Require and undefined member functions

[klatt]

Basically I want to have a file that can be called with a function to connect to my database. I am using MySQL 4 and PHP 5

here is my connect.php file:

<?php
function connect()
{
$db = new mysqli('localhost', 'mcneil', 'noway', 'it');
if (!$db)
throw new Exception('Could not connect to the database');
else
return $result;
}
?>

and i have been including this file and also trying "require_once"

the function is being called like so:

$db_conn = connect();

Finally, this line:

$result = $db_conn->query($query);

or any referring to the database gets the error:

Fatal error: Call to a member function query() on a non-object in C:\klatt.... etc etc

I cant figure this out for the life of me....

TIA,
Frank

[Kudose]

$result = $db_conn->mysql_query($query);

[klatt]

that gives me the same error but now with mysql_query

mysql_query is the old procedural way of doing it

using $db->query is the OO way of doing it...

either way doesnt work when i include it

[Kudose]

My bad...

Shouldnt you be calling

$db_conn = connect();

as

$db_conn = new connect();

to establish it as an object, one you convert your function into a class?

[klatt]

Hmm, I dont think so....

I have a friend that uses the old mysql_connect like this and I have an example in a book that works exactly like this. That is actually where most of the connect scrip comes from....

[Kudose]

Let me look into my big bad PHP5 book. 😉

[Kudose]

This is what I gather...

<?php
class Connection {
function connect()
{
$db = new mysqli('localhost', 'mcneil', 'noway', 'it');
if (!$db)
throw new Exception('Could not connect to the database');
else
return $result;
}
}

$db_conn = new Connection;
$db_conn -> connect();

$query = "MySQL Stuff...";

$result = $db_conn->query($query);
?>

Could be off though...haven't tried it.

[klatt]

that gives me:

Fatal error: Call to undefined method Connection::query() in C:\klat.....

:-/ even that seems too complicated though, I dont understand why what I had originally wont work.

BTW thanks for being the only one to reply so far Kudose!

[Kudose]

No problem on the help.

Here is where I am so far...I have MySQL 4.x and PHP 4.3.9 so my commands are a little different, but you should understand the upgraded commands.

<?php
class Connection {
	function connect(){
		$db = mysql_connect('localhost', 'xxxxx', 'xxxxx', 'fxnsdqzg_ccrt1');
		if (!$db){
			die('Could not connect to the database');
		} else {
			return $result;
		}
	}
}

$db_conn = new Connection;
$db_conn->connect();

//this line works fine
$result = mysql_get_server_info();

//this next line doesnt work...
//it produces an undefined function mysql_get_server_info() error
//$result = $db_conn->mysql_get_server_info();

echo $result;
?> 

[klatt]

hmm yeah i think that works as the procedural version...

i should use the OO version tho since this is partially for a class as well...