<?php
// MySQL-ga bog'liq ma'lumotlar
$mysqli = new mysqli("localhost", "foouser", "password", "dbname");

// Uzatma yuklash qatlamasi
if ($mysqli->connect_errno) {
    echo "Uzatma yuklashda xatolik yuz berdi: " . $mysqli->connect_error;
    exit();
}

// So'rov tayyorlash va bajarish
$query = "SELECT A, B FROM your_table";
$result = $mysqli->query($query);

// Natijani qabul qilish va B ustundagi qiymatni qo'rlash
while ($row = $result->fetch_assoc()) {
    $a_value = $row['A'];
    $b_value = $row['B'];

    // A ustundan olsadigan qiymat 4ta belgidan kam bo'lsa, B ustundagi qiymatni qo'rlash
    if (strlen($a_value) < 4) {
        $a_value = $b_value;
    }

    // Natijani chiqarish
    echo "A: " . $a_value . ", B: " . $b_value . "<br>";
}

// Uzatmani yopish
$mysqli->close();
?>

<?php

// Telegram bot token
$botToken = 'BOT_TOKEN';
// Telegram bot API URL
$apiUrl = 'https://api.telegram.org/bot' . $botToken . '/';
// Chat ID where you want to send the message
$chatId = 'CHAT_ID';

// Function to send a message via Telegram bot
function sendMessage($message) {
    global $apiUrl, $chatId;
    $url = $apiUrl . 'sendMessage?chat_id=' . $chatId . '&text=' . urlencode($message);
    file_get_contents($url);
}

// Function to get bitrate of a music file
function getBitrate($fileUrl) {
    $bitrate = shell_exec('ffprobe -v error -select_streams a:0 -show_entries stream=bit_rate -of default=nokey=1:noprint_wrappers=1 ' . $fileUrl);
    return $bitrate;
}

// Example usage
$fileUrl = 'URL_TO_YOUR_MUSIC_FILE';
$bitrate = getBitrate($fileUrl);
sendMessage('Bitrate of the music file is: ' . $bitrate . ' kbps');

<?php

// Telegram bot token
$botToken = 'BOT_TOKEN';
// Telegram bot API URL
$apiUrl = 'https://api.telegram.org/bot' . $botToken . '/';
// Chat ID where you want to send the message
$chatId = 'CHAT_ID';

// Function to send a photo via Telegram bot
function sendPhoto($photoPath, $caption = '') {
    global $apiUrl, $chatId;
    $url = $apiUrl . 'sendPhoto';
    $postFields = array('chat_id' => $chatId, 'photo' => new CURLFile(realpath($photoPath)), 'caption' => $caption);
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type:multipart/form-data"));
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $postFields);
    curl_exec($ch);
    curl_close($ch);
}

// Example usage
$musicFilePath = 'PATH_TO_YOUR_MUSIC_FILE';
$imagePath = 'PATH_TO_STORE_GENERATED_IMAGE'; // Change this path to where you want to store the generated image
$caption = 'Here is the cover art for the music file.';
$command = 'ffmpeg -i ' . $musicFilePath . ' -an -vcodec copy ' . $imagePath;
exec($command);
sendPhoto($imagePath, $caption);

   sudo apt install ffmpeg
   

// Function to send a video via Telegram bot
function sendVideo($videoPath, $caption = '') {
    global $apiUrl, $chatId;
    $url = $apiUrl . 'sendVideo';
    $postFields = array('chat_id' => $chatId, 'video' => new CURLFile(realpath($videoPath)), 'caption' => $caption);
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type:multipart/form-data"));
    curl_setopt($ch, CURLOPT_URL, $url);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $postFields);
    curl_exec($ch);
    curl_close($ch);
}

// Function to convert audio file to video using FFmpeg
function convertToVideo($audioPath, $videoPath) {
    $command = 'ffmpeg -i ' . $audioPath . ' -loop 1 -i background.jpg -c:a copy -c:v libx264 -shortest -pix_fmt yuv420p -vf "scale=trunc(iw/2)*2:trunc(ih/2)*2" ' . $videoPath;
    exec($command);
}

<?php

// Telegram bot token
$botToken = 'BOT_TOKEN';
// Telegram bot API URL
$apiUrl = 'https://api.telegram.org/bot' . $botToken . '/';
// Chat ID of the Telegram channel
$channelId = 'CHANNEL_ID';
// MySQL database credentials
$host = 'localhost';
$username = 'USERNAME';
$password = 'PASSWORD';
$database = 'DATABASE';

// Function to send a message via Telegram bot
function sendMessage($chatId, $message) {
    global $apiUrl;
    $url = $apiUrl . 'sendMessage?chat_id=' . $chatId . '&text=' . urlencode($message);
    file_get_contents($url);
}

