The 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 MySQLi
A knowledge of PHP and MySQL is recommended for this course.
Using MySQLi to connect to a MySQL database and how to handle errors connecting so we can display an error to users.
Create a database that we'll be able to work with during the series.
How to query the database for a single record, and how to examine the data with PHP.
How to pull multiple records from the database and how to examine the data with PHP.
The different result types we can choose from once we've queried the database for data.
Count either total results in the database table, or counting the amount of results that have been returned using a specific query.
Update records and find out how many records have been affected by the query we execute.
Escaping data we get from another souce, such as a user, so we can protected against SQL injection.
Learn how SQL injection works and what can happen if the appropriate steps are not taken to escape data.
Using prepared statements to send multiple values to a query, automatically escaping them to protect against SQL injection. Specifically deals with inserting data.
How to use the MySQLi method to free up result data, helping to speed up the application.
Using prepared statements to send multiple values to a query, automatically escaping them to protect against SQL injection. Specifically deals with selecting data.
At Stone River eLearning, technology is all we teach. If you're interested in programming, development or design - we have it covered.
Check out our huge catalog of courses and join the over 390,000 students currently taking Stone River eLearning courses. We currently offer 100+ different technology training courses on our Stone River eLearning website and are adding new courses on hot and trending topics every month. A subscription option is available for those with a real passion for learning.