php 表单 sql,从html表单插入数据到sql数据库(html,php,sql)时未保存输入的值

问题：insert.php连接正常,但是当我在html表单上点击’save’时,只插入空值(”).我正在尝试插入的文字我没有保存.在某个地方没有建立连接,数据丢失但我无法确切地知道在哪里.有帮助吗？

HTML插入表单(收集2个参数的数据,’用户’和’线程’)

user:

thread:

PHP代码连接到SQL,插入输入的值

$user = $_POST['user'];

$thread = $_POST['thread'];

$servername = "##.##.###";

$username = "harwoodjp";

$password = "~";

$dbname = "332";

//create connection

$conn = new mysqli($servername, $username, $password, $dbname);

//check connection

if ($conn->connect_error) {

die("SQL (☒)
" . $conn->connect_error);

}

echo "SQL (☑)
";

$sql = mysql_connect($servername,$username,$password);

mysql_connect($servername,$username,$password);

mysql_select_db("332project");

//insert values

$insert_query = "INSERT INTO test1(user,thread) VALUES ('$user', '$thread')";

mysql_query($insert_query);

echo ""; //select.php displays the full table

//close MySQL

mysql_close($sql);

?>