Notes

<?php
class DatabaseTable //database table is initialize
{
public $table;
function __construct($table)
{
$this->table = $table;
}


function save($record,$pk =''){ //save function is used for inserting and updating
try {
$this->insert($record);
} catch (Exception $e) {
$this->update($record, $pk);
}
}

function insert($record) { //insert function is used for inserting data
global $pdo;
$keys = array_keys($record);

$values = implode(', ', $keys);
$valuesWithColon = implode(', :', $keys);

$query = 'INSERT INTO ' . $this->table . ' (' . $values . ') VALUES (:' . $valuesWithColon . ')';

$stmt = $pdo->prepare($query);

$stmt->execute($record);
}

function update($record, $pk){ //update function is used for updating data
global $pdo;
$parameters = [];
foreach ($record as $key => $value) {
$parameters[] = $key . '= :' . $key;
}
$parametersWithComma = implode(', ', $parameters);
$query = "UPDATE $this->table SET $parametersWithComma WHERE $pk = :pk";
$record['pk'] = $record[$pk];
$stmt = $pdo->prepare($query);
$stmt->execute($record);
}

function find($field, $value) { //find function is used for select statement for specific
global $pdo;
$stmt = $pdo->prepare('SELECT * FROM ' . $this->table . ' WHERE ' . $field . ' = :value');
$criteria = [
'value' => $value
];
$stmt->execute($criteria);

return $stmt;
}

function findAll() { //findAll function is used for select statement for all
global $pdo;
$stmt = $pdo->prepare('SELECT * FROM ' . $this->table );

$stmt->execute();

return $stmt;
}

function delete($field,$value){ //delete function is for deleting data
global $pdo;
$stmt = $pdo->prepare('DELETE FROM '.$this->table.' WHERE ' . $field . ' = :value');
$criteria = [
'value' => $value
];
$stmt->execute($criteria);

return $stmt;

}
}
?>