Lecture Introduction to web engineering - Lec 30: Retrieving data from MySQL using PHP

After studying this chapter you will be able to understand: Retrieving data from MySQL using PHP, connections: login functionality, connection with database, selecting data, display structure, writing data. | Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 1 FILES super global variable File uploading in PHP Storing reference of uploaded file in database CONNECTIONS: user registration with file upload Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 2 Retrieving data from MySQL using PHP CONNECTIONS: login functionality Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 3 Connection with database Execute Select SQL command Make display structure Write data Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 4 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 5 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 6 SELECT command in SQL: SELECT column-name FROM table-name SELECT user_Name FROM users SELECT * . | Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 1 FILES super global variable File uploading in PHP Storing reference of uploaded file in database CONNECTIONS: user registration with file upload Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 2 Retrieving data from MySQL using PHP CONNECTIONS: login functionality Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 3 Connection with database Execute Select SQL command Make display structure Write data Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 4 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 5 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 6 SELECT command in SQL: SELECT column-name FROM table-name SELECT user_Name FROM users SELECT * FROM users Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 7 Condition selection: SELECT column-name FROM table-name WHERE condition SELECT * FROM users WHERE user_Id>4 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 8 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 9 Counting rows: mysql_num_rows(variable); Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 10 User Name User Email User Password User Picture         Basharat Mahmood, Department of Computer .