Mike Mike - 1 month ago 10
MySQL Question

mysqli_error() expects exactly 1 parameter, 0 given

I am trying to get my head around mysql. Can someone tell my why this mysql query is not working? I am getting the following error:


Warning: mysqli_error() expects
exactly 1 parameter, 0 given in
/home/freebet2/public_html/test.php on
line 11


test.php

<?php
require_once($_SERVER['DOCUMENT_ROOT'].'/includes/db.php');
$conn = db_connect();
$result = $conn->query("ALTER TABLE users ADD COLUMN refer_old INT(10) AFTER refer_id");

if(!$result){
echo "Error with MySQL Query: ".mysqli_error();
}
?>


db.php

<?php

function db_connect() {
$result = new mysqli('localhost', 'user', 'password', 'db');
if (!$result) {
throw new Exception('Could not connect to database server');
} else {
return $result;
}
}

?>


If I change the alter string to something like :
$result = $conn->query("SELECT * FROM users refer_id");
I get no error for some reason.

Answer

As far as the sql error is concerned, does 'user' have permissions to alter the table?

Comments