-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathexample.php
36 lines (22 loc) · 971 Bytes
/
example.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
<?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);