123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643 |
- /*
- +----------------------------------------------------------------------+
- | Copyright (c) The PHP Group |
- +----------------------------------------------------------------------+
- | This source file is subject to version 3.01 of the PHP license, |
- | that is bundled with this package in the file LICENSE, and is |
- | available through the world-wide-web at the following url: |
- | https://www.php.net/license/3_01.txt |
- | If you did not receive a copy of the PHP license and are unable to |
- | obtain it through the world-wide-web, please send a note to |
- | license@php.net so we can mail you a copy immediately. |
- +----------------------------------------------------------------------+
- | Authors: Georg Richter <georg@php.net> |
- | Andrey Hristov <andrey@php.net> |
- | Ulf Wendel <uw@php.net> |
- +----------------------------------------------------------------------+
- */
- #ifdef HAVE_CONFIG_H
- #include "config.h"
- #endif
- #include <signal.h>
- #include "php.h"
- #include "php_ini.h"
- #include "php_globals.h"
- #include "ext/standard/info.h"
- #include "zend_smart_str.h"
- #include "php_mysqli_structs.h"
- #include "mysqli_priv.h"
- #include "ext/mysqlnd/mysql_float_to_double.h"
- #define ERROR_ARG_POS(arg_num) (getThis() ? (arg_num-1) : (arg_num))
- #ifndef MYSQLI_USE_MYSQLND
- /* {{{ mysqli_tx_cor_options_to_string */
- static void mysqli_tx_cor_options_to_string(const MYSQL * const conn, smart_str * str, const uint32_t mode)
- {
- if (mode & TRANS_COR_AND_CHAIN && !(mode & TRANS_COR_AND_NO_CHAIN)) {
- if (str->s && ZSTR_LEN(str->s)) {
- smart_str_appendl(str, " ", sizeof(" ") - 1);
- }
- smart_str_appendl(str, "AND CHAIN", sizeof("AND CHAIN") - 1);
- } else if (mode & TRANS_COR_AND_NO_CHAIN && !(mode & TRANS_COR_AND_CHAIN)) {
- if (str->s && ZSTR_LEN(str->s)) {
- smart_str_appendl(str, " ", sizeof(" ") - 1);
- }
- smart_str_appendl(str, "AND NO CHAIN", sizeof("AND NO CHAIN") - 1);
- }
- if (mode & TRANS_COR_RELEASE && !(mode & TRANS_COR_NO_RELEASE)) {
- if (str->s && ZSTR_LEN(str->s)) {
- smart_str_appendl(str, " ", sizeof(" ") - 1);
- }
- smart_str_appendl(str, "RELEASE", sizeof("RELEASE") - 1);
- } else if (mode & TRANS_COR_NO_RELEASE && !(mode & TRANS_COR_RELEASE)) {
- if (str->s && ZSTR_LEN(str->s)) {
- smart_str_appendl(str, " ", sizeof(" ") - 1);
- }
- smart_str_appendl(str, "NO RELEASE", sizeof("NO RELEASE") - 1);
- }
- smart_str_0(str);
- }
- /* }}} */
- /* {{{ mysqlnd_escape_string_for_tx_name_in_comment */
- char *
- mysqli_escape_string_for_tx_name_in_comment(const char * const name)
- {
- char * ret = NULL;
- if (name) {
- bool warned = false;
- const char * p_orig = name;
- char * p_copy;
- p_copy = ret = emalloc(strlen(name) + 1 + 2 + 2 + 1); /* space, open, close, NullS */
- *p_copy++ = ' ';
- *p_copy++ = '/';
- *p_copy++ = '*';
- while (1) {
- char v = *p_orig;
- if (v == 0) {
- break;
- }
- if ((v >= '0' && v <= '9') ||
- (v >= 'a' && v <= 'z') ||
- (v >= 'A' && v <= 'Z') ||
- v == '-' ||
- v == '_' ||
- v == ' ' ||
- v == '=')
- {
- *p_copy++ = v;
- } else if (!warned) {
- php_error_docref(NULL, E_WARNING, "Transaction name has been truncated, since it can only contain the A-Z, a-z, 0-9, \"\\\", \"-\", \"_\", and \"=\" characters");
- warned = true;
- }
- ++p_orig;
- }
- *p_copy++ = '*';
- *p_copy++ = '/';
- *p_copy++ = 0;
- }
- return ret;
- }
- /* }}} */
- /* {{{ mysqli_commit_or_rollback_libmysql */
- static int mysqli_commit_or_rollback_libmysql(MYSQL * conn, bool commit, const uint32_t mode, const char * const name)
- {
- int ret;
- smart_str tmp_str = {0};
- mysqli_tx_cor_options_to_string(conn, &tmp_str, mode);
- smart_str_0(&tmp_str);
- {
- char *query;
- char *name_esc = mysqli_escape_string_for_tx_name_in_comment(name);
- size_t query_len;
- query_len = spprintf(&query, 0,
- (commit? "COMMIT%s %s":"ROLLBACK%s %s"), name_esc? name_esc:"", tmp_str.s? ZSTR_VAL(tmp_str.s):"");
- smart_str_free(&tmp_str);
- if (name_esc) {
- efree(name_esc);
- name_esc = NULL;
- }
- ret = mysql_real_query(conn, query, query_len);
- efree(query);
- }
- return ret;
- }
- /* }}} */
- #endif
- /* {{{ Get number of affected rows in previous MySQL operation */
- PHP_FUNCTION(mysqli_affected_rows)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- my_ulonglong rc;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- rc = mysql_affected_rows(mysql->mysql);
- if (rc == (my_ulonglong) -1) {
- RETURN_LONG(-1);
- }
- MYSQLI_RETURN_LONG_INT(rc);
- }
- /* }}} */
- /* {{{ Turn auto commit on or of */
- PHP_FUNCTION(mysqli_autocommit)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- bool automode;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Ob", &mysql_link, mysqli_link_class_entry, &automode) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- if (mysql_autocommit(mysql->mysql, (my_bool)automode)) {
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- RETURN_FALSE;
- }
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ mysqli_stmt_bind_param_do_bind */
- #ifndef MYSQLI_USE_MYSQLND
- static
- int mysqli_stmt_bind_param_do_bind(MY_STMT *stmt, unsigned int num_vars, zval *args, const char * const types, unsigned int num_extra_args)
- {
- int i, ofs;
- MYSQL_BIND *bind;
- unsigned long rc;
- /* prevent leak if variables are already bound */
- if (stmt->param.var_cnt) {
- php_free_stmt_bind_buffer(stmt->param, FETCH_SIMPLE);
- }
- stmt->param.is_null = ecalloc(num_vars, sizeof(char));
- bind = (MYSQL_BIND *) ecalloc(num_vars, sizeof(MYSQL_BIND));
- ofs = 0;
- for (i = 0; i < num_vars; i++) {
- zval *param;
- if (Z_ISREF(args[i])) {
- param = Z_REFVAL(args[i]);
- } else {
- param = &args[i];
- }
- /* set specified type */
- switch (types[ofs]) {
- case 'd': /* Double */
- bind[ofs].buffer_type = MYSQL_TYPE_DOUBLE;
- bind[ofs].buffer = &Z_DVAL_P(param);
- bind[ofs].is_null = &stmt->param.is_null[ofs];
- break;
- case 'i': /* Integer */
- #if SIZEOF_ZEND_LONG==8
- bind[ofs].buffer_type = MYSQL_TYPE_LONGLONG;
- #elif SIZEOF_ZEND_LONG==4
- bind[ofs].buffer_type = MYSQL_TYPE_LONG;
- #endif
- bind[ofs].buffer = &Z_LVAL_P(param);
- bind[ofs].is_null = &stmt->param.is_null[ofs];
- break;
- case 'b': /* Blob (send data) */
- bind[ofs].buffer_type = MYSQL_TYPE_LONG_BLOB;
- /* don't initialize is_null and length to 0 because we use ecalloc */
- break;
- case 's': /* string */
- bind[ofs].buffer_type = MYSQL_TYPE_VAR_STRING;
- /* don't initialize buffer and buffer_length because we use ecalloc */
- bind[ofs].is_null = &stmt->param.is_null[ofs];
- break;
- default:
- zend_argument_value_error(num_extra_args, "must only contain the \"b\", \"d\", \"i\", \"s\" type specifiers");
- rc = 1;
- goto end_1;
- }
- ofs++;
- }
- rc = mysql_stmt_bind_param(stmt->stmt, bind);
- end_1:
- if (rc) {
- efree(stmt->param.is_null);
- } else {
- stmt->param.var_cnt = num_vars;
- stmt->param.vars = safe_emalloc(num_vars, sizeof(zval), 0);
- for (i = 0; i < num_vars; i++) {
- if (bind[i].buffer_type != MYSQL_TYPE_LONG_BLOB) {
- ZVAL_COPY(&stmt->param.vars[i], &args[i]);
- } else {
- ZVAL_UNDEF(&stmt->param.vars[i]);
- }
- }
- }
- efree(bind);
- return rc;
- }
- #else
- static
- int mysqli_stmt_bind_param_do_bind(MY_STMT *stmt, unsigned int num_vars, zval *args, const char * const types, unsigned int num_extra_args)
- {
- unsigned int i;
- MYSQLND_PARAM_BIND *params;
- enum_func_status ret = FAIL;
- /* If no params -> skip binding and return directly */
- if (num_vars == 0) {
- return PASS;
- }
- params = mysqlnd_stmt_alloc_param_bind(stmt->stmt);
- if (!params) {
- goto end;
- }
- for (i = 0; i < num_vars; i++) {
- zend_uchar type;
- switch (types[i]) {
- case 'd': /* Double */
- type = MYSQL_TYPE_DOUBLE;
- break;
- case 'i': /* Integer */
- #if SIZEOF_ZEND_LONG==8
- type = MYSQL_TYPE_LONGLONG;
- #elif SIZEOF_ZEND_LONG==4
- type = MYSQL_TYPE_LONG;
- #endif
- break;
- case 'b': /* Blob (send data) */
- type = MYSQL_TYPE_LONG_BLOB;
- break;
- case 's': /* string */
- type = MYSQL_TYPE_VAR_STRING;
- break;
- default:
- zend_argument_value_error(num_extra_args, "must only contain the \"b\", \"d\", \"i\", \"s\" type specifiers");
- ret = FAIL;
- mysqlnd_stmt_free_param_bind(stmt->stmt, params);
- goto end;
- }
- ZVAL_COPY_VALUE(¶ms[i].zv, &args[i]);
- params[i].type = type;
- }
- ret = mysqlnd_stmt_bind_param(stmt->stmt, params);
- end:
- return ret;
- }
- #endif
- /* }}} */
- /* {{{ Bind variables to a prepared statement as parameters */
- PHP_FUNCTION(mysqli_stmt_bind_param)
- {
- zval *args;
- int argc;
- MY_STMT *stmt;
- zval *mysql_stmt;
- char *types;
- size_t types_len;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os*", &mysql_stmt, mysqli_stmt_class_entry, &types, &types_len, &args, &argc) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- if (!types_len) {
- zend_argument_value_error(ERROR_ARG_POS(2), "cannot be empty");
- RETURN_THROWS();
- }
- if (types_len != (size_t) argc) {
- /* number of bind variables doesn't match number of elements in type definition string */
- zend_argument_count_error("The number of elements in the type definition string must match the number of bind variables");
- RETURN_THROWS();
- }
- if (types_len != mysql_stmt_param_count(stmt->stmt)) {
- zend_argument_count_error("The number of variables must match the number of parameters in the prepared statement");
- RETURN_THROWS();
- }
- RETVAL_BOOL(!mysqli_stmt_bind_param_do_bind(stmt, argc, args, types, getThis() ? 1 : 2));
- MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
- }
- /* }}} */
- /* {{{ mysqli_stmt_bind_result_do_bind */
- #ifndef MYSQLI_USE_MYSQLND
- /* TODO:
- do_alloca, free_alloca
- */
- static int
- mysqli_stmt_bind_result_do_bind(MY_STMT *stmt, zval *args, unsigned int argc)
- {
- MYSQL_BIND *bind;
- int i, ofs;
- int var_cnt = argc;
- zend_long col_type;
- zend_ulong rc;
- /* prevent leak if variables are already bound */
- if (stmt->result.var_cnt) {
- php_free_stmt_bind_buffer(stmt->result, FETCH_RESULT);
- }
- bind = (MYSQL_BIND *)ecalloc(var_cnt, sizeof(MYSQL_BIND));
- {
- int size;
- char *p = emalloc(size= var_cnt * (sizeof(char) + sizeof(VAR_BUFFER)));
- stmt->result.buf = (VAR_BUFFER *) p;
- stmt->result.is_null = (my_bool *) (p + var_cnt * sizeof(VAR_BUFFER));
- memset(p, 0, size);
- }
- for (i = 0; i < var_cnt; i++) {
- ofs = i;
- col_type = (stmt->stmt->fields) ? stmt->stmt->fields[ofs].type : MYSQL_TYPE_STRING;
- switch (col_type) {
- case MYSQL_TYPE_FLOAT:
- stmt->result.buf[ofs].type = IS_DOUBLE;
- stmt->result.buf[ofs].buflen = sizeof(float);
- stmt->result.buf[ofs].val = (char *)emalloc(sizeof(float));
- bind[ofs].buffer_type = MYSQL_TYPE_FLOAT;
- bind[ofs].buffer = stmt->result.buf[ofs].val;
- bind[ofs].is_null = &stmt->result.is_null[ofs];
- break;
- case MYSQL_TYPE_DOUBLE:
- stmt->result.buf[ofs].type = IS_DOUBLE;
- stmt->result.buf[ofs].buflen = sizeof(double);
- /* allocate buffer for double */
- stmt->result.buf[ofs].val = (char *)emalloc(sizeof(double));
- bind[ofs].buffer_type = MYSQL_TYPE_DOUBLE;
- bind[ofs].buffer = stmt->result.buf[ofs].val;
- bind[ofs].is_null = &stmt->result.is_null[ofs];
- break;
- case MYSQL_TYPE_NULL:
- stmt->result.buf[ofs].type = IS_NULL;
- /*
- don't initialize to 0 :
- 1. stmt->result.buf[ofs].buflen
- 2. bind[ofs].buffer
- 3. bind[ofs].buffer_length
- because memory was allocated with ecalloc
- */
- bind[ofs].buffer_type = MYSQL_TYPE_NULL;
- bind[ofs].is_null = &stmt->result.is_null[ofs];
- break;
- case MYSQL_TYPE_SHORT:
- case MYSQL_TYPE_TINY:
- case MYSQL_TYPE_LONG:
- case MYSQL_TYPE_INT24:
- case MYSQL_TYPE_YEAR:
- stmt->result.buf[ofs].type = IS_LONG;
- /* don't set stmt->result.buf[ofs].buflen to 0, we used ecalloc */
- stmt->result.buf[ofs].val = (char *)emalloc(sizeof(int));
- bind[ofs].buffer_type = MYSQL_TYPE_LONG;
- bind[ofs].buffer = stmt->result.buf[ofs].val;
- bind[ofs].is_null = &stmt->result.is_null[ofs];
- bind[ofs].is_unsigned = (stmt->stmt->fields[ofs].flags & UNSIGNED_FLAG) ? 1 : 0;
- break;
- case MYSQL_TYPE_LONGLONG:
- case MYSQL_TYPE_BIT:
- stmt->result.buf[ofs].type = IS_STRING;
- stmt->result.buf[ofs].buflen = sizeof(my_ulonglong);
- stmt->result.buf[ofs].val = (char *)emalloc(stmt->result.buf[ofs].buflen);
- bind[ofs].buffer_type = col_type;
- bind[ofs].buffer = stmt->result.buf[ofs].val;
- bind[ofs].is_null = &stmt->result.is_null[ofs];
- bind[ofs].buffer_length = stmt->result.buf[ofs].buflen;
- bind[ofs].is_unsigned = (stmt->stmt->fields[ofs].flags & UNSIGNED_FLAG) ? 1 : 0;
- bind[ofs].length = &stmt->result.buf[ofs].output_len;
- break;
- case MYSQL_TYPE_DATE:
- case MYSQL_TYPE_TIME:
- case MYSQL_TYPE_DATETIME:
- case MYSQL_TYPE_NEWDATE:
- case MYSQL_TYPE_VAR_STRING:
- case MYSQL_TYPE_STRING:
- case MYSQL_TYPE_TINY_BLOB:
- case MYSQL_TYPE_BLOB:
- case MYSQL_TYPE_MEDIUM_BLOB:
- case MYSQL_TYPE_LONG_BLOB:
- case MYSQL_TYPE_TIMESTAMP:
- case MYSQL_TYPE_DECIMAL:
- case MYSQL_TYPE_GEOMETRY:
- #ifdef FIELD_TYPE_NEWDECIMAL
- case MYSQL_TYPE_NEWDECIMAL:
- #endif
- {
- my_bool tmp;
- stmt->result.buf[ofs].type = IS_STRING;
- /*
- If the user has called $stmt->store_result() then we have asked
- max_length to be updated. this is done only for BLOBS because we don't want to allocate
- big chunkgs of memory 2^16 or 2^24
- */
- if (stmt->stmt->fields[ofs].max_length == 0 &&
- !mysql_stmt_attr_get(stmt->stmt, STMT_ATTR_UPDATE_MAX_LENGTH, &tmp) && !tmp)
- {
- /*
- Allocate directly 256 because it's easier to allocate a bit more
- than update max length even for text columns. Try SELECT UNION SELECT UNION with
- different lengths and you will see that we get different lengths in stmt->stmt->fields[ofs].length
- The just take 256 and saves us from realloc-ing.
- */
- stmt->result.buf[ofs].buflen =
- (stmt->stmt->fields) ? (stmt->stmt->fields[ofs].length) ? stmt->stmt->fields[ofs].length + 1: 256: 256;
- } else {
- /*
- the user has called store_result(). if he does not there is no way to determine the
- libmysql does not allow us to allocate 0 bytes for a buffer so we try 1
- */
- if (!(stmt->result.buf[ofs].buflen = stmt->stmt->fields[ofs].max_length))
- ++stmt->result.buf[ofs].buflen;
- }
- stmt->result.buf[ofs].val = (char *)emalloc(stmt->result.buf[ofs].buflen);
- bind[ofs].buffer_type = MYSQL_TYPE_STRING;
- bind[ofs].buffer = stmt->result.buf[ofs].val;
- bind[ofs].is_null = &stmt->result.is_null[ofs];
- bind[ofs].buffer_length = stmt->result.buf[ofs].buflen;
- bind[ofs].length = &stmt->result.buf[ofs].output_len;
- break;
- }
- default:
- php_error_docref(NULL, E_WARNING, "Server returned unknown type %ld. Probably your client library is incompatible with the server version you use!", col_type);
- break;
- }
- }
- rc = mysql_stmt_bind_result(stmt->stmt, bind);
- MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
- if (rc) {
- /* don't close the statement or subsequent usage (for example ->execute()) will lead to crash */
- for (i=0; i < var_cnt ; i++) {
- if (stmt->result.buf[i].val) {
- efree(stmt->result.buf[i].val);
- }
- }
- /* Don't free stmt->result.is_null because is_null & buf are one block of memory */
- efree(stmt->result.buf);
- } else {
- stmt->result.var_cnt = var_cnt;
- stmt->result.vars = safe_emalloc((var_cnt), sizeof(zval), 0);
- for (i = 0; i < var_cnt; i++) {
- ZVAL_COPY(&stmt->result.vars[i], &args[i]);
- }
- }
- efree(bind);
- return rc;
- }
- #else
- static int
- mysqli_stmt_bind_result_do_bind(MY_STMT *stmt, zval *args, unsigned int argc)
- {
- unsigned int i;
- MYSQLND_RESULT_BIND *params = mysqlnd_stmt_alloc_result_bind(stmt->stmt);
- if (params) {
- for (i = 0; i < argc; i++) {
- ZVAL_COPY_VALUE(¶ms[i].zv, &args[i]);
- }
- return mysqlnd_stmt_bind_result(stmt->stmt, params);
- }
- return FAIL;
- }
- #endif
- /* }}} */
- /* {{{ Bind variables to a prepared statement for result storage */
- PHP_FUNCTION(mysqli_stmt_bind_result)
- {
- zval *args;
- int argc;
- zend_ulong rc;
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O+", &mysql_stmt, mysqli_stmt_class_entry, &args, &argc) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- if ((uint32_t)argc != mysql_stmt_field_count(stmt->stmt)) {
- zend_argument_count_error("Number of bind variables doesn't match number of fields in prepared statement");
- RETURN_THROWS();
- }
- rc = mysqli_stmt_bind_result_do_bind(stmt, args, argc);
- RETURN_BOOL(!rc);
- }
- /* }}} */
- /* {{{ Change logged-in user of the active connection */
- PHP_FUNCTION(mysqli_change_user)
- {
- MY_MYSQL *mysql;
- zval *mysql_link = NULL;
- char *user, *password, *dbname;
- size_t user_len, password_len, dbname_len;
- zend_ulong rc;
- #ifndef MYSQLI_USE_MYSQLND
- MY_CHARSET_INFO old_charset;
- #endif
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Osss!", &mysql_link, mysqli_link_class_entry, &user, &user_len, &password, &password_len, &dbname, &dbname_len) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- #ifndef MYSQLI_USE_MYSQLND
- mysql_get_character_set_info(mysql->mysql, &old_charset);
- #endif
- #ifdef MYSQLI_USE_MYSQLND
- rc = mysqlnd_change_user_ex(mysql->mysql, user, password, dbname, false, (size_t) password_len);
- #else
- rc = mysql_change_user(mysql->mysql, user, password, dbname);
- #endif
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- if (rc) {
- RETURN_FALSE;
- }
- #ifndef MYSQLI_USE_MYSQLND
- if (mysql_get_server_version(mysql->mysql) < 50123L) {
- /*
- Request the current charset, or it will be reset to the system one.
- 5.0 doesn't support it. Support added in 5.1.23 by fixing the following bug :
- Bug #30472 libmysql doesn't reset charset, insert_id after succ. mysql_change_user() call
- */
- rc = mysql_set_character_set(mysql->mysql, old_charset.csname);
- }
- #endif
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ Returns the name of the character set used for this connection */
- PHP_FUNCTION(mysqli_character_set_name)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_STRING(mysql_character_set_name(mysql->mysql));
- }
- /* }}} */
- /* {{{ php_mysqli_close */
- void php_mysqli_close(MY_MYSQL * mysql, int close_type, int resource_status)
- {
- if (resource_status > MYSQLI_STATUS_INITIALIZED) {
- MyG(num_links)--;
- }
- if (!mysql->persistent) {
- mysqli_close(mysql->mysql, close_type);
- } else {
- zend_resource *le;
- if ((le = zend_hash_find_ptr(&EG(persistent_list), mysql->hash_key)) != NULL) {
- if (le->type == php_le_pmysqli()) {
- mysqli_plist_entry *plist = (mysqli_plist_entry *) le->ptr;
- #ifdef MYSQLI_USE_MYSQLND
- mysqlnd_end_psession(mysql->mysql);
- #endif
- if (MyG(rollback_on_cached_plink) &&
- #ifndef MYSQLI_USE_MYSQLND
- mysqli_commit_or_rollback_libmysql(mysql->mysql, false, TRANS_COR_NO_OPT, NULL))
- #else
- FAIL == mysqlnd_rollback(mysql->mysql, TRANS_COR_NO_OPT, NULL))
- #endif
- {
- mysqli_close(mysql->mysql, close_type);
- } else {
- zend_ptr_stack_push(&plist->free_links, mysql->mysql);
- MyG(num_inactive_persistent)++;
- }
- MyG(num_active_persistent)--;
- }
- }
- mysql->persistent = false;
- }
- mysql->mysql = NULL;
- php_clear_mysql(mysql);
- }
- /* }}} */
- /* {{{ Close connection */
- PHP_FUNCTION(mysqli_close)
- {
- zval *mysql_link;
- MY_MYSQL *mysql;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_INITIALIZED);
- php_mysqli_close(mysql, MYSQLI_CLOSE_EXPLICIT, ((MYSQLI_RESOURCE *)(Z_MYSQLI_P(mysql_link))->ptr)->status);
- ((MYSQLI_RESOURCE *)(Z_MYSQLI_P(mysql_link))->ptr)->status = MYSQLI_STATUS_UNKNOWN;
- MYSQLI_CLEAR_RESOURCE(mysql_link);
- efree(mysql);
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ Commit outstanding actions and close transaction */
- PHP_FUNCTION(mysqli_commit)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- zend_long flags = TRANS_COR_NO_OPT;
- char * name = NULL;
- size_t name_len;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O|ls!", &mysql_link, mysqli_link_class_entry, &flags, &name, &name_len) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- #ifndef MYSQLI_USE_MYSQLND
- if (mysqli_commit_or_rollback_libmysql(mysql->mysql, true, flags, name)) {
- #else
- if (FAIL == mysqlnd_commit(mysql->mysql, flags, name)) {
- #endif
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- RETURN_FALSE;
- }
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ Move internal result pointer */
- PHP_FUNCTION(mysqli_data_seek)
- {
- MYSQL_RES *result;
- zval *mysql_result;
- zend_long offset;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Ol", &mysql_result, mysqli_result_class_entry, &offset) == FAILURE) {
- RETURN_THROWS();
- }
- if (offset < 0) {
- zend_argument_value_error(ERROR_ARG_POS(2), "must be greater than or equal to 0");
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
- if (mysqli_result_is_unbuffered(result)) {
- if (getThis()) {
- zend_throw_error(NULL, "mysqli_result::data_seek() cannot be used in MYSQLI_USE_RESULT mode");
- } else {
- zend_throw_error(NULL, "mysqli_data_seek() cannot be used in MYSQLI_USE_RESULT mode");
- }
- RETURN_THROWS();
- }
- if ((uint64_t)offset >= mysql_num_rows(result)) {
- RETURN_FALSE;
- }
- mysql_data_seek(result, offset);
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ */
- PHP_FUNCTION(mysqli_debug)
- {
- char *debug;
- size_t debug_len;
- if (zend_parse_parameters(ZEND_NUM_ARGS(), "s", &debug, &debug_len) == FAILURE) {
- RETURN_THROWS();
- }
- mysql_debug(debug);
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ */
- PHP_FUNCTION(mysqli_dump_debug_info)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_BOOL(!mysql_dump_debug_info(mysql->mysql));
- }
- /* }}} */
- /* {{{ Returns the numerical value of the error message from previous MySQL operation */
- PHP_FUNCTION(mysqli_errno)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_LONG(mysql_errno(mysql->mysql));
- }
- /* }}} */
- /* {{{ Returns the text of the error message from previous MySQL operation */
- PHP_FUNCTION(mysqli_error)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_STRING(mysql_error(mysql->mysql));
- }
- /* }}} */
- /* {{{ Execute a prepared statement */
- PHP_FUNCTION(mysqli_stmt_execute)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- HashTable *input_params = NULL;
- #ifndef MYSQLI_USE_MYSQLND
- unsigned int i;
- #endif
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O|h!", &mysql_stmt, mysqli_stmt_class_entry, &input_params) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- // bind-in-execute
- if (input_params) {
- #if defined(MYSQLI_USE_MYSQLND)
- zval *tmp;
- unsigned int index;
- unsigned int hash_num_elements;
- unsigned int param_count;
- MYSQLND_PARAM_BIND *params;
- if (!zend_array_is_list(input_params)) {
- zend_argument_value_error(ERROR_ARG_POS(2), "must be a list array");
- RETURN_THROWS();
- }
- hash_num_elements = zend_hash_num_elements(input_params);
- param_count = mysql_stmt_param_count(stmt->stmt);
- if (hash_num_elements != param_count) {
- zend_argument_value_error(ERROR_ARG_POS(2), "must consist of exactly %d elements, %d present", param_count, hash_num_elements);
- RETURN_THROWS();
- }
- params = mysqlnd_stmt_alloc_param_bind(stmt->stmt);
- ZEND_ASSERT(params);
- index = 0;
- ZEND_HASH_FOREACH_VAL(input_params, tmp) {
- ZVAL_COPY_VALUE(¶ms[index].zv, tmp);
- params[index].type = MYSQL_TYPE_VAR_STRING;
- index++;
- } ZEND_HASH_FOREACH_END();
- if (mysqlnd_stmt_bind_param(stmt->stmt, params)) {
- MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
- RETVAL_FALSE;
- }
- #else
- zend_argument_count_error("Binding parameters in execute is not supported with libmysqlclient");
- RETURN_THROWS();
- #endif
- }
- #ifndef MYSQLI_USE_MYSQLND
- if (stmt->param.var_cnt) {
- int j;
- for (i = 0; i < stmt->param.var_cnt; i++) {
- if (!Z_ISREF(stmt->param.vars[i])) {
- continue;
- }
- for (j = i + 1; j < stmt->param.var_cnt; j++) {
- /* Oops, someone binding the same variable - clone */
- if (Z_ISREF(stmt->param.vars[j]) &&
- Z_REFVAL(stmt->param.vars[j]) == Z_REFVAL(stmt->param.vars[i])) {
- /*SEPARATE_ZVAL(&stmt->param.vars[j]);*/
- Z_DELREF_P(&stmt->param.vars[j]);
- ZVAL_COPY(&stmt->param.vars[j], Z_REFVAL(stmt->param.vars[j]));
- break;
- }
- }
- }
- }
- for (i = 0; i < stmt->param.var_cnt; i++) {
- if (!Z_ISUNDEF(stmt->param.vars[i])) {
- zval *param;
- if (Z_ISREF(stmt->param.vars[i])) {
- param = Z_REFVAL(stmt->param.vars[i]);
- } else {
- param = &stmt->param.vars[i];
- }
- if (!(stmt->param.is_null[i] = (Z_ISNULL_P(param)))) {
- switch (stmt->stmt->params[i].buffer_type) {
- case MYSQL_TYPE_VAR_STRING:
- if (!try_convert_to_string(param)) {
- RETURN_THROWS();
- }
- stmt->stmt->params[i].buffer = Z_STRVAL_P(param);
- stmt->stmt->params[i].buffer_length = Z_STRLEN_P(param);
- break;
- case MYSQL_TYPE_DOUBLE:
- convert_to_double(param);
- stmt->stmt->params[i].buffer = &Z_DVAL_P(param);
- break;
- case MYSQL_TYPE_LONGLONG:
- case MYSQL_TYPE_LONG:
- convert_to_long(param);
- stmt->stmt->params[i].buffer = &Z_LVAL_P(param);
- break;
- default:
- break;
- }
- }
- }
- }
- #endif
- if (mysql_stmt_execute(stmt->stmt)) {
- MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
- RETVAL_FALSE;
- } else {
- RETVAL_TRUE;
- }
- if (MyG(report_mode) & MYSQLI_REPORT_INDEX) {
- php_mysqli_report_index(stmt->query, mysqli_stmt_server_status(stmt->stmt));
- }
- }
- /* }}} */
- #ifndef MYSQLI_USE_MYSQLND
- /* {{{ void mysqli_stmt_fetch_libmysql
- Fetch results from a prepared statement into the bound variables */
- void mysqli_stmt_fetch_libmysql(INTERNAL_FUNCTION_PARAMETERS)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- unsigned int i;
- zend_ulong ret;
- my_ulonglong llval;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- /* reset buffers */
- for (i = 0; i < stmt->result.var_cnt; i++) {
- if (stmt->result.buf[i].type == IS_STRING) {
- memset(stmt->result.buf[i].val, 0, stmt->result.buf[i].buflen);
- }
- }
- ret = mysql_stmt_fetch(stmt->stmt);
- #ifdef MYSQL_DATA_TRUNCATED
- if (!ret || ret == MYSQL_DATA_TRUNCATED) {
- #else
- if (!ret) {
- #endif
- for (i = 0; i < stmt->result.var_cnt; i++) {
- zval *result;
- /* it must be a reference, isn't it? */
- if (Z_ISREF(stmt->result.vars[i])) {
- result = &stmt->result.vars[i];
- } else {
- continue; // but be safe ...
- }
- /* Even if the string is of length zero there is one byte alloced so efree() in all cases */
- if (!stmt->result.is_null[i]) {
- switch (stmt->result.buf[i].type) {
- case IS_LONG:
- if ((stmt->stmt->fields[i].type == MYSQL_TYPE_LONG)
- && (stmt->stmt->fields[i].flags & UNSIGNED_FLAG))
- {
- /* unsigned int (11) */
- #if SIZEOF_ZEND_LONG == 4
- unsigned int uval = *(unsigned int *) stmt->result.buf[i].val;
- if (uval > INT_MAX) {
- char *tmp, *p;
- int j = 10;
- tmp = emalloc(11);
- p= &tmp[9];
- do {
- *p-- = (uval % 10) + 48;
- uval = uval / 10;
- } while (--j > 0);
- tmp[10]= '\0';
- /* unsigned int > INT_MAX is 10 digits - ALWAYS */
- ZEND_TRY_ASSIGN_REF_STRINGL(result, tmp, 10);
- efree(tmp);
- break;
- }
- #endif
- }
- if (stmt->stmt->fields[i].flags & UNSIGNED_FLAG) {
- ZEND_TRY_ASSIGN_REF_LONG(result, *(unsigned int *)stmt->result.buf[i].val);
- } else {
- ZEND_TRY_ASSIGN_REF_LONG(result, *(int *)stmt->result.buf[i].val);
- }
- break;
- case IS_DOUBLE:
- {
- double dval;
- if (stmt->stmt->bind[i].buffer_type == MYSQL_TYPE_FLOAT) {
- #ifndef NOT_FIXED_DEC
- # define NOT_FIXED_DEC 31
- #endif
- dval = mysql_float_to_double(*(float *)stmt->result.buf[i].val,
- (stmt->stmt->fields[i].decimals >= NOT_FIXED_DEC) ? -1 :
- stmt->stmt->fields[i].decimals);
- } else {
- dval = *((double *)stmt->result.buf[i].val);
- }
- ZEND_TRY_ASSIGN_REF_DOUBLE(result, dval);
- break;
- }
- case IS_STRING:
- if (stmt->stmt->bind[i].buffer_type == MYSQL_TYPE_LONGLONG
- || stmt->stmt->bind[i].buffer_type == MYSQL_TYPE_BIT
- ) {
- my_bool uns = (stmt->stmt->fields[i].flags & UNSIGNED_FLAG)? 1:0;
- if (stmt->stmt->bind[i].buffer_type == MYSQL_TYPE_BIT) {
- switch (stmt->result.buf[i].output_len) {
- case 8:llval = (my_ulonglong) bit_uint8korr(stmt->result.buf[i].val);break;
- case 7:llval = (my_ulonglong) bit_uint7korr(stmt->result.buf[i].val);break;
- case 6:llval = (my_ulonglong) bit_uint6korr(stmt->result.buf[i].val);break;
- case 5:llval = (my_ulonglong) bit_uint5korr(stmt->result.buf[i].val);break;
- case 4:llval = (my_ulonglong) bit_uint4korr(stmt->result.buf[i].val);break;
- case 3:llval = (my_ulonglong) bit_uint3korr(stmt->result.buf[i].val);break;
- case 2:llval = (my_ulonglong) bit_uint2korr(stmt->result.buf[i].val);break;
- case 1:llval = (my_ulonglong) uint1korr(stmt->result.buf[i].val);break;
- }
- } else {
- llval= *(my_ulonglong *) stmt->result.buf[i].val;
- }
- #if SIZEOF_ZEND_LONG==8
- if (uns && llval > 9223372036854775807L) {
- #elif SIZEOF_ZEND_LONG==4
- if ((uns && llval > L64(2147483647)) ||
- (!uns && (( L64(2147483647) < (my_longlong) llval) ||
- (L64(-2147483648) > (my_longlong) llval))))
- {
- #endif
- char tmp[22];
- /* even though lval is declared as unsigned, the value
- * may be negative. Therefore we cannot use MYSQLI_LLU_SPEC and must
- * use MYSQLI_LL_SPEC.
- */
- snprintf(tmp, sizeof(tmp), (stmt->stmt->fields[i].flags & UNSIGNED_FLAG)? MYSQLI_LLU_SPEC : MYSQLI_LL_SPEC, llval);
- ZEND_TRY_ASSIGN_REF_STRING(result, tmp);
- } else {
- ZEND_TRY_ASSIGN_REF_LONG(result, llval);
- }
- } else {
- if (ret == MYSQL_DATA_TRUNCATED && *(stmt->stmt->bind[i].error) != 0) {
- /* result was truncated */
- ZEND_TRY_ASSIGN_REF_STRINGL(result, stmt->result.buf[i].val, stmt->stmt->bind[i].buffer_length);
- } else {
- ZEND_TRY_ASSIGN_REF_STRINGL(result, stmt->result.buf[i].val, stmt->result.buf[i].output_len);
- }
- }
- break;
- default:
- break;
- }
- } else {
- ZEND_TRY_ASSIGN_REF_NULL(result);
- }
- }
- } else {
- MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
- }
- switch (ret) {
- case 0:
- #ifdef MYSQL_DATA_TRUNCATED
- /* according to SQL standard truncation (e.g. loss of precision is
- not an error) - for detecting possible truncation you have to
- check mysqli_stmt_warning
- */
- case MYSQL_DATA_TRUNCATED:
- #endif
- RETURN_TRUE;
- break;
- case 1:
- RETURN_FALSE;
- break;
- default:
- RETURN_NULL();
- break;
- }
- }
- /* }}} */
- #else
- /* {{{ mixed mysqli_stmt_fetch_mysqlnd */
- void mysqli_stmt_fetch_mysqlnd(INTERNAL_FUNCTION_PARAMETERS)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- bool fetched_anything;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- if (FAIL == mysqlnd_stmt_fetch(stmt->stmt, &fetched_anything)) {
- MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
- RETURN_FALSE;
- } else if (fetched_anything) {
- RETURN_TRUE;
- } else {
- RETURN_NULL();
- }
- }
- #endif
- /* }}} */
- /* {{{ Fetch results from a prepared statement into the bound variables */
- PHP_FUNCTION(mysqli_stmt_fetch)
- {
- #ifndef MYSQLI_USE_MYSQLND
- mysqli_stmt_fetch_libmysql(INTERNAL_FUNCTION_PARAM_PASSTHRU);
- #else
- mysqli_stmt_fetch_mysqlnd(INTERNAL_FUNCTION_PARAM_PASSTHRU);
- #endif
- }
- /* }}} */
- /* {{{ php_add_field_properties */
- static void php_add_field_properties(zval *value, const MYSQL_FIELD *field)
- {
- #ifdef MYSQLI_USE_MYSQLND
- add_property_str(value, "name", zend_string_copy(field->sname));
- #else
- add_property_stringl(value, "name",(field->name ? field->name : ""), field->name_length);
- #endif
- add_property_stringl(value, "orgname", (field->org_name ? field->org_name : ""), field->org_name_length);
- add_property_stringl(value, "table", (field->table ? field->table : ""), field->table_length);
- add_property_stringl(value, "orgtable", (field->org_table ? field->org_table : ""), field->org_table_length);
- add_property_stringl(value, "def", (field->def ? field->def : ""), field->def_length);
- add_property_stringl(value, "db", (field->db ? field->db : ""), field->db_length);
- /* FIXME: manually set the catalog to "def" due to bug in
- * libmysqlclient which does not initialize field->catalog
- * and in addition, the catalog is always be "def"
- */
- add_property_string(value, "catalog", "def");
- add_property_long(value, "max_length", 0);
- add_property_long(value, "length", field->length);
- add_property_long(value, "charsetnr", field->charsetnr);
- add_property_long(value, "flags", field->flags);
- add_property_long(value, "type", field->type);
- add_property_long(value, "decimals", field->decimals);
- }
- /* }}} */
- /* {{{ Get column information from a result and return as an object */
- PHP_FUNCTION(mysqli_fetch_field)
- {
- MYSQL_RES *result;
- zval *mysql_result;
- const MYSQL_FIELD *field;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
- if (!(field = mysql_fetch_field(result))) {
- RETURN_FALSE;
- }
- object_init(return_value);
- php_add_field_properties(return_value, field);
- }
- /* }}} */
- /* {{{ Return array of objects containing field meta-data */
- PHP_FUNCTION(mysqli_fetch_fields)
- {
- MYSQL_RES *result;
- zval *mysql_result;
- zval obj;
- unsigned int i, num_fields;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
- array_init(return_value);
- num_fields = mysql_num_fields(result);
- for (i = 0; i < num_fields; i++) {
- const MYSQL_FIELD *field = mysql_fetch_field_direct(result, i);
- object_init(&obj);
- php_add_field_properties(&obj, field);
- add_index_zval(return_value, i, &obj);
- }
- }
- /* }}} */
- /* {{{ Fetch meta-data for a single field */
- PHP_FUNCTION(mysqli_fetch_field_direct)
- {
- MYSQL_RES *result;
- zval *mysql_result;
- const MYSQL_FIELD *field;
- zend_long offset;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Ol", &mysql_result, mysqli_result_class_entry, &offset) == FAILURE) {
- RETURN_THROWS();
- }
- if (offset < 0) {
- zend_argument_value_error(ERROR_ARG_POS(2), "must be greater than or equal to 0");
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
- if (offset >= (zend_long) mysql_num_fields(result)) {
- zend_argument_value_error(ERROR_ARG_POS(2), "must be less than the number of fields for this result set");
- RETURN_THROWS();
- }
- if (!(field = mysql_fetch_field_direct(result,offset))) {
- RETURN_FALSE;
- }
- object_init(return_value);
- php_add_field_properties(return_value, field);
- }
- /* }}} */
- /* {{{ Get the length of each output in a result */
- PHP_FUNCTION(mysqli_fetch_lengths)
- {
- MYSQL_RES *result;
- zval *mysql_result;
- unsigned int i, num_fields;
- #ifdef MYSQLI_USE_MYSQLND
- const size_t *ret;
- #else
- const unsigned long *ret;
- #endif
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
- // TODO Warning?
- if (!(ret = mysql_fetch_lengths(result))) {
- RETURN_FALSE;
- }
- array_init(return_value);
- num_fields = mysql_num_fields(result);
- for (i = 0; i < num_fields; i++) {
- add_index_long(return_value, i, ret[i]);
- }
- }
- /* }}} */
- /* {{{ Get a result row as an enumerated array */
- PHP_FUNCTION(mysqli_fetch_row)
- {
- php_mysqli_fetch_into_hash(INTERNAL_FUNCTION_PARAM_PASSTHRU, MYSQLI_NUM, 0);
- }
- /* }}} */
- /* {{{ Fetch the number of fields returned by the last query for the given link */
- PHP_FUNCTION(mysqli_field_count)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_LONG(mysql_field_count(mysql->mysql));
- }
- /* }}} */
- /* {{{ Set result pointer to a specified field offset */
- PHP_FUNCTION(mysqli_field_seek)
- {
- MYSQL_RES *result;
- zval *mysql_result;
- zend_long fieldnr;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Ol", &mysql_result, mysqli_result_class_entry, &fieldnr) == FAILURE) {
- RETURN_THROWS();
- }
- if (fieldnr < 0) {
- zend_argument_value_error(ERROR_ARG_POS(2), "must be greater than or equal to 0");
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
- if ((uint32_t)fieldnr >= mysql_num_fields(result)) {
- zend_argument_value_error(ERROR_ARG_POS(2), "must be less than the number of fields for this result set");
- RETURN_THROWS();
- }
- mysql_field_seek(result, fieldnr);
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ Get current field offset of result pointer */
- PHP_FUNCTION(mysqli_field_tell)
- {
- MYSQL_RES *result;
- zval *mysql_result;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
- RETURN_LONG(mysql_field_tell(result));
- }
- /* }}} */
- /* {{{ Free query result memory for the given result handle */
- PHP_FUNCTION(mysqli_free_result)
- {
- MYSQL_RES *result;
- zval *mysql_result;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
- mysqli_free_result(result, false);
- MYSQLI_CLEAR_RESOURCE(mysql_result);
- }
- /* }}} */
- /* {{{ Get MySQL client info */
- PHP_FUNCTION(mysqli_get_client_info)
- {
- if (getThis()) {
- if (zend_parse_parameters_none() == FAILURE) {
- RETURN_THROWS();
- }
- } else {
- zval *mysql_link;
- if (zend_parse_parameters(ZEND_NUM_ARGS(), "|O!", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- if (ZEND_NUM_ARGS()) {
- php_error_docref(NULL, E_DEPRECATED, "Passing connection object as an argument is deprecated");
- }
- }
- RETURN_STRING(mysql_get_client_info());
- }
- /* }}} */
- /* {{{ Get MySQL client info */
- PHP_FUNCTION(mysqli_get_client_version)
- {
- if (zend_parse_parameters_none() == FAILURE) {
- RETURN_THROWS();
- }
- RETURN_LONG((zend_long)mysql_get_client_version());
- }
- /* }}} */
- /* {{{ Get MySQL host info */
- PHP_FUNCTION(mysqli_get_host_info)
- {
- MY_MYSQL *mysql;
- zval *mysql_link = NULL;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- #ifndef MYSQLI_USE_MYSQLND
- RETURN_STRING((mysql->mysql->host_info) ? mysql->mysql->host_info : "");
- #else
- RETURN_STRING((mysql->mysql->data->host_info) ? mysql->mysql->data->host_info : "");
- #endif
- }
- /* }}} */
- /* {{{ Get MySQL protocol information */
- PHP_FUNCTION(mysqli_get_proto_info)
- {
- MY_MYSQL *mysql;
- zval *mysql_link = NULL;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_LONG(mysql_get_proto_info(mysql->mysql));
- }
- /* }}} */
- /* {{{ Get MySQL server info */
- PHP_FUNCTION(mysqli_get_server_info)
- {
- MY_MYSQL *mysql;
- zval *mysql_link = NULL;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_STRING(mysql_get_server_info(mysql->mysql));
- }
- /* }}} */
- /* {{{ Return the MySQL version for the server referenced by the given link */
- PHP_FUNCTION(mysqli_get_server_version)
- {
- MY_MYSQL *mysql;
- zval *mysql_link = NULL;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_LONG(mysql_get_server_version(mysql->mysql));
- }
- /* }}} */
- /* {{{ Get information about the most recent query */
- PHP_FUNCTION(mysqli_info)
- {
- MY_MYSQL *mysql;
- zval *mysql_link = NULL;
- const char *info;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- info = mysql_info(mysql->mysql);
- if (info) {
- RETURN_STRING(info);
- }
- }
- /* }}} */
- /* {{{ php_mysqli_init() */
- void php_mysqli_init(INTERNAL_FUNCTION_PARAMETERS, bool is_method)
- {
- MYSQLI_RESOURCE *mysqli_resource;
- MY_MYSQL *mysql;
- if (zend_parse_parameters_none() == FAILURE) {
- RETURN_THROWS();
- }
- if (is_method && (Z_MYSQLI_P(getThis()))->ptr) {
- return;
- }
- mysql = (MY_MYSQL *)ecalloc(1, sizeof(MY_MYSQL));
- #ifndef MYSQLI_USE_MYSQLND
- if (!(mysql->mysql = mysql_init(NULL)))
- #else
- /*
- We create always persistent, as if the user want to connect
- to p:somehost, we can't convert the handle then
- */
- if (!(mysql->mysql = mysqlnd_init(MYSQLND_CLIENT_NO_FLAG, true)))
- #endif
- {
- efree(mysql);
- RETURN_FALSE;
- }
- mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
- mysqli_resource->ptr = (void *)mysql;
- mysqli_resource->status = MYSQLI_STATUS_INITIALIZED;
- if (!is_method) {
- MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_link_class_entry);
- } else {
- (Z_MYSQLI_P(getThis()))->ptr = mysqli_resource;
- }
- }
- /* }}} */
- /* {{{ Initialize mysqli and return a resource for use with mysql_real_connect */
- PHP_FUNCTION(mysqli_init)
- {
- php_mysqli_init(INTERNAL_FUNCTION_PARAM_PASSTHRU, false);
- }
- /* }}} */
- /* {{{ Get the ID generated from the previous INSERT operation */
- PHP_FUNCTION(mysqli_insert_id)
- {
- MY_MYSQL *mysql;
- my_ulonglong rc;
- zval *mysql_link;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- rc = mysql_insert_id(mysql->mysql);
- MYSQLI_RETURN_LONG_INT(rc)
- }
- /* }}} */
- /* {{{ Kill a mysql process on the server */
- PHP_FUNCTION(mysqli_kill)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- zend_long processid;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Ol", &mysql_link, mysqli_link_class_entry, &processid) == FAILURE) {
- RETURN_THROWS();
- }
- if (processid <= 0) {
- zend_argument_value_error(ERROR_ARG_POS(2), "must be greater than 0");
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- if (mysql_kill(mysql->mysql, processid)) {
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- RETURN_FALSE;
- }
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ check if there any more query results from a multi query */
- PHP_FUNCTION(mysqli_more_results)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_BOOL(mysql_more_results(mysql->mysql));
- }
- /* }}} */
- /* {{{ read next result from multi_query */
- PHP_FUNCTION(mysqli_next_result) {
- MY_MYSQL *mysql;
- zval *mysql_link;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- if (mysql_next_result(mysql->mysql)) {
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- RETURN_FALSE;
- }
- RETURN_TRUE;
- }
- /* }}} */
- /* TODO: Make these available without mysqlnd */
- #if defined(MYSQLI_USE_MYSQLND)
- /* {{{ check if there any more query results from a multi query */
- PHP_FUNCTION(mysqli_stmt_more_results)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- RETURN_BOOL(mysqlnd_stmt_more_results(stmt->stmt));
- }
- /* }}} */
- #endif
- /* {{{ read next result from multi_query */
- PHP_FUNCTION(mysqli_stmt_next_result) {
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- if (mysql_stmt_next_result(stmt->stmt)) {
- MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
- RETURN_FALSE;
- }
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ Get number of fields in result */
- PHP_FUNCTION(mysqli_num_fields)
- {
- MYSQL_RES *result;
- zval *mysql_result;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
- RETURN_LONG(mysql_num_fields(result));
- }
- /* }}} */
- /* {{{ Get number of rows in result */
- PHP_FUNCTION(mysqli_num_rows)
- {
- MYSQL_RES *result;
- zval *mysql_result;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_result, mysqli_result_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE(result, MYSQL_RES *, mysql_result, "mysqli_result", MYSQLI_STATUS_VALID);
- if (mysqli_result_is_unbuffered_and_not_everything_is_fetched(result)) {
- zend_throw_error(NULL, "mysqli_num_rows() cannot be used in MYSQLI_USE_RESULT mode");
- RETURN_THROWS();
- }
- MYSQLI_RETURN_LONG_INT(mysql_num_rows(result));
- }
- /* }}} */
- /* {{{ mysqli_options_get_option_zval_type */
- static int mysqli_options_get_option_zval_type(int option)
- {
- switch (option) {
- #ifdef MYSQLI_USE_MYSQLND
- case MYSQLND_OPT_NET_CMD_BUFFER_SIZE:
- case MYSQLND_OPT_NET_READ_BUFFER_SIZE:
- case MYSQLND_OPT_INT_AND_FLOAT_NATIVE:
- #endif /* MYSQLI_USE_MYSQLND */
- case MYSQL_OPT_CONNECT_TIMEOUT:
- #ifdef MYSQL_REPORT_DATA_TRUNCATION
- case MYSQL_REPORT_DATA_TRUNCATION:
- #endif
- case MYSQL_OPT_LOCAL_INFILE:
- case MYSQL_OPT_NAMED_PIPE:
- #ifdef MYSQL_OPT_PROTOCOL
- case MYSQL_OPT_PROTOCOL:
- #endif /* MySQL 4.1.0 */
- case MYSQL_OPT_READ_TIMEOUT:
- case MYSQL_OPT_WRITE_TIMEOUT:
- #ifdef MYSQL_OPT_GUESS_CONNECTION /* removed in MySQL-8.0 */
- case MYSQL_OPT_GUESS_CONNECTION:
- case MYSQL_OPT_USE_EMBEDDED_CONNECTION:
- case MYSQL_OPT_USE_REMOTE_CONNECTION:
- case MYSQL_SECURE_AUTH:
- #endif
- #ifdef MYSQL_OPT_RECONNECT
- case MYSQL_OPT_RECONNECT:
- #endif /* MySQL 5.0.13 */
- #ifdef MYSQL_OPT_SSL_VERIFY_SERVER_CERT
- case MYSQL_OPT_SSL_VERIFY_SERVER_CERT:
- #endif /* MySQL 5.0.23 */
- #ifdef MYSQL_OPT_COMPRESS
- case MYSQL_OPT_COMPRESS:
- #endif /* mysqlnd @ PHP 5.3.2 */
- #if (MYSQL_VERSION_ID >= 50611 && defined(CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS)) || defined(MYSQLI_USE_MYSQLND)
- case MYSQL_OPT_CAN_HANDLE_EXPIRED_PASSWORDS:
- #endif
- return IS_LONG;
- #ifdef MYSQL_SHARED_MEMORY_BASE_NAME
- case MYSQL_SHARED_MEMORY_BASE_NAME:
- #endif /* MySQL 4.1.0 */
- #ifdef MYSQL_SET_CLIENT_IP
- case MYSQL_SET_CLIENT_IP:
- #endif /* MySQL 4.1.1 */
- case MYSQL_READ_DEFAULT_FILE:
- case MYSQL_READ_DEFAULT_GROUP:
- case MYSQL_INIT_COMMAND:
- case MYSQL_SET_CHARSET_NAME:
- case MYSQL_SET_CHARSET_DIR:
- #if MYSQL_VERSION_ID > 50605 || defined(MYSQLI_USE_MYSQLND)
- case MYSQL_SERVER_PUBLIC_KEY:
- #endif
- #if (MYSQL_VERSION_ID >= 80021 && !defined(MARIADB_BASE_VERSION)) || defined(MYSQLI_USE_MYSQLND)
- case MYSQL_OPT_LOAD_DATA_LOCAL_DIR:
- #endif
- return IS_STRING;
- default:
- return IS_NULL;
- }
- }
- /* }}} */
- /* {{{ Set options */
- PHP_FUNCTION(mysqli_options)
- {
- MY_MYSQL *mysql;
- zval *mysql_link = NULL;
- zval *mysql_value;
- zend_long mysql_option;
- unsigned int l_value;
- zend_long ret;
- int expected_type;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Olz", &mysql_link, mysqli_link_class_entry, &mysql_option, &mysql_value) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_INITIALIZED);
- #ifndef MYSQLI_USE_MYSQLND
- if (PG(open_basedir) && PG(open_basedir)[0] != '\0') {
- if(mysql_option == MYSQL_OPT_LOCAL_INFILE) {
- RETURN_FALSE;
- }
- }
- #endif
- expected_type = mysqli_options_get_option_zval_type(mysql_option);
- if (expected_type != Z_TYPE_P(mysql_value)) {
- switch (expected_type) {
- case IS_STRING:
- if (!try_convert_to_string(mysql_value)) {
- RETURN_THROWS();
- }
- break;
- case IS_LONG:
- convert_to_long(mysql_value);
- break;
- default:
- break;
- }
- }
- switch (expected_type) {
- case IS_STRING:
- if ((ret = mysql_options(mysql->mysql, mysql_option, Z_STRVAL_P(mysql_value)))) {
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- }
- break;
- case IS_LONG:
- l_value = Z_LVAL_P(mysql_value);
- if ((ret = mysql_options(mysql->mysql, mysql_option, (char *)&l_value))) {
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- }
- break;
- default:
- ret = 1;
- break;
- }
- RETURN_BOOL(!ret);
- }
- /* }}} */
- /* {{{ Ping a server connection or reconnect if there is no connection */
- PHP_FUNCTION(mysqli_ping)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- zend_long rc;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- rc = mysql_ping(mysql->mysql);
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- RETURN_BOOL(!rc);
- }
- /* }}} */
- /* {{{ Prepare a SQL statement for execution */
- PHP_FUNCTION(mysqli_prepare)
- {
- MY_MYSQL *mysql;
- MY_STMT *stmt;
- char *query = NULL;
- size_t query_len;
- zval *mysql_link;
- MYSQLI_RESOURCE *mysqli_resource;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os",&mysql_link, mysqli_link_class_entry, &query, &query_len) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- #ifndef MYSQLI_USE_MYSQLND
- if (mysql->mysql->status == MYSQL_STATUS_GET_RESULT) {
- php_error_docref(NULL, E_WARNING, "All data must be fetched before a new statement prepare takes place");
- RETURN_FALSE;
- }
- #endif
- stmt = (MY_STMT *)ecalloc(1,sizeof(MY_STMT));
- if ((stmt->stmt = mysql_stmt_init(mysql->mysql))) {
- if (mysql_stmt_prepare(stmt->stmt, query, query_len)) {
- /* mysql_stmt_close() clears errors, so we have to store them temporarily */
- #ifndef MYSQLI_USE_MYSQLND
- char last_error[MYSQL_ERRMSG_SIZE];
- char sqlstate[SQLSTATE_LENGTH+1];
- unsigned int last_errno;
- last_errno = stmt->stmt->last_errno;
- memcpy(last_error, stmt->stmt->last_error, MYSQL_ERRMSG_SIZE);
- memcpy(sqlstate, mysql->mysql->net.sqlstate, SQLSTATE_LENGTH+1);
- #else
- MYSQLND_ERROR_INFO error_info = *mysql->mysql->data->error_info;
- mysql->mysql->data->error_info->error_list.head = NULL;
- mysql->mysql->data->error_info->error_list.tail = NULL;
- mysql->mysql->data->error_info->error_list.count = 0;
- #endif
- mysqli_stmt_close(stmt->stmt, false);
- stmt->stmt = NULL;
- /* restore error messages */
- #ifndef MYSQLI_USE_MYSQLND
- mysql->mysql->net.last_errno = last_errno;
- memcpy(mysql->mysql->net.last_error, last_error, MYSQL_ERRMSG_SIZE);
- memcpy(mysql->mysql->net.sqlstate, sqlstate, SQLSTATE_LENGTH+1);
- #else
- zend_llist_clean(&mysql->mysql->data->error_info->error_list);
- *mysql->mysql->data->error_info = error_info;
- #endif
- }
- }
- /* don't initialize stmt->query with NULL, we ecalloc()-ed the memory */
- /* Get performance boost if reporting is switched off */
- if (stmt->stmt && query_len && (MyG(report_mode) & MYSQLI_REPORT_INDEX)) {
- stmt->query = (char *)emalloc(query_len + 1);
- memcpy(stmt->query, query, query_len);
- stmt->query[query_len] = '\0';
- }
- /* don't join to the previous if because it won't work if mysql_stmt_prepare_fails */
- if (!stmt->stmt) {
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- efree(stmt);
- RETURN_FALSE;
- }
- #ifndef MYSQLI_USE_MYSQLND
- ZVAL_COPY(&stmt->link_handle, mysql_link);
- #endif
- mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
- mysqli_resource->ptr = (void *)stmt;
- /* change status */
- mysqli_resource->status = MYSQLI_STATUS_VALID;
- MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_stmt_class_entry);
- }
- /* }}} */
- /* {{{ Open a connection to a mysql server */
- PHP_FUNCTION(mysqli_real_connect)
- {
- mysqli_common_connect(INTERNAL_FUNCTION_PARAM_PASSTHRU, true, false);
- }
- /* }}} */
- /* {{{ Binary-safe version of mysql_query() */
- PHP_FUNCTION(mysqli_real_query)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- char *query = NULL;
- size_t query_len;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os", &mysql_link, mysqli_link_class_entry, &query, &query_len) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- MYSQLI_DISABLE_MQ; /* disable multi statements/queries */
- if (mysql_real_query(mysql->mysql, query, query_len)) {
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- RETURN_FALSE;
- }
- if (!mysql_field_count(mysql->mysql)) {
- if (MyG(report_mode) & MYSQLI_REPORT_INDEX) {
- php_mysqli_report_index(query, mysqli_server_status(mysql->mysql));
- }
- }
- RETURN_TRUE;
- }
- /* }}} */
- #if defined(MYSQLI_USE_MYSQLND) || MYSQL_VERSION_ID < 50707 || defined(MARIADB_BASE_VERSION)
- # define mysql_real_escape_string_quote(mysql, to, from, length, quote) \
- mysql_real_escape_string(mysql, to, from, length)
- #endif
- PHP_FUNCTION(mysqli_real_escape_string) {
- MY_MYSQL *mysql;
- zval *mysql_link = NULL;
- char *escapestr;
- size_t escapestr_len;
- zend_string *newstr;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os", &mysql_link, mysqli_link_class_entry, &escapestr, &escapestr_len) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- newstr = zend_string_safe_alloc(2, escapestr_len, 0, 0);
- ZSTR_LEN(newstr) = mysql_real_escape_string_quote(mysql->mysql, ZSTR_VAL(newstr), escapestr, escapestr_len, '\'');
- newstr = zend_string_truncate(newstr, ZSTR_LEN(newstr), 0);
- RETURN_NEW_STR(newstr);
- }
- /* {{{ Undo actions from current transaction */
- PHP_FUNCTION(mysqli_rollback)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- zend_long flags = TRANS_COR_NO_OPT;
- char * name = NULL;
- size_t name_len = 0;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O|ls!", &mysql_link, mysqli_link_class_entry, &flags, &name, &name_len) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- #ifndef MYSQLI_USE_MYSQLND
- if (mysqli_commit_or_rollback_libmysql(mysql->mysql, false, flags, name)) {
- #else
- if (FAIL == mysqlnd_rollback(mysql->mysql, flags, name)) {
- #endif
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- RETURN_FALSE;
- }
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ */
- PHP_FUNCTION(mysqli_stmt_send_long_data)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- char *data;
- zend_long param_nr;
- size_t data_len;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Ols", &mysql_stmt, mysqli_stmt_class_entry, ¶m_nr, &data, &data_len) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- if (param_nr < 0) {
- zend_argument_value_error(ERROR_ARG_POS(2), "must be greater than or equal to 0");
- RETURN_THROWS();
- }
- if (mysql_stmt_send_long_data(stmt->stmt, param_nr, data, data_len)) {
- RETURN_FALSE;
- }
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ Return the number of rows affected in the last query for the given link. */
- PHP_FUNCTION(mysqli_stmt_affected_rows)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- my_ulonglong rc;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- rc = mysql_stmt_affected_rows(stmt->stmt);
- if (rc == (my_ulonglong) -1) {
- RETURN_LONG(-1);
- }
- MYSQLI_RETURN_LONG_INT(rc)
- }
- /* }}} */
- /* {{{ Close statement */
- PHP_FUNCTION(mysqli_stmt_close)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- mysqli_stmt_close(stmt->stmt, false);
- stmt->stmt = NULL;
- php_clear_stmt_bind(stmt);
- MYSQLI_CLEAR_RESOURCE(mysql_stmt);
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ Move internal result pointer */
- PHP_FUNCTION(mysqli_stmt_data_seek)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- zend_long offset;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Ol", &mysql_stmt, mysqli_stmt_class_entry, &offset) == FAILURE) {
- RETURN_THROWS();
- }
- if (offset < 0) {
- zend_argument_value_error(ERROR_ARG_POS(2), "must be greater than or equal to 0");
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- mysql_stmt_data_seek(stmt->stmt, offset);
- }
- /* }}} */
- /* {{{ Return the number of result columns for the given statement */
- PHP_FUNCTION(mysqli_stmt_field_count)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- RETURN_LONG(mysql_stmt_field_count(stmt->stmt));
- }
- /* }}} */
- /* {{{ Free stored result memory for the given statement handle */
- PHP_FUNCTION(mysqli_stmt_free_result)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- mysql_stmt_free_result(stmt->stmt);
- }
- /* }}} */
- /* {{{ Get the ID generated from the previous INSERT operation */
- PHP_FUNCTION(mysqli_stmt_insert_id)
- {
- MY_STMT *stmt;
- my_ulonglong rc;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- rc = mysql_stmt_insert_id(stmt->stmt);
- MYSQLI_RETURN_LONG_INT(rc)
- }
- /* }}} */
- /* {{{ Return the number of parameter for the given statement */
- PHP_FUNCTION(mysqli_stmt_param_count)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- RETURN_LONG(mysql_stmt_param_count(stmt->stmt));
- }
- /* }}} */
- /* {{{ reset a prepared statement */
- PHP_FUNCTION(mysqli_stmt_reset)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- if (mysql_stmt_reset(stmt->stmt)) {
- RETURN_FALSE;
- }
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ Return the number of rows in statements result set */
- PHP_FUNCTION(mysqli_stmt_num_rows)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- my_ulonglong rc;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- rc = mysql_stmt_num_rows(stmt->stmt);
- MYSQLI_RETURN_LONG_INT(rc)
- }
- /* }}} */
- /* {{{ Select a MySQL database */
- PHP_FUNCTION(mysqli_select_db)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- char *dbname;
- size_t dbname_len;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os", &mysql_link, mysqli_link_class_entry, &dbname, &dbname_len) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- if (mysql_select_db(mysql->mysql, dbname)) {
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- RETURN_FALSE;
- }
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ Returns the SQLSTATE error from previous MySQL operation */
- PHP_FUNCTION(mysqli_sqlstate)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_STRING(mysql_sqlstate(mysql->mysql));
- }
- /* }}} */
- /* {{{ */
- PHP_FUNCTION(mysqli_ssl_set)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- char *ssl_parm[5];
- size_t ssl_parm_len[5], i;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os!s!s!s!s!", &mysql_link, mysqli_link_class_entry, &ssl_parm[0], &ssl_parm_len[0], &ssl_parm[1], &ssl_parm_len[1], &ssl_parm[2], &ssl_parm_len[2], &ssl_parm[3], &ssl_parm_len[3], &ssl_parm[4], &ssl_parm_len[4]) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_INITIALIZED);
- for (i = 0; i < 5; i++) {
- if (!ssl_parm_len[i]) {
- ssl_parm[i] = NULL;
- }
- }
- mysql_ssl_set(mysql->mysql, ssl_parm[0], ssl_parm[1], ssl_parm[2], ssl_parm[3], ssl_parm[4]);
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ Get current system status */
- PHP_FUNCTION(mysqli_stat)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- #ifdef MYSQLI_USE_MYSQLND
- zend_string *stat;
- #else
- char *stat;
- #endif
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- #ifndef MYSQLI_USE_MYSQLND
- if ((stat = (char *)mysql_stat(mysql->mysql)))
- {
- RETURN_STRING(stat);
- #else
- if (mysqlnd_stat(mysql->mysql, &stat) == PASS)
- {
- RETURN_STR(stat);
- #endif
- } else {
- RETURN_FALSE;
- }
- }
- /* }}} */
- /* {{{ Flush tables or caches, or reset replication server information */
- PHP_FUNCTION(mysqli_refresh)
- {
- MY_MYSQL *mysql;
- zval *mysql_link = NULL;
- zend_long options;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Ol", &mysql_link, mysqli_link_class_entry, &options) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_INITIALIZED);
- #ifdef MYSQLI_USE_MYSQLND
- RETURN_BOOL(!mysql_refresh(mysql->mysql, (uint8_t) options));
- #else
- RETURN_BOOL(!mysql_refresh(mysql->mysql, options));
- #endif
- }
- /* }}} */
- /* {{{ */
- PHP_FUNCTION(mysqli_stmt_attr_set)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- zend_long mode_in;
- my_bool mode_b;
- unsigned long mode;
- zend_long attr;
- void *mode_p;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Oll", &mysql_stmt, mysqli_stmt_class_entry, &attr, &mode_in) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- switch (attr) {
- case STMT_ATTR_UPDATE_MAX_LENGTH:
- if (mode_in != 0 && mode_in != 1) {
- zend_argument_value_error(ERROR_ARG_POS(3), "must be 0 or 1 for attribute MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH");
- RETURN_THROWS();
- }
- mode_b = (my_bool) mode_in;
- mode_p = &mode_b;
- break;
- case STMT_ATTR_CURSOR_TYPE:
- switch (mode_in) {
- case CURSOR_TYPE_NO_CURSOR:
- case CURSOR_TYPE_READ_ONLY:
- case CURSOR_TYPE_FOR_UPDATE:
- case CURSOR_TYPE_SCROLLABLE:
- break;
- default:
- zend_argument_value_error(ERROR_ARG_POS(3), "must be one of the MYSQLI_CURSOR_TYPE_* constants "
- "for attribute MYSQLI_STMT_ATTR_CURSOR_TYPE");
- RETURN_THROWS();
- }
- mode = mode_in;
- mode_p = &mode;
- break;
- case STMT_ATTR_PREFETCH_ROWS:
- if (mode_in < 1) {
- zend_argument_value_error(ERROR_ARG_POS(3), "must be greater than 0 for attribute MYSQLI_STMT_ATTR_PREFETCH_ROWS");
- RETURN_THROWS();
- }
- mode = mode_in;
- mode_p = &mode;
- break;
- default:
- zend_argument_value_error(ERROR_ARG_POS(2), "must be one of "
- "MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH, "
- "MYSQLI_STMT_ATTR_PREFETCH_ROWS, or STMT_ATTR_CURSOR_TYPE");
- RETURN_THROWS();
- }
- // TODO Can unify this?
- #ifndef MYSQLI_USE_MYSQLND
- if (mysql_stmt_attr_set(stmt->stmt, attr, mode_p)) {
- #else
- if (FAIL == mysql_stmt_attr_set(stmt->stmt, attr, mode_p)) {
- #endif
- MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
- RETURN_FALSE;
- }
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ */
- PHP_FUNCTION(mysqli_stmt_attr_get)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- unsigned long value = 0;
- zend_long attr;
- int rc;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Ol", &mysql_stmt, mysqli_stmt_class_entry, &attr) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- if ((rc = mysql_stmt_attr_get(stmt->stmt, attr, &value))) {
- /* Success corresponds to 0 return value and a non-zero value
- * should only happen if the attr/option is unknown */
- zend_argument_value_error(ERROR_ARG_POS(2), "must be one of "
- "MYSQLI_STMT_ATTR_UPDATE_MAX_LENGTH, "
- "MYSQLI_STMT_ATTR_PREFETCH_ROWS, or STMT_ATTR_CURSOR_TYPE");
- RETURN_THROWS();
- }
- if (attr == STMT_ATTR_UPDATE_MAX_LENGTH)
- value = *((my_bool *)&value);
- RETURN_LONG((unsigned long)value);
- }
- /* }}} */
- /* {{{ */
- PHP_FUNCTION(mysqli_stmt_errno)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_INITIALIZED);
- RETURN_LONG(mysql_stmt_errno(stmt->stmt));
- }
- /* }}} */
- /* {{{ */
- PHP_FUNCTION(mysqli_stmt_error)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_INITIALIZED);
- RETURN_STRING(mysql_stmt_error(stmt->stmt));
- }
- /* }}} */
- /* {{{ Initialize statement object */
- PHP_FUNCTION(mysqli_stmt_init)
- {
- MY_MYSQL *mysql;
- MY_STMT *stmt;
- zval *mysql_link;
- MYSQLI_RESOURCE *mysqli_resource;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O",&mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- stmt = (MY_STMT *)ecalloc(1,sizeof(MY_STMT));
- if (!(stmt->stmt = mysql_stmt_init(mysql->mysql))) {
- efree(stmt);
- RETURN_FALSE;
- }
- #ifndef MYSQLI_USE_MYSQLND
- ZVAL_COPY(&stmt->link_handle, mysql_link);
- #endif
- mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
- mysqli_resource->status = MYSQLI_STATUS_INITIALIZED;
- mysqli_resource->ptr = (void *)stmt;
- MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_stmt_class_entry);
- }
- /* }}} */
- /* {{{ prepare server side statement with query */
- PHP_FUNCTION(mysqli_stmt_prepare)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- char *query;
- size_t query_len;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "Os", &mysql_stmt, mysqli_stmt_class_entry, &query, &query_len) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_INITIALIZED);
- if (mysql_stmt_prepare(stmt->stmt, query, query_len)) {
- MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
- RETURN_FALSE;
- }
- /* change status */
- MYSQLI_SET_STATUS(mysql_stmt, MYSQLI_STATUS_VALID);
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ return result set from statement */
- PHP_FUNCTION(mysqli_stmt_result_metadata)
- {
- MY_STMT *stmt;
- MYSQL_RES *result;
- zval *mysql_stmt;
- MYSQLI_RESOURCE *mysqli_resource;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- if (!(result = mysql_stmt_result_metadata(stmt->stmt))){
- MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
- RETURN_FALSE;
- }
- mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
- mysqli_resource->ptr = (void *)result;
- mysqli_resource->status = MYSQLI_STATUS_VALID;
- MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_result_class_entry);
- }
- /* }}} */
- /* {{{ */
- PHP_FUNCTION(mysqli_stmt_store_result)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- #ifndef MYSQLI_USE_MYSQLND
- {
- /*
- If the user wants to store the data and we have BLOBs/TEXTs we try to allocate
- not the maximal length of the type (which is 16MB even for LONGBLOB) but
- the maximal length of the field in the result set. If he/she has quite big
- BLOB/TEXT columns after calling store_result() the memory usage of PHP will
- double - but this is a known problem of the simple MySQL API ;)
- */
- int i = 0;
- for (i = mysql_stmt_field_count(stmt->stmt) - 1; i >=0; --i) {
- if (stmt->stmt->fields && (stmt->stmt->fields[i].type == MYSQL_TYPE_BLOB ||
- stmt->stmt->fields[i].type == MYSQL_TYPE_MEDIUM_BLOB ||
- stmt->stmt->fields[i].type == MYSQL_TYPE_LONG_BLOB ||
- stmt->stmt->fields[i].type == MYSQL_TYPE_GEOMETRY))
- {
- my_bool tmp = 1;
- mysql_stmt_attr_set(stmt->stmt, STMT_ATTR_UPDATE_MAX_LENGTH, &tmp);
- break;
- }
- }
- }
- #endif
- if (mysql_stmt_store_result(stmt->stmt)){
- MYSQLI_REPORT_STMT_ERROR(stmt->stmt);
- RETURN_FALSE;
- }
- RETURN_TRUE;
- }
- /* }}} */
- /* {{{ */
- PHP_FUNCTION(mysqli_stmt_sqlstate)
- {
- MY_STMT *stmt;
- zval *mysql_stmt;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_stmt, mysqli_stmt_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_STMT(stmt, mysql_stmt, MYSQLI_STATUS_VALID);
- RETURN_STRING(mysql_stmt_sqlstate(stmt->stmt));
- }
- /* }}} */
- /* {{{ Buffer result set on client */
- PHP_FUNCTION(mysqli_store_result)
- {
- MY_MYSQL *mysql;
- MYSQL_RES *result;
- zval *mysql_link;
- MYSQLI_RESOURCE *mysqli_resource;
- zend_long flags = 0;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O|l", &mysql_link, mysqli_link_class_entry, &flags) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- result = mysql_store_result(mysql->mysql);
- if (!result) {
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- RETURN_FALSE;
- }
- if (MyG(report_mode) & MYSQLI_REPORT_INDEX) {
- php_mysqli_report_index("from previous query", mysqli_server_status(mysql->mysql));
- }
- mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
- mysqli_resource->ptr = (void *)result;
- mysqli_resource->status = MYSQLI_STATUS_VALID;
- MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_result_class_entry);
- }
- /* }}} */
- /* {{{ Return the current thread ID */
- PHP_FUNCTION(mysqli_thread_id)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_LONG((zend_long) mysql_thread_id(mysql->mysql));
- }
- /* }}} */
- /* {{{ Return whether thread safety is given or not */
- PHP_FUNCTION(mysqli_thread_safe)
- {
- if (zend_parse_parameters_none() == FAILURE) {
- RETURN_THROWS();
- }
- RETURN_BOOL(mysql_thread_safe());
- }
- /* }}} */
- /* {{{ Directly retrieve query results - do not buffer results on client side */
- PHP_FUNCTION(mysqli_use_result)
- {
- MY_MYSQL *mysql;
- MYSQL_RES *result;
- zval *mysql_link;
- MYSQLI_RESOURCE *mysqli_resource;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- if (!(result = mysql_use_result(mysql->mysql))) {
- MYSQLI_REPORT_MYSQL_ERROR(mysql->mysql);
- RETURN_FALSE;
- }
- if (MyG(report_mode) & MYSQLI_REPORT_INDEX) {
- php_mysqli_report_index("from previous query", mysqli_server_status(mysql->mysql));
- }
- mysqli_resource = (MYSQLI_RESOURCE *)ecalloc (1, sizeof(MYSQLI_RESOURCE));
- mysqli_resource->ptr = (void *)result;
- mysqli_resource->status = MYSQLI_STATUS_VALID;
- MYSQLI_RETVAL_RESOURCE(mysqli_resource, mysqli_result_class_entry);
- }
- /* }}} */
- /* {{{ Return number of warnings from the last query for the given link */
- PHP_FUNCTION(mysqli_warning_count)
- {
- MY_MYSQL *mysql;
- zval *mysql_link;
- if (zend_parse_method_parameters(ZEND_NUM_ARGS(), getThis(), "O", &mysql_link, mysqli_link_class_entry) == FAILURE) {
- RETURN_THROWS();
- }
- MYSQLI_FETCH_RESOURCE_CONN(mysql, mysql_link, MYSQLI_STATUS_VALID);
- RETURN_LONG(mysql_warning_count(mysql->mysql));
- }
- /* }}} */
|