-
Notifications
You must be signed in to change notification settings - Fork 0
/
questioninfo.php
41 lines (33 loc) · 1.25 KB
/
questioninfo.php
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
$username = 'contwzvk_honey';
$database = 'contwzvk_Survey';
$localhost = 'localhost';
$password = 'rocking_143';
//$con = mysqli_connect('localhost', $username, $password, $database);
$link = mysql_connect($localhost, $username, $password);
$db_selected = mysql_select_db($database, $link);
if (!$db_selected) {
die ('Can\'t use foo : ' . mysql_error());
}
// $surveyID = '1';
// $qID = '2';
// $qTitle = 'How is my pic';
// $maxOptions = '4';
$request = file_get_contents('php://input');
$input = json_decode($request,true);
$surveyID = $input['surveyID'];
$qID = $input['qID'];
$qTitle = $input['qTitle'];
$options = $input['options'];
$maxOptions = $input['maxOptions'];
$query = "INSERT INTO QuestionInfo VALUES ('$surveyID', '$qID', '$qTitle', '', '$maxOptions')";
mysql_query($query) or die("error");
//$resultArray['status'] = '800';
for ($x = 0; $x < sizeof($options); $x++) {
$query = "INSERT INTO OptionsInfo VALUES ('$surveyID', '$qID', '$options[$x]', '$x + 1', '')";
mysql_query($query) or die("error");
$resultArray['status'] = '800';
}
//$resultArray['surveyID'] = $surveyID;
echo json_encode($resultArray);
?>