Page 1 of 1

display data directly into forms using php(data retrived fro

Posted: Thu Jul 09, 2009 10:54 am
by csakthikumar
GUYS i want to display data into forms which includes buttons,text box and list box using php where data is retrived from mysql db

i just want to retrieve the datas already stored in db and make it editable..


please help.........


below is my php file i wnt to retrieve data back into this form itself ..........from mysql db

Code: Select all

 
 
 
 
<form name="form1" id="form1" method="post" action="l.php">
 
 
 
<b>
PATIENT NAME
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
 
<input name="pat_patname"  id="pat_patname" type="text">
 
&nbsp&nbsp&nbsp
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp DATE: &nbsp&nbsp 
<?php
$d=date("d/m/y");
echo $d;
?>
<br>
    <br>ADDRESS<br>
&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
 
<TEXTAREA name="pat_address" id="pat_address" cols="17" rows="6">
</textarea>
 
<BR>
<BR>
CITY/TOWN &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
<input  name="pat_city" id="pat_city" type="text">
&nbsp&nbsp&nbsp&nbsp&nbsp <br><br>
STATE&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
<select name="pat_state" id="pat_state"  >
        <option value="AP">AP</option>
        <option value="UP">UP</option>
        <option value="TN">TN</option>      
        <option value="MP">MP</option>
        <option value="JK">JK</option>
        <option value="KR">KR</option>
        <option value="KL">KL</option>
        <option value="AS">AS</option>
    </select>
    <br><br>
    AGE&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
    <select name="pat_age"  id="pat_age">
        <option value="1">1</option>
        <option value="2">2</option>
        <option value="3">3</option>        
        <option value="4">4</option>
        <option value="5">5</option>
        <option value="6">5</option>
        <option value="7">7</option>
        <option value="8">8</option>
    </select>
    &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp &nbsp&nbsp
    &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
    
    
    <br><br>SEX&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
    <INPUT type="radio" name="pat_sex" value="Male" checked> Male
     &nbsp&nbsp&nbsp
     <INPUT type="radio" name="pat_sex" value="Female"> Female<BR><BR>
    CONTACT NUMBER &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
<input name="pat_contactno" name="pat_contactno" type="text">
    <BR>
<BR>
    REFERENCE DETAILS &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
    <input name="refr" type="text">
    <BR>
<BR>
    INSURANCE DETAILS
    <BR><br>
INSURANCE PROVIDER &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
<select name="inpro"  >
<option value="NULL">-NIL-</option>
        <option value="STAR">STAR</option>
        <option value="LIC">LIC</option>
        <option value="HDFC">HDFC</option>      
        <option value="AXIS">AXIS</option>
            </select>
            &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp INSURANCE ID &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp
    <input name="inid" type="text">     
    <br><br><br>
    <center><input name="save" type="submit" id="save" value="Save">&nbsp
        
    <INPUT type="RESET">&nbsp
    <input type="button" value="Back" >&nbsp</center>
    
    
            
</form>