$sql = $DB_con->prepare("INSERT INTO users (username, email, password, ip, signup, lastlogin, notescheck)
            VALUES(:u,:e,:p_hash,:ip,now(),now(),now())");
    $sql->bindparam(":u",$u);
    $sql->bindparam(":e",$e);
    $sql->bindparam(":p_hash",$p_hash);
    $sql->bindparam(":ip",$ip);

    $sql->execute();
    $last_id = $DB_con->lastInsertId();

$sql=$DB_con->prepare("UPDATE users SET file =':final_file', type = ':file_type', size = ':new_size'  WHERE userid = ':last_id'" );

            $sql->execute();
    $sql->bindparam(":final_file",$final_file);
    $sql->bindparam(":file_type",$file_type);
    $sql->bindparam(":new_size",$new_size);
$sql->bindparam(":last_id",$last_id);