tailieunhanh - Lecture Introduction to web engineering - Lec 32: CONNECTIONS: web application

Lecture Introduction to web engineering - Lec 32: CONNECTIONS: web application. After studying this chapter you will be able to understand: User registration (already discussed), user login (already discussed), send message, inbox, out box, sign-out. | Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 1 Deleting records in MySQL using PHP Updating records in MySQL using PHP Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 2 User registration (already discussed) User login (already discussed) Send Message Inbox Out Box Sign-Out Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 3 User registration form: Home page Action page: Retrieve user’s input Validate input Connection with DB Insert record into users table Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 4 User login form: Home page Action page: Retrieve user’s input Connection with DB Select record from users table where user email and password are same as user’s input Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 5 If one row is selected then: Session variables are registered $_SESSION[‘name’]; $_SESSION[‘email’]; $_SESSION[‘password’]; Redirect to | Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 1 Deleting records in MySQL using PHP Updating records in MySQL using PHP Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 2 User registration (already discussed) User login (already discussed) Send Message Inbox Out Box Sign-Out Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 3 User registration form: Home page Action page: Retrieve user’s input Validate input Connection with DB Insert record into users table Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 4 User login form: Home page Action page: Retrieve user’s input Connection with DB Select record from users table where user email and password are same as user’s input Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 5 If one row is selected then: Session variables are registered $_SESSION[‘name’]; $_SESSION[‘email’]; $_SESSION[‘password’]; Redirect to user’s page Redirect to index page with error message Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 6 Create a table in connections database as: Table Name: messages No. of fields: 4 message_Id int 5 s_Email varchar 50 r_Email varchar 50 message varchar 500 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 7 Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 8 Table fields Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 9 Form to send message: Receiver email: data-list of users Message: text-area Submit button Action page: Retrieve receiver email and message from post array Retrieve sender email from $_SEESION[‘email’] Insert data into messages table Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 10 Session starts DB connection HTML page starts Basharat Mahmood, Department of Computer Science,CIIT,Islamabad, Pakistan. 11 header links Basharat Mahmood, .