', "\n";
echo "Error: $msg \n";
echo '', "\n";
exit;
}
function note ($msg)
{
echo '', "\n";
echo "Note: $msg \n";
echo '
', "\n";
}
/* quote string */
function sql_str ($value)
{
return "'" . MySQL_Escape_String ($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 */
$connection = MySQL_Connect ($db_host, $db_user, $db_password) or Err (MySQL_Error());
MySQL_Select_Db($database) or Err (MySQL_Error());
/* actions */
$fce = param ("fce");
if ($fce == "" or $fce == "list")
{
$cmd = "
CREATE TABLE colors
(
name varchar(80) not null,
red int,
green int,
blue int
)
";
MySQL_Query ($cmd) or Note (MySQL_Error());
$cmd = "
INSERT INTO colors VALUES
('blede modra', 128, 128, 255)
";
MySQL_Query ($cmd) or Err (MySQL_Error());
$cmd = "SELECT * FROM colors";
$results = MySQL_Query ($cmd) or Err (MySQL_Error());
?>
| Name |
Red |
Blue |
Green |
Preview |
Edit |
";
for ($k = 0; $k < 4; $k++)
{
$value = $data [$k];
echo " $value | ";
}
$code = $data['red'].','.$data['green'].','.$data['blue'];
echo " | ";
echo " edit | ";
echo " ";
}
?>
Edit one record
" . $name . ", " . $red . ", " . $blue . ", " . $green;
$cmd = 'UPDATE colors ' .
' SET name = ' . sql_str ($name) . "," .
' red = ' . sql_str ($red) . "," .
' blue = ' . sql_str ($blue) . "," .
' green = ' . sql_str ($green) .
' WHERE name = ' . sql_str ($id);
$results = MySQL_Query ($cmd) or Err (MySQL_Error());
?>
continue