PDA

View Full Version : Newbie Database advice please


gemini
10-7-05, 04:31 PM
Newbie Database advice please.

this is what I want to achieve

to build a simple online database and allow people to search my database online from a webpage:

e.g search field 'type of dog'

user enters 'b'

and have the results shown of all dogs that begin with the letter 'b' in a simple html page



how can I produce a: such a database and b: a searchable and results html



any help for a newbie to databases would be of great help

Zacarias
10-7-05, 04:37 PM
You'll probably want to get a basic background of php.. I bought a book recently... here.

http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764557440.html

gemini
10-7-05, 05:29 PM
even what i want it simple, is what I am thinking of doing past a beginners grasp?

satis
10-7-05, 06:10 PM
there's probably more to it than you may realize. You have to set up a database and then set up a page to grab a visitor's query, strip it of any bad stuff, then run it against the database, and finally output the result to a webpage.

Honestly, it's not THAT difficult, but if you don't have any background in php or databases, you've got a bit of a learning curve to fight up. still, something that simple would be a really great way to start to learn the languages.

There are some really great newbie tutorials for php online. Here's an example, but there are tons more if you don't like this one.

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