The Arcive of vBulletin Modifications Site.

Jaynesh · #1 04-09-2006, 08:59 PM

What am i doing wrong here?

Im trying to display all the rows in the table.
But its not working, there is no error message. It just doesnt display!

PHP Code:


			
<?php

// ######################## SET PHP ENVIRONMENT ########################### 

error_reporting(E_ALL & ~E_NOTICE); 



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

// change the line below to the actual filename without ".php" extention. 

// the reason for using actual filename without extention as a value of this constant is to ensure uniqueness of the value throughout every PHP file of any given vBulletin installation. 



define('THIS_SCRIPT', 'test');  



// #################### 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( 

        // change the lines below to the list of actual templates used in the script 

        'test', 

); 



// pre-cache templates used by specific actions 

$actiontemplates = array(); 



// ########################## REQUIRE BACK-END ############################ 

require_once('./global.php'); 



// #################### HARD CODE JAVASCRIPT PATHS ######################## 

$headinclude = str_replace('clientscript', $vbulletin->options['bburl'] . '/clientscript', $headinclude); 



// ######################################################################## 

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

// ######################################################################## 



$userid = $vbulletin->userinfo['userid'];

$usergroupid = $vbulletin->userinfo['usergroupid'];

$username = $vbulletin->userinfo['username'];



function foo() 

{ 

    global $vbulletin; 



    $views = $db->query_first("SELECT * FROM test"); 

    while ($view = $vbulletin->db->fetch_array($views)) 

    { 

    } 

    $vbulletin->db->free_result($views); 

}  





$navbits = array();  

$navbits[$parent] = 'Test Page'; 



$navbits = construct_navbits($navbits); 

eval('$navbar = "' . fetch_template('navbar') . '";'); 

eval('print_output("' . fetch_template('test') . '");'); 





?>

Code Monkey · #2 04-09-2006, 09:05 PM

You have nothing in your while loop which means no output to display.

Plus, I don't see where you are even using the function named foo.

Jaynesh · #3 04-09-2006, 09:11 PM

Quote:

Originally Posted by JumpD

You have nothing in your while loop which means no output to display.

Plus, I don't see where you are even using the function named foo.

I got it from here https://vborg.vbsupport.ru/showthread.php?t=106053

Could you tell me how to fix it or do it the correct way? Im new to php

Code Monkey · #4 04-09-2006, 09:15 PM

PHP Code:


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

// ##################### DEFINE IMPORTANT CONSTANTS #######################
// change the line below to the actual filename without ".php" extention.
// the reason for using actual filename without extention as a value of this constant is to ensure uniqueness of the value throughout every PHP file of any given vBulletin installation.

define('THIS_SCRIPT', 'test');

// #################### 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(
// change the lines below to the list of actual templates used in the script
'test',
);

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

// ########################## REQUIRE BACK-END ############################
require_once('./global.php');

// #################### HARD CODE JAVASCRIPT PATHS ########################
$headinclude = str_replace('clientscript', $vbulletin->options['bburl'] . '/clientscript', $headinclude);

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

$userid = $vbulletin->userinfo['userid'];
$usergroupid = $vbulletin->userinfo['usergroupid'];
$username = $vbulletin->userinfo['username'];

$views = $db->query_first("SELECT * FROM test");
while ($view = $vbulletin->db->fetch_array($views))
{
    echo $view['some_collumn_name'];
}
$vbulletin->db->free_result($views);



$navbits = array();
$navbits[$parent] = 'Test Page';

$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('test') . '");');

?>

Jaynesh · #5 04-09-2006, 09:21 PM

Im getting a parse error.

Parse error: parse error, expecting `','' or `';'' in c:\program files\easyphp1-8\www\test.php on line 44

Okay i fixed the parse error but it still is not displaying rows. No errors.

Okay okay i got it

Thanks alot

Code Monkey · #6 04-09-2006, 09:57 PM

Yeah, you need to use actual database collumn names.

Jaynesh · #7 04-09-2006, 10:03 PM

Lol yep ive got it.

Ive now put $view[column] in the template.
But it only displays the first row.
How can i display all rows?

PHP Code:


			
<?php

// ######################## SET PHP ENVIRONMENT ###########################

error_reporting(E_ALL & ~E_NOTICE);



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

// change the line below to the actual filename without ".php" extention.

// the reason for using actual filename without extention as a value of this constant is to ensure uniqueness of the value throughout every PHP file of any given vBulletin installation.



define('THIS_SCRIPT', 'test');



// #################### 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(

// change the lines below to the list of actual templates used in the script

'test',

);



// pre-cache templates used by specific actions

$actiontemplates = array();



// ########################## REQUIRE BACK-END ############################

require_once('./global.php');



// #################### HARD CODE JAVASCRIPT PATHS ########################

$headinclude = str_replace('clientscript', $vbulletin->options['bburl'] . '/clientscript', $headinclude);



// ########################################################################

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

// ########################################################################



$userid = $vbulletin->userinfo['userid'];

$usergroupid = $vbulletin->userinfo['usergroupid'];

$username = $vbulletin->userinfo['username'];



$views = $db->query_read("SELECT * FROM test");

while ($view = $vbulletin->db->fetch_array($views))

{

    $review = $view['review'];

    $member = $view['member'];



$vbulletin->db->free_result($views);



$navbits = array();

$navbits[$parent] = 'Test Page';



$navbits = construct_navbits($navbits);

eval('$navbar = "' . fetch_template('navbar') . '";');

eval('print_output("' . fetch_template('test') . '");');

}



?>

Code Monkey · #8 04-09-2006, 10:09 PM

You don't want all these in that loop.

PHP Code:


			
$vbulletin->db->free_result($views);

$navbits = array();
$navbits[$parent] = 'Test Page';

$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');

Jaynesh · #9 04-10-2006, 06:01 AM

It still only displays one row?

If i do this

PHP Code:


			
{

    echo $view['review'];

    echo $view['member'];

    

}

It displays all the rows.

but if i do this and try and put it in the template file it only displays one row.

PHP Code:


			
{

    $review = $view['review'];

    $member = $view['member'];

    

}

Code Monkey · #10 04-10-2006, 12:18 PM

You need a template file for the rows (inside the loop) then a main template to hold the rows (outside the loop).

PHP Code:


			
$views = $db->query_first("SELECT * FROM test");
$viewrow = '';
while ($view = $vbulletin->db->fetch_array($views))
{
    $review = $view['review'];
    $member = $view['member']; 
    eval('$viewrow .= "' . fetch_template('viewrows') . '";');
}
eval('$viewtable = "' . fetch_template('viewtable') . '";');
$vbulletin->db->free_result($views);
$navbits = array();
$navbits[$parent] = 'Test Page';

$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('test') . '");');

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07720 seconds Memory Usage 4,784KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (7)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (1)pagenav (1)pagenav_curpage (1)pagenav_pagelink (10)post_thanks_box (10)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (10)post_thanks_postbit_info (10)postbit (10)postbit_onlinestatus (10)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages: