<?php
// Just include the one file.
include 'mysquirrel.php';
// Connect.
$mysql = new MySquirrel('localhost', 'user', 'pass', 'database');
// Activate paranoid mode.
$mysql->paranoid();
// This is how you query the database.
$result = $mysql->query('SELECT * FROM users WHERE id = ?', $id);
foreach ($result as $row) {
echo $row['name'];
}
// Additional parameters are passed as additional arguments to query();
$mysql->query('UPDATE users SET email = ? WHERE id = ?', $new_email, $id);
// Insert and get the autoincrement ID.
$mysql->query('INSERT INTO users (name, password, email) VALUES (?, ?, ?)', $name, $password, $email);
$id = $mysql->lastInsertID();
// Use prepared statements for extra security and possible performance gains.
$stmt = $mysql->prepare('INSERT INTO users (name, password, email) VALUES (?, ?, ?)');
$stmt->execute($name, $password, $email);
$stmt->execute($name, $password, $email);
$stmt->execute($name, $password, $email);
public function __construct($connection, $querystring)
{
$this->connection = $connection;
$this->querystring = $querystring;
$this->numargs = substr_count($querystring, '?');
$this->statement = MySquirrel::genStatementName();
$this->realQuery('PREPARE ' . $this->statement . ' FROM \'' . mysql_real_escape_string($this->querystring, $this->connection) . '\'');
}
