使用PDO选择登录的用户ID [英] Select logged in user's ID using PDO
本文介绍了使用PDO选择登录的用户ID的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我不熟悉PDO,并且想知道如何从phpMyAdmin数据库中选择登录用户的ID.
I am new to using PDO and was wondering how I would select the logged in user's id from my phpMyAdmin database.
我的初始化文件是...
My initialization file is...
session_start();
$_SESSION['user_id'] = 1;
$db = new PDO('mysql:host=localhost;dbname=project', 'root', '');
这是我的用户表布局:
推荐答案
我假设您要获取用户的信息,这些用户的id
与user_id
I'm assuming you want to get the users info where their id
is the same as user_id
您可能会做类似的事情;
You might do something like this;
$query = $db->prepare('SELECT * FROM table WHERE id=:id');
//using bindParam helps prevent SQL Injection
$query->bindParam(':id', $_SESSION['user_id']);
$query->execute();
//$results is now an associative array with the result
$result = $query->fetch(PDO::FETCH_ASSOC);
我不确定如何设置user_id
,所以我只是使用bindParam以防万一.
I wasn't sure how user_id
is set so I just used bindParam just in case.
这篇关于使用PDO选择登录的用户ID的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文