too long

Question

Ok here's the short hands on, i have custom function that runs 8 MySQL queries SELECT, UPDATE, DELETE. Now i have strict standards on so i had to remove error message each time i run query. So i did error_reporting(0); and next query then error_reporting(-1)

        $add_log = "INSERT INTO ac_cand_log
                        (
                            id,
                            action,
                            time
                        )
                      VALUES
                        {$var}";
        $error_reporting = error_reporting();
        error_reporting(0);
        MysqlFns::ExecuteQuery($add_log, "insert");
        error_reporting($error_reporting);

Now i am confused because i run the function and it does not produce necessary result for some reason. I am sure it run until the end. Does switching error reporting level can drive php/mysql nuts?

I also just imported backup database moments before it happened. I know this happened to me before when i just started working on this project and imported database i could not trace why and then it stopped.

Basically i set error_reporting(-1); in all queries in function and put die; at the end funny thing it showed strict standard warning and no other warnings for each query that executed however database was untact and when i refresh page all records was the same as before running query.

Can someone solve this mastery for me?

Answer 1

You need a function like this

function skip($boolean = true) {
    if($boolean) {
         error_reporting(0);
    }
    else {
         error_reporting(E_ALL | E_STRICT);
    }

Before query,

skip(true);
#Query here#

after query, need to turn error_reporting to default

skip(false);

and if not useful, you need show your mysql function use to query