Article Rating

  • 0 Rating(s)
  • 0
  • 0
  • 0
  • 0
  • 0

How to connect to MySQL with PHP

<h1>MySQL Test Code Results</h1> 
<p><table border="1"> 
<tr> 
<td>ID</td> 
<td>First Name</td> 
<td>Last Name</td> 
</tr> 
 
<?php 
 
// Configuration Information and Definitions 
 
$mysql_host = 'MySQL Server Name'; 
$mysql_user = 'DB Login'; 
$mysql_pass = 'DB Password'; 
$mysql_db = 'DB Name; 
$query = 'SELECT * from table1'; 
 
mysql_connect($mysql_host, $mysql_user, $mysql_pass) or die("Connection to MySQL-server failed!"); 
 
mysql_select_db($mysql_db) or die("Selection of database $mysql_db failed!"); 
 
$result = mysql_query($query) or die("Invalid Query, " . mysql_error()); 
 
while( list( $pkid, $fname, $lname ) = mysql_fetch_row($result) ) { 
printf("<tr><td>%d</td><td>%s</td><td>%s</td></tr>", $pkid, $fname, $lname); 
} 
 
?> 
</table> 
<p /> 
<b>End MySQL Test Code Results</b>  


If you run in to problems using this code, please post in our community forum. Technical support cannot assist with specific coding related issues.

Article ID: 834, Created On: 8/17/2010, Modified: 4/21/2011