dbx 函数

dbx_close — Close an open connection/database
dbx_compare — Compare two rows for sorting purposes
dbx_connect — Open a connection/database
dbx_error — Report the error message of the latest function call in the module
dbx_escape_string — Escape a string so it can safely be used in an sql-statement
dbx_fetch_row — Fetches rows from a query-result that had the DBX_RESULT_UNBUFFERED flag set
dbx_query — Send a query and fetch all results (if any)
dbx_sort — Sort a result from a dbx_query by a custom sort function

add a note

User Contributed Notes 5 notes

down

carl [at] carlthompson [dot] net ¶

15 years ago


The above benchmark is very misleading. Unfortunately, I found out the hard way by porting my app to ADODB. Most PHP apps are going to be very short-lived therefore startup / setup time is a large factor. This benchmark does not measure that. Just include()ing the main ADODB file added 27ms to my app's startup time! Considering my app took only 16ms to run in total using DBX, the idea of switching to ADODB was DOA before running a single query.

In the end, the total time for my app went from 16ms with DBX to 49ms with ADODB. ADODB's powerful features are obviously not worth that kind of overhead.

Carl Thompson

down

bart at mediawave dot nl ¶

14 years ago


Simple function for returning paged result sets.



<?php 

// use: pagedQuery($link, $sql, $rows_per_page, $current_page)



function pagedQuery($link, $sql, $nrows = 10, $page = 1) {

    $handle = dbx_query($link, $sql, DBX_RESULT_UNBUFFERED);

    $result = new stdClass;

    $result->link = $this->link;

    $result->page = $page;

    $result->data = array();

    $result->info['name'] = array();

    $start = ($page - 1) * $nrows;

    $end = $start + $nrows;

    $result->rows = 0;

    while ($row = dbx_fetch_row($handle)) {

        $result->rows++;

        if (($result->rows > $start) && ($result->rows <= $end)) {

            $result->data[] = $row;            

        }

    }

    if ($result->data[0]) {

        $result->cols = count($result->data[0]) / 2;

        $result->info['name'] = array_slice(array_keys($result->data[0]), $result->cols, $result->cols);

        $result->lastPage = ceil($result->rows / $nrows);

    }

    return $result;

}

?>

down

rhcf at linux dot ime dot usp dot br ¶

15 years ago


BEWARE!!!

dbx_query allocate all retrieved data in an array on memory. If the query result is big (bigger then the memory_limit on php.ini), the result will be empty. So use dbx wih care.

down

-3

bart at mediawave dot nl ¶

14 years ago


Would like to confirm that dbx is at least three times faster than adodb with my application. However, once loaded, adodb has much more features and probably performs better in some situations then dbx.

One of the nice features that adodb has, is the way you can quickly make a dropdown menu from a query. Here's a similar function that works with a dbx result object:

<?php

// $result is the dbx_query result (It expects two fields)
// $name is the name of the dropdown field
// $selected is the option that should be selected
// $firstrow takes a string like "myvalue:myname"
// $attr can be used to add some extra attributes

function dropDown($result, $name, $selected, $firstRow, $attr) {
    $s = '<select name="'.$name.'" '.$attr.'>';
    if (is_string($firstRow))  {
        $row = explode(':', $firstRow);
        $s .= '<option value="'.$row[0].'">'.$row[1].'</option>';
    } else
        $s .= '<option></option>';
    foreach ($result->data as $row) {
        if ($row[0] == $selected)
            $s .= '<option value="'.$row[0].'" selected="selected">'.htmlspecialchars($row[1]).'</option>';
        else
            $s .= '<option value="'.$row[0].'">'.htmlspecialchars($row[1]).'</option>';
    }
    return $s.'</select>';
}

?>

down

-3

jlim at natsoft dot com dot my ¶

16 years ago


For some benchmarks of dbx connecting to mysql compared to native mysql api, adodb, and others, see:

http://phplens.com/lens/adodb/

http://php.weblogs.com/2003/02/06#a2336

add a note

官方地址：https://www.php.net/manual/en/ref.dbx.php

有任何技术问题请点击这里网站运营推广招聘

IT PHP 编程语言 Linux 开发编程科技 Elasticsearch HTML/CSS/XML 网络数据库 JAVA 面试 NoSQL C/C++ Golang Git 算法操作系统正则表达式 Redis 互联网 MySql JavaScript 运维软件国际架构设计 Mac OS TCP/IP Excel Vim Windows Socket Oracle VR MongoDB Python 运营 MemCache 商业硬件电子娱乐设计 nginx 摄影游戏 WordPress HTTP 团建数码电器

php7 安装fileinfo扩展 preg_split — 通过一个正则表达式分隔字符串 php位值,解决 PHP 中 usort 在值相同时改变原始位置的问题 [PHP] inet_pton/inet_ntop IP地址转换函数 [鸟哥]PHP_INT_MIN 和 -9223372036854775808 PHP 8.1 ADORecordSet对象 adodb手册 opcache预加载 Composer的Packagist资源 array_multisort() 多字段排序 mysql面试题 PHPMailer设置utf8 PHPMailer字符集CharSet PHP json解析（json_decode）页面工具纯php实现DES以及TripleDES加密算法 [原创]诡异的php-fpm超时问题 php中几种注释规范 PHP获取指定函数定义在哪个文件中及行号 php上周一、本周一、下周一日期 [鸟哥]PHP FFI详解 - 一种全新的PHP扩展方式

略微加速

PHP官方手册 - 互联网笔记

dbx 函数

Table of Contents

User Contributed Notes 5 notes