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
1 |
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
1 2 3 4 5 6 7 8 9 10 |
<?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
1 2 3 4 5 6 7 8 9 10 |
<?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']; } } ?> |
Leave a Reply