Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Adding search function to the page


Irin

Recommended Posts

Hello. I'm trying to add a search box on my item export page in admin panel, so when a list of products is populated, I can look up a specific product on that list by keywords (name, model). I managed to add a Search box on the page, but when I input my keywords, nothing happens, the page just refreshes, but doesn't show the product that I'm looking for. There is obviously something that I'm missing here. Any help will be appreciated. Here is the code on my item_export.php page:

<?php
require('includes/application_top.php');
if (!$_POST['submit'])
{
 ?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//DE">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
<!--- BOF Simple Search Box //-->
<script language="JavaScript" type="text/javascript">
function clearDefault(dw) {
 if (dw.defaultValue==dw.value) dw.value = ""
}
function Default(w) {
 if (w.value=="") w.value = "<?php echo SEARCH_VALUE; ?>"
}
</script>
<!--- EOF Simple Search Box //-->
</head>
<body id="products">
<!-- header //-->
<?php require(DIR_WS_INCLUDES.'header.php'); ?>
<!-- header_eof //-->
<!-- body //-->
<table border="0" width="100%" cellspacing="2" cellpadding="2">
 <tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">
	<!-- left_navigation //-->
	<?php require(DIR_WS_INCLUDES.'column_left.php'); ?>
	<!-- left_navigation_eof //-->
  </table></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
	<tr>
	  <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
	</tr>
	<tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
	<tr>
	  <td><?php echo tep_draw_form(BOX_EXPORT_ITEMS, FILENAME_EXPORT_ITEMS, '', 'post'); ?>
		<table border="0" width="100%" cellspacing="0" cellpadding="0">
		  <tr>
			<td class="main"><?php echo TABLE_HEADING_EXPORT_ITEMS; ?>  
<?php
  if ($exportfile->Export == "") {
?>
 <A target="_blank" href="product_export.php?export=html&<?php echo tep_get_all_get_params(array('action')) ?>"><IMG
		title="Printer Friendly" height=16 alt="Printer Friendly"
		src="images/print.gif" width=16
		border=0></A>
 <A href="product_export.php?export=excel&<?php echo tep_get_all_get_params(array('action')) ?>"><IMG
		title="Export to Excel" height=16 alt="Export to Excel"
		src="images/exportxls.gif" width=16
		border=0></A>
 <A href="product_export.php?export=word&<?php echo tep_get_all_get_params(array('action')) ?>"><IMG
		title="Export to Word" height=16 alt="Export to Word"
		src="images/exportdoc.gif" width=16
		border=0></A>
 <a href="product_export.php?export=csv&<?php echo tep_get_all_get_params(array('action')) ?>"><IMG
		title="Export to csv" height=16 alt="Export to csv"
		src="images/exportcsv.gif" width=16
		border=0></a>
<?php
}
else {
}
?>
		  </td>
		  </tr>
		  <tr>
			<td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
		  </tr>
		  <tr>
			<td class="main">
			<form name="quick_find" action="item_export.php" method="get">
  <table width="1" border="0" style="background: black; vertical-align: bottom;">
  <tr>
	<td>
	  <div align="right">
		  <!-- This is the input box to enter keywords etc -->
		<!--- BOF Simple Search Box //-->
		<input type="text" name="keywords" maxlength="30" value="Search..." onFocus="clearDefault(this)" onBlur="Default(this)">
		<!--- EOF Simple Search Box //-->
		<input type="hidden" name="search_in_description" value="1" />
		<input type="hidden" name="inc_subcat" value="1" />
		  </div>
	</td>
	  <td>
	  <div align="left" style="border: 1px solid #333333;">
		  <!-- OSC Search Submit Button Below -->
		<?php echo tep_image_submit('button_search.gif', HEADING_TITLE_SEARCH); ?>
		<!-- Default Gray Search Submit Button Below -->
		<!--<input type="submit" name="search" value="Search" class="formfield" border="0" width="79" height="25">-->
	  </div>
	</td>
	</tr>
  </table>
</form>
			  <table border="1" width="100%" cellspacing="0" cellpadding="2">
				<tr class="dataTableHeadingRow">
				  <td class="dataTableHeadingContent">ID</td>
				  <td class="dataTableHeadingContent">Name</td>
				  <td class="dataTableHeadingContent">Model</td>
				  <td class="dataTableHeadingContent">Description</td>
				  <td class="dataTableHeadingContent">Quantity</td>
				  <td class="dataTableHeadingContent">Price</td>
				</tr>
				<?php
$products_query_raw = "select p.products_id, pd.products_name, p.products_model, pd.products_description, p.products_quantity, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'order by p.products_id";
$products_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows);
$products_query = tep_db_query($products_query_raw);
while ($products = tep_db_fetch_array($products_query)) {
?>
			 <tr class="dataTableRow">
				<td class="dataTableContent"><b><?php echo $products['products_id']; ?></b></td>
				  <td class="dataTableContent"><?php echo $products['products_name']; ?></td>
				  <td class="dataTableContent"><?php echo $products['products_model']; ?></td>
				  <td class="dataTableContent"><?php echo $products['products_description']; ?></td>
				  <td class="dataTableContent"><?php echo $products['products_quantity']; ?></td>
				  <td class="dataTableContent"><?php
 if(($products['products_price1_qty'] > 0) && ($products['products_price2_qty'] > 0)) {
echo $products['products_price1_qty'] . ' - ' . $products['products_price2_qty'] . ': $' . $products['products_price1'] . '<br>';
}
if(($products['products_price1_qty'] > 0) && ($products['products_price2_qty'] < 1)) {
  echo $products['products_price1_qty'] . ' + : $' . $products['products_price1'] . '<br>';
}
if(($products['products_price2_qty'] > 0) && ($products['products_price3_qty'] > 0)) {
echo $products['products_price2_qty'] . ' - ' . $products['products_price3_qty'] . ': $' . $products['products_price2'] . '<br>';
}
if(($products['products_price2_qty'] > 0) && ($products['products_price3_qty'] < 1)) {
  echo $products['products_price2_qty'] . ' + : $' . $products['products_price2'] . '<br>';
}
if(($products['products_price3_qty'] > 0) && ($products['products_price4_qty'] > 0)) {
echo $products['products_price3_qty'] . ' - ' . $products['products_price4_qty'] . ': $' . $products['products_price3'] . '<br>';
}
if(($products['products_price3_qty'] > 0) && ($products['products_price4_qty'] < 1)) {
  echo $products['products_price3_qty'] . ' + : $' . $products['products_price3'] . '<br>';
}
if(($products['products_price4_qty'] > 0) && ($products['products_price5_qty'] > 0)) {
echo $products['products_price4_qty'] . ' - ' . $products['products_price5_qty'] . ': $' . $products['products_price4'] . '<br>';
}
if(($products['products_price4_qty'] > 0) && ($products['products_price5_qty'] < 1)) {
  echo $products['products_price4_qty'] . ' + : $' . $products['products_price4'] . '<br>';
}
if(($products['products_price5_qty'] > 0) && ($products['products_price6_qty'] > 0)) {
echo $products['products_price5_qty'] . ' - ' . $products['products_price6_qty'] . ': $' . $products['products_price5'] . '<br>';
}
if(($products['products_price5_qty'] > 0) && ($products['products_price6_qty'] < 1)) {
  echo $products['products_price5_qty'] . ' + : $' . $products['products_price5'] . '<br>';
}
if(($products['products_price6_qty'] > 0) && ($products['products_price7_qty'] > 0)) {
echo $products['products_price6_qty'] . ' - ' . $products['products_price7_qty'] . ': $' . $products['products_price6'] . '<br>';
}
if(($products['products_price6_qty'] > 0) && ($products['products_price7_qty'] < 1)) {
  echo $products['products_price6_qty'] . ' + : $' . $products['products_price6'] . '<br>';
}
if(($products['products_price7_qty'] > 0) && ($products['products_price8_qty'] > 0)) {
echo $products['products_price7_qty'] . ' - ' . $products['products_price8_qty'] . ': $' . $products['products_price7'] . '<br>';
}
if(($products['products_price7_qty'] > 0) && ($products['products_price8_qty'] < 1)) {
  echo $products['products_price7_qty'] . ' + : $' . $products['products_price7'] . '<br>';
}
if($products['products_price8_qty'] > 0) {
echo $products['products_price8_qty'] . ' + : $' . $products['products_price8'];
}
?></td>
				</tr>
<?php
}
?>
			  </table>
			  </td>
		  </tr>
		  <tr>
			<td colspan="4"><table border="0" width="100%" cellspacing="0" cellpadding="2">
			  <tr>
				<td class="smallText" valign="top"><?php echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td>
				<td class="smallText" align="right"><?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'info', 'x', 'y', 'cID'))); ?></td>
			  </tr>
			 </td>
		   </tr>
		  <tr>
			<td> </td>
		  </tr>
		</table>
		</form>
	  </td>
	</tr>
  </table></td>
 </tr>
</table>
<!-- footer //-->
<center>
 <font color="#666666" size="2"></font>
</center>
<!-- footer_eof //-->
<br>
</body>
</html>
<?php
}
require(DIR_WS_INCLUDES . 'application_bottom.php');
?>

 

Thank you!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...