Lines Matching refs:result
509 odbc_result *result; in php_odbc_fetch_attribs() local
517 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in php_odbc_fetch_attribs()
522 result->longreadlen = flag; in php_odbc_fetch_attribs()
524 result->binmode = flag; in php_odbc_fetch_attribs()
532 void odbc_bindcols(odbc_result *result) in odbc_bindcols() argument
541 result->values = (odbc_result_value *) safe_emalloc(sizeof(odbc_result_value), result->numcols, 0); in odbc_bindcols()
543 result->longreadlen = ODBCG(defaultlrl); in odbc_bindcols()
544 result->binmode = ODBCG(defaultbinmode); in odbc_bindcols()
546 for(i = 0; i < result->numcols; i++) { in odbc_bindcols()
550 rc = PHP_ODBC_SQLCOLATTRIBUTE(result->stmt, (SQLUSMALLINT)(i+1), PHP_ODBC_SQL_DESC_NAME, in odbc_bindcols()
551 result->values[i].name, sizeof(result->values[i].name), &colnamelen, 0); in odbc_bindcols()
552 result->values[i].coltype = 0; in odbc_bindcols()
553 rc = PHP_ODBC_SQLCOLATTRIBUTE(result->stmt, (SQLUSMALLINT)(i+1), SQL_COLUMN_TYPE, in odbc_bindcols()
554 NULL, 0, NULL, &result->values[i].coltype); in odbc_bindcols()
560 switch(result->values[i].coltype) { in odbc_bindcols()
568 result->values[i].value = NULL; in odbc_bindcols()
573 result->values[i].value = (char *)emalloc(27); in odbc_bindcols()
574 SQLBindCol(result->stmt, (SQLUSMALLINT)(i+1), SQL_C_CHAR, result->values[i].value, in odbc_bindcols()
575 27, &result->values[i].vallen); in odbc_bindcols()
590 rc = PHP_ODBC_SQLCOLATTRIBUTE(result->stmt, (SQLUSMALLINT)(i+1), colfieldid, in odbc_bindcols()
604 …if (SQL_SUCCESS == SQLGetDiagRec(SQL_HANDLE_STMT, result->stmt, 1, state, &err, errtxt, 128, NULL)… in odbc_bindcols()
612 rc = SQLColAttributes(result->stmt, (SQLUSMALLINT)(i+1), SQL_COLUMN_DISPLAY_SIZE, in odbc_bindcols()
620 if (result->values[i].coltype == SQL_WVARCHAR && displaysize == 0) { in odbc_bindcols()
621 result->values[i].coltype = SQL_WLONGVARCHAR; in odbc_bindcols()
622 result->values[i].value = NULL; in odbc_bindcols()
627 if (SQL_VARCHAR == result->values[i].coltype && displaysize == 0) { in odbc_bindcols()
628 result->values[i].coltype = SQL_LONGVARCHAR; in odbc_bindcols()
629 result->values[i].value = NULL; in odbc_bindcols()
634 if (result->values[i].coltype == SQL_TIMESTAMP) { in odbc_bindcols()
642 result->values[i].value = (char *)emalloc(displaysize + 1); in odbc_bindcols()
643 rc = SQLBindCol(result->stmt, (SQLUSMALLINT)(i+1), SQL_C_CHAR, result->values[i].value, in odbc_bindcols()
644 displaysize + 1, &result->values[i].vallen); in odbc_bindcols()
692 odbc_result *result; in odbc_column_lengths() local
711 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in odbc_column_lengths()
720 if (result->numcols == 0) { in odbc_column_lengths()
725 if (pv_num > result->numcols) { in odbc_column_lengths()
730 …PHP_ODBC_SQLCOLATTRIBUTE(result->stmt, (SQLUSMALLINT)pv_num, (SQLUSMALLINT) (type?SQL_COLUMN_SCALE… in odbc_column_lengths()
790 odbc_result *result = NULL; in PHP_FUNCTION() local
806 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
808 result->numparams = 0; in PHP_FUNCTION()
809 result->param_info = NULL; in PHP_FUNCTION()
811 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
813 efree(result); in PHP_FUNCTION()
820 efree(result); in PHP_FUNCTION()
829 if ((result->fetch_abs = (scrollopts & SQL_FD_FETCH_ABSOLUTE))) { in PHP_FUNCTION()
833 SQLSetStmtOption(result->stmt, SQL_CURSOR_TYPE, ODBCG(default_cursortype)); in PHP_FUNCTION()
836 result->fetch_abs = 0; in PHP_FUNCTION()
840 rc = SQLPrepare(result->stmt, (SQLCHAR *) query, SQL_NTS); in PHP_FUNCTION()
845 odbc_sql_error(conn, result->stmt, "SQLPrepare"); in PHP_FUNCTION()
848 odbc_sql_error(conn, result->stmt, "SQLPrepare"); in PHP_FUNCTION()
849 efree(result); in PHP_FUNCTION()
853 SQLNumParams(result->stmt, &(result->numparams)); in PHP_FUNCTION()
854 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
856 if (result->numcols > 0) { in PHP_FUNCTION()
857 odbc_bindcols(result); in PHP_FUNCTION()
859 result->values = NULL; in PHP_FUNCTION()
862 result->conn_ptr = conn; in PHP_FUNCTION()
863 result->fetched = 0; in PHP_FUNCTION()
865 …result->param_info = (odbc_param_info *) safe_emalloc(sizeof(odbc_param_info), result->numparams, … in PHP_FUNCTION()
866 for (i=0;i<result->numparams;i++) { in PHP_FUNCTION()
867 …rc = SQLDescribeParam(result->stmt, (SQLUSMALLINT)(i+1), &result->param_info[i].sqltype, &result->… in PHP_FUNCTION()
868 &result->param_info[i].scale, &result->param_info[i].nullable); in PHP_FUNCTION()
870 odbc_sql_error(result->conn_ptr, result->stmt, "SQLDescribeParameter"); in PHP_FUNCTION()
871 SQLFreeStmt(result->stmt, SQL_RESET_PARAMS); in PHP_FUNCTION()
872 efree(result->param_info); in PHP_FUNCTION()
873 efree(result); in PHP_FUNCTION()
878 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
892 static void odbc_release_params(odbc_result *result, odbc_params_t *params) { in odbc_release_params() argument
893 SQLFreeStmt(result->stmt, SQL_RESET_PARAMS); in odbc_release_params()
894 for (int i = 0; i < result->numparams; i++) { in odbc_release_params()
913 odbc_result *result; in PHP_FUNCTION() local
921 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
925 if (result->numparams > 0) { in PHP_FUNCTION()
926 if ((ne = zend_hash_num_elements(pv_param_ht)) < result->numparams) { in PHP_FUNCTION()
927 …php_error_docref(NULL, E_WARNING, "Not enough parameters (%d should be %d) given", ne, result->num… in PHP_FUNCTION()
931 params = (odbc_params_t *)safe_emalloc(sizeof(odbc_params_t), result->numparams, 0); in PHP_FUNCTION()
932 for(i = 0; i < result->numparams; i++) { in PHP_FUNCTION()
942 odbc_release_params(result, params); in PHP_FUNCTION()
950 if (IS_SQL_BINARY(result->param_info[i-1].sqltype)) { in PHP_FUNCTION()
961 odbc_release_params(result, params); in PHP_FUNCTION()
970 odbc_release_params(result, params); in PHP_FUNCTION()
976 odbc_release_params(result, params); in PHP_FUNCTION()
985 rc = SQLBindParameter(result->stmt, (SQLUSMALLINT)i, SQL_PARAM_INPUT, in PHP_FUNCTION()
986 …ctype, result->param_info[i-1].sqltype, result->param_info[i-1].precision, result->param_info[i-1]… in PHP_FUNCTION()
997 rc = SQLBindParameter(result->stmt, (SQLUSMALLINT)i, SQL_PARAM_INPUT, in PHP_FUNCTION()
998 …ctype, result->param_info[i-1].sqltype, result->param_info[i-1].precision, result->param_info[i-1]… in PHP_FUNCTION()
1003 odbc_sql_error(result->conn_ptr, result->stmt, "SQLBindParameter"); in PHP_FUNCTION()
1004 odbc_release_params(result, params); in PHP_FUNCTION()
1007 if (++i > result->numparams) break; in PHP_FUNCTION()
1011 rc = SQLFreeStmt(result->stmt, SQL_CLOSE); in PHP_FUNCTION()
1014 odbc_sql_error(result->conn_ptr, result->stmt, "SQLFreeStmt"); in PHP_FUNCTION()
1017 result->fetched = 0; in PHP_FUNCTION()
1018 rc = SQLExecute(result->stmt); in PHP_FUNCTION()
1024 rc = SQLParamData(result->stmt, (void*)&fp); in PHP_FUNCTION()
1027 SQLPutData(result->stmt, (void*)&buf, nbytes); in PHP_FUNCTION()
1037 odbc_sql_error(result->conn_ptr, result->stmt, "SQLExecute"); in PHP_FUNCTION()
1040 odbc_sql_error(result->conn_ptr, result->stmt, "SQLExecute"); in PHP_FUNCTION()
1044 if (result->numparams > 0) { in PHP_FUNCTION()
1045 odbc_release_params(result, params); in PHP_FUNCTION()
1052 if (result->numcols == 0) { in PHP_FUNCTION()
1053 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
1055 if (result->numcols > 0) { in PHP_FUNCTION()
1056 odbc_bindcols(result); in PHP_FUNCTION()
1058 result->values = NULL; in PHP_FUNCTION()
1071 odbc_result *result; in PHP_FUNCTION() local
1078 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
1082 …rc = SQLGetInfo(result->conn_ptr->hdbc,SQL_MAX_CURSOR_NAME_LEN, (void *)&max_len,sizeof(max_len),&… in PHP_FUNCTION()
1089 rc = SQLGetCursorName(result->stmt, (SQLCHAR *) cursorname, (SQLSMALLINT)max_len, &len); in PHP_FUNCTION()
1096 SQLError( result->conn_ptr->henv, result->conn_ptr->hdbc, in PHP_FUNCTION()
1097 result->stmt, (SQLCHAR *) state, &error, (SQLCHAR *) errormsg, in PHP_FUNCTION()
1100 snprintf(cursorname, max_len+1, "php_curs_" ZEND_ULONG_FMT, (zend_ulong)result->stmt); in PHP_FUNCTION()
1101 if (SQLSetCursorName(result->stmt, (SQLCHAR *) cursorname, SQL_NTS) != SQL_SUCCESS) { in PHP_FUNCTION()
1102 odbc_sql_error(result->conn_ptr, result->stmt, "SQLSetCursorName"); in PHP_FUNCTION()
1188 odbc_result *result = NULL; in PHP_FUNCTION() local
1203 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
1205 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
1208 efree(result); in PHP_FUNCTION()
1214 efree(result); in PHP_FUNCTION()
1223 if ((result->fetch_abs = (scrollopts & SQL_FD_FETCH_ABSOLUTE))) { in PHP_FUNCTION()
1227 SQLSetStmtOption(result->stmt, SQL_CURSOR_TYPE, ODBCG(default_cursortype)); in PHP_FUNCTION()
1230 result->fetch_abs = 0; in PHP_FUNCTION()
1234 rc = SQLExecDirect(result->stmt, (SQLCHAR *) query, SQL_NTS); in PHP_FUNCTION()
1239 odbc_sql_error(conn, result->stmt, "SQLExecDirect"); in PHP_FUNCTION()
1240 SQLFreeStmt(result->stmt, SQL_DROP); in PHP_FUNCTION()
1241 efree(result); in PHP_FUNCTION()
1245 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
1248 if (result->numcols > 0) { in PHP_FUNCTION()
1249 odbc_bindcols(result); in PHP_FUNCTION()
1251 result->values = NULL; in PHP_FUNCTION()
1254 result->conn_ptr = conn; in PHP_FUNCTION()
1255 result->fetched = 0; in PHP_FUNCTION()
1256 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
1268 odbc_result *result; in php_odbc_fetch_hash() local
1284 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in php_odbc_fetch_hash()
1296 if (result->numcols == 0) { in php_odbc_fetch_hash()
1302 if (result->fetch_abs) { in php_odbc_fetch_hash()
1304 rc = SQLExtendedFetch(result->stmt,SQL_FETCH_ABSOLUTE,(SQLLEN)pv_row,&crow,RowStatus); in php_odbc_fetch_hash()
1306 rc = SQLExtendedFetch(result->stmt,SQL_FETCH_NEXT,1,&crow,RowStatus); in php_odbc_fetch_hash()
1310 rc = SQLFetch(result->stmt); in php_odbc_fetch_hash()
1319 if (!pv_row_is_null && pv_row > 0 && result->fetch_abs) in php_odbc_fetch_hash()
1320 result->fetched = (SQLLEN)pv_row; in php_odbc_fetch_hash()
1323 result->fetched++; in php_odbc_fetch_hash()
1325 for(i = 0; i < result->numcols; i++) { in php_odbc_fetch_hash()
1328 switch(result->values[i].coltype) { in php_odbc_fetch_hash()
1332 if (result->binmode <= 0) { in php_odbc_fetch_hash()
1336 if (result->binmode == 1) { in php_odbc_fetch_hash()
1344 if (IS_SQL_LONG(result->values[i].coltype) && result->longreadlen <= 0) { in php_odbc_fetch_hash()
1349 buf = emalloc(result->longreadlen + 1); in php_odbc_fetch_hash()
1352 …rc = SQLGetData(result->stmt, (SQLUSMALLINT)(i + 1), sql_c_type, buf, result->longreadlen + 1, &re… in php_odbc_fetch_hash()
1355 odbc_sql_error(result->conn_ptr, result->stmt, "SQLGetData"); in php_odbc_fetch_hash()
1361 ZVAL_STRINGL(&tmp, buf, result->longreadlen); in php_odbc_fetch_hash()
1365 } else if (result->values[i].vallen == SQL_NULL_DATA) { in php_odbc_fetch_hash()
1368 } else if (result->values[i].vallen == SQL_NO_TOTAL) { in php_odbc_fetch_hash()
1372 ZVAL_STRINGL(&tmp, buf, result->values[i].vallen); in php_odbc_fetch_hash()
1377 if (result->values[i].vallen == SQL_NULL_DATA) { in php_odbc_fetch_hash()
1380 } else if (result->values[i].vallen == SQL_NO_TOTAL) { in php_odbc_fetch_hash()
1385 ZVAL_STRINGL(&tmp, result->values[i].value, result->values[i].vallen); in php_odbc_fetch_hash()
1392 if (!*(result->values[i].name) && Z_TYPE(tmp) == IS_STRING) { in php_odbc_fetch_hash()
1395 …zend_hash_str_update(Z_ARRVAL_P(return_value), result->values[i].name, strlen(result->values[i].na… in php_odbc_fetch_hash()
1428 odbc_result *result; in PHP_FUNCTION() local
1444 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
1456 if (result->numcols == 0) { in PHP_FUNCTION()
1467 if (result->fetch_abs) { in PHP_FUNCTION()
1469 rc = SQLExtendedFetch(result->stmt,SQL_FETCH_ABSOLUTE,(SQLLEN)pv_row,&crow,RowStatus); in PHP_FUNCTION()
1471 rc = SQLExtendedFetch(result->stmt,SQL_FETCH_NEXT,1,&crow,RowStatus); in PHP_FUNCTION()
1475 rc = SQLFetch(result->stmt); in PHP_FUNCTION()
1482 if (!pv_row_is_null && pv_row > 0 && result->fetch_abs) in PHP_FUNCTION()
1483 result->fetched = (SQLLEN)pv_row; in PHP_FUNCTION()
1486 result->fetched++; in PHP_FUNCTION()
1488 for(i = 0; i < result->numcols; i++) { in PHP_FUNCTION()
1491 switch(result->values[i].coltype) { in PHP_FUNCTION()
1495 if (result->binmode <= 0) { in PHP_FUNCTION()
1499 if (result->binmode == 1) sql_c_type = SQL_C_BINARY; in PHP_FUNCTION()
1507 if (IS_SQL_LONG(result->values[i].coltype) && result->longreadlen <= 0) { in PHP_FUNCTION()
1513 buf = emalloc(result->longreadlen + 1); in PHP_FUNCTION()
1515 …rc = SQLGetData(result->stmt, (SQLUSMALLINT)(i + 1),sql_c_type, buf, result->longreadlen + 1, &res… in PHP_FUNCTION()
1518 odbc_sql_error(result->conn_ptr, result->stmt, "SQLGetData"); in PHP_FUNCTION()
1523 ZVAL_STRINGL(&tmp, buf, result->longreadlen); in PHP_FUNCTION()
1527 } else if (result->values[i].vallen == SQL_NULL_DATA) { in PHP_FUNCTION()
1530 } else if (result->values[i].vallen == SQL_NO_TOTAL) { in PHP_FUNCTION()
1534 ZVAL_STRINGL(&tmp, buf, result->values[i].vallen); in PHP_FUNCTION()
1539 if (result->values[i].vallen == SQL_NULL_DATA) { in PHP_FUNCTION()
1542 } else if (result->values[i].vallen == SQL_NO_TOTAL) { in PHP_FUNCTION()
1547 ZVAL_STRINGL(&tmp, result->values[i].value, result->values[i].vallen); in PHP_FUNCTION()
1553 RETURN_LONG(result->numcols); in PHP_FUNCTION()
1560 odbc_result *result; in PHP_FUNCTION() local
1574 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
1589 if (result->numcols == 0) { in PHP_FUNCTION()
1595 if (result->fetch_abs) { in PHP_FUNCTION()
1597 rc = SQLExtendedFetch(result->stmt,SQL_FETCH_ABSOLUTE,(SQLLEN)pv_row,&crow,RowStatus); in PHP_FUNCTION()
1599 rc = SQLExtendedFetch(result->stmt,SQL_FETCH_NEXT,1,&crow,RowStatus); in PHP_FUNCTION()
1603 rc = SQLFetch(result->stmt); in PHP_FUNCTION()
1610 result->fetched = (SQLLEN)pv_row; in PHP_FUNCTION()
1613 result->fetched++; in PHP_FUNCTION()
1627 odbc_result *result; in PHP_FUNCTION() local
1650 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
1654 if (result->numcols == 0) { in PHP_FUNCTION()
1661 if (result->values == NULL) { in PHP_FUNCTION()
1666 for(i = 0; i < result->numcols; i++) { in PHP_FUNCTION()
1667 if (!strcasecmp(result->values[i].name, field)) { in PHP_FUNCTION()
1679 if (field_ind >= result->numcols || field_ind < 0) { in PHP_FUNCTION()
1685 if (result->fetched == 0) { in PHP_FUNCTION()
1688 if (result->fetch_abs) in PHP_FUNCTION()
1689 rc = SQLExtendedFetch(result->stmt, SQL_FETCH_NEXT, 1, &crow,RowStatus); in PHP_FUNCTION()
1692 rc = SQLFetch(result->stmt); in PHP_FUNCTION()
1698 result->fetched++; in PHP_FUNCTION()
1701 switch(result->values[field_ind].coltype) { in PHP_FUNCTION()
1705 if (result->binmode <= 1) { in PHP_FUNCTION()
1708 if (result->binmode <= 0) { in PHP_FUNCTION()
1718 if (IS_SQL_LONG(result->values[field_ind].coltype)) { in PHP_FUNCTION()
1719 if (result->longreadlen <= 0) { in PHP_FUNCTION()
1722 fieldsize = result->longreadlen; in PHP_FUNCTION()
1725 PHP_ODBC_SQLCOLATTRIBUTE(result->stmt, (SQLUSMALLINT)(field_ind + 1), in PHP_FUNCTION()
1731 fieldsize = (result->longreadlen <= 0) ? 4096 : result->longreadlen; in PHP_FUNCTION()
1737 rc = SQLGetData(result->stmt, (SQLUSMALLINT)(field_ind + 1), sql_c_type, in PHP_FUNCTION()
1738 ZSTR_VAL(field_str), fieldsize, &result->values[field_ind].vallen); in PHP_FUNCTION()
1741 odbc_sql_error(result->conn_ptr, result->stmt, "SQLGetData"); in PHP_FUNCTION()
1750 } else if (result->values[field_ind].vallen == SQL_NULL_DATA) { in PHP_FUNCTION()
1753 } else if (result->values[field_ind].vallen == SQL_NO_TOTAL) { in PHP_FUNCTION()
1760 if ((result->values[field_ind].coltype == SQL_LONGVARCHAR) in PHP_FUNCTION()
1762 || (result->values[field_ind].coltype == SQL_WLONGVARCHAR) in PHP_FUNCTION()
1771 field_str = zend_string_truncate(field_str, result->values[field_ind].vallen, 0); in PHP_FUNCTION()
1778 if (result->values[field_ind].vallen == SQL_NULL_DATA) { in PHP_FUNCTION()
1780 } else if (result->values[field_ind].vallen == SQL_NO_TOTAL) { in PHP_FUNCTION()
1784 RETURN_STRINGL(result->values[field_ind].value, result->values[field_ind].vallen); in PHP_FUNCTION()
1797 …rc = SQLGetData(result->stmt, (SQLUSMALLINT)(field_ind + 1),sql_c_type, field, fieldsize, &result-… in PHP_FUNCTION()
1800 odbc_sql_error(result->conn_ptr, result->stmt, "SQLGetData"); in PHP_FUNCTION()
1811 if (result->values[field_ind].vallen == SQL_NULL_DATA) { in PHP_FUNCTION()
1814 } else if (result->values[field_ind].vallen == SQL_NO_TOTAL) { in PHP_FUNCTION()
1820 PHPWRITE(field,(rc == SQL_SUCCESS_WITH_INFO) ? 4095 : result->values[field_ind].vallen); in PHP_FUNCTION()
1835 odbc_result *result; in PHP_FUNCTION() local
1850 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
1854 if (result->numcols == 0) { in PHP_FUNCTION()
1859 if (result->fetch_abs) in PHP_FUNCTION()
1860 rc = SQLExtendedFetch(result->stmt,SQL_FETCH_NEXT,1,&crow,RowStatus); in PHP_FUNCTION()
1863 rc = SQLFetch(result->stmt); in PHP_FUNCTION()
1877 for (i = 0; i < result->numcols; i++) { in PHP_FUNCTION()
1878 php_printf("<th>%s</th>", result->values[i].name); in PHP_FUNCTION()
1884 result->fetched++; in PHP_FUNCTION()
1886 for(i = 0; i < result->numcols; i++) { in PHP_FUNCTION()
1888 switch(result->values[i].coltype) { in PHP_FUNCTION()
1892 if (result->binmode <= 0) { in PHP_FUNCTION()
1896 if (result->binmode <= 1) sql_c_type = SQL_C_BINARY; in PHP_FUNCTION()
1904 if (IS_SQL_LONG(result->values[i].coltype) && in PHP_FUNCTION()
1905 result->longreadlen <= 0) { in PHP_FUNCTION()
1911 buf = emalloc(result->longreadlen); in PHP_FUNCTION()
1914 …rc = SQLGetData(result->stmt, (SQLUSMALLINT)(i + 1),sql_c_type, buf, result->longreadlen, &result-… in PHP_FUNCTION()
1919 odbc_sql_error(result->conn_ptr, result->stmt, "SQLGetData"); in PHP_FUNCTION()
1925 if (result->values[i].vallen == SQL_NO_TOTAL) { in PHP_FUNCTION()
1931 PHPWRITE(buf, result->longreadlen); in PHP_FUNCTION()
1938 } else if (result->values[i].vallen == SQL_NULL_DATA) { in PHP_FUNCTION()
1942 PHPWRITE(buf, result->values[i].vallen); in PHP_FUNCTION()
1947 if (result->values[i].vallen == SQL_NULL_DATA) { in PHP_FUNCTION()
1949 } else if (result->values[i].vallen == SQL_NO_TOTAL) { in PHP_FUNCTION()
1953 php_printf("<td>%s</td>", result->values[i].value); in PHP_FUNCTION()
1961 if (result->fetch_abs) in PHP_FUNCTION()
1962 rc = SQLExtendedFetch(result->stmt,SQL_FETCH_NEXT,1,&crow,RowStatus); in PHP_FUNCTION()
1965 rc = SQLFetch(result->stmt); in PHP_FUNCTION()
1969 RETURN_LONG(result->fetched); in PHP_FUNCTION()
1977 odbc_result *result; in PHP_FUNCTION() local
1984 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
1988 if (result->values) { in PHP_FUNCTION()
1989 for (i = 0; i < result->numcols; i++) { in PHP_FUNCTION()
1990 if (result->values[i].value) { in PHP_FUNCTION()
1991 efree(result->values[i].value); in PHP_FUNCTION()
1994 efree(result->values); in PHP_FUNCTION()
1995 result->values = NULL; in PHP_FUNCTION()
2335 odbc_result *result; in PHP_FUNCTION() local
2343 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
2347 SQLRowCount(result->stmt, &rows); in PHP_FUNCTION()
2356 odbc_result *result; in PHP_FUNCTION() local
2364 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
2368 if (result->values) { in PHP_FUNCTION()
2369 for(i = 0; i < result->numcols; i++) { in PHP_FUNCTION()
2370 if (result->values[i].value) { in PHP_FUNCTION()
2371 efree(result->values[i].value); in PHP_FUNCTION()
2374 efree(result->values); in PHP_FUNCTION()
2375 result->values = NULL; in PHP_FUNCTION()
2376 result->numcols = 0; in PHP_FUNCTION()
2379 result->fetched = 0; in PHP_FUNCTION()
2380 rc = SQLMoreResults(result->stmt); in PHP_FUNCTION()
2382 rc = SQLFreeStmt(result->stmt, SQL_UNBIND); in PHP_FUNCTION()
2383 SQLNumParams(result->stmt, &(result->numparams)); in PHP_FUNCTION()
2384 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
2386 if (result->numcols > 0) { in PHP_FUNCTION()
2387 odbc_bindcols(result); in PHP_FUNCTION()
2389 result->values = NULL; in PHP_FUNCTION()
2395 odbc_sql_error(result->conn_ptr, result->stmt, "SQLMoreResults"); in PHP_FUNCTION()
2405 odbc_result *result; in PHP_FUNCTION() local
2412 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
2416 RETURN_LONG(result->numcols); in PHP_FUNCTION()
2423 odbc_result *result; in PHP_FUNCTION() local
2431 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
2440 if (result->numcols == 0) { in PHP_FUNCTION()
2445 if (pv_num > result->numcols) { in PHP_FUNCTION()
2450 RETURN_STRING(result->values[pv_num - 1].name); in PHP_FUNCTION()
2457 odbc_result *result; in PHP_FUNCTION() local
2467 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
2476 if (result->numcols == 0) { in PHP_FUNCTION()
2481 if (pv_num > result->numcols) { in PHP_FUNCTION()
2486 …PHP_ODBC_SQLCOLATTRIBUTE(result->stmt, (SQLUSMALLINT)pv_num, SQL_COLUMN_TYPE_NAME, tmp, 31, &tmple… in PHP_FUNCTION()
2510 odbc_result *result; in PHP_FUNCTION() local
2517 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_res), "ODBC result", le_result)) == NU… in PHP_FUNCTION()
2521 if (result->numcols == 0) { in PHP_FUNCTION()
2527 for(i = 0; i < result->numcols; i++) { in PHP_FUNCTION()
2528 if (strcasecmp(result->values[i].name, fname) == 0) { in PHP_FUNCTION()
2648 odbc_result *result; in PHP_FUNCTION() local
2674 …if ((result = (odbc_result *)zend_fetch_resource(Z_RES_P(pv_handle), "ODBC result", le_result)) ==… in PHP_FUNCTION()
2678 rc = SQLSetStmtOption(result->stmt, (unsigned short) pv_opt, pv_val); in PHP_FUNCTION()
2681 odbc_sql_error(result->conn_ptr, result->stmt, "SetStmtOption"); in PHP_FUNCTION()
2702 odbc_result *result = NULL; in PHP_FUNCTION() local
2717 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
2719 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
2721 efree(result); in PHP_FUNCTION()
2728 efree(result); in PHP_FUNCTION()
2737 rc = SQLTables(result->stmt, in PHP_FUNCTION()
2744 odbc_sql_error(conn, result->stmt, "SQLTables"); in PHP_FUNCTION()
2745 efree(result); in PHP_FUNCTION()
2749 result->numparams = 0; in PHP_FUNCTION()
2750 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
2752 if (result->numcols > 0) { in PHP_FUNCTION()
2753 odbc_bindcols(result); in PHP_FUNCTION()
2755 result->values = NULL; in PHP_FUNCTION()
2757 result->conn_ptr = conn; in PHP_FUNCTION()
2758 result->fetched = 0; in PHP_FUNCTION()
2759 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
2767 odbc_result *result = NULL; in PHP_FUNCTION() local
2782 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
2784 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
2786 efree(result); in PHP_FUNCTION()
2793 efree(result); in PHP_FUNCTION()
2804 rc = SQLColumns(result->stmt, in PHP_FUNCTION()
2811 odbc_sql_error(conn, result->stmt, "SQLColumns"); in PHP_FUNCTION()
2812 efree(result); in PHP_FUNCTION()
2816 result->numparams = 0; in PHP_FUNCTION()
2817 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
2819 if (result->numcols > 0) { in PHP_FUNCTION()
2820 odbc_bindcols(result); in PHP_FUNCTION()
2822 result->values = NULL; in PHP_FUNCTION()
2824 result->conn_ptr = conn; in PHP_FUNCTION()
2825 result->fetched = 0; in PHP_FUNCTION()
2826 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
2835 odbc_result *result = NULL; in PHP_FUNCTION() local
2850 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
2852 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
2854 efree(result); in PHP_FUNCTION()
2861 efree(result); in PHP_FUNCTION()
2865 rc = SQLColumnPrivileges(result->stmt, in PHP_FUNCTION()
2872 odbc_sql_error(conn, result->stmt, "SQLColumnPrivileges"); in PHP_FUNCTION()
2873 efree(result); in PHP_FUNCTION()
2877 result->numparams = 0; in PHP_FUNCTION()
2878 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
2880 if (result->numcols > 0) { in PHP_FUNCTION()
2881 odbc_bindcols(result); in PHP_FUNCTION()
2883 result->values = NULL; in PHP_FUNCTION()
2885 result->conn_ptr = conn; in PHP_FUNCTION()
2886 result->fetched = 0; in PHP_FUNCTION()
2887 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
2897 odbc_result *result = NULL; in PHP_FUNCTION() local
2924 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
2926 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
2928 efree(result); in PHP_FUNCTION()
2935 efree(result); in PHP_FUNCTION()
2939 rc = SQLForeignKeys(result->stmt, in PHP_FUNCTION()
2948 odbc_sql_error(conn, result->stmt, "SQLForeignKeys"); in PHP_FUNCTION()
2949 efree(result); in PHP_FUNCTION()
2953 result->numparams = 0; in PHP_FUNCTION()
2954 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
2956 if (result->numcols > 0) { in PHP_FUNCTION()
2957 odbc_bindcols(result); in PHP_FUNCTION()
2959 result->values = NULL; in PHP_FUNCTION()
2961 result->conn_ptr = conn; in PHP_FUNCTION()
2962 result->fetched = 0; in PHP_FUNCTION()
2963 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
2973 odbc_result *result = NULL; in PHP_FUNCTION() local
2988 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
2990 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
2992 efree(result); in PHP_FUNCTION()
2999 efree(result); in PHP_FUNCTION()
3003 rc = SQLGetTypeInfo(result->stmt, data_type ); in PHP_FUNCTION()
3006 odbc_sql_error(conn, result->stmt, "SQLGetTypeInfo"); in PHP_FUNCTION()
3007 efree(result); in PHP_FUNCTION()
3011 result->numparams = 0; in PHP_FUNCTION()
3012 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
3014 if (result->numcols > 0) { in PHP_FUNCTION()
3015 odbc_bindcols(result); in PHP_FUNCTION()
3017 result->values = NULL; in PHP_FUNCTION()
3019 result->conn_ptr = conn; in PHP_FUNCTION()
3020 result->fetched = 0; in PHP_FUNCTION()
3021 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
3029 odbc_result *result = NULL; in PHP_FUNCTION() local
3043 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
3045 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
3047 efree(result); in PHP_FUNCTION()
3054 efree(result); in PHP_FUNCTION()
3058 rc = SQLPrimaryKeys(result->stmt, in PHP_FUNCTION()
3064 odbc_sql_error(conn, result->stmt, "SQLPrimaryKeys"); in PHP_FUNCTION()
3065 efree(result); in PHP_FUNCTION()
3069 result->numparams = 0; in PHP_FUNCTION()
3070 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
3072 if (result->numcols > 0) { in PHP_FUNCTION()
3073 odbc_bindcols(result); in PHP_FUNCTION()
3075 result->values = NULL; in PHP_FUNCTION()
3077 result->conn_ptr = conn; in PHP_FUNCTION()
3078 result->fetched = 0; in PHP_FUNCTION()
3079 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
3088 odbc_result *result = NULL; in PHP_FUNCTION() local
3103 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
3105 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
3107 efree(result); in PHP_FUNCTION()
3114 efree(result); in PHP_FUNCTION()
3118 rc = SQLProcedureColumns(result->stmt, in PHP_FUNCTION()
3125 odbc_sql_error(conn, result->stmt, "SQLProcedureColumns"); in PHP_FUNCTION()
3126 efree(result); in PHP_FUNCTION()
3130 result->numparams = 0; in PHP_FUNCTION()
3131 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
3133 if (result->numcols > 0) { in PHP_FUNCTION()
3134 odbc_bindcols(result); in PHP_FUNCTION()
3136 result->values = NULL; in PHP_FUNCTION()
3138 result->conn_ptr = conn; in PHP_FUNCTION()
3139 result->fetched = 0; in PHP_FUNCTION()
3140 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
3150 odbc_result *result = NULL; in PHP_FUNCTION() local
3164 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
3166 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
3168 efree(result); in PHP_FUNCTION()
3175 efree(result); in PHP_FUNCTION()
3179 rc = SQLProcedures(result->stmt, in PHP_FUNCTION()
3185 odbc_sql_error(conn, result->stmt, "SQLProcedures"); in PHP_FUNCTION()
3186 efree(result); in PHP_FUNCTION()
3190 result->numparams = 0; in PHP_FUNCTION()
3191 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
3193 if (result->numcols > 0) { in PHP_FUNCTION()
3194 odbc_bindcols(result); in PHP_FUNCTION()
3196 result->values = NULL; in PHP_FUNCTION()
3198 result->conn_ptr = conn; in PHP_FUNCTION()
3199 result->fetched = 0; in PHP_FUNCTION()
3200 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
3210 odbc_result *result = NULL; in PHP_FUNCTION() local
3230 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
3232 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
3234 efree(result); in PHP_FUNCTION()
3241 efree(result); in PHP_FUNCTION()
3245 rc = SQLSpecialColumns(result->stmt, type, in PHP_FUNCTION()
3253 odbc_sql_error(conn, result->stmt, "SQLSpecialColumns"); in PHP_FUNCTION()
3254 efree(result); in PHP_FUNCTION()
3258 result->numparams = 0; in PHP_FUNCTION()
3259 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
3261 if (result->numcols > 0) { in PHP_FUNCTION()
3262 odbc_bindcols(result); in PHP_FUNCTION()
3264 result->values = NULL; in PHP_FUNCTION()
3266 result->conn_ptr = conn; in PHP_FUNCTION()
3267 result->fetched = 0; in PHP_FUNCTION()
3268 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
3277 odbc_result *result = NULL; in PHP_FUNCTION() local
3296 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
3298 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
3300 efree(result); in PHP_FUNCTION()
3307 efree(result); in PHP_FUNCTION()
3311 rc = SQLStatistics(result->stmt, in PHP_FUNCTION()
3319 odbc_sql_error(conn, result->stmt, "SQLStatistics"); in PHP_FUNCTION()
3320 efree(result); in PHP_FUNCTION()
3324 result->numparams = 0; in PHP_FUNCTION()
3325 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
3327 if (result->numcols > 0) { in PHP_FUNCTION()
3328 odbc_bindcols(result); in PHP_FUNCTION()
3330 result->values = NULL; in PHP_FUNCTION()
3332 result->conn_ptr = conn; in PHP_FUNCTION()
3333 result->fetched = 0; in PHP_FUNCTION()
3334 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
3343 odbc_result *result = NULL; in PHP_FUNCTION() local
3357 result = (odbc_result *)ecalloc(1, sizeof(odbc_result)); in PHP_FUNCTION()
3359 rc = PHP_ODBC_SQLALLOCSTMT(conn->hdbc, &(result->stmt)); in PHP_FUNCTION()
3361 efree(result); in PHP_FUNCTION()
3368 efree(result); in PHP_FUNCTION()
3372 rc = SQLTablePrivileges(result->stmt, in PHP_FUNCTION()
3378 odbc_sql_error(conn, result->stmt, "SQLTablePrivileges"); in PHP_FUNCTION()
3379 efree(result); in PHP_FUNCTION()
3383 result->numparams = 0; in PHP_FUNCTION()
3384 SQLNumResultCols(result->stmt, &(result->numcols)); in PHP_FUNCTION()
3386 if (result->numcols > 0) { in PHP_FUNCTION()
3387 odbc_bindcols(result); in PHP_FUNCTION()
3389 result->values = NULL; in PHP_FUNCTION()
3391 result->conn_ptr = conn; in PHP_FUNCTION()
3392 result->fetched = 0; in PHP_FUNCTION()
3393 RETURN_RES(zend_register_resource(result, le_result)); in PHP_FUNCTION()
