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....

Recommended Answers

All 3 Replies

Can you try to explain with an example? This is a little vague.

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>

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....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.