";
echo "b = $b
";
echo "submit = $submit
";
// Connect to the MySQL server
$db = mysql_connect("mysql2.stern.nyu.edu:3306", "mjohnson", "password");
// Open our DB
mysql_select_db("test", $db);
if ($submit == "Insert") {
$query = "INSERT INTO mytab VALUES('$a', '$b');";
} else {
if ($submit == "Delete") {
$query = "DELETE FROM mytab WHERE a='$a' AND b='$b'";
} else
$query = "";
}
print "query = $query
";
if ($a and $b) {
# Run the update
mysql_query($query, $db);
}
// Display the query for debug
$query = "SELECT * FROM mytab";
echo "query = $query
\n";
// Run the query
$result = mysql_query($query,$db);
// Print the table header
echo "\n";
echo "| a | b |
\n";
// Print the data in our table
while ($row = mysql_fetch_assoc($result))
echo "| " . $row["a"] . " | " . $row["b"] .
" |
\n";
// print table footer
echo "
\n";
mysql_close($db);
?>