Guest User

Untitled

a guest
May 26th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.75 KB | None | 0 0
  1. <?php
  2. $dbhost = "localhost";
  3. $dbuser = "Логин";
  4. $dbpassword = 'Пароль';
  5. $dbname = "vladiksan1998";
  6.  
  7. $sname = $_POST['sname'];
  8. $fname = $_POST['fname'];
  9. $score = $_POST['score'];
  10.  
  11. $link = mysql_connect($dbhost, $dbuser, $dbpassword);
  12. if (false === $link)
  13. die ('Error database connect');
  14. $select_result = mysql_select_db($dbname, $link);
  15. if (false === $select_result)
  16. die ('Error database select<');
  17. $query = "INSERT INTO records VALUES('$fname','$sname','$score')";
  18. $query_result = mysql_query($query, $link);
  19. if (false === $query_result)
  20. die ('Error database SQL query');
  21. $close_result = mysql_close($link);
  22. if (false === $close_result)
  23. die ('Error database close');
  24. ?>
  25.  
  26. <?php
  27. $link = mysql_connect('localhost', 'login', 'pass')
  28. or die('Не удалось соединиться: ' . mysql_error());
  29. mysql_select_db('vladiksan1998') or die('Не удалось выбрать базу данных');
  30.  
  31. $query = 'SELECT fname, sname, score FROM records';
  32. $result = mysql_query($query) or die('Запрос не удался: ' . mysql_error());
  33.  
  34. echo "<table>n";
  35. while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
  36. if($line['score'] != 0){
  37. echo "t<tr>n";
  38. echo "tt<td>" . $line['fname'] . "</td>n";
  39. echo "tt<td>" . $line['sname'] . "</td>n";
  40. echo "tt<td>" . $line['score'] . "</td>n";
  41. echo "t</tr>n";
  42. }
  43. }
  44. echo "</table>n";
  45. mysql_free_result($result);
  46. mysql_close($link);
  47. ?>
  48.  
  49. $query = "INSERT INTO records VALUES('$fname','$sname','$score')";
  50. $query_result = mysql_query($query, $link);
  51.  
  52. if($score != 0)
  53. {
  54. $query = "INSERT INTO records VALUES('$fname','$sname','$score')";
  55. $query_result = mysql_query($query, $link);
  56. }
  57.  
  58. $query = 'SELECT fname , sname , score FROM records WHERE score != 0';
Add Comment
Please, Sign In to add comment