PHP Classes

File: examples/example.php

Recommend this page to a friend!
  Classes of Stefan Gabos   Zebra Database   examples/example.php   Download  
File: examples/example.php
Role: Example script
Content type: text/plain
Description: Example script
Class: Zebra Database
MySQL database access wrapper library
Author: By
Last change: Added meta charset
Initial GitHub release
Date: 8 years ago
Size: 2,229 bytes
 

Contents

Class file image Download
<!DOCTYPE html>

<html>

    <head>

        <meta charset="utf-8">

        <title>Zebra_Database Example</title>

    </head>

    <body>

    <p>
        Prior to running this example you must first download and install the <a href="http://dev.mysql.com/doc/index-other.html">
        <em>world</em></a> test database from MySQL's website.<br>
        Then, you must edit this file (example.php) and change the settings of <em>host</em>, <em>user name</em>, <em>password</em>
        and <em>database</em> to match your configuration.
    </p>

    <?php

       
// THIS EXAMPLE IS VERY BRIEF!
        // CHECK THE DOCUMENTATION TO SEE WHAT METHODS ARE AVAILABLE!

        // include the wrapper class
       
require '../Zebra_Database.php';

       
// create a new database wrapper object
       
$db = new Zebra_Database();

       
// turn debugging on
       
$db->debug = true;

       
// connect to the MySQL server and select the database
       
$db->connect(
           
'', // host
           
'', // user name
           
'', // password
           
'' // database
       
);

       
$db->set_charset();

       
// let's work with a country
       
$country = 'Romania';

       
// get the country's code
       
$country_code = $db->dlookup('Code', 'country', 'Name = ?', array($country));

       
// get all the cities for the country code
       
$db->query('
            SELECT
                Name
            FROM
                city
            WHERE
                CountryCode = ?
            ORDER BY
                Name
        '
, array($country_code));

       
// get all the languages spoken for the country code
       
$db->query('
            SELECT
                Language,
                IsOfficial,
                Percentage
            FROM
                countrylanguage
            WHERE
                CountryCode = ?
            ORDER BY
                Percentage DESC
        '
, array($country_code));

       
// show debug console.
        // THIS SHOULD ALWAYS BE PRESENT AT THE END OF YOUR SCRIPTS!
        // debugging should be controlled by setting the "debug" property to TRUE/FALSE
       
$db->show_debug_console();

   
?>

    </body>

</html>