Php + access encountered an exception! Hope to help solve this problem! I guess I have to take up my post!

Source: Internet
Author: User
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 );

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.