Use code as below :
<?php
$myotherdatabase = new wpdb("username","password","databasename","localhost");
$motscles = "abri";
$query = "SELECT `post_id` FROM `wp_postmeta` WHERE `meta_key` = 'nom' AND MATCH (`meta_value`) AGAINST ('" . $motscles . "' IN BOOLEAN MODE)";
$result = $myotherdatabase -> get_results($query, ARRAY_A);
foreach ($result as $post) {
$pids .= $post->post_id . ",";// ARRAY_A
}
echo $pids;
?>
Related Posts:
- MySQL SELECT increment counter
- Is it fine to have foreign key as primary key?
- Detecting errors generated by $wpdb->get_results()
- wpdb update add current timestamp not working
- Custom form that store input in database
- Restoring WordPress posts from database only
- Displaying content from one WP site on separate WP site
- Lost the `wp_options` table: what’s the best way to restore the site?
- Issue with wp_insert_post and post_content field error Could not update post in the database
- wp_posts – guid update
- Performance Gains of Relational DB Setup
- How to move existing WordPress wp-content folder along with database to new server and new domain name?
- store simple data in get_option()
- How might I retrieve a featured post image from an external WP site and display it as a link back?
- What are conventions about the schema of the $table_prefix
- WordPress database becoming huge. How to analyze and optimize it? fear of running out of memory
- Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
- BuddyPress: What’s the use of wp_bp_xprofile_data table and how does it get updated? [closed]
- storing database in version control
- Is deleting orphaned wp_options entries safe?
- How to build a movie database with wordpress?
- What’s the most efficient database method to add and query usermeta?
- How to solve slow WordPress site caused by attachment_metadata
- Sub-domain or 2nd, temporary different domain?
- How do i get user data from a custom table in the wordpress database by user ID?
- Converting WordPress into Android or iPhone app
- Large database causes slow load
- Safe way to find last inserted id in a table?
- Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
- Database slowdown after update to 3.4.1
- WooCommerce sku location in DB
- How to insert data into MySQL database from the form created in WordPress site
- Emoji support and MariaDB 10.0.30-
- WordPress DATABASE Update Manually?
- Is it possible to store visitors IPs in wp_postmeta table?
- Which is more efficient? Using usermeta, or creating a new MySQL table?
- Can I have multiple database users within WordPress?
- How do I copy a wordpress database?
- Export all content from wordpress
- Import live site to local setup without access to live site
- Modify Database in Multi-Site wp_usermeta table
- Form Data not getting stored in WordPress database
- Hook directly into query execution
- Best way to tell if a user account is active, using the database only
- Structure of postmeta meta_value for woocommerce product download
- $wpdb doesn’t like to store arrays
- Connect to a remote database for wordpress in my own hosting server
- WordPress ‘repairing database’ in a constant error loop?
- What Is the Proper Way to Merge Usermeta Table to a an existing WP Database?
- Importing CSV into database table not working?
- A MySQL DB within a MySQL DB
- “Database Connection Error” upon install in Apache VirtualHost document root.. Why did this happen? [closed]
- How Can I Put Meta_Compare in the Database-Query?
- Check if an option exists and get its value in one hit
- Change options table prefix only
- What’s the proper way to sanitize checkbox value sent to the database
- Problems with moving my WordPress site to another domain/server
- Is it important to have integers inserted using %d rather than %s?
- Export a custom Mysql database product catalog to WordPress
- Any risk to changing WP table col CHARACTER_MAXIMUM_LENGTH?
- Global__r connection timed out
- Connect to database in the header of my WordPress website
- Should I store critical css in the database or in my theme’s filesystem?
- WordPress url transformation script
- Location of WP default mySQL tables creation file?
- Is it risky if I update all url in the database due to my site url changed?
- Select From wpdb – Author/User Directory page
- Just created a WordPress Table can’t get $wpdb get row to work – need help
- Need help fixing sql syntax error after WP 3.2 upgrade
- Need help with creating a searchable user data by name or specific number like ID
- $wpdb->insert not inserting all rows
- Intentionally corrupt WordPress database
- How to re-connect WP files in lampp/htdocs to new SQL database to recover site under development
- I need to find posts that contain YouTube links without http:// or https:// prefix and add http:// to all of them
- How can I find user role in Mysql?
- How would I see which wordpress posts have a revision history without opening each one?
- Creating a custom form with ability to query and submit to SQL
- Insert variables into wpdb in custom post template
- error establishing a database connection 3
- User saved through WordPress backend does not show up in database table users
- Correct and secure way to access a custom SQL database in a custom PHP template file
- Does WordPress Support Using Named Pipes on the Windows Operating System?
- Missing latest posts and options after DB migration via phpMyAdmin
- get_the_terms is not working
- Custom metabox does not store data
- How do i get value from wp_postmeta?
- Local host to server import problem
- Restoring .sql backup results in “Error establishing a database connection”
- Link to handle $_GET request
- WordPress sync with phpbb
- “MySQL server has gone away” since update to 3.8
- featured image not showing up with mysql_connect
- Getting deleted users in database
- Options of accessing wordpress data from mobile app
- Getting data from a table using a query
- Database interaction (private-public) [closed]
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
- wp_usermeta key problem
- Database Queries are crashing the server
- Uploading to WordPress Database