Gecko [ eachadeal.com ]

Linux host2.homegym.sg 4.18.0-553.8.1.el8_10.x86_64 #1 SMP Tue Jul 2 07:26:33 EDT 2024 x86_64
Apache
Server IP : 159.223.38.192 & Your IP : 159.223.38.192
Domains : 20 Domain
User : eachadea

Name	Size	Permission	Date
tiny_mce	[ DIR ]	drwxr-xr-x	2012-07-05 12:13
error_log	3.68 KB	-rw-r--r--	2012-07-04 17:19
getProduct.php	1.4 KB	-rw-r--r--	2012-07-05 13:40
login.php	1.77 KB	-rw-r--r--	2012-07-06 09:14
session_head.php	261 B	-rw-r--r--	2012-07-06 09:13
update.php	1.09 KB	-rw-r--r--	2012-07-06 09:04

Rename

<?php

require_once 'session_head.php';

$write = Mage::getSingleton('core/resource')->getConnection('core_write');

$input = stripslashes($_POST['input']);

// now $write is an instance of Zend_Db_Adapter_Abstract
$products = $write->query("SELECT `value` AS product_name FROM catalog_product_entity_varchar WHERE entity_type_id = (SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = 'catalog_product') AND attribute_id = (SELECT attribute_id FROM eav_attribute WHERE attribute_code = 'name' AND entity_type_id = (SELECT entity_type_id FROM eav_entity_type WHERE entity_type_code = 'catalog_product'))");

while ($row = $products->fetch() ) {

$pos = stripos($input, $row['product_name']);
if ($pos === false) { // note: three equal signs
    
}
else
{
$matched_products[] = $row['product_name'];
}
	
}

<form id="form_442309" class="appnitro"  method="post" action="">
										
		
		<table>
			<tr><th>Qty</th><th>Name</th><th>Price</th></tr>
			<?php 
			foreach ($matched_products as $key=>$products) {
				echo '<tr><td><select name="qty_"'.$key.'>';
				for ($i=0;$i<1000;$i++) {
					echo '<option value="'.$i.'"';
					if ($i == 1)
						echo ' selected="true"';
					echo '>'.$i.'</option>';
				}
				echo '</select></td><td>'.$products.'</td><td></td></tr>';
			}
			?>
		</table>
		<input type="submit" name="mysubmit" value="Click!" />
		</form>