|
Server IP : 172.16.15.8 / Your IP : 3.144.21.206 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home/kakaragiorgis/public_html/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<BODY>
<CENTER><h2>Insert Record Results</h2></center>
<hr>
<?php
$Pname = $_POST['Pname'];
$Cname = $_POST['Cname'];
$Link = $_POST['Link'];
$priority = $_POST['priority'];
$S1 = $_POST['S1'];
$S2 = $_POST['S2'];
$S3 = $_POST['S3'];
$S4 = $_POST['S4'];
$S5 = $_POST['S5'];
$S6 = $_POST['S6'];
$S7 = $_POST['S7'];
$S8 = $_POST['S8'];
$S9 = $_POST['S9'];
$S10 = $_POST['S10'];
$S11 = $_POST['S11'];
$S12 = $_POST['S12'];
$S13 = $_POST['S13'];
$S14 = $_POST['S14'];
$S15 = $_POST['S15'];
$S16 = $_POST['S16'];
$S17 = $_POST['S17'];
$S18 = $_POST['S18'];
$S19 = $_POST['S19'];
$S20 = $_POST['S20'];
$S21 = $_POST['S21'];
$S22 = $_POST['S22'];
$S23 = $_POST['S23'];
$S24 = $_POST['S24'];
$S25 = $_POST['S25'];
$S26 = $_POST['S26'];
$S27 = $_POST['S27'];
$S28 = $_POST['S28'];
$S29 = $_POST['S29'];
$S30 = $_POST['S30'];
$S31 = $_POST['S31'];
$S32 = $_POST['S32'];
$S33 = $_POST['S33'];
$S34 = $_POST['S34'];
$S35 = $_POST['S35'];
$S36 = $_POST['S36'];
$S37 = $_POST['S37'];
$S38 = $_POST['S38'];
$S39 = $_POST['S39'];
$S40 = $_POST['S40'];
$S41 = $_POST['S41'];
$S42 = $_POST['S42'];
$S43 = $_POST['S43'];
$S44 = $_POST['S44'];
$S45 = $_POST['S45'];
$S46 = $_POST['S46'];
$S47 = $_POST['S47'];
$S48 = $_POST['S48'];
$menu = array('Frontal Headache', 'Back of the Head', 'Side of
the Head', 'Top of the Head', 'Pain in the eye', 'Jaw', 'Toothache',
'Ear', 'Neck', 'Shoulder',
'Wrist', 'Hand', 'Backache', 'Hip', 'Knee', 'Ankle', 'Foot', 'Sore
throat', 'Sinusitis', 'Loss of Voice',
'Earaches', 'Allergy', 'Anxiety attacks and Nervousness', 'Depression',
'Insomnia', 'Fainting', 'Hiccoughs',
'Memory and Concentration issues', 'Angina', 'Palpitations',
'High Blood Pressure Treatments', 'Constipation', 'Diarrhea',
'Heartburn',
'Stomachache', 'PMS and painful periods', 'Hot Flashes', 'Acupressure
during Pregnancy', 'Bed Wetting',
'Incontinence', 'Urinary Retention', 'Weight Loss', 'Nose Bleeding',
'Allergy', 'Itching', 'Asthma', 'Decreased
Libido', 'Hangover Treatment');
// if(count($index) ==0) // no checked
// echo "Please go back <A HREF=insert.php>
// to select a symptom</A>.";
// else
// { echo "<BR>Your symptom(s) are: <p>";
// $i=0;
// foreach ($index as $item)
// {
// $cond = "$menu[$item]"; $sym[$i]=$cond; $i++;
// echo "$cond <br>";
// }
// //echo "<hr>";
// }
$host = 'localhost';
$user = 'kakaragiorgis';
$pass = 'cs480';
$database = 'kakaragiorgis';
$connect = mysqli_connect($host, $user, $pass);
$table_name = 'Symptom';
$query = "insert into $table_name values ('$Pname','$Cname',
'$Link',
'$S1', '$S2', '$S3', '$S4', '$S5', '$S6', '$S7', '$S8', '$S9', '$S10',
'$S11', '$S12', '$S13', '$S14', '$S15', '$S16', '$S17', '$S18', '$S19',
'$S20', '$S21', '$S22', '$S23', '$S24', '$S25', '$S26', '$S27', '$S28',
'$S29', '$S30', '$S31', '$S32', '$S33', '$S34', '$S35', '$S36', '$S37',
'$S38', '$S39', '$S40', '$S41', '$S42', '$S43', '$S44', '$S45', '$S46',
'$S47', '$S48', '$priority')";
$query1 = "select * from $table_name";
// debug
print "The query is <i> $query </i>";
mysqli_select_db($connect, $database);
$results_id = mysqli_query($connect, $query);
$results_id1 = mysqli_query($connect, $query1);
if($results_id)
print "Insert Succussful. <P>";
else
print "Insert failed.<P>";
if($results_id1)
{ // p.178
print "<table border=1>";
print "<th>Point Name<th>Chinese Name<th>Link";
while($row=mysqli_fetch_row($results_id1))
{ print "<tr>";
foreach ($row as $field) print
"<td>$field</td>";
print "</tr>";
}
}
else echo ( "Search failed");
mysqli_close($connect);
?>
<a href="insert.php">Back to insert another record?.</a><br>
<a href="acupressureindex.html">Back to the home page.</a>
</BODY>