Connect to a mysql Database using php

adam_uk · 10-24-2003, 12:52 PM

PHP Code:

  <?

 
$username = "username";

$password ="password";

$db = "db";

 
$conn = mysql_connect("localhost", "$username", "$password") or die(mysql_error());

 
mysql_select_db("$db", $conn) or die (mysql_error());

 
 
?>

Once you have php,mysql working you can add this to a php file to use the database
????: NamePros.com http://www.namepros.com/code/15448-connect-to-mysql-database-using-php.html

you may also need other tools such as phpmyadmin www.phpmyadmin.net to help generate the mysql queries and make/delete/edit/change databases

deadserious · 10-30-2003, 05:35 PM

Nice one! That was a definite needed code snippet around here. ... Thanks for sharing.

adam_uk · 10-31-2003, 08:35 AM

surprised it wasnt already here

Phoenix · 04-18-2004, 01:07 PM

I am saving this page in my "Cool Sites" guide

, cool reference if your in a hurry.

10-24-2003, 12:52 PM	THREAD STARTER #1 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	Connect to a mysql Database using php PHP Code: `<? $username = "username"; $password ="password"; $db = "db"; $conn = mysql_connect("localhost", "$username", "$password") or die(mysql_error()); mysql_select_db("$db", $conn) or die (mysql_error()); ?>` Once you have php,mysql working you can add this to a php file to use the database ????: NamePros.com http://www.namepros.com/code/15448-connect-to-mysql-database-using-php.html you may also need other tools such as phpmyadmin www.phpmyadmin.net to help generate the mysql queries and make/delete/edit/change databases

04-18-2004, 01:07 PM	#4 (permalink)
Phoenix NP Maniacâ„¢ Join Date: Apr 2004 Location: Nottingham, UK Posts: 820 Follow @47ideas	I am saving this page in my "Cool Sites" guide , cool reference if your in a hurry. __________________ PHP/MySQL Development offered: PM me for a quote. 47ideas.com - my freelancing portfolio.

10-30-2003, 05:35 PM	#2 (permalink)
deadserious Senior Member Join Date: Aug 2002 Posts: 1,255	Nice one! That was a definite needed code snippet around here. ... Thanks for sharing.

10-31-2003, 08:35 AM	THREAD STARTER #3 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,187	surprised it wasnt already here

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)