<div>
This would depend on how your database is set up. &nbsp;Let's say it's set up like this:<br />
<br />
Persons_table:<br />
int ID<br />
varchar Name<br />
varchar City<br />
<br />
You would make an SQL call with PHP like this:<br />
<br />
$q = 'select `Name` from `Persons_table` where `City` = &quot;Canton&quot;';<br />
mysql_query($q);<br />
<br />
To get people within 5 miles of that city, you would have to find what cities are within 5 miles of that city. &nbsp;To do this, you might need to have a zip code for your user. &nbsp;See this application for an example of how it might work:<br />
<br />
<a href="http://www.zip-codes.com/zip-code-radius-finder.asp?zipMilesLow=5&zipMilesHigh=5&zip1=44714&Submit=Search" rel="ugc">http://www.zip-codes.com/zip-code-radius-finder.asp?zipMilesLow=5&zipMilesHigh=5&zip1=44714&Submit=Search</a>
</div>


This would depend on how your database is set up.  Let's say it's set up like this:

Persons_table:
int ID
varchar Name
varchar City

You would make an SQL call with PHP like this:

$q = 'select `Name` from `Persons_table` where `City` = "Canton"';
mysql_query($q);

To get people within 5 miles of that city, you would have to find what cities are within 5 miles of that city.  To do this, you might need to have a zip code for your user.  See this application for an example of how it might work:

http://www.zip-codes.com/zip-code-radius-finder.asp?zipMilesLow=5&zipMilesHigh=5&zip1=44714&Submit=Search [http://www.zip-codes.com/zip-code-radius-finder.asp?zipMilesLow=5&zipMilesHigh=5&zip1=44714&Submit=Search]

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I just want to ask how difficult it is to make a search using php ...<br />
<br />
<br />
for example , for a dating site it it should return the people that are in the given city and the the people who live 5 km away form that given city .<br />
<br />
is it difficult to make ? is there any tutorial for it or ...<br />
<br />
thank you
</div>
</div>


Hello,

I just want to ask how difficult it is to make a search using php ...


for example , for a dating site it it should return the people that are in the given city and the the people who live 5 km away form that given city .

is it difficult to make ? is there any tutorial for it or ...

thank you

php Search

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.