How to Use Databases with PHP (Example)

Here is a simple example of how to use your MySQL database with a PHP script. The database used here is the one described in the Knowledge Base article How To Create a MySQL Database, in which we then created a table called books with 3 fields: ID, author, title. The following script will output the title and author of each book:

<?php

$dbh = mysqli_connect("localhost", "johndoe_mysqlusername", "johndoe_mysqlusername_password", "johndoe_project01") or die ('Connexion error: ' . mysqli_error($dbh));
$sql = "SELECT * FROM books";
$result = mysqli_query($dbh,$sql) or die('SQL Error: ' . mysqli_error($dbh));

while ($row = mysqli_fetch_array($result)){
   echo 'Title: ' . $row['title'] . ', ';
   echo 'Author: ' . $row['author'] . '';
}

?>

For additional information, please refer to the PHP and MySQL web sites. A Google search of a specific problems also often turns up useful results!

 

 

Article ID: #HC5020

Was this answer helpful? Yes No