PHP code example of josecarlosphp / db
1. Go to this page and download the library: Download josecarlosphp/db 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/ */
josecarlosphp / db example snippets
use josecarlosphp\db\DbConnection;
use josecarlosphp\db\DbConnection;
// Factory auto-selects available driver
$db = DbConnection::Factory(
$ip = 'localhost',
$dbport = 3306,
$dbname = 'my_database',
$dbuser = 'root',
$dbpass = 'secret',
$connect = true,
$charset = 'utf8mb4'
);
// Or explicitly specify a driver ('PDO', 'MySQLi', 'MySQL'):
$dbPdo = DbConnection::Factory('localhost', 3306, 'my_database', 'root', 'secret', true, 'utf8mb4', false, 'PDO');
// SELECT query
$res = $db->Select("SELECT * FROM users WHERE status = 'active'");
// INSERT query
$id = $db->Insert("INSERT INTO users (name, email) VALUES ('Juan', '[email protected] ')");
$lastInsertId = $db->Insert_id();
// UPDATE query
$db->Update("UPDATE users SET status = 'inactive' WHERE last_login < '2023-01-01'");
$affectedRows = $db->AffectedRows();
// Check if records exist
$exists = $db->Exists('[email protected] ', 'email', 'users');
try {
$db->beginTransaction();
$queries = [
"UPDATE accounts SET balance = balance - 100 WHERE id = 1",
"UPDATE accounts SET balance = balance + 100 WHERE id = 2",
];
foreach ($queries as $query) {
if (!$db->Execute($query)) {
throw new Exception($db->Error());
}
}
if ($db->inTransaction()) {
$db->commit();
echo "Transaction committed successfully!";
}
} catch (\Exception $e) {
if ($db->inTransaction()) {
$db->rollback();
}
echo "Transaction failed: " . $e->getMessage();
}
$rs = $db->Select("SELECT id, name, email FROM users");
while ($row = $rs->FetchAssoc()) {
echo $row['name'] . ' - ' . $row['email'] . "\n";
}
// Or fetch all rows at once
$allUsers = $rs->FetchAllAssoc();
use josecarlosphp\db\SqlSelectQuery;
$query = new SqlSelectQuery();
$query->SetSelect('u.id, u.name, count(o.id) as total_orders');
$query->SetFrom('users u');
$query->SetJoin('LEFT JOIN orders o ON u.id = o.user_id');
$query->SetWhere("u.status = 'active'");
$query->SetGroupBy('u.id');
$query->SetOrderBy('total_orders DESC');
$query->SetLimit('0, 10');
$sql = $query->GetQuery();
$res = $db->Select($sql);
use josecarlosphp\db\DbReg;
$user = new DbReg($db, 'users');
$user->Load(1); // Load record with ID 1
if ($user->SetValue('name', 'Carlos') && $user->Save()) {
echo "User updated successfully!";
}else{
echo "User update failed: " . $user->Error();
}