This repository was archived by the owner on Jul 18, 2019. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
An object-oriented wrapper to PHP's native mysql_* functions
mirfan/dal
Folders and files
| Name | Name | Last commit message | Last commit date | |
|---|---|---|---|---|
Repository files navigation
Example usage:
--------------
// Create database object.
$db = new MySQL('myHost', 'myUser', 'myPassword', 'myDatabase');
// Fetch a single value.
$rowCount = $db->fetchOne('
SELECT COUNT(*)
FROM `some_table`;
');
printf('Row count: %s', $rowCount);
// Fetch a single row using a single placeholder.
$rawSql = 'SELECT firstname, lastname, age FROM `persons` WHERE id = ?;'
$id = 123;
$db->bindParam(1, $id);
$sql = $db->prepare($rawSql);
$row = $db->fetchRow($sql);
print_r($row);
// Fetch multiple rows using multiple placeholders.
$firstname = 'Joe';
$minimumAge = 30;
$rawSql = 'SELECT firstname, lastname, age FROM `persons` WHERE firstname = ? AND age > ?;'
$db->bindParam(1, $firstname);
$db->bindParam(2, $minimumAge);
$sql = $db->prepare($rawSql);
$rows = $db->fetchAll($sql);
print_r($rows);
// Insert a row using placeholders with auto-escaping.
$rawSql = 'INSERT INTO `persons` (firstname, lastname, age) VALUES (?, ?, ?);'
$db->bindParam(1, $firstname);
$db->bindParam(2, $lastname);
$db->bindParam(3, $age);
$sql = $db->prepare($rawSql);
$db->query($sql);
// Insert a row using the SQL-free method with an associative array.
$db->insert('persons', array(
'firstname' => $firstname,
'lastname' => $lastname,
'age' => $age
));
// Update a row using associative array
$db->update('persons', array('age' => 123), array('id' => 1));
// Delete a row.
$db->delete('persons', array('age' => 18));About
An object-oriented wrapper to PHP's native mysql_* functions
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published