PDO กับฐานข้อมูล

    <?php

    // prepare database connection variables
    $db_host = 'localhost';
    $db_name = 'keancode';
    $db_user = 'keanuser';
    $db_pass = 'keanpass';

    // connect
    try {
        // If you change db server system, change this too!
        $conn = new PDO("mysql:host=$db_host; dbname=$db_name", $db_user, $db_pass);
        echo "Connected to database";
    }
    catch (PDOException $e) {
        echo $e->getMessage();
    }

    <?php

    // PostgreSQL
    $conn = new PDO("pgsql:host=$db_host port=5432 dbname=$db_name", $db_user, $db_pass);

    // Oracle
    $conn = new PDO("OCI:dbname=$db_name;charset=UTF-8", $db_user, $db_pass);

    // ODBC with MS Access database
    $conn = new PDO("odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq="C:\database.mdb;Uid=Admin");

    // SQLite
    $conn = new PDO("sqlite:/path/to/database.sqlite");

    <?php

    $conn = null;

    <?php

    try {
        // connect to database
        $conn = new PDO("mysql:host=$db_host; dbname=$db_name", $db_user, $db_pass);
        echo "Connected to database \n";

        // prevent unreadable characters in many languages
        $conn->exec("SET CHARACTER SET utf8");

        // add data into database
        $count = $conn->exec("INSERT INTO application VALUES (null, 'Opera', 'Browser', 'Opera Software ASA', 1994)");

        // display result
        echo 'Rows add: ' . $count . "\n";

        // close connection
        $conn = null;
    }
    catch (PDOException $e) {
        echo $e->getMessage();
    }

    <?php

    // get data
    $result = $conn->query("SELECT name,year FROM application");

    // display it
    if ($result !== false) {
        echo 'There is ' . $result->rowCount() . " application(s) in database.\n";

        foreach($result as $row) {
            echo '- ' . $row['name'] . ' was released on ' . $row['year'] . "\n";
        }
    }

    <?php

    // get data
    $result = $conn->query("SELECT name,year FROM application");

    // display it
    if ($result !== false) {
        echo 'There is ' . $result->rowCount() . " application(s) in database.\n";

        while($row = $result->fetch()) {
            echo '- ' . $row['name'] . ' was released on ' . $row['year'] . "\n";
        }
    }

    <?php

    // prepare and query (direct)
    $result = $conn->prepare("SELECT * FROM application WHERE category='Browser'");
    $result->execute();

    // display it
    if ($result !== false) {
        echo $result->rowCount() . " application(s) in Browser category.\n";

        while($row = $result->fetch()) {
            echo '- ' . $row['name'] . ' was released on ' . $row['year'] . "\n";
        }
    }

    <?php

    // category that I want to show
    $cat = {'OS', 'Office Suite'};

    $result = $conn->prepare("SELECT * FROM application WHERE category=? OR category=?");
    $result->execute($cat);

    if ($result !== false) {
        echo 'Found ' . $result->rowCount() . " application(s).\n";

        while($row = $result->fetch()) {
            echo '- ' . $row['name'] . ' was released on ' . $row['year'] . "\n";
        }
    }

    <?php

    $term = array(
        'cat'   => 'Browser',
        'year'  => 2000,
    );

    // prepare query
    $result = $conn->prepare("SELECT * FROM application WHERE category=:cat AND year>:year");

    // bind statement and query it
    $result->execute($term);

    if ($result !== false) {
        echo 'Found ' . $result->rowCount() . " application(s).\n";

        while($row = $result->fetch()) {
            echo '- ' . $row['name'] . ' was released on ' . $row['year'] . "\n";
        }
    }

    <?php

    function display_data($result) {
        if ($result !== false) {
            echo 'Found ' . $result->rowCount() . " application(s).\n";

            while($row = $result->fetch()) {
                echo '- ' . $row['name'] . ' was released on ' . $row['year'] . "\n";
            }
        }
    }

    $term = array(
        'cat'   => 'Browser',
        'year'  => 2000,
    );

    // prepare query
    $query = $conn->prepare("SELECT * FROM application WHERE category=:cat AND year>:year");

    // bind statement and query it
    $query->execute($term);
    display_data($query);

    // change bind data
    $term = array(
        'cat'   => 'Graphic Editor',
        'year'  => 1991,
    );

    // bind with new data and query it
    $query->execute($term);
    display_data($query);