Migrated from PHP4 to PHP5, part of code did not run as expected

happyness

Hi.

I wanna migrate the code from PHP4 to PHP5, but It didn't work and threw the notice as follows:

Notice: Trying to get property of non-object in C:\xampp\htdocs\poll\miniPoll.class.php on line 47

Notice: Trying to get property of non-object in C:\xampp\htdocs\poll\miniPoll.class.php on line 48

the code snippets include line 48,47 in the miniPoll.class.php :

44	function getActivePoll() {
45	$sql = @mysql_query ("SELECT pollid, polltitle FROM poll_desc WHERE status = 'active'");
46	$row = @mysql_fetch_object($sql);
47	$this->active_poll_id = $row->pollid;
48      $this->active_poll_title = $row->polltitle;
49	return;
50	}

Is there anybody able to guide me on this, thank you!

s0me0ne

Is mysql enabled in your php.ini? I believe by default its not with PHP5

happyness

Hi, s0me0ne. Thanks reply. Yes. the code didn't developed on my PC.
My Environment as follows:

Windows XP SP2
XAMPP (basic package) version 1.6.6a
Apache 2.2.8
MySQL 5.0.51a
PHP 5.2.5

Any advice would be much appreciated.

s0me0ne

Check if your php.ini has the mysql extension commented out. If so uncomment it and restart apache. Also make sure mysql is running

NogDog

Another possibility is that the query is not working for some reason. Try adding some debugging to see if you can find out why:

$sql = @mysql_query ("SELECT pollid, polltitle FROM poll_desc WHERE status = 'active'");
if($sql == false)
{
   echo "Query failed: " . mysql_error();
}

For the production version, you'll want to change that error message to something "user-friendly" and write the mysql_error() information to an error log file, instead.

happyness

s0me0ne wrote:
Check if your php.ini has the mysql extension commented out. If so uncomment it and restart apache. Also make sure mysql is running

I checked the mysql extension in php.ini. It's ok.
In my PHP5 environment , mysql and apache is running. most of codes work as well, just threw the notice in above code snippets.

Then I used XAMPP switch PHP5 to PHP4, but got following warning:

Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in C:\xampp\htdocs\poll\test_poll.php on line 7
Unable to connect

happyness

NogDog wrote:
Another possibility is that the query is not working for some reason. Try adding some debugging to see if you can find out why:
$sql = @mysql_query ("SELECT pollid, polltitle FROM poll_desc WHERE status = 'active'");
if($sql == false)
{
   echo "Query failed: " . mysql_error();
}
For the production version, you'll want to change that error message to something "user-friendly" and write the mysql_error() information to an error log file, instead.

Thanks for your reply, NogDog. I am sure the SQL code It works, I checked it in my PhpMyAdmin. I added debug code in my error snippets, but nothing echo.