Tablouri Canvas - GALERIE

0 && $search < 5000 ) { str_pad($search, 4, '0', STR_PAD_LEFT); }else { $search = $search; } $search = strtolower($search); if ($search == 'per' || $search == 'personalizare' || $search == 'personalizate' || $search == 'personalizat'|| $search == 'tablouri personalizat' || $search == 'tablouri personalizate' || $search == 'tablouri personalizare' || $search == 'tablou personalizat' || $search == 'tablou personalizate' || $search == 'tablou personalizare' || $search == 'poza' || $search == 'cu poza') { echo ""; exit(0); }else { if($filter_texture == '') { $textureFilter = " WHERE texture_number LIKE '%$search%' ".$forma_texture_sql." OR texture_name LIKE '%$search%' ".$forma_texture_sql." OR texture_name_eng LIKE '%$search%' ".$forma_texture_sql." OR texture_long_name LIKE '%$search%' ".$forma_texture_sql." OR texture_long_name_eng LIKE '%$search%' ".$forma_texture_sql." OR texture_keywords LIKE '%$search%' ".$forma_texture_sql." OR texture_keywords_eng LIKE '%$search%' ".$forma_texture_sql." OR texture_colors LIKE '%$search%' ".$forma_texture_sql." OR texture_colors_eng LIKE '%$search%' ".$forma_texture_sql." OR texture_tags LIKE '%$search%' ".$forma_texture_sql." OR texture_tags_eng LIKE '%$search%' ".$forma_texture_sql." OR texture_special LIKE '%$search%' ".$forma_texture_sql." "; $selectedTag = 'Toate'; } else { $textureFilter = " WHERE texture_number LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." OR texture_name LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." OR texture_name_eng LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." OR texture_long_name LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." OR texture_long_name_eng LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." OR texture_keywords LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." OR texture_keywords_eng LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." OR texture_colors LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." OR texture_colors_eng LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." OR texture_tags LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." OR texture_tags_eng LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." OR texture_special LIKE '%$search%' AND texture_keywords LIKE '%".$filter_texture."%' ".$forma_texture_sql." "; $selectedTag = $filter_texture; } } } // Get products from database 0_table_textures_publish // ORDER BY texture_id DESC // $result = $db->query("SELECT * FROM 0_table_textures_publish $textureFilter ORDER BY RAND() LIMIT $limit OFFSET $offset"); $result = $db->query("SELECT * FROM 0_table_textures_publish $textureFilter ORDER BY texture_id DESC LIMIT $limit OFFSET $offset"); $queryResult = mysqli_num_rows($result); // Get products from database 0_table_textures_publish FOR COUNT TOTAL PRODUCTS $result2 = $db->query("SELECT * FROM 0_table_textures_publish $textureFilter "); $queryResult_for_page = mysqli_num_rows($result2); // Here we have the total row count $total_rows = $queryResult_for_page[0]; $offset2 = $limit+$offset; $total_pages = $queryResult_for_page / $limit; $last = ceil($queryResult_for_page / $limit); $total_pages = ceil($total_pages); if ($page > $last) { $page = $last; } ?>