pdo update work in xamp but not work in server

Question

I use this function to update a table.

It works correctly in xamp and local but on the server it returns this error:

Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ': WHERE id=1' at line

function update($sTable, $aValues = array(),$key,$debug = 0){

        global $pdo;
        unset($aValues['edit']);
        unset($aValues['update']);

        if (!empty($aValues) && !empty($sTable)){

            # validation of table / columns nam

            $aColumns = array_map('mysql_real_escape_string',array_keys($aValues));

            $aElements = array();

            foreach ($aColumns as $sColumn){

                $aElements[] = "`$sColumn`= :$sColumn";

            } // foreach

            $oPDOStatement = $pdo->prepare("UPDATE $sTable SET " . implode(',', $aElements)." WHERE `id`=$key");

            $oPDOStatement->execute($aValues);

            if($debug==1) print_r($oPDOStatement->errorInfo());

        }
    }

You're mixing a `mysql_` function `mysql_real_escape_string()` with PDO, Those different APIs don't intermix together. The colon in `:$sColumn` could also be a factor. — Funk Forty Niner, Mar 14 '15 at 13:39
Edit your question and print out the `update` statement after variable substitution. My guess is that the syntax error will be obvious. — Gordon Linoff, Mar 14 '15 at 13:39
after all update error return . and "this function work correct in xamp and local but in server return this error" — bnnoor, Mar 14 '15 at 13:42
@GordonLinoff Plus, mixing in an `mysql_` function doesn't help neither. — Funk Forty Niner, Mar 14 '15 at 13:45
We would need to know which API you're actually using to connect with. Is it `mysql_`, `mysqli_`, PDO? — Funk Forty Niner, Mar 14 '15 at 13:53
@Fred -ii i using pdo $pdo = new PDO('mysql:dbname=db;host=localhost', 'root', ''); — bnnoor, Mar 14 '15 at 13:55
Hard to say, but have a look at these Q's and A's http://stackoverflow.com/q/22793617/ http://stackoverflow.com/q/14195032/ and possibly http://stackoverflow.com/q/11999343/ — Funk Forty Niner, Mar 14 '15 at 14:01

pdo update work in xamp but not work in server

0 Answers0