PHP: Hypertext Preprocessor (original) (raw)

`<?php
/* Open a connection /
$link = mysqli_connect("localhost", "my_user", "my_password", "world");/ check connection /
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}mysqli_query($link, "CREATE TABLE myCountry LIKE Country");
mysqli_query($link, "INSERT INTO myCountry SELECT * FROM Country");$query = "SELECT Name, Code FROM myCountry ORDER BY Name";
if ($stmt = mysqli_prepare($link, $query)) {/ drop table /
mysqli_query($link, "DROP TABLE myCountry");/ execute query */
mysqli_stmt_execute($stmt);

echo

"Error:\n";
print_r(mysql_stmt_error_list($stmt));/* close statement /
mysqli_stmt_close($stmt);
}/ close connection */
mysqli_close($link);
?>`

Error: Array ( [0] => Array ( [errno] => 1146 [sqlstate] => 42S02 [error] => Table 'world.myCountry' doesn't exist )

)