php怎么更新数据库,如何在提交时创建一个更新数据库的php函数？

我创建此函数以在单击提交按钮时更新数据库.但它似乎没有用.该脚本用于通过id使用用户的登录详细信息从数据库中绘制用户的值,并填充表单.该功能用于在表单文本字段中进行更改时帮助更新用户的详细信息.

请,我需要帮助调试它.

libraries.php

function db(){ //handles database connection

//connect to the database server or die and spit out connection error

$conn = mysql_connect('localhost','root', '') or die("Cannot connect to the database server now". mysql_error());

//select database table or die and spit out database selection error

mysql_select_db('newbishop',$conn) or die("Error in selecting database now ".mysql_errno());

return $conn;

}

personalsettings.php

include_once('libraries.php'); // contains the database function

session_checker();

db();

$categoryid = $_SESSION['id'];

$select = "SELECT * FROM users WHERE categoryid ='$categoryid' LIMIT 1";

$row1 = dbprocess ($select);

$rows = mysql_fetch_assoc($row1);

$pname1 = $rows['pname'];

$email1 = $rows['email'];

$user1 = $rows['user'];

$pass1 = $rows['pass'];

$salt1 = $rows['salt'];

$phone1 = $rows['phone'];

$accesslevel = $rows['accesslevel'];

$position = $rows['position'];

function update(){

db(); // database function

$pname = $_POST['pname'];

$categoryid = $_POST['categoryid'];

$email = $_POST['email'];

$phone = $_POST['phone'];

$user = $_POST['users'];

$pass = $_POST['pass'];

function createSalt(){

$string = md5(uniqid(rand(), true));

return substr($string, 0, 3);

};

$salt = createSalt();

$hash = hash('sha256', $salt . $pass);

$sql = "UPDATE users SET user=?,pass=?,salt=?,pname=?,email=?,phone=? WHERE categoryid=?";

$q = $conn->prepare($sql);

$q->execute(array($user,$hash,$salt,$pname,$email,$phone,$categoryid));

}

?>

表格

编辑个人设置

Submit