vb.org Archive
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Help show more than one result. (https://vborg.vbsupport.ru/showthread.php?t=281224)

Preech 04-07-2012 07:10 AM
Damn, that was simple. I see where I went wrong.
I never put this in the code at all.
PHP Code:
$templater = vB_Template::create('vbmusic'); 
I still one get the one album to show. I will send you a pm of the link of what I"m trying to do.

--------------- Added [DATE]1333786475[/DATE] at [TIME]1333786475[/TIME] ---------------

I read the article, I guess I just wasn't pay attention to it.
I really do appreciate it. I've sent you a link to see what I'm trying to accomplish over-all.
Just by seeing how it's done, I learned alot faster on how to accomplish this. Now I'm just trying to figure out the foreach statement.

I figured I could use the vb:each statement in the template, but that didn't work.

Pandemikk 04-07-2012 07:27 AM
I'm going to focus on your second problem now:

PHP Code:
while ($musical =$db->fetch_array($musicalbum))
    {
    $malbumid = $musical['alid'];
    $malbumname = $musical['alname'];
    $malbumarname = $musical['arname'];
    $malbumarid = $musical['arid'];
    $mcvrsaved = $musical['cvrsaved'];
    } 
You're only going to get one value doing that because you're overwriting the variable each time.

PHP Code:
$musicals = array();
if ($db->num_rows($musicalbum))
{
    while ($musical = $db->fetch_array($musicalbum))
    {
        $musicals[] = $musical;
    }
}
$db->free_result($musicalbum); 
Now we're cooking. ;)

I've replace your unnecessary variables with an array and, furthermore, I've made sure each row gets it own place in the array.

PHP Code:
$musicstat = $db->query_read("SELECT nr_artists, nr_albums,nr_tracks FROM " . TABLE_PREFIX ." stats");
while ($music_stat = $db->fetch_array($musicstat))
{
$statar = $music_stat['nr_artists'];
$statal = $music_stat['nr_albums'];
$statt = $music_stat['nr_tracks'];
} 
Think you can figure out how to fix this?

Now replace all that ugliness in your first template render with:
PHP Code:
$templater->register('musicals', $musicals); 
Now you have an array of all the albums ready for display.

I'd recommend using {vb:each [, ]} to loop through that array and do that.

Read my article, it should help you get the basics down: https://vborg.vbsupport.ru/showthread.php?t=280880

Preech 04-07-2012 07:34 AM
Appreciate it so much. Just some free time during this deployment. I will read this article one more.

--------------- Added [DATE]1333821880[/DATE] at [TIME]1333821880[/TIME] ---------------

I've been trying for hours. I've search on google, and read through your article. I'm assuming that I am making a mistake as to where I'm suppose to put the php code foreach.

Preech 04-08-2012 05:17 PM
Yo, I am seriously lost.
This is my code in the template
PHP Code:
<vb:each from="musicals"  value="value">
    {vb:raw vbmusic_latest}
</vb:each> 
This is my php code.
PHP Code:
$musicals = array('alid','alname','arid','cvrsaved','arname');

if ($db->num_rows($musicalbum))
{
    while ($musical = $db->fetch_array($musicalbum))
    {
  
       $musicals[] = $musical;  
       $malbumid = $musical['alid'];
    $malbumname = $musical['alname'];
    //$malbumarname = $musical['arname'];
    //$malbumarid = $musical['arid'];
    //$mcvrsaved = $musical['cvrsaved'];
    }
foreach ($musicals AS $value)
{
    $value = $vbmusic_latest;
}
} 
I am trying to get the template to show for each album, but I can not get it to show. I can get it to show without being in the foreach.

Pandemikk 04-08-2012 05:29 PM
What are you doing? The code I gave you is what you should be using! What you're doing won't work. vb:each replicates the foreach function, so you shouldn't be using an actual foreach in your php code!

HTML Code:
<vb:each from="musicals"  key="key" value="musical">
    {vb:raw musical.nr_artists}
    {vb:raw musical.nr_albums}
etc.,.
</vb:each>

Preech 04-08-2012 05:56 PM
Okay, so I put the php code just like you shown, and I've put the vb:each in just like you just posted. Nothing shows.
I've been reading alot of articles.

Pandemikk 04-08-2012 07:18 PM
Post your complete PHP code and template code.

Preech 04-09-2012 03:36 AM
Php Code
PHP Code:
<?php

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################

define('THIS_SCRIPT', 'vbmusic');
define('CSRF_PROTECTION', true);  
// change this depending on your filename

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array('vbmusic','vbmusic_latest'
);

// pre-cache templates used by specific actions
$actiontemplates = array();

// ######################### REQUIRE BACK-END ############################
// if your page is outside of your normal vb forums directory, you should change directories by uncommenting the next line
// chdir ('/path/to/your/forums');
require_once('./global.php');

// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################

$navbits = construct_navbits(array('' => 'Music'));
$navbar = render_navbar_template($navbits);



// ###### YOUR CUSTOM CODE GOES HERE #####



$musicalbum =  $db->query_read("
SELECT al.alid, al.alname, al.arid, al.added, al.cvrsaved, ar.arname FROM " . TABLE_PREFIX. " album al
LEFT JOIN artist ar ON ar.arid=al.arid  
ORDER BY al.alid DESC LIMIT 5
");

$musicals = array();

if ($db->num_rows($musicalbum))
{
    while ($musical = $db->fetch_array($musicalbum))
    {
        $musicals[] = $musical;  
 
    }
 

}
$db->free_result($musicalbum);  
  
 



$templater = vB_Template::create('vbmusic_latest');
$templater->register('musicals', $musicals);
   // $templater->register('malbumid', $malbumid);
   // $templater->register('malbumname', $malbumname);
    //$templater->register('malbumarname', $malbumarname);
   // $templater->register('malbumarid', $malbumarid); 
$vbmusic_latest = $templater->render(); 


    //$malbumid = $musical['alid'];
    //$malbumname = $musical['alname'];
    //$malbumarname = $musical['arname'];
    //$malbumarid = $musical['arid'];
    //$mcvrsaved = $musical['cvrsaved'];
      


$musicstat = $db->query_read("SELECT nr_artists, nr_albums,nr_tracks FROM " . TABLE_PREFIX ." stats");
while ($music_stat = $db->fetch_array($musicstat))
{
$statar = $music_stat['nr_artists'];
$statal = $music_stat['nr_albums'];
$statt = $music_stat['nr_tracks'];
}
    


    
// ###### NOW YOUR TEMPLATE IS BEING RENDERED ######

$templater = vB_Template::create('vbmusic');
    $templater->register_page_templates(); 
    $templater->register('navbar', $navbar);
    $templater->register('vbmusic_latest', $vbmusic_latest);
    $templater->register('cvrsaved', $cvrsaved);
    $templater->register('statar', $statar);
    $templater->register('statal', $statal);
    $templater->register('statt', $statt);
print_output($templater->render());



?>
PHP Code:
{vb:stylevar htmldoctype}
<html xmlns="http://www.w3.org/1999/xhtml" dir="{vb:stylevar textdirection}" lang="{vb:stylevar languagecode}" id="vbulletin_html">
  <head>
    <title>{vb:raw vboptions.bbtitle} - {vb:raw pagetitle}</title>
    {vb:raw headinclude}
    {vb:raw headinclude_bottom}
  </head>
  <body>
    
    {vb:raw header}
    
    {vb:raw navbar}


<br /><br /><br />
    
<div class="colmask leftmenu">
    <div class="colleft">
        <div class="col1">
            <!-- Column 1 start -->



<div class="audio_head">Newest Mixtapes</div>
<div class="audio_body">

<vb:each from="musicals" value="musical">

    {vb:raw musical.alid}
    {vb:raw musical.alname}

</vb:each>
<!--{vb:raw vbmusic_latest}-->
    </div>


            <!-- Column 1 end -->
        </div>
        <div class="col2">
            <!-- Column 2 start -->
<div class="audio_head">Menu</div>
<div class="audio_body">
        <table align="center" cellspacing="0" cellpadding="0" width="100%" > 
 <tr> 
  <td valign="top" align="center">
   <table align="center" cellspacing="5" cellpadding="0" width="100%"> 
    <tr> 
     <td align="left"><a href="vbmusic.php" title="" alt="">- Music Home</a></td>
    </tr>
    <tr> 
     <td align=\"left\"><a href=\"browse.php?typ=artist\" title=\"\" alt=\"\">- Browse Artist</a></td>
    </tr>
    <tr> 
     <td align=\"left\"><a href=\"browse.php?typ=album\" title=\"\" alt=\"\">- Browse Albums</a></td>
    </tr>
    <tr> 
     <td align=\"left\"><a href=\"browse.php?typ=genre\" title=\"\" alt=\"\">- Browse Genre</a></td>
    </tr>

 <tr> 
     <td align=\"left\"><a href=\"import.php\" title=\"\" alt=\"\">- Import Albums</a></td>
    </tr>
    <tr> 
     <td align=\"left\"><a href=\"config.php\" title=\"\" alt=\"\">- Config Settings</a></td>
    </tr>
    <tr> 
     <td align=\"left\"><a href=\"usr_list.php\" title=\"\" alt=\"\">- Userlist</a></td>
    </tr>
    <tr> 
     <td align=\"left\"><a href=\"showlog.php\" title=\"\" alt=\"\">- Show Log</a></td>
    </tr>
    <tr> 
     <td align=\"left\"><a href=\"stats.php\" title=\"\" alt=\"\">- Statistics</a></td>
    </tr>
    <tr> 
     <td align=\"left\"><a href=\"create_artist.php\" title=\"\" alt=\"\">- Create artist</a></td>
    </tr>
    <tr> 
     <td align=\"left\"><a href=\"del_artist.php\" title=\"\" alt=\"\">- Delete artist</a></td>
    </tr>


</table>
  </td>
 </tr>
</table>
        </div><br />
<div class="audio_head">Statistics</div>
<div class="audio_body">
<table align="center" cellspacing="0" cellpadding="0" width="100%"> 
 <tr> 
  <td valign="top" align="center">
   <table align="center" cellspacing="0" cellpadding="0" width="90%">
    <tr>
     <td class="data3" align="left"><b>Albums  </b>&nbsp</td>
     <td class="data1" align="left">{vb:raw statal}</td></tr>
     <tr><td class="data3" align="left"><b>Artists  </b>&nbsp</td>
     <td class="data1" align="left">{vb:raw statar}</td></tr>
     <tr><td class="data3" align="left"><b>Songs  </b>&nbsp</td>
     <td class="data1" align="left">{vb:raw stats}</td></tr>
   </table>
  </td>
 </tr>
</table>
</div>
    

            
            <!-- Column 2 end -->
        </div>
    </div>
</div>
    {vb:raw footer}
  </body>
</html> 

Pandemikk 04-09-2012 04:55 AM
Is the HTML you're showing me from template: vbmusic_latest, or from template: vbmusic

If it's from template: vbmusic, then you need to add: $templater->register('musicals', $musicals); to the register in that template.

Preech 04-09-2012 05:24 AM
Well god damn, I knew it was something simple that I was over looking. That was it.

I see that your site is music related as well. I'm currently deployed to Afghanistan right now. If it's not to much, can I continue to ask you for help from time to time. I get about six hours of free time each day. If possible how may I contact you.


All times are GMT. The time now is 11:45 PM.
Page 2 of 3 1 2 3
Show 40 post(s) from this thread on one page

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.01208 seconds
  • Memory Usage 1,846KB
  • 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
  • (1)bbcode_html_printable
  • (9)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete