Assign the values of an stdClass Object into a string variable with php

Question

How do I get the values of the stdClass Object into a string variable so that I can take that variable and use it in an insert statement in another function. I'm using json_encode/json_decoding if that helps or makes a difference?

so the string variable will be:

$stdClassObjectStringVariable = 'test','[email protected]', 2, 15, 'test', '[email protected]', 'test test', 2, 14, 1, '','Lorem ipsom dolor..';

Object and Function:

stdClass Object
(
    [NominatorsName] => test
    [NominatorsEmail] => [email protected]
    [NomDivision] => 2
    [NomUnit] => 15
    [NominatorsSupervisor] => test
    [NominatorsSupervisorsEmail] => [email protected]
    [RecipientsName] => test test
    [RecipDivision] => 2
    [RecipUnit] => 14
    [Category] => 1
    [Reason] => 
    [Message] => Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
    [Continue] => Continue...
)

public function SaveToDatabase(){
    $sql = "INSERT INTO recognition (
                `nominator`,
                `nominators_email`,
                `nominators_division_id`,
                `nomimators_unit_id`,
                `nominators_supervisor`,
                `nominators_supervisors_email`,
                `recipient`,
                `recipients_division_id`,
                `recipients_unit_id`,
                `category_id`,
                `reason`,
                `message`) VALUES(" . $stdClassObjectStringVariable . ");";
    $this->query($sql);
    return $this->insert_id;
}

@stachu That doesn't produce something that can be substituted into an INSERT statement. — Barmar
– Barmar, Commented Jul 28, 2015 at 21:50
I saw that but I'm using json_encode and json_decode will it still work the same with that? — Mary
– Mary, Commented Jul 28, 2015 at 21:51
Of course not. I give you fishbot, if you want a code written by me so pay me :) — ventaquil
– ventaquil, Commented Jul 28, 2015 at 21:52

RiggsFolly · Accepted Answer · 2015-07-29 09:28:06Z

1

Maybe I am not understanding your question correctly but it seems to me that you want to get all of the properties form a class and format them into a string. if this is correct then here is an implementation.

Solution (but it depends upon the class property names matching the table column names)

I recommend using get_object_vars(). This will return an array of all accessible and non-static properties.

Then just implode() the array's values and use that for your string.

So maybe something like this...

$stringForQuery = implode(",",get_object_vars($someClass));

This does not guarantee the correct order however (Thanks @RiggsFolly).

DANGER: This is not necesarily safe for MySQL. This will NOT cleanse the data for MySQL or defend against MySQL injections. BE WARNED

More Comprehensive Solution

This solution solves some order and MySQL safety issues.

$properties = get_object_vars($someClass);

foreach ($properties as $key => $value)
    $cleanProperties[mysqli_real_escape_string($mysqliLink,$key)] = mysqli_real_escape_string($mysqliLink,$value);

$sql = "INSERT INTO recognition ('" .
    implode("','",array_keys($cleanProperties)) .
    "') VALUES ('" .
    implode("','",$cleanProperties)) .
    "');"
;

edited Jul 29, 2015 at 9:28

RiggsFolly

94.7k22 gold badges108 silver badges152 bronze badges

answered Jul 28, 2015 at 22:27

Hurricane Development

2,4682 gold badges21 silver badges42 bronze badges

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

2 Comments

RiggsFolly Over a year ago

And there is no guarantee that the data will be in the same order as the column names either.

RiggsFolly Over a year ago

That was basically what I was going to suggest, but only if she answered my question in the affirmative, that she could change the property names used in the class. Currently the property names dont match the column names so while I think this is the correct idea it does depend upon the class property names matching the table column names. And currently they dont!

Collectives™ on Stack Overflow

Assign the values of an stdClass Object into a string variable with php

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related