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 Quote 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. Quote 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] Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.