-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathconnection_page.php
79 lines (73 loc) · 5.26 KB
/
connection_page.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
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
<?php
include 'db_connection.php';
if(isset($_REQUEST))
{
$conn = OpenCon();
echo "Connected Successfully";
// Family level details.
$inputFlatNumber = $_POST['inputFlatNumber'];
$inputAddress = $_POST['inputAddress'];
$inputAddress2 = $_POST['inputAddress2'];
$inputCity = $_POST['inputCity'];
$inputZip = $_POST['inputZip'];
$inputFamilyPhoneNumber = $_POST['inputFamilyPhoneNumber']; // PK
$inputFamilyWhatsAppNumber = $_POST['inputFamilyWhatsAppNumber'];
$sql = "INSERT INTO temp(inputFlatNumber,inputAddress,inputAddress2,inputCity,inputZip,inputFamilyPhoneNumber,inputFamilyWhatsAppNumber) VALUES ('$inputFlatNumber', '$inputAddress', '$inputAddress2', '$inputCity', '$inputZip', '$inputFamilyPhoneNumber', '$inputFamilyWhatsAppNumber')";
$result = mysqli_query($conn,$sql);
if($result) {
echo "Family details have been appended successfully.";
} else echo mysqli_error($conn);
// Family member specific details
// Count of the total number of family members.
$extraPersonCount = $_POST['extraPersonCount'];
for ($extraPersonIndex = 0; $extraPersonIndex < $extraPersonCount; $extraPersonIndex++) {
$inputName = ($extraPersonIndex == 0) ? $_POST['inputName'] : $_POST['inputName'.$extraPersonIndex];
$inputAge = ($extraPersonIndex == 0) ? $_POST['inputAge'] : $_POST['inputAge'.$extraPersonIndex];
$inputGender = ($extraPersonIndex == 0) ? $_POST['gender'] : $_POST['gender'.$extraPersonIndex];
$inputPhoneNumber = ($extraPersonIndex == 0) ? (isset($_POST['inputPhoneNumber']) ? $_POST['inputPhoneNumber']:"") : (isset($_POST["inputPhoneNumber".$extraPersonIndex]) ? $_POST["inputPhoneNumber".$extraPersonIndex] : "");
$inputWhatsAppNumber = ($extraPersonIndex == 0) ? (isset($_POST['inputWhatsAppNumber']) ? $_POST['inputWhatsAppNumber']:""): (isset($_POST['inputWhatsAppNumber'.$extraPersonIndex]) ? $_POST['inputWhatsAppNumber'.$extraPersonIndex] : "");
$otherDiseases = ($extraPersonIndex == 0) ? $_POST['otherDiseases'] : $_POST['otherDiseases'.$extraPersonIndex];
$inputOtherHealthIssue = ($extraPersonIndex == 0) ? (isset($_POST['inputOtherHealthIssue']) ? $_POST['inputOtherHealthIssue'] : "" ): (isset($_POST['inputOtherHealthIssue'.$extraPersonIndex]) ? $_POST['inputOtherHealthIssue'.$extraPersonIndex] : "" );
$diseases = ($extraPersonIndex == 0) ? ( isset( $_POST['diseases']) ? $_POST['diseases']:[]) : (isset($_POST['diseases'.$extraPersonIndex]) ? $_POST['diseases'.$extraPersonIndex] :[] );
$pregnantWoman = 0;
$diabetes = 0;
$hypertension = 0;
$tuberculosis = 0;
$cancer = 0;
$dialysis = 0;
$stroke = 0;
$hivPositive = 0;
$organTransplant = 0;
foreach ($diseases as $key => $value) {
if($value == "pregnantWoman") $pregnantWoman = 1;
else if($value == "diabetes") $diabetes = 1;
else if($value == "hypertension") $hypertension = 1;
else if($value == "tuberculosis") $tuberculosis = 1;
else if($value == "cancer") $cancer = 1;
else if($value == "dialysis") $dialysis = 1;
else if($value == "stroke") $stroke = 1;
else if($value == "hivPositive") $hivPositive = 1;
else if($value == "organTransplant") $organTransplant = 1;
}
$sql = "INSERT INTO family_member_table(inputName, inputAge, inputGender, inputPhoneNumber, inputWhatsAppNumber, otherDiseases, inputOtherHealthIssue, inputFamilyPhoneNumber, pregnantWoman, diabetes, hypertension,tuberculosis, cancer, dialysis, stroke, hivPositive, organTransplant) VALUES ('$inputName', '$inputAge', '$inputGender', '$inputPhoneNumber', '$inputWhatsAppNumber', '$otherDiseases', '$inputOtherHealthIssue', '$inputFamilyPhoneNumber', '$pregnantWoman', '$diabetes', '$hypertension', '$tuberculosis', '$cancer', '$dialysis', '$stroke', '$hivPositive', '$organTransplant')";
$result = mysqli_query($conn,$sql);
if($result) {
echo "Family member details have been appended successfully.";
} else echo mysqli_error($conn);
}
// Household help specific details
// Count of household helps.
$extraHouseHelpCount = $_POST['extraHouseHelpCount'];
for($extraHouseHelpIndex = 0; $extraHouseHelpIndex < $extraHouseHelpCount; $extraHouseHelpIndex++){
$inputNameHouseholdHelp = $extraHouseHelpIndex == 0 ? (isset($_POST['inputNameHouseholdHelp']) ? $_POST['inputNameHouseholdHelp'] : "" ): (isset($_POST['inputNameHouseholdHelp'.$extraHouseHelpIndex]) ? $_POST['inputNameHouseholdHelp'.$extraHouseHelpIndex] : "");
$inputPhoneNumberHouseholdHelp = $extraHouseHelpIndex == 0 ? (isset($_POST['inputPhoneNumberHouseholdHelp']) ? $_POST['inputPhoneNumberHouseholdHelp']: "") : (isset($_POST['inputPhoneNumberHouseholdHelp'.$extraHouseHelpIndex]) ? $_POST['inputPhoneNumberHouseholdHelp'.$extraHouseHelpIndex] : "");
$inputAddressHouseholdHelp = $extraHouseHelpIndex == 0 ? (isset($_POST['inputAddressHouseholdHelp']) ? $_POST['inputAddressHouseholdHelp'] : "") : (isset($_POST['inputAddressHouseholdHelp'.$extraHouseHelpIndex]) ? $_POST['inputAddressHouseholdHelp'.$extraHouseHelpIndex] : "");
$sql = "INSERT INTO household_help_table(inputFamilyPhoneNumber, inputNameHouseholdHelp,inputPhoneNumberHouseholdHelp,inputAddressHouseholdHelp) VALUES ('$inputFamilyPhoneNumber', '$inputNameHouseholdHelp', '$inputPhoneNumberHouseholdHelp', '$inputAddressHouseholdHelp')";
$result = mysqli_query($conn, $sql);
if($result) {
echo "Household help details appended successfully";
}else echo mysqli_error($conn);
}
}
CloseCon($conn);
?>