I can connect but when it comes to the prepared statement
that is the error i got. anything wrong
there?
Code:
// Open connection
$db = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
//check connection
if (mysqli_connect_errno()) {
printf("Connect
failed: %s\n", mysqli_connect_error());
exit();
}
// Create statement object
$stmt =
$db->stmt_init();
// sql statement
$sql = "INSERT
INTO ch_users ('uid','admin','password','directory','size','format','locationid') VALUES
(?, 1, ?, ?, ?, ?, 1)";
// Create a prepared statement
$stmt = $db->prepare($sql) or
die($db->error());
No comments:
Post a Comment