HeavyRain asked:
I’m new to PHP MySQL .I need to build a site listing URL of sites in my town.I’ve populated the data.My problem is how can i make use of php mysql inorder to add data and a user be able to retrieve data on a key word search to my site.any step by step help appreciated.
I’m new to PHP MySQL .I need to build a site listing URL of sites in my town.I’ve populated the data.My problem is how can i make use of php mysql inorder to add data and a user be able to retrieve data on a key word search to my site.any step by step help appreciated.


5 Comments to 'How to build PHP MySQL directory website?'
February 15, 2009
You should check the php documentation for help with programming it to handle mysql querys
More help:
February 15, 2009
first get EASY-PHP . it install appache ( web server), + the php component + the mysql database. then learn “html” ( it’s easy to learn with google )…. then learn php. then learn mysql (google). then create a simple mysql database and add the websites urls. the create an html page (main page) with an empty field and a button that link to a php file ( that send the info typed by the user to the php file ) then the php file you’ve created specially to query your database will generate the result page… then find a web server and buy a dns. and you’re done … it seems to be long but it’s not that bad …
February 15, 2009
First you can visit to be good on PHP
then you can visit to get a script for your need then change on to meet your need
February 17, 2009
If you already have MySQL and PHP installed and configured, get ADOdb for PHP ( ). Read the instructions on how to use it. a simple connection looks something like this:
include(’../includes/adodb/adodb.inc.php’);
$db = ADONewConnection(’mysql’);
$db->Connect(’localhost’, ‘username’, ‘password’, ‘database’);
$db->SetFetchMode(ADODB_FETCH_ASSOC);
$sql = “SELECT * FROM table_sites”;
$record_set=$db->Execute($sql);
while ( !$record_set->EOF) {
echo $record_set->Fields[business_name] . ” ” . $record_set->Fields[phone number] . “”;
$rs_soldiers->MoveNext();
}
February 19, 2009
what u want to do is simple database i/o, a goot tutorial can be foud on
Leave a comment