Fatal error: Call to a member function query() on a non-object in

phpeasyrider

Who knows whats wrong and how to fix it?

Fatal error: Call to a member function query() on a non-object in ***\mysqli_01.php on line 8

mysqli_01.php:

<?php
require_once('../includes/connection.inc.php');
// connect to MySQL
$conn = dbConnect('read');
// prepare the SQL query
$sql = 'SELECT * FROM images';
// submit the query and capture the result
$result = $conn->query($sql) or die(mysqli_error());
// find out how many records were retrieved
$numRows = $result->num_rows;
?>
<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8">
<title>Connecting with MySQLi</title>
</head>

<body>
<p>A total of <?php echo $numRows; ?> records were found.</p>
</body>
</html>

connection.inc.php:

<?php
function dbConnect($usertype, $connectionType = 'mysqli') {
  $host = 'localhost';
  $db = 'phpsols';
  if ($usertype  == 'read') {
	$user = 'user1';
	$pwd = 'pass1';
  } elseif ($usertype == 'write') {
	$user = 'user2';
	$pwd = 'pass2';
  } else {
	exit('Unrecognized connection type');
  }
  if ($connectionType == 'mysqli') {
	return new mysqli($host, $user, $pwd, $db) or die ('Cannot open database');
  } else {
    try {
      return new PDO("mysql:host=$host;dbname=$db", $user, $pwd);
    } catch (PDOException $e) {
      echo 'Cannot connect to database';
      exit;
    }
  }
}

bradgrafelman

Since PHP claims that $conn is a non-object type, have you tried using something like [man]var_dump/man to determine what type it actually is? If so, what is the output?

builtforthekill

please try this code for connection.inc.php...

<?php 
function dbConnect($usertype, $connectionType = 'mysqli') { 
  $host = 'localhost'; 
  $db = 'phpsols'; 
  if ($usertype  == 'read') { 
    $user = 'user1'; 
    $pwd = 'pass1'; 
  } elseif ($usertype == 'write') { 
    $user = 'user2'; 
    $pwd = 'pass2'; 
  } else { 
    exit('Unrecognized connection type'); 
  } 
  if ($connectionType == 'mysqli') { 
    $conn =  new mysqli($host, $user, $pwd, $db) or die ('Cannot open database');
    return $conn; 
  } else { 
    try { 
      $conn = new PDO("mysql:host=$host;dbname=$db", $user, $pwd); 
      return $conn;
    } catch (PDOException $e) { 
      echo 'Cannot connect to database'; 
      exit; 
    } 
  } 
}

grejen

This is exactly what I needed (someone else is using the same book I have). Thanks for clearing up the error.