Stone River Elearning – MySQLi For BeginnersBest practices and security considerationsThe course teaches MySQLi, a way to connect to databases within PHP. It covers connecting to the database, and using all the features required to build fast, scalable applications that use a database connection. It covers essential concepts like security, and best practices with using the data retrieved from the database.Benefits of MySQLiAn object-oriented interfaceSupport for prepared statementsSupport for multiple statementsSupport for transactionsEnhanced debugging supportEmbedded server supportA knowledge of PHP and MySQL is recommended for this course.Course CurriculumIntroductionIntroduction (5:21)Getting ed with MySQLiConnecting To A Database (7:55)Connecting Using PHP (9:44)Creating a Database Table (3:38)Fetching ResultsPulling Single Records (4:45)Pulling Multiple Records (9:11)Different Result Types (5:26)Getting ResultsCounting Results (9:25)Updating and Seeing Affected Rows (4:46)SecurityEscaping (12:33)Prepared Statements for Inserting (8:14)Selecting Prepared Statements (5:42)Finishing UpFreeing Results (2:48)Closing the Database Connection (2:15)
