Always escape/prepare your data
Don’t leave it open to injections:
global $wpdb;
$all_posts = $wpdb->get_results( $wpdb->prepare(
"
SELECT %s.*
FROM %s
LEFT JOIN %s ON(%s = %s)
WHERE %s="soundcloud"
AND %s="%s"
"
,$wpdb->posts
,$wpdb->posts
,"{$wpdb->prefix}soundcloud"
,$wpdb->posts.ID
,"{$wpdb->prefix}soundcloud.idpost"
,$wpdb->posts.post_type
,$wpdb->posts.post_name
,$name
), OBJECT );
echo '<pre>'.var_export( $all_posts, true ).'</pre>';
Use the prefix
$wpdb;
offers the $wpdb->prefix
, which would be whatever you set in your wp-config.php
as table prefix. Then append your table name: {$wpdb->prefix}{$your_table_name}
or "{$wpdb->prefix}soundcloud"
.
Related Posts:
- writing inner join in wpdb
- How do you properly prepare a %LIKE% SQL statement?
- $wpdb and MySQL Create Trigger
- wpdb->prepare function remove single quote for %s in SQL statment
- Alternative to mysql_real_escape_string
- Increment value (value = value+1) of $wpdb->update
- wpdb Custom Meta Data with 2 conditions
- wpdb prepare syntax
- SQL query not working in alphabetical post title/content search
- MySQL LIKE not working
- Proper way to work with wpdb to get user’s firstname
- How to check for empty and not a failure
- Database: Custom table: sprintf value for DateTime column
- Converting mysql to $wpdb
- WP_USE_EXT_MYSQL
- wpdb insert and boolean fields
- How to split the a table in database?
- MySQL Rank & $wpdb
- When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
- How do I join a $wpdb query with user meta using default value if not exist?
- How to translate this mySQL query to $wpdb query
- $wpdb select all meta for each post
- $wpdb to insert html form information
- Proper usage of $wpdb->update()?
- WordPress(wpdb class) and mysql stored procedures
- Can’t run database query
- Using WPDB->Insert()
- Active DB queries in WordPress?
- How to stop $wpdb from prepending database name
- WordPress $wpdb get posts from category and sort by custom meta
- How to get INSERT errors from $wpdb?
- Getting Error Trying to Create Table
- How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
- Understanding custom php that reads from WP MYSQL
- How to insert dash (-) into database using wpdb and new_to_publish hook?
- $wpdb->get_var multiple queries in one database check
- List users with the most posts in the last 30 days
- Insert two row in wordpress database
- WordPress $wpdb no result
- PHP variables in mysql query
- MySQL ‘duplicate entry’ error
- User set date and time from frontend doesn’t get stored into database
- Wpdb query with dynamic table name
- get posts whether meta_key exists or not
- when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
- How to search usermeta table
- How to add virtual column in wpdb get_result statement
- wpdb insert into point column in db
- WPDB delivers wrong results from complex queries
- $wpdb post type and term query only works when there are no dashes or spaces in the term slug and title
- Custom user query – orderby meta_key (that may not exist)
- CONCAT_WS in custom sql query
- Geographical proximity query using post_meta
- MySQL Select within WP Page template
- Saving custom term value to the database in new table
- why is $wpdb->update() causing a DB error from within wp_set_password()
- $wpdb->get_var returns 0
- Initialization of table in database using ‘CREATE … IF NOT EXISTS’
- “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- what does “/index.php?admin/admin_dashboard” in my url mean
- How to join two tables by multiple columns in SQL?
- How to get size of mysql database?
- MySQL Error 1093 – Can’t specify target table for update in FROM clause
- mysqladmin: connect to server at ‘localhost’ failed
- mysql update multiple columns with same now()
- Usage of MySQL’s “IF EXISTS”
- Getting java.sql.SQLException: Operation not allowed after ResultSet closed
- How to create a foreign key in phpmyadmin
- Can’t create test file lower test start server mysql
- MySQL delete multiple rows in one query conditions unique to each row
- CAST to DECIMAL in MySQL
- How to copy post titles to post slug in phpmyadmin
- Triple meta_key on custom SELECT query
- If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
- Database slowdown after update to 3.4.1
- What is the most secure way to set up the MySQL user in WPMU?
- Order by custom table and multiplication
- Why is variable not working on custom sql query using wpdb?
- Unknown collation when I import a dump from an existing site into a development database?
- PHP script can’t connect to Database on port 3307
- Separate DB by yearly archive of WordPress
- WordPress running SQL query to update database from form
- What should a WordPress developer know about MySQL? [closed]
- Update MySQL query so that it functions again
- Query posts by custom taxonomy and sort by post_modified
- Trouble running $wpdb->query() with last_insert_id
- Array Formation Issue
- Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
- How to get product order by two custom taxonomy in wordpress
- form $_post action value gets truncated after it passes through two forms
- $wpdb is queried but results don’t show
- edit_user_created_user hook – using to update Groups
- Improving performance of SQL sub-queries in WordPress
- MYSQL Join on meta key value?
- Complicated MySQL Query
- InnoDB: Error: log file ./ib_logfile0 is of different size
- Postgres equivalent to MySQL’s \G?
- Putting form result in my database
- How can I update a value of a field depending on outside source?