PHP Lesson 40 – Adding, Deleting, Updating, and Displaying Records from a MySQL Database



Link for code: https://lecturesnippets.com/mydata5/
In this lesson I continue the PHP code from Lesson 39 allowing for an empty row of text boxes that have an add button to insert a new record into the MySQL database. So now the records are displayed in an HTML table, in text boxes, with an update and delete button that controls each individual record and at the end of the list of records is a row to add a new record all from the same web page.

This video is part of a series on PHP Development. This PHP Development series is designed to teach both current and new programmers web development techniques in a step-by-step guided approach. Any images used are part of the Creative Commons License. For more information visit Lecture Snippets at http://lecturesnippets.com.

23 thoughts on “PHP Lesson 40 – Adding, Deleting, Updating, and Displaying Records from a MySQL Database

  1. Thank you so MUCH! You have been a huge help. I am finishing up my degree and PHP has been a little struggle understanding my instructor. You made things so much simpler to understand. Keep up the teaching 🙂

  2. Finally, I have found what I am looking for…Your code and everything works!!!! Great Job, someone that knows what they are talking about. I have learned so much from your tutorials, keep up the good work hope to see more from you. I am going to recommend your channel to all my programmer chicks.

  3. Hi, is it possible to insert in a row of data that is shown in the table, into another table? In my case, I have a 'insert' button for each table row. But the problem is SQL statements do not have the 'Where' clause, therefore i cannot link each insert button to the 'hidden' text

  4. It seems like … if this code:
    echo "<form action= 'PHP Lesson 40 – Adding, Deleting, Updating, and Displaying Records from a MySQL Database.php' method='post'>";
    is written without the 'abc.php' and 'post' , then browsers won't take this file into consideration, and the output will be URL problem, I guess this line of code has to be obey the html / 5 syntax rule.

Leave a Reply

Your email address will not be published. Required fields are marked *