undefined function error: don't know why

beckstei

I've the following script that is supposed to take a query
from a textarea and display the results in a table. This is using the Pear DB abstration layer, DB.php. The function numCol is in the file DB.php which is called at the beginning of the script. I'm receiving an 'undefined function' error at line 45, which is the line where the function numCols is called.
If I comment out this line, I get the same error from the call to numRows. If I comment out the call to numRows, I get the error when the function tableInfo is called.

All of the function calls that result in the undefined error message are called in the same way:
$cols = $res->numCols();
$rows = $res->numRows();
$table = $res->tableInfo();

which leads me to the idea that $res is not being initialized correctly. Which would further indicate that the query,

$res = $cnx->query($query);

is not working.

However, when I enter a deliberately bad query, e.g.,

select no_col_by_this_namel from table,

I get the correct query-error message back: that the column doesn't exist. And when I enter a correct query,

e.g., select * from table,

I don't get a query-error message at all, I just get the undefined function error.

I'm at a loss.

The code is below. I appreciate any help a lot.

Thanks
B

<?php

require_once 'DB.php';

If($_GET['submit']){

echo $_GET['query'].'<br>';

$query=stripslashes($_GET['query']);
echo $query.'<br>';

$user = '';
$pass = '';
$host = 'localhost';
$db_name = '***';

// Data Source Name: This is the universal connection string
$dsn = "mysql://$user:$pass@$host/$db_name";

// Connect to the database

$cnx = DB::connect($dsn); //fill "stuff" with your own DB info.

if (DB::isError($cnx)) {
echo 'No connection<br>';
die ($cnx->getMessage());
}

// Query the database

$res = $cnx->query($query);

if (DB::isError($res)) {
echo 'Invalid query<br>';
die ($res->getMessage());
}

// Determine the number of rows and columns in the result set

//line 45 is below:
$cols = $res->numCols();
$rows = $res->numRows();

// Print column headings

$table = $res->tableInfo();

echo("<table><tr><td> ");

for ($i = 0; $i < $cols; $i++)
{
echo("<td>".$table[$i]['name']."</td>");
}

echo("</tr>");

// Print query results

while ($row = $res->fetchRow())
{
echo("<tr>");
for ($i = 0; $i < $cols; $i++)
{
echo("<td>$row[$i]</td>");
}
echo("</tr>");
}

echo("</table>");

// disconnect from the database
$db->disconnect();

}
?>

<form action="<?php echo $PHP_SELF ?>" method="get">

 <textarea name="query" rows="7" cols="50"></textarea>

 <input type="submit" name="submit" value="Submit">

</form>

</body>
</html>

MrAlaska

What is $res? I am not familiar with the package you are using, but I have a feeling $cnx->query($query); returns a result set which will not inherit any methods. For $res to access those functions, it would need to be an object itself.

EDIT: I just went to the PHP site to see what the heck the :: was. I have never noticed it on the OOP page before. I guess I thought it was a line break or something lol However, it is a method of accessing functions WITHOUT creating an object first. It would 'appear' that DB::connect returns an object, in which case $cnx might have access to the functions.

I dunno, though, it is all guesswork from me.

EDIT AGAIN: By the way, where is $db coming from in $db->disconnect(); ? If DB.php instantiates a $db object then I would be using that for all your database functions. I think it would be better practice to instantiate $db in your script, though, at least to make it easier to read.