How to change from MySQL to ADODB (1) _ MySQL

Advanced materials Insert and Update assume that you want to Insert the following data into the database. ID3TheDatemktime (,) * 31stAugust2001 * Notesugarwhydontwecallitoff when you use another database, your insert operation may not succeed. The first problem is that every database has Advanced Materials
Insert and Update
Suppose you want to insert the following data into the database.
　　
ID = 3
TheDate = mktime (2001,)/* 31st August */
Note = sugar why don't we call it off
　　
When you use another database, your insert operation may not be successful.
　　
The first problem is that each database has a different default date format. The default MySQL format is YYYY-MM-DD,
However, other databases have different default formats. ADODB has a DBDate () function that can convert a date
Change to the correct format.
　　
The next question is that the don't in the Note field value should be used as a citation. In MySQL, use
Don \'t to solve this problem, but in some other databases (Sybase, Access, Microsoft
SQL Server) use don't. Qstr () solves this problem.
　　
How can we use this function? As shown below:
　　
$ SQL = "INSERT INTO table (id, thedate, note) values (". $ ID. ','. $ db-> DBDate ($ TheDate ). ','. $ db-> qstr ($ Note ). ")"; $ db-> Execute ($ SQL); ADODB also supports $ connection-> Affected_Rows () (returns the impact of the last update or delete operation
And $ recordset-> Insert_ID () (returns the last auto-increment number generated by the insert statement ). However
Whether all databases support these two functions.
　　
　　 Policypes
You can find