Hi all,
I have tried this for a very long time. But i could not found out the error. This should suppose to retrieve data when a user enters particular Account Number. But always an empty form displays...:-(
<?php
$connect=mysql_connect('localhost','root','');
mysql_select_db('bank',$connect);
if( isset($_POST['account_number']) && !empty($_POST['account_number']) ){
exit();
}
?>
<form method="post" action="modify_data.php">
<div>Enter Account Number:
<input type="text" name="account_number" value="" />
<input type="submit" value="Submit"/>
</div>
</form>modify_data.php
<form name="form1" action="approve_data.php">
<fieldset>
<legend class="cap">Customer details</legend>
<table width="75%" border="0" cellspacing="0" cellpadding="5" align="center">
<?php
//initilize variables
$full_name = '';
$name_with_initials = '';
$phone_number = '';
$address = '';
$gender = '';
$date_of_birth = '';
$account_type = '';
$fd_period = '';
$sql =sprintf("SELECT account_details. full_name,phone_number,address,gender,date_of_birth,account.name_with_initials,account_type,fd_period"." FROM account_details LEFT JOIN account"." ON account_details.`account_number`='%s'", mysql_real_escape_string($_POST['account_number']) );
$result=mysql_query($sql) or die( mysql_error() );
if( mysql_num_rows($result)<1 )
{
echo "<p>No records found.</p>";
}
$query="select * from account LEFT JOIN account_details ON account.account_number = account_details.account_number";
$result = mysql_query($query) or die(mysql_error());
while ($row=mysql_fetch_array($result)){
// replace blank variables with variables from the database
$full_name = $row['full_name'];
$name_with_initials = $row['name_with_initials'];
$phone_number = $row['name_with_initials'];
$address = $row['address'];
$gender = $row['gender'];
$date_of_birth = $row['date_of_birth'];
$account_type = $row['account_type'];
$fd_period = $row['fd_period'];
}
?>
<tr>
<td> </td>
<td class="title02"> </td>
<td> </td>
<td> </td>
</tr>
<tr height="30">
<td width="10%"> </td>
<td width="25%" class="title02" align="left">Full name</td>
<td width="55%" class="attribute1" align="left"><label>
<input type="text" name="full_name" value="<?php echo $row['full_name']; ?>" class="attribute1" />
</label></td>
<td width="10%"> </td>
</tr>
<tr height="30">
<td> </td>
<td class="title02" align="left">Name with initials</td>
<td class="attribute1" align="left"><input type="text" name="name_with_initials" value="<?php echo $row['name_with_initials']; ?> " class="attribute1" /></td>
</tr>
<tr height="30">
<td width="10%"> </td>
<td width="25%" class="title02" align="left">Phone Number</td>
<td width="55%" class="attribute1" align="left"><label>
<input type="text" name="phone_number" value="<?php echo $row['phone_number']; ?>" class="attribute1" />
</label></td>
<td width="10%"> </td>
</tr>
<tr height="30">
<td width="10%"> </td>
<td width="25%" class="title02" align="left">Address</td>
<td width="55%" class="attribute1" align="left"><label>
<textarea name="address" id="textarea" <?php echo $row['address']; ?> cols="45" rows="5"></textarea>
</label></td>
<td width="10%"> </td>
<tr height="30">
<td> </td>
<td class="title02" align="left">Gender</td>
<td class="attribute1" align="left"><label>
<select name="gender" id="select">
<option selected="selected"><?php echo $row['gender']; ?></option>
<option value="male">Male</option>
<option value="female">Female</option>
</select>
</label></td>
<tr height="30">
<td> </td>
<td class="title02" align="left">Date of birth</td>
<td class="attribute1" align="left"><input type="Text" id="demo3" name="date_of_birth" value="<?php echo $row['date_of_birth']; ?>" maxlength="25" size="25"/><img src="../images/cal.gif" onClick= "javascript:NewCssCal('demo3','yyyyMMdd')" style="cursor:pointer"/> </td>
</tr>
<tr height="30">
<td width="10%" height="41"> </td>
<td width="25%" class="title02" align="left">Account Type</td>
<td width="65%" align="left" bgcolor="#FFFFFF" class="attribute1">
<select name="account_type" onChange="fd_show(this.value)">
<option selected="selected"><?php echo $row['account_type']; ?></option>
<option value="savings_investment">Savings Investment</option>
<option value="shakthi" >Shakthi</option>
<option value="surathal">Surathal</option>
<option value="abhimani_plus">Abhimani Plus</option>
<option value="yasasa">Yasasa Certificates</option>
<option value="fd">Fixed Deposits</option>
</select> </td>
<tr height="30">
<td colspan="4">
<div id="fd_box" style="visibility: hidden;">
<table width="100%" border="0" cellspacing="0" cellpadding="5" align="center">
<tr height="30"> </tr>
<tr height="30">
<td width="10%"></td>
<td width="25%" class="title02" align="left">FD period</td>
<td width="55%" class="attribute1" align="left"><select name="fd_period">
<option selected="selected"><?php echo $row['fd_period']; ?></option>
<option value="< 1">less than 1 year</option>
<option value="1-3 years" >1-3 years</option>
<option value="> 3">more than 3 years</option>
<option value="il">immediate loan</option>
</select></td>
<td width="10%"></td>
</tr>
<tr height="1"></tr>
<tr height="30"></tr>
</table>
<tr height="30">
<td> </td>
<td width="25%" class="title02" align="left"> </td>
<td width="55%" align="left" bgcolor="#FFFFFF" class="attribute1"> </td>
</table>
<p align="center"> </p>
<p align="center">
<a href="approve_data.php">
<label>
<input type="submit" name="button2" id="button2" value="Modify" />
</label></a>
<label>
<input type="submit" name="button2" id="button2" value="Help" />
</label>
</p>
</fieldset>
</td>
</table>
</form>
