Website Database? Help

P45

n00b
Joined
Nov 27, 2008
Messages
11
Okay basically I want to have my friend punch in some items they have and I want the results to show up on a list and see if its ALSO possible to search for results such as:

who wants A & has B ?

I know how to build websites but I have no idea how to have users sumbit information and that information to be stored so if you guys could point me in the correct direction I'd be really grateful. Thank you: Oh here is a diagram of something I sort of want:


xdt5w4.jpg
 
You will want to read up on HTML forms for submitting your data to your server. Then you can use PHP on the back end to submit data to your database. I would start by reading up on HTML forms and PHP forms (google it). Work on submitting your page and using PHP to print your input to the screen. Once you get that working you can then look into storing your data in a database.
 
you're right on the money Nick !

This is what I was looking for. I spent a good hour looking at HTML forms and I think i got it down. Now only to submit the info to a database available for users to access :: hmmmm
 
you're right on the money Nick !

This is what I was looking for. I spent a good hour looking at HTML forms and I think i got it down. Now only to submit the info to a database available for users to access :: hmmmm

First, what OS is your web server running, Linux, Windows? I'm going to assume Linux and if this assumption is correct then you should look into MySQL. Before doing that you will need to create a database and add tables to it. I'm running a development box using Ubuntu. I use MySQL Administrator to create users for my data base. Then I use MySQL Query Browser to create tables and test queries.

Here's what I would look into next,
1) MySQL - specifically create databases in MySQL. This includes understanding relational databases and how to create tables based on similar/related data. Depending on your needs this can be very simple or very complex.
2) Understand how the structured query language works such as inserting, selecting, updating and deleting data inside a database

Once you have a database created you should practice writing code to insert data. Then work on selecting the data and lastly displaying the data on your page.
 
Back
Top