PHP MYSQL Tutorial 2 How to select records from MYSQL via PHP

Опубликовано: 30 Сентябрь 2024
на канале: How to code well

1,122

In this PHP tutorial I will demonstrate how to select records from a MYSQL database via PHP using MYSQLi.
We are going to cover fetch_object and fetch assoc methods of the MYSQLi class.
Once we have the records I will show you how to create a HTML table which displays each database records as a row in the table.
I will also demonstrate how to count the records in the MYSQL table using PHP

==== GET EARLY ACCESS TO FUTURE VIDEOS & TUTORIALS ====

Patron: http://bit.ly/2hmVKwX

======== RECOMMENDED PROGRAMMING RESOURCES ========

Manning programming books and courses: http://bit.ly/2BIrExp

PHP Books:
http://howtocodewell.net/shop/books/php

PHP Hosting from Cloudways:
http://bit.ly/2CB4mWD

======== MY PROGRAMMING COURSES ========

Docker in Motion: http://bit.ly/2vvz2sA
Skillshare courses: http://skl.sh/2gI33M5
Udemy courses: http://bit.ly/2iGhvIE

======== WEB HOSTING DEALS ========

Cloudways: http://bit.ly/2CKb79b = 20% off first 6 months
Digital Ocean: https://m.do.co/c/9d4641c62263 = $10 off
Linode: http://bit.ly/2CmoNq3

======== SUBSCRIBE TO THE NEWSLETTER ========

Join the Newsletter: http://bit.ly/2fPlG3v

======== FOLLOW ME ========

Blog: http://peterfisher.me.uk
Facebook:   / howtocodewell
Instagram:   / howtocodewell
Twitter:   / howtocodewell
Pintrest: http://pinterest.co.uk/howtocodewell/
Twitch:   / howtocodewell

======== MY TALKS ========

How to put your Docker image on a diet: http://bit.ly/2y5KMly

======== SUPPORT THE CHANNEL ========

Become a Patron: http://bit.ly/2hmVKwX
Donate: https://www.paypal.me/howToCodeWell
Help translate the videos: http://bit.ly/2iEyxXB

======== VIDEO SETUP ========

Nikon D5300 Camera: http://amzn.to/2u5jreD
Logitech HD Pro Webcam C920 http://amzn.to/2C5NNVJ
CRAPHY Photography Studio Lights: http://amzn.to/2BThzOc
Rode Procaster Microphone: http://amzn.to/2sH2WJ1
Rode VideoMic Pro: http://amzn.to/2vmNF0D
Zoom H4NPro: http://amzn.to/2kZrrvo