Advertisement
Guest User

Untitled

a guest
Jan 29th, 2019
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.31 KB | None | 0 0
  1. <?php
  2. $u_name = '';
  3.  if (isset($_POST['u_name']))  $u_name = mysql_real_escape_string(strip_tags(trim($_POST['u_name'])));
  4. $u_score = 0;
  5. if (isset($_POST['u_score'])) $u_score = intval(strip_tags(trim($_POST['u_score'])));
  6.  
  7.  
  8. $host = "localhost";
  9. $user = "root";
  10. $password = "";
  11. $db = 'my_db';
  12.  
  13. $con = mysqli_connect($host, $user, $password, $db);
  14. if (mysqli_connect_errno()) {
  15.     printf("Не удалось подключиться: %s\n", mysqli_connect_error());
  16.     exit();
  17. }
  18.  
  19. try {
  20.     if(!mysqli_query($con, 'insert into `sc` (`name`, `score`) values ("'.$u_name.'", "'.$u_score.'")')){
  21.         printf("Ошибка: %s\n", mysqli_error($con));
  22.     } else {
  23.         echo('ok');
  24.     }
  25. } catch (Exception $e) {
  26.     die('Не удалось');
  27. }
  28.  
  29. /*
  30. $result = mysqli_query($con, "SELECT * FROM `sc` order by `score` desc limit 10");
  31.  
  32.  
  33. if($result)
  34. {
  35.     $rows = mysqli_num_rows($result); // количество полученных строк
  36.    
  37.     echo "<table border=\"1\"><tr><th></th><th>Имя</th><th>Счет</th></tr>";
  38.     for ($i = 0 ; $i < $rows ; ++$i)
  39.     {
  40.         $row = mysqli_fetch_row($result);
  41.         echo "<tr>";
  42.             for ($j = 0 ; $j < 3 ; ++$j) echo "<td>$row[$j]</td>";
  43.         echo "</tr>";
  44.     }
  45.     echo "</table>";
  46.    
  47.     // очищаем результат
  48.     mysqli_free_result($result);
  49. }
  50. */
  51.  
  52. mysqli_close($con);
  53. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement