-1

hai I want to know the particular field name using search the full word in mysql database and that field name using we want to retrieve the entire table in mysql database....

Next I want to know can we retrieve the php with mysql database in PDF report in front end....

2
Contributors
3
Replies
5
Views
4 Years
Discussion Span
Last Post by raji181
0

THIS IS THE EXAMPLE PGM can u tell me how to correct it...

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<?php
error_reporting(E_ALL ^ E_NOTICE);
$save=$_POST['submit'];
mysql_connect("localhost","root","raji")or die(mysql_error());
mysql_select_db("prescription") or die(mysql_error());
if(isset($save))
{
$result =mysql_query("SELECT PatientName FROM patientdiagnosis WHERE PatientName='$patname'");
echo $result;
if(mysql_num_rows($result)>0)
{
echo "<font color='green'><b><h3>Name Already Exist in Database<h3></b></font>";
$sel=mysql_query("SELECT * from patientdiagnosis where PatientName='$patname'");
echo $sel;
while($arr=mysql_fetch_array($sel))
{
$patname=$arr['PatientName'];
$regno=$arr['RegistrationNo'];
$date=$arr['DiagnosisDate'];
$provdiag=$arr['ProvisionalDiagnosis'];
$language=$arr['language'];
$test=$arr['test'];
$remark=$arr['Remark'];
$redate=$arr['DReconsultation'];
$finaldiagnosis=$arr['FINAL'];
}
}
 }
?>
<body>
<form name='frm' method='post' action='tabretrievesearch.php'>
<span>Enter Patient name</span><input type="text" name="t1" value="">
<input type="submit" name="submit" value="search"><br/>
PatientName:<?php echo $patname;?><br/>
RegistrationNo:<?php echo $regno;?><br/>
Date:<?php echo $date;?><br/>
ProvisionalDiagnosis:<?php echo $provdiag;?><br/>
Language:<?php echo $language;?><br/>
test:<?php echo $test;?><br/>
Remark:<?php echo $remark;?><br/>
ReconsultationDate:<?php echo $redate;?><br/>
FINAL:<?php echo $finaldiagnosis;?>
</body>
</form>
</html>
0

Hai then i want to know how to view d PDF report from MYSQL database...is there any plugin or toolkit is possible..can u specify me d name pls.....

BY RAJI....

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.