Joomla开发--JDatabase_jcdashboards: database joomla-CSDN博客

本文链接：https://blog.csdn.net/gaogao0603/article/details/5281093

JDatabase类：数据库操作类

看一个简单例子，就基本明白了：

jos_users表中数据：

访问代码：
    // @Author:Pandajj
    $sql ='SELECT id,username FROM #__users';
    $db =&JFactory ::getDBO() ;
    $db ->setQuery ($sql );

    ob_start();

    print('<table border=1 cellspacing=0 cellpadding=2>');
    print('<tr><th>function</th><th>outcome</th></tr>');
    print('<tr><td>loadResult()</td>');
    print('<td>');
        print_r($db ->loadResult() );
    print('</td></tr>');
    print('<tr><td>loadResultArray()</td>');
    print('<td>');
        print_r($db ->loadResultArray() );
    print('</td></tr>');
    print('<tr><td>loadAssoc()</td>');
    print('<td>');
        print_r($db ->loadAssoc() );
    print('</td></tr>');
    print('<tr><td>loadAssocList()</td>');
    print('<td>');
        print_r($db ->loadAssocList() );
    print('</td></tr>');
    print('<tr><td>loadObject()</td>');
    print('<td>');
        print_r($db ->loadObject() );
    print('</td></tr>');
    print('<tr><td>loadObjectList()</td>');
    print('<td>');
        print_r($db ->loadObjectList() );
    print('</td></tr>');
    print('<tr><td>loadRow()</td>');
    print('<td>');
        print_r($db ->loadRow() );
    print('</td></tr>');
    print('<tr><td>loadRowList()</td>');
    print('<td>');
        print_r($db ->loadRowList() );
    print('</td></tr>');
    print('</table>');

    ob_flush();

结果：