WordPress SQL Query on new table

February 21, 20234 Views

I am using wordpress and I’ve created a new table in the wordpress database.

I have then created template and I am adding custome php code in there but wrapped in wordpress header and footer.

My question is, how can I query my new table, as wordpress already does the database connection etc..

Thanks

Post Views: 4

2 comments

Anonymous says:

February 21, 2023 at 1:30 am
In the WordPress documentation there is a section “Run any Query on the Database” that suggest to use:
```
<?php $wpdb->query('query'); ?> 
```
Where query is your SQL query you want to execute.

Please be sure to protect your queries against SQL injection to avoid these kind of things:
Log in to Reply
Anonymous says:

February 21, 2023 at 1:30 am

Use the $wpdb class reference.

Log in to Reply