table.inc

来自「linux下安装不上mysql5与php5的可用此关联」· INC 代码 · 共 21 行

<?PHP
if (!$link = 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, 'CREATE TABLE test(id INT, 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));        
}
?>