The binary protocol allows you to use the MYSQL_TIME structure to send and accept DATE and TIME values (DATE, TIME, DATETIME, and TIMESTAMP ). In section 25.2.5, "data type of CAPI preprocessing statements" describes the members of this structure. To send temporary data values, use mysql_stmt_prepare () to create a preprocessing statement. Then, before calling mysql_stmt_execute () to execute the statement, you can set each temporary parameter in the following steps... the binary protocol allows you to use the MYSQL_TIME structure to send and accept DATE and TIME values (DATE, TIME, DATETIME, and TIMESTAMP ). In section 25.2.5, "data type of c api preprocessing statement" describes the members of this structure. To send temporary data values, use mysql_stmt_prepare () to create a preprocessing statement. Then, before calling mysql_stmt_execute () to execute the statement, you can set each temporary parameter as follows: In the MYSQL_BIND structure related to the data value, set buffer_type to the corresponding type, this type specifies the temporary value type for sending. For DATE, TIME, DATETIME, or TIMESTAMP values, set buffer_type to MYSQL_TYPE_DATE, MYSQL_TYPE_TIME, MYSQL_TYPE_DATETIME, or MYSQL_TYPE_TIMESTAMP. Set the buffer member of the MYSQL_BIND structure to be used to pass
1. time-related functions for getting started with MySQL
Introduction: PHP extension date and time functions
The above is a detailed description of the recommended time-related functions. For more information, see other related articles in the first PHP community!