god_zun Posted September 5, 2008 Share Posted September 5, 2008 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 Link to comment https://forums.phpfreaks.com/topic/122919-how-to-edit-info-on-sql-table-via-php-form/ Share on other sites More sharing options...
.josh Posted September 5, 2008 Share Posted September 5, 2008 If I understand you correct, you're lookin' to just do some Basic Database Handling. Link to comment https://forums.phpfreaks.com/topic/122919-how-to-edit-info-on-sql-table-via-php-form/#findComment-634883 Share on other sites More sharing options...
DarkWater Posted September 5, 2008 Share Posted September 5, 2008 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] Link to comment https://forums.phpfreaks.com/topic/122919-how-to-edit-info-on-sql-table-via-php-form/#findComment-634894 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.