How to build PHP MySQL directory website?

Question

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.

Answer 1

You should check the php documentation for help with programming it to handle mysql querys



More help:

http://www.freewebmasterhelp.com/tutorials/phpmysql/

http://www.weberdev.com/

http://www.phpfreaks.com/

Answer 2

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

Answer 3

If you already have MySQL and PHP installed and configured, get ADOdb for PHP ( http://adodb.sourceforge.net/ ). 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();

}

Answer 4

what u want to do is simple database i/o, a goot tutorial can be foud on http://www.php-mysql-tutorial.com/

Answer 5

First you can visit http://www.w3schools.com to be good on PHP

then you can visit http://www.hotscripts.com to get a script for your need then change on to meet your need