DaniWeb Forum Index > Web Development > PHP

Hi I need to data search by php

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2008

Posts: 2

Reputation: afrojazad is an unknown quantity at this point

Solved Threads: 0

afrojazad

Offline

Newbie Poster

Hi I need to data search by php

Dec 28th, 2008

Hi, I need mysql data searchin by php. But do not complete the data view smothly. so, pls help me.
my data wiew now:
Name: Mobile Blood City Donation date
Sinha 01912266936 A+ Dhaka 9-10-2008
Munna 01917755515 A+ Dhaka 0-0-0000

I want to view my data like this.
Name: Sinha Name: Azad
Mobile: 01912266936 Mobile: 01712266936
Blood Group: A+ Blood Group: A+
City: Dhaka City: Dhaka
Donation Date : 12-12-2007 Donation Date : 12-12-2007

Name: Shamim Name: Karim
Mobile: 01912266936 Mobile: 01712266936
Blood Group: A+ Blood Group: A+
City: Dhaka City: Dhaka
Donation Date : 12-12-2007 Donation Date : 12-12-2007
Previous>>1 2 3 4 <<Next
you can see my website also.
www.bloodfoundationbd.com
Thanks
Azad

afrojazad

•

Join Date: Dec 2008

Posts: 19

Reputation: ashafaaiz is an unknown quantity at this point

Solved Threads: 1

ashafaaiz

Offline

Newbie Poster

Re: Hi I need to data search by php

Dec 29th, 2008

•

Originally Posted by afrojazad

Hi, I need mysql data searchin by php. But do not complete the data view smothly. so, pls help me.
my data wiew now:
Name: Mobile Blood City Donation date
Sinha 01912266936 A+ Dhaka 9-10-2008
Munna 01917755515 A+ Dhaka 0-0-0000

I want to view my data like this.
Name: Sinha Name: Azad
Mobile: 01912266936 Mobile: 01712266936
Blood Group: A+ Blood Group: A+
City: Dhaka City: Dhaka
Donation Date : 12-12-2007 Donation Date : 12-12-2007

Name: Shamim Name: Karim
Mobile: 01912266936 Mobile: 01712266936
Blood Group: A+ Blood Group: A+
City: Dhaka City: Dhaka
Donation Date : 12-12-2007 Donation Date : 12-12-2007
Previous>>1 2 3 4 <<Next
you can see my website also.
www.bloodfoundationbd.com
Thanks
Azad

Hi,
I think you have retrieved the data from database. Then no problem, you should design the html form using tables and display whatever you want.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?
//made database connections here
?>
<form>
<table>
<?
$q1=musql_query("select * from <tablename>");
while($row=mysql_fetch_array($q1))
{
?>
<tr>
<td>Name</td><td><? echo $row['Name']; ?></td>
</tr>
<tr>
<td>Mobile</td><td><? echo $row['Mobile']; ?></td>
</tr>
<tr>
<td>Blood Group</td><td><? echo $row['Bloodgroup']; ?></td>
</tr>
<tr>
<td>City</td><td><? echo $row['City']; ?></td>
</tr>
<tr>
<td>Donation</td><td><? echo $row['Donation']; ?></td>
</tr>
<?
}
?>
</table></form>
<?
//made database connections here
?>
<form>
<table>
<?
$q1=musql_query("select * from <tablename>");
while($row=mysql_fetch_array($q1))
{
?>
<tr>
<td>Name</td><td><? echo $row['Name']; ?></td>
</tr>
<tr>
<td>Mobile</td><td><? echo $row['Mobile']; ?></td>
</tr>
<tr>
<td>Blood Group</td><td><? echo $row['Bloodgroup']; ?></td>
</tr>
<tr>
<td>City</td><td><? echo $row['City']; ?></td>
</tr>
<tr>
<td>Donation</td><td><? echo $row['Donation']; ?></td>
</tr>
<?
}
?>
</table></form>

i hope it works.

Last edited by peter_budo; Dec 29th, 2008 at 5:48 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Sep 2008

Posts: 2

Reputation: afrojazad is an unknown quantity at this point

Solved Threads: 0

afrojazad

Offline

Newbie Poster

I need to data search by php

Jan 2nd, 2009

Thank you. I do not want to searh result in sigle colum I want 2 colum with limit.

the page like
Name: Name:
Mobile: Mobile:

<<<Previous 1 | 2 | 3 next>>>

afrojazad