Posted By

Tagged

Versions (?)

Advertising

Website Promotion DIRECTORY is a crucial factor for all websites that need to gain better organic search engine rankings and increase website traffic.
Submitting your website as part of your Web Promotion strategy to our SEO friendly and high traffic Business Directory for review is an excellent way to gain a valuable backlink and increase your websites visibility online.

Who likes this?

5 people have marked this snippet as a favorite

Wiederkehr
bsisco
Nix
vali29
love

PHP connecting and query MySQL DB

Published in: PHP

Expand | Embed | Plain Text

<?php
	//create db connection
	$connection = mysql_connect("localhost", "user", "password");
	if(!$connection)
	{
		die("Database connection failed:" . mysql_error());
	}
 
	// select a dtabase to use
	$db_select = mysql_select_db("database name", $connection);
	if(!$db_select)
	{
		die("Database selection failed:" . mysql_error());
	}
 
 
?>
 
<body>
     $result = mysql_query("SELECT * FROM tablename", $connection);
 
	while ($row = mysql_fetch_array($result))
	{
		echo $row["rownamehere"]." ".$row["rownamehere"]."<br/>";
	}
?>
</body>
 
<?php
mysql_close($connection);
?>

Report this snippet

Comments

Subscribe to comments

Posted By: PixelMin on October 22, 2008: "

Comment:

You need to login to post a comment.