Php + access encountered an error !! Hope to help solve this problem !! It is estimated that the job will be laid off if it cannot be done !! Php + access error. An error occurred while inserting the database. The younger brother has insufficient experience. hope you can give me some advice! The operation method is dao. The access document field uses Remarks. However, during the test, a maximum of 700 words can be entered and inserted normally. if too many Chinese characters are entered, an error occurs for a long time: php + access encountered an error !! Hope to help solve this problem !! It is estimated that the job will be laid off if it cannot be done !!
Php + access error. An error occurred while inserting the database. The younger brother has insufficient experience. hope you can give me some advice!
Operation method:
Dao method.
The access document field uses Remarks. However, during the test, a maximum of 700 words can be entered and inserted normally. if too many Chinese characters are entered, an error may occur for a long time:
====================================
Fatal error: Uncaught exception 'com _ exception' with message'
Source:Microsoft ole db Provider for ODBC Drivers
Description:[Microsoft] [ODBC Microsoft Access Driver] the syntax of the string is incorrect in the query expression ''test data test data! The big picture is the big picture. Where did the three major branches go, Dr. ashisfan, Satan? Satenzafenza local: Dr. ashisvanza, Satan FA [test data ???????????????????????? ??? Too many ??? Why ?? How can I renew my instances? ?? Why are there too many other users ?? Alimama ?? Why? When there are too many threads ??? Why? Too many? Why? Kai Chen ?? Why? What are the possible reasons? Why is it true? Why are there too many other users? Why are there too many other users ?? Too many tasks? Too many calls ??? What is nitrogen mark ?? Why? Too many? Why ?? Why ??? In the specified region. 'In F: \ server \ vhosts \ testgengxin \ houtai98 \ func. php: 63 Stack trace: #0 F: \ server \ vhosts \ testgengxin \ houtai98 \ func. php (63): com-> Execute ('Insert into art... ') #1 F: \ server \ vhosts \ testgengxin \ houtai98 \ d58rx5s4rer7tx. php (21): addArticle ('???????????????... ','???????????????... ') #2 {main} thrown in F: \ server \ vhosts \ testgengxin \ houtai98 \ func. php on line 63
========================
Hope to help solve this problem !! Thank you! My QQ434818735
------ Solution --------------------
Print out the SQL statement and check what is the data type of about 700? You can use text
Finally, you don't have to worry about it. it will be done. Fuel
------ Solution --------------------
First confirm that the data has been escaped
------ Solution --------------------
Getting ridiculed
Discussion
$ Item = "test data ";
$ Escaped_item = mysql_real_escape_string ($ item );
------ Solution --------------------
Discussion
Getting ridiculed
Reference:
$ Item = "test data ";
$ Escaped_item = mysql_real_escape_string ($ item );