// Function to insert post data into MySQL database
function insertPostData($messageId, $fileName) {
    global $host, $username, $password, $database;
    $conn = new mysqli($host, $username, $password, $database);
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $sql = "INSERT INTO posts (message_id, file_name) VALUES ('$messageId', '$fileName')";
    if ($conn->query($sql) === TRUE) {
        echo "New record inserted successfully";
    } else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }
    $conn->close();
}

// Function to check if a post exists in the database
function postExists($messageId) {
    global $host, $username, $password, $database;
    $conn = new mysqli($host, $username, $password, $database);
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $sql = "SELECT * FROM posts WHERE message_id = '$messageId'";
    $result = $conn->query($sql);
    $conn->close();
    return $result->num_rows > 0;
}

// Example usage
for ($i = 0; $i < 1000; $i++) {
    $audioFilePath = 'PATH_TO_YOUR_AUDIO_FILE'; // Change this path to your audio file
    $fileName = basename($audioFilePath);
    $message = 'Post ' . ($i + 1);
    
    // Send audio file to Telegram channel
    $audioUrl = 'https://example.com/' . $fileName; // Change this URL to your audio file URL
    $postUrl = $apiUrl . 'sendAudio?chat_id=' . $channelId . '&audio=' . urlencode($audioUrl) . '&caption=' . urlencode($message);
    $response = file_get_contents($postUrl);
    $responseData = json_decode($response, true);
    $messageId = $responseData['result']['message_id'];
    
    // Insert post data into MySQL database if not already exists
    if (!postExists($messageId)) {
        insertPostData($messageId, $fileName);
    }
    
    sleep(1); // Sleep for 1 second to avoid hitting API rate limits
}

if ($well) {
    bot('sendmessage', [
        'chat_id' => $chats_id,
        'text' => "Asslomu alaykum, <b>$chatn_id</b> ishonchli taksi xizmati kerak bo'lsa quyidagi botdan foydalaning.",
        'parse_mode' => 'html',
        'reply_markup' => json_encode([
            'inline_keyboard' => [
                [['text' => "Botdan foydalanish", 'url' => "https://t.me/taksi_navoiy_bot"]],
            ]
        ])
    ]);

    // 10 soniyadan so'ng xabar o'chiriladi
    bot('deleteMessage', [
        'chat_id' => $chats_id,
        'message_id' => $mid+1,
    ]);
}

exit();

if (!$connect) {
    die("Ulanishda xatolik: " . mysqli_connect_error());
}

if ($type == "supergroup" or ($type == "group" and $update->message->text)) {
    // kodni bajarish
}

if ($type == "group" and $update->message->text) {
    // kodni bajarish
}

if ($row['account_type'] == 'HAYDOVCHI' && $row['taxi_own_text'] !== NULL) {

if ($text == "/setting") {
    $result = $user->query("SELECT * FROM users WHERE user_id = '$user_id'");
    $resout = mysqli_fetch_array($result);
    $title = $resout['music'];
    $video = $resout['video'];
    $book = $resout['book'];
    $apk = $resout['apk'];
    $exe = $resout['exe'];
    $user->sendMessage([
        'chat_id' => $user_id,
        'message_id' => $mid,
        'text' => "⚙️ <b>SOZLAMALAR</b>

☑️ <i>Media fayllar qay tarzda qidirilishini sozlang.</i>",
        'parse_mode' => "html",
        'reply_markup' => json_encode([
            'inline_keyboard' => [
                [['text' => "🎧 Musiqa", 'callback_data' => " "], ['text' => "Sarlavha", 'callback_data' => "#title"], ['text' => "Ijrochi", 'callback_data' => "#perforemer"], ['text' => "Izoh", 'callback_data' => "#caption"]],
                [['text' => "🎬 Video", 'callback_data' => " "], ['text' => "Sarlavha", 'callback_data' => "#title"], ['text' => "Ijrochi", 'callback_data' => "#perforemer"], ['text' => "Izoh", 'callback_data' => "#caption"]],
                [['text' => "🎧 Kitob", 'callback_data' => " "], ['text' => "Sarlavha", 'callback_data' => "#title"], ['text' => "Ijrochi", 'callback_data' => "#perforemer"], ['text' => "Izoh", 'callback_data' => "#caption"]],
                [['text' => "📚 APK", 'callback_data' => " "], ['text' => "Sarlavha", 'callback_data' => "#title"], ['text' => "Ijrochi", 'callback_data' => "#perforemer"], ['text' => "Izoh", 'callback_data' => "#caption"]],
                [['text' => "💻 Dekstop", 'callback_data' => " "], ['text' => "Sarlavha", 'callback_data' => "#title"], ['text' => "Ijrochi", 'callback_data' => "#perforemer"], ['text' => "Izoh", 'callback_data' => "#caption"]],
            ]
        ]),
    ]);
    exit();
}