[SOLVED] trying to populate fields with values from db...

rsammy · July 20, 2006

Hi,

I am trying to populate some fields on screen with values from db. i wrote the query and tested it out in MySQL and it works fine. it returns the necessary records. only, when i use the same query in my code, just the label names print on screen and no values for them.

here is the code... I am not sure where exactly the problem is, so am attaching the entire code for this page here.

<?PHP

//File for database information

//require_once ("phpInclude/config.php");
require_once ("../config.php");

//File to verify authenticated user

include ("phpInclude/cookie.php");

if (isset($USER_NAME))

{

list($user_fname, $user_lname) = explode (' ', $USER_NAME);

$pat_ID=$_POST["pat_ID"];
if ($USER_NAME == ' Office Manager')
{
$query= "SELECT grp_name FROM group_details";
}
else
{
$query= "SELECT grp_name FROM group_details, user_mgr WHERE user_mgr.user_fname='$user_fname' AND user_mgr.user_lname='$user_lname' AND user_mgr.user_grp_id=group_details.grp_id";
}
$result=mysql_query($query);

$row = mysql_fetch_array($result);

$group_name = $row["grp_name"];

}

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>

<head>

<title>INSTICOMM</title>

<link rel='stylesheet' type='text/css' href='css/styleSheet.css'>

<SCRIPT language="JavaScript" src="js/tree.js"></script>

<SCRIPT language="JavaScript" src="js/validateSSN.js"></SCRIPT>

<SCRIPT language="JavaScript">

function trim(inputString)
{

// Removes leading and trailing spaces from the passed string. Also

// removes consecutive spaces and replaces it with one space.

var retValue = inputString;

var ch = retValue.substring(0, 1);

while (ch == " ") { // Check for spaces at the beginning of the string

retValue = retValue.substring(1, retValue.length);

ch = retValue.substring(0, 1);

}

ch = retValue.substring(retValue.length-1, retValue.length);

while (ch == " ") { // Check for spaces at the end of the string

retValue = retValue.substring(0, retValue.length-1);

ch = retValue.substring(retValue.length-1, retValue.length);

}

while (retValue.indexOf(" ") != -1) { // Note that there are two spaces in the string - look for multiple spaces within the string

retValue = retValue.substring(0, retValue.indexOf(" ")) + retValue.substring(retValue.indexOf(" ")+1, retValue.length); // Again, there are two spaces in each of the strings

}

return retValue; // Return the trimmed string back to the user

} // Ends the "trim" function

function validate()

{
var err_msg = new Array();

var i=0;

var j=0;

var bigstring = "Please correct the following errors:\n";

var loginID = "";

var pass = "";

var count = 0;

var aMatch = false;

var aBlank = false;

PatientFirstName = document.changeStatus.PatientFirstName.value;

PatientLastName = document.changeStatus.PatientLastName.value;
AdmitStatus = document.changeStatus.AdmitStatus.value;

AdmitLocation = document.changeStatus.AdmitLocation.value;

AdmitRoomNo = document.changeStatus.AdmitRoomNo.value;

PatientCity = document.changeStatus.PatientCity.value;

PatientState = document.changeStatus.PatientState.value;

PatientZip = document.changeStatus.PatientZip.value;

PatientHomePhone = document.changeStatus.PatientHomePhone.value;

PatientDOB = document.changeStatus.PatientDOB.value;

PatientSSN = document.changeStatus.PatientSSN.value;

PatientSex = document.changeStatus.PatientSex.value;

PatientEmergencyContactName= document.changeStatus.PatientEmergencyContactName.value;

PatientEmergencyPhone= document.changeStatus.PatientEmergencyPhone.value;

PatientEmployerPhone = document.changeStatus.PatientEmployerPhone.value;

InsuranceProvider = document.changeStatus.InsuranceProvider.value;

InsuranceID = document.changeStatus.InsuranceID.value;

PatientRelationship = document.changeStatus.PatientRelationship.value;

ClientName = document.changeStatus.ClientName.value;
}

