PHP DB::DBInstance Examples

Example #1

File: chat_server.php Project: VoidWalker/learning-project

function refreshChat()
{
    $db = DB::DBInstance()->DB();
    $stmt = $db->query("SELECT * FROM message");
    while ($row = $stmt->fetchObject()) {
        foreach ($row as $column => $value) {
            echo "-" . $column . "=>" . $value . "<br />";
        }
        echo "<hr>";
    }
}

Example #2

File: Main.php Project: VoidWalker/learning-project

 public static function init()
 {
     DB::DBInstance()->DB();
 }

Example #3

File: save_message.php Project: VoidWalker/learning-project

<?php

require_once '/../DB.php';
$time = time();
$author = $_POST['author'];
$message = $_POST['message'];
$db = DB::DBInstance()->DB();
$stmt = $db->prepare('INSERT INTO message (id, time, author, message) VALUES (null, :time, :author, :message)');
$stmt->execute(array(':time' => $time, ':author' => $author, ':message' => $message));
echo 'TRUE';