<?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']));