<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("mysql", $con);
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("mysql", $con);
//$sql="select * from accountdtl";
$result = mysql_query("select * from accountdtl where account_no='$_POST[name]'");
while($rowval = mysql_fetch_array($result))
{
$accountnumber= $rowval['account_no'];
$title= $rowval['title'];
$fname= $rowval['fname'];
$lname= $rowval['lname'];
$add1= $rowval['address1'];
$add2= $rowval['address2'];
$town= $rowval['town'];
$country= $rowval['country'];
$pin= $rowval['pcode'];
$mob= $rowval['con_no'];
$mailid= $rowval['mail_id'];
$uname= $rowval['uname'];
$balance= $rowval['balance'];
}
mysql_close($con);
?>
<html>
<body>
<from >
<table style="color:purple;border-style:groove; height:150px;width:350px" background="3.jpg">
<tr>
<td style="font-family:Copperplate Gothic Bold"> </td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">Account no:</td>
<td class="auto-style4">
<input id="Text1" type="text" value='<?php echo $accountnumber; ?>'/></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">Title</td>
<td class="auto-style4">
<input id="Text2" type="text" value='<?php echo $title; ?>'/></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">FirstName:</td>
<td class="auto-style4">
<input id="Text3" type="text" value='<?php echo $fname; ?>' /></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">Surname:</td>
<td class="auto-style4">
<input id="Text4" type="text" value='<?php echo $lname; ?>' /></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">Address Line 1:</td>
<td class="auto-style4">
<input id="Text5" type="text" value='<?php echo $add1; ?>' /></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">Address Line 2:</td>
<td class="auto-style4">
<input id="Text6" type="text" value='<?php echo $add2; ?>' ></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">Town:</td>
<td class="auto-style4">
<input id="Text7" type="text" value='<?php echo $town; ?>'/></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">Country:</td>
<td class="auto-style4">
<input id="Text8" type="text" value='<?php echo $country; ?>' /></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">Post Code:</td>
<td class="auto-style4">
<input id="Text9" type="text" value='<?php echo $pin; ?>'/></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">Contact Number:</td>
<td class="auto-style4">
<input id="Text10" type="text" value='<?php echo $mob; ?>'/></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">Email Address:</td>
<td class="auto-style4">
<input id="Text11" type="text" value='<?php echo $mailid; ?>'/></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">User Name:</td>
<td class="auto-style4">
<input id="Text12" type="text" value='<?php echo $uname; ?>'/></td>
</tr>
<tr>
<td style="color:red;background-color:aqua;" class="auto-style3">Balance:</td>
<td>
<input id="Text13" type="text" value='<?php echo $balance; ?>' /></td>
</tr>
<tr>
<td></td>
</tr>
</table>
</form>
</body>
</html>