Code: Select all
<html>
<body bgcolor="f6fff6">
<font face="Verdana" style="font-size: 12px; font-color: #11ff11">
<?php
$con = mysql_connect("localhost", "root", "");
$db = mysql_select_db("test");
if(isset($_POSTї'name']) && isset($_POSTї'favcolor']))
{
if(isset($_POSTї'name'])) $name_ = $_POSTї'name'];
if(isset($_POSTї'favcolor'])) $favcolor_ = $_POSTї'favcolor'];
$sql = "SELECT * FROM test WHERE name = ".$_POSTї'name'];
$result = mysql_query("$sql");
if(!($row = mysql_fetch_array($result))) {
$sql = "INSERT INTO test (name, favcolor) VALUES ('".$name_."', '".$favcolor_."')";
$result = mysql_query("$sql");
}
}
echo "<table bgcolor='eeffee' width='400' border='1'><tr><td><b>Name</b></td><td><b>Favorite color</b></td></tr>";
$sql = "SELECT * FROM test ORDER BY name";
$result = mysql_query("$sql");
while($row = mysql_fetch_array($result)) {
echo "<tr><td>".$rowї'name']."</td><td>".$rowї'favcolor']."</td></tr>";
}
mysql_close($con);
?>
</table>
<br><br><br><br>
<form method="POST" action="mysql.php">
Name: <input type="text" name="name"><br>
Favorite color: <input type="text" name="favcolor"><br>
<input type="submit" value="Submit">
</form>
</font>
</body>
</html>