summaryrefslogtreecommitdiff
path: root/vendor/thecodingmachine/safe/generated/msql.php
blob: 331c1b6cd45380c1077f028e1e49a24e2adc0c9e (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
<?php

namespace Safe;

use Safe\Exceptions\MsqlException;

/**
 * Returns number of affected rows by the last SELECT, UPDATE or DELETE
 * query associated with result.
 *
 * @param resource $result The result resource that
 * is being evaluated. This result comes from a call to
 * msql_query.
 * @return int Returns the number of affected rows on success.
 * @throws MsqlException
 *
 */
function msql_affected_rows($result): int
{
    error_clear_last();
    $result = \msql_affected_rows($result);
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
    return $result;
}


/**
 * msql_close closes the non-persistent connection to
 * the mSQL server that's associated with the specified link identifier.
 *
 * Using msql_close isn't usually necessary, as
 * non-persistent open links are automatically closed at the end of the
 * script's execution. See also freeing resources.
 *
 * @param resource|null $link_identifier The mSQL connection.
 * If not specified, the last link opened by msql_connect
 * is assumed. If no such link is found, the function will try to establish a
 * link as if msql_connect was called, and use it.
 * @throws MsqlException
 *
 */
function msql_close($link_identifier = null): void
{
    error_clear_last();
    if ($link_identifier !== null) {
        $result = \msql_close($link_identifier);
    } else {
        $result = \msql_close();
    }
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
}


/**
 * msql_connect establishes a connection to a mSQL
 * server.
 *
 * If a second call is made to msql_connect with
 * the same arguments, no new link will be established, but instead, the
 * link identifier of the already opened link will be returned.
 *
 * The link to the server will be closed as soon as the execution of the
 * script ends, unless it's closed earlier by explicitly calling
 * msql_close.
 *
 * @param string $hostname The hostname can also include a port number. e.g.
 * hostname,port.
 *
 * If not specified, the connection is established by the means of a Unix
 * domain socket, being then more efficient then a localhost TCP socket
 * connection.
 *
 * While this function will accept a colon (:) as a
 * host/port separator, a comma (,) is the preferred
 * method.
 * @return resource Returns a positive mSQL link identifier on success.
 * @throws MsqlException
 *
 */
function msql_connect(string $hostname = null)
{
    error_clear_last();
    if ($hostname !== null) {
        $result = \msql_connect($hostname);
    } else {
        $result = \msql_connect();
    }
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
    return $result;
}


/**
 * msql_create_db attempts to create a new database on
 * the mSQL server.
 *
 * @param string $database_name The name of the mSQL database.
 * @param resource|null $link_identifier The mSQL connection.
 * If not specified, the last link opened by msql_connect
 * is assumed. If no such link is found, the function will try to establish a
 * link as if msql_connect was called, and use it.
 * @throws MsqlException
 *
 */
function msql_create_db(string $database_name, $link_identifier = null): void
{
    error_clear_last();
    if ($link_identifier !== null) {
        $result = \msql_create_db($database_name, $link_identifier);
    } else {
        $result = \msql_create_db($database_name);
    }
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
}


/**
 * msql_data_seek moves the internal row
 * pointer of the mSQL result associated with the specified query
 * identifier to point to the specified row number.  The next call
 * to msql_fetch_row would return that
 * row.
 *
 * @param resource $result The result resource that
 * is being evaluated. This result comes from a call to
 * msql_query.
 * @param int $row_number The seeked row number.
 * @throws MsqlException
 *
 */
function msql_data_seek($result, int $row_number): void
{
    error_clear_last();
    $result = \msql_data_seek($result, $row_number);
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
}


/**
 * msql_db_query selects a database and executes a query
 * on it.
 *
 * @param string $database The name of the mSQL database.
 * @param string $query The SQL query.
 * @param resource|null $link_identifier The mSQL connection.
 * If not specified, the last link opened by msql_connect
 * is assumed. If no such link is found, the function will try to establish a
 * link as if msql_connect was called, and use it.
 * @return resource Returns a positive mSQL query identifier to the query result.
 * @throws MsqlException
 *
 */
function msql_db_query(string $database, string $query, $link_identifier = null)
{
    error_clear_last();
    if ($link_identifier !== null) {
        $result = \msql_db_query($database, $query, $link_identifier);
    } else {
        $result = \msql_db_query($database, $query);
    }
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
    return $result;
}


/**
 * msql_drop_db attempts to drop (remove) a database
 * from the mSQL server.
 *
 * @param string $database_name The name of the database.
 * @param resource|null $link_identifier The mSQL connection.
 * If not specified, the last link opened by msql_connect
 * is assumed. If no such link is found, the function will try to establish a
 * link as if msql_connect was called, and use it.
 * @throws MsqlException
 *
 */
function msql_drop_db(string $database_name, $link_identifier = null): void
{
    error_clear_last();
    if ($link_identifier !== null) {
        $result = \msql_drop_db($database_name, $link_identifier);
    } else {
        $result = \msql_drop_db($database_name);
    }
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
}


/**
 * msql_field_len returns the length of the specified
 * field.
 *
 * @param resource $result The result resource that
 * is being evaluated. This result comes from a call to
 * msql_query.
 * @param int $field_offset The numerical field offset. The
 * field_offset starts at 1.
 * @return int Returns the length of the specified field.
 * @throws MsqlException
 *
 */
function msql_field_len($result, int $field_offset): int
{
    error_clear_last();
    $result = \msql_field_len($result, $field_offset);
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
    return $result;
}


/**
 * msql_field_name gets the name of the specified field
 * index.
 *
 * @param resource $result The result resource that
 * is being evaluated. This result comes from a call to
 * msql_query.
 * @param int $field_offset The numerical field offset. The
 * field_offset starts at 1.
 * @return string The name of the field.
 * @throws MsqlException
 *
 */
function msql_field_name($result, int $field_offset): string
{
    error_clear_last();
    $result = \msql_field_name($result, $field_offset);
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
    return $result;
}


/**
 * Seeks to the specified field offset. If the next call to
 * msql_fetch_field won't include a field offset, this
 * field would be returned.
 *
 * @param resource $result The result resource that
 * is being evaluated. This result comes from a call to
 * msql_query.
 * @param int $field_offset The numerical field offset. The
 * field_offset starts at 1.
 * @throws MsqlException
 *
 */
function msql_field_seek($result, int $field_offset): void
{
    error_clear_last();
    $result = \msql_field_seek($result, $field_offset);
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
}


/**
 * Returns the name of the table that the specified field is in.
 *
 * @param resource $result The result resource that
 * is being evaluated. This result comes from a call to
 * msql_query.
 * @param int $field_offset The numerical field offset. The
 * field_offset starts at 1.
 * @return int The name of the table on success.
 * @throws MsqlException
 *
 */
function msql_field_table($result, int $field_offset): int
{
    error_clear_last();
    $result = \msql_field_table($result, $field_offset);
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
    return $result;
}


/**
 * msql_field_type gets the type of the specified field
 * index.
 *
 * @param resource $result The result resource that
 * is being evaluated. This result comes from a call to
 * msql_query.
 * @param int $field_offset The numerical field offset. The
 * field_offset starts at 1.
 * @return string The type of the field. One of int,
 * char, real, ident,
 * null or unknown. This functions will
 * return FALSE on failure.
 * @throws MsqlException
 *
 */
function msql_field_type($result, int $field_offset): string
{
    error_clear_last();
    $result = \msql_field_type($result, $field_offset);
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
    return $result;
}


/**
 * msql_free_result frees the memory associated
 * with query_identifier.  When PHP completes a
 * request, this memory is freed automatically, so you only need to
 * call this function when you want to make sure you don't use too
 * much memory while the script is running.
 *
 * @param resource $result The result resource that
 * is being evaluated. This result comes from a call to
 * msql_query.
 * @throws MsqlException
 *
 */
function msql_free_result($result): void
{
    error_clear_last();
    $result = \msql_free_result($result);
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
}


/**
 * msql_pconnect acts very much like
 * msql_connect with two major differences.
 *
 * First, when connecting, the function would first try to find a
 * (persistent) link that's already open with the same host.
 * If one is found, an identifier for it will be returned instead of opening
 * a new connection.
 *
 * Second, the connection to the SQL server will not be closed when the
 * execution of the script ends.  Instead, the link will remain open for
 * future use (msql_close will not close links
 * established by this function).
 *
 * @param string $hostname The hostname can also include a port number. e.g.
 * hostname,port.
 *
 * If not specified, the connection is established by the means of a Unix
 * domain socket, being more efficient than a localhost TCP socket
 * connection.
 * @return resource Returns a positive mSQL link identifier on success.
 * @throws MsqlException
 *
 */
function msql_pconnect(string $hostname = null)
{
    error_clear_last();
    if ($hostname !== null) {
        $result = \msql_pconnect($hostname);
    } else {
        $result = \msql_pconnect();
    }
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
    return $result;
}


/**
 * msql_query sends a query to the currently active
 * database on the server that's associated with the specified link
 * identifier.
 *
 * @param string $query The SQL query.
 * @param resource|null $link_identifier The mSQL connection.
 * If not specified, the last link opened by msql_connect
 * is assumed. If no such link is found, the function will try to establish a
 * link as if msql_connect was called, and use it.
 * @return resource Returns a positive mSQL query identifier on success.
 * @throws MsqlException
 *
 */
function msql_query(string $query, $link_identifier = null)
{
    error_clear_last();
    if ($link_identifier !== null) {
        $result = \msql_query($query, $link_identifier);
    } else {
        $result = \msql_query($query);
    }
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
    return $result;
}


/**
 * msql_select_db sets the current active database on
 * the server that's associated with the specified
 * link_identifier.
 *
 * Subsequent calls to msql_query will be made on the
 * active database.
 *
 * @param string $database_name The database name.
 * @param resource|null $link_identifier The mSQL connection.
 * If not specified, the last link opened by msql_connect
 * is assumed. If no such link is found, the function will try to establish a
 * link as if msql_connect was called, and use it.
 * @throws MsqlException
 *
 */
function msql_select_db(string $database_name, $link_identifier = null): void
{
    error_clear_last();
    if ($link_identifier !== null) {
        $result = \msql_select_db($database_name, $link_identifier);
    } else {
        $result = \msql_select_db($database_name);
    }
    if ($result === false) {
        throw MsqlException::createFromPhpError();
    }
}