尝试使用php上传时出现Sql问题

Question

I'm trying to upload a video to a folder which is working but, the relevant entry in the DB isn't occurring to match it. Really having trouble seeing what's wrong, as no errors are reported.

    session_start();
    require 'db.php';
    $name = $_FILES['video']['name'];
    $uploader = $_SESSION['first_name'].$_SESSION['last_name'];
    $newstring = $_SESSION['last_name'].'_'.$_SESSION['first_name'].'_'.date('ymdhms').".mp4";
    $extension = strtolower(substr($name, strpos($name, '.') + 1));
    $size = $_FILES['video']['size'];
    $max_size = '1073741824';
    $type = $_FILES['video']['type'];
    $id = $_SESSION['id'];
    $date = date('Y-m-D');
    $tmp_name = $_FILES['video']['tmp_name'];

    if(!empty($name)){
        $location = "uploads/";

    if($extension=='mp4'&&$type == 'video/mp4'){
        if($size <= $max_size){
            if(move_uploaded_file($tmp_name, $location.$newstring)){ 
                $sql = "INSERT INTO videos (file_name, upload_by, date) VALUES 
                   ('$newstring', '$id', '$date')";
                mysqli_query($mysqli, $sql);
                require('profile.php');
                $_SESSION['message'] = "Upload Successful!";
                header('Refresh:0; url=profile.php');
            }else{
                $_SESSION['message'] = "File failed to upload";
                header("location: error.php");
            }

I'm not getting a corresponding DB entry. Any help would be really appreciated.

Answer 1

Try this:

$sql = "INSERT INTO videos (file_name, upload_by, date) VALUES 
                   ('".$newstring."', '".$id."', '".$date."')";