Hi, Joshua Herbison I would like to say that you are doing wonderful at educating people I have seen lots of tutorial videos but the way you clear things at a level that even a novice person can understand you (and I love that you don't just assume that the person who is watching have that knowledge already) . Thumbs up and you got a new subscriber. Keep it up and keep bringing these types of videos

I'm doing some custom messaging for a customer in their wordpress environment and this saved me tons of time perusing through the developer documentation. Thank you so much for the thorough explanation. Thought you'd like to know that after 3 years, this video is still providing value!

Queries can get extensive. If you understand creating custom queries, you can create great dynamic websites far beyond the possibilities of WordPress. Hope you all enjoy the video. Creators that are looking to collaborate with other creators should checkout collab.tube

This is immensely helpful - has been more effective for me than some courses. Thank you!

This was very very well made, and a total lifesaver for many people in various projects Joshua. Keep it up you are helping a lot.

This was helpful. I was having issues in-lining php db calls and figured out about 13 minutes into your video that I had a couple of missing semi-colons scattered about. Was able to do what I needed to do w/o all Google misdirection out there. Even found a nice shortcode plugin for php as all the php inline html attempts at presenting table data seemed to fail miserably. While it's still a bit kludgy, and wordpress is still mostly inelegant, at least I can create a data-centric site now. Still beats writing node and a front-end from scratch. Protip: create stored procedures to cut down on the database load with $wpdb calls.

Well done. I looked around for this information so much, and this was straight forward and clearly explained.

Great! You are a wonderful teacher. Very helpful. Thanks

I didn’t know you could do sql type queries directly in Wordpress awesome

DUD ty rrrrrrrrrllllllllly ty you're lookin directly and answer full of the problem more people dont do this ... ty

Great vid again! Would love a custom tables creation and CRUD tutorial in future. :)

Great tutorial!

Thank you Joshua , these videos are very well made and very usefull. Many thanks.

Super clear and easy to understand.!!!!. Thank you.

Sounds like loads of people want to custom query the WP database, but what if we want to query a second database that is holding a dataset unrelated to Wordpress?

Be wary of using require_once( "wp-load.php" ); Some hosting environments have the root directory WP files symlinked. What this means is the typical WP root directory files won't be where we might think they are. Using require_once() in this fashion, as we saw, will trigger a fatal error every time. Great video though Joshua, many thanks :-)

You are awesome. SUBSCRIBED! Keep it rolling. I'm having some issues connecting my gravity form to my own database [not WordPress tables] can you do a video about that? Thank you.

Thats tutorial helped me with my actual website. I use ACF plugin and I Needed to pull out countries from data base. So hard coded countries is possible to pull out, now I need to think how to by switching the countries. Thanks anyway!

Thanks, would be nice to put the data into the admin users panel column, and instead of the post data let's say, take whatever data from database and fill each users row, like ID, but as you explain we will understand how, hehe. I made it myself but couldn't get users data made by other plugin in it's own table. For users ID column there's plenty of tuts.

Good Work, Comment from Pakistan.

Thanks for the great content! I've gotten here because I'm running an affiliate program within my website and I'm needing to display specific content within the landing page for each Referror. The use case would be something like this (Jhon enrols to the referral program; Jhon includes a link instead of his home address within the address field; WP Affiliate Manager register Jhon and generates his unique link; Jhon shates his link to Jenna; Jenna cliks on Jhons link; Jenna gets to the LandingPage and sees Jhon's link on a section of the page). Thanks to you I now have and idea on how to resolve the puzzle... If you could help me some more... I'd bee a grateful follower of yours for ever!

Great explanation. Well, put together. 👍

Great Video. But I want to hear more about a main wp site and a subdomain wp site sharing data. in other words, I have a wp site installed on a subdomain that I want to query data from the "parent" wp site. Both are using the same data server but individual dbs. you briefly mentioned something about this. any chance you're working on a plugin?

Keep posting Joshua !!

Thank you so much!

Great! , how we can speed up search in post content ? , that is not indexed ?

Cool, can we make section in page or theme customize panel to show content by post type and category like elemntor advance query control

Hey Joshua, great explanation. I’ve a doubt, I’m using a plug-in to manage custom listings(posts) on my Wordpress website. Now I want to sort these listings by distance. I managed to write a sql query for the same, using which I’m able to fetch the posts ID ordered by distance. Now when I try to fetch posts data using wp query for the corresponding IDs I’m getting them in random order. How can I preserve the order of posts fetched from custom query?

Hello Joshua, i have a issue with my get_the__date() gives me the wrong current date, do you know how i can fix this issue, or do you hve any videos covering this? :)

Please make the complete course for wordpress

I've always been curious about this but I'm trying to think of situations where I would have to resort to this instead of WP_Query.

5:00 sound like hacking 🤣

Dude if you dont already have one, you need to make a udemy course for selling your awesome knowledge!

hi, how to show woocommerce product inventory (counter). i am integrating POS with online store. Based on my POS quantity I want to change website inventory stock.

this tutorial was very helpful I need your help in the same kind of project. can you help me?

including wp-load.php does not work with Updated WP 5.4, on my local machine with php 5 something, but on previous vesions is ok

Do you have any guides that show how you call this through an Ajax call? I am building an Admin page using DataTables with the data being loaded via an Ajax call. But the Ajax page has no WP loaded

Hi Joshua, which php-editor are using?

Thank you sir !

There has been a recent update to Wordpress core, about a week ago. Is this still safe to use and won't break anything?

is this method works with products also?

I have a question.... where are you doing this from?

My database failing to connect even after following step by step.

Thank you so much!