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
|
<?php
include ('connect.php');
$ip = $_POST['ip'] ;
$q1_reponse1 = $_POST['q1_reponse1'];
$q1_reponse2 = $_POST['q1_reponse2'];
$q1_reponse3 = $_POST['q1_reponse3'];
$q1_reponse4 = $_POST['q1_reponse4'];
$q2_reponse1 = $_POST['q2_reponse1'];
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Erreur de connection à Mysql');
mysql_select_db($dbname);
$sql1 = "INSERT INTO enquete_user (user_id, date, ip)"
."VALUES ('', NOW(), '$ip')";
mysql_query($sql1) or die('Erreur SQL !'.$sql1.'<br>'.mysql_error());
$user_id = mysql_insert_id();
$sql2 = "INSERT INTO question1 (q1_id, q1_reponse1, q1_reponse2, q1_reponse3, q1_reponse4, user_id)"
."VALUES ('', '$q1_reponse1', '$q1_reponse2', '$q1_reponse3', '$q1_reponse4', '$user_id')";
mysql_query($sql2) or die('Erreur SQL !'.$sql2.'<br>'.mysql_error());
$user_id = mysql_insert_id();
$sql3 = "INSERT INTO question2 (q2_id, q2_reponse1, user_id)"
."VALUES ('', '$q2_reponse1', '$user_id')";
mysql_query($sql3) or die('Erreur SQL !'.$sql3.'<br>'.mysql_error());
?> |
Partager