How would I do this?
I need some way of letting users upload info onto a webpage and then being able to add/delete that info when needed.
I am guessing that i will probably need to use MySQL or access and php?
Unfortunatly i dont know anything about mysql or php, but i am good with access.
kb posted this at 19:40 — 26th June 2003.
He has: 1,380 posts
Joined: Feb 2002
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.
ShaneS posted this at 04:17 — 27th June 2003.
They have: 93 posts
Joined: Jun 2003
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.
[Design Alpha] -Web Services : Design,Hosting,Advertising,Software
Ask about custom pricing on hosting!!
Site Assets: [UltraGaming.com] [Blades of Warcraft]
kb posted this at 16:15 — 27th June 2003.
He has: 1,380 posts
Joined: Feb 2002
lol thanks alot...i am new to PHP and MySQL myself...lol
ShaneS posted this at 16:46 — 27th June 2003.
They have: 93 posts
Joined: Jun 2003
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.
[Design Alpha] -Web Services : Design,Hosting,Advertising,Software
Ask about custom pricing on hosting!!
Site Assets: [UltraGaming.com] [Blades of Warcraft]
go2jacks posted this at 09:48 — 28th June 2003.
They have: 20 posts
Joined: Jun 2003
Hi,
Thanks alot for everyones help. I'll let you know how i get on!
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.