Hi folks
I'm a bit new and I've sort of hit a brick with what I'm doing now. Looked at W3S, PhP.net etc but I can't quite relate it to what I'm trying to do. Here's some old code.
PHP Code:
function getResult($sql) {
$result = mysql_query($sql, $this->conn);
if ($result) {
return $result;
} else {
die("SQL Retrieve Error: " . mysql_error());
}
}
Now, this is my MySqli attempt:
function getResult($sql){;
$result = mysqli_query($this->conn ,"$sql" ); //line93
if ($result) {
return $result;
} else {
die("SQL Retrieve Error: " . mysqli_error($sql));//97
}
}
The error I am getting is the null one.
Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\1\func.php on line 93
Warning: mysqli_error() expects parameter 1 to be mysqli, string given in C:\xampp\htdocs\1\func.php on line 97
SQL Retrieve Error:
Now, the web page that calls up this function uses the this code. I think it's OK though.
$db1 = new dbmember();
$db1->openDB();
$sql="SELECT * from member";
$result=$db1->getResult($sql);
echo "<table border='1'>";
echo "<tr><th>Member ID</th><th>Name</th><th>Address</th><th>Postcode</th><th>Photo</th></tr>";
while($row = mysqli_fetch_assoc($result))
Any help on what's going on would be fantastic - I have been pouring over this code for hours and it feels like I'm hitting my head against a wall.
Edited 1 time(s). Last edit at 07/08/2013 02:53PM by Boluchamid Laacashadola.