php - update over odbc with prepared statements on filemaker -


i trying update string on odbc on filemaker-server contains special characters é, á etc. have use prepare statements. don´t have error logfile writing numeric 1:update:1

$conn = odbc_connect("dsn=server;database=test;uid=odbc;pwd=1234", "odbc", "1234");   $result = odbc_exec($conn, "select id, mh_data mytable mh_data '1,%'");     while ($row = odbc_fetch_array($result)){        $id = $row["id"];     $mh_data = $row["mh_data"];     $arr = explode(",", $mh_data);     $arrcount = count($arr);             if ($arrcount == 2){         $mh_data = preg_replace("/1, /", "1 ", $mh_data, 1);         $mh_data_neu = trim($mh_data);                   // update         $query = 'update mytable set mh_data=? id=?';         $stmt = odbc_prepare ($conn, $query);         $success = odbc_execute($stmt, array($mh_data_neu, $id));                  fwrite($flog, "\nupdate:" . $success);       }    }  odbc_close($conn); 

thanks help!


Comments

Popular posts from this blog

html - How to set bootstrap input responsive width? -

javascript - Highchart x and y axes data from json -

javascript - Get js console.log as python variable in QWebView pyqt -