tailieunhanh - Lecture Introduction to web engineering - Lec 31: Deleting and updating records in MySQL using PHP

Lec 31 - Deleting and updating records in MySQL using PHP. After studying this chapter you will be able to understand: Retrieving data from MySQL using PHP, connections: login functionality, deleting records in MySQL using PHP, updating records in MySQL using PHP. | Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 1 Retrieving data from MySQL using PHP CONNECTIONS: login functionality Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 2 Deleting records in MySQL using PHP Updating records in MySQL using PHP Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 3 Connection with database Delete the record Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 4 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 5 Delete SQL instruction: DELETE FROM table-name WHERE condition DELETE FROM users WHERE user_Id =5 DELETE FROM users WHERE user_Id >5 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 6 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 5 Delete SQL instruction: DELETE FROM table-name WHERE condition DELETE FROM users WHERE user_Id =5 DELETE FROM users WHERE user_Id >5 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 6 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 7 Display data from database in a table Add actions column In each record, add a delete button When delete button in clicked, delete that record Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 8 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 9 Delete Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 10 User Name User Email User Password User Picture Actions Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 11 ”>