Trouble With Mysql

leiaah

Jun 23 2005, 05:27 PM

I just bought a book 'SAMS Teach Yourself PHP, MySQL, and Apache' and it included a CD with installers of the 3. I previously had MySQL 3.23.54 on my computer and since there's a newer version in the CD I replaced it with that one. Everything worked fine and I even set permissions for users using the windows command prompt but the trouble came when I try previewing the pages I have. Nothing gets displayed when I view it in a browser (no tables, no error on the connection, nothing). I know that PHP works fine because I've tested out some PURE PHP pages, the only trouble is the PHP pages with MySQL queries. The pages worked fine when I uploaded them on my Trap17 website but not here in my local PC.

Does anyone know what's wrong with it and what has to be done about it?

bjrn

Jun 23 2005, 06:19 PM

Make sure the PHP scripts are connecting to the DB and selecting the DB okay. Try to do something like

CODE

$username = 'something';
$password = 'something';
$dbname= 'something';

mysql_connect ("localhost", $username, $password) or die ('ERROR: I cannot connect to the database because: ' . mysql_error());
mysql_select_db ($dbname) or die ('ERROR: I cannot select the database because: ' . mysql_error());

And die() messages further along the way as well.

rvalkass

Jun 23 2005, 06:48 PM

Also, make sure MySQL is running as a service, otherwise you have to manually start it, which you won't have done. Try starting it as a service (help on the MySQL Website).

leiaah

Jun 24 2005, 03:28 AM

CODE

@ $db = mysql_connect ("localhost", "xxxx", "xxxxx") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("blog",$db);

if(!$db){
echo 'Could not connect to the database';
exit;
}
mysql_select_db('blog');

$query=mysql_query("SELECT name,url,msg,id FROM shout ORDER BY id DESC",$db) or die (mysql_error());
while($row=mysql_fetch_row($query)){
//echo the results here
}

Bjrn...

This is the code I use and nothing gets displayed still. I reinstalled the older version of MySQL that worked for me before but still nothing. I'm thinking maybe it has to do with the PHP version I have now installed or the Apache server.

bjrn

Jun 26 2005, 06:53 PM

Perhaps if you tried this:

CODE

mysql_connect ("localhost", "xxxx", "xxxxx") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ('blog) or die ('I cannot select the database because: ' . mysql_error());

$query=mysql_query("SELECT name,url,msg,id FROM shout ORDER BY id DESC",$db) or die (mysql_error());
while($row=mysql_fetch_row($query)){
echo "Name: ".$row[0];
}

Things you might want to check:
I'm sure you've checked yourself, but I still have to ask: Are you completely sure that there is data in the shout table?

That you aren't using mysql_fetch_row() and then $row['name']. I think when you fetch results with the row function, you can only use numbers, if you want to use names like: $row['name'], $row['url'] etc, you have to use mysql_fetch_array($query) instead.

That's all I can think of right now.

hype

Jun 27 2005, 10:22 AM

Maybe your pc just cant process mysql, you may just access it through your trap17 website, since it wont do much harm... and maybe its not called localhost, but I'm not really sure, cause I never tried using mysql through my pc...

RazorICE

Jun 28 2005, 06:46 AM

Or maybe try updating your PHP version? I don't know, it may help, it may not, it probably has nothing to do with it, but, *shrug* there's a possibility it could work.

badinfluence

Jun 28 2005, 02:31 PM

CODE

mysql_select_db ("blog",$db);

if this is on the trap17 server, your database name should start with prefix(mostly your cpanel username) e.g. this format "username_blog".
even though you can use "blog" as a database name on local server but on trap17 must have username prefix.

miCRoSCoPiC^eaRthLinG

Jun 28 2005, 02:59 PM

Leeiah - most likely your copy of PHP is still using the authentication method that was used in MySQL 3.x. This is a very common problem. MySQL 4.1 and later uses a new authentication protocol which is not compatible with the libraries that PHP 4 uses.

First try setting the option display_errors to 1 in your php.ini file, and restart php+your system. When display_errors is set to 1, it instructs PHP not to suppress error messages - that will help in spotting the exact nature of the problem.

Next try your own php code again and see if it gives out an error like "Client does not support authentication protocol" - that is a sureshot sign of this. Now your job would be to update PHP to the latest version (5) and update your MySQL too.. and restart the system. That should ideally solve your problem. You might also consider removing the "@" in front of your $db = mysql_connect, temporarily for debugging purposes.

From what I've seen in your case - I'm damned sure its the older PHP version causing this problem.

Try and let me know - or else, will tell you another solution (a little brute force way)...

Regards,
m^e

ADD REPLY / Got an Opinion!	Remove these ADs!	RAPID SEARCH!	Free Web Hosting	[X]
Express your Opinions, Thoughts or Contribute more info. to help others. Ask your Doubts & Queries to get answers, So that "Together We can help others!"	Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.		500MB Space No Ads, CPanel, FTP, PHP, MySQL, EMails - 100% FREE