topic Re: Need Hello World PHP script in Operating System - Linux

Need Hello World PHP script

Vernon Brown_4 — Sun, 27 Feb 2005 14:28:28 GMT

I'm trying to setup phpbb which uses php and MySQL. Error message from the phpbb install says my PHP setup doesn't support the database selected. The install splash page says that the database selected must already exist.

I need a simple PHP script that will access MySQL as a test so that I know they are compatible.

I need to create a MySQL database and assign it a password. I'm not sure the MySQL install process did that.

Re: Need Hello World PHP script

K.C. Chan — Sun, 27 Feb 2005 18:56:24 GMT

below is a code piece which should let you view information/configuration about apache,php,and and db configuration associated with php.
phpinfo();
?>

create a file call info.php, put that field in a proper directory under apache, access it from the browser and you should see a slew of information you need.

It sounds like a mysql config issue? Installing mysql by defautl will create a user root and test. The default db are mysql and test. In short I do not think the install process create the db you wanted.

Re: Need Hello World PHP script

Vernon Brown_4 — Sun, 27 Feb 2005 19:25:53 GMT

Thanks for your response K.C.

I agree it is probably a MySQL config issue; I just don't have it set up correctly. Thanks for the PHP script; I had it from a previous post, though :)
I'm really looking for something that will tell me if my PHP setup can actually talk to MySQL setup. A script that would store something in a default db (test) and retrieve it would do. I've attempted to write one; so far no joy.

Vern

Re: Need Hello World PHP script

K.C. Chan — Sun, 27 Feb 2005 19:44:13 GMT

Have you check to make sure the user has privilege to access the db remotely from another box (assuming you are not hosting mysql on the same server as your webpage). Here's a quick command to test it:
mysql -u -h -p

Re: Need Hello World PHP script

NiCK_76 — Sun, 27 Feb 2005 22:28:59 GMT

Hi,Brown,

Try following PHP script
mysql_connect('localhost','username','password') or die ('can't connect mysqld');
mysql_select_db('yourdb') or die ('can't connect db');
?>

PHP and mysql are working,if nothing display.

NiCK

Re: Need Hello World PHP script

Vernon Brown_4 — Mon, 28 Feb 2005 07:26:10 GMT

Thanks guys !!

Exactly what I needed.