Installere highscore i MySQL Admin

[ntec]

hvordan installerer jeg de nødvendige table'ne for denne php-skripten?

 

highscore.php

<?php
if (!isset($act)){ 
$act="1"; 
} 

if ($act == "2"){ 
include('sql_setup.php'); 
$db = mysql_connect($sql_host,$sql_user,$sql_pass); 
mysql_select_db('highscore',$db); 
$sql = "INSERT INTO scores (name, score) VALUES ('$name', '$score')"; 
mysql_query($sql, $db); 
mysql_close($db); 
header("Location:view_highscore.php"); 
}else{ 
echo 'Add Score<br><form action="highscore.php" method="POST"><input type=hidden name="act" value="2">Name: <input type=text name="name"><br>Score: <input type=text name="score"><br><input type=submit value="add"></form>'; 
} 
?>

 

sql_setup.php

<?php 
$host = "host";
$brukernavn = "brukernavn"; 
$passord = "passord";
$database = "database";
?>

 

view_highscore.php

<?php 
include('sql_setup.php'); 
$db = mysql_connect($sql_host,$sql_user,$sql_pass); 
mysql_select_db('highscore',$db); 
$sql = 'SELECT * FROM `scores` ORDER BY `score` ASC LIMIT 0, 30'; 
$result = mysql_query($sql, $db) or die(mysql_error()); 
echo 'High-Score List:<br>'; 
while ($row = mysql_fetch_row($result)){ 
echo $row[0].': '.$row[1].'<br>'; 
} 
mysql_close($db); 
?>

Endret 15. november 2005 av ntec