Current location: Hot Scripts Forums » Programming Languages » PHP » Help using PHP to query MySQL Database


Help using PHP to query MySQL Database

Reply
  #1 (permalink)  
Old 01-27-10, 11:24 PM
gmawright gmawright is offline
New Member
 
Join Date: Jan 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Help using PHP to query MySQL Database

I own a company that impounds vehicles that are not properly parked, and I tow vehicles damaged in accidents. I am looking to give customers and insurance companies the ability to go to my website and enter various details about the vehicle (year, make, model, color, last six of VIN, date range picked up, etc..) and have this search the database of vehicles that we have entered. The information would need to be rendered on their screen and preferably have a built-in calculator (to calculate the daily fees plus the pick-up fee), giving the customer real-time pricing information. Could someone please point me in the right direction? I'm sure this is a very common request and I apologize in advance for my lack of knowledge in how to do this!

:-) All help is appreciated! :-)
Reply With Quote
  #2 (permalink)  
Old 01-28-10, 09:04 AM
carters-site's Avatar
carters-site carters-site is offline
Wannabe Coder
 
Join Date: Sep 2009
Location: Moline, IL
Posts: 100
Thanks: 2
Thanked 1 Time in 1 Post
While I do not think this project itself is hard..
It storage of data in a database and then retrieved. That does not make it any less of a small project for someone.

I am not sure what your technical level is as far as programming but you are basically going to want to

Insertion
Build a HTML form with at minimal textfields you want to store into the data base the one you listed.
Build a PHP file that will take the form data and use a MySQL Insert Syntax to add it to the database.

Search
Build a HTML form with fields you would like to search on
Build a PHP file that will take the search fields and use the SELECT Syntax to get results.
(Probably using the like '%input%' in the where for best results.)

I found this link has some basic code to get you going.
Reply With Quote
  #3 (permalink)  
Old 01-28-10, 05:37 PM
wirehopper's Avatar
wirehopper wirehopper is offline
-
 
Join Date: Feb 2006
Posts: 2,515
Thanks: 20
Thanked 109 Times in 106 Posts
You might want to consider a content management system (CMS).

The CMS Matrix - cmsmatrix.org - The Content Management Comparison Tool
Reply With Quote
Reply

Bookmarks

Tags
database, mysql, php, query, search


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
PHP and MySQL ? rob2132 Hot Scripts Forum Questions, Suggestions and Feedback 4 08-29-08 02:22 AM
PHP MySQL Database Managers? ibzi PHP 1 07-10-05 08:24 AM
Complex mysql sorting pb (Get cat_list from cids &pcids with 1 query, willing to pay) aqw PHP 1 06-23-05 07:02 PM
How to get PHP to input data into a MYSQL table? scl789 PHP 5 04-21-05 09:06 PM
PHP script to modify MySQL Database Diviance Script Requests 3 08-25-04 12:31 PM


All times are GMT -5. The time now is 08:09 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.