· 9 years ago · Feb 10, 2017, 05:24 PM
1<?php
2$dbhost='localhost';
3$dbuser='root';
4$dbpass='';
5$dbname='task';
6$connection = new mysqli($dbhost, $dbuser, $dbpass,$dbname );
7if ($connection->connect_error) die($connection->connect_error);
8function createTable($name, $query)
9{
10 queryMysql("CREATE TABLE IF NOT EXISTS $name($query)");
11 echo "Table '$name' create or already existed<br>";
12}
13
14
15
16function queryMysql($query)
17{
18 global $connection;
19 $result = $connection->query($query);
20 if (!$result) die($connection->error);
21 return $result;
22}
23
24
25function destroySession()
26{
27 $_SESSION = array();
28 if (session_id() != "" || isset($_COOKIE[session_name()])) {
29 setcookie(session_name(), '', time() - 2592000, '/');
30 session_destroy();
31 }
32}
33function sanitizeString($var)
34{
35 global $connection;
36 $var = strip_tags($var);
37 $var = htmlentities($var);
38 $var = stripslashes($var);
39 return $connection->real_escape_string($var);
40}
41
42
43
44
45?>