vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   How to read values in an array (https://vborg.vbsupport.ru/showthread.php?t=222152)

Coen Jeukens 08-31-2009 03:22 PM
How to read values in an array
 
1 Attachment(s)
Newbie: I am writing my first vB php module and need some help in using the output results of my query.

I have created 2 functions:
  1. function fetchforums() - this function runs a query and stores the data in an array
  2. function foruminfo(x) - function will be called many times and should retrieve values from the array.

Running my query returns three columns of data (see picture1.png).
  1. forumid
  2. title
  3. cntthreads

The code I use is:
PHP Code:
function fetchforums()
{
    global $vbulletin, $forumstructure;
    if (empty($vbulletin->iforumcache))
    {
        $forums = $vbulletin->db->query_read("
            SELECT forum.forumid, forum.title, count(*) AS cntthread
            FROM " . TABLE_PREFIX . "forum AS forum
            LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (forum.forumid=thread.forumid)
            GROUP BY forum.forumid, forum.title
            ORDER BY forum.forumid
        ");
        
        $result = array();
        while ($row = $vbulletin->db->fetch_array($forums)) {
            $result["$row[forumid]"] = $row;
        }
        unset($row);
        
        $vbulletin->db->free_result($forums);
    }

    return($result);
} 
I have tested the function as folllowing:
PHP Code:
$rc = fetchforums();
print_r(array_values($rc)); 
This gives me a result as shown in picture2.png.

In the second function I want to read the array.
I want to call the function like: (or equivalent)
PHP Code:
$rc1 = foruminfo(23,'title');
$rc2 = foruminfo(23,'cntthread');
echo "<li><a href="{$vbulletin->options[bburl]}/forumdisplay.php?f=23">$rc1</a> ($rc2)</li>"; 
Currently I have not been able to navigate the $rc array.

Q: How do I proceed?

Regards
Coen

Lynne 08-31-2009 04:02 PM
You should be able to use the values in that array as $rc['forumid'], $rc['title'] and $rc['cntthread'] Loop through them?


All times are GMT. The time now is 09:23 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01124 seconds
  • Memory Usage 1,723KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete