Scratch

Magnie wrote:

Official One by JD1

My "revised" version:

Code:

<title>Scratch-Live <?php 
$title = 'Variables';
echo($title);?></title>

<?php 

$SQLhost     = "127.0.0.1";
$SQLuser     = "root";
$SQLpass     = "";
$SQLdatabase = "test";
$SQLtable    = "scratchlive";

$con = mysql_connect($SQLhost,$SQLuser,$SQLpass);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
echo "Database Connected";
echo "<br />";

if ( isset($_GET['user']) ) { $user  = $_GET["user"]; } else { $user = ""; }
if ( isset($_GET['pass']) ) { $pass  = $_GET["pass"]; } else { $pass = ""; }
if ( isset($_GET['value']) ) { $value  = $_GET["value"]; } else { $value = ""; }

echo $user;
echo "<br />";
echo $pass;
echo "<br />";
echo $value;
echo "<br />";

if ($pass == 1) {
    $val = strlen($value);
    if ($val > 0) {
        echo "Acting on request";
        $act = "set";
    } else {
        echo "Getting request";
        $act = "get";
    }
echo "<br />";


//**************************
//******DATABASE STUFF******
//**************************

mysql_select_db($SQLdatabase, $con);

if(1==0)
    {
        $sql = "CREATE TABLE" . $SQLtable. "
                    (
                    Username varchar(20),
                    Value varchar(20),
                    )";
        mysql_query($sql,$con);
        echo "<br />";
        echo "Table made";
        echo "<br />";
            
    }

$result = mysql_query("SELECT * FROM ".$SQLtable." WHERE Username='$user'");
$row = mysql_fetch_array($result);
if ( $row['Username'] != "" ) { $get = $row['Value']; }
else { $get = ""; }

if ($get == "") {
    $query = "INSERT INTO ".$SQLtable." (Username, Value) VALUES ('$user', '$value')";
    mysql_query($query);
}
echo "<br />";
echo "\n";
if ($act == "get") {
    echo $get;
}

if ($act == "set") {
    $query = "UPDATE ".$SQLtable." SET Value = '".$value."' WHERE Username = '".$user."'";
    mysql_query($query);
    echo "Updated";
}

}

mysql_close($con);
?>

ok thanks i will try it 

i know why it won't work now... i forgot to insert the coloumns in the database lol