MySQL Basics: How to Populate a MySQL Database in PHP


show more There are many methods for populating a MySQL database. This video demonstrates a simple manual method to insert rows, with attention to how to insert data when autoincrement columns are present, the use of single quotes, and entering integer, string and Boolean values into your table.You will also see examples of statements for selecting and displaying your data, as well as pitfalls to avoid when updating or deleting data. show less
From:

PHP with MySQL Essential Training

with Kevin Skoglund

Video: MySQL Basics: How to Populate a MySQL Database in PHP

There are many methods for populating a MySQL database. This video demonstrates a simple manual method to insert rows, with attention to how to insert data when autoincrement columns are present, the use of single quotes, and entering integer, string and Boolean values into your table.You will also see examples of statements for selecting and displaying your data, as well as pitfalls to avoid when updating or deleting data.
please wait ...
Populating a MySQL database
Video duration: 7m 32s 14h 32m Beginner Updated May 20, 2015

Viewers:

There are many methods for populating a MySQL database. This video demonstrates a simple manual method to insert rows, with attention to how to insert data when autoincrement columns are present, the use of single quotes, and entering integer, string and Boolean values into your table.You will also see examples of statements for selecting and displaying your data, as well as pitfalls to avoid when updating or deleting data.

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 ...