Advertisement
far_light

Connect with database

Mar 3rd, 2018
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.67 KB | None | 0 0
  1. <?php
  2. function getQuery($database) {
  3. $dateTime = date('Y-m-d [H:i:s]');
  4.  
  5. for ($i = 1; $i <= 10; $i++) {
  6. $name = "tov" . $i;
  7.  
  8. if ($_GET[$name]) {
  9. $count = $_GET[$name];
  10. $query = "INSERT INTO things (name, count, date) VALUES ({$i}, {$count}, '{$dateTime}')";
  11. mysqli_query($database, $query);
  12. }
  13. }
  14. }
  15.  
  16. function returnCountForClient($database) {
  17. $result = "";
  18. $query = "SELECT name, SUM(count) FROM things GROUP BY name ASC";
  19.  
  20. $data = mysqli_fetch_all(
  21. mysqli_query($database, $query),
  22. MYSQLI_ASSOC
  23. );
  24.  
  25. for ($i= 0; $ < 10; $i++) {
  26. $count = $data[$i]['count'];
  27. $result .= $count;
  28.  
  29. if ($i != 9)
  30. $result .= "~";
  31. }
  32.  
  33. echo $result;
  34. }
  35.  
  36. function runMySql() {
  37. $database = mysqli_connect(
  38. "localhost", "root",
  39. "", "db_name"
  40. );
  41.  
  42. if (mysqli_connect_errno()) {
  43. echo "Не подключено!", mysqli_connect_errno(), ": ", mysqli_connect_error();
  44. exit();
  45. }
  46.  
  47. getQuery($database);
  48. returnCountForCLient($database);
  49. mysqli_close($database);
  50. }
  51.  
  52. if ($_GET) {
  53. $has = false;
  54.  
  55. for ($i = 0; $i < 10; $i++)
  56. if ($_GET["tov" . $i]) {
  57. $has = true;
  58. break;
  59. }
  60.  
  61. if ($has) {
  62. runMySql();
  63. }
  64. }
  65. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement