Hi I need to data search by php

Expand Post »

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

Similar Threads

mysql search and display data help.... in MySQL
Making Search Engin using PHP & MySQL to search in DB in PHP
search and results question. in PHP
Filtering My sql through Php using drop down menu and text field in PHP
bringing data from mysql using select box in PHP

afrojazad

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Sep 2008

Permalink

Dec 29th, 2008

Re: Hi I need to data search by php

Click to Expand / Collapse Quote 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.

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.

ashafaaiz

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

20 posts
since Dec 2008

Permalink

Jan 2nd, 2009

I need to data search by php

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

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Sep 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: php contact form help needed plz

Next Thread in PHP Forum Timeline: The Most Secure Way Encrypt and Protect Strings

DaniWeb Message

Cancel Changes

User Name
Password