MySQL - Flexible Insert-Funktion
<?php
// Flexible Insert-Funktion
$pdo = new PDO('mysql:host=localhost;dbname=test;charset=UTF-8', '', '');
function insertData($pdo, $table, $values) {
$tableHead = array_keys($values);
$comma_separated = implode(",", $tableHead);
$colon_separated = implode(",:", $tableHead);
$statement = $pdo->prepare("INSERT INTO " . $table . " (" . $comma_separated . ") VALUES (:" . $colon_separated . ")");
$statement->execute($values);
}
$table = "members";
$values = array('email' => 'max.mustermann@example.com', 'firstname' => 'Max', 'lastname' => 'Mustermann');
$aktion = insertData($pdo,$table,$values);
?>
Bausteine
Eine zufällige Auswahl von Bausteinen (Snippets) aus den Bereichen CSS, PHP, JavaScript und MySQL.
CSS - Tabellenzeilen einfärben