Advanced Search

Return to Snippet

Revision: 5607
at March 18, 2008 23:13 by mswallace
Initial Code 
<?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);
?>
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
PHP connecting and query MySQL DB

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, database, php, query

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PHP