Post
Ask Question
Renzo Royce

Renzo Royce

  • NA
  • 26
  • 5.6k

Php,database,XAMPP

Feb 12 2016 11:04 PM

 this will be the index

<html>

<body>

<form action="search.php" method="post">

<table style="color:purple;border-style:groove; height:150px;width:350px" background="backimage.jpg">
<tr>
<td style=" height:25px; font-family:'Copperplate Gothic Bold'">&nbsp;</td>
</tr>
<tr>
<td style="color:red;background-color:aqua;height:25px">Enter Account no&nbsp;&nbsp;&nbsp;&nbsp;
<input name="name" id="name" type="text"/></td>
</tr>
<tr>
<td style="height:25px">nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="submit" value="Submit" style="color:white;background-color:brown; height:30px"/></td>

</tr>

</table>

</form>

</body>

</html>

 
 
 this will be the 2nd page

<?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">&nbsp;</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>

 my question is how can i do this or how can i display the data in a single page only cause this code wil open the first page for me to input the account no and then display the other information to the second page, how can i do it in a single page only? 

Answers (2)