CSC 5750 Lecture Notes - Lecture 20: Data Manipulation Language, Sql, Mysql

• School: Wayne State University
• Department: Computer Science
• Course: CSC 5750
• Professor: Daniel Ouellette

Document Summary

Dml statements are a category of sql statements that enable the management of data stored within a database. See the structured query language - dml statements document on canvas. Php method mysqli_connect is used to connect to a mysql database. Php method mysqli_query is used to submit a select or update query to a. If a query fails, the query result will be false. This may be tested after a query is submitted to a mysql database: if( == false) See city manager page on canvas. mysqli_error. Also, the query error may be accessed with php method mysqli_error: mysqli_error() If a select query was successful, the number of rows returned may be queried with mysqli_num_rows: mysqli_num_rows() See city manager page on canvas. mysqli_affected_rows. If an insert, update, or delete query was successful, the number of rows affected may be queried with mysqli_affected_rows: mysqli_affected_rows() mysqli_fetch_row. If the query succeeds, the query result will contain data returned from the.