| 12
 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