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

[manishnankar]

Hi All,
Can anyone please help me here?

I created one php file. My code is :

<?php

$conn  = mysql_connect("localhost","manish","manish","my_db");
if (empty($conn))
{
 die("mysql_connect failed ". mysql_connect_error());
}
print "connected to ". mysql_get_host_info($conn);

$result = $conn->query("SELECT id from test_manish",mysql_use_result);

while($row = $result->fetch_row())
{
  Print $row[0]. "<br\n>";
}
$result->free();


mysql_close($conn);

?>

I am receiving below error :

connected to localhost via TCP/IP
Fatal error: Call to a member function query() on a non-object in C:\webroot\database1.php on line 10

..

Please let me know what is wrong with this code?

[Derokorian]

mysql_connect is procedural, not OOP so $conn is NOT an object but rather a resource.

If you want to use the OOP approach you need to use mysqli firstly and secondly you need to instantiate it the OOP way.

//psuedo code
$conn = new mysqli("localhost","manish","manish","my_db");
$res = $conn->query("SELECT 1 FROM test_manish");

OR to continue using mysql (not recommended, you should use mysqli or PDO):

$conn = mysql_connect("localhost","manish","manish","my_db");
$res = mysql_query("SELECT 1 FROM test_manish",$conn);

[manishnankar]

Hi Derokorian

It worked .Thanks for ur quick reply.

i used second option to connect to mysql.

[manishnankar]

Hi Friend ,
i need one more help here.

i modified below code:

<?php

$conn = mysql_connect("localhost","manish","manish","my_db");
if (!$conn)
{
die("mysql_connect failed ". mysql_error());
}
print "connected to ". mysql_get_host_info($conn). "<br />";

$qry = "SELECT id from test_manish where id = 1";

$result = mysql_query($qry,$conn);

if (!$result)
{
echo "could not run :" . mysql_error();
exit;
}

$row = mysql_fetch_row($result);

mysql_close($conn);

?>

when i run this it gives me below error message :

connected to localhost via TCP/IP
could not run :No database selected

can u please help me?

//Manish n

[Derokorian]

Look at the page for mysql_connect again, the 4th param is a bool representing if its a new link or not. You need to use mysql_select_db to select the db to use.

$conn = mysql_connect("localhost","manish","manish");
if (!$conn)
{
die("mysql_connect failed ". mysql_error());
}
print "connected to ". mysql_get_host_info($conn). "<br />";

// Select database
mysql_select_db("my_db",$conn);

$qry = "SELECT id from test_manish where id = 1";

[manishnankar]

Thanks..

This is solved.

[manishnankar]

actully the problem was, user manish did not have access to table test_manish.

so i grant access to table. and hence the problem resolved.