1. Go to this page and download the library: Download xy2z/pdodb library. Choose the download type require.
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
xy2z / pdodb example snippets
use xy2z\PDODB\PDODB;
$pdo = new PDODB('host', 'database', 'user', 'password', 'mysql','utf8');
// Change default database.
$pdo->use('test');
// Select query
$data = $pdo->select("SELECT * FROM tablename");
$data = $pdo->select("SELECT * FROM tablename LIMIT :limit", ['limit' => 10]);
$data = $pdo->select("SELECT id, age FROM tablename WHERE name LIKE :name", ['name' => '%Demogorgon%']);
foreach ($data as $row) {
echo $row->id;
}
// Select a single row
$row = $pdo->select_row('SELECT name, age FROM users WHERE id = :id', ['id' => 4]);
echo $row->name;
// Select a single field
$name = $pdo->select_field('SELECT name FROM tablename WHERE id = :id', [
'id' => 24
]);
echo $name;
// Insert row
$id = $pdo->insert_row('tablename', [
'name' => 'The Dude',
'age' => 234
]);
echo 'Inserted ID: ' . $id;
// Insert multiple rows (accepts array of (objects/arrays))
$count = $pdo->insert_multi('tablename', [
(object) ['name' => 'Will', 'age' => '11'],
['name' => 'El', 'age' => '11'],
]);
echo 'Inserted ' . $count . ' rows.';
// Update
$fields = [
'name' => 'New Name',
'age' => '12'
];
$count = $pdo->update('tablename', $fields, ['id' => 24]);
echo 'Updated ' . $count . ' rows.';
// Delete rows
$count = $pdo->delete('tablename', ['id' => 14]);
echo 'Deleted ' . $count . ' rows.';
// Transaction.
try {
$pdo->transaction_start();
$pdo->insert_row('users', ['username' => 'Elliot']);
$pdo->delete('tablename', ['id' => 60]);
$pdo->transaction_commit();
} catch(Exception $e) {
var_dump('Error: ' . $e->getMessage());
$pdo->transaction_rollback();
}
// Query
$statement = $pdo->query("DELETE FROM tablename WHERE name LIKE :name", ['name' => '%del%']);
echo 'Deleted ' . $pdo->affected_rows($statement) . ' rows.';
Loading please wait ...
Before you can download the PHP files, the dependencies should be resolved. This can take some minutes. Please be patient.