我需要修复什么来获得工作排行榜？ [关闭]

I am following a tutorial (here) and it has outdated php and my google searches haven't helped me so i'd like to know how can i get this working?

It shows up with a 500 page isnt working (is currently unable to handle this request.)

Edit. I forgot to add my code so.

<?php
header('Access-Control-Allow-Origin: *');




$host="localhost"; // Host name 
$username="username"; // Mysql username 
$password="password"; // Mysql password 
$db_name="name"; // Database name 
$tbl_name="scores"; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

// Retrieve data from database 
$sql="SELECT * FROM scores ORDER BY score DESC LIMIT 10";
$result=mysql_query($sql);

// Start looping rows in mysql database.
while($rows=mysql_fetch_array($result)){
echo $rows['name'] . "|" . $rows['score'] . "|";

// close while loop 
}

// close MySQL connection 
mysql_close();
?>

How do I also fix this code?

 $dblink = mysql_connect($host,$dbu,$dbp);
$seldb = mysql_select_db($db);

if(isset($_GET['name']) && isset($_GET['score'])){

     //Lightly sanitize the GET's to prevent SQL injections and possible XSS attacks
     $name = strip_tags(mysql_real_escape_string($_GET['name']));
     $score = strip_tags(mysql_real_escape_string($_GET['score']));
     $sql = mysql_query("INSERT INTO `$db`.`scores` (`id`,`name`,`score`) VALUES ('','$name','$score');");

     if($sql){

          //The query returned true - now do whatever you like here.
          echo 'Your score was saved. Congrats!';

     }else{

          //The query returned false - you might want to put some sort of error reporting here. Even logging the error to a text file is fine.
          echo 'There was a problem saving your score. Please try again later.';

     }

}else{
     echo 'Your name or score wasnt passed in the request. Make sure you add ?name=NAME_HERE&score=1337 to the tags.';
}

mysql_close($dblink);//Close off the MySQL connection to save resources.

Here is example using mysqli

$host="localhost"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="name"; // Database name
$tbl_name="scores"; // Table name

// Connect to server and select database.
$conn= new mysqli($host, $username, $password, $db_name);

// Retrieve data from database
$sql="SELECT * FROM scores ORDER BY score DESC LIMIT 10";
$result=$conn->query($sql);


$data = [];
// Start looping rows in mysql database.
while($rows = mysqli_fetch_assoc($result)){

    $data[] = $rows;

// close while loop
}

foreach ($data as $row){

    echo $row['name'] . "|" . $row['score'] . "|";


}

// close MySQL connection
mysqli_close($conn);