<html>
<head>
<title> DB Example </title>
<style type="text/css">
table, td, th {
background-color: #eaf2ff;
padding: 2px 15px 2px 15px;
border-collapse:collapse;
}
th {
background-color: #95B8E7;
}
.error {
margin: 0.5em auto 0.5em auto;
padding: 15px 10px 15px 55px;
width: 450px;
color: #ff0000;
background: #fff0f0;
border: 1px solid #ffcccc;
}
.note {
margin: 0.5em auto 0.5em auto;
padding: 15px 10px 15px 55px;
width: 450px;
background: #fffddf;
border: 1px solid #ffcc00;
}
</style>
</head>
<body>
<?php
// phpinfo();
/******************************* FUNCTIONS ********************************/
function err ($msg)
{
echo '<div class="error">', "\n";
echo "Error: $msg \n";
echo '</div>', "\n";
exit;
}
function note ($msg)
{
echo '<div class="note">', "\n";
echo "Note: $msg \n";
echo '</div>', "\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, '<br>', "\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 */
?>
<a href="?fce=list"> list </a>
<a href="?fce=abc"> abc </a>
<br>
<?php
$fce = param ("fce");
if ($fce == "" or $fce == "list")
{
$cmd = "SELECT * FROM colors";
$results = MySQL_Query ($cmd) or Err (MySQL_Error());
echo "<table border=1>";
while ($data = MySQL_Fetch_Array ($results))
{
echo "<tr> ";
for ($k = 0; $k < 4; $k++)
{
$value = $data [$k];
echo "<td> $value </td>";
}
$id = $data['name'];
echo "<td> <a href='?fce=edit&id=$id'> edit </a> </td>";
echo "</tr> ";
}
echo "</table> ";
}
if ($fce == "edit")
{
$id = param ("id");
echo "Edit $id";
?>
<h4> Edit one record </h4>
<form>
Name: <input type="text" name="name" >
<br>
Red: <input type="text" name="red" >
<br>
Blue: <input type="text" name="blue" >
<br>
Green: <input type="text" name="green" >
<br>
</form>
<?php
}
?>