PHP MySQL database connections

PHP MySQL database connections, available at $19.99, has an average rating of 3.8, with 38 lectures, based on 79 reviews, and has 6689 subscribers.

You will learn about connect web pages to a mysql database update insert delete and use mysql database content connect to MySQL using procedural methods connect to MySQL using mysqli object methods connect to MySQL using PDO methods This course is ideal for individuals who are web developers or application developers or anyone who needs to utilize a database and connect to it It is particularly useful for web developers or application developers or anyone who needs to utilize a database and connect to it.

Enroll now: PHP MySQL database connections

Summary

Title: PHP MySQL database connections

Price: $19.99

Average Rating: 3.8

Number of Lectures: 38

Number of Published Lectures: 38

Number of Curriculum Items: 38

Number of Published Curriculum Objects: 38

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

connect web pages to a mysql database
update insert delete and use mysql database content
connect to MySQL using procedural methods
connect to MySQL using mysqli object methods
connect to MySQL using PDO methods

Who Should Attend

web developers
application developers
anyone who needs to utilize a database and connect to it

Target Audiences

web developers
application developers
anyone who needs to utilize a database and connect to it

Learn how to use a MySQL database and access data within your PHP code. MySQL is the most popular database used by PHP. Its works really well and smoothly with PHP code and is an ideal solution for storing information and utilising that data within your web projects.�

Do you need a database within you website? Database can help with information management and run as a the data source for dynamic websites. MySQL is the perfect solution for any size application. Its fast and reliable and best of all easy to use. �

This course covers multiple methods of connecting to a MySQL database. Avoid the confusion of only one way, we show you three ways to connect to a MySQL database via PHP code.

Top resources, source code and more is provided to get you started quickly.

Learn how to connect to a database
Create databases
Create tables
Insert records into a MySQL database
Return ids of inserted records
Delete records�
Update records
Create queries to interact with database content
phpmyadmin and how to use it

By the end of the course we show how to use a database within your PHP code

I am here to help you learn how to create your own websites and ready to answer any questions you may have.

Want to know more, what are you waiting for take the first step. Join now to start learning how you too can add a database to your website today.

Course Curriculum

Chapter 1: Learn how to connect and use mysql database from PHP

Lecture 1: Course introduction mysql databases and PHP

Lecture 2: Resources and Setup Information

Lecture 3: Resources for setup

Lecture 4: How to Create a database

Chapter 2: PHP and Database access

Lecture 1: MySQLi Procedural database connection

Lecture 2: MySQLi Object Oriented connection

Lecture 3: PDO connection

Lecture 4: Create a SQL query to create a database

Lecture 5: Source Code

Lecture 6: How to create a table mysqli

Lecture 7: PDO create Table

Lecture 8: Source Code Create Tables

Chapter 3: PHP MySQL working with Databases MySQLi Procedural

Lecture 1: Insert into database MySQLi

Lecture 2: Source Code

Lecture 3: mysqli_insert_id return id value

Lecture 4: Select from database PHP query

Lecture 5: Source Code Query content

Lecture 6: DELETE row from MySQL

Lecture 7: Update content in your database

Lecture 8: How to create query strings with phpmyadmin

Lecture 9: Source Code MySQLi Procedural connection

Chapter 4: PHP MySQL working with Databases MySQLi Object Oriented connection

Lecture 1: Insert query multi query into Mysql Object Oriented Connection

Lecture 2: Source Files

Lecture 3: Query Selection Object Oriented PHP connection

Lecture 4: Source Files

Lecture 5: Delete from mySQL database

Lecture 6: Update data in your database

Lecture 7: Source Code used in MySQLi Object Oriented connection

Chapter 5: PHP MySQL working with Databases PDO connection

Lecture 1: PDO connection insert Data

Lecture 2: Insert Into Database PDO connection

Lecture 3: Source Code Insert

Lecture 4: Select data from database

Lecture 5: Delete rows using PDO connection

Lecture 6: Update MySQL database

Lecture 7: How to use prepare statements in PHP

Lecture 8: Source Files

Chapter 6: PHP MySQL connection Resources

Lecture 1: Resources

Chapter 7: Bonus Section

Lecture 1: Bonus Lecture

Instructors

Laurence Svekis
Instructor, GDE, Application Developer

Rating Distribution

1 stars: 2 votes
2 stars: 2 votes
3 stars: 13 votes
4 stars: 25 votes
5 stars: 37 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu