Retrieve data from MySQL PHP in MySQL


show more There are three basic functions for retrieving data from MySQL. These functions control retrieving the data, working with the data, and releasing the memory when you are done. In this tutorial you will learn to use the mysqli_query, mysqli_fetch_row and the mysqli_free_result functions to access, use, and release data properly from your MySQL database. show less
From:

PHP with MySQL Essential Training

with Kevin Skoglund

Video: Retrieve data from MySQL PHP in MySQL

There are three basic functions for retrieving data from MySQL. These functions control retrieving the data, working with the data, and releasing the memory when you are done. In this tutorial you will learn to use the mysqli_query, mysqli_fetch_row and the mysqli_free_result functions to access, use, and release data properly from your MySQL database.
please wait ...
Retrieving data from MySQL
Video duration: 8m 47s 14h 32m Beginner Updated May 20, 2015

Viewers:

There are three basic functions for retrieving data from MySQL. These functions control retrieving the data, working with the data, and releasing the memory when you are done. In this tutorial you will learn to use the mysqli_query, mysqli_fetch_row and the mysqli_free_result functions to access, use, and release data properly from your MySQL database.

PHP is a popular, reliable programming language at the foundation of many smart, data-driven websites. This comprehensive course from Kevin Skoglund helps developers learn the basics of PHP (including variables, logical expressions, loops, and functions), understand how to connect PHP to a MySQL database, and gain experience developing a complete web application with site navigation, form validation, and a password-protected admin area. Kevin also covers the basic CRUD routines for updating a database, debugging techniques, and usable user interfaces. Along the way, he provides practical advice, offers examples of best practices, and demonstrates refactoring techniques to improve existing code.

Topics include:
  • What is PHP?
  • Installing and configuring PHP and MySQL
  • Exploring data types
  • Controlling code with logical expressions and loops
  • Using PHP's built-in functions
  • Writing custom functions
  • Building dynamic webpages
  • Working with forms and form data
  • Using cookies and sessions to store data
  • Connecting to MySQL with PHP
  • Creating and editing database records
  • Building a content management system
  • Adding user authentication
Subject:
Developer
Software:
MySQL PHP
Author:

Closed captioning isn’t available for this video right now. New videos usually include captioning within 24 hours after they’re released.

Find answers to the most frequently asked questions about PHP with MySQL Essential Training .


Expand all | Collapse all
please wait ...
Q: This course was revised on 6/4/2013. What changed?
A: The old version of this course was 6 years old and it was time for a complete revision, using PHP 5.4. (The tutorials will work with any version of PHP and covers any differences you might encounter). The author has also added updated installation instructions for Mac OS X Mountain Lion and Windows 8. The topics and end project are the same, but the code is slightly different. It also addresses frequently asked questions from the previous version.
Q: This course was updated on 5/20/2015. What changed?
A: We added one movie called "Changing the document root in Yosemite," which helps the Mac installation run more smoothly.
please wait ...