Lista coduri

query_vars['wu_lc_search'])) { $keyword = urldecode($wp_query->query_vars['wu_lc_search']); } $output = ''; } return $output; } /* * RESULTS for CODES LIST * */ add_shortcode('wu-codes-list-results', 'codes_list_results'); function codes_list_results() { global $wpdb; global $wp_query; global $post; $output = ''; $page = 1; $keyword = ''; $search_or_not = ''; if(isset($wp_query->query_vars['wu_lc_page'])) { $page = urldecode($wp_query->query_vars['wu_lc_page']); } if(isset($wp_query->query_vars['wu_lc_search'])) { $keyword = urldecode($wp_query->query_vars['wu_lc_search']); $search_or_not = $keyword . '/'; } $post_per_page = 20; $offset = ($page - 1) * $post_per_page; $query = "SELECT * FROM wu_lista_coduri_piese WHERE cod LIKE '%" . $keyword . "%'"; $total_record = count($wpdb->get_results($query, ARRAY_A)); $max_num_pages = ceil($total_record / $post_per_page); $wp_query->found_posts = $total_record; $wp_query->max_num_pages = $max_num_pages; $limit_query = " LIMIT " . $post_per_page . " OFFSET " . $offset; // If results - build OUTPUT $results = $wpdb->get_results($query . $limit_query, OBJECT); if($results) { // CSS ?>

Cod piesă	Producător	Pret