<?php
mysql_connect("host","user","pass") or die(mysql_error());
mysql_select_db("db") or die(mysql_error());
$ip = $_SERVER['REMOTE_ADDR'];
$a = mysql_query("SELECT * FROM bg WHERE ip='$ip'") or die(mysql_error());
$b = mysql_num_rows($a);
if ($b > 0)
{
$c = mysql_fetch_array($a);
$bg = $c['color'];
echo "<body style='background-color: $color ;'><br>";
echo "<form method='POST'> <input type='text' name='color'> <input type='submit' name='submit' value='Change background'></form>";
if (isset($_POST['submit']))
{
$color = htmlspecialchars($_POST['color']);
mysql_query("UPDATE bg SET color='$color' WHERE ip='$ip'") or die(mysql_error());
echo "GOTOVO";
}
}
else
{
echo "<form method='POST'> <input type='text' name='color'> <input type='submit' name='submit' value='Change background'></form>";
if (isset($_POST['submit']))
{
$color = htmlspecialchars($_POST['color']);
mysql_query("INSERT INTO bg (ip,color) VALUES ('$ip','$color')") or die(mysql_error());
echo "GOTOVO";
}
}
?>
