vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Records from database (https://vborg.vbsupport.ru/showthread.php?t=246381)

Przemoo 07-12-2010 09:18 AM
Records from database
 
Hi.

What code is responsible for displaying all the records from the database / table
Is there any other method than "echo"

Speysider 07-12-2010 02:06 PM
Just use the SELECT query and use $row['(name of row here)'] in a table tag.

Przemoo 07-12-2010 02:25 PM
what is wrong in that code ?

PHP Code:
<?php 

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

// #################### DEFINE IMPORTANT CONSTANTS ####################### 
define('NO_REGISTER_GLOBALS', 1); 
define('THIS_SCRIPT', 'test'); // 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( 
    'screeny', 
); 

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

); 

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

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

$navbits = array(); 
$navbits[$parent] = 'Testowa Strona'; 

$sql = $db->query_read ("SELECT * FROM `amx_screenshots` ORDER BY ssid DESC");


while( $row = $db->fetch_array($sql) )
{ 

$x++;

$gracz = $row["player_username"]; 
$admin = $row["admin_username"]; 
$data = $row["screenshot_time"]; 
$mapa = $row["map"];
$ip = $row["player_authid"]; 

$data = date("H:i:s  d.m.Y",$data);
/*
$template->assign_block_vars('screeny', array( 

'ID' => $x+$start,
'GRACZ' => $gracz,
'ADMIN' => $admin, 
'DATA' => $data,
'MAPA' => $mapa, 
'IP' => $ip) 
);*/
}

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

?>
it shows me only the last entry in the table instead of all

Speysider 07-12-2010 02:31 PM
try a do ... while loop, instead of just a while loop

Przemoo 07-12-2010 02:36 PM
what do u mean exactly ? could u change that for me please ?

BirdOPrey5 07-12-2010 02:50 PM
Quote:
Originally Posted by Przemoo (Post 2068082)
what do u mean exactly ? could u change that for me please ?
The do... while loop is below... not sure if it will help personally but this is how you do it.

PHP Code:
do 
{  

$x++; 

$gracz = $row["player_username"];  
$admin = $row["admin_username"];  
$data = $row["screenshot_time"];  
$mapa = $row["map"]; 
$ip = $row["player_authid"];  

$data = date("H:i:s  d.m.Y",$data); 
/* 
$template->assign_block_vars('screeny', array(  

'ID' => $x+$start, 
'GRACZ' => $gracz, 
'ADMIN' => $admin,  
'DATA' => $data, 
'MAPA' => $mapa,  
'IP' => $ip)  
);*/ 
} while( $row = $db->fetch_array($sql) ) ; 

Przemoo 07-12-2010 03:11 PM
still shows the last entry

i think the problem is here
Code:
$sql = $db->query_read("SELECT * FROM `amx_screenshots` ORDER BY ssid DESC");
but i don't know what exactly ;/

BirdOPrey5 07-12-2010 03:28 PM
Why don't you echo x; at some point so you can see how many rows there are supposed to be in the loop, that would help pinpoint the issue... if x=1 then the problem is with the sql, otherwise the sql is probably right,

Przemoo 07-12-2010 09:17 PM
could u write an example code for templates ? what code should be there :>

BirdOPrey5 07-12-2010 09:24 PM
after your while loop just put the line:

echo "<h1>" . $x . "</h1>" ;

That should output the value of x somewhere in a big font, just for debugging purposes, obviously don't run your forum this way. I don't know if $x is available in a template... just put:
<h1>$x</h1>
somewhere in the template and see if anything shows up.

Przemoo 07-12-2010 09:38 PM
1 Attachment(s)
it show up but on the top only (take a look on a screen)

BirdOPrey5 07-12-2010 09:54 PM
That's good, that means there are 4,668 rows in your variable- the SQL statement is right (probably) you just need to figure out how to print it. (Which I realize was your first question to start this thread, but at some point you questioned if the SQL statement was right).

Przemoo 07-13-2010 09:40 AM
its working now, because of $dane

PHP Code:
$gracz = $row["player_username"];   
$admin = $row["admin_username"];   
$data = $row["screenshot_time"];   
$mapa = $row["map"];  
$ip = $row["player_authid"];   
$x++;
$data = date("H:i:s  d.m.Y",$data);  
$dane = (''.$dane.'
    <tr>
    <td class="alt2" align="center" width="2%"><span class="screeny2">&nbsp;'.$x.'</span></td>
    <td class="alt1" align="center" width="15%"><span class="screeny2">&nbsp;'.$gracz.'</span></td>
    <td class="alt2" align="center" width="15%"><span class="screeny2">&nbsp;'.$admin.'&nbsp;</span></td>
    <td class="alt1" align="center" width="15%"><span class="screeny2">&nbsp;'.$ip.'&nbsp;</span></td>      
    <td class="alt2" align="center" width="17%"><span class="screeny2">&nbsp;'.$data.'&nbsp;</span></td>  
    <td class="alt1" align="center" width="13%"><span class="screeny2">&nbsp;'.$mapa.'&nbsp;</span></td>
    </tr>
');
} while( $row = $db->fetch_array($sql) ) ; 

but there is another problem with pagination
i used tha article - https://vborg.vbsupport.ru/showthrea...ght=Paginating

paginating shows up but only for few minutes and then disappeared


that how it is

PHP Code:
<?php 

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

// #################### DEFINE IMPORTANT CONSTANTS ####################### 
define('NO_REGISTER_GLOBALS', 1); 
define('THIS_SCRIPT', 'test'); // 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( 
    'screeny', 
); 

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

); 

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

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

$navbits = array(); 
$navbits[$parent] = 'Testowa Strona';


$sql_conn = mysql_connect('host', 'login', 'password');
mysql_select_db('database',$sql_conn);

    // Default page variables 
    $perpage = $vbulletin->input->clean_gpc('r', 'perpage', TYPE_UINT);
    $pagenumber = $vbulletin->input->clean_gpc('r', 'pagenumber', TYPE_UINT); 
    
    // Count all log entries 
    $bannedcount = $db->query_first(" 
        SELECT COUNT(`player_username`) AS `bannedcount` 
        FROM `amx_screenshots` 
    "); 
    
    sanitize_pageresults($bannedcount['bannedcount'], $pagenumber, $perpage, 100, 25); 
    
    // Default lower and upper limit variables 
    $limitlower = ($pagenumber - 1) * $perpage + 1; 
    $limitupper = $pagenumber * $perpage; 
    if ($limitupper > $bannedcount['bannedcount']) 
    { 
        // Too many for upper limit 
        $limitupper = $bannedcount['bannedcount']; 
        if ($limitlower > $bannedcount['bannedcount']) 
        { 
            // Too many for lower limit 
            $limitlower = $bannedcount['bannedcount'] - $perpage; 
        } 
    } 
    if ($limitlower <= 0) 
    { 
        // Can't have negative or null lower limit 
        $limitlower = 1; 
    }
    


    
    

$sql = mysql_query("SELECT * FROM amx_screenshots ORDER BY ssid DESC LIMIT " . ($limitlower - 1) . ", $perpage ");
$x=0;
do  
{   

 

$gracz = $row["player_username"];   
$admin = $row["admin_username"];   
$data = $row["screenshot_time"];   
$mapa = $row["map"];  
$ip = $row["player_authid"];   
$x++;
$data = date("H:i:s  d.m.Y",$data);  
$dane = (''.$dane.'
    <tr>
    <td class="alt2" align="center" width="2%"><span class="screeny2">&nbsp;'.$x.'</span></td>
    <td class="alt1" align="center" width="15%"><span class="screeny2">&nbsp;'.$gracz.'</span></td>
    <td class="alt2" align="center" width="15%"><span class="screeny2">&nbsp;'.$admin.'&nbsp;</span></td>
    <td class="alt1" align="center" width="15%"><span class="screeny2">&nbsp;'.$ip.'&nbsp;</span></td>      
    <td class="alt2" align="center" width="17%"><span class="screeny2">&nbsp;'.$data.'&nbsp;</span></td>  
    <td class="alt1" align="center" width="13%"><span class="screeny2">&nbsp;'.$mapa.'&nbsp;</span></td>
    </tr>
');
} while( $row = $db->fetch_array($sql) ) ;
   
$pagenav = construct_page_nav($pagenumber, $perpage, $bannedcount['bannedcount'], 'screeny.php?' . $vbulletin->session->vars['sessionurl'] . 'do=view');  
$navbits = construct_navbits($navbits); 
eval('$navbar = "' . fetch_template('navbar') . '";'); 
eval('print_output("' . fetch_template('screeny') . '");'); 

?>

kh99 07-13-2010 12:06 PM
I'm not sure how that's supposed to work. It looks like you're always starting at the first record instead of calculating " $limitlower " like in the article.

Also, I think you might want to go back to using a "while" loop instead of "do...while", because I think the way you have it you're using the "$row" variable the first time before you've set it.

BTW, you probably don't want to post your database connect info. Is there a reason you're opening a database connection instead of using the one vB opens?

Przemoo 07-13-2010 12:12 PM
Quote:
Originally Posted by kh99 (Post 2068509)
I'm not sure how that's supposed to work. It looks like you're always starting at the first record instead of calculating " $limitlower " like in the article.

Also, I think you might want to go back to using a "while" loop instead of "do...while", because I think the way you have it you're using the "$row" variable the first time before you've set it.

BTW, you probably don't want to post your database connect info. Is there a reason you're opening a database connection instead of using the one vB opens?
omg i forgot to hide it :) ;p thx

my hosting is sux, i've got limit in "max_user_connection" and my script doesn't close the connection thats why am using VPS for that.
pagenav was working yesterday i don't know why is not :/

kh99 07-13-2010 12:24 PM
Oh. Anyway, I see that you *did* calculate $limitlower, you just used 1 in the query, so maybe you were just debugging.

Przemoo 07-13-2010 12:26 PM
could you show me an example ? am not best in php :/

kh99 07-13-2010 12:29 PM
No, it was my mistake, what you have is right. :) Sorry, I was looking at the wrong code.

Przemoo 07-13-2010 12:33 PM
is right but still without pagination :D maybe i will find it somewhere

Przemoo 07-16-2010 04:44 PM
still not working :/ any solutions for that ?

kh99 07-17-2010 10:36 PM
Maybe try displaying some values to debug the code? I usually insert them in HTML comments, then view the page source to see the values. You would just have to add them in to your $dane variable.


All times are GMT. The time now is 01:41 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.01304 seconds
  • Memory Usage 1,848KB
  • 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_code_printable
  • (4)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (21)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