1. Go to this page and download the library: Download dekyfin/easypdo 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/ */
dekyfin / easypdo example snippets
// Insert row using prepared statement and get insert id
// PDO
$stmt = $db->prepare("INSERT INTO table(col1,col2) VALUES(:col1, :col2)");
$stmt->execute(["col1"=>"val1", "col2"=>"val2"]);
$id = $db->lastInsertId();
// EasyPDO
$id = $db->insert("table", ["col1" => "val1", "col2"=>"val2"]);
// Select rows from DB
//PDO
$stmt2 = $db->prepare("SELECT * FROM table WHERE col1 = :col1 AND col2 = :col2)");
$stmt2->execute(["col1"=>"val1", "col2"=>"val2"]);
$rows = $db->fetchAll( $stmt2 );
// EasyPDO
$rows = $db->select("table", ["col1"=>"val1", "col2"=>"val2"]);
/* Take note of the the 2nd parameter:
* A value of true ocauses the function to return the 'convenient data',
* while false returns the PDOStatement Object
*/
// Select Statement
$rows = $db->execute("SELECT id FROM table WHERE id < :max", ["max"=>3], true);
// Output: array of matched rows
$insertId = $db->execute("INSERT INTO table(col1, col2) VALUES(:col1, :col2)", ["col1"=>"val1", "col2"=>"val2"], true);
//Output: inserId
$affectedRows = $db->execute("DELETE FROM table WHERE id = :id", ["id"=>5], true);
//Output: affected rows
$affectedRows = $db->execute("UPDATE table SET col1 = :col1 WHERE id = :id", ["id"=>5, "col1"=>"valX"], true);
//Output: affected rows
// Options for connecting to MySQL database
$options = [
"host"=>"localhost",
"user"=>"db_user",
"db"=>"db_name",
"pass"=>"s3cr3tp@ssw0rd"
];
// Create connection
$db = new DF\DB($options);
// Run queries
$rows = $db->query("SELECT * FROM table", true);
$data = $db->select("table", ["category"=>3] , 10); //Show only 10 results
$data = $db->select("table", ["category"=>3] , "ORDER BY id DESC");
$data = $db->query("Select id FROM table", true); // [ [id=>1], [id=>2] ... ]
$data = $db->execute("Select id FROM table WHERE id < :max", ["max"=>3] , true); // [ [id=>1], [id=>2] ... ]