我是编码和堆栈溢出的新手,所以我提前道歉。我已经浏览了堆栈溢出,但找不到问题的答案。我设置了一个 html 表单,然后将电子邮件和密码保存到 mysql 没有问题。我希望将名称,出生日期,城镇,国家/地区添加到这些输入中,我已经在下面的html中这样做了:
<form class="marginTop" method="post">
<div class="form-group">
<div class="input-group">
<span class="input-group-addon">Name</span>
<input name="name" class="form-control" placeholder="Katie" type="text" value="<? echo addslashes($_POST['name']); ?>" />
</div>
<div class="input-group">
<span class="input-group-addon">Email</span>
<!-- email panel -->
<input name="email" class="form-control" placeholder="Katie@katie.com" type="email" value="<? echo addslashes($_POST['email']); ?>" />
</div>
<div class="input-group">
<span class="input-group-addon">DOB</span>
<!-- DOB panel -->
<input name="DOB" class="form-control" placeholder="dd/mm/yyyy" type="DOB" value="<? echo addslashes($_POST['DOB']); ?>" />
</div>
<div class="input-group">
<span class="input-group-addon">Town/City</span>
<!-- Place panel -->
<input name="Town" class="form-control" placeholder="New York" type="town" value="<? echo addslashes($_POST['town']); ?>" />
</div>
<div class="input-group">
<span class="input-group-addon">Country</span>
<!-- country panel -->
<input name="country" class="form-control" placeholder="America" type="country" value="<? echo addslashes($_POST['country']); ?>" />
</div>
<div class="input-group">
<span class="input-group-addon">Password</span>
<!-- password panel -->
<input name="password" class="form-control" placeholder="At least 8 characters and 1 cap letter" type="password" value="<? echo addslashes($_POST['password']); ?>" />
</div>
<input type="submit" name="submit" value="Sign Up" class="btn btn-success btn-lg marginTop"/>
</form>
php 文档中记录密码并将其与电子邮件一起添加到 mysql 的行是这样的。这工作正常,我正在努力的是添加Name
、DOB
、Town
和Country
。
$query = "INSERT INTO `users` (`email`, `password`) VALUES ('".mysqli_real_escape_string($link, $_POST['email'])."', '".md5(md5($_POST['email']).$_POST['password'])."')";
我以为我可以简单地将这些添加到这行代码中,但是当我这样做时我遇到了错误。例如,像这样添加name
。
$query = "INSERT INTO `users` (`email`, `password`, `name`) VALUES ('".mysqli_real_escape_string($link, $_POST['email'])."', '".md5(md5($_POST['email']).$_POST['password']).$_POST['name'])."')";
任何帮助将不胜感激,就像我说我是新手,所以对我温柔。
提前谢谢。
像下面这样:
$query = "INSERT INTO `users` (`email`, `password`, `name`) VALUES ('".mysqli_real_escape_string($link, $_POST['email'])."', '".md5(md5($_POST['email']).$_POST['password']))."','".$_POST['name']."')";
如@Epodax所述,您不是分隔您的值(密码和名称),而是将它们连接起来。
$query = "INSERT INTO `users` (`email`, `password`, `name`) VALUES ('".mysqli_real_escape_string($link, $_POST['email'])."', '".md5(md5($_POST['email']).$_POST['password']).$_POST['name']."')";
应该是...
$query = "INSERT INTO `users` (`email`, `password`, `name`) VALUES ('".mysqli_real_escape_string($link, $_POST['email'])."', '".md5(md5($_POST['email']).$_POST['password']). "', '" . $_POST['name']."')";
试试这个:
$query = "INSERT INTO `users` (`email`, `password`, `name`) VALUES ('".mysqli_real_escape_string($link, $_POST['email'])."', '".md5(md5($_POST['email']).$_POST['password']))."','".$_POST['name']."')";