</Script>

<SCRIPT LANGUAGE="JavaScript">


</SCRIPT>

<SCRIPT language="JavaScript">

<?PHP

//Navigation File
require_once ("../nav.php");

?>

</SCRIPT>

<?

$query="

SELECT pat_dgraphics.pat_first_name, pat_dgraphics.pat_mid_init, pat_dgraphics.pat_last_name, pat_dgraphics.pat_home_ph, Date_Format(pat_dgraphics.pat_dob, '%m/%d/%Y') as pat_dob,

pat_dgraphics.pat_ssn, pat_dgraphics.pat_ID, pat_dgraphics.pat_phy_id, Date_Format(pat_dgraphics.pat_reg_date, '%m/%d/%Y') as enter_date, pat_dgraphics.pat_client_id, pat_ins_det.ins_pro,

pat_ins_det.ins_grp_id, Date_Format(admit_stat.admit_visit_date, '%m/%d/%Y') as activate_date, admit_stat.admit_reason, admit_stat.admit_visit_loc, admit_stat.admit_room_no

FROM pat_dgraphics, pat_ins_det, admit_stat where pat_ID='$pat_ID'

";
print ("$pat_ID");
$result=mysql_db_query("$database[dbname]", $query);

$r=mysql_fetch_array($result);

$pat_first_name=$r["pat_first_name"];

$pat_mid_init=$r["pat_mid_init"];

$pat_last_name=$r["pat_last_name"];

$pat_home_ph=$r["pat_home_ph"];

$pat_dob=$r["pat_dob"];

$pat_ssn=$r["pat_ssn"];

$pat_client_id=$r["pat_client_id"];

$pat_phy_id = $r["pat_phy_id"];

$ins_pro = $r["ins_pro"];

$admit_reason = $r["admit_reason"];

$admit_status = $r["admit_status"];
$admit_visit_loc = $r["admit_visit_loc"];
$admit_room_no = $r["admit_room_no"];
$activate_date = $r["$activate_date"];
$enter_date = $r["$enter_date"];

$query ="SELECT * FROM pat_ins_det where ins_pat_id='$pat_ID' ";
$result = mysql_query($query);
$row= mysql_fetch_array($result);
$ins_pro=$row["ins_pro"];
$ins_ref=$row["ins_ref"];
$ins_id=$row["ins_id"];
$ins_grp_id=$row["ins_grp_id"];

$clientquery="SELECT client_name FROM clients WHERE client_id = '$pat_client_id'";
$resultclient= mysql_query($clientquery);
$row=mysql_fetch_array($resultclient);
$client_name=$row["client_name"];

?>

</head>

<BODY onload="window.scroll(0,yoffset)">

<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="4" bgcolor="#FFFFFF">
<div align="left"><font color="#FFFFFF"></font></div>
<div align="right"><font color="#FFFFFF"><img src="images/title_barom.jpg" width="900" height="49"></font></div></td>
</tr>
<tr>
<td align="left" valign="top" width="276"> <table width="276" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top"><div align="center"><img src="../images/clear.gif" height="15" width="1"><font color="#006699"><img src="images/clear.gif" height="15" width="1"><b><?PHP print($group_name); ?><br>
User: </b><?PHP print($USER_NAME); ?> </font></div></td>
</tr>
<tr>
<td align="left" valign="top"> <SCRIPT language="JavaScript">

tree.loadState()

tree.display()

</SCRIPT> </td>
</tr>
</table>

</td>
</a><br>
<br>
</div>
<table width="614" border="1" cellspacing="0" cellpadding="0" align="center" bordercolor="#006699">
<tr>
<td bgcolor="#006699" width="475" height="19"> <div align="left"><b><font color="#FFFFFF">Existing
Patient: Change Patient Information/Status</font></b> </div></td>
</tr>
<tr>
<td> <table width="608" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="3"><img src="../images/clear.gif" width="1" height="15"></td>
</tr>
<tr>
<td width="15"> </td>

