function db_getConnection()
{
static $dbh = null;
if ($dbh != null) return $dbh;
$dbh = new PDO("mysql:dbname=NAME;host=
127.0.0.1;charset=utf8;port=3306", 'root', '',
[
PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
]);
return $dbh;
}
function db_insert($table, $arr)
{
$q = "INSERT INTO
{$table}
";
$fields = array_keys($arr);
$q .= "(
" . implode("
,
", $fields) . "
) VALUES (:" . implode(",:", $fields) . ")";
$stmt = db_getConnection()->prepare($q);
$stmt->execute($arr);
}
$data = $_POST;
if(isset($data['title']) && isset($data['about'])){
$newNew = [];
$newNew['title']=trim ... htmlspecialchars ... ($data['title']);
$newNew['about']=trim ... htmlspecialchars ... ($data['about']);
db_insert('article',$newNew);
header('Location: /');
}