Php,database,XAMPP

this will be the index

<html>

<body>

<table style="color:purple;border-style:groove; height:150px;width:350px" background="backimage.jpg">
<tr>
<td style=" height:25px; font-family:'Copperplate Gothic Bold'"> td>
tr>
<tr>
<td style="color:red;background-color:aqua;height:25px">Enter Account no
<input name="name" id="name" type="text"/>td>
tr>
<tr>
<td style="height:25px">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 >

<tr>

tr>

<tr>

<td style="color:red;background-color:aqua;" class="auto-style3">Account no:td>

tr>

<tr>

<td style="color:red;background-color:aqua;" class="auto-style3">Titletd>

tr>

<tr>

<td style="color:red;background-color:aqua;" class="auto-style3">FirstName:td>

tr>

<tr>

<td style="color:red;background-color:aqua;" class="auto-style3">Surname:td>

tr>

<tr>

<td style="color:red;background-color:aqua;" class="auto-style3">Address Line 1:td>

tr>

<tr>

<td style="color:red;background-color:aqua;" class="auto-style3">Address Line 2:td>

tr>

<tr>

tr>

<tr>

<td style="color:red;background-color:aqua;" class="auto-style3">Country:td>

tr>

<tr>

tr>

<tr>

<td style="color:red;background-color:aqua;" class="auto-style3">Contact Number:td>

tr>

<tr>

<td style="color:red;background-color:aqua;" class="auto-style3">Email Address:td>

tr>

<tr>

tr>

<tr>

<td style="color:red;background-color:aqua;" class="auto-style3">Balance:td>

<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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Renzo Royce10y ago
hey bro I dont know how to use asp.net. do you have php only?

Amit Kumar Singh10y ago

hey,

Let's try this.....we do in asp.net .......

Add one from

.html page

1.Create table

Page 1 Content

Page 2 Content

2.On Page _Load

Page1.visible=true;

Page2.visible=false;

3.On Button Submit

Page1.visible=false;

Page2.visible=true;