Jump to content

How to Edit Info on SQL Table Via PHP Form?


god_zun

Recommended Posts

Hi,

 

I am new on here and need help the coding of a script for my project.

 

Just to give you an exact description of what I want to accomplish:

 

I work in the merchant processing industry and I have coded a table in which my co-worker will be able to enter in shipping information for credit card terminals via a form..(the fields are: tracking number, date, merchant, status). All of this information is then transferred and stored on a table named SHIPPING on a SQL database. Obviously the status information will always be changing, so I need a way in which the status can also be edited via a form. For example the status will need to be changed from shipped to delivered, or shipped to cancelled or many other changes. I need the edit to take effect on the SHIPPING table in which the information is stored.

 

Here is the function I pretty much need

 

If this information is entered into a form....

 

Tracking #: 123456789

Date:9/5/2008

Merchant:Burgers 'R' Us

Status:Shipped

 

.....Now lets say 10 minutes later that the status is now delivered. I will need a way to come back to that exact Merchant(Burgers 'R' Us) via a form and change the status to Delivered so everyone will be able to view it on the database.

 

I need a direction to go in and would appreciate any assistance or tips on how to accomplish this. If any additional info is needed or I need to be clearer ...please let me know. I want to make this as simple as possible since this is an in-house service that will be used and viewed by only 3 people.

 

Thank's

 

Yeah, read that tutorial first.  To elaborate a bit on what you actually need to apply:

 

[ul]

  • You'll need a primary key on the SHIPPING table
  • You'll need to create a page that loops through all the entries and displays them in a useful manner, and provides links to the editing page
  • The editing page receives the ID in the URL, and processes from there.

[/ul]

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.