Get an error in html form while saving data in PHP.I want that when i view a patient it takes his id and store it in the history table where i am inserting data for medical history.It just inserting the patient id not the history in the database
<!– [if lt IE 7 ]> <![endif]–>
<!– [if IE 7 ]> <![endif]–>
<!– [if IE 8 ]> <![endif]–>
<!– [if (gte IE 9)|!(IE)]>>–> <!–
<!– Basic Page Needs
================================================== –>
Hospital Records
<!– Mobile Specific Metas
================================================== –>
<!– CSS
================================================== –>
<!– [if lt IE 8]>–>
<!– [if lt IE 9]>–>
<!–////////////////////////////////////Header–>
[email protected]
80 88888 7
<a href=”index.php”>Home</a>
<a href=”testpatient.php”>Register Patient</a>
<a>Settings</a>
<a>Log Out</a>
<!–Start Box–>
Patient Id
Patient Name
Address
Gender
Date Of Birth
Add Medical History
<?php echo” <a>Add History</a>”; ?>
<!– [if lt IE 7 ]> <![endif]–>
<!– [if IE 7 ]> <![endif]–>
<!– [if IE 8 ]> <![endif]–>
<!– [if (gte IE 9)|!(IE)]>>–> <!–
<!– Basic Page Needs
================================================== –>
Hospital Records
<!– Mobile Specific Metas
================================================== –>
<!– CSS
================================================== –>
<!– [if lt IE 8]>–>
<!– [if lt IE 9]>–>
form.register{
width:800px;
margin: 20px auto 0px auto;
height:530px;
background-color:#fff;
padding:5px;
-moz-border-radius:20px;
-webkit-border-radius:20px;
}
form p{
margin: 0;
color: #666;
font-size: 10pt;
clear:both;
padding:4px;
font-weight: bold;
}
form.register fieldset.row1
{
width:770px;
padding:5px;
float:left;
border-top:1px solid #F5F5F5;
margin-bottom:15px;
}
form.register fieldset.row1 label{
width:140px;
float: left;
text-align: right;
margin-right: 6px;
margin-top:2px;
}
form.register fieldset.row2
{
border-top:1px solid #F1F1F1;
border-right:1px solid #F1F1F1;
height:1000px;
width:330px;
padding:5px;
float:left;
}
form.register fieldset.row3
{
border-top:1px solid #F1F1F1;
border-right:1px solid #F1F1F1;
height:800px;
width:400px;
padding:5px;
float:left;
}
form.register legend
{
color: #00FFFF;
padding:2px;
margin-left: 14px;
font-weight:bold;
font-size: 18px;
font-weight:200;
text-decoration: underline;
}
form.register label{
color:#444;
width:130px;
float: left;
text-align: right;
margin-right: 6px;
margin-top:2px;
}
form.register label.optional{
float: left;
text-align: right;
margin-right: 6px;
margin-top:2px;
color: #A3A3A3;
}
form.register label.obinfo{
float:right;
padding:3px;
font-style:italic;
}
form.register input{
display:block;width:90%;border-radius:4px;-webkit-border-radius:4px;-moz-border-radius:4px; color:#000; border:1px solid #5f5f5f;padding:10px;margin: 5px 0 25px 0;
}
form.register input.long{
width: 150px;
color: #505050;
}
form.register input.short{
width: 200px;
color: #505050;
}
form.register input[type=radio]
{
float:left;
width:15px;
}
form.register input[type=text]
{
border: 1px solid #E1E1E1;
height: 18px;
}
form.register input[type=password]
{
border: 1px solid #E1E1E1;
height: 18px;
}
.button
{
background: #00FFFF url(../img/overlay.png) repeat-x;
padding: 8px 10px 8px;
color: #00FFFF;
text-decoration: none;
-moz-border-radius: 5px;
-webkit-border-radius: 5px;
-moz-box-shadow: 0 1px 3px rgba(0,0,0,0.5);
-webkit-box-shadow: 0 1px 3px rgba(0,0,0,0.5);
text-shadow: 0 -1px 1px rgba(0,0,0,0.25);
cursor: pointer;
float:left;
font-size:18px;
margin:200px;
}
form.register input[type=text].year
{
border: 1px solid #E1E1E1;
height: 18px;
width:30px;
}
form.register input[type=checkbox] {
width:14px;
margin-top:4px;
}
form.register select
{
border: 1px solid #E1E1E1;
width: 85px;
float:left;
margin-bottom:3px;
color: #505050;
margin-right:5px;
}
form.register select.date
{
width: 50px;
}
input:focus, select:focus{
background-color: #efffe0;
}
p.info{
font-size:7pt;
color: gray;
}
p.agreement{
margin-left:15px;
}
p.agreement label{
width:390px;
text-align:left;
margin-top:3px;
}
#dialogoverlay{
display: none;
opacity: .8;
position: fixed;
top: 0px;
left: 0px;
background: #FFF;
width: 100%;
z-index: 10;
}
#dialogbox{
display: none;
position: fixed;
background: #000;
border-radius:7px;
width:550px;
z-index: 10;
}
#dialogbox > div{ background:#FFF; margin:8px; }
#dialogbox > div > #dialogboxhead{ background: #ff0000; font-size:19px; padding:10px; color:#CCC; }
#dialogbox > div > #dialogboxbody{ background:#333; padding:20px; color:#FFF; }
#dialogbox > div > #dialogboxfoot{ background: #666; padding:10px; text-align:right; }
<!–////////////////////////////////////Header–>
[email protected]
80 88888 7
<a href=”index.php”>Home</a>
<a href=”testpatient.php”>Register Patient</a>
<a href=”contact.html”>Settings</a>
<!–Start Box–>
Patient Medical History
Patient Visit Reason
Vitals
Bp Systolic
Bp Diastolic
Temperature/°C
Respiratory Rate/(breaths/m)
Add Symptom
Symptom Title
Symptom:
Prescription
Drug Name
Strength
Direction For Use
Quantity
Treatment Details
Vitals
Pulse/Bpm
Weight/Kg
Height/Cm
Diagnosis
Diagnosis Title
Diagnosis
Add Test
Test Name
Test Details
upload
<?php echo” <a>Add History</a>”; ?>
<a href=”view.php”>CANCEL</a>
<!– [if lt IE 7 ]> <![endif]–>
<!– [if IE 7 ]> <![endif]–>
<!– [if IE 8 ]> <![endif]–>
<!– [if (gte IE 9)|!(IE)]>>–> <!–
<!– Basic Page Needs
================================================== –>
Hospital Records
<!– Mobile Specific Metas
================================================== –>
<!– CSS
================================================== –>
<!– [if lt IE 8]>–>
<!– [if lt IE 9]>–>
#dialogoverlay{
display: none;
opacity: .8;
position: fixed;
top: 0px;
left: 0px;
background: #FFF;
width: 100%;
z-index: 10;
}
#dialogbox{
display: none;
position: fixed;
background: #000;
border-radius:7px;
width:550px;
z-index: 10;
}
#dialogbox > div{ background:#FFF; margin:8px; }
#dialogbox > div > #dialogboxhead{ background: #ff0000; font-size:19px; padding:10px; color:#CCC; }
#dialogbox > div > #dialogboxbody{ background:#333; padding:20px; color:#FFF; }
#dialogbox > div > #dialogboxfoot{ background: #666; padding:10px; text-align:right; }
Patient Registration
<!–Start Box–>
<?php
$Reason=isset($_POST[“reason”]);
$Bpsys=isset($_POST[“Bpsys”]);
$Bpdia=isset($_POST[“Bpdia”]);
$temp=isset($_POST[“temp”]);
$pulse=isset($_POST[“pulse”]);
$resp=isset($_POST[“resp”]);
$weight=isset($_POST[“weight”]);
$height=isset($_POST[“height”]);
$symp=isset($_POST[“symp”]);
$sym=isset($_POST[“sym”]);
$diag=isset($_POST[“diag”]);
$diags=isset($_POST[“diags”]);
$pres=isset($_POST[“pres”]);
$stren=isset($_POST[“stren”]);
$direc=isset($_POST[“direc”]);
$qty=isset($_POST[“qty”]);
$treat=isset($_POST[“treat”]);
$test=isset($_POST[“test”]);
$testdet=isset($_POST[“testdet”]);
//sql insert statement-record saving in my database
$sql=”INSERT INTO history (Reason,Bpsys,Bpdia,Temp,Pulse,Resp,Weight,Height,Symp,Sym,Diag,Diags,Dname,Stren,Direc,Qty,Treat,Tname,Tdet) VALUES (‘$Reason’,’$Bpsys’,’$Bpdia’,’$temp’,’$pulse’,’$resp’,’$weight’,’$height’,’$symp’,’$sym’,’$diag’,’$diags’,’$pres’,’$stren’,’$direc’,’$qty’,’$treat’,’$test’,’$testdet’)”;
$result2 = mysql_query($sql) or die(‘Query failed: ‘ .mysql_error());
echo ‘Thank you for ADDING ! ‘;
?>
i have a table patient in database(patienttbl),then i have a history table in database. When a doctor view his patient he has a button beside each patient where he can add patient medical history.I want that when the doctor add the history,it stores the patient id also in the history table.so as to know which table history belongs to which patient.
You have to create a form and under that form you can pass the data to the file where you are getting the form data. And thats it.
Thanx