1 2 3 4 5 6 7 8 9 10 11 12 13
| $insertSQL = sprintf("INSERT INTO agent (Nom, Prenom, Age, Niveau, Experience, Destination, Datearriv, Presence, Photo, Numcate) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
GetSQLValueString($_POST['nom'], "text"),
GetSQLValueString($_POST['prenom'], "text"),
GetSQLValueString($_POST['age'], "int"),
GetSQLValueString($_POST['niveau'], "text"),
GetSQLValueString($_POST['experience'], "text"),
GetSQLValueString($_POST['destination'], "text"),
GetSQLValueString($_POST['datearriv'], "date"),
GetSQLValueString(isset($_POST['Presence']) ? "true" : "", "defined","'Y'","'N'"),
GetSQLValueString($_POST['photo'], "text"),
GetSQLValueString($_POST['NumCat'], "int"));
mysql_select_db($database_connection, $connection); |
Partager