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
| <?php
$link = mysqli_connect("localhost", "root", "", "maintenance");
/* Vérification de la connexion */
if (mysqli_connect_error()) {
printf("Échec de la connexion : %s\n", mysqli_connect_error());
exit();
//Si action de validation faite
if(isset($_POST["Valider"]))
$index = mysql_real_escape_string($_POST["index"]);
$equipment_name = mysql_real_escape_string($_POST["equipment_name"]);
$location = mysql_real_escape_string($_POST["location"]);
$specification= mysql_real_escape_string($_POST["specification"]);
$date_of_install = mysql_real_escape_string($_POST["date_of_install"]);
$power = mysql_real_escape_string($_POST["power"]);
$time_on = mysql_real_escape_string($_POST["time_on"]);
$time_off = mysql_real_escape_string($_POST["time_off"]);
$consumption = mysql_real_escape_string($_POST["consumption"]);
$temp_use = mysql_real_escape_string($_POST["temp_use"]);
$next_intervention_date = mysql_real_escape_string($_POST["next_intervention_date"]);
$intervention_frequency = mysql_real_escape_string($_POST["intervention_frequency"]);
$query="INSERT INTO 'equipement' ('id', 'index', 'equipment_name', 'location', 'specification' , 'date_of_install', 'power' , 'time_on' , 'time_off' , 'consumption' , 'temp_use' , 'next_intervention_date' , 'intervention_frequency' ) VALUES('', '$index', '$equipment_name','$location','$specification','$date_of_install'.'$power','$time_on','$time_off','$consumption','$temp_use','$next_intervention_date','$intervention_frequency')";
mysql_query($query) or die($query . '<br>' . mysql_error());
mysqli_close($link);
?> |
Partager