Does any one tell me How to Connect PHP with MySql database please

In the words of the virgin mary, RTFM ;)

http://www.php.net/mysql

Once you know the basics, its very simple. Connecting is a matter of using the command mysql_connect(), and mysql_query() to run a query.

Many shoes,

James/SiliconFuRy

To get you started, try this(predefining the variables of course):

mysql_connect($hostname, $user, $pass) or die("Cannot connect to server!\n");
mysql_select_db($dbname) or die("Table unavailable!\n");

$sql = "Show tables";

$result = mysql_query($sql);

$result is now an identifier to the result list that the query returned.

mysql_fetch_array($result) will return the first row in the result, so implement this in a loop to go
through the result table row at a time and do whatever functions you need.

Many shows,

James/SiliconFuRy

yes I try to use
mysql_connect($hostname, $user, $pass) or die("Cannot connect to server!\n");
function bu I get the following error
Undefind mysql_connect function
I'm using XP pro

READ THE MANUAL.

If you had read the manual, it says that the MySQL library is no longer included with PHP 5.

Read the manual for instructions to install it.

-Snib
Where will you be in 100 years?
Try new FreshView 0.2!

Is this some nazisom/communism/capitilism/shoeism by PHP not to include php by default? Or is it just a security thing?

Many shoes,

James/SiliconFuRy

I assume you mean to not include MySQL by default....

I agree with you, it's kind of stupid. I searched on it and it gave me this:
http://us2.php.net/manual/en/faq.dat...ses.mysql.php5

-Snib
Where will you be in 100 years?
Try new FreshView 0.2!

Excuse my shoes, going by the time of posting it must have been nearing the Midday Feeding Frenzy...

Many shoes

JAmez

Why2use PHP-MySQL on WinXPPRO !!

Better try install PHP 5 on Win2000 or 2003
Be ready to read documentation, download something from php.net and fix mysql by hit -n- trial

I'm better with PHP 4.3.4 :)

Why2use extra PHP 5 lieu 4.x.y !!

Tell me, how does this post help anyone? Or are you just saying you don't care for XP? PHP runs almost the same cross-platform.

-Snib
Where will you be in 100 years?
Try new FreshView 0.2!