View Full Version : Trying to create a searchable database

02-21-2009, 06:09 AM
Hi everyone...

First of all, I will say that I'm good with HTML and a little java, but I've never really worked with PHP or MYSql. The more research I do, I'm figuring out that I need PHP and MYSql for what I want to do.

I'm trying to create a database with the following fields: state, price, item

Then I want to create a search form on my website with the following search areas:
Location (drop down box with states)
Price (drop down box with "up to $10,000", "up to $25,000", "up to $50,000", "up to $100,000", and "any price")
Item (drop down box with 7 different items)

In the database, each item will have an i.d. number. Then, when the user searches, I want a picture displayed with the price and location. The picture will be clickable to take the user to the info sheet.

Is there an easy way to do this? Thanks in advance for any input!!!


02-21-2009, 07:41 AM
welcome to CF, Karyn.

Yes there is a way to do it. have you got any of the db built yet? if so, please post us your 'create table' statements so we can see the structure you plan to work with.


02-21-2009, 05:20 PM
No, I haven't built any of it yet, because I'm really not sure where to start. From what you are saying, I guess the database is where to start, lol. Like I said, I really don't have any experience with MySQL or PHP. Do I just create the database in an Excel file? Or what is the easiest program to use? I will need to add to it often.

02-21-2009, 07:06 PM
I read about this just, the other day.

It was suggested that you should make a website in your chosen server-side language (php/perl etc), and when you hav a graso of that, there start into mysql where you can integrate it into your php.

You will need mysql and php/perl installed on your server and most isp's do this by default.
You will need a program on the server like phpMyAdmin which will let you administer/create/manage the db OR, something like heidisql, which you should d'l to your computer. it then connects to your db online.

Steep learning curve ahead of you but it's all relative in terms of difficulty. some people find php difficult others mysql, almost everybody finds perl difficult to begin with but (I think), it's very good.

perl coders are the ones with a bulge on the froint of their heads from where they have been banging it off the desk for so long :D

look up in your fav search engine:
'create a table' and what a 'create table' statement is.
'data types' for the columns in your db tables
'select statements'
'sql injection'
'table constraints'
'referential integrity'

(all are search terms)

Playing' with phpMyAdmin should get you started in terms of how tbales are set up (from a db admin perspective). Don't forget that if learning is unstructured, you will get into bad habits which likely will affect the security of your database.



02-21-2009, 07:07 PM
Oh-h-h, to answer you actual question ;) you can build the data in an excel spreadsheet. then export it as a csv file (comma separated variable) and upload it to the server where your db is. then you can 'import' it to the db using phpMyAdmin/heidisql 'import' feature.


02-21-2009, 07:46 PM
Thank you for all your help! My hosting site is IX hosting, which does have all of the above. I just basically needed some sort of shove in the right direction of how to get started with this, lol.

02-21-2009, 07:49 PM
Thats OK, :)

Come back again when you have more questions.


11-05-2012, 05:29 PM
Actually it is not necessary to setup mysql. There is already SaaS solutions in the web. For example, mytaskhelper.com (http://mytaskhelper.com), where you can easily create searchable database.

It has Free account.

Hope it helps!

Old Pedant
11-06-2012, 03:59 AM
Please don't reply to threads that are 3 years old.