个人中心
文章发布
退出
作者热门文章
- html - 出于某种原因，IE8 对我的 Sass 文件中继承的 html5 CSS 不友好？
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景？
25
4
我已经为此工作好几天了，但仍无法解决。我有一份登记表和一份登录表。我想做的就是在他登录时保存检索用户的数据，并在他的 session 处于事件状态时保存它。这是我的最新尝试这是我的inscription.php(注册部分)
<?php //script pour vérifier et enregistrer les données
ini_set('display_errors',1);
if (isset($_POST['submit']))
{
//on récupère les données entrées
$name = ucfirst($_POST['userName']); //mettre le premier caractère en majuscule
$firstName = ucfirst($_POST['firstName']);
$birthDate = $_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
$languageM = $_POST['langueM']; //langue maternelle
$languageE = $_POST['langueE']; //langue étudiée
$niveau = $_POST['level'];//niveau première langue étudiée
$langueAjoutee = $_POST['secondeLangue'];
$niveau2 = $_POST['level2'];
$email = $_POST['mailInput'].'@'.$_POST['schools'];
$password1 = $_POST['password1'];
$password2 = $_POST['password2'];
if(isset($name,$firstName,$birthDate,$languageM,$languageE,$niveau,$email,$password1,$password2))
{
if ($password1===$password2)
{
//hashage du mot de passe
$password1_sha1 = sha1($password1);
$password2_sha1 = sha1($password2);
// si utilisateur déjà enregistré
$bdd = new PDO('mysql:host=localhost;dbname=bladuo', 'root', '');
$bdd->exec('SET NAMES utf8');//affichage caractères utf-8 dans la bdd
$stmt= $bdd->prepare("SELECT COUNT(*) AS count FROM `membres` WHERE email=?");
$stmt->execute(array($email));
while ($row = $stmt->fetch(PDO::FETCH_ASSOC))
{
$email_count = $row["count"];
}
//if email already used
else
{
//check password length
else
{
//connection à la bdd
try
{
$bdd = new PDO('mysql:host=localhost;dbname=bladuo', 'root', '');
$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$bdd->exec('SET NAMES utf8');//affichage caractères utf-8 dans la bdd
//enregistrement de l'étudiant dans la bdd
$stmt = $bdd->prepare('INSERT INTO members(nom,prenom,date_de_naissance,langue_maternelle,langue_etudiee,niveau,langu2,niveau2,email,passe)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?,?)');
$success = $stmt->execute(array($name , $firstName , $birthDate, $languageM , $languageE,$niveau,$langueAjoutee,$niveau2,$email,$password1_sha1));
if($success)//si l'utilisateur est enregistré dans la bdd
{
header('Location: Index.php');
}else
{
echo "INSERT a echouer!!";
exit();
}
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
}
}
}else
{
print "<span style=\"color:red;\">Les mots de passe ne sont pas identiques</span>";
exit();
}
}else
{
print "<span style=\"color:red;\">une des variables n'est pas attribuée</span>";
}
}
?>
和我的 reg.php(用于登录表单)
<?php
ini_set('display_errors',1);
error_reporting(E_ALL); ini_set('display_errors', 1);
session_start();
$errmsg_arr = array();
$errflag = false;
// connexion db
$bdd = new PDO('mysql:host=localhost;dbname=bladuo', 'root', '');
$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// nouvelle donnée
$mail = $_POST['mail'];
$password = $_POST['pwd'];
$password_sha =sha1($password);
if($mail == '') {
$errmsg_arr[] = 'Veuillez entrer votre addresse email';
$errflag = true;
}
if($password == '') {
$errmsg_arr[] = 'Veuillez entrer votre mot de passe';
$errflag = true;
}
// query
$result = $bdd->prepare("SELECT * FROM members WHERE email=? AND passe=?");
$result->bindParam(1,$mail);
$result->bindParam(2,$password_sha);
$result->execute();
$rows = $result->fetch(PDO::FETCH_NUM);
print_r($rows);
if($result->rowCount() == 1)
{
$getUsers = $bdd->prepare("SELECT * FROM members WHERE nom=? AND email=?");
$getUsers->bindParam(1,$name);
$getUsers->bindParam(2,$email);
$getUsers->execute();
$users = $getUsers->fetch();
print_r($users);
while($user = $getUsers->fetch(PDO::FETCH_NUM)){
$_SESSION['nom']=$users['nom'];
$_SESSION['email']=$users['email'];
}
$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
header("location: Accueil.php");
} else
{
$errmsg_arr[] = "Email ou mot de passe incorrecte ou vide";
$errflag = true;
}
if($errflag) {
$_SESSION['ERRMSG_ARR'] = $errmsg_arr;
session_write_close();
header("location: Index.php");
exit();
}
？>
感谢任何帮助
最佳答案
除了确保您的变量正确传递到此页面之外，正如 @ Kypros 所建议的，也许可以尝试使用类系统。
用户类别
<?php
class SetUserInfo
{
// Database connection
public $db;
// Error reporting
public $error;
// Set to check pass1 = pass 2
public $passCheck;
// Storage for user submission data
public $useInfo;
protected $host = 'localhost';
protected $database = 'dbname';
protected $user = 'username';
protected $pass = 'password';
public function __construct()
{
// Save db connection
$this->db = new DBEngine($this->host,$this->database,$this->user,$this->pass);
}
// This method pulls user from system
public function FetchUser($pass, $email)
{
// If the email address is valid, fetch from db
if(filter_var($email, FILTER_VALIDATE_EMAIL)) {
$info = $this->db->prepare("SELECT * FROM members WHERE passe=? AND email=?");
$info->bindParam(1,$pass);
$info->bindParam(2,$email);
$info->execute();
// If there are rows, set them to an array
if($info->rowCount() == 1) {
$user = $info->fetch(PDO::FETCH_ASSOC);
}
}
// Return the user array if validated or else return false/0
return (isset($user))? $user:0;
}
// This should return the count
public function EmailCount()
{
// Assign email from previously assigned email [ from Process() array ]
$query = $this->db->con->prepare("SELECT COUNT(*) AS count FROM `members` WHERE email=?");
$query->execute(array($this->useInfo['email']));
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$count = $row["count"];
}
if(isset($count) && $count == 1)
$this->error['email']['available'] = 'Compte d\'utilisateur déjà dans le système';
return (isset($count) && $count == 1)? 1:0;
}
public function CreateRegistration($errors = false)
{
// print_r($this->useInfo);
$this->db->con->exec('SET NAMES utf8');
//enregistrement de l'étudiant dans la bdd
$query = $this->db->con->prepare('INSERT INTO members (nom,prenom,date_de_naissance,langue_maternelle,langue_etudiee,niveau,langu2,niveau2,email,passe)
VALUES(?,?,?,?,?,?,?,?,?,?)');
$query->bindParam(1,$this->useInfo['name']);
$query->bindParam(2,$this->useInfo['firstName']);
$query->bindParam(3,$this->useInfo['birthDate']);
$query->bindParam(4,$this->useInfo['languageM']);
$query->bindParam(5,$this->useInfo['languageE']);
$query->bindParam(6,$this->useInfo['niveau']);
$query->bindParam(7,$this->useInfo['langueAjoutee']);
$query->bindParam(8,$this->useInfo['niveau2']);
$query->bindParam(9,$this->useInfo['email']);
$query->bindParam(10,$this->useInfo['passe']);
$query->execute();
// Validate user right.
$user = $this->ValidateLogin($this->useInfo['email'],$this->useInfo['passe'],0);
// Toggle error reporting on and off. Default is off.
if($errors == true || $errors == 1) { ?>
<pre>
<?php
// Print sql error
print_r($query->errorInfo());
// Print all values set to be inserted
print_r($this->useInfo);
// Print post
print_r($_POST); ?>
</pre>
<?php }
// Send back success or failure
return (is_array($user))? 1:0;
}
public $loginVars;
public function ValidateLogin($email = '',$password = '',$validate=1)
{
// Check that email is valid
$this->loginVars['mail'] = (isset($email) && filter_var($email, FILTER_VALIDATE_EMAIL))? $email:0;
// Check that password is not empty
$this->loginVars['pwd'] = (isset($password) && !empty($password))? $password:0;
// If there are no problems check database
if(!in_array('0',$this->loginVars)) {
// Assign encryption or process raw (could registration has encrytion alredy)
$this->loginVars['password_sha'] = ($validate == 1)? sha1($this->loginVars['pwd']):$this->loginVars['pwd'];
// Prepare to check db
$query = $this->db->con->prepare("SELECT * FROM `members` WHERE email=? AND passe=?");
$query->bindParam(1,$this->loginVars['mail']);
$query->bindParam(2,$this->loginVars['password_sha']);
// Execute search
$query->execute();
// If there are returned rows (1 specifically) set to array
if($query->rowCount() == 1) {
$rows = $query->fetch(PDO::FETCH_ASSOC);
return $rows;
}
else {
$this->error['login']['error'] = 'Échec de la connexion.';
return 0;
}
}
else {
if($this->loginVars['email'] == 0)
$this->error['invalid']['email'] = 'Veuillez entrer votre addresse email';
if($this->loginVars['pwd'] == 0)
$this->error['invalid']['pwd'] = 'Veuillez entrer votre mot de passe';
return 0;
}
}
// Processor $_POSTs
protected function Process()
{
// Process if $_POST is set
if(isset($_POST['userName'])) {
$this->useInfo['name'] = (!empty($_POST['userName']))? ucfirst($_POST['userName']):"";
$this->useInfo['firstName'] = (!empty($_POST['firstName']))? ucfirst($_POST['firstName']):"";
$this->useInfo['birthDate'] = (!empty($_POST['year']) && !empty($_POST['month']) && !empty($_POST['day']))? $_POST['year'].'-'.$_POST['month'].'-'.$_POST['day']:"";
$this->useInfo['languageM'] = (!empty($_POST['langueM']))? $_POST['langueM']:"";
$this->useInfo['languageE'] = (!empty($_POST['langueE']))? $_POST['langueE']:"";
$this->useInfo['niveau'] = (!empty($_POST['level']))? $_POST['level']:"";
$this->useInfo['langueAjoutee'] = (!empty($_POST['secondeLangue']))? $_POST['secondeLangue']:"";
$this->useInfo['niveau2'] = (!empty($_POST['level2']))? $_POST['level2']:"";
$this->useInfo['email'] = (!empty($_POST['mailInput']) && !empty($_POST['schools']))? $_POST['mailInput'].'@'.$_POST['schools']:"";
$this->useInfo['password1'] = (!empty($_POST['password1']))? $_POST['password1']:"";
$this->useInfo['password2'] = (!empty($_POST['password2']))? $_POST['password2']:"";
// Set password equivalent check
$pcheck = ($this->useInfo['password1'] == $this->useInfo['password2'])? true:false;
if($pcheck == true) {
// This is where you would run a validation on password
// For instance -> check password length (I chose 8, but you never supplied that code)
$length = 8;
if(strlen($this->useInfo['password1']) >= 8) {
$this->passCheck['password_sha'] = sha1($this->useInfo['password1']);
$this->useInfo['passe'] = $this->passCheck['password_sha'];
// Remove unused value
unset($this->useInfo['password1'],$this->useInfo['password2']);
// $this->passCheck['p2'] = sha1($this->useInfo['password2']);
}
else
$this->error['password']['length'] = 'Le mot de passe doit être de '.$length.' caractères';
}
else
$this->error['password']['id'] = 'Les mots de passe ne sont pas identiques';
}
// Return only if the array is set and not empty
return (isset($this->useInfo) && !empty($this->useInfo))? $this->useInfo: 0;
}
public function Validate()
{
// Set all the prefs to array
$user = $this->Process();
// If the array is filled with something
if(!empty($user)) {
// Loop through the returned array
foreach($user as $key => $value) {
// If there were any empty fields, assign them to an error array
if(empty($value))
$this->error['validate'][] = $key;
}
// This will only return the array IF there are no errors
// If you want something less strict, just remove the $this->error condition
return (!isset($this->error['validate']))? $user : 'err';
}
else
// Return false/0 if the user array is empty
return 0;
}
} ?>
连接类别
<?php
class DBEngine
{
public $con;
public $errors;
public function __construct($host="",$db = "",$user="",$pass="")
{
try {
$this->con = new PDO("mysql:host=$host;dbname=$db",$user,$pass, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING));
}
catch (Exception $e) {
$this->errors['connect']['message'] = $e->getMessage();
$this->errors['connect']['error_code'] = $e->getCode();
print_r($this->errors);
}
}
// Simple fetch and return method
public function Fetch($_sql)
{
$query = $this->con->prepare($_sql);
$query->execute();
$this->errors['fetch'][] = $query->errorInfo();
if($query->rowCount() > 0) {
while($rows = $query->fetch(PDO::FETCH_ASSOC)) {
$array[] = $rows;
}
}
return (isset($array) && $array !== 0 && !empty($array))? $array: 0;
}
// Simple write to db method
public function Write($_sql)
{
$query = $this->con->prepare($_sql);
$query->execute();
$this->errors['insert'][] = $query->errorInfo();
}
} ?>
注册页面
<?php
//Registration workflow
ini_set('display_errors',1);
error_reporting(E_ALL);
// Register User
if(isset($_POST['submit'])) {
include('class.user.php');
include('class.connect.php');
$info = new SetUserInfo();
// If info is all filled
if(is_array($info->Validate())) {
// If the passwords equal each other & is the correct
// length of characters
if(isset($info->passCheck['password_sha'])) {
// This is supposed to return the count
// if email exists already
$_emailInSys = $info->EmailCount();
// If email not in the system insert values for registration
if($_emailInSys == 0) {
// Insert into database
$success = $info->CreateRegistration();
// If success, forward to index
if($success == 1)
header('Location: Index.php');
}
}
}
}
?><!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Accueil</title>
<script src="../js/bootstrap.min.js"></script>
<script src="../js/myjavascript.js"></script>
<link rel="stylesheet" href="../css/bootstrap.css">
<link rel="stylesheet" href="../css/">
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.4/jquery-ui.min.js"></script>
<script src="http://ajax.aspnetcdn.com/ajax/jquery.validate/1.11.1/jquery.validate.js"></script>
<style>
label.error { color: red; float: left; clear: left; font-size: 10px; text-transform: uppercase; margin-bottom: 5px; }
#errors { background-color: #C00; color: #FFF; border-radius: 4px; padding: 10px 20px; font-size: 14px; text-shadow: 1px 1px 4px rgba(0,0,0,0.4); display: none; font-family: Arial, Helvetica, sans-serif; }
#errorcont { display: inline-block; }
</style>
</head>
<body>
<?php include("header.php"); ?>
<div id="formulaireInscription">
<h3 id="titreIncrivez">Inscrivez-vous!</h3>
<div id="numstyle">
</div>
<form action="Inscription.php" method="POST" id="registration">
<div class="form-group">
<div id="renseignementgenerale" class="form-group">
<div id="errorcont">
<div id="errors"></div>
</div>
<label for="userName">Nom:
<input type="text" class="form-control" name="userName" placeholder="Entrez votre nom" required="required">
</label>
<br />
<label for="firstName">Prénom:</label>
<input type="text" class="form-control" name="firstName" placeholder="Entrez votre prénom" required="required">
<div class="form-group" id="birthdate">
<label>Date de naissance:</label>
<label for="dayInput">Jour</label>
<select name="day">
<option value="">Jour</option>
<?php for ($i = 1; $i <= 31; $i++) { ?>
<option value="<?php echo $i; ?>"><?php echo $i; ?></option>
<?php } ?>
</select>
<label for"monthInput">Mois</label>
<select name="month">
<option value="">Mois</option>
<option value="01">Janvier</option>
<option value="02">Février</option>
<option value="03">Mars</option>
<option value="04">Avril</option>
<option value="05">Mai</option>
<option value="06">Juin</option>
<option value="07">juillet</option>
<option value="08">Aout</option>
<option value="09">Septembre</option>
<option value="10">Octobre</option>
<option value="11">Novembre</option>
<option value="12">Décembre</option>
</select>
<label for"yearInput">Année</label>
<select name="year">
<option value="">Année</option>
<?php
for ($i = 2014; $i >= 1930; $i--)
{
echo '<option value="' . $i . '">' . $i . '</option>';
}
?>
</select>
</div>
<div class="form-group" id="langueM">
<label>Langue maternelle:</label>
<select name="langueM">
<option value="français">Français</option>
<option value="anglais">Anglais</option>
<option value="espagnol">Espagnol</option>
</select>
</div>
<div class="form-group" id="langueE">
<label>Langue étudiée:</label>
<select name="langueE">
<option value="anglais">Anglais</option>
<option value="espagnol">Espagnol</option>
<option value="français">Français</option>
</select>
<label>Niveau:</label>
<select name=level id="niveau">
<option value="B1">B1</option>
<option value="B2">B2</option>
<option value="C1">C1</option>
<option value="C2">C2</option>
</select>
<img id="plus" title="Cliquer sur l'image pour ajouter une seconde langue" src="../res/images/boutons/plus.png"> <a class="level" ><strong><em>Comment choisir mon niveau?</em></strong> <span> B1:Je participe à des conversations sur des sujets<br />
simples et familiers.<br />
B2:Je peux discuter avec aisance et une certaine<br />
spontanéité.<br />
C1:Je m’exprime spontanément sans trop chercher<br />
mes mots<br />
C2:Je m’exprime et comprends sans efforts et<br />
je souhaite maintenir mon niveau. </span> </a><br />
<script>
document.getElementById('plus').onclick = function() {//cacher le bouton et afficher le select
document.getElementById('addLanguage').style.display = 'inline';
document.getElementById('plus').style.display = 'none';
}
</script>
<div id="addLanguage">
<select id="langu2" name="secondeLangue">
<option value="espagnol">Espagnol</option>
<option value="anglais">Anglais</option>
<option value="français">Français</option>
</select>
<label>Niveau:</label>
<select name=level2 id="niveau2">
<option value="B1">B1</option>
<option value="B2">B2</option>
<option value="C1">C1</option>
<option value="C2">C2</option>
</select>
</div>
</a>
</div>
</div>
<label >Adresse email:</label>
<div>
<div class="mailliste">
<input name="mailInput" type="text" placeholder="Entrez votre email" required="required">
@
<select name="schools" onchange="VerifListe();">
<option value="rms.fr">rms.fr</option>
<option value="icade.es">icade.es</option>
<option value="esb.de">esb.de</option>
</select>
<a href=""><img id="question" src="../res/images/boutons/question.png"> <span> Vous pouvez vous inscrire<br />
uniquement avec <strong><em>votre adresse Email<br />
de votre école.</em></strong> Pour consulter la liste<br />
des écoles patenaires cliquez ici. </span> </a>
</div>
<br>
</div>
</div>
<div class="form-group">
<label for="inscriptionInputPassword1">Mot de passe:</label>
<input type="password" class="form-control" id="password1" name="password1" placeholder="Entrez votre mode passe" required="required">
<br>
<input type="password" class="form-control" id="password2" name="password2" placeholder="Répétez votre mode passe" required="required">
</div>
<div class="myButtons">
<input type="submit" name="submit" value="Inscription"/>
<input type="button" value="Retour" onclick="document.location.href='Index.php';" />
</div>
</form>
</div>
<script>
$(document).ready(function() {
<?php if(isset($info->error)) {
foreach($info->error as $kind => $container) {
$imploder[] = str_replace('"','\"',ucwords(implode("<br />",$container)));
}
?>
$("#errors").html("<?php echo implode("<br />",$imploder); ?>");
$("#errors").delay(500).fadeIn("slow");
$("#errors").delay(3000).fadeOut("slow");
<?php } ?>
// validate signup form on keyup and submit
$("#registration").validate({
rules: {
userName: {
required: true
},
day: {
required: true
},
month: {
required: true
},
year: {
required: true
},
mail: {
required: true,
email: true//,
//minlength: 4
},
password1: {
required: true,
minlength: 8
},
password2: {
required: true,
minlength: 8,
equalTo: "#password1"
}
},
messages: {
mail: {
required: "Nom d'utilisateur Obligatoire",
email: "Adresse email invalide"
},
password1: {
required: "Mot de passe requis",
minlength: "8 caractères minimum"
},
password2: {
required: "Mot de passe requis",
minlength: "8 caractères minimum",
equalTo: "Not the same"
}
}
});
});
</script>
</body>
</html>
登录页面
<?php
session_start();
ini_set('display_errors',0);
error_reporting(0);
if(isset($_POST['cesam'])) {
include('class.user.php');
include('class.connect.php');
$info = new SetUserInfo();
$userData = $info->ValidateLogin($_POST['mail'],$_POST['pwd']);
if($userData !== 0) {
$_SESSION['email'] = $userData['mail'];
$_SESSION['nom'] = $userData['nom'];
$_SESSION['date_de_naissance'] = $userData['date_de_naissance'];
$_SESSION['langue_maternelle'] = $userData['langue_maternelle'];
$_SESSION['langue_etudiee'] = $userData['langue_etudiee'];
$_SESSION['niveau'] = $userData['niveau'];
$_SESSION['langu2'] = $userData['langu2'];
$_SESSION['niveau2'] = $userData['niveau2'];
header("location: Accueil.php");
}
}
?><!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Accueil</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
<script src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.10.4/jquery-ui.min.js"></script>
<script src="http://ajax.aspnetcdn.com/ajax/jquery.validate/1.11.1/jquery.validate.js"></script>
<style>
label.error { color: red; float: left; clear: left; font-size: 10px; text-transform: uppercase; margin-bottom: 5px; }
#errors { background-color: #C00; color: #FFF; border-radius: 4px; padding: 10px 20px; font-size: 14px; text-shadow: 1px 1px 4px rgba(0,0,0,0.4); display: none; font-family: Arial, Helvetica, sans-serif; }
#errorcont { display: inline-block; }
</style>
</head>
<body>
<?php include("header.php"); ?>
<div id="intro">
<h2><span>Bladuo, Qu'est ce que c'est ?</span></h2>
</div>
<div id="errorcont">
<div id="errors"></div>
</div>
<div id="formulaireConnexion">
<form class="form-horizontal" action="Index.php" method="POST" id="login">
<input type="email" name="mail" class="form-control" id="inputEmail3" placeholder="Email">
<br />
<input type="password" name="pwd" class="form-control" id="inputPassword3" placeholder="Mot de passe">
<input type="checkbox">
Se souvenir de moi
<button type="submit" name="cesam" class="btn btn-lg btn-primary btn-block" role="button">Se connecter</button>
<a href="Inscription.php" class="btn btn-lg btn-primary btn-block" role="button">S'inscrire</a>
</form>
</div>
<div id="videoPresentation">
<iframe width="560" height="315" src="//www.youtube.com/embed/CqSDWoAhvLU" allowfullscreen> </iframe>
</div>
<script>
$(document).ready(function() {
<?php if(isset($info->error)) {
foreach($info->error as $kind => $container) {
$imploder[] = str_replace('"','\"',implode("",$container));
}
?>
$("#errors").html("<?php echo implode("",$imploder); ?>");
$("#errors").delay(500).fadeIn("slow");
$("#errors").delay(2000).fadeOut("slow");
<?php } ?>
// validate signup form on keyup and submit
$("#login").validate({
rules: {
mail: {
required: true,
email: true//,
//minlength: 4
},
pwd: {
required: true,
minlength: 8
}
},
messages: {
mail: {
required: "Nom d'utilisateur Obligatoire",
email: "Adresse email invalide"
},
pwd: {
required: "Mot de passe requis",
minlength: "8 caractères minimum"
}
}
});
});
</script>
</body>
</html>
关于php - PDO在登录时获取用户的数据库值并将其存储到$_SESSION，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/26434349/
25
4
0
PHP查询: prepare('SELECT * FROM Locations WHERE user_id = :id LIMIT 0, 5'); $query->bindParam(":id
到目前为止我一直在使用 PDO->bindParam 但是在阅读手册时我发现 PDO->bindValue 我可以告诉 PDO->bindValue 按值传递，而 PDO->bindParam 按引用
我使用PDO进行MySQL数据库连接、选择、更新和删除。 但是我在选择带有特殊字符的行时遇到问题，例如，我想选择带有“Judge-Fürstová Mila”的页面标题， 表页， id titl
我使用的是 PHP 5.2.9 和 Apache 2.2.11 以及 mysql 5.1.32 为什么我不能禁用 PDO::ATTR_EMULATE_PREPARES ？ 下面是代码: false)
当 PDO::ATTR_PERSISTENT = true 时，PDO::exec 和 PDO::query 之间似乎存在差异。当使用PDO::exec时，连接将不会被重用，并最终导致MySQL出现“
我正在尝试调整 Zend Skeleton App 以使用 ODBC 连接。我能够在 Zend 之外设置 PDO 连接(同一个表、服务器、所有内容)，如下所示: new PDO('odbc:DRIVE
我正在使用 XAMPP 3.2.1 在 Windows 7 上使用 PDO，但在使其正常工作时遇到问题，即使它可以在我的共享托管服务器。 settings.php db.php setAttribu
我正在尝试使用以下代码从 get 变量中获取结果，我使用了另一个代码(在下面列出)并且它有效但是在使用它时无法逃脱，我不知道我有什么做错了，但我需要帮助，我刚刚开始 PDO，所以是的，我是个白痴 :D
我有这个代码 try { $dbh = new PDO('mysql:host=localhost;dbname=db_informations', 'root', ''); $dbh
在我的本地开发机器 (MAMP) 上，我的 MySQL 查询返回正确的大小写。但是，在我的共享托管服务器上，使用 fetch(PDO::FETCH_ASSOC); 时，我的结果是小写的 我试过以下方法
我正在使用这个 PDO 连接: try{ $db=new PDO(" mysql:host=localhost; dbname=...", "dbu...", "pass", array(PDO::M
我需要将 PDO 连接从 controller 传递到 cart 类， function __construct($connection) { $this->cart = new cart($
位于 PHP.net 的 PDO 交易示例表明 PDO::exec() 是事务处理的，但是没有这样的例子使用 PDO::query()。 事务是否涵盖 PDO::query()？ 此外，据我所知，PD
几天来我一直在使用来自 http://www.mamp.info 的 MAMP Pro 3.07 . 很棒的工具，一切正常。 但是现在我遇到了问题，对于一个新项目，我需要连接到 MSSQL。 我在 w
我正在尝试在我的 PHP 代码中使用 PDO 模块来连接到数据库。我已经阅读并搜索了类似的主题，但我无法弄清楚我做错了什么。请帮我解决问题。 Apache版本:Apache/2.2.21 (Win32
这个问题不太可能帮助任何 future 的访问者；它只与一个小的地理区域、一个特定的时间点或一个非常狭窄的情况有关，这些情况并不普遍适用于互联网的全局受众。为了帮助使这个问题更广泛地适用，visit
我使用 PDO 连接到我的数据库，我不知道哪种方法比更新、删除和插入、PDO::exec 或 PDO::excute 的另一种方法更好。我应该使用哪个？ 最佳答案 虽然这两种方法具有相似的命名(exe
如何在 Codeigniter 中设置 PDO 数据库句柄的属性(PDO::ATTR_ERRMODE)？ 最佳答案 我认为更好的选择是使用 MY_Model(然后您对其进行扩展，然后它在整个应用程序中
从 mysql 切换到 PDO 我注意到 fetch 方法改变了 PDO 对象本身!例如: $res=$ps->fetchAll(); echo($res[0]['Mail']); //it'ok /
嗨，我正在使用 PDO 为 mysql 开发一个基本的数据库连接类，但是当我 var dump 返回结果时，它告诉我我有 2 个对象:object(PDO)[2]。不应该只有一个吗？ 这是迄今为止我的
我是一名优秀的程序员,十分优秀！