MySQL Tutorials For Beginners

MySQL Tutorials For Beginners List

If you’re a beginner, or even more advanced, this MySQL Tutorials For Beginners will be a good resource for you. In learning web development, you’re going to need to know some amount of SQL or MySQL at some point. The whole point of building dynamic websites is to be able to tie into a database to store and retrieve information. Just like when learning about how to use PHP Frameworks, one must have some amount of knowledge about OOP, or object oriented programming.…

Escape Strings For MySQL To Avoid SQL Injection

Escape Strings For MySQL To Avoid SQL Injection

With all the talk about working with databases using MySQL and PHP in this tutorial series, one thing we didn’t cover yet is SQL Injection and how to protect your site from it. The syntax for MySQL is very specific, and if you don’t get it right, it is easy to break. As we build up queries using dynamic data from our variables in PHP, you need to be careful that any data contained in those variables do not break the syntax as well.…

PHP MySQL CRUD Tutorial

4 Components Of CRUD With Native PHP and MySQL

In the last lesson we learned more about working with results from select queries in MySQL. In other words, when we used PHP to build up a query and send it to MySQL, MySQL then sent back a resource which could be massaged by any of the four techniques we discussed to get access to the data contained in the resource. So of all the MySQL commands such as SELECT, INSERT, UPDATE, and DELETE, SELECT is the only one to return a resource on success which requires further processing.…

Process Returned MySQL Query Results In PHP

4 Cool Ways To Process Returned MySQL Query Results In PHP

In the prior episode of working with MySQL and PHP, we took a good look at the entire process of getting data to work with. This involved setting up a database connection, testing the database connection, defining a query, running said query, processing any results we got back, releasing memory, and closing the database connection. Bing, Bang, Boom, we’re talking to the database successfully. In this PHP and MySQL Tutorial we’ll take a closer look at the processing portion of this cycle.…

PHP And MySQL Tutorial

5 Essential Steps For Database Nirvana With PHP

This PHP Tutorial Series has gone soup to nuts covering all of the fundamental aspects of using PHP to build dynamic websites. Based on all of the concepts covered so far, you should be able to build links to pages, pass data via $_GET in those links, create forms, collect user data via $_POST in those forms, as well as use cookies and sessions to establish state and customized user experiences.…