MySQL PHP Database Essentials add a Database to your site

Name: MySQL PHP Database Essentials add a Database to your site
Rating: 4.0 (80 reviews)

Learn the fundamentals of MySQL databases and phpMyAdmin and how to connect database to your PHP code

Created byLaurence Svekis

Last updated 11/2021

English

English [Auto],

What you'll learn

learn to apply MySQL database to your web applications
PHP and MySQL interacting together
create update insert and delete database content
setup databases
create tables and databases

Course content

3 sections • 34 lectures • 1h 45m total length

MySQL course introduction3:54
Learn to write MySQL queries and interact with a MySQL database using PHP code, including procedural and object connections, creating tables, inserting, updating, deleting data, and joins.
MySQL cpanel course resources introduction3:30
Set up a local environment with zap, use phpmyadmin to create databases and users, and connect PHP code to build dynamic, database-driven web content.
MySQL options4:18
Explore MySQL options and access a database via phpMyAdmin, compare GUI interfaces, set up localhost connections, and perform exports, imports, renaming, and deletion of tables.
mySQL Course Resources5:00
MySQL PHPmyadmin create a table6:35
Create a brand-new database in phpMyAdmin and design a users table with id, first name, last name, and age, using primary key and auto increment.
MYSQL connect to database10:10
Organize PHP files into settings, connection, and bootstrap to define host, user, password, and database name, then connect to MySQL and verify the connection.
MYSQL connect Object Oriented Method2:52
Learn to connect to a MySQL database in PHP using procedural and object oriented methods, with error checks and compatibility notes for older and newer PHP versions.
MYSQL Source1:00
MYSQL create a database with PHP3:46
Learn how to create a new database via php code by executing a sql create database command, ensure permissions, connect with a bootstrap file, and run queries to prepare tables.
MYSQL DROP database3:10
Learn to drop a database with PHP code or MySQL admin, compare drop vs create commands, and understand cautions before destroying data in this MySQL PHP database essentials lesson.
MYSQL Source 21:00
MYSQL Create Table Datatypes6:56
Learn how to select and use a specific database in phpMyAdmin, then create a users table with an auto-incrementing id and key data types like integer, variable character, and text.
MYSQL Source 31:00
mySQL DataTypes2:00
MYSQl Object vs Procedural Connections9:33
Explore procedural and object-oriented connections in PHP, set up and execute queries, connect to the newsletter database, handle errors, and fetch results with a clear, practical workflow.

MySQL Insert Data7:07
Pull MySQL queries into the index page, establish a database connection, and insert data into the newsletter table while debugging common errors.
Source Code for Previous Lecture1:00
MySQL Fetch Array Select4:23
Master selecting emails from the newsletter table and retrieving an array of results by looping through rows with while or for loops, then outputting data in a table.
MYSQL Source 41:00
MySQL Insert array list data6:27
Add first name and last name columns and create an insert.php page to insert email, first name, and last name into the newsletter table, then verify inserts in phpMyAdmin.
MySQL selectors wildcards and LIKE4:04
Explore how MySQL selectors, the like operator, and wildcards enable flexible searches. Use wildcards before, after, or both sides to match patterns in names within APHC code.
MYSQL Source 51:00
MySQL Sort order2:59
Learn how to use the order by clause in MySQL to sort results by ID, first name, or last name, in ascending or descending order, with phpMyAdmin as a reference.
MySQL joining tables6:43
Learn how to join two tables by matching first names in PHP, select data from newsletter and first tables, and understand how join order affects results.
MYSQL Source 81:00
MySQL DELETE records2:36
Delete records in MySQL using delete from with where clauses, such as id = 47 or id = 50, and like for wildcards, while noting deletions are permanent.
MySQL UPDATE table2:47
update records in a mysql table using the update command, specify columns with a where clause, and handle multiple fields like first name, last name, and email.
MySQL GROUPING rows3:55
Learn how to group newsletter data by location using a group by query, update records with a location field, and interpret grouped results by location (Canada, US).
MYSQL Source 61:00
MySQL COUNTING ROWs4:17
Learn to use the MySQL count function to count rows in newsletters with select count(*) and output the result, including looping through results if needed.
MYSQL Source 71:00
MySQL clean avoid sql injections2:36
learn how to protect your MySQL database from sql injections by cleansing dynamic input and escaping strings before insert, update, or delete operations.
MySQL Source 91:00

Requirements

computer
database access server access
basic PHP understanding
desire to learn

Description

Learning MySQL and phpmyadmin

NEW course December 2015!

MySQL Database Tutorial for beginners to help better understand PHP connections. Learn how to interact with PHP code to connect to Databases.

Create a database with both phpmyadmin and PHP code.
Object oriented connections MySQLi and MySQL.
How to create a database MySQL
How to drop MySQL databases
Different MySQL data types
How to insert connect to MySQL using PHP
Output Database content into PHP and web code.
Selectors wildcards and custom selection options.
JOIN tables
GROUP tables
Avoid SQL injections

Create update insert and delete database content.

MySQL is the most popular relational database used across the internet today. We show you how to setup and use a database for your website.

Perfect for anyone who wants to understand how to use MYSQL

This course is designed to be easy to follow along, its encouraged to practice the code being presented through out the course. Resources, source code, and everything you need to learn to try MYSQL code is provided.

This step by step course shows you the code you need to know. Learn about mysql databases and its core concepts and much more.....

We walk you through step by step with detailed explanations of code and more.

quick lessons get right to the point
fully covered topics with real world examples
source files downloadable to work along
challenges and lessons and code samples
code snippets
Links to top resources to save time
30 day money back guarantee
new course material added regularly
trusted name in education since 2002
full HD easy to read source coding
quick response support to students
regular discussions

Everything you need to know is included in this course. Learn at your own pace, lifetime access to this course. Regualr updates and more.

Who this course is for:

Learn how to apply MySQL to a website
use MySQL as a database solution
basic programming skills to interact with databases

MySQL PHP Database Essentials add a Database to your site

What you'll learn

Explore related topics

Course content

Learning MYSQL15 lectures • 1hr 5min

MYSQL Database interaction18 lectures • 55min

Code examples and source code Q&A responses and example1 lecture • 3min

Requirements

Description

Who this course is for: