Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function getQuery($database) {
- $dateTime = date('Y-m-d [H:i:s]');
- for ($i = 1; $i <= 10; $i++) {
- $name = "tov" . $i;
- if ($_GET[$name]) {
- $count = $_GET[$name];
- $query = "INSERT INTO things (name, count, date) VALUES ({$i}, {$count}, '{$dateTime}')";
- mysqli_query($database, $query);
- }
- }
- }
- function returnCountForClient($database) {
- $result = "";
- $query = "SELECT name, SUM(count) FROM things GROUP BY name ASC";
- $data = mysqli_fetch_all(
- mysqli_query($database, $query),
- MYSQLI_ASSOC
- );
- for ($i= 0; $ < 10; $i++) {
- $count = $data[$i]['count'];
- $result .= $count;
- if ($i != 9)
- $result .= "~";
- }
- echo $result;
- }
- function runMySql() {
- $database = mysqli_connect(
- "localhost", "root",
- "", "db_name"
- );
- if (mysqli_connect_errno()) {
- echo "Не подключено!", mysqli_connect_errno(), ": ", mysqli_connect_error();
- exit();
- }
- getQuery($database);
- returnCountForCLient($database);
- mysqli_close($database);
- }
- if ($_GET) {
- $has = false;
- for ($i = 0; $i < 10; $i++)
- if ($_GET["tov" . $i]) {
- $has = true;
- break;
- }
- if ($has) {
- runMySql();
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement