mysql 不能设置新的类型_php - 我无法更新mysql（i）数据库。如何在数据库中设置用户类型？ - SO中文参考 - www.soinside.com...

我需要在mysql数据库中更新我的配置文件，并在程序中设置用户类型。如何在此注册程序中上传图片？已经尝试了一切，新的PHP和我每次运行我的下面的程序时收到一个错误。如何删除存储的值？

Register.php

session_start();

require('connect.php');

if(isset($_POST['submit'])){

$username = $_POST['username'];

$name = $_POST['name'];

$email = $_POST['email'];

$password = md5($_POST['password']);

$dob = $_POST['dob'];

$gender = $_POST['gender'];

$location = $_POST['location'];

$course = $_POST['course'];

$mobile = $_POST['mobile'];

$query = "INSERT INTO `user`(username, name, password, email, dob, gender, location, course, mobile) VALUES ('$username', '$name', '$password', '$email', '$dob', '$gender', '$location', '$course', '$mobile')";

$result = mysqli_query ($mysqli,$query);

if($result){

$smsg = "Thank you!Your registration form has been successfully submitted.";

}else{

$fmsg = "This email already exists ";

}

}

?>

User Registration PHP & MYSQL

<?php } ?><?php } ?>

Please Register

ID

Full Name

Email address

Password

DOB

Gender:

Male

female

Location

Course

Mobile

Register

Login