Online
- Thread Author
- #1
Connect:
İNSERT:
DELETE:
UPDATE:
SELECT:
İNDİR
PHP:
require 'vendor/autoload.php';
$config = [
'host' => 'localhost',
'driver' => 'mysql',
'database' => 'test',
'username' => 'root',
'password' => '',
'charset' => 'utf8',
'collation' => 'utf8_general_ci',
'prefix' => ''
];
$db = new \Buki\Pdox($config);
$records = $db->table('users')
->select('id, name, surname, age')
->where('age', '>', 18)
->orderBy('id', 'desc')
->limit(20)
->getAll();
var_dump($records);
İNSERT:
PHP:
$data = [
'name' => 'Burak',
'surname' => 'Demirtaş',
'age' => '24',
'country' => 'Turkey',
'city' => 'Ankara',
'status' => 1
];
$query = $db->table('users')->insert($data);
if($query)
{
echo 'Record added! <br />' .
'InsertID: ' . $db->insertId();
}
PHP:
$query = $db->table('pages')->where('year', 2014)->where('status', 0)->delete();
if($query)
{
echo 'Record(s) deleted!';
}
UPDATE:
PHP:
$data = [
'username' => 'new-user-name',
'password' => md5('new-password'),
'status' => 1
];
$query = $db->table('users')->where('id', 17)->update($data);
if($query)
{
echo 'Record updated!';
}
SELECT:
PHP:
$records = $db->table('users')
->select('name, surname, age')
->where('age', '>', 18)
->orderBy('id', 'desc')
->limit(20)
->getAll();
foreach($records as $record)
{
echo $record->name . '<br />' .
$record->surname . '<br />' .
$record->age;
}
İNDİR