La gama de productos que pueden ser puestos a disposición de los usuarios es muy amplia
CATÁLOGO
\n");
$db = Conectarse();
// now, retrieve all descendants of the $root node
$sql = "SELECT * from taxons WHERE `parent_id` IS NULL ORDER BY 'position'";
$result = mysql_query($sql ,$db);
// display each row
while ($row = mysql_fetch_array($result)) {
//printf("\n");
printf("\n");
}
mysql_free_result($result);
mysql_close($db);
printf("
\n");
}
function pintaSubCategorias($categoria, $nombreCategoria, $subCategoria){
printf("\n");
printf("
\n");
if($contador==1 && ($subCategoria==null || $subCategoria=="" || !is_numeric($subCategoria))){
pintaProductosSubCategoria($_subCategoria, $_nombreSubCategoria);
}
}
function pintaProductosSubCategoria($subCategoria, $nombreSubCategoria){
printf("".$nombreCategoria."
\n"); $db = Conectarse(); // now, retrieve all descendants of the $root node $sql = "SELECT * from taxons WHERE `parent_id`=".$categoria." ORDER BY 'position'"; $result = mysql_query($sql ,$db); $contador=0; // display each row while ($row = mysql_fetch_array($result)) { $contador++; $_subCategoria = $row['id']; $_nombreSubCategoria = utf8_encode($row['name']); printf("\n"); } mysql_free_result($result); mysql_close($db); printf("\n");
printf("
\n");
}
function pintaProductosBuscados($filtro){
printf("\n");
printf("".$nombreSubCategoria."
\n"); $db = Conectarse(); // now, retrieve all descendants of the $root node $sql = "SELECT products.id as id, products.description as description, products.name as name FROM products JOIN products_taxons ON products.id=products_taxons.product_id WHERE products_taxons.taxon_id=".$subCategoria." ORDER BY products.name"; $result = mysql_query($sql ,$db); // display each row while ($row = mysql_fetch_array($result)) { $sql2 = "SELECT id FROM product_images WHERE product_id=".$row['id']; $result2 = mysql_query($sql2 ,$db); while ($row2 = mysql_fetch_array($result2)) { $id_image = $row2['id']; $sql3 = "SELECT filename, thumbnail FROM product_images WHERE parent_id=".$id_image; $result3 = mysql_query($sql3 ,$db); $name_image_medium = ""; $name_image_thumb = ""; while ($row3 = mysql_fetch_array($result3)) { $thumbnail= $row3['thumbnail']; if($thumbnail!=null && $thumbnail=="thumb"){ $name_image_thumb = utf8_encode($row3['filename']); }else if($thumbnail!=null && $thumbnail=="medium"){ $name_image_medium = utf8_encode($row3['filename']); } } } $product_name = utf8_encode($row['name']); $product_description = utf8_encode($row['description']); printf("\n");
if($id_image!=null&&$id_image!=""){
if($id_image < 10) $id_image = "000".$id_image;
else if($id_image < 100 && $id_image >= 10) $id_image = "00".$id_image;
else if($id_image < 1000 && $id_image >= 100) $id_image = "0".$id_image;
else if($id_image < 10000 && $id_image >= 1000) $id_image = $id_image;
printf("![\"".$product_description."\"](\"http://catalogo.nexofreelance.com/files/0000/".$id_image."/".$name_image_thumb."\")
\n");
}else{
printf("![](\"http://catalogo.nexofreelance.com/files/default.png\")
\n");
}
printf("
\n");
$name_image_medium = "";
$name_image_thumb = "";
$id_image = "";
mysql_free_result($result2);
}
mysql_free_result($result);
mysql_close($db);
printf("\n");
printf("
\n");
printf("".$product_name."
\n");
//printf("".$product_description."
\n");
printf("\n");
printf("
\n");
}
pintaCategorias();
if($operacion=="s"){
$categoria = $_POST['c'];
$subCategoria = $_POST['sc'];
$filtro = $_POST['filtro'];
if($filtro!=null&&$filtro!=""){
pintaProductosBuscados($filtro);
}
}
if($categoria!=null && $categoria!="" && is_numeric($categoria)){
pintaSubCategorias($categoria, $nombreCategoria, $subCategoria);
if($subCategoria!=null && $subCategoria!="" && is_numeric($subCategoria)){
pintaProductosSubCategoria($subCategoria, $nombreSubCategoria);
}
}
?>
Resultados de la búsqueda
\n"); $db = Conectarse(); // now, retrieve all descendants of the $root node $sql = "SELECT * FROM products WHERE name like CONCAT('%', '".$filtro."','%') or description like CONCAT('%', '".$filtro."','%') ORDER BY name"; mysql_set_charset('utf8', $db); //$charset = mysql_client_encoding($db); //echo "The current character set is: $charset\n"; $result = mysql_query($sql ,$db); $noEncontrado=true; // display each row while ($row = mysql_fetch_array($result)) { printf("Encontrados.
\n"); $noEncontrado=false; $sql2 = "SELECT id FROM product_images WHERE product_id=".$row['id']; $result2 = mysql_query($sql2 ,$db); while ($row2 = mysql_fetch_array($result2)) { $id_image = $row2['id']; $sql3 = "SELECT filename, thumbnail FROM product_images WHERE parent_id=".$id_image; $result3 = mysql_query($sql3 ,$db); $name_image_medium = ""; $name_image_thumb = ""; while ($row3 = mysql_fetch_array($result3)) { $thumbnail= $row3['thumbnail']; if($thumbnail!=null && $thumbnail=="thumb"){ //$name_image_thumb = utf8_encode($row3['filename']); $name_image_thumb = $row3['filename']; }else if($thumbnail!=null && $thumbnail=="medium"){ //$name_image_medium = utf8_encode($row3['filename']); $name_image_medium = $row3['filename']; } } } //$product_name = utf8_encode($row['name']); //$product_description = utf8_encode($row['description']); $product_name = $row['name']; $product_description = $row['description']; printf("\n");
if($id_image!=null&&$id_image!=""){
if($id_image < 10) $id_image = "000".$id_image;
else if($id_image < 100 && $id_image >= 10) $id_image = "00".$id_image;
else if($id_image < 1000 && $id_image >= 100) $id_image = "0".$id_image;
else if($id_image < 10000 && $id_image >= 1000) $id_image = $id_image;
printf("\n");
}else{
printf("\n");
}
printf("
\n");
$name_image_medium = "";
$name_image_thumb = "";
$id_image = "";
mysql_free_result($result2);
}
if($noEncontrado) printf("\n");
printf("
\n");
printf("".$product_name."
\n");
//printf("".$product_description."
\n");
printf("Su búsqueda no produjo ningún resultado, inténtelo de nuevo siendo menos preciso o póngase en contacto con nosotros. Gracias.
\n"); mysql_free_result($result); mysql_close($db); printf("
