Lecture 8 PHP and MYSQL part 2.ppType Classificationtx

Chapter 19-2 PHP LECTUR 8: PHP & MYSQL PART 2 Web-Based Design IT210 1

OBJECTIVES By the end of this lecture student will be able to: Apply php methodology for different SQL queries using MySQLi extension(procedural) through interface (form) 2

OUTL INE 3 Insert to database through form Display the data in a table Update to database through form Delete to database through form

Insert , Delete , Update 1. create a connection to the database 2. verify the connection 3. create an SQL query 4. preform the Query in the database 5. verify the query (optional) 6. close the database connection (Good practice to do so(why?)) 4 PHP METHODOLOGY:

LETS WARM UP 1. Create a new database called lecture7 2. Create a table called students that has 4 column (ID , Fname, Lname , Email) 5

LETS WARM UP 3. Open a new php page call it lecture7.php 4. Create a form with 3 text fields and one insert button .. 3. Lets write the connection code to the database and verify it?  Hint: in order to connect and verify our connection 3 functions are needed  mysqli_connect(with 4 arguments);  mysqli_connect_errno();  mysqli_connect_error(); 6 Form code is in the note ..

CONNECT TO THE DATABASE AND VERIFY THE CONNECTION 7 Connection code is in the note .. 7

NOW,  In the last lecture (lecture 7) we learned how to write insert code. 1. (step 3: create an insert SQL query ) 2. (step 4: preform the insert Query in the database by using mysqli_query() function )  In (lecture 5 & 6) we learn how to deal with user input .. Using your knowledge and based on your understanding. write a code to insert the user inputs to the database.. 8

9 insert code is in the note ..

Select 1. create a connection to the database 2. verify the connection 3. create an SQL select query 4. preform the Query in the database A. receive the result from the database (As an array) B. parse the result and use them (use the index) 5. verify the query (optional) 6. close the database connection 10 PHP METHODOLOGY:

NOW WE NEED TO DISPLAY ALL RECORDS IN A HTML TABLE  First lets make sure that select code is working just fine …  Lets make step (3 , 4 , a and b ) 11  Select Methodology 1. create a connection to the database 2. verify the connection 3. create an SQL select query 4. preform the Query in the database A. receive the result from the database (As an array) B. parse the result and use them (use the index) 5. verify the query (optional) 6. close the database connection

12 insert code is in the note .. Now lets place those in a table… Testing select code functionality..

THE BROWSER WILL LOOK LIKE … Lets say , we would like to update the email of the second record .. What should we do ?! All the records should be pleased in a text field in order to update them 15

pleasing the form values in an input text field 16 Notice that when we want to display the information in text box and we need the end user to not change the value of this field we can add readonly attribute

pleasing the form values in an input text field (output) 17 Note: the border for the table disappear because we set the table border to zero

UPDATING THE VALUES IN THE FORM 18

NOW, LETS ADD A DELETE BUTTON  We need to add delete button on the form inside the table ..  The code will look like…(Next Slid) 19

NOW, LETS ADD A DELETE BUTTON 20

NOW, LETS ADD A DELETE BUTTON 21

LETS TEST THE FORM 22 Try to insert a record Delete the last record

LETS TEST THE FORM 23 Is everything working well? What happened? Why? How we fix it? NO The record will be deleted and on the same time another one with the same value will be added The insert value was kept on the supper global array post The page should be reloaded

 The header() function sends a raw HTTP header to a client.  Return Values: This function doesn’t return any value.  Uses:  Redirect the browser THE SOLUTION IS: PHP HEADER() FUNCTION <?php // PHP program to describes header function // Redirect the browser header(“ Location: http://www.iau.edu.sa "); // The below code does not get executed // while redirecting ?> 24 Where to add?

25 header("Location:lecture7.php");

CHALLENGE YOURSELF … 26  Add an empty fields to allow the end user to insert record in the same table…  NOTE: ID field should be read only .. (why?)

Lecture 8 PHP and MYSQL part 2.ppType Classificationtx

More Related Content

Similar to Lecture 8 PHP and MYSQL part 2.ppType Classificationtx

More from ZahouAmel1

Recently uploaded

Lecture 8 PHP and MYSQL part 2.ppType Classificationtx

Editor's Notes