<?php
if(isset($_POST['form1'])) {
    $valid = 1;
    $error_message = '';
 
    $path = $_FILES['photo']['name'];
    $path_tmp = $_FILES['photo']['tmp_name'];
 
    if($path != '') {
        $ext = strtolower(pathinfo($path, PATHINFO_EXTENSION));
        $file_name = basename($path, '.' . $ext);
        if($ext != 'jpg' && $ext != 'png' && $ext != 'jpeg' && $ext != 'gif') {
            $valid = 0;
            $error_message .= 'You must upload a jpg, jpeg, gif or png file.<br>';
        }
    } else {
        $valid = 0;
        $error_message .= 'You must select a photo.<br>';
    }
 
    if($valid == 1) {
        // Auto increment ID'yi almak için doğru sütun adını kullanın
        $statement = $pdo->prepare("SHOW TABLE STATUS LIKE 'tbl_slider'");
        $statement->execute();
        $result = $statement->fetchAll();
        foreach($result as $row) {
            $ai_id=$row['Auto_increment']; 
        }
 
        $final_name = 'slider-' . $ai_id . '.' . $ext;
        move_uploaded_file($path_tmp, '../uploads/' . $final_name);
 
        $statement = $pdo->prepare("INSERT INTO tbl_slider (photo, heading, content, button_text, button_url, order, status) VALUES (?,?,?,?,?,?,?)");
        $statement->execute(array($final_name, $_POST['heading'], $_POST['content'], $_POST['button_text'], $_POST['button_url'], $_POST['slide_order'], $_POST['status']));
            
        $success_message = 'Slider added successfully!';
 
        // Form verilerini temizleyin
        unset($_POST['heading']);
        unset($_POST['content']);
        unset($_POST['button_text']);
        unset($_POST['button_url']);
        unset($_POST['slide_order']);
        unset($_POST['status']);
    }
}
?>