In this video I’ll show you how to install XAMPP on Windows 10. I also cover configuring php.ini / config.inc.php, changing passwords, creating databases, inserting data, creating users, privileges, connecting to MySQL with PHP, handling MySQL queries with PHP and much more!

I’ll be uploading a new PHP Learn in One in a few days. Here is my Learn MySQL in One Video tutorial.

►► Get my Python Programming Bootcamp Series for $9.99 ( Expires Nov 3rd ) :

Like the channel? Consider becoming a Patreon and get access to exclusive videos! All Patreons who contribute $1 or more get a FREE coupon code to my Python Programming Bootcamp Series!!!

GET FREE STUFF FOR SUPPORTING MY TUTORIALS

1. Get a Free Stock
2. Get 2 Free Audiobooks

All the Files

INSERT INTO student (f_name, l_name, street, city, state, email, phone) VALUES ('Chris', 'Martinez', '123 Main St', 'Katy', 'TX', 'cm@aol.com', '412-555-1212');

mysqli_connect.php

<?php
DEFINE ('DB_USER', 'studentdb');
DEFINE ('DB_PASSWORD', 'TurtleDove');
DEFINE ('DB_HOST', 'localhost');
DEFINE ('DB_NAME', 'students');

$dbc = @mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
OR die('Could not connect to MySQL: ' .
mysqli_connect_error());
?>

testdb.php

<?php
require_once('mysqli_connect.php');
$query = "SELECT f_name, l_name FROM student";
$response = @mysqli_query($dbc, $query);
if($response){
  while($row = mysqli_fetch_array($response)){
    echo $row['f_name'] . ' ' . $row['l_name'];
  }
}
?>