php - 如何从我的数据库中获取注册消息
问题描述
我正在设置完全有组织的注册表单,我正在尝试将信息发送到我的 MySQL 数据库服务器中。我的代码不起作用,无法弄清楚弹出消息您已注册!
我已经尝试了几个选项,但它们都不能在服务器上工作,
<?php
if (array_key_exists('email', $_POST) or array_key_exists('password', $_POST)) {
// So I'm guessing here need to some additions of based my own inclinatios.
我的代码
<?php
if (array_key_exists('email', $_POST) or array_key_exists('password', $_POST)) {
$link = mysqli_connect("localhost", "id8955440_bigebro", "sunshine1987**", "id8955440_bigebro");
if (mysqli_connect_error()) {
die("There was an error connecting to the database");
}
if ($_POST['email'] == '') {
echo "<p>Email address is required.</p>";
} else if ($_POST['password'] == '') {
echo "<p>Password is required.</p>";
} else {
$query = "SELECT `id` FROM `bigebro` WHERE email = '" . mysqli_real_escape_string($link, $_POST['email']) . "'";
$result = mysqli_query($link, $query);
if (mysqli_num_rows($result) > 0) {
echo "<p>That email address has already been taken.</p>";
} else {
$query = "INSERT INTO `bigebro` (`email`, `password`) VALUES ('" . mysqli_real_escape_string($link, $_POST['email']) . "', '" . mysqli_real_escape_string($link, $_POST['password']) . "')";
if (mysqli_query($link, $query)) {
echo "<p>You have been signed up!";
} else {
echo "<p>There was a problem signing you up - please try again later.</p>";
}
}
}
}
?>
HTML
<form method="post">
<input name="email" type="text" placeholder="Email address">
<input name="password" type="password" placeholder="Password">
<input type="submit" value="Sign up">
</form>
$link = mysqli_connect("localhost", "id8955440_bigebro", "sunshine1987**", "id8955440_bigebro");
当我注册表格时只弹出“注册时出现问题 - 请稍后再试”,我希望从结果中看到“您已注册”。请参阅注册表单
解决方案
用于mysqli_error
跟踪查询中的错误。
$query = "INSERT INTO `bigebro` (`email`, `password`) VALUES ('" . mysqli_real_escape_string($link, $_POST['email']) . "', '" . mysqli_real_escape_string($link, $_POST['password']) . "')";
if (mysqli_query($link, $query)) {
echo "<p>You have been signed up!";
} else {
echo "Error: " . mysqli_error($conn);
}
推荐阅读
- python - 是否有任何 numpy 函数可以使列对角矩阵变小,行中有大量元素?
- python - 与迭代器相比,生成器返回一个隐式的可迭代序列是什么意思?
- python-3.x - 尝试用 CIFAR-10 学习卷积神经网络
- c++builder - TEdit 控件的 NumbersOnly 属性
- excel - 将代码从 VBA 转换为使用 Google Docs
- python - 从 DateTime 数据框列中提取时间并使用线图绘制每小时时间
- javascript - Howler.JS 从使用 vue 的方法播放时不播放音频
- google-apps-script - 为什么代码有时会从自身触发?
- javascript - 正则表达式匹配和分组直到一个字符序列
- python - 如何正确保存文件以避免 UnicodeDecodeError