问MySqli查询:列更新

EN

    $filetemp=$_FILES['dpfile']['tmp_name'];
        $filename=$_FILES['dpfile']['name'];
        //echo $filetemp;
        $filetype=$_FILES['dpfile']['type'];
        $filepath="../welcome/dp/".$dept."/".$filename;

        move_uploaded_file($filetemp, $filepath);


        $sql = "update teachers SET 
                                    filename='$filename',
                                    filepath='$filepath',
                                    filetype='$filetype'

                                    WHERE id='$edit_id'";

        $reslt = mysqli_query($conn, $sql);
        if($reslt)
        {
                echo "file uploaded successfully";

        }