go2jacks — Sat, 28 Jun 2003 09:48:34 +0000

Hi,

Thanks alot for everyones help. I'll let you know how i get on!

ShaneS — Fri, 27 Jun 2003 16:46:44 +0000

It alright I wasn't being mean. Just if he goes to read up on MySQL there refer to columns, rows, record sets, column types etc.

Im not perfect with it either. But after spending hours on IRC in #PHP and #MySQL I learned you need to use proper or interchangable terminology or you get no where fast.

brady.k — Fri, 27 Jun 2003 16:15:52 +0000

Quote: Eskater05's termonology is not that great to follow, but the basic concepts are correct

lol thanks alot...i am new to PHP and MySQL myself...lol

ShaneS — Fri, 27 Jun 2003 04:17:49 +0000

the MySQL is not nessary, your could do it with a deliminated text file. However, most hosts provide you with a database option, 70% of the time MySQL. I would suggest that method as well.

Eskater05's termonology is not that great to follow, but the basic concepts are correct.

Dpending on if you chose to usa for processor or just learn the $_POST[] value of php, and if you learn the 4 basic MySQL functions or use a DB object like PEAR will depend on how complex in nature but versital it can be.

Here are steps needed without going into coding details:
Create a MySQL Table with the proper column/field names and type you will need. (http://www.mysql.com/ , http://www.mysql.com/doc/en/Column_types.html )

Create an HTML form with the HTML form field you will need with the buttons and a hidden field called form_submit with a value of 1

Make a new file, this will be your PHP
file. In it you will need to have your database connection lines, an if/elseif/else series to check it the form was sbumited or not. An area to insert the data into the database (via Insert the first time around, and Update the second[this would be in your SQL query]). Then an if banch to detect if it is an update and for what user the update is for.

All in all your talking a form that would take and experienced programmer maybe an hour to create at most.

Give it a shot might take you a good week to make it, but once you learn the concepts it is well worth it. I started out making my first form a littler over a year ago. Now I programming CMS and other things.

brady.k — Thu, 26 Jun 2003 19:40:38 +0000

MySQL/PHP

make a form, that has the ability to overwrite the previously input data (i.e. Name, Address, etc.). Call this their "User Profile Page" or something, and when they goto it, they fill out what they want to change and submit. The PHP then submits each filled in field to the corresponding place in a MySQL DB table and overwrites the previous data or creates a new place. PHP form processors should be ok for this, and just create a different MySQL variable for each field.