connect_error){ die("Connection failed: " . $conn->connect_error); } $conn->set_charset("utf8"); // ------------------ گرفتن محصولات ------------------ $sql = "SELECT * FROM products WHERE status=1"; $result = $conn->query($sql); // ------------------ ایجاد فید شبانه ------------------ $file = fopen("torob-feed-power.php","w"); // بازنویسی فایل اصلی fwrite($file, "';\n"); fwrite($file, "echo '';\n"); while($row = $result->fetch_assoc()){ $link = "https://lavasemkhangi.ir/product/".$row['slug']; $title = str_replace(['خرید','ارزان','اصل','اورجینال','قیمت','جدید','ارسال سریع','با گارانتی'],'',$row['title']); preg_match('/[A-Za-z0-9\-]{3,}/', $title, $matches); $model = $matches[0] ?? ''; $final_title = $row['brand'].' '.$title; if($model != '') $final_title .= ' مدل '.$model; $productXML = " {$row['id']} {$link} https://lavasemkhangi.ir/uploads/{$row['image']} {$row['price']} IRR ".($row['stock']>0?'in stock':'out of stock')." \n"; fwrite($file, "echo '".addslashes($productXML)."';\n"); } fwrite($file, "echo '';\n"); fwrite($file, "?>"); fclose($file); $conn->close(); ?> getMessage()); } // گرفتن محصولات فعال $stmt = $pdo->prepare("SELECT id, name, price, stock, description, image, category, brand FROM products WHERE status='active'"); $stmt->execute(); $products = $stmt->fetchAll(PDO::FETCH_ASSOC); // شروع XML echo ''; echo ""; foreach($products as $p) { echo ""; echo "{$p['id']}"; echo ""; echo "{$p['price']}"; echo "{$p['stock']}"; echo "https://lavasemkhangi.ir/product.php?id={$p['id']}"; echo "{$p['image']}"; echo ""; echo ""; echo ""; echo ""; } echo ""; ?>

پیگیری سفارش

برگشت به بالا