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();
}