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();
?>