function accessDB($cod, $tabla) { //DATABASE work $database = new pdodatabase(); $values = array("*"); $conditions = array("cod" => $cod); $sql = $database->createSelect($tabla, $values, $conditions); $datos = $database->execSelect($sql, $conditions); if ($datos != false) { $row = $datos->fetch(PDO::FETCH_ASSOC); foreach ($row as $key => $value) { $producto[$row['cod']][$key] = $value; } return $producto; } }
function listProduct() { //DATABASE work $database = new pdodatabase(); $values = array("*"); $sql = $database->createSelect("producto", $values, $conditions); $datos = $database->execSelect($sql, null); if ($datos != false) { //list all the products while ($row = $datos->fetch()) { $productos[$row['nombre_corto']][0] = $row['PVP']; if ($row['familia'] === "ORDENA") { $productos[$row['nombre_corto']][1] = $row['cod']; } } return $productos; } }