注册表格无法连接

 

prepare($query); $statement->bind_param('ssssissiisss', $firstname, $lastname, $streetAddress, $suburb, $postcode, $state, $country, $phone, $mobile, $email, $dateJoined, $password); $statement->execute(); $statement->store_result(); $creationWasSuccessful = $statement->affected_rows == 1 ? true : false; if ($creationWasSuccessful) { $userId = $statement->insert_id; $addToUserRoleQuery = "INSERT INTO users_in_roles (user_id, role_id) VALUES (?, ?)"; $addUserToUserRoleStatement = $db->prepare($addToUserRoleQuery); // this puts all users into standard user role. in other websites there may be different levels of access $userRoleId = 2; $addUserToUserRoleStatement->bind_param('dd', $userId, $userRoleId); $addUserToUserRoleStatement->execute(); $addUserToUserRoleStatement->close(); //$_SESSION['userid'] = $userId; )this is not being used here -- header has session include //$_SESSION['username'] = $username; ) if removed? do we need else function? // header ("Location: home.php"); ) } else { echo "Failed registration"; /*? do we need this ?*/ } } include ("includes/header.php"); ?>

 

名字  

姓  

电子邮件  

密码  

重新输入密码  

街道地址  

市郊  

邮编  

国家  

电话  

移动

 

 

答：我刚刚检查了您提到的代码。您正在表单中使用其他用户数据，并尝试在数据库中插入详细信息。在第一步中，应该建立与数据库的连接。您是否已从数据库建立连接？如果您在查询语法上犯了错误，则可以简单地使用phpmyadmin进行正确的查询。让我知道您是否还需要其他帮助。