', "\n";
echo "Error: $msg \n";
echo '', "\n";
exit;
}
function note ($msg)
{
echo '', "\n";
echo "Note: $msg \n";
echo '
', "\n";
}
/* quote string */
function sql_str ($connection, $value)
{
return "'" . $connection->quote ($value) . "'";
}
function html_str ($value)
{
return htmlspecialchars ($value);
}
/* parameters and session variables */
function param ($param_name)
{
if (isset ($_POST[$param_name]))
{
$value = $_POST[$param_name];
}
else if (isset ($_GET[$param_name]))
{
$value = $_GET[$param_name];
}
else
{
$value = "";
}
// echo "$param_name: ", $value, '
', "\n";
return trim ($value);
}
function recall_variable ($session_name)
{
$value = "";
if (isset ($_SESSION[$session_name]))
$value = $_SESSION[$session_name];
// echo "$session_name: ", $value, '
', "\n";
return $value;
}
function set_variable ($session_name, $value)
{
$_SESSION[$session_name] = $value;
return $value;
}
/********************************* START **********************************/
/* database parameters */
$db_host = "localhost";
$db_user = "uzivatel";
$db_password = "heslo";
$database = "mydb";
/* database connection */
try
{
$connection = new PDO ("mysql:host=$db_host;dbname=$database", $db_user, $db_password);
}
catch(PDOException $e)
{
Err ($e->getMessage());
}
/* actions */
$fce = param ("fce");
if ($fce == "create")
{
$cmd = "
CREATE TABLE colors
(
name VARCHAR(80) NOT NULL PRIMARY KEY,
red INT,
green INT,
blue INT
)
";
try
{
$connection->query ($cmd);
}
catch(PDOException $e)
{
Err ($e->getMessage());
}
}
if ($fce == "drop")
{
$cmd = "DROP TABLE colors";
try
{
$connection->query ($cmd);
}
catch(PDOException $e)
{
Err ($e->getMessage());
}
}
if ($fce == "insert")
{
$cmd = "
INSERT INTO colors VALUES
('blede modra', 128, 128, 255)
";
$connection->query ($cmd);
$fce = "list"; /* and show table */
}
if ($fce == "" or $fce == "list")
{
$cmd = "SELECT * FROM colors";
$results = $connection->query ($cmd);
?>
| Name |
Red |
Green |
Blue |
Preview |
Edit |
fetch ())
{
echo " ";
for ($k = 0; $k < 4; $k++)
{
$value = $data [$k];
echo "| $value | ";
}
$code = $data['red'].','.$data['green'].','.$data['blue'];
echo " | ";
echo " edit | ";
echo "
";
}
?>
query ($cmd);
$data = $results->fetch ()
?>
Edit one record
" . $name . ", " . $red . ", " . $blue . ", " . $green;
$cmd = 'UPDATE colors ' .
' SET name = ' . sql_str ($connection, $name) . "," .
' red = ' . sql_str ($connection, $red) . "," .
' green = ' . sql_str ($connection, $green) . "," .
' blue = ' . sql_str ($connection, $blue) .
' WHERE name = ' . sql_str ($connection, $id);
$results = $connection->query ($cmd);
?>
continue