How to build PHP MySQL directory website?
-
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:
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/
HeavyRai... at Yahoo! Answers Visit the source
Other answers
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.p… $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(); }
John A
what u want to do is simple database i/o, a goot tutorial can be foud on http://www.php-mysql-tutorial.com/
B1t Hunt3r
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
IraqiHaider
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 ...
the_manutor
Related Q & A:
- How to arbitrariarly sort MySQL result set?Best solution by Stack Overflow
- How to do a MySQL recursive query?Best solution by Stack Overflow
- How to connect to mysql in MapReduce temporarily?Best solution by Stack Overflow
- How to install PHP 4.4 on Ubuntu?Best solution by Ask Ubuntu
- How to make a MySql query faster?Best solution by Stack Overflow
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.