Code:
<?PHP
$aKeys = array("login", "password" => "PASSWORD(#)", "email", "question1", "answer1", "question2", "answer2", "create_time" => "NOW()", "web_ip" => $_SERVER['REMOTE_ADDR'], "web_aktiviert" => 1);
$sqlInsert = keyToInsertString($aKeys);
foreach ($aKeys as $key => $value){
if (is_numeric($key)){
if (isset($_POST[$value])){
$fInput = CheckInput($value, $_POST[$value]); // überprüft welche zeichen und länge es haben darf
if ($fInput === true){
$aSQLInsert[":".$value] = $_POST[$value];
}else{
$fError = true;
echo $value."\r\n";
}
}else{
$fError = true;
echo $value." exisitert nicht\r\n";
}
}
}
if (!isset($fError)){
$mQuery = $sqlHP->prepare("INSERT INTO `account` (".$sqlInsert[0].") VALUES (".$sqlInsert[1].")");
print_r($aSQLInsert);
exit;
$mQuery->execute($aSQLInsert);
var_dump($sqlHP->errorInfo());
}
function keyToInsertString($keys){
foreach ($keys as $key => $value){
if (is_numeric($key)){
$sKeys .= $value.",";
$sValues .= ':'.$value.',';
}else{
$sKeys .= $key.",";
if (preg_match('~[A-Z]\(.*\)~s', $value)){
$value = str_replace ("#", ":".$key, $value);
$sValues .= $value.',';
}else{
$sValues .= '"'.$value.'",';
}
}
}
$sKeys = substr($sKeys, 0, strlen($sKeys)-1);
$sValues = substr($sValues, 0, strlen($sValues)-1);
return array ($sKeys, $sValues);
}
?>