1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88
|
if($form->errors()) {
//print_r($form->errors());
echo '<pre>';
echo $form->messages();
echo '</pre>';
}
else
{
// Prepare the request
$sql_user ='INSERT into users (
id_user,
roles_id_role,
user_email,
user_mdp,
user_active,
user_create,
user_lastlogin,
user_failedlogin
)VALUES (
"",
"'.$roles.'",
"'.$email.'",
"'.$pwd_h.'",
"0",
"'.gmdate("Y-m-d H:i:s").'",
"0000-00-00 00:00:00",
"0"
);';
echo '<pre>';
print_r($sql_user);
echo '</pre>';
try{
if (!$connect->query($sql_user) )
{
echo "<h4>ERROR user</h4>";
echo $connect->error;
$lastUser_inserted = 0;
exit();
}
else
{
$lastUser_inserted = $connect->insert_id;
}
}catch(Exception $e){
echo 'Exception reçue : ', $e->getMessage(), "\n";
}
// echo $lastUser_inserted;
foreach ($field as $key => $values) {
$sql_fields = 'INSERT into fields_has_users {
fields_id_field,
users_id_user
}VALUES{
"'.$values.'",
"'.$lastUser_inserted.'"
};';
echo '<pre>';
print_r($sql_fields);
echo '</pre>';
try{
if (!$connect->query($sql_fields) )
{
echo "<h4>ERROR fields</h4>";
echo $connect->error;
exit();
}
}catch(Exception $e){
echo 'Exception reçue : ', $e->getMessage(), "\n";
}
}
echo '<h3>Saved</h3>';
} |
Partager