How to solve PHPADODB database operations

Source: Internet
Author: User
The PHPADODB database operation is currently working on a project. the customer has MSSQL, but I only have MYSQL resources here, so I chose ADODB for the operation. After the MYSQL version is developed, the code is packaged to the customer (all resources are not provided due to security issues on the customer side). the test result is resolved by email, execute is not executed for addition, deletion, and modification. Only key code is pasted. Because the time is urgent, you cannot go to the opposite server for testing or access the page ,. Know php adodb database operations
Recently, I was working on a project where the customer was using MSSQL, but I only had MYSQL resources here, so I chose ADODB for operations. After the MYSQL version is developed, the code is packaged to the customer (all resources are not provided due to security issues on the customer side). the test result is resolved by email, execute is not executed for addition, deletion, and modification.
Only key code is pasted. Because the time is urgent, you cannot go to the opposite server for testing or access the page ,. Can you tell me anything you know?


$ Db = ADONewConnection ("mssqlnative "");
$ Sql9 = "UPDATE table SET table_type = 1 WHERE user_id = 1 ";
$ Db-> Execute ($ sql9 );

------ Solution ----------------------


$ Db = ADONewConnection ("mssqlnative" "); // double quotation marks in Chinese


------ Solution ----------------------
Don't joke! You must load the extension of the corresponding database before using the adodb class library.

The adodb class library also uses an error handling mechanism. do you not read the error information provided by the class library?

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.