PHP Front To Back [Part 21] - Fetching Data With MySQLi

Показать описание

In this video we will start to work with the MySQLi extension. We will create a MySQL database using phpMyAdmin as well as a posts table to interact with.

CODE: Code for this video

EDUONIX COURSES: Please use affiliate links from website below

SUPPORT: We spend massive amounts of time creating these free videos, please donate to show your support:

FOLLOW TRAVERSY MEDIA:

Рекомендации по теме

Комментарии

Thank you for your time in making this video. Thank you for helping others on a path to providing a better life. Blessings to you and your family.

shargenezangana

To be honest, I like videos with "face time :D". It brings you closer to us.
Keep up your good work!

je-suis-alin

i wake up today telling myself 'aaah i have to learn that SQL+PHP stuff...' and before looking for it, there it was, in my feed. You're freaking me out! Thank you!!

Pabloquerock

Thanks for continuing to keep this series updated, Brad. I can only speak for myself, but I'm really enjoying it...and no worries about the delay in getting parts up, it gives me time to go back and write test code to make sure I really understand each part before going on to the next one. Cheers!

basq

Hey man, you actually do not know, you are getting thousand of blessings from us. You are simply YouTube legend. #respect

RajatSharma-mmof

Thanks so much for all this, Brad.

Just a note that in real world application, the entire <head> section of the page should *not* be put in a common header unless you define all your page titles and descriptions dynamically, so that they're not the same across every page.

TimGallant

Some people are just blessed with the gift of sharing knowledge. Brad, you are blessed with that gift. I have never used MySQL and have never learned it before but after watching this video, I feel like an expert. I will check out your other video you mentioned regarding MySQL. Thank you once again for a job well done.

successfulpeople

Finally, a PHP tutorial that renders PHP down in the HTML code. So many tutorials out there where they don't show you how to add PHP with your HTML, especially for repeated regions.

bg

If someone is getting an error at 11:23, check also how you named the table in the database - post or posts. If it was post change all posts to post in the index.php file.

nikolay

awesome helped a lot to understand php in short time

rupamshaw

You tuts are simple and easy to follow.
As a beginner, I am to follow what you are teaching without much difficulty.
Thank you.

d.o.balogun

Hi Brad, for preparing SQL queries, it is VERY handy to use HEREDOC sintax.
The easiest way to prepare strings. No escape needed at all. And also valiables are evaluated. BIG THANKS for your tutorials.

pepeback

Can't wait for the next one! I've been looking for a tutorial on how to submit form data to a database for a week now and can't get something that works for some reason.

iflynina

If you are taking any requests (and I know it is too much to ask but ;) before getting in to the forms or while getting in to the forms ( because I am sure we will be getting in to POST, PUT and possibly DELETE functions.)

-Is it possible for you to create a second table for Tags, left_join it with the post tables and use Split function to populate the tags. So when you will create the forms, you create another input text box to make the tags and the amount of spaces that you have for input will split the input words in to tags.

-Is it possible to use Sha Hashing /Hashing that is offered by JQuery for admin login?

This is just a request, it is all good and understandable if you are planning to keep this tutorial just simple and on point.

As for this tutorial. Thank you for the update on php series. I really admire your work and you are indeed an extremely reliable source for developers / web developers like me.

AK-urme

when you were clicking 'new folder' it was actually working but was hidden behind your windows taskbar and was half visible. Nice stuff btw.

webhelp

Thank you for all your videos Brad. There are lots of videos on coding, but your videos are the one that help with real projects. The way you explain things really click and the things you explain are really important.... I actually utilised everything taught in this video in a CMS/Blog project I am currently working on. Though I improvised a lot, but what you taught makes the foundation upon which I am building. Thank you again.. and all the very best with everything... Regards.

manishpandey

I'm confused in 22:27 you set the $conn with the constant created in config.php. Is it not necessary to use require('config/config.php'); ?

WinadiWiratama

damn! programming is enjoyable as fuck! I love it! I've been coding for several years, but never it had never tasted good as now! thanks brad for great tutorials.

RameenFallschirmjager

mysqli_connect(): (HY000/1045): Access denied for user 'root'@'localhost'(using password: YES)
what's this mean? Actually I'm newbie in PHP so I don't know much about stuff like that so anyone? I need some help

sabahkhan

Hey Brad.
In SublimeText when you click new folder, first you need to give a name hit enter then you folder will add to the project, look at the 22:57 on the bottom you need to name you folder.
Thanks for your videos, i like the way you teach, i have learned alot!
keep up the great work.

mushegh_k

PHP Front To Back [Part 21] - Fetching Data With MySQLi

PHP Front To Back [Part 20] - OOP

PHP Front To Back [Part 16] - Sessions Tutorial

PHP Front To Back [Part 10] - $_SERVER Superglobal

PHP Front To Back [Part 2] - PHP7 & Xammp Installation

PHP Front To Back [Part 5] - Loops

PHP Front To Back [Part 6] - Functions

PHP Front To Back [Part 1] - Series Introduction

PHP Front To Back [Part 21] - Fetching Data With MySQLi

Group Discussion: Building a Result Management System with React, PHP, Laravel, & MySQL

PHP Front To Back [Part 9] - Include & Require

PHP Front To Back [Part 7] - Conditionals & Comparison

PHP Front To Back [Part 15] - PHP Contact Form

PHP Front To Back - [Part 13] Ternary & Shorthand Syntax

PHP Front To Back [Part 22] - MySQLi Insert, Update & Delete

PHP Front To Back [Part 4] - Arrays

PHP Front To Back [Part 17] - Cookies Tutorial

PHP Front To Back [Part 12] - Common String Functions

PHP Front To Back [Part 14] - Filters & Validation

PHP Front To Back [Part 19] - File System Functions

PHP Front To Back [Part 11] - Get & Post Tutorial

PHP Front To Back [Part 8] - Dates & Timestamps

PHP Front To Back [Part 3] - Variables, Constants & Data Types

PHP Front To Back [Part 18] - PHP & AJAX

Should You Learn PHP? - Pros and Cons