php insert into mysql table from object

Question

Please, I've got a table in an array I want to update with object with matching schema in php. query:

REPLACE INTO entries ( mail, name, gender, age, ip, t, code, v, ansvers ) 
VALUES ( '$entry->mail', '$entry->name', '$entry->gender', '$entry->age', '$entry->ip', '$entry->t', '$entry->code', '$entry->v', '$entry->ansvers' )

I'd like to know if there is any simple way to specify variables without having to create query string using loop and retrieving object/array variable keys or typing everything manually like this. for example, if I rename $entry->mail to $entry->mail2 then query will do:

REPLACE INTO entries ( mail2 ) VALUES ( `$entry->mail2` )

if needed, $entry can be changed to any data structure.

thanks.

Are both examples pseudocode, or real? Both seem susceptible to SQL injections, and VALUES ( `$entry->mail2` ) is invalid. — chris85
– chris85, Commented Apr 8, 2018 at 4:45
$entry is created beforehand in php and performs checks and escapes. due to number of security and validity check its in whole new file. the first example is real code, string in query(""). the second is just pseudocode to show what i mean. — Round-Sliced
– Round-Sliced, Commented Apr 8, 2018 at 5:10

Nick · Accepted Answer · 2018-04-08 05:38:17Z

2

If there is truly a 1:1 correspondence from the object to the table you could do this to generate the query:

$query = "REPLACE INTO entries (" . 
   implode(',', array_keys(get_object_vars($entry))) .
   ") VALUES ('" . 
   implode("','", get_object_vars($entry)) .
   "')";

edited Apr 8, 2018 at 5:38

answered Apr 8, 2018 at 5:33

Nick

147k23 gold badges67 silver badges106 bronze badges

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

1 Comment

Round-Sliced Over a year ago

thanks. i hoped for some kind of auto function, but this is simple enough and i need to return get_object_vars($entry) for other functions anyway.

Collectives™ on Stack Overflow

php insert into mysql table from object

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related