connect_error) { die('Connection failed: ' . $mysqli->connect_error); } // Get image URLs and stock data from database $sql = 'SELECT * FROM stok'; $result = $mysqli->query($sql); if ($result->num_rows > 0) { // Loop through each result and send message with photo while ($row = $result->fetch_assoc()) { // Get photo URL from database $photo_url = 'http://takip.kalaci.net/' . $row['StokPic']; // Create caption with stock information $caption = 'Ayakkabı Stokları:' . PHP_EOL . PHP_EOL; $caption .= 'Stok Kodu: ' . $row['StokCode'] . PHP_EOL; if ($row['otuzalti'] > 0) { $caption .= '36: ' . $row['otuzalti'] . '' . PHP_EOL; } if ($row['otuzyedi'] > 0) { $caption .= '37: ' . $row['otuzyedi'] . '' . PHP_EOL; } if ($row['otuzsekiz'] > 0) { $caption .= '38: ' . $row['otuzsekiz'] . '' . PHP_EOL; } if ($row['otuzdokuz'] > 0) { $caption .= '39: ' . $row['otuzdokuz'] . '' . PHP_EOL; } if ($row['kirk'] > 0) { $caption .= '40: ' . $row['kirk'] . '' . PHP_EOL; } if ($row['kirkbir'] > 0) { $caption .= '41: ' . $row['kirkbir'] . '' . PHP_EOL; } if ($row['kirkiki'] > 0) { $caption .= '42: ' . $row['kirkiki'] . '' . PHP_EOL; } if ($row['kirkuc'] > 0) { $caption .= '43: ' . $row['kirkuc'] . '' . PHP_EOL; } if ($row['kirkdort'] > 0) { $caption .= '44: ' . $row['kirkdort'] . '' . PHP_EOL; } if ($row['kirkbes'] > 0) { $caption .= '45: ' . $row['kirkbes'] . '' . PHP_EOL; } // Send photo with caption $data = [ 'chat_id' => '-1001612114603', // Replace with your chat ID 'photo' => $photo_url, 'caption' => $caption, 'parse_mode' => 'HTML', 'disable_notification' => true, // Disable notification for silent updates ]; $result = Request::sendPhoto($data, '5962914293:AAFeRA5nIIlk607fGlWuDqFXEvlEUgAhkmQ'); // Replace with your API key if ($result->isOk()) { echo 'Message sent successfully'; } else { echo 'Error sending message: ' . $result->getDescription(); } // Wait for 5 seconds before sending the next photo sleep(5); } // Close database connection $mysqli->close(); ?>