<td width="578" rowspan="3" align="left" valign="top"> <form name="changeStatus" method="post" action="updatedStatus.php" onSubmit="return validate()">
<p align="center"><br><b>EXISTING PATIENT INFORMATION</b> <br></p>
<table width="563" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="283"> <div align="right"><font class="inputLbl">
<input type="hidden" name="pat_ID" value="<? print ("$pat_ID"); ?>">
</font></div></td>
<td colspan="2"> </td>
</tr>
<tr>
<td width="283"> <div align="right"><font class="inputLbl">  
</font></div></td>
<td colspan="2"> </td>
</tr>
<tr>
<td width="283"> <div align="right"><font class="inputLbl">First
Name:    </font></div></td>
<td colspan="2"><font class="plnTxtBl" type="text" name="PatientFirstName"><? print ("$pat_first_name"); ?></font>
</td>
</tr>
<tr>
<td width="283"> <div align="right"><font class="inputLbl">Middle
Initial:    </font></div></td>
<td colspan="2"><font class="plnTxtBl"><? print ("$pat_mid_init"); ?></font>
</td>
</tr>
<tr>
<td width="283"> <div align="right"><font class="inputLbl">Last
Name:    </font></div></td>
<td colspan="2"><font class="plnTxtBl"><? print ("$pat_last_name"); ?></font>
</td>
</tr>
<tr>
<td width="283"> <div align="right"><font class="inputLbl">Date
of Birth as mm/dd/yyyy:    </font></div></td>
<td colspan="2"><font class="plnTxtBl"><? print ("$pat_dob"); ?></font>

<script language=javascript>

function validateBDay()
{
var BirthdayDay = document.EditPatInfo.PatientDOB.value;
var bDate = BirthdayDay.split("/");
var bMonth = bDate[0];
var bDay = bDate[1];
var bYear = bDate[2];

var BDate = new Date(bYear, (bMonth - 1), bDay);
var Today = new Date();
TodayDay = Today.getDate();
TodayMon = Today.getMonth()+1;
TodayYear = Today.getYear();
if (TodayYear < 2000) TodayYear += 1900;
//var sysdate = new Date();

if (BDate > Today)
alert("Birthday cannot be greater than today's date");
}

</script></td>
</tr>
<tr>
<td width="283"> <div align="right"><font class="inputLbl">ASN/
SSN as a 9-digit number:    </font></div></td>
<td colspan="2"><font class="plnTxtBl"><? print ("$pat_ssn"); ?></font>
</td>

</tr>
<tr>
<td width="283"> <div align="right"><font class="inputLbl">Home
Phone as 000-000-0000:    </font></div></td>
<td colspan="2"><font class="plnTxtBl"><? print ("$pat_home_ph"); ?></font>
</td>
</tr>
<tr>
<td><div align="right"><font class="inputLbl">Insurance
Provider:   </font></div></td>
<td colspan="2"><font class="plnTxtBl"><? print ("$ins_pro"); ?></font>
</td>
</tr>
</table>

<p align="center"><b>STATUS INFORMATION</b> <br></p>
<table width="562" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="right"><font class="inputLbl">Reason:  </font></div></td>
<td colspan="2"> <input name="reason" type="text" class="txtboxLarge" value="<? if(isset($admit_reason)){print ("$admit_reason"); } ?>" >
<span class="errTxt"> </span></td>
</tr>

<tr>
<td width="283"> <div align="right"><font class="inputLbl">Preferred
Provider:  </font></div></td>
<td colspan="2">
<?PHP

//$query="select phy_id, phy_fname, phy_lname from phy_det order by phy_lname, phy_fname";
$query="select phy_id, phy_fname, phy_lname from phy_det where phy_disabled = 'Enable' order by phy_lname, phy_fname";

$result= mysql_query ($query);

