J'ai un formulaire pour ajouter une video et d'autres informations dans une base de données mais ça n'a pas marché. Les données ne sont pas ajoutées dans la base de données et j'obtient ce résultat.
Code : Tout sélectionner
Array
(
)
Array
(
)Code : Tout sélectionner
<?php
include '../components/connect.php';
if(isset($_COOKIE['tutor_id'])){
$tutor_id = $_COOKIE['tutor_id'];
}else{
$tutor_id = '';
header('location:login.php');
}
echo '<pre>'; print_r($_FILES); echo '</pre>'; // Valorisé ?
echo '<pre>'; print_r($_POST); echo '</pre>'; // Valorisé ?
if(isset($_POST['submit'])){
echo "[DEBUG] tutor_id=[{$tutor_id}], title=[{$title}], description=[{$description}]";
$id = create_unique_id();
$status = $_POST['status'];
$status = filter_var($status, FILTER_SANITIZE_STRING);
$title = $_POST['title'];
$title = filter_var($title, FILTER_SANITIZE_STRING);
$description = $_POST['description'];
$description = filter_var($description, FILTER_SANITIZE_STRING);
$playlist_id = $_POST['playlist'];
$playlist_id = filter_var($playlist_id, FILTER_SANITIZE_STRING);
$thumb = $_FILES['thumb']['name'];
$thumb = filter_var($thumb, FILTER_SANITIZE_STRING);
$thumb_ext = pathinfo($thumb, PATHINFO_EXTENSION);
$rename_thumb = create_unique_id().'.'.$thumb_ext;
$thumb_size = $_FILES['thumb']['size'];
$thumb_tmp_name = $_FILES['thumb']['tmp_name'];
$thumb_folder = '../uploaded_files/'.$rename_thumb;
$video = $_FILES['video']['name'];
$video = filter_var($video, FILTER_SANITIZE_STRING);
$video_ext = pathinfo($video, PATHINFO_EXTENSION);
$rename_video = create_unique_id().'.'.$video_ext;
$video_tmp_name = $_FILES['video']['tmp_name'];
$video_size= $_FILES['video']['size'];
$video_folder = '../uploaded_files/'.$rename_video;
$verify_content=$conn->perepare("select * from 'content' where tutor_id= ? and title=?and description=? ");
$verify_content->execute([$tutor_id,$title,$description]);
if($verify_content->rowCount()>0){
$message[] = 'content already created!';
}else{
$add_content = $conn->prepare("INSERT INTO `content`(id, tutor_id, playlist_id, title, description, video, thumb, status) VALUES(?,?,?,?,?,?,?,?)");
$add_content->execute([$id, $tutor_id, $playlist_id, $title, $description, $rename_video, $rename_thumb, $status]);
move_uploaded_file($thumb_tmp_name, $thumb_folder);
move_uploaded_file($video_tmp_name, $video_folder);
$message[] = 'new course uploaded!';
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Dashboard</title>
<!-- custom css file link -->
<link rel="stylesheet" href="../css/admin_style.css">
</head>
<body>
<?php include '../components/admin_header.php'; ?>
<section class="video-form">
<h1 class="heading">upload content</h1>
<form action="" method="post" enctype="multipart/form-data">
<p>video status <span>*</span></p>
<select name="status" class="box" required>
<option value="" selected disabled>-- select status</option>
<option value="active">active</option>
<option value="desactive">desactive</option>
</select>
<p>video title <span>*</span></p>
<input type="text" name="title" maxlength="100" required placeholder="enter video title" class="box">
<p>video description <span>*</span></p>
<textarea name="description" class="box" required placeholder="write description" maxlength="1000" cols="30" rows="10"></textarea>
<p>video playlist <span>*</span></p>
<select name="playlist" class="box" required>
<option value="" disabled selected>--select playlist</option>
<?php
$select_playlists = $conn->prepare("SELECT * FROM `playlist` WHERE tutor_id = ?");
$select_playlists->execute([$tutor_id]);
if($select_playlists->rowCount() > 0){
while($fetch_playlist = $select_playlists->fetch(PDO::FETCH_ASSOC)){
?>
<option value="<?= $fetch_playlist['id']; ?>"><?= $fetch_playlist['title']; ?></option>
<?php
}
?>
<?php
}else{
echo '<option value="" disabled>no playlist created yet!</option>';
}
?>
</select>
<p>select thumbnail <span>*</span></p>
<input type="file" name="thumb" accept="image/*" required class="box">
<p>select video <span>*</span></p>
<input type="file" name="video" accept="video/*" required class="box">
<input type="submit" value="upload video" name="submit" class="btn">
</form>
</section>
<?php include '../components/footer.php'; ?>
<script src="../js/admin_script.js"></script>
</body>
</html>