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.
BTW, I posted the same information in the regular discussion forum but haven't received any feedback yet....
Thanks in advance for your help.
Shoolace
--------------- Added [DATE]1230305614[/DATE] at [TIME]1230305614[/TIME] ---------------
Never mind... figured it out by myself.
Here's the PHP code that was missing...
$i++;
Thanks
More Information