Category: General PHP

PHP connect to a database and query a table:

<? # Connect mysql_connect('localhost', 'user', 'password') or die('Could not connect: ' . mysql_error()); # Choose a database mysql_select_db('dbname') or die('Could not select database'); # Perform database query $query = "SELECT * from table"; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); # Filter through rows and echo desired information while ($row = mysql_fetch_object($result)) { echo $row->colname;
}
?>

 

Tags:

PHP

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count: