How do I make custom query with WordPress?

February 11, 20234 Views

I need to make a query in a WordPress plugin but I couldn’t find a WordPress function and I’m not sure is right to use mysql_query

The functions I’ve found enable ordering and grouping but I need to use also join and in (list).

Is there a way?

Post Views: 4

2 comments

Anonymous says:

February 11, 2023 at 11:29 am
It looks like you’d want to use the $wpdb class (which has functions for directly accessing and manipulating the wordpress database). It lets you do things like:
```
<?php $wpdb->query('select * from my_plugin_table where foo = "bar"'); ?>
```
Documentation here.
Log in to Reply
Anonymous says:

February 11, 2023 at 11:29 am
To pull out rows maybe you’d use:
```
$myrows = $wpdb->get_results( "SELECT id, name FROM mytable" );
```
Log in to Reply