<?php
require_once '/../../controller/productos.php';
$producto = new productos();
$producto->listarProductos();
?>
<html>
<?php
require_once APPLICATION_PATH . '/layout/header.php';
?>
<link rel="stylesheet" type="text/css" href="pcss/productos.css" media="screen" />
<body>
<div id="imPage">
<div id="imHeader">
<h1 class="imHidden">ITERA S.A.C</h1>
</div>
<a class="imHidden" href="#imGoToCont" title="Salta el menu principal">Vaya al Contenido</a>
<a id="imGoToMenu"></a><p class="imHidden">Menu Principal</p>
<?php
require_once APPLICATION_PATH . '/layout/menu.php';
?>
<div id="imContentGraphics"></div>
<div id="imContent">
<a id="imGoToCont"></a>
<h2 id="imPgTitle">Productos</h2>
<div style="width: 984px; float: left;">
<div id="imCell_1" class="imGrid[0, 0]"><div id="imCellStyleGraphics_1"></div><div id="imCellStyle_1"><div id="imObjectImage_1"><div id="imObjectImageContent_1"></div></div><script type="text/javascript">var flashvars = {containerId: "imObjectImage_1", key: "211206165160216183098145169131118136175191176133099207227213", cWidth: "970", cHeight: "224", copyright: "© Copyright 2011 por ITERA S.A.C Todos los derechos reservados.", watermark: "false", cpindex: "147519"}; var params = {quality: "high", bgcolor: "#ffffff", play: "true", loop: "true", wmode: "transparent", scale: "noscale", menu: "true", devicefont: "false", salign: "lt", allowscriptaccess: "sameDomain", allowFullScreen: "true"}; var attributes = {id: "imObjectImageContent_1", name: "imObjectImageContent_1", align: "middle"}; swfobject.embedSWF("/res/imImage.swf", "imObjectImageContent_1", "970", "224", "10.0.0", "res/expressInstall.swf", flashvars, params, attributes);</script></div></div>
</div>
<div style="width: 984px; float: left;">
<div style="float: left; width: 164px;">
<?php
class productos
{
public function listarProductos($buscar, $bd)
{
// require_once '../../general/conexion.php';
require_once '../../general/' . $bd;
$db = new Db();
$db->conectar($bd);
$datos = '';
$strSQL = "\r\n SELECT DISTINCT P.strProductos\r\n FROM tbproductos P\r\n WHERE P.strProductos LIKE '%" . $buscar . "%'\r\n ORDER BY P.strProductos ASC\r\n ";
$stmt = $db->ejecutar($strSQL);
$db->desconectar();
while ($row = mysql_fetch_array($stmt, MYSQL_ASSOC)) {
$datos[] = array("value" => $row['strProductos']);
}
return $datos;
}
}
$producto = new productos();
echo json_encode($producto->listarProductos($_GET['term'], $_GET['bd']));
