PHP Classes

MySQL errors

Recommend this page to a friend!

      Access user Class  >  All threads  >  MySQL errors  >  (Un) Subscribe thread alerts  
Subject:MySQL errors
Summary:Not getting queries through, PHP5 and MySQL 4.1
Messages:5
Author:Jim Kraus
Date:2005-07-08 11:57:40
Update:2005-07-09 08:55:24
 

  1. MySQL errors   Reply   Report abuse  
Picture of Jim Kraus Jim Kraus - 2005-07-08 11:57:40
Yes I'm a REAL newbie. this is my first attempt after reading PHP and MySQL Web Development(Welling, Thompson)good book. I downloaded your class and examples last night. At first I got no connection at all, until I modified the class at about line 123 by commenting out the the function content of connect_db and inserted:
new mysqli ('localhost', 'dbuser', 'password', 'dbname');
Things looked much better until I tried register.php and got errors like:

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in c:\program files\apache group\Apache\htdocs\classes\access_user\access_user_class.php on line 95
**and I also get the same on line 95*
I'm also getting:
Warning: mysql_query() [function.mysql-query]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in c:\program files\apache group\Apache\htdocs\classes\access_user\access_user_class.php on line 295
I really don't get the 'SYSTEM'@'localhost' part as thats not my user or database.
I'm using PHP5, and mysql 4.1.
Any idea what up?
Thanks

  2. Re: MySQL errors   Reply   Report abuse  
Picture of Olaf Lederer Olaf Lederer - 2005-07-08 13:00:13 - In reply to message 1 from Jim Kraus
Hello,

first of all the class is not written for php5...(not sure if it works with php5)

tell me what code is this:
new mysqli ('localhost', 'dbuser', 'password', 'dbname');

this is not from the php manual, do you use any library?

gr. Olaf

  3. Re: MySQL errors   Reply   Report abuse  
Picture of Olaf Lederer Olaf Lederer - 2005-07-08 13:06:16 - In reply to message 2 from Olaf Lederer
OOps (php5 is comming)....

I found some reference about the mysqli extension and this code should be valid....

My advice to you as a new PHP user: If you have good knowledge in OOP than it will be easy to you to replace the code for using the mysqli extension and otherwise use php4...

Maybe I will write a php5 version later this year...

  4. Re: MySQL errors   Reply   Report abuse  
Picture of Jim Kraus Jim Kraus - 2005-07-09 03:08:55 - In reply to message 1 from Jim Kraus
Well, I'd like to try and fix it, but I don't have the time. I may look at it again later. And I don't want to go backwards to PHP4 either. I'm looking at other packages instead. But I thank you for your promt answer and support of your users. Keep up the good work.
Jim

  5. Re: MySQL errors   Reply   Report abuse  
Picture of Olaf Lederer Olaf Lederer - 2005-07-09 08:55:24 - In reply to message 4 from Jim Kraus
OK, success with searching (there is not so much) :-(.
Don't forget that the most applications are written in php4. Check the internet how to install both version 4 and 5. After this you can use scripts in both version with the same database.