24 | Selecting Data Using PHP From Your Website! | 2023 | Learn PHP Full Course For Beginners

In this PHP tutorial I will teach you how to SELECT database data using PHP from your website! 🙂 Being able to select data from your database directly from your site, opens up a lot of cool opportunities and features you can do in a website, and is one of the milestones most people look forward to reaching when it comes to PHP.

➤ TIMESTAMPS

00:00:00 - HTML search form

➤ GET ACCESS TO MY LESSON MATERIAL HERE!

First of all, thank you for all the support you have given me!

I am really glad to have such an awesome community on my channel. It motivates me to continue creating and uploading content! So thank you!

I am now using Patreon and YouTube Memberships to share improved and updated lesson material, and for a small fee you can access all the material either from my memberships or Patreon, depending on your preference. I have worked hard, and done my best to help you understand what I teach.

I hope you will find it helpful :)

[Dani_Krossing]

Sorry about the re-upload! 🙂 I had accidentally left out a extremely important security step in the last upload, where we forgot to sanitize the data before outputting it, using htmlspecialchars(). This step is important enough that I believe a re-upload is necessary, so I have re-recorded the entire last part of this video. Thank you @Graham Ince for bringing this to my attention.

[sammygitongar]

The amount of knowledge one can access on YouTube due to teachers like you is ridiculous. Keep up the good work.

[Izkawi]

if you complete this course and add security one it will be the best one I have ever seen in youtube.

[Jensees]

This course is the best one on programming I've ever seen on YouTube. Thank you so much for your work! Thanks due to this course I truely understand PHP and can build things on my own.

[odiseevansyomi]

I'm watching this tutorial to understand how database content is projected to users on a website, and I must admit, this is quite helpful. Thanks a lot, Dani!!

[kasunkumarasinghe]

Another wonderful lesson. I am doing my project using PDO method with your guide videos.

One small thing Dani, at 14:28 (line 24 in search.php) shouldn't it be "header("Location: index.php");" since we are in same folder....?

[skikso]

Nice video❤.... Sir can you just make a video of crud operation + join method. Because i was asked this question in an interview.

[ruudkorunka]

Is it possible to select (copy) a new row of data from the database automatically into an html table, after the user has clicked the submit button?

[ClashRoyale-ptzj]

Even when we are echoing out data from inside our database (which is intended to already have been stored after due sanitizing), is it still necessary to wrap up this data with escaping functions such htmlspecialchars?

[DaedalusDM]

Hey Dani. Excellent video as always. Thank you for all of these. A snag I've run into with this particular lesson is that I've tried to apply these principles to a slightly different scenario and I've messed it up somewhere along the line. I'm trying to simply populate a table with all available info from MySQL using this method, but with instead using a SELECT * approach. The problem is that I am following this almost exactly, but when I try echo data I receive a repetition of ArrayArrayArray as opposed to the actual contents of table columns. Am I misunderstanding associative arrays altogether and am trying to approach printing out info with the wrong solution, or what could be the problem that causes this?

[nhatanh]

Hi Krossing, I dont know if you can share with us the CSS files that you use in this video, just to make it easier to follow and code the same in the video!

[AustinHaynes-qofo]

I have a question which may be stupid, but how does the button on the form know which page to take the user to without setting an <a href="">

[AgenceWebSigma]

in the first episodes of this playlist, you used htmlspecialchars to sanitize inputs from the user and now you are using this method for outputs. I think the data is already sanitized. Why sanitize it when outputting? Can you explain to me please because I am a little bit confused :) advanced Thanks.

[KAREKINFPV]

I love your content but I feel like this should have been 23 and 23 should have been 24. :-)

[drewplayz]

hey thanks for the great teaching but I'm sort of finding it hard as every 2 min you are using a new function which I haven't heard before in the tutorials. How do I learn those.