vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Moving php embedded html to template and php file (https://vborg.vbsupport.ru/showthread.php?t=68834)

Jolten 08-29-2004 05:28 AM

Moving php embedded html to template and php file
 
Hi,

Ive got a php file with embedded html and I'm trying to convert this to work with the vb templates and files.

I'm trying to edit the member.php file and the memberinfo template to include this information.

I've added queries to the member.php file as follows:
Code:

$Con01=$DB_site->query("SELECT COUNT(*) as count FROM buster,usrbuster where buster.atoCon=usrcbuster.intCon and usrbuster.chrqualify ='Y' and buster.intCat in(1,2,3) and usrbuster.intplace=1 and usrbuster.strUsrId='$userinfo[username]'");
$num=$Con01['count'];
                                                                                       
$Con02=$DB_site->query("SELECT COUNT(*) as count FROM buster,usrbuster where buster.atoCon=usrcbuster.intCon and usrbuster.chrqualify ='Y' and buster.intCat in(1,2,3) and usrbuster.intplace=2 and usrbuster.strUsrId='$userinfo[username]'");
$num2=$Con02['count'];
                                       
$Con03=$DB_site->query("select COUNT(*) as count from usrbuster where strusrid = '$userinfo[username]' and intPlace=3 order by intPlace ");
$num3=$Con02['count'];
                                       
$Con04=$DB_site->query("SELECT COUNT(*) as count FROM buster,usrbuster where buster.atoCon=usrcbuster.intCon and usrbuster.chrqualify ='Y' and buster.intCat in(1,2,3) and usrbuster.intplace=1 and usrbuster.strUsrId='$userinfo[username]'");
$num4=$Con04['count'];

All these queries work as best as I can tell, yes I know the strUsrId=$userinfo[username] apears like a contradiction, but it isn't.

Here's the code I'd like to get working with the php file and template:
If it's possible to jsut wrap all this code in a container variable that I can call in the template, that would work.
Code:

<?for($i =1 ; $i <= $num; $i++){ ?>
                                <img border="0" src="../bb/images/1st_badge.gif" width="14" height="14" alt="First" />
                                <?} for($i =1 ; $i <= $num2; $i++){ ?>
                                <img border="0" src="../bb/images/2nd_badge.gif" width="14" height="14" alt="Second" />
                                <?} for($i =1 ; $i <= $num3; $i++){ ?>
                                <img border="0" src="../bb/images/3rd_badge.gif" width="14" height="14" alt="Third" />
                                <?} for($i =1 ; $i <= $num4; $i++){ ?>
                                <img border="0" src="../bb/images/cm_badgeA.gif" width="14" height="14" alt="fourth" />
                                <?}?>

This code works when embedded into a php file but, I can't see to get the for statements to work with some sort of variable I can place in the template. I've tried placint a variable in the for statements and then setting each variable, then calling the variable in the template but that doesn't work.

Any help would be really appreciated.

Jolten 08-29-2004 05:38 PM

Oka how about a while statement?

I've got this
Code:

$i=1;
while ($i <= $num):
print "<img border=\"0\" src=\"images/1st_badge.gif\" width=\"14\" height=\"14\" alt=\"First\" />";
$i++;
endwhile;

And I need to be able to call it in the template in order to place it. Right now it just places the images in the upper left corner of the page.

How can I define a variable for the while statement? Or have some what of telling the statement where to place it's image.

rake 08-30-2004 09:38 AM

for($i =1 ; $i <= $num; $i++)
{
$var .='<img border="0" src="../bb/images/1st_badge.gif" width="14" height="14" alt="First" />';
}

for($i =1 ; $i <= $num2; $i++)
{
$var .='<img border="0" src="../bb/images/2nd_badge.gif" width="14" height="14" alt="Second" />';
}

for($i =1 ; $i <= $num3; $i++)
{
$var .='<img border="0" src="../bb/images/3rd_badge.gif" width="14" height="14" alt="Third" />';
}

for($i =1 ; $i <= $num4; $i++)
{
$var .='<img border="0" src="../bb/images/cm_badgeA.gif" width="14" height="14" alt="fourth" />';
}

for the second one, you just replace print with $var = " ... ";

Jolten 08-30-2004 05:32 PM

Thank you! thank you! thank you! I was pulling hair out over this.

it was that pesky .=

I really can't thank you enough for the help Alex. You've made an entire community happy. I owe you one.

rake 08-30-2004 06:56 PM

Glad i was able to help. :)


All times are GMT. The time now is 11:18 AM.

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.00985 seconds
  • Memory Usage 1,725KB
  • 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_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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