4SxNjH3E

1class indexFunctions
2    {
3        public function createFunc()
4        {
5            $conn = mysqli_connect("localhost", "m026976f", "m026976f", "m026976f")or die("Not connected.");
6            if (mysqli_connect_errno())
7            {
8                echo "Failed to connect to MySQL: " . mysqli_connect_error();
9                //you need to exit the script, if there is an error
10            }
11            else
12            {
13                echo "Create connection ok!: ";
14            }
15            $table = 'CREATE TABLE IF NOT EXISTS `cricketers`('.
16                '`id` int(11) NOT NULL AUTO_INCREMENT,'.
17                '`surname` varchar(50) NOT NULL,'.
18                '`firstname` varchar(50) NOT NULL,'.
19                '`club` varchar(50) NOT NULL,'.
20                '`role` varchar(50) NOT NULL,'.
21                'PRIMARY KEY (`id`));';
22            mysqli_query($conn, $table);
23            $conn->close();
24        }
25}