vb.org Archive - multidimensional array from database table

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - multidimensional array from database table (https://vborg.vbsupport.ru/showthread.php?t=258677)

multidimensional array from database table

I am having trouble getting multiple rows from a table to display.

This is where i am currently at...
In my plugin php code i have the following:

Code:

// This will be in the form of page.php?do=action&user=1

$rkc_getuserid = $vbulletin->input->clean_gpc('r', 'user', TYPE_UINT);



$rkc_allchar = $vbulletin->db->query_first("

        SELECT char_id, char_name, char_race, char_class

        FROM " . TABLE_PREFIX . "rkc_plugintable AS rkc_plugintable

        WHERE user_id = '" . $vbulletin->db->escape_string($rkc_getuserid) . "'

");



$rkc_char['char_id'] = htmlspecialchars($rkc_char['char_id']);

$rkc_char['char_name'] = htmlspecialchars($rkc_char['char_name']);

$rkc_char['char_race'] = htmlspecialchars($rkc_char['char_race']);

$rkc_char['char_class'] = htmlspecialchars($rkc_char['char_class']);



...



    $templater->register('rkc_allchar', $rkc_allchar);

    $templater->register('rkc_char', $rkc_char);

then in my template, i have the following:

Code:

<tr>

        <vb:each from="rkc_allchar" value="char">

                <td>{vb:raw char}</td>

        </vb:each>

</tr>

The above code will successfully pull 1 row of data from the table. but if the user has multiple rows to pull, the other rows will not display. if i change from="rkc_allchar" to from="rkc_char" i get no data displayed at all.

I am pretty sure this has something to do with making a multidimensional array, but i am not sure how exactly to do this. I have trolled multiple php and vb sites but none of them give me enough to know how to do this when pulling multiple rows with multiple fields from a database.

What I am looking to do is something like:

Code:

<vb:each from="?" value="?">  // This will create a new row for each row of data collected

<tr>

        <vb:each from="rkc_allchar" value="char">  // This will break down each field from the row into its own <td>

                <td>{vb:raw char}</td>

        </vb:each>

</tr>

</vb:each>

I assume the array will have to look something like:

Code:

char_array( 

               char1( 

                      char_id => $variable, 

                      char_name => $variable,

                      char_race => $variable

                      char_class => $variable

                    ),

               char2( 

                      char_id => $variable, 

                      char_name => $variable,

                      char_race => $variable

                      char_class => $variable

                    ),

               char3( 

                      char_id => $variable, 

                      char_name => $variable,

                      char_race => $variable

                      char_class => $variable

                    )

             );

You are using query_first which will only get you one row of data. You need to do a query_read in order to get all the rows.

ah, ty for that. i changed that, but it is still not working properly.

Like i said, I am unsure how to structure the php code and the template code properly. i have tried multiple ways, and will keep trying to find an example/tutorial/etc on what im trying to do, but any help on the structure or what i'm doing wrong is appreciated.

----------------------------
EDIT: User Solved
----------------------------
PHP Code:

Code:

$rkc_allchar = $vbulletin->db->query_first("

        SELECT char_id, char_name, char_race, char_class

        FROM " . TABLE_PREFIX . "rkc_plugintable AS rkc_plugintable

        WHERE user_id = '" . $vbulletin->db->escape_string($rkc_getuserid) . "'

");



$count = 0;

while ($rkc_char = $vbulletin->db->fetch_array($rkc_allchar))

{

    $rkc_charlist[$count] = array(

        'char_id' => htmlspecialchars($rkc_char['char_id']),

        'char_name' => htmlspecialchars($rkc_char['char_name']),

        'char_race' => htmlspecialchars($rkc_char['char_race']),

        'char_class' => htmlspecialchars($rkc_char['char_class']),

    );

    $count++;

...



    $templater->register('rkc_charlist', $rkc_charlist);



    }

Template Code:

Code:

        <vb:each from="rkc_charlist" value="char">

        <tr>

                <td class="blocksubhead" style="width:15%;">{vb:raw char['char_id']}</td>

                <td class="blocksubhead" style="width:15%;">{vb:raw char['char_name']}</td>

                <td class="blocksubhead" style="width:15%;">{vb:raw char['char_race']}</td>

                <td class="blocksubhead" style="width:15%;">{vb:raw char['char_class']}</td>

        </tr>

        </vb:each>

Thank you for the help!

Have you tried doing a search in the default vbulletin files for some code that is an example of what you want?

i posted my solution as an edit to my last post. Thanks for the help!

Thanks for posting the solution and I'm glad you got it figured out. :)

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01073 seconds Memory Usage 1,733KB 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 (6)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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
Messages: