The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Problem displaying a table output in a vBulletin powered page
Hello everyone,
I'm a novice PHP and MySQL but have some understanding of how programming languages are supposed to work so based on about 3 days worth of effort, I have built a table in MySQL called 'sales'. This table contains sales data on cars. Now, I'm trying to display this tabular data and picture on a vBulletin powered page as a table but to no avail... I'm getting memory errors... It goes without saying that I copied most of this code from others on this website so have a very limited understanding of many of the concepts. Following is the memory error: Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 129237044 bytes) in /home/xxxxxxx/public_html/ref.php(64) : eval()'d code on line 18 So, here's my PHP code: <?php error_reporting(E_ALL & ~E_NOTICE); define('NO_REGISTER_GLOBALS', 1); define('THIS_SCRIPT', 'ref'); // change this depending on your filename // get special phrase groups $phrasegroups = array(); // get special data templates from the datastore $specialtemplates = array(); // pre-cache templates used by all actions $globaltemplates = array( 'REF', 'REFBODY' ); $actiontemplates = array(); require_once('./global.php'); if ($vbulletin->userinfo['userid'] == 0) { $show['permission_error'] = 1; eval('print_output("' . fetch_template('STANDARD_ERROR') . '");'); } elseif (isset($_REQUEST['do'])) // Being passed from a web page $ref_req = $_GET['mdl'] ; include("dbinfo.php"); mysql_connect(localhost,$user,$pass); @mysql_select_db($db) or die( "Unable to select database"); $showlistbits = ''; $altclass = 'alt1'; $query="SELECT * FROM sales WHERE model LIKE '%$ref_req%' "; $result=mysql_query($query); $omega = mysql_fetch_array($result); $num=mysql_numrows($result); mysql_close(); $i=0; while ($i < $num) { $altclass = ($altclass=='alt1') ? 'alt2' : alt1; eval('$showlistbits .= "' .fetch_template('REFBODY') . '";'); } $navbits = array(); $navbits[$parent] = "Sales Table"; $navbits = construct_navbits($navbits); eval('$navbar = "' . fetch_template('navbar') . '");'); eval('print_output("' . fetch_template('REF') . '");'); ?> Here's the REF template: $stylevar[htmldoctype] <html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]"> <head> $headinclude <title>$vboptions[bbtitle] - $pagetitle</title> </head> <body> $header $navbar <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="1" border="0" width="100%" align="center"> <tr> <td class="tcat" align="center" colspan="6">Sales Table</td> </tr> <tr align="center" bgcolor="#336699"> <th style="width: 81px"><b><font color="#FFFFFF">Venue</font></b></th> <th style="width: 77px"><b><font color="#FFFFFF">Cylinders</font></b></th> <th style="width: 77px"><b><font color="#FFFFFF">Color</font></b></th> <th style="width: 90px"><b><font color="#FFFFFF">Wheels</font></b></th> <th style="width: 90px"><b><font color="#FFFFFF">Year</font></b></th> <th style="width: 50px"><b><font color="#FFFFFF">Pic 1</font></b></th> </tr> $showlistbits </table> $footer </body> </html> Here's the REFBODY template: <tr> <td class=$altclass"> $omega[venue] </td> <td class=$altclass"> $omega[cyl] </td> <td class=$altclass"> $omega[color] </td> <td class=$altclass"> $omega[wheel] </td> <td class=$altclass"> $omega[year] </td> <td class=$altclass"> $omega[pic_1] </td> </tr> Two more things. I have a thumbnail pic and a full-size pic. When the table displays, I want the thumbnail to show but when you click on the thumbnail, I want the full-size pic to display in a new window. BTW, both the thumbnail and the full-size pics are stored on the server directory and not in MySQL. Also, I've noticed some people using conventions like $DB->... These conventions don't work on my server, however, I have verified that PEAR is installed on the server. Any advice in this area will also be greatly appreciated. Thanks in advance for your help. Shoolace --------------- Added [DATE]1230316112[/DATE] at [TIME]1230316112[/TIME] --------------- Fixed |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|