if ($result)
{
print ("<select name='physician'>");

if ($row = mysql_fetch_array($result))
{
do
{
print("<option value=\"");
print $row["phy_id"];
if($pat_phy_id == $row["phy_id"])
{
print("\" selected>");
}
else
{
print("\">");
}
//print $row["phy_fname"]; print (" "); print $row["phy_lname"];
print $row["phy_lname"]; print (", "); print $row["phy_fname"];
print("</option>");
}
while($row = mysql_fetch_array($result));
}
}
print ("</select>");
?>
</td>
</tr>
<tr>
<td><div align="right"><font class="inputLbl">Registered
Client:  </font> </div></td>
<td colspan="2"><? $queryclient="SELECT client_name, client_id FROM clients";
$resultclient= mysql_query($queryclient);

if ($resultclient)
//if (mysql_num_rows($resultclient) != 0)
{
//print ("<select name='client_id'>");
print ("<select name='ClientName'>");
//echo "$row";
if ($row = mysql_fetch_array($resultclient))
{
do
{

print("<option value=\"");
echo $row["client_name"];
if ($row["client_name"]== $client_name)
{
print("\" selected>");
}
else
{
print("\">");
}
print $row["client_name"];
print("</option>");
//}
}

while($row = mysql_fetch_array($resultclient));
}
}
print ("</select>");
//}
?></td>
</tr>
<tr>
<td><div align="right"><font class="inputLbl">Insurance
Ref #:   </font></div></td>
<td colspan="2"><input name="ins_ref" type="text" class="txtboxLarge" id="ins_ref" onBlur="javascript:changeCase(document.EditPatInfo.InsuranceProvider);" value="<? print("$ins_ref"); ?>"></td>
</tr>-->

<tr>
<td width="282"> <div align="right"><font class="inputLbl">Status:    </font></div></td>
<td colspan="2"><input class="txtboxLarge" type="text" name="AdmitStatus" value="<? print ("$admit_status"); ?>">
</td>
</tr>
<tr>
<td width="282"> <div align="right"><font class="inputLbl">Location:    </font></div></td>
<td colspan="2"><input class="txtboxLarge" type="text" name="AdmitLocation" value="<? print ("$admit_visit_loc"); ?>">
</td>
</tr>
<tr>
<td width="282"> <div align="right"><font class="inputLbl">Room#:    </font></div></td>
<td colspan="2"><input class="txtboxLarge" type="text" name="AdmitRoomNo" value="<? print ("$admit_room_no "); ?>">
</td>
</tr>
<tr>
<td width="278"> <div align="right"><font class="inputLbl">Enter Date:    </font></div></td>
<td colspan="2"><font class="plnTxtBl"><? print ("$enter_date"); ?></font></td>
</tr>
<tr>
<td width="278"> <div align="right"><font class="inputLbl">Activate Date:    </font></div></td>
<td colspan="2"><font class="plnTxtBl"><? print ("$activate_date"); ?></font></td>
</tr>
<tr>
<td width="282"> <div align="right"></div></td>
<td width="280"> </td>
</tr>

<tr>
<td width="282"> <div align="right"></div></td>
<td width="280"> <input class="sbttn" type="submit" name="Submit" value="Update">
</td>
</tr>
<tr>
<td width="282"> <div align="right"></div></td>
<td width="280"> </td>
</tr>
</table>
</form>
<p align="center"> </p>
<p align="center"> </p></td>
<td width="15"> </td>
</tr>
<tr>
<td width="15"> </td>
<td width="15"> </td>
</tr>
<tr>
<td width="15" height="478"><img src="../images/clear.gif" width="15" height="8"></td>
<td width="15" height="478"><img src="../images/clear.gif" width="15" height="1"></td>
</tr>
<tr>
<td colspan="3"><img src="../images/clear.gif" width="1" height="15"></td>
</tr>
</table></td>
</tr>
</table>
<p> </p></td>
</tr>
<tr>
<td align="left" valign="top" width="276"> </td>
<td colspan="3" width="624"> </td>
</tr>
</table>

</body>

</html>

<?PHP

mysql_close();

?>

****************************

can someone help me out with this one please?

thanx in advance

Sign In

[SOLVED] trying to populate fields with values from db...

Recommended Posts

rsammy

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information