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

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   What am i doing wrong? (https://vborg.vbsupport.ru/showthread.php?t=112590)

Jaynesh 04-09-2006 09:59 PM
What am i doing wrong?
 
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 04-09-2006 10: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 04-09-2006 10: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 :confused:

Code Monkey 04-09-2006 10: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 04-09-2006 10: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 :D Thanks alot :D

Code Monkey 04-09-2006 10:57 PM
Yeah, you need to use actual database collumn names.

Jaynesh 04-09-2006 11: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 04-09-2006 11: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 04-10-2006 07: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 04-10-2006 01: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') . '");'); 


All times are GMT. The time now is 05:52 AM.
Page 1 of 2 1 2
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.01726 seconds
  • Memory Usage 1,800KB
  • 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
  • (7)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)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