Custom Database Queries in WordPress | WordPress Tutorials
ฝัง
- เผยแพร่เมื่อ 14 ต.ค. 2024
- Custom WordPress Database Queries as requested.. Use $wpdb WordPress object to do a database query.
Company Website: www.ideapro.com
SEND BUSINESS CORRESPONDENCE TO:
Idea Pro LLC or Joshua Herbison
2901 E Greenway Rd. #54171
Phoenix, AZ 85032
In my tutorials, you will see me upload files to the server. To upload, I use Sublime Text 3 with SFTP by WBond. idp.bz/sftp
WordPress Codex: idp.bz/wordpres...
![ILLSLICK - WINTER IS COMING [Official Video]](http://i.ytimg.com/vi/dwTMeM1zIhQ/mqdefault.jpg)
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
Awesome! Thank you for watching and commenting..
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!
That is awesome. It really assists beginners on WordPress to understand how effectively query data from the database. However, how would the user navigate to the result of the query page on the browser without manually entering the url? I love the method of teaching. Clear, concise and visual are visible.
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 was very very well made, and a total lifesaver for many people in various projects Joshua. Keep it up you are helping a lot.
Thank you for watching and commenting.
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.
This is immensely helpful - has been more effective for me than some courses. Thank you!
Thank you for watching and commenting.
Great! You are a wonderful teacher. Very helpful. Thanks
Thank you for the compliment and comment.
DUD ty
rrrrrrrrrllllllllly ty
you're lookin directly and answer full of the problem
more people dont do this ...
ty
Awesome.. Thank you for watching and commenting.
Great vid again! Would love a custom tables creation and CRUD tutorial in future. :)
Awesome. Thanks for watching and commenting.
I didn’t know you could do sql type queries directly in Wordpress awesome
Thank you for the comment and watching.
Well done. I looked around for this information so much, and this was straight forward and clearly explained.
Thank you for the comment. Glad you liked it.
Super clear and easy to understand.!!!!. Thank you.
Thank you for watching and commenting.. Glad to hear it was clear and easy to understand.
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?
Thank you for the question. It can be done, but you would need to connect to the second database and make sure to not conflict with your current DB connection. I would suggest creating an API style code outside of your WordPress install to the second database and then use something like cURL to pull in that data that you fetch from the cURL command. If you have more details or an example, I could make a video explaining it.
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.
So is the website WordPress, and then you have a different database that holds the gravity form information?
@@jherbison YES. That's is exactly my situation. What options do I have to implement that?
FYI: It's also a MySQL database.
Thank you Joshua , these videos are very well made and very usefull. Many thanks.
Glad you like them. Thank you for watching and commenting.
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 :-)
When commenting something like that, please explain what they should do instead! Thank you.
Great tutorial!
Thank you! Thank you for watching and commenting.
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?
Thank you. Hope you found a solution for this as I missed your comment. There are many ways to do this. Thank you for watching and commenting.
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.
Thank you for watching and commenting. I am trying to catch up on comments that I missed.
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!
Not exactly sure what you meant, but hope the video helped and thank you for commenting.
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?
Also I’m using get_col() because apparently get_results() was causing critical errors. [undefined function get_results]
It shouldn’t give you an error of undefined function unless you are calling that function before Wordpress core has loaded the function. It would be interesting to see how your code is setup.
As far as the query, are you trying to sort by the distance from a given point? Where is the distance stored? As meta value?
@@jherbison I can hop on a zoom meeting(screen share) or something if you are available.
@@jherbison Yes, starting from a given point. I made a view in the database for the same since the data was scattered all over. And using the sql query in view to sort.
Great! , how we can speed up search in post content ? , that is not indexed ?
Yes, searching the post_content is slow. I would suggest adding tags to the post for the keywords that are searched most or what words you think are searched for. Not really anyway to speed it up unless you find keywords in the post_content and put those automatically as tags.
Good Work, Comment from Pakistan.
Thank you! Welcome!
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!
Glad you understand a little more about your solution. Not sure what you need help with. If you need to you can add a function and modify the content with add_filter('the_content','YOUR_FUNCTION_NAME');
Let me know if that makes sense.
Cool, can we make section in page or theme customize panel to show content by post type and category like elemntor advance query control
I hope you found a solution for this.. If not, can you explain a little more about it?
Trying to catch up on comments that I missed.
Thank you for watching and commenting.
If you haven't already, please check out my latest video: A Day In the life of a software engineer. th-cam.com/video/Z8GluDQ2U-E/w-d-xo.html
Hi Joshua, which php-editor are using?
Sublime text
Thank you for watching and commenting.
@@jherbison Thank you
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
On the ajax page that is loaded, use require_once('PATH_TO_ROOT_WORDPRESS_FOLDER/wp-load.php');
Then WordPress is loaded on that page.
@@jherbison Thanks for replying. I went onto to some other tutorials and learnt about admin-ajax.php and nonce and have built my very first plugin. Will have to show you sometime
Great explanation. Well, put together. 👍
Thank you for watching and commenting.
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? :)
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.
I have not dug into woocommerce that much as I don't like it. I have only been in to fix errors. If I get time, I will take a look at it and see how to update the quantity. Thank you for watching and commenting.
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.
That's cool.. You can use WP_Query.
Please make the complete course for wordpress
Thank you for the comment.
Keep posting Joshua !!
Thank you. I have some videos in the queue, just haven't had time to get them recorded. Thank you for the comment.
There has been a recent update to Wordpress core, about a week ago. Is this still safe to use and won't break anything?
Yes, it still works and should not break anything unless you write the query wrong.. I would always do it in a dev staging area before doing it on a live website. Thank you for watching and commenting.
@@jherbison Thanks for the quick reply!
@@jherbison ps: your tubebuddy link is broken
Yeah, I need to remove it. I stopped using TubeBuddy as it was too expensive for what I was getting out of it. Thank you for letting me know. Forgot it was even still a link on the description.
Your welcome. Sometimes I have more time to reply then other times.
is this method works with products also?
Yes, you should be able to query any information in the database. Thank you for the comment.
Thank you so much!
You're welcome.. Thank you for watching and commenting.
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
You should be using php 7 at minimum. It should work on all versions of WordPress since about version 4.. Maybe the path is wrong. Hope you were able to figure it out. Thank you for watching and commenting.
this tutorial was very helpful I need your help in the same kind of project. can you help me?
Hope you were able to figure out your project.. Thank you for watching and commenting.
I have a question.... where are you doing this from?
Do you mean location? If so, my home office in Scottsdale Arizona.
I was more interested in a directory path but I’ll type in your city and state and see what I get... 😉
Dude if you dont already have one, you need to make a udemy course for selling your awesome knowledge!
Thank you. It isn’t about the money. I enjoy helping others. If I did it as a course on udemy, then it would become a job! Thank you for the comment.
@@jherbison interesting perspective! I actually jump out of the Udemy course to come here and get some clarification. Your pace is so much more natural. I guess your perspective on doing the videos is the reason why you do them so well.
5:00 sound like hacking 🤣
Not hacking at all.. Just writing the code to your benefit.. Hacking would be accessing someone else's admin area... ;-)
My database failing to connect even after following step by step.
Can you email me your code to josh@ideapro.com so I can see what is happening? Thank you for watching and commenting.
Thank you sir !
You’re welcome. Hope it helped. Please share the video with anyone that it can help. I really want to start growing the channel but need more subs and views. Thank you for your help and comment.
@@jherbison sure sir!
Thank you so much!
Thank you for watching and commenting.. Trying to catch up on comments.