Name: INOXBONOMI CASA KITCHEN KNIFE 16 Cm
Brand: INOXBONOMI
SKU: 8007684907702
Availability: InStock

function phenix_render_new_products() { global $wpdb; $table = $wpdb->prefix . 'phenix_new_products'; // التقاط الفلاتر $search = isset($_GET['search']) ? sanitize_text_field($_GET['search']) : ''; $min_qty = isset($_GET['min_qty']) ? intval($_GET['min_qty']) : ''; $sort_by = isset($_GET['sort_by']) ? sanitize_text_field($_GET['sort_by']) : 'id'; $order = isset($_GET['order']) && strtolower($_GET['order']) === 'desc' ? 'DESC' : 'ASC'; // إعدادات الترقيم $per_page = 20; $paged = max(1, intval($_GET['paged'] ?? 1)); $offset = ($paged - 1) * $per_page; // بناء الشرط $where = "WHERE 1=1"; if ($search) { $where .= $wpdb->prepare(" AND (name LIKE %s OR sku LIKE %s)", "%$search%", "%$search%"); } if ($min_qty !== '') { $where .= $wpdb->prepare(" AND quantity >= %d", $min_qty); } // الحصول على عدد الصفوف $total_items = $wpdb->get_var("SELECT COUNT(*) FROM $table $where"); // الحصول على النتائج مع ترقيم $sql = "SELECT * FROM $table $where ORDER BY $sort_by $order LIMIT $per_page OFFSET $offset"; $products = $wpdb->get_results($sql); // واجهة البحث والفلترة echo '

🛒 New Products

'; echo ''; // الجدول echo ''; echo ''; if (!empty($products)) { foreach ($products as $p) { echo ""; } } else { echo ''; } echo '

ID	Name	SKU	Quantity	Price	Offer Price
{$p->id}	{$p->name}	{$p->sku}	{$p->quantity}	{$p->price}	{$p->offer_price}
No matching products found.

'; // الترقيم $total_pages = ceil($total_items / $per_page); if ($total_pages > 1) { echo '

'; $base_url = remove_query_arg('paged'); for ($i = 1; $i <= $total_pages; $i++) { $url = add_query_arg('paged', $i, $base_url); $class = ($i == $paged) ? ' class="current-page button"' : ' class="button"'; echo "$i "; } echo '

'; } echo '