[SOLVED] Insert command from PHP not working

[Ikoshop]

I'm getting acquainted with reading and writing from the Prestashop database. I  am trying to get an INSERT statement to work.

$result should be true or false here, but instead it's a null value and nothing is written to the database. 

The command itself, if I run it from the phpmyadmin interface, works just fine.

The docs mention using _DB_PREFIX_ but I'm not sure what the point of that is, and if I have to remove the 'ps_' just to re-add it with the prefix variable?
 

EDIT: updated opening post as the site blocking the SQL quote made it too confusing.

Edited December 9, 2024 by Ikoshop
solved (see edit history)

[Prestashop Addict]

execute( instead of executeS( that's all. executeS is only for queries

[Ikoshop]

Thanks. I wonder why it's not either writing to the database or giving a result.

[Prestashop Addict]

Don't forget to change your title post by adding [SOLVED] and add a Thanks or Like to the good answer, this will help community.

[Ikoshop]

Nothing is solved. I realise the code I tried to share didn't post.

 

updated opening post to try make it clearer

 

Edited December 9, 2024 by Ikoshop (see edit history)

[Ikoshop]

For what it's worth, using the _DB_PREFIX_ makes absolutely no difference.

[Ikoshop]

OK, as it turns out, it is not possible to execute more than one command at a time, even separating them by ;

This is different from ExecuteS, which allows multiple commands to be executed successively.