php - Any possible way to make $wpdb->get_results() return anything else than array?

admin管理员组

文章数量:1130349

So I'm using $wpdb->get_results() to query my database and then make AJAX call from JS file. The problem is that I need to get the value itself, like a string, instead of array, but as much as I know, get_results return only array. Is there any way around this to get string value from database? Or should I use something else than get_results()?

So I'm using $wpdb->get_results() to query my database and then make AJAX call from JS file. The problem is that I need to get the value itself, like a string, instead of array, but as much as I know, get_results return only array. Is there any way around this to get string value from database? Or should I use something else than get_results()?

• php
• ajax
• database
• query
• wpdb

Share Improve this question asked Nov 13, 2018 at 17:27 LimpulsLimpuls 30711 gold badge33 silver badges1616 bronze badges 2

• Why not use that array and get the string from it? – kero Commented Nov 13, 2018 at 17:32
• I converted it to JSON but still don't know how to access the string in the loop. I have an array of json objects here. Any hints? – Limpuls Commented Nov 13, 2018 at 17:55

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

$wpdb->get_results() only returns arrays( associative or numeric) or an object. It does not return a string value.

If you want a string value, you need to use $wpdb->get_var() instead

So I'm using $wpdb->get_results() to query my database and then make AJAX call from JS file. The problem is that I need to get the value itself, like a string, instead of array, but as much as I know, get_results return only array. Is there any way around this to get string value from database? Or should I use something else than get_results()?

So I'm using $wpdb->get_results() to query my database and then make AJAX call from JS file. The problem is that I need to get the value itself, like a string, instead of array, but as much as I know, get_results return only array. Is there any way around this to get string value from database? Or should I use something else than get_results()?

• php
• ajax
• database
• query
• wpdb

Share Improve this question asked Nov 13, 2018 at 17:27 LimpulsLimpuls 30711 gold badge33 silver badges1616 bronze badges 2

• Why not use that array and get the string from it? – kero Commented Nov 13, 2018 at 17:32
• I converted it to JSON but still don't know how to access the string in the loop. I have an array of json objects here. Any hints? – Limpuls Commented Nov 13, 2018 at 17:55

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

$wpdb->get_results() only returns arrays( associative or numeric) or an object. It does not return a string value.

If you want a string value, you need to use $wpdb->get_var() instead

本文标签： phpAny possible way to make wpdbgtgetresults() return anything else than array