我的问题是:我的代码有问题(从MySql中选择数据)这是我的代码
<?php
$user_name = $_SESSION['user_name'];
$user_email = $_SESSION['user_email'];
echo $user_email;
$con = mysqli_connect("localhost", "root", "", "minehelp");
$id_query = mysqli_query($con, "SELECT user_name FROM users_en WHERE user_name = '" . $user_name . "' OR user_email = '" . $user_email . "';");
while ($row_id_query = mysqli_fetch_assoc($id_query)){
print($row_id_query['user_name']);
}
?>
我想选择"user_name是$user_name"
的数据这是登录系统,这意味着 $_SESSION'user_name'
是我代码的一部分,我无法重新制作它。
谢谢你的每一个回答,
雅库布克-0
应该看起来类似于
$sql = "INSERT INTO users (NickName, PassWord, Email)
VALUES (:nick, :pass, :mail)";
$conn->prepare($sql);
$conn->execute(array(':nick' => $NickNaming, ':pass' => $PassWording, ':mail' => $Emailing));
你应该使用 PDO::p repare
准备要由 PDOStatement::execute() 方法.
和 PDO::执行
执行预准备语句。
因此,您的准备和执行将如下所示:
$sth = $conn->prepare( 'INSERT INTO users (NickName, PassWord, Email)
VALUES (:nick, :pass, :mail)');
$sth->execute( array(':nick' => $NickNaming,
':pass' => $PassWording,
':mail' => $Emailing));
我尽量不使用PDO:
$insert = mysqli_query($con,"INSERT INTO users (Nickname, PassWord, Email)
VALUES ('$NickName','$PassWording','$Emailing')");
那会起作用