SQL error Catchable fatal error: Object of class stdClass could not be converted to string

Question

function getjobid() {
global $geotag_table, $wpdb;
$qry = "SELECT * FROM mirdc_jo_form WHERE  jo_id = (SELECT MAX(jo_id)  FROM mirdc_jo_form)";
$desc = $wpdb->get_results($qry);

return $desc; }

can you help me guys.. i am trying to get the id from my table and try to show the data to my wordpress..

<?php  foreach (getjobid() as $generatedid) {
echo $generatedid;?>  #<------ this is the error

this is my wordpress code.. can you teach me how i convert the object to string.. to show the result to my wordpress.

the error is self explanatory that you are trying to echo an object. <?php $array_data = getjobid(); ?> now print it first and then work accordingly. Show use what you got after printing this variable — Death-is-the-real-truth
– Death-is-the-real-truth, Commented Jan 11, 2017 at 5:16
uhmm sory sory i am just a begginer how i convert it to string ? — Elli Joshua Rey
– Elli Joshua Rey, Commented Jan 11, 2017 at 5:18

Manish Jesani · Accepted Answer · 2017-01-11 05:37:47Z

2

Please try this is batter for your code

function getjobid() {
global $geotag_table, $wpdb;
$qry = "SELECT jo_id FROM mirdc_jo_form WHERE  jo_id = (SELECT MAX(jo_id)  FROM mirdc_jo_form)";
$desc = $wpdb->get_col($qry);

return $desc[0]; }
$lastid = getjobid();

answered Jan 11, 2017 at 5:37

Manish Jesani

1,3555 gold badges22 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

Elli Joshua Rey Over a year ago

ohhhhh .. i see..sr can you explain to me why it is better to my codes.. sory i am a beginner and trying to study here :D

Manish Jesani Over a year ago

@ElliJoshuaRey your query SELECT * FROM mirdc_jo_form........ you get all field from database table but as your requirement only one field 'jo_id'. so why are you get all field. so your information vary large database you get one field mysql query fast response from database otherwise your site SLOW....

Elli Joshua Rey Over a year ago

ohhhhhhhhhhh isee thx for your informative information i will always take note it :D

Elli Joshua Rey Over a year ago

sr i have a question.. what if i dont have value on my table.. and if there is no data on my table. i want to have value of 1.. try an if statement and there is wrong to it

if (!$lastid) {     echo "Ther is no data";     echo $val1; } else {     foreach ($lastid as $row) {         $auto = $row->jo_id;         if ($auto === ''){             echo "There is no id!";            } else {             echo $auto;         }     } }

the wrong part is when theres a value on my table it gives me a lot of 9999999 (my last id is 9) why it give me so many 9?

Elli Joshua Rey Over a year ago

dumb of me xD why i put an foreach statement when i already get the jo_id if (!$lastid) { echo "Ther is no data"; echo $val1; } else { echo $lastid->jo_id; }

|

Ashwini Agarwal · Accepted Answer · 2017-01-11 05:17:39Z

1

$generatedid is an Object and containing entire row of data. You need to specify what column you want from that row.

You should try var_dump($generatedid) to view all the data.

foreach (getjobid() as $generatedid) {
    echo $generatedid->jo_id; // or whatever ID you want from DB 
}

answered Jan 11, 2017 at 5:17

Ashwini Agarwal

4,8582 gold badges44 silver badges59 bronze badges

7 Comments

Elli Joshua Rey Over a year ago

OWWW i see that was it :( i am so noob THX SR T_T

Elli Joshua Rey Over a year ago

i tried it earlier ---- echo $generatedid["jo_id"]; but it was wrong

Ashwini Agarwal Over a year ago

It's an object, you should try $generatedid->jo_id

Elli Joshua Rey Over a year ago

i am new here and it help me a lot when i don`t understand in programming :D so many people want to help if i have a question..

Ashwini Agarwal Over a year ago

It's a learning phase for all of us. Everyone was new at some point of time. Keep up the spirit and keep going. Wish you all the best. :)

|

Collectives™ on Stack Overflow

SQL error Catchable fatal error: Object of class stdClass could not be converted to string

2 Answers 2

7 Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related