', "\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);
}
/* 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 */
?>
list
abc
";
while ($data = MySQL_Fetch_Array ($results))
{
echo " ";
for ($k = 0; $k < 4; $k++)
{
$value = $data [$k];
echo "| $value | ";
}
$id = $data['name'];
echo " edit | ";
echo "
";
}
echo " ";
}
if ($fce == "edit")
{
$id = param ("id");
echo "Edit $id";
?>
Edit one record