reference/mysqli/constants.xml
e11d90ec66baf31038e800870913ff2baec5ba72
e11d90ec66baf31038e800870913ff2baec5ba72
...
...
@@ -4,65 +4,115 @@
4
4
&reftitle.constants;
5
5
&extension.constants;
6
6
<variablelist>
7
-
<varlistentry xml:id="constantmysqli-read-default-group">
8
-
<term><constant>MYSQLI_READ_DEFAULT_GROUP</constant></term>
7
+
<varlistentry xml:id="constant.mysqli-read-default-group">
8
+
<term>
9
+
<constant>MYSQLI_READ_DEFAULT_GROUP</constant>
10
+
(<type>int</type>)
11
+
</term>
9
12
<listitem>
10
13
<para>
11
14
Read options from the named group from <filename>my.cnf</filename>
12
-
or the file specified with <constant>MYSQLI_READ_DEFAULT_FILE</constant>
15
+
or the file specified with <constant>MYSQLI_READ_DEFAULT_FILE</constant>.
13
16
</para>
14
17
</listitem>
15
18
</varlistentry>
16
-
<varlistentry xml:id="constantmysqli-read-default-file">
17
-
<term><constant>MYSQLI_READ_DEFAULT_FILE</constant></term>
19
+
<varlistentry xml:id="constant.mysqli-read-default-file">
20
+
<term>
21
+
<constant>MYSQLI_READ_DEFAULT_FILE</constant>
22
+
(<type>int</type>)
23
+
</term>
18
24
<listitem>
19
25
<para>
20
-
Read options from the named option file instead of from <filename>my.cnf</filename>
26
+
Read options from the named option file instead of from <filename>my.cnf</filename>.
21
27
</para>
22
28
</listitem>
23
29
</varlistentry>
24
-
<varlistentry xml:id="constantmysqli-opt-connect-timeout">
25
-
<term><constant>MYSQLI_OPT_CONNECT_TIMEOUT</constant></term>
30
+
<varlistentry xml:id="constant.mysqli-opt-can-handle-expired-passwords">
31
+
<term>
32
+
<constant>MYSQLI_OPT_CAN_HANDLE_EXPIRED_PASSWORDS</constant>
33
+
(<type>int</type>)
34
+
</term>
35
+
<listitem>
36
+
<simpara>
37
+
Indicates to the server that the client can handle sandbox mode
38
+
for expired passwords.
39
+
Can be used with <function>mysqli_options</function>.
40
+
</simpara>
41
+
</listitem>
42
+
</varlistentry>
43
+
<varlistentry xml:id="constant.mysqli-opt-load-data-local-dir">
44
+
<term>
45
+
<constant>MYSQLI_OPT_LOAD_DATA_LOCAL_DIR</constant>
46
+
(<type>int</type>)
47
+
</term>
48
+
<listitem>
49
+
<simpara>
50
+
If enabled, this option specifies the directory
51
+
from which client-side <literal>LOCAL</literal> data loading is permitted
52
+
in <literal>LOAD DATA LOCAL</literal> statements.
53
+
</simpara>
54
+
</listitem>
55
+
</varlistentry>
56
+
<varlistentry xml:id="constant.mysqli-opt-connect-timeout">
57
+
<term>
58
+
<constant>MYSQLI_OPT_CONNECT_TIMEOUT</constant>
59
+
(<type>int</type>)
60
+
</term>
26
61
<listitem>
27
62
<para>
28
-
Connect timeout in seconds
63
+
Connect timeout in seconds.
29
64
</para>
30
65
</listitem>
31
66
</varlistentry>
32
-
<varlistentry xml:id="constantmysqli-opt-read-timeout">
33
-
<term><constant>MYSQLI_OPT_READ_TIMEOUT</constant></term>
67
+
<varlistentry xml:id="constant.mysqli-opt-read-timeout">
68
+
<term>
69
+
<constant>MYSQLI_OPT_READ_TIMEOUT</constant>
70
+
(<type>int</type>)
71
+
</term>
34
72
<listitem>
35
73
<para>
36
74
Command execution result timeout in seconds. Available as of PHP 7.2.0.
37
75
</para>
38
76
</listitem>
39
77
</varlistentry>
40
-
<varlistentry xml:id="constantmysqli-opt-local-infile">
41
-
<term><constant>MYSQLI_OPT_LOCAL_INFILE</constant></term>
78
+
<varlistentry xml:id="constant.mysqli-opt-local-infile">
79
+
<term>
80
+
<constant>MYSQLI_OPT_LOCAL_INFILE</constant>
81
+
(<type>int</type>)
82
+
</term>
42
83
<listitem>
43
84
<para>
44
-
Enables command <literal>LOAD LOCAL INFILE</literal>
85
+
Enables command <literal>LOAD LOCAL INFILE</literal>.
45
86
</para>
46
87
</listitem>
47
88
</varlistentry>
48
-
<varlistentry xml:id="constantmysqli-opt-int-and-float-native">
49
-
<term><constant>MYSQLI_OPT_INT_AND_FLOAT_NATIVE</constant></term>
89
+
<varlistentry xml:id="constant.mysqli-opt-int-and-float-native">
90
+
<term>
91
+
<constant>MYSQLI_OPT_INT_AND_FLOAT_NATIVE</constant>
92
+
(<type>int</type>)
93
+
</term>
50
94
<listitem>
51
95
<para>
52
96
Convert integer and float columns back to PHP numbers. Only valid for mysqlnd.
53
97
</para>
54
98
</listitem>
55
99
</varlistentry>
56
-
<varlistentry xml:id="constantmysqli-opt-net-cmd-buffer-size">
57
-
<term><constant>MYSQLI_OPT_NET_CMD_BUFFER_SIZE</constant></term>
100
+
<varlistentry xml:id="constant.mysqli-opt-net-cmd-buffer-size">
101
+
<term>
102
+
<constant>MYSQLI_OPT_NET_CMD_BUFFER_SIZE</constant>
103
+
(<type>int</type>)
104
+
</term>
58
105
<listitem>
59
106
<para>
60
107
The size of the internal command/network buffer. Only valid for mysqlnd.
61
108
</para>
62
109
</listitem>
63
110
</varlistentry>
64
-
<varlistentry xml:id="constantmysqli-opt-net-read-buffer-size">
65
-
<term><constant>MYSQLI_OPT_NET_READ_BUFFER_SIZE</constant></term>
111
+
<varlistentry xml:id="constant.mysqli-opt-net-read-buffer-size">
112
+
<term>
113
+
<constant>MYSQLI_OPT_NET_READ_BUFFER_SIZE</constant>
114
+
(<type>int</type>)
115
+
</term>
66
116
<listitem>
67
117
<para>
68
118
Maximum read chunk size in bytes when reading the body of a MySQL command packet.
...
...
@@ -70,41 +120,90 @@
70
120
</para>
71
121
</listitem>
72
122
</varlistentry>
73
-
<varlistentry xml:id="constantmysqli-opt-ssl-verify-server-cert">
74
-
<term><constant>MYSQLI_OPT_SSL_VERIFY_SERVER_CERT</constant></term>
123
+
<varlistentry xml:id="constant.mysqli-opt-ssl-verify-server-cert">
124
+
<term>
125
+
<constant>MYSQLI_OPT_SSL_VERIFY_SERVER_CERT</constant>
126
+
(<type>int</type>)
127
+
</term>
75
128
<listitem>
76
129
<para>
77
-
Requires MySQL 5.1.10 and up
78
130
</para>
79
131
</listitem>
80
132
</varlistentry>
81
-
<varlistentry xml:id="constantmysqli-init-command">
82
-
<term><constant>MYSQLI_INIT_COMMAND</constant></term>
133
+
<varlistentry xml:id="constant.mysqli-init-command">
134
+
<term>
135
+
<constant>MYSQLI_INIT_COMMAND</constant>
136
+
(<type>int</type>)
137
+
</term>
83
138
<listitem>
84
139
<para>
85
140
Command to execute when connecting to MySQL server. Will automatically be re-executed when reconnecting.
86
141
</para>
87
142
</listitem>
88
143
</varlistentry>
89
-
<varlistentry xml:id="constantmysqli-client-ssl">
90
-
<term><constant>MYSQLI_CLIENT_SSL</constant></term>
144
+
<varlistentry xml:id="constant.mysqli-client-can-handle-expired-passwords">
145
+
<term>
146
+
<constant>MYSQLI_CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS</constant>
147
+
(<type>int</type>)
148
+
</term>
149
+
<listitem>
150
+
<simpara>
151
+
Indicates to the server that the client can handle sandbox mode
152
+
for expired passwords.
153
+
Can be used with <function>mysqli_real_connect</function>.
154
+
</simpara>
155
+
</listitem>
156
+
</varlistentry>
157
+
<varlistentry xml:id="constant.mysqli-client-found-rows">
158
+
<term>
159
+
<constant>MYSQLI_CLIENT_FOUND_ROWS</constant>
160
+
(<type>int</type>)
161
+
</term>
162
+
<listitem>
163
+
<simpara>
164
+
Return number of matched rows, not the number of affected rows.
165
+
</simpara>
166
+
</listitem>
167
+
</varlistentry>
168
+
<varlistentry xml:id="constant.mysqli-client-ssl-verify-server-cert">
169
+
<term>
170
+
<constant>MYSQLI_CLIENT_SSL_VERIFY_SERVER_CERT</constant>
171
+
(<type>int</type>)
172
+
</term>
173
+
<listitem>
174
+
<simpara>
175
+
Verify server certificate.
176
+
</simpara>
177
+
</listitem>
178
+
</varlistentry>
179
+
<varlistentry xml:id="constant.mysqli-client-ssl">
180
+
<term>
181
+
<constant>MYSQLI_CLIENT_SSL</constant>
182
+
(<type>int</type>)
183
+
</term>
91
184
<listitem>
92
185
<para>
93
186
Use SSL (encrypted protocol). This option should not be set by application programs;
94
-
it is set internally in the MySQL client library
187
+
it is set internally in the MySQL client library.
95
188
</para>
96
189
</listitem>
97
190
</varlistentry>
98
-
<varlistentry xml:id="constantmysqli-client-compress">
99
-
<term><constant>MYSQLI_CLIENT_COMPRESS</constant></term>
191
+
<varlistentry xml:id="constant.mysqli-client-compress">
192
+
<term>
193
+
<constant>MYSQLI_CLIENT_COMPRESS</constant>
194
+
(<type>int</type>)
195
+
</term>
100
196
<listitem>
101
197
<para>
102
-
Use compression protocol
198
+
Use compression protocol.
103
199
</para>
104
200
</listitem>
105
201
</varlistentry>
106
-
<varlistentry xml:id="constantmysqli-client-interactive">
107
-
<term><constant>MYSQLI_CLIENT_INTERACTIVE</constant></term>
202
+
<varlistentry xml:id="constant.mysqli-client-interactive">
203
+
<term>
204
+
<constant>MYSQLI_CLIENT_INTERACTIVE</constant>
205
+
(<type>int</type>)
206
+
</term>
108
207
<listitem>
109
208
<para>
110
209
Allow <literal>interactive_timeout</literal> seconds
...
...
@@ -115,23 +214,29 @@
115
214
</para>
116
215
</listitem>
117
216
</varlistentry>
118
-
<varlistentry xml:id="constantmysqli-client-ignore-space">
119
-
<term><constant>MYSQLI_CLIENT_IGNORE_SPACE</constant></term>
217
+
<varlistentry xml:id="constant.mysqli-client-ignore-space">
218
+
<term>
219
+
<constant>MYSQLI_CLIENT_IGNORE_SPACE</constant>
220
+
(<type>int</type>)
221
+
</term>
120
222
<listitem>
121
223
<para>
122
224
Allow spaces after function names. Makes all functions names reserved words.
123
225
</para>
124
226
</listitem>
125
227
</varlistentry>
126
-
<varlistentry xml:id="constantmysqli-client-no-schema">
127
-
<term><constant>MYSQLI_CLIENT_NO_SCHEMA</constant></term>
228
+
<varlistentry xml:id="constant.mysqli-client-no-schema">
229
+
<term>
230
+
<constant>MYSQLI_CLIENT_NO_SCHEMA</constant>
231
+
(<type>int</type>)
232
+
</term>
128
233
<listitem>
129
234
<para>
130
235
Don't allow the <literal>db_name.tbl_name.col_name</literal> syntax.
131
236
</para>
132
237
</listitem>
133
238
</varlistentry>
134
-
<varlistentry xml:id="constantmysqli-client-multi-queries">
239
+
<varlistentry xml:id="constant.mysqli-client-multi-queries">
135
240
<term><constant>MYSQLI_CLIENT_MULTI_QUERIES</constant></term>
136
241
<listitem>
137
242
<para>
...
...
@@ -139,64 +244,109 @@
139
244
</para>
140
245
</listitem>
141
246
</varlistentry>
142
-
<varlistentry xml:id="constantmysqli-store-result">
143
-
<term><constant>MYSQLI_STORE_RESULT</constant></term>
247
+
<varlistentry xml:id="constant.mysqli-store-result">
248
+
<term>
249
+
<constant>MYSQLI_STORE_RESULT</constant>
250
+
(<type>int</type>)
251
+
</term>
144
252
<listitem>
145
253
<para>
146
-
For using buffered resultsets
254
+
For using buffered result sets. It has a value of <literal>0</literal>.
147
255
</para>
148
256
</listitem>
149
257
</varlistentry>
150
-
<varlistentry xml:id="constantmysqli-use-result">
151
-
<term><constant>MYSQLI_USE_RESULT</constant></term>
258
+
<varlistentry xml:id="constant.mysqli-store-result-copy-data">
259
+
<term>
260
+
<constant>MYSQLI_STORE_RESULT_COPY_DATA</constant>
261
+
(<type>int</type>)
262
+
</term>
263
+
<listitem>
264
+
<simpara>
265
+
As of PHP 8.1, this constant no longer has any effect.
266
+
Before PHP 8.1, this constant is used to copy results
267
+
from the internal <literal>mysqlnd</literal> buffer
268
+
into the PHP variables fetched.
269
+
By default, <literal>mysqlnd</literal> will use a reference logic
270
+
to avoid copying and duplicating results held in memory.
271
+
For certain result sets, for example, result sets with many small rows,
272
+
the copy approach can reduce the overall memory usage
273
+
because PHP variables holding results may be released earlier.
274
+
Available with <literal>mysqlnd</literal> only.
275
+
Deprecated as of PHP 8.4.0.
276
+
</simpara>
277
+
</listitem>
278
+
</varlistentry>
279
+
<varlistentry xml:id="constant.mysqli-use-result">
280
+
<term>
281
+
<constant>MYSQLI_USE_RESULT</constant>
282
+
(<type>int</type>)
283
+
</term>
152
284
<listitem>
153
285
<para>
154
-
For using unbuffered resultsets
286
+
For using unbuffered result sets. It has a value of <literal>1</literal>.
155
287
</para>
156
288
</listitem>
157
289
</varlistentry>
158
-
<varlistentry xml:id="constantmysqli-assoc">
159
-
<term><constant>MYSQLI_ASSOC</constant></term>
290
+
<varlistentry xml:id="constant.mysqli-assoc">
291
+
<term>
292
+
<constant>MYSQLI_ASSOC</constant>
293
+
(<type>int</type>)
294
+
</term>
160
295
<listitem>
161
296
<para>
162
297
Columns are returned into the array having the fieldname as the array index.
163
298
</para>
164
299
</listitem>
165
300
</varlistentry>
166
-
<varlistentry xml:id="constantmysqli-num">
167
-
<term><constant>MYSQLI_NUM</constant></term>
301
+
<varlistentry xml:id="constant.mysqli-num">
302
+
<term>
303
+
<constant>MYSQLI_NUM</constant>
304
+
(<type>int</type>)
305
+
</term>
168
306
<listitem>
169
307
<para>
170
308
Columns are returned into the array having an enumerated index.
171
309
</para>
172
310
</listitem>
173
311
</varlistentry>
174
-
<varlistentry xml:id="constantmysqli-both">
175
-
<term><constant>MYSQLI_BOTH</constant></term>
312
+
<varlistentry xml:id="constant.mysqli-both">
313
+
<term>
314
+
<constant>MYSQLI_BOTH</constant>
315
+
(<type>int</type>)
316
+
</term>
176
317
<listitem>
177
318
<para>
178
319
Columns are returned into the array having both a numerical index and the fieldname as the associative index.
179
320
</para>
180
321
</listitem>
181
322
</varlistentry>
182
-
<varlistentry xml:id="constantmysqli-not-null-flag">
183
-
<term><constant>MYSQLI_NOT_NULL_FLAG</constant></term>
323
+
<varlistentry xml:id="constant.mysqli-not-null-flag">
324
+
<term>
325
+
<constant>MYSQLI_NOT_NULL_FLAG</constant>
326
+
(<type>int</type>)
327
+
</term>
184
328
<listitem>
185
329
<para>
186
-
Indicates that a field is defined as <literal>NOT NULL</literal>
330
+
Indicates that a field is defined as <literal>NOT NULL</literal>.
187
331
</para>
188
332
</listitem>
189
333
</varlistentry>
190
-
<varlistentry xml:id="constantmysqli-pri-key-flag">
191
-
<term><constant>MYSQLI_PRI_KEY_FLAG</constant></term>
334
+
<varlistentry xml:id="constant.mysqli-pri-key-flag">
335
+
<term>
336
+
<constant>MYSQLI_PRI_KEY_FLAG</constant>
337
+
(<type>int</type>)
338
+
</term>
192
339
<listitem>
193
340
<para>
194
-
Field is part of a primary index
341
+
Field is part of a primary index.
195
342
</para>
196
343
</listitem>
197
344
</varlistentry>
198
-
<varlistentry xml:id="constantmysqli-unique-key-flag">
199
-
<term><constant>MYSQLI_UNIQUE_KEY_FLAG</constant></term>
345
+
<varlistentry xml:id="constant.mysqli-unique-key-flag">
346
+
<term>
347
+
<constant>MYSQLI_UNIQUE_KEY_FLAG</constant>
348
+
(<type>int</type>)
349
+
</term>
200
350
<listitem>
201
351
<para>
202
352
Field is part of a unique index.
...
...
@@ -204,559 +354,785 @@
204
354
</listitem>
205
355
</varlistentry>
206
356
207
-
<varlistentry xml:id="constantmysqli-multiple-key-flag">
208
-
<term><constant>MYSQLI_MULTIPLE_KEY_FLAG</constant></term>
357
+
<varlistentry xml:id="constant.mysqli-multiple-key-flag">
358
+
<term>
359
+
<constant>MYSQLI_MULTIPLE_KEY_FLAG</constant>
360
+
(<type>int</type>)
361
+
</term>
209
362
<listitem>
210
363
<para>
211
364
Field is part of an index.
212
365
</para>
213
366
</listitem>
214
367
</varlistentry>
215
-
<varlistentry xml:id="constantmysqli-blob-flag">
216
-
<term><constant>MYSQLI_BLOB_FLAG</constant></term>
368
+
<varlistentry xml:id="constant.mysqli-blob-flag">
369
+
<term>
370
+
<constant>MYSQLI_BLOB_FLAG</constant>
371
+
(<type>int</type>)
372
+
</term>
217
373
<listitem>
218
374
<para>
219
-
Field is defined as <literal>BLOB</literal>
375
+
Field is defined as <literal>BLOB</literal>.
220
376
</para>
221
377
</listitem>
222
378
</varlistentry>
223
-
<varlistentry xml:id="constantmysqli-unsigned-flag">
224
-
<term><constant>MYSQLI_UNSIGNED_FLAG</constant></term>
379
+
<varlistentry xml:id="constant.mysqli-unsigned-flag">
380
+
<term>
381
+
<constant>MYSQLI_UNSIGNED_FLAG</constant>
382
+
(<type>int</type>)
383
+
</term>
225
384
<listitem>
226
385
<para>
227
-
Field is defined as <literal>UNSIGNED</literal>
386
+
Field is defined as <literal>UNSIGNED</literal>.
228
387
</para>
229
388
</listitem>
230
389
</varlistentry>
231
-
<varlistentry xml:id="constantmysqli-zerofill-flag">
232
-
<term><constant>MYSQLI_ZEROFILL_FLAG</constant></term>
390
+
<varlistentry xml:id="constant.mysqli-zerofill-flag">
391
+
<term>
392
+
<constant>MYSQLI_ZEROFILL_FLAG</constant>
393
+
(<type>int</type>)
394
+
</term>
233
395
<listitem>
234
396
<para>
235
-
Field is defined as <literal>ZEROFILL</literal>
397
+
Field is defined as <literal>ZEROFILL</literal>.
236
398
</para>
237
399
</listitem>
238
400
</varlistentry>
239
-
<varlistentry xml:id="constantmysqli-auto-increment-flag">
240
-
<term><constant>MYSQLI_AUTO_INCREMENT_FLAG</constant></term>
401
+
<varlistentry xml:id="constant.mysqli-auto-increment-flag">
402
+
<term>
403
+
<constant>MYSQLI_AUTO_INCREMENT_FLAG</constant>
404
+
(<type>int</type>)
405
+
</term>
241
406
<listitem>
242
407
<para>
243
-
Field is defined as <literal>AUTO_INCREMENT</literal>
408
+
Field is defined as <literal>AUTO_INCREMENT</literal>.
244
409
</para>
245
410
</listitem>
246
411
</varlistentry>
247
-
<varlistentry xml:id="constantmysqli-timestamp-flag">
248
-
<term><constant>MYSQLI_TIMESTAMP_FLAG</constant></term>
412
+
<varlistentry xml:id="constant.mysqli-timestamp-flag">
413
+
<term>
414
+
<constant>MYSQLI_TIMESTAMP_FLAG</constant>
415
+
(<type>int</type>)
416
+
</term>
249
417
<listitem>
250
418
<para>
251
-
Field is defined as <literal>TIMESTAMP</literal>
419
+
Field is defined as <literal>TIMESTAMP</literal>.
252
420
</para>
253
421
</listitem>
254
422
</varlistentry>
255
-
<varlistentry xml:id="constantmysqli-set-flag">
256
-
<term><constant>MYSQLI_SET_FLAG</constant></term>
423
+
<varlistentry xml:id="constant.mysqli-set-flag">
424
+
<term>
425
+
<constant>MYSQLI_SET_FLAG</constant>
426
+
(<type>int</type>)
427
+
</term>
257
428
<listitem>
258
429
<para>
259
-
Field is defined as <literal>SET</literal>
430
+
Field is defined as <literal>SET</literal>.
260
431
</para>
261
432
</listitem>
262
433
</varlistentry>
263
-
<varlistentry xml:id="constantmysqli-num-flag">
264
-
<term><constant>MYSQLI_NUM_FLAG</constant></term>
434
+
<varlistentry xml:id="constant.mysqli-num-flag">
435
+
<term>
436
+
<constant>MYSQLI_NUM_FLAG</constant>
437
+
(<type>int</type>)
438
+
</term>
265
439
<listitem>
266
440
<para>
267
-
Field is defined as <literal>NUMERIC</literal>
441
+
Field is defined as <literal>NUMERIC</literal>.
268
442
</para>
269
443
</listitem>
270
444
</varlistentry>
271
-
<varlistentry xml:id="constantmysqli-part-key-flag">
272
-
<term><constant>MYSQLI_PART_KEY_FLAG</constant></term>
445
+
<varlistentry xml:id="constant.mysqli-part-key-flag">
446
+
<term>
447
+
<constant>MYSQLI_PART_KEY_FLAG</constant>
448
+
(<type>int</type>)
449
+
</term>
273
450
<listitem>
274
451
<para>
275
-
Field is part of an multi-index
452
+
Field is part of an multi-index.
276
453
</para>
277
454
</listitem>
278
455
</varlistentry>
279
-
<varlistentry xml:id="constantmysqli-group-flag">
280
-
<term><constant>MYSQLI_GROUP_FLAG</constant></term>
456
+
<varlistentry xml:id="constant.mysqli-group-flag">
457
+
<term>
458
+
<constant>MYSQLI_GROUP_FLAG</constant>
459
+
(<type>int</type>)
460
+
</term>
281
461
<listitem>
282
462
<para>
283
-
Field is part of <literal>GROUP BY</literal>
463
+
Field is part of <literal>GROUP BY</literal>.
284
464
</para>
285
465
</listitem>
286
466
</varlistentry>
287
-
<varlistentry xml:id="constantmysqli-type-decimal">
288
-
<term><constant>MYSQLI_TYPE_DECIMAL</constant></term>
467
+
<varlistentry xml:id="constant.mysqli-no-default-value-flag">
468
+
<term>
469
+
<constant>MYSQLI_NO_DEFAULT_VALUE_FLAG</constant>
470
+
(<type>int</type>)
471
+
</term>
289
472
<listitem>
290
-
<para>
291
-
Field is defined as <literal>DECIMAL</literal>
292
-
</para>
473
+
<simpara>
474
+
A column has no <literal>DEFAULT</literal> clause in its definition.
475
+
This does not apply to <literal>NULL</literal>
476
+
or to <literal>AUTO_INCREMENT</literal> columns
477
+
because such columns have a default value of <literal>NULL</literal>
478
+
and an implied default value respectively.
479
+
</simpara>
293
480
</listitem>
294
481
</varlistentry>
295
-
<varlistentry xml:id="constantmysqli-type-newdecimal">
296
-
<term><constant>MYSQLI_TYPE_NEWDECIMAL</constant></term>
482
+
<varlistentry xml:id="constant.mysqli-type-decimal">
483
+
<term>
484
+
<constant>MYSQLI_TYPE_DECIMAL</constant>
485
+
(<type>int</type>)
486
+
</term>
297
487
<listitem>
298
488
<para>
299
-
Precision math <literal>DECIMAL</literal> or <literal>NUMERIC</literal> field (MySQL 5.0.3 and up)
489
+
Field is defined as <literal>DECIMAL</literal>.
300
490
</para>
301
491
</listitem>
302
492
</varlistentry>
303
-
<varlistentry xml:id="constantmysqli-type-bit">
304
-
<term><constant>MYSQLI_TYPE_BIT</constant></term>
493
+
<varlistentry xml:id="constant.mysqli-type-newdecimal">
494
+
<term>
495
+
<constant>MYSQLI_TYPE_NEWDECIMAL</constant>
496
+
(<type>int</type>)
497
+
</term>
305
498
<listitem>
306
499
<para>
307
-
Field is defined as <literal>BIT</literal> (MySQL 5.0.3 and up)
500
+
Precision math <literal>DECIMAL</literal> or <literal>NUMERIC</literal> field.
308
501
</para>
309
502
</listitem>
310
503
</varlistentry>
311
-
<varlistentry xml:id="constantmysqli-type-tiny">
312
-
<term><constant>MYSQLI_TYPE_TINY</constant></term>
504
+
<varlistentry xml:id="constant.mysqli-type-bit">
505
+
<term>
506
+
<constant>MYSQLI_TYPE_BIT</constant>
507
+
(<type>int</type>)
508
+
</term>
313
509
<listitem>
314
510
<para>
315
-
Field is defined as <literal>TINYINT</literal>
511
+
Field is defined as <literal>BIT</literal>.
316
512
</para>
317
513
</listitem>
318
514
</varlistentry>
319
-
<varlistentry xml:id="constantmysqli-type-short">
320
-
<term><constant>MYSQLI_TYPE_SHORT</constant></term>
515
+
<varlistentry xml:id="constant.mysqli-type-tiny">
516
+
<term>
517
+
<constant>MYSQLI_TYPE_TINY</constant>
518
+
(<type>int</type>)
519
+
</term>
321
520
<listitem>
322
521
<para>
323
-
Field is defined as <literal>SMALLINT</literal>
522
+
Field is defined as <literal>TINYINT</literal>.
324
523
</para>
325
524
</listitem>
326
525
</varlistentry>
327
-
<varlistentry xml:id="constantmysqli-type-long">
328
-
<term><constant>MYSQLI_TYPE_LONG</constant></term>
526
+
<varlistentry xml:id="constant.mysqli-type-short">
527
+
<term>
528
+
<constant>MYSQLI_TYPE_SHORT</constant>
529
+
(<type>int</type>)
530
+
</term>
329
531
<listitem>
330
532
<para>
331
-
Field is defined as <literal>INT</literal>
533
+
Field is defined as <literal>SMALLINT</literal>.
332
534
</para>
333
535
</listitem>
334
536
</varlistentry>
335
-
<varlistentry xml:id="constantmysqli-type-fload">
336
-
<term><constant>MYSQLI_TYPE_FLOAT</constant></term>
537
+
<varlistentry xml:id="constant.mysqli-type-long">
538
+
<term>
539
+
<constant>MYSQLI_TYPE_LONG</constant>
540
+
(<type>int</type>)
541
+
</term>
337
542
<listitem>
338
543
<para>
339
-
Field is defined as <literal>FLOAT</literal>
544
+
Field is defined as <literal>INT</literal>.
340
545
</para>
341
546
</listitem>
342
547
</varlistentry>
343
-
<varlistentry xml:id="constantmysqli-type-double">
344
-
<term><constant>MYSQLI_TYPE_DOUBLE</constant></term>
548
+
<varlistentry xml:id="constant.mysqli-type-float">
549
+
<term>
550
+
<constant>MYSQLI_TYPE_FLOAT</constant>
551
+
(<type>int</type>)
552
+
</term>
345
553
<listitem>
346
554
<para>
347
-
Field is defined as <literal>DOUBLE</literal>
555
+
Field is defined as <literal>FLOAT</literal>.
348
556
</para>
349
557
</listitem>
350
558
</varlistentry>
351
-
<varlistentry xml:id="constantmysqli-type-null">
352
-
<term><constant>MYSQLI_TYPE_NULL</constant></term>
559
+
<varlistentry xml:id="constant.mysqli-type-double">
560
+
<term>
561
+
<constant>MYSQLI_TYPE_DOUBLE</constant>
562
+
(<type>int</type>)
563
+
</term>
353
564
<listitem>
354
565
<para>
355
-
Field is defined as <literal>DEFAULT NULL</literal>
566
+
Field is defined as <literal>DOUBLE</literal>.
356
567
</para>
357
568
</listitem>
358
569
</varlistentry>
359
-
<varlistentry xml:id="constantmysqli-type-timestamp">
360
-
<term><constant>MYSQLI_TYPE_TIMESTAMP</constant></term>
570
+
<varlistentry xml:id="constant.mysqli-type-null">
571
+
<term>
572
+
<constant>MYSQLI_TYPE_NULL</constant>
573
+
(<type>int</type>)
574
+
</term>
361
575
<listitem>
362
576
<para>
363
-
Field is defined as <literal>TIMESTAMP</literal>
577
+
Field is defined as <literal>DEFAULT NULL</literal>.
364
578
</para>
365
579
</listitem>
366
580
</varlistentry>
367
-
<varlistentry xml:id="constantmysqli-type-longlong">
368
-
<term><constant>MYSQLI_TYPE_LONGLONG</constant></term>
581
+
<varlistentry xml:id="constant.mysqli-type-timestamp">
582
+
<term>
583
+
<constant>MYSQLI_TYPE_TIMESTAMP</constant>
584
+
(<type>int</type>)
585
+
</term>
369
586
<listitem>
370
587
<para>
371
-
Field is defined as <literal>BIGINT</literal>
588
+
Field is defined as <literal>TIMESTAMP</literal>.
372
589
</para>
373
590
</listitem>
374
591
</varlistentry>
375
-
<varlistentry xml:id="constantmysqli-type-int24">
376
-
<term><constant>MYSQLI_TYPE_INT24</constant></term>
592
+
<varlistentry xml:id="constant.mysqli-type-longlong">
593
+
<term>
594
+
<constant>MYSQLI_TYPE_LONGLONG</constant>
595
+
(<type>int</type>)
596
+
</term>
377
597
<listitem>
378
598
<para>
379
-
Field is defined as <literal>MEDIUMINT</literal>
599
+
Field is defined as <literal>BIGINT</literal>.
380
600
</para>
381
601
</listitem>
382
602
</varlistentry>
383
-
<varlistentry xml:id="constantmysqli-type-date">
384
-
<term><constant>MYSQLI_TYPE_DATE</constant></term>
603
+
<varlistentry xml:id="constant.mysqli-type-int24">
604
+
<term>
605
+
<constant>MYSQLI_TYPE_INT24</constant>
606
+
(<type>int</type>)
607
+
</term>
385
608
<listitem>
386
609
<para>
387
-
Field is defined as <literal>DATE</literal>
610
+
Field is defined as <literal>MEDIUMINT</literal>.
388
611
</para>
389
612
</listitem>
390
613
</varlistentry>
391
-
<varlistentry xml:id="constantmysqli-type-time">
392
-
<term><constant>MYSQLI_TYPE_TIME</constant></term>
614
+
<varlistentry xml:id="constant.mysqli-type-date">
615
+
<term>
616
+
<constant>MYSQLI_TYPE_DATE</constant>
617
+
(<type>int</type>)
618
+
</term>
393
619
<listitem>
394
620
<para>
395
-
Field is defined as <literal>TIME</literal>
621
+
Field is defined as <literal>DATE</literal>.
396
622
</para>
397
623
</listitem>
398
624
</varlistentry>
399
-
<varlistentry xml:id="constantmysqli-type-datetime">
400
-
<term><constant>MYSQLI_TYPE_DATETIME</constant></term>
625
+
<varlistentry xml:id="constant.mysqli-type-time">
626
+
<term>
627
+
<constant>MYSQLI_TYPE_TIME</constant>
628
+
(<type>int</type>)
629
+
</term>
401
630
<listitem>
402
631
<para>
403
-
Field is defined as <literal>DATETIME</literal>
632
+
Field is defined as <literal>TIME</literal>.
404
633
</para>
405
634
</listitem>
406
635
</varlistentry>
407
-
<varlistentry xml:id="constantmysqli-type-year">
408
-
<term><constant>MYSQLI_TYPE_YEAR</constant></term>
636
+
<varlistentry xml:id="constant.mysqli-type-datetime">
637
+
<term>
638
+
<constant>MYSQLI_TYPE_DATETIME</constant>
639
+
(<type>int</type>)
640
+
</term>
409
641
<listitem>
410
642
<para>
411
-
Field is defined as <literal>YEAR</literal>
643
+
Field is defined as <literal>DATETIME</literal>.
412
644
</para>
413
645
</listitem>
414
646
</varlistentry>
415
-
<varlistentry xml:id="constantmysqli-type-newdate">
416
-
<term><constant>MYSQLI_TYPE_NEWDATE</constant></term>
647
+
<varlistentry xml:id="constant.mysqli-type-year">
648
+
<term>
649
+
<constant>MYSQLI_TYPE_YEAR</constant>
650
+
(<type>int</type>)
651
+
</term>
417
652
<listitem>
418
653
<para>
419
-
Field is defined as <literal>DATE</literal>
654
+
Field is defined as <literal>YEAR</literal>.
420
655
</para>
421
656
</listitem>
422
657
</varlistentry>
423
-
<varlistentry xml:id="constantmysqli-type-interval">
424
-
<term><constant>MYSQLI_TYPE_INTERVAL</constant></term>
658
+
<varlistentry xml:id="constant.mysqli-type-newdate">
659
+
<term>
660
+
<constant>MYSQLI_TYPE_NEWDATE</constant>
661
+
(<type>int</type>)
662
+
</term>
425
663
<listitem>
426
664
<para>
427
-
Field is defined as <literal>INTERVAL</literal>
665
+
Field is defined as <literal>DATE</literal>.
428
666
</para>
429
667
</listitem>
430
668
</varlistentry>
431
-
<varlistentry xml:id="constantmysqli-type-enum">
432
-
<term><constant>MYSQLI_TYPE_ENUM</constant></term>
669
+
<varlistentry xml:id="constant.mysqli-type-interval">
670
+
<term>
671
+
<constant>MYSQLI_TYPE_INTERVAL</constant>
672
+
(<type>int</type>)
673
+
</term>
433
674
<listitem>
434
675
<para>
435
-
Field is defined as <literal>ENUM</literal>
676
+
Alias of <constant>MYSQLI_TYPE_ENUM</constant>. Removed as of PHP 8.4.0.
436
677
</para>
437
678
</listitem>
438
679
</varlistentry>
439
-
<varlistentry xml:id="constantmysqli-type-set">
440
-
<term><constant>MYSQLI_TYPE_SET</constant></term>
680
+
<varlistentry xml:id="constant.mysqli-type-enum">
681
+
<term>
682
+
<constant>MYSQLI_TYPE_ENUM</constant>
683
+
(<type>int</type>)
684
+
</term>
441
685
<listitem>
442
686
<para>
443
-
Field is defined as <literal>SET</literal>
687
+
Field is defined as <literal>ENUM</literal>.
444
688
</para>
445
689
</listitem>
446
690
</varlistentry>
447
-
<varlistentry xml:id="constantmysqli-type-tiny-blob">
448
-
<term><constant>MYSQLI_TYPE_TINY_BLOB</constant></term>
691
+
<varlistentry xml:id="constant.mysqli-type-set">
692
+
<term>
693
+
<constant>MYSQLI_TYPE_SET</constant>
694
+
(<type>int</type>)
695
+
</term>
449
696
<listitem>
450
697
<para>
451
-
Field is defined as <literal>TINYBLOB</literal>
698
+
Field is defined as <literal>SET</literal>.
452
699
</para>
453
700
</listitem>
454
701
</varlistentry>
455
-
<varlistentry xml:id="constantmysqli-type-medium-blob">
456
-
<term><constant>MYSQLI_TYPE_MEDIUM_BLOB</constant></term>
702
+
<varlistentry xml:id="constant.mysqli-type-tiny-blob">
703
+
<term>
704
+
<constant>MYSQLI_TYPE_TINY_BLOB</constant>
705
+
(<type>int</type>)
706
+
</term>
457
707
<listitem>
458
708
<para>
459
-
Field is defined as <literal>MEDIUMBLOB</literal>
709
+
Field is defined as <literal>TINYBLOB</literal>.
460
710
</para>
461
711
</listitem>
462
712
</varlistentry>
463
-
<varlistentry xml:id="constantmysqli-type-long-blob">
464
-
<term><constant>MYSQLI_TYPE_LONG_BLOB</constant></term>
713
+
<varlistentry xml:id="constant.mysqli-type-medium-blob">
714
+
<term>
715
+
<constant>MYSQLI_TYPE_MEDIUM_BLOB</constant>
716
+
(<type>int</type>)
717
+
</term>
465
718
<listitem>
466
719
<para>
467
-
Field is defined as <literal>LONGBLOB</literal>
720
+
Field is defined as <literal>MEDIUMBLOB</literal>.
468
721
</para>
469
722
</listitem>
470
723
</varlistentry>
471
-
<varlistentry xml:id="constantmysqli-type-blob">
472
-
<term><constant>MYSQLI_TYPE_BLOB</constant></term>
724
+
<varlistentry xml:id="constant.mysqli-type-long-blob">
725
+
<term>
726
+
<constant>MYSQLI_TYPE_LONG_BLOB</constant>
727
+
(<type>int</type>)
728
+
</term>
473
729
<listitem>
474
730
<para>
475
-
Field is defined as <literal>BLOB</literal>
731
+
Field is defined as <literal>LONGBLOB</literal>.
476
732
</para>
477
733
</listitem>
478
734
</varlistentry>
479
-
<varlistentry xml:id="constantmysqli-type-var-string">
480
-
<term><constant>MYSQLI_TYPE_VAR_STRING</constant></term>
735
+
<varlistentry xml:id="constant.mysqli-type-blob">
736
+
<term>
737
+
<constant>MYSQLI_TYPE_BLOB</constant>
738
+
(<type>int</type>)
739
+
</term>
481
740
<listitem>
482
741
<para>
483
-
Field is defined as <literal>VARCHAR</literal>
742
+
Field is defined as <literal>BLOB</literal>.
484
743
</para>
485
744
</listitem>
486
745
</varlistentry>
487
-
<varlistentry xml:id="constantmysqli-type-string">
488
-
<term><constant>MYSQLI_TYPE_STRING</constant></term>
746
+
<varlistentry xml:id="constant.mysqli-type-var-string">
747
+
<term>
748
+
<constant>MYSQLI_TYPE_VAR_STRING</constant>
749
+
(<type>int</type>)
750
+
</term>
489
751
<listitem>
490
752
<para>
491
-
Field is defined as <literal>CHAR</literal> or <literal>BINARY</literal>
753
+
Field is defined as <literal>VARCHAR</literal>.
492
754
</para>
493
755
</listitem>
494
756
</varlistentry>
495
-
<varlistentry xml:id="constantmysqli-type-char">
496
-
<term><constant>MYSQLI_TYPE_CHAR</constant></term>
757
+
<varlistentry xml:id="constant.mysqli-type-string">
758
+
<term>
759
+
<constant>MYSQLI_TYPE_STRING</constant>
760
+
(<type>int</type>)
761
+
</term>
497
762
<listitem>
498
763
<para>
499
-
Field is defined as <literal>TINYINT</literal>.
500
-
For <literal>CHAR</literal>, see <literal>MYSQLI_TYPE_STRING</literal>
764
+
Field is defined as <literal>CHAR</literal> or <literal>BINARY</literal>.
501
765
</para>
502
766
</listitem>
503
767
</varlistentry>
504
-
<varlistentry xml:id="constantmysqli-type-geometry">
505
-
<term><constant>MYSQLI_TYPE_GEOMETRY</constant></term>
768
+
<varlistentry xml:id="constant.mysqli-type-char">
769
+
<term>
770
+
<constant>MYSQLI_TYPE_CHAR</constant>
771
+
(<type>int</type>)
772
+
</term>
506
773
<listitem>
507
774
<para>
508
-
Field is defined as <literal>GEOMETRY</literal>
775
+
Field is defined as <literal>TINYINT</literal>.
776
+
For <literal>CHAR</literal>, see <literal>MYSQLI_TYPE_STRING</literal>.
509
777
</para>
510
778
</listitem>
511
779
</varlistentry>
512
-
<varlistentry xml:id="constantmysqli-type-json">
513
-
<term><constant>MYSQLI_TYPE_JSON</constant></term>
780
+
<varlistentry xml:id="constant.mysqli-type-geometry">
781
+
<term>
782
+
<constant>MYSQLI_TYPE_GEOMETRY</constant>
783
+
(<type>int</type>)
784
+
</term>
514
785
<listitem>
515
786
<para>
516
-
Field is defined as <literal>JSON</literal>.
517
-
Only valid for mysqlnd and MySQL 5.7.8 and up.
787
+
Field is defined as <literal>GEOMETRY</literal>.
518
788
</para>
519
789
</listitem>
520
790
</varlistentry>
521
-
<varlistentry xml:id="constantmysqli-need-data">
522
-
<term><constant>MYSQLI_NEED_DATA</constant></term>
791
+
<varlistentry xml:id="constant.mysqli-type-json">
792
+
<term>
793
+
<constant>MYSQLI_TYPE_JSON</constant>
794
+
(<type>int</type>)
795
+
</term>
523
796
<listitem>
524
797
<para>
525
-
More data available for bind variable
798
+
Field is defined as <literal>JSON</literal>.
799
+
Only valid for mysqlnd and MySQL 5.7.8 and up.
526
800
</para>
527
801
</listitem>
528
802
</varlistentry>
529
-
<varlistentry xml:id="constantmysqli-no-data">
530
-
<term><constant>MYSQLI_NO_DATA</constant></term>
803
+
<varlistentry xml:id="constant.mysqli-type-vector">
804
+
<term>
805
+
<constant>MYSQLI_TYPE_VECTOR</constant>
806
+
(<type>int</type>)
807
+
</term>
531
808
<listitem>
532
809
<para>
533
-
No more data available for bind variable
810
+
Field is defined as <literal>VECTOR</literal>.
534
811
</para>
535
812
</listitem>
536
813
</varlistentry>
537
-
<varlistentry xml:id="constantmysqli-data-truncated">
538
-
<term><constant>MYSQLI_DATA_TRUNCATED</constant></term>
814
+
<varlistentry xml:id="constant.mysqli-need-data">
815
+
<term><constant>MYSQLI_NEED_DATA</constant></term>
539
816
<listitem>
540
817
<para>
541
-
Data truncation occurred. Available since MySQL 5.0.5.
818
+
More data available for bind variable.
542
819
</para>
543
820
</listitem>
544
821
</varlistentry>
545
-
<varlistentry xml:id="constantmysqli-enum-flag">
546
-
<term><constant>MYSQLI_ENUM_FLAG</constant></term>
822
+
<varlistentry xml:id="constant.mysqli-enum-flag">
823
+
<term>
824
+
<constant>MYSQLI_ENUM_FLAG</constant>
825
+
(<type>int</type>)
826
+
</term>
547
827
<listitem>
548
828
<para>
549
829
Field is defined as <literal>ENUM</literal>.
550
830
</para>
551
831
</listitem>
552
832
</varlistentry>
553
-
<varlistentry xml:id="constantmysqli-binary-flag">
554
-
<term><constant>MYSQLI_BINARY_FLAG</constant></term>
833
+
<varlistentry xml:id="constant.mysqli-binary-flag">
834
+
<term>
835
+
<constant>MYSQLI_BINARY_FLAG</constant>
836
+
(<type>int</type>)
837
+
</term>
555
838
<listitem>
556
839
<para>
557
840
Field is defined as <literal>BINARY</literal>.
558
841
</para>
559
842
</listitem>
560
843
</varlistentry>
561
-
<varlistentry xml:id="constantmysqli-cursor-type-for-update">
562
-
<term><constant>MYSQLI_CURSOR_TYPE_FOR_UPDATE</constant></term>
844
+
<varlistentry xml:id="constant.mysqli-cursor-type-for-update">
845
+
<term>
846
+
<constant>MYSQLI_CURSOR_TYPE_FOR_UPDATE</constant>
847
+
(<type>int</type>)
848
+
</term>
563
849
<listitem>
564
850
<para>
851
+
Removed as of PHP 8.4.0.
565
852
</para>
566
853
</listitem>
567
854
</varlistentry>
568
-
<varlistentry xml:id="constantmysqli-cursor-type-no-cursor">
569
-
<term><constant>MYSQLI_CURSOR_TYPE_NO_CURSOR</constant></term>
855
+
<varlistentry xml:id="constant.mysqli-cursor-type-no-cursor">
856
+
<term>
857
+
<constant>MYSQLI_CURSOR_TYPE_NO_CURSOR</constant>
858
+
(<type>int</type>)
859
+
</term>
570
860
<listitem>
571
861
<para>
572
862
</para>
573
863
</listitem>
574
864
</varlistentry>
575
-
<varlistentry xml:id="constantmysqli-cursor-type-read-only">
576
-
<term><constant>MYSQLI_CURSOR_TYPE_READ_ONLY</constant></term>
865
+
<varlistentry xml:id="constant.mysqli-cursor-type-read-only">
866
+
<term>
867
+
<constant>MYSQLI_CURSOR_TYPE_READ_ONLY</constant>
868
+
(<type>int</type>)
869
+
</term>
577
870
<listitem>
578
871
<para>
579
872
</para>
580
873
</listitem>
581
874
</varlistentry>
582
-
<varlistentry xml:id="constantmysqli-cursor-type-scrollable">
583
-
<term><constant>MYSQLI_CURSOR_TYPE_SCROLLABLE</constant></term>
875
+
<varlistentry xml:id="constant.mysqli-cursor-type-scrollable">
876
+
<term>
877
+
<constant>MYSQLI_CURSOR_TYPE_SCROLLABLE</constant>
878
+
(<type>int</type>)
879
+
</term>
584
880
<listitem>
585
881
<para>
882
+
Removed as of PHP 8.4.0.
586
883
</para>
587
884
</listitem>
588
885
</varlistentry>
589
-
<varlistentry xml:id="constantmysqli-stmt-attr-cursor-type">
590
-
<term><constant>MYSQLI_STMT_ATTR_CURSOR_TYPE</constant></term>
886
+
<varlistentry xml:id="constant.mysqli-stmt-attr-cursor-type">
887
+
<term>
888
+
<constant>MYSQLI_STMT_ATTR_CURSOR_TYPE</constant>
889
+
(<type>int</type>)
890
+
</term>
591
891
<listitem>
592
892
<para>
593
893
</para>
594
894
</listitem>
595
895
</varlistentry>
596
-
<varlistentry xml:id="constantmysqli-stmt-attr-prefetch-rows">
597
-
<term><constant>MYSQLI_STMT_ATTR_PREFETCH_ROWS</constant></term>
896
+
<varlistentry xml:id="constant.mysqli-stmt-attr-prefetch-rows">
897
+
<term>
898
+
<constant>MYSQLI_STMT_ATTR_PREFETCH_ROWS</constant>
899
+
(<type>int</type>)
900
+
</term>
598
901
<listitem>
599
902
<para>
903
+
Removed as of PHP 8.4.0.
600
904
</para>
601
905
</listitem>
602
906
</varlistentry>
603
-
<varlistentry xml:id="constantmysqli-stmt-attr-update-max-length">
604
-
<term><constant>MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH</constant></term>
907
+
<varlistentry xml:id="constant.mysqli-stmt-attr-update-max-length">
908
+
<term>
909
+
<constant>MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH</constant>
910
+
(<type>int</type>)
911
+
</term>
605
912
<listitem>
606
913
<para>
607
914
</para>
608
915
</listitem>
609
916
</varlistentry>
610
-
<varlistentry xml:id="constantmysqli-set-charset-name">
611
-
<term><constant>MYSQLI_SET_CHARSET_NAME</constant></term>
917
+
<varlistentry xml:id="constant.mysqli-set-charset-name">
918
+
<term>
919
+
<constant>MYSQLI_SET_CHARSET_NAME</constant>
920
+
(<type>int</type>)
921
+
</term>
612
922
<listitem>
613
923
<para>
614
924
</para>
615
925
</listitem>
616
926
</varlistentry>
617
-
<varlistentry xml:id="constantmysqli-report-index">
618
-
<term><constant>MYSQLI_REPORT_INDEX</constant></term>
927
+
<varlistentry xml:id="constant.mysqli-report-index">
928
+
<term>
929
+
<constant>MYSQLI_REPORT_INDEX</constant>
930
+
(<type>int</type>)
931
+
</term>
619
932
<listitem>
620
933
<para>
621
934
Report if no index or bad index was used in a query.
622
935
</para>
623
936
</listitem>
624
937
</varlistentry>
625
-
<varlistentry xml:id="constantmysqli-report-error">
626
-
<term><constant>MYSQLI_REPORT_ERROR</constant></term>
938
+
<varlistentry xml:id="constant.mysqli-report-error">
939
+
<term>
940
+
<constant>MYSQLI_REPORT_ERROR</constant>
941
+
(<type>int</type>)
942
+
</term>
627
943
<listitem>
628
944
<para>
629
945
Report errors from mysqli function calls.
630
946
</para>
631
947
</listitem>
632
948
</varlistentry>
633
-
<varlistentry xml:id="constantmysqli-report-strict">
634
-
<term><constant>MYSQLI_REPORT_STRICT</constant></term>
949
+
<varlistentry xml:id="constant.mysqli-report-strict">
950
+
<term>
951
+
<constant>MYSQLI_REPORT_STRICT</constant>
952
+
(<type>int</type>)
953
+
</term>
635
954
<listitem>
636
955
<para>
637
956
Throw a <literal>mysqli_sql_exception</literal> for errors instead of warnings.
638
957
</para>
639
958
</listitem>
640
959
</varlistentry>
641
-
<varlistentry xml:id="constantmysqli-report-all">
642
-
<term><constant>MYSQLI_REPORT_ALL</constant></term>
960
+
<varlistentry xml:id="constant.mysqli-report-all">
961
+
<term>
962
+
<constant>MYSQLI_REPORT_ALL</constant>
963
+
(<type>int</type>)
964
+
</term>
643
965
<listitem>
644
966
<para>
645
967
Set all options on (report all).
646
968
</para>
647
969
</listitem>
648
970
</varlistentry>
649
-
<varlistentry xml:id="constantmysqli-report-off">
650
-
<term><constant>MYSQLI_REPORT_OFF</constant></term>
971
+
<varlistentry xml:id="constant.mysqli-report-off">
972
+
<term>
973
+
<constant>MYSQLI_REPORT_OFF</constant>
974
+
(<type>int</type>)
975
+
</term>
651
976
<listitem>
652
977
<para>
653
978
Turns reporting off.
654
979
</para>
655
980
</listitem>
656
981
</varlistentry>
657
-
<varlistentry xml:id="constantmysqli-debug-trace-enabled">
658
-
<term><constant>MYSQLI_DEBUG_TRACE_ENABLED</constant></term>
982
+
<varlistentry xml:id="constant.mysqli-debug-trace-enabled">
983
+
<term>
984
+
<constant>MYSQLI_DEBUG_TRACE_ENABLED</constant>
985
+
(<type>int</type>)
986
+
</term>
659
987
<listitem>
660
988
<para>
661
989
Is set to 1 if <function>mysqli_debug</function> functionality is enabled.
662
990
</para>
663
991
</listitem>
664
992
</varlistentry>
665
-
<varlistentry xml:id="constantmysqli-server-query-no-good-index-used">
666
-
<term><constant>MYSQLI_SERVER_QUERY_NO_GOOD_INDEX_USED</constant></term>
667
-
<listitem>
668
-
<para>
669
-
</para>
670
-
</listitem>
671
-
</varlistentry>
672
-
<varlistentry xml:id="constantmysqli-server-query-no-index-used">
673
-
<term><constant>MYSQLI_SERVER_QUERY_NO_INDEX_USED</constant></term>
674
-
<listitem>
675
-
<para>
676
-
</para>
677
-
</listitem>
678
-
</varlistentry>
679
-
<varlistentry xml:id="constantmysqli-server-public-key">
680
-
<term><constant>MYSQLI_SERVER_PUBLIC_KEY</constant></term>
993
+
<varlistentry xml:id="constant.mysqli-server-public-key">
994
+
<term>
995
+
<constant>MYSQLI_SERVER_PUBLIC_KEY</constant>
996
+
(<type>int</type>)
997
+
</term>
681
998
<listitem>
682
999
<para>
683
1000
</para>
684
1001
</listitem>
685
1002
</varlistentry>
686
-
<varlistentry xml:id="constantmysqli-refresh-grant">
687
-
<term><constant>MYSQLI_REFRESH_GRANT</constant></term>
1003
+
<varlistentry xml:id="constant.mysqli-refresh-grant">
1004
+
<term>
1005
+
<constant>MYSQLI_REFRESH_GRANT</constant>
1006
+
(<type>int</type>)
1007
+
</term>
688
1008
<listitem>
689
1009
<para>
690
1010
Refreshes the grant tables.
1011
+
Deprecated as of PHP 8.4.0.
691
1012
</para>
692
1013
</listitem>
693
1014
</varlistentry>
694
-
<varlistentry xml:id="constantmysqli-refresh-log">
695
-
<term><constant>MYSQLI_REFRESH_LOG</constant></term>
1015
+
<varlistentry xml:id="constant.mysqli-refresh-log">
1016
+
<term>
1017
+
<constant>MYSQLI_REFRESH_LOG</constant>
1018
+
(<type>int</type>)
1019
+
</term>
696
1020
<listitem>
697
1021
<para>
698
1022
Flushes the logs, like executing the
699
1023
<literal>FLUSH LOGS</literal> <acronym>SQL</acronym> statement.
1024
+
Deprecated as of PHP 8.4.0.
700
1025
</para>
701
1026
</listitem>
702
1027
</varlistentry>
703
-
<varlistentry xml:id="constantmysqli-refresh-tables">
704
-
<term><constant>MYSQLI_REFRESH_TABLES</constant></term>
1028
+
<varlistentry xml:id="constant.mysqli-refresh-tables">
1029
+
<term>
1030
+
<constant>MYSQLI_REFRESH_TABLES</constant>
1031
+
(<type>int</type>)
1032
+
</term>
705
1033
<listitem>
706
1034
<para>
707
1035
Flushes the table cache, like executing the
708
1036
<literal>FLUSH TABLES</literal> <acronym>SQL</acronym> statement.
1037
+
Deprecated as of PHP 8.4.0.
709
1038
</para>
710
1039
</listitem>
711
1040
</varlistentry>
712
-
<varlistentry xml:id="constantmysqli-refresh-hosts">
713
-
<term><constant>MYSQLI_REFRESH_HOSTS</constant></term>
1041
+
<varlistentry xml:id="constant.mysqli-refresh-hosts">
1042
+
<term>
1043
+
<constant>MYSQLI_REFRESH_HOSTS</constant>
1044
+
(<type>int</type>)
1045
+
</term>
714
1046
<listitem>
715
1047
<para>
716
1048
Flushes the host cache, like executing the
717
1049
<literal>FLUSH HOSTS</literal> <acronym>SQL</acronym> statement.
1050
+
Deprecated as of PHP 8.4.0.
718
1051
</para>
719
1052
</listitem>
720
1053
</varlistentry>
721
-
<varlistentry xml:id="constantmysqli-refresh-status">
722
-
<term><constant>MYSQLI_REFRESH_STATUS</constant></term>
1054
+
<varlistentry xml:id="constant.mysqli-refresh-replica">
1055
+
<term>
1056
+
<constant>MYSQLI_REFRESH_REPLICA</constant>
1057
+
(<type>int</type>)
1058
+
</term>
1059
+
<listitem>
1060
+
<para>
1061
+
Alias of <constant>MYSQLI_REFRESH_SLAVE</constant> constant.
1062
+
Available as of PHP 8.1.0. Deprecated as of PHP 8.4.0.
1063
+
</para>
1064
+
</listitem>
1065
+
</varlistentry>
1066
+
<varlistentry xml:id="constant.mysqli-refresh-status">
1067
+
<term>
1068
+
<constant>MYSQLI_REFRESH_STATUS</constant>
1069
+
(<type>int</type>)
1070
+
</term>
723
1071
<listitem>
724
1072
<para>
725
1073
Reset the status variables, like executing the
726
1074
<literal>FLUSH STATUS</literal> <acronym>SQL</acronym> statement.
1075
+
Deprecated as of PHP 8.4.0.
727
1076
</para>
728
1077
</listitem>
729
1078
</varlistentry>
730
-
<varlistentry xml:id="constantmysqli-refresh-threads">
731
-
<term><constant>MYSQLI_REFRESH_THREADS</constant></term>
1079
+
<varlistentry xml:id="constant.mysqli-refresh-threads">
1080
+
<term>
1081
+
<constant>MYSQLI_REFRESH_THREADS</constant>
1082
+
(<type>int</type>)
1083
+
</term>
732
1084
<listitem>
733
1085
<para>
734
1086
Flushes the thread cache.
1087
+
Deprecated as of PHP 8.4.0.
735
1088
</para>
736
1089
</listitem>
737
1090
</varlistentry>
738
-
<varlistentry xml:id="constantmysqli-refresh-slave">
739
-
<term><constant>MYSQLI_REFRESH_SLAVE</constant></term>
1091
+
<varlistentry xml:id="constant.mysqli-refresh-slave">
1092
+
<term>
1093
+
<constant>MYSQLI_REFRESH_SLAVE</constant>
1094
+
(<type>int</type>)
1095
+
</term>
740
1096
<listitem>
741
1097
<para>
742
1098
On a slave replication server: resets the master server information, and
743
1099
restarts the slave. Like executing the <literal>RESET SLAVE</literal>
744
1100
<acronym>SQL</acronym> statement.
1101
+
Deprecated as of PHP 8.4.0.
745
1102
</para>
746
1103
</listitem>
747
1104
</varlistentry>
748
-
<varlistentry xml:id="constantmysqli-refresh-master">
749
-
<term><constant>MYSQLI_REFRESH_MASTER</constant></term>
1105
+
<varlistentry xml:id="constant.mysqli-refresh-master">
1106
+
<term>
1107
+
<constant>MYSQLI_REFRESH_MASTER</constant>
1108
+
(<type>int</type>)
1109
+
</term>
750
1110
<listitem>
751
1111
<para>
752
1112
On a master replication server: removes the binary log files listed in the
753
1113
binary log index, and truncates the index file. Like executing the
754
1114
<literal>RESET MASTER</literal> <acronym>SQL</acronym> statement.
1115
+
Deprecated as of PHP 8.4.0.
755
1116
</para>
756
1117
</listitem>
757
1118
</varlistentry>
758
-
<varlistentry xml:id="constantmysqli-trans-cor-and-chain">
759
-
<term><constant>MYSQLI_TRANS_COR_AND_CHAIN</constant></term>
1119
+
<varlistentry xml:id="constant.mysqli-refresh-backup-log">
1120
+
<term>
1121
+
<constant>MYSQLI_REFRESH_BACKUP_LOG</constant>
1122
+
(<type>int</type>)
1123
+
</term>
1124
+
<listitem>
1125
+
<simpara>
1126
+
Closes and reopens the backup log files.
1127
+
Deprecated as of PHP 8.4.0.
1128
+
</simpara>
1129
+
</listitem>
1130
+
</varlistentry>
1131
+
<varlistentry xml:id="constant.mysqli-trans-cor-and-chain">
1132
+
<term>
1133
+
<constant>MYSQLI_TRANS_COR_AND_CHAIN</constant>
1134
+
(<type>int</type>)
1135
+
</term>
760
1136
<listitem>
761
1137
<para>
762
1138
Appends "AND CHAIN" to <function>mysqli_commit</function> or
...
...
@@ -764,8 +1140,11 @@
764
1140
</para>
765
1141
</listitem>
766
1142
</varlistentry>
767
-
<varlistentry xml:id="constantmysqli-trans-cor-and-no-chain">
768
-
<term><constant>MYSQLI_TRANS_COR_AND_NO_CHAIN</constant></term>
1143
+
<varlistentry xml:id="constant.mysqli-trans-cor-and-no-chain">
1144
+
<term>
1145
+
<constant>MYSQLI_TRANS_COR_AND_NO_CHAIN</constant>
1146
+
(<type>int</type>)
1147
+
</term>
769
1148
<listitem>
770
1149
<para>
771
1150
Appends "AND NO CHAIN" to <function>mysqli_commit</function> or
...
...
@@ -773,8 +1152,11 @@
773
1152
</para>
774
1153
</listitem>
775
1154
</varlistentry>
776
-
<varlistentry xml:id="constantmysqli-trans-cor-release">
777
-
<term><constant>MYSQLI_TRANS_COR_RELEASE</constant></term>
1155
+
<varlistentry xml:id="constant.mysqli-trans-cor-release">
1156
+
<term>
1157
+
<constant>MYSQLI_TRANS_COR_RELEASE</constant>
1158
+
(<type>int</type>)
1159
+
</term>
778
1160
<listitem>
779
1161
<para>
780
1162
Appends "RELEASE" to <function>mysqli_commit</function> or
...
...
@@ -782,8 +1164,11 @@
782
1164
</para>
783
1165
</listitem>
784
1166
</varlistentry>
785
-
<varlistentry xml:id="constantmysqli-trans-cor-no-release">
786
-
<term><constant>MYSQLI_TRANS_COR_NO_RELEASE</constant></term>
1167
+
<varlistentry xml:id="constant.mysqli-trans-cor-no-release">
1168
+
<term>
1169
+
<constant>MYSQLI_TRANS_COR_NO_RELEASE</constant>
1170
+
(<type>int</type>)
1171
+
</term>
787
1172
<listitem>
788
1173
<para>
789
1174
Appends "NO RELEASE" to <function>mysqli_commit</function> or
...
...
@@ -791,8 +1176,11 @@
791
1176
</para>
792
1177
</listitem>
793
1178
</varlistentry>
794
-
<varlistentry xml:id="constantmysqli-trans-start-read-only">
795
-
<term><constant>MYSQLI_TRANS_START_READ_ONLY</constant></term>
1179
+
<varlistentry xml:id="constant.mysqli-trans-start-read-only">
1180
+
<term>
1181
+
<constant>MYSQLI_TRANS_START_READ_ONLY</constant>
1182
+
(<type>int</type>)
1183
+
</term>
796
1184
<listitem>
797
1185
<para>
798
1186
Start the transaction as "START TRANSACTION READ ONLY" with
...
...
@@ -800,8 +1188,11 @@
800
1188
</para>
801
1189
</listitem>
802
1190
</varlistentry>
803
-
<varlistentry xml:id="constantmysqli-trans-start-read-write">
804
-
<term><constant>MYSQLI_TRANS_START_READ_WRITE</constant></term>
1191
+
<varlistentry xml:id="constant.mysqli-trans-start-read-write">
1192
+
<term>
1193
+
<constant>MYSQLI_TRANS_START_READ_WRITE</constant>
1194
+
(<type>int</type>)
1195
+
</term>
805
1196
<listitem>
806
1197
<para>
807
1198
Start the transaction as "START TRANSACTION READ WRITE" with
...
...
@@ -809,27 +1200,65 @@
809
1200
</para>
810
1201
</listitem>
811
1202
</varlistentry>
812
-
<varlistentry xml:id="constantmysqli-trans-start-consistent-snapshot">
813
-
<term><constant>MYSQLI_TRANS_START_CONSISTENT_SNAPSHOT</constant></term>
1203
+
<varlistentry xml:id="constant.mysqli-trans-start-with-consistent-snapshot">
1204
+
<term>
1205
+
<constant>MYSQLI_TRANS_START_WITH_CONSISTENT_SNAPSHOT</constant>
1206
+
(<type>int</type>)
1207
+
</term>
814
1208
<listitem>
815
1209
<para>
816
-
Start the transaction as "START TRANSACTION WITH CONSISTENT SNAPSHOT" with
817
-
<function>mysqli_begin_transaction</function>.
1210
+
Start the transaction as "START TRANSACTION WITH CONSISTENT SNAPSHOT".
818
1211
</para>
819
1212
</listitem>
820
1213
</varlistentry>
821
-
<varlistentry xml:id="constantmysqli-client-ssl-dont-verify-server-cert">
822
-
<term><constant>MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT</constant></term>
1214
+
<varlistentry xml:id="constant.mysqli-client-ssl-dont-verify-server-cert">
1215
+
<term>
1216
+
<constant>MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT</constant>
1217
+
(<type>int</type>)
1218
+
</term>
823
1219
<listitem>
824
1220
<para>
825
1221
Requires MySQL 5.6.5 and up.
826
1222
</para>
827
1223
</listitem>
828
1224
</varlistentry>
1225
+
<varlistentry xml:id="constant.mysqli-is-mariadb">
1226
+
<term>
1227
+
<constant>MYSQLI_IS_MARIADB</constant>
1228
+
(<type>bool</type>)
1229
+
</term>
1230
+
<listitem>
1231
+
<para>
1232
+
Whether the mysqli extension has been built against a MariaDB client library.
1233
+
Available as of PHP 8.1.2.
1234
+
</para>
1235
+
</listitem>
1236
+
</varlistentry>
1237
+
<varlistentry xml:id="constant.mysqli-async">
1238
+
<term>
1239
+
<constant>MYSQLI_ASYNC</constant>
1240
+
(<type>int</type>)
1241
+
</term>
1242
+
<listitem>
1243
+
<simpara>
1244
+
The query is performed asynchronously and no result set is immediately returned.
1245
+
Available with <literal>mysqlnd</literal> only.
1246
+
</simpara>
1247
+
</listitem>
1248
+
</varlistentry>
1249
+
<varlistentry xml:id="constant.mysqli-on-update-now-flag">
1250
+
<term>
1251
+
<constant>MYSQLI_ON_UPDATE_NOW_FLAG</constant>
1252
+
(<type>int</type>)
1253
+
</term>
1254
+
<listitem>
1255
+
<simpara>
1256
+
If a field is updated it will get the current time value.
1257
+
</simpara>
1258
+
</listitem>
1259
+
</varlistentry>
829
1260
</variablelist>
830
1261
</appendix>
831
-
832
-
833
1262
<!-- Keep this comment at the end of the file
834
1263
Local variables:
835
1264
mode: sgml
...
...
@@ -850,4 +1279,3 @@ vim600: syn=xml fen fdm=syntax fdl=2 si
850
1279
vim: et tw=78 syn=sgml
851
1280
vi: ts=1 sw=1
852
1281
-->
853
-
854
1282