Ejemplo update sql php

First, create a database named crud. In the crud database, create a table called info. The info table should have the following columns:. Just two fields. I'm trying to keep things simple here. Doesn't look like the best form in the world right? Let's fix that. Thats the link to load styling from the stylesheet file.

Let's create the styles. I consider that good practice. At this point, all that this code does is connect to the database, initialize some variables and saves submitted data from the form to the database in the info we created earlier. Let's proceed with the others. This code displays a confirmation message to tell the user that a new record has been created in the database.

To retrieve the database records and display them on the page, add this code immediately above the input form:. Now we move onto editting.

At the top of your index. When editting a database record, we need to put the old values in the form so that they can be modified. Also add a hidden field to hold the id of the record we will be updating so that it can be recognized in the database uniquely by it's id. This explains it better:. Now if we click on the edit button on a particular record from the database, the values will be filled in the form and we will be able to edit them. Since we are editing on the same form as when we are creating, we have to put a condition that determines the appropriate button to be displayed.

For example, when editing, we display the update button on the form and when creating, we display the save button. We do this using the update variable which is boolean.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.

Asked 10 years, 8 months ago. Active 7 years, 2 months ago. Viewed 74k times. Improve this question. Juan Mellado Add a comment. Active Oldest Votes. Improve this answer. Here you go, now you have Don't thank me, just accept the answer so the question could be marked as solved.

You messed up on your ". Fahim Faysal Fahim Faysal 4 4 silver badges 6 6 bronze badges. Sign up or log in Sign up using Google.