File: table.inc

package info (click to toggle)
php7.0 7.0.33-0%2Bdeb9u8
  • links: PTS, VCS
  • area: main
  • in suites: stretch
  • size: 184,180 kB
  • sloc: ansic: 809,195; php: 22,035; sh: 11,873; cpp: 8,064; xml: 6,228; javascript: 2,546; yacc: 1,869; exp: 1,514; makefile: 1,231; pascal: 1,200; awk: 501; perl: 315; sql: 22
file content (28 lines) | stat: -rw-r--r-- 1,021 bytes parent folder | download | duplicates (4)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
<?PHP
require_once('connect.inc');

if (!$link = my_mysqli_connect($host, $user, $passwd, $db, $port, $socket)) {
	printf("Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n",
		$host, $user, $db, $port, $socket);
	exit(1);
}

if (!mysqli_query($link, 'DROP TABLE IF EXISTS test')) {
	printf("Failed to drop old test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
	exit(1);
}

if (!mysqli_query($link, 'SET SESSION sql_mode=\'\'')) {
	printf("Failed to drop old test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
	exit(1);
}

if (!mysqli_query($link, 'CREATE TABLE test(id INT DEFAULT 0, label CHAR(1), PRIMARY KEY(id)) ENGINE=' . $engine)) {
	printf("Failed to create test table: [%d] %s\n", mysqli_errno($link), mysqli_error($link));
	exit(1);
}

if (!mysqli_query($link, "INSERT INTO test(id, label) VALUES (1, 'a'), (2, 'b'), (3, 'c'), (4, 'd'), (5, 'e'), (6, 'f')")) {
	printf("[%d] %s\n",  mysqli_errno($link), mysqli_error($link));
}
?>