Page 1 of 1

prefill form

Posted: Sun Jul 18, 2004 9:24 pm
by g3ckO
How can I fill the form (text field) with data from database.

Code: Select all

<?php
<?

include("database.php");

function get_user()

{ 
   $user = $_POST['user']; 
   $query = "SELECT * FROM employee WHERE username = '$user'";      
   $result = mysql_query($query); 
   $row_array = mysql_fetch_array($result);    
   return $row_array; 
} 

?><font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif"><?

   $row_array=get_user(); 
   $ID=$row_array['username']; 
   $Pass=$row_array['password']; 
   $Access=$row_array['AccType'];
   $Name=$row_array['EmpName'];
   $Birth=$row_array['EmpDOB'];
   $IC=$row_array['EmpIC'];
   $Mobile=$row_array['EmpMobileNO'];
   $House=$row_array['EmpHouseNO'];
   $Address=$row_array['EmpAdd'];
   $Des=$row_array['EmpDes'];
   $Office=$row_array['EmpOffice'];
   $Dept=$row_array['EmpDept'];
   $Unit=$row_array['EmpUnit'];
   $Super=$row_array['EmpSuper'];
   $Ent=$row_array['LeaveEnt'];
   $BF=$row_array['LeaveBF'];
   $Annual=$row_array['LeaveAnn'];
   $Med=$row_array['LeaveMed'];

if(!$_POST['user'])
   {
   	echo"<br><br><br><center><h3>ERROR: No username entered.<h3></center>";
?> 	<form action="viewuser.php" method="post">
   	<center><input type="submit" value="BACK" name="back"></center></form>
<? 	exit();
   }

if(!$row_array)
   {
	echo"<br><br><br><center><h3>ERROR: Username doesn't exist.<h3></center>";
?> 	<form action="viewuser.php" method="post">
   	<center><input type="submit" value="BACK" name="back"></center></form>
<? 	exit();
   }

else
   {
   	
?> 

    <hr>
    <font color="#671247" size="3" face="Verdana, Arial, Helvetica, sans-serif">
    <table border="0" cellspacing="4" cellpadding="0">
    
    <tr><td><b>Username:</td><td><input type="text" name="username" value"<!--[i][b][u]WHAT SHOULD I PUT HERE TO VIEW THE USERNAME FROM DATABASE[/u][/b][/i]-->"</td></tr>
<?
}
?>
?>

Posted: Sun Jul 18, 2004 9:46 pm
by evilmonkey

Code: Select all

<?php echo $username; ?>

Posted: Sun Jul 18, 2004 9:48 pm
by feyd
you'll want a = between the value and it's following quote. ;)

Posted: Sun Jul 18, 2004 10:02 pm
by g3ckO
okay.. :)