You need to repalce the PDO connection object with WPDB object. And for the kind of query in your example, looks like the best way to do it is with $wpdb->getcol. Something like this (didn’t test):
if ( isset( $_GET['term'] ) ){
global $wpdb;
$term = filter_var( $_GET['term'], FILTER_SANITIZE_STRING, FILTER_NULL_ON_FAILURE );
if ( is_null( $term ) ) {
echo json_encode( array() );
}
else {
$return_array = $wpdb->get_col(
$wpdb->prepare(
"SELECT supplier_company
FROM {$wpdb->prefix}_teleapo_supplier
WHERE term = %s",
$term
)
);
$return_arr = $return_arr ? $return_arr : array();
/* Toss back results as json encoded array. */
echo json_encode( $return_arr );
}
}
Related Posts:
- Display fields as values in array from external SQL DB
- Trying to establish connection to External Database
- How to insert a single row to WP database table?
- WSoD being caused by this piece of code
- How to use mysql LIKE with wpdb?
- Isn’t Returning Value While Using SELECT COUNT(*) FROM {$wpdb->prefix}
- Modify post image in full size
- posts_clauses drop ACF get_field function
- Function wpdb::prepare was called incorrectly. The query argument of wpdb::prepare() must have a placeholder
- Trouble getting wpdb to work – first time
- Retrieve $_POST data submitted from external URL in WordPress(NOT API)
- Pass Category Name, Description and Photo into variables to pass to jQuery
- Use DOMDocument with ob_start breaks my HTML code
- Auto-update products after they were published – Woocommerce
- How to prevent WP_Query function from returning all posts when empty?
- Querying wpdb using PHP
- wp_trim_words() does not work with my code Am I doing any mistake in my code?
- JS file work only in index page
- Display a specific category of products in shop page and disable code for specific actions
- Woocommerce related product text
- esc_html_e() is not translating string in wordpress [closed]
- Removing “wpautop” (auto tags) only on certain pages?
- Fatal error: Uncaught Error: Call to undefined function test()
- How to pick the default selected value in wordpress dropdown?
- Using WP-API and SSE not authenticating user ID
- Woocommerce: hook action/filter I could use to add variation id and price with each attribute opt on WooCommerce Rest api
- Validate functions before inserting then into functions.php
- How to retrieve current wordpress profile page URL?
- Firing schema via code in functions.php doesn’t work
- A non-numeric value encountered in /wp-includes/functions.php on line 68
- Get page that displays all children of taxonomy parent
- Ajax request not sending to server and returning – wp-admin/admin-ajax.php 400
- get author_name from queried post
- Why ajax doesn’t work on certain wordpress hooks?
- Is it possible to intercept all ajax requests and get the parameters and the returns?
- How to call plugin function per site in a multisite?
- Print last modified date only on posts
- different id for same element visual composer [closed]
- WooCommerce: How can I get orders with a custom ID in order meta data object?
- Tax query in pre_get_posts not working
- Update results, Before deleting the related category [closed]
- WordPress Gravatar filter is removing my custom attributes
- foreach loop still echoes array
- trigger html cleanup for all posts
- Error in custom php function doesn’t exist
- dynamic dependent select dropdown
- Generating an nonce for Content Security Policy and all scripts – How to make it match/persist for each page load?
- Custom shortcode outputs plain text instead of HTML at top of post
- how can i use $_COOKIE[] + PostID to execute the below code?
- Return a numerical function value in Customizer controls
- getting logged in user info (wp-load.php) from parent directory
- How can I get the values of my WordPress $wpdb query in Jquery?
- What’s the uses of wp_cache_set() or wp_cache_add()?
- Get users that likes the post
- Blog posts repeat
- Ajax load more button for comments wordpress
- How WordPress reacts to a lack of memory of the server [closed]
- wpdb php get_var query to get ID for URL image doesn’t work for ID over 999
- Function to capture a value and store it in a variable
- How to abort saving data in save_extra_profile_fields function WordPress?
- Pass php dynamic variable to shortcode
- Unique icons next to each WordPress menu item
- 3 Slashes appear after Apostrophe in custom fields after updating product-site
- How to create a php variable using WordPress the_title() function
- Keyword checking in Gravity Forms
- how to refresh div on template part?
- Child page menu in sidebar
- Populate editor with some content of a page with a page template
- Title Case WordPress Menu Items
- I want to load in a new class but only if the current page is single-movies.php
- wp query foreach deleting record returning only first or last item
- Modify function to print tags/categories/exclude tags/categories/ number of posts
- Incorrect amount of posts returned when filtering related Woo products by custom taxonomy
- Search not showing all results
- Validation algorithm in checkout field
- Css loads very slow [closed]
- Catchable fatal error: Object of class stdClass could not be converted to string after WP 4.7
- Show when user is online/offline in real time on user_profile.php
- Limit 1 global comment per minute
- Create highly customized submenu (possibly using wp_list_pages)
- Create Page To Count Comments For Each Post In WordPress Site
- Modify custom field input data before creating a new post
- Adding a widget function into the php theme file
- Update user profile information from functions.php
- WordPress Quick Question . How to Get Parent Link in Submenu in My Code
- Get the date of the className or classID
- My new button is in the wrong place
- Can’t find infinite loop cause
- how to make custom ajax handler?
- Checking array against author id in loop
- Database query works fine outside WordPress
- Compare the old get_theme_mod($name) to the new get_theme_mod($name) return value
- Scrape external webpage for first image and add it to new post
- Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
- Skt full width basic slideshow problem
- How to Reference/Echo Variable from Another PHP Function
- Remove echo from shortcode
- wp-comments-post.php file returns a blank page
- php function to display commenter username or login
- Detecting classes, adding widgets, and adding divs in with a Nav Walker