Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 9 of 9
  1. #1
    New to the CF scene
    Join Date
    Feb 2009
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Question Trying to create a searchable database

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

    Karyn

  • #2
    Master Coder
    Join Date
    Apr 2003
    Location
    in my house
    Posts
    5,211
    Thanks
    39
    Thanked 201 Times in 197 Posts
    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.

    bazz
    "The day you stop learning is the day you become obsolete"! - my late Dad.

    Why do some people say "I don't know for sure"? If they don't know for sure then, they don't know!
    Useful MySQL resource
    Useful MySQL link

  • #3
    New to the CF scene
    Join Date
    Feb 2009
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts
    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.

  • #4
    Master Coder
    Join Date
    Apr 2003
    Location
    in my house
    Posts
    5,211
    Thanks
    39
    Thanked 201 Times in 197 Posts
    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

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

    hth

    bazz
    "The day you stop learning is the day you become obsolete"! - my late Dad.

    Why do some people say "I don't know for sure"? If they don't know for sure then, they don't know!
    Useful MySQL resource
    Useful MySQL link

  • Users who have thanked bazz for this post:

    karyn627 (02-21-2009)

  • #5
    Master Coder
    Join Date
    Apr 2003
    Location
    in my house
    Posts
    5,211
    Thanks
    39
    Thanked 201 Times in 197 Posts
    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.

    bazz
    "The day you stop learning is the day you become obsolete"! - my late Dad.

    Why do some people say "I don't know for sure"? If they don't know for sure then, they don't know!
    Useful MySQL resource
    Useful MySQL link

  • #6
    New to the CF scene
    Join Date
    Feb 2009
    Posts
    6
    Thanks
    1
    Thanked 0 Times in 0 Posts
    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.

  • #7
    Master Coder
    Join Date
    Apr 2003
    Location
    in my house
    Posts
    5,211
    Thanks
    39
    Thanked 201 Times in 197 Posts
    Thats OK,

    Come back again when you have more questions.

    bazz
    "The day you stop learning is the day you become obsolete"! - my late Dad.

    Why do some people say "I don't know for sure"? If they don't know for sure then, they don't know!
    Useful MySQL resource
    Useful MySQL link

  • #8
    New to the CF scene
    Join Date
    Nov 2012
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    No need to code

    Actually it is not necessary to setup mysql. There is already SaaS solutions in the web. For example, mytaskhelper.com, where you can easily create searchable database.

    It has Free account.

    Hope it helps!

  • #9
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,133
    Thanks
    75
    Thanked 4,338 Times in 4,304 Posts
    Please don't reply to threads that are 3 years old.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •