TAILIEUCHUNG - Lecture Web technologies and programming – Lecture 27: Retrieving data, delete, update from database

Lecture Web technologies and programming – Lecture 27: Retrieving data, delete, update from database. 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. | 1 CIIT-Human Computer Interaction-CSC456-Fall-2015-Mr. Tehseen Riaz Abbasi 1 2 3 3 Creating database in MySQL using WAMP Connecting PHP with MySQL Inserting data in database CONNECTIONS: user registration FILES super global variable File uploading in PHP Storing reference of uploaded file in database User registration in CONNECTIONS web application with file upload 4 Retrieving data from MySQL using PHP CONNECTIONS: login functionality Deleting records in MySQL using PHP Updating records in MySQL using PHP 5 Connection with database Execute Select SQL command Make display structure Write data 6 7 8 The SELECT statement is used to select data from one or more tables: SELECT command in SQL: SELECT column-name FROM table-name SELECT user_Name FROM users SELECT * FROM users 9 Condition selection: SELECT column-name FROM table-name WHERE condition SELECT * FROM users WHERE user_Id>4 10 11 Counting rows: mysql_num_rows(variable); 12 User Name User Email User Password User Picture         13 mysql_fetch_array(result-resource); mysql_fetch_array($result); 14 $result= $row = mysql_fetch_array($result); 1 Ali ali@ 123 upload/ 2 Umar umar@ 123 upload/ $row= 1 Ali ali@ 123 upload/ user_Id user_Name user_Email user_Password user_Picture 0 4 1 2 3 echo $row [1]; echo $row[‘user_Name’]; 15 User Name User Email User .

• Kỹ thuật lập trình
• Web technologies
• Web programming
• Web applications
• Computer programming
• Web development technologies
• Retrieving data
• Web project management
• Web application development process
• Modeling web applications
• Testing web application
• Web services
• Web hosting
• Categories of web applications
• Characteristics of web applications
• Web application architecture
• Requirement engineering
• HTML images
• Web pages
• Hyper Text Markup Language
• Markup Language
• HTML page
• Text formatting tags
• HTML links
• HTML forms
• HTML form elements
• HTML 5 form elments
• Adding form elements
• Cascading Style Sheets
• CSS writing option
• CSS rules
• Page Layout
• Rounded corners
• Box shadows
• Elements of visual design
• Interface design