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?