How To Set MySql SQL_MODE to ANSI from PHP

Question

MySQL Command:

set @session sql_mode = ANSI;

What is the corresponding PHP Command??

This Approach Does Not Seem To Work:

$conn= new mysqli("localhost", "root", "", "DB");
$conn->options(MYSQLI_INIT_COMMAND, "SET SQL_MODE = 'ANSI'");

Looking at the manual - I don't think the options method is meant for this: http://www.php.net/manual/en/mysqli.options.php — Martin, Mar 05 '10 at 07:50

score 1 · Answer 1 · answered Mar 05 '10 at 09:35

1

It seems that you have missed the scope variable,try this:

SET GLOBAL SQL_MODE = 'ANSI'

answered Mar 05 '10 at 09:35

Young

It did not work when I tried it in mysql 5.7 via mysqli – Jonathan Jun 23 '16 at 23:51

score 1 · Answer 2 · answered Mar 05 '10 at 09:44

1

Does this work for you? (Sorry, can't test at the moment)

$conn->query("set @session sql_mode = ANSI;");

answered Mar 05 '10 at 09:44

middus

1

It did not work when I tried it in mysql 5.7 via mysqli – Jonathan Jun 23 '16 at 23:49

score 1 · Accepted Answer · answered Mar 08 '10 at 01:06

1

I ended up using mysqli_init instead of new mysqli() and everything worked fine.

answered Mar 08 '10 at 01:06

Joshua

3 Answers3