如何从许多用户的列表中检索单个用户的数据

am having problem on retrieving data of a specific user when "View This Profile" button is pressed. am biulding a recruitment web system in which i want employer to be able to view job seeker's profile when the view button is pressed. Here is the sample codes

<?php
    $sqli_one= mysqli_query($connection, "SELECT personal_info_tbl.Name, personal_info_tbl.Email, personal_info_tbl.Gender, personal_info_tbl.Career_objective, education_tbl.Career, education_tbl.Degree_University, registration_tbl.profile_picture, registration_tbl.Status);
 while($rows = mysqli_fetch_array($sqli_one, MYSQLI_ASSOC)){
        $name = $rows['Name'];
        $gender = $rows['Gender'];
        $career = $rows['Career'];
        $career_objective = $rows['Career_objective'];
        $college = $rows['Degree_University'];
        $profile_picture = $rows['profile_picture'];
        $_SESSION['viewedEmail'] = $rows['Email'];
        $_SESSION['userPhoto'] = $rows['profile_picture'];
        $_SESSION['viewedName'] = $rows['Name'];

?>

    <div class="col-sm-4" style="height: 200px; border: 6px solid #ffffff; border-radius: 30px; background-color: #CCFFFF; margin-top: 5px;">
        <div class="row" style="height: 100px; max-width: auto; color: #0000FF; overflow: hidden;">
     <div class="col-sm-3" style="margin-top: 15px;">
         <?php echo "<img src='profile_pictures/".$rows['profile_picture']."' class='img-responsive' style='image-orientation:from-image;'>";?>
     </div>
     <div class="col-sm-9">
        <div class="row">
            <div class="col-sm-4" style="text-align: right; font-weight: bolder;">Name:&nbsp</div>
            <div class="col-sm-8" style="text-align: left;"><?php echo "$name"; ?></div>
        </div>
        <div class="row">
            <div class="col-sm-4" style="text-align: right; font-weight: bolder;">College:</div>
            <div class="col-sm-8" style="text-align: left;"><?php echo "$college"; ?></div>
        </div>
        <div class="row">
            <div class="col-sm-4" style="text-align: right; font-weight: bolder;">Gender:</div>
            <div class="col-sm-8" style="text-align: left;"><?php echo "$gender";  ?></div>
        </div>
        <div class="row">
            <div class="col-sm-4" style="text-align: right; font-weight: bolder;">Career:&nbsp</div>
            <div class="col-sm-8" style="text-align: left;"><?php  echo "$career"; ?></div>
        </div>
     </div>
</div> 

    <div class="row" style="text-align: center;">
        <div style="color: #d80000;"><h6><strong>Marked As:</strong>&nbsp<?php  echo $rows['Marked_As'];  ?></h6>
        </div>
    </div>
<div class="row" style="margin-top: 0px; text-align: center;">
    <?php echo "<a href='profile_page.php?Email='" . $_SESSION['viewedEmail'] . "'><button class='btn button'>View This Profile</button></a>"; ?>
</div>
</div>

<?php
    }
?>

here is a sample output

So I want when employer click view this profile button the specific clicked profile should appear with details of the selected job seeker's profile. Please help

Here is the codes for profile_page.php

    if(isset($_GET['email']) && !empty($_GET['email'])) {

 $email = $_GET['email'];

$sqli_one= mysqli_query($connection, "SELECT personal_info_tbl.Email, personal_info_tbl.Name, personal_info_tbl.Gender, personal_info_tbl.Career_objective, personal_info_tbl.Nationality, personal_info_tbl.BOD, personal_info_tbl.Residence, personal_info_tbl.Skills, personal_info_tbl.Language, personal_info_tbl.Training, personal_info_tbl.Sport, personal_info_tbl.Mobile, personal_info_tbl.Country, personal_info_tbl.Address WHERE personal_info_tbl.Email = '".$email."'") or die("We could not execute your query sqli_one&nbsp".mysqli_error($connection));

$rows = mysqli_fetch_array($sqli_one, MYSQLI_ASSOC);
        $cand_email = $rows['Email'];
        $cand_name = $rows['Name'];
        $cand_gender = $rows['Gender'];
        $cand_career_objective = $rows['Career_objective'];
        $cand_nationality = $rows['Nationality'];
        $cand_dob = $rows['BOD'];
        $cand_residence = $rows['Residence'];
        $cand_skills = $rows['Skills'];
        $cand_language = $rows['Language'];
        $cand_training = $rows['Training'];
        $cand_sports = $rows['Sport'];
        $cand_mobile = $rows['Mobile'];
        $cand_country = $rows['Country'];
        $cand_address = $rows['Address'];
 }
?>

<div class="container">
    <div class="row" style="margin-top: 93px;">
        <div class="col-sm-12" style="border: 1px solid #cccccc;">
            <div class="row" style="background-color: #cccccc; color: #000;">
                <h3 style="text-align: center; font-variant-caps: uppercase; text-transform: uppercase;">
                <strong><?php echo $viewedName; ?>&nbsp;-&nbsp;CURRICULUM VITAE</strong></h3>
            </div>
            <div class="row" style="background-color: #3483cd; color: #ffffff;">
                <h3 style="text-align: center; font-variant-caps: uppercase; text-transform: uppercase;">
                <strong>Career Objective</strong></h3>
            </div>
            <div class="row" style="background-color: #cccccc; color: #000;">
                <h4 style="font-weight: bolder; text-align: center;"><?php echo "$cand_career_objective"; ?></h4>
            </div>
            <div class="row" style="background-color: #3483cd; color: #ffffff;">
                <h3 style="text-align: center; font-variant-caps: uppercase; text-transform: uppercase;">
                <strong>PERSONAL INFROMATION</strong></h3>
            </div>
                    <div class="row" style="border-bottom: 1px solid #000;">
                        <div class="col-sm-4" style="background-color: #cccccc; color: #000;">Name:
                        </div>
                        <div class="col-sm-8"><?php echo "$cand_name"; ?></div>
                    </div>
                    <div class="row" style="border-bottom: 1px solid #000;">
                        <div class="col-sm-4" style="background-color: #cccccc; color: #000;">Gender:
                        </div>
                        <div class="col-sm-8"><?php echo "$cand_gender"; ?></div>
                    </div>
                    <div class="row" style="border-bottom: 1px solid #000;">
                        <div class="col-sm-4" style="background-color: #cccccc; color: #000;">Nationality:
                        </div>
                        <div class="col-sm-8"><?php echo "$cand_nationality"; ?></div>
                    </div>
                    <div class="row" style="border-bottom: 1px solid #000;">
                        <div class="col-sm-4" style="background-color: #cccccc; color: #000;">BIRTH DATE:
                        </div>
                        <div class="col-sm-8"><?php echo "$cand_dob"; ?></div>
                    </div>
                    <div class="row" style="border-bottom: 1px solid #000;">
                        <div class="col-sm-4" style="background-color: #cccccc; color: #000;">RESIDENCE:
                        </div>
                        <div class="col-sm-8"><?php echo "$cand_residence"; ?></div>
                    </div>
            <div class="row" style="background-color: #3483cd; color: #ffffff;">
                <h3 style="text-align: center; font-variant-caps: uppercase; text-transform: uppercase;">
                <strong>CONATCT INFROMATION</strong></h3>
            </div>
            <div class="row" style="border-bottom: 1px solid #000;">
                <div class="col-sm-4" style="background-color: #cccccc; color: #000;">EMAIL:
                </div>
                <div class="col-sm-8"><?php echo "$cand_email"; ?></div>
            </div>
            <div class="row" style="border-bottom: 1px solid #000;">
                <div class="col-sm-4" style="background-color: #cccccc; color: #000;">MOBILE:
                </div>
                <div class="col-sm-8"><?php echo "$cand_mobile"; ?></div>
            </div>
            <div class="row" style="border-bottom: 1px solid #000;">
                <div class="col-sm-4" style="background-color: #cccccc; color: #000;">COUNTRY:
                </div>
                <div class="col-sm-8"><?php echo "$cand_country"; ?></div>
            </div>
            <div class="row" style="border-bottom: 1px solid #000;">
                <div class="col-sm-4" style="background-color: #cccccc; color: #000;">ADDRESS:
                </div>
                <div class="col-sm-8"><?php echo "$cand_address"; ?></div>
            </div>
</div>
</div>

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

2条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
dtqi87613 2017-05-12 09:59
关注
The first thing that you need to do is to remove the $_SESSION['viewedEmail'] on the query string because this will not give you the required results on the profile_page this will always give you the same value all the time until you destroy the session.

Therefore this :

<?php echo "<a href='profile_page.php?Email='" . $_SESSION['viewedEmail'] . "'><button class='btn button'>View This Profile</button></a>"; ?>

Should change to this :

<?php echo "<a class='btn button' href='profile_page.php?email='" . $row['Email'] . "'>View This Profile</a>"; ?>

Then to get the details of the clicked profile then you do this:

profile_page.php

if(isset($_GET['email']) && !empty($_GET['email'])){ $email = $_GET['email']; //THEN SELECT WHAT YOU NEED FROM TABLE WHERE EMAIL = $email }else{ //THE PERSON IS VIEWEING THE PAGE ILLEGAL DO SOMETHING }
本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(1条)

报告相同问题？

关注问题

如何从许多用户的列表中检索单个用户的数据 php
2017-05-12 09:42

回答 2 已采纳 The first thing that you need to do is to remove the $_SESSION['viewedEmail'] on the query string
在php中从动态表单中检索数据 php
2017-02-22 01:08

回答 1 已采纳 If you are having problems distinguishing between your radio buttons and other form fields, you co
从AJAX中检索PHP中formdata的数据 php
2019-05-01 22:36

回答 1 已采纳 Update your contentType: to contentType: false, Also Your checks should look similar to this: i
Rulerz：PHP中规范模式的强大实现
2021-02-03 23:39

规格，RulerZ是Specification模式PHP实现，重点放在三个主要方面：简单且与数据无关的定义业务规则和规范，检查候选人是否符合规格的能力，过滤或查询任何数据源以仅检索符合规范的候选者的能力。介绍可以使用...
如何使用PHP从mysql中正确检索数据？ mysql php
2017-04-23 04:57

回答 1 已采纳 Your error is caused by $results being false. That means that the query failed and it's probably b
如何从PHP中的多列SQL中检索数据 mysql php sql
2019-04-14 14:49

回答 2 已采纳 Since PID exists in both tables, it becomes ambiguous (meaning that SQL doesn't know which value i
所有从PHP中的ms访问数据库中检索数据 php
2019-04-06 07:00

回答 1 已采纳 You return only a single record in the JSON data because you do not iterate through the recordset.
Case Study: 利用JS设计高级检索功能通过PHP获取MySQL数据
2021-05-04 15:41

HaoranWu_ZJU的博客点击“ADD”按钮，能够添加检索条件，并通过逻辑运算下拉列表框指定“AND”“OR”或“NOT”逻辑运算关系，使PHP自动构建出复杂的数据检索式，从服务器的MySQL数据库中查找满足用户需求的数据。图1 数据库网页中的...
从Php函数中检索数据 php
2016-11-18 20:11

回答 1 已采纳 Well, this is working b <i class="<?php $this->Html->_($value['name']);?>"><
从数据透视表中检索单个列 - Laravel 5 laravel php
2015-06-17 07:45

回答 2 已采纳 I think what will help you achieve this behavior is the lists() method. Try something like $user
尝试从mysql数据库中检索登录的用户信息 html mysql php
2017-12-18 22:16

回答 1 已采纳 It looks like you might be able to run a query like this: $stmt = $DB_con->prepare('SELECT id,
万字详解PHP+Sphinx中文亿级数据全文检索实战（实测亿级数据0.1秒搜索耗时）
2024-03-29 17:04

小松聊PHP进阶的博客 Sphinx查询性能非常厉害，亿级数据下输入关键字，大部分能在0.01~0.1秒，少部分再5秒之内查出数据。 Sphinx 官方文档：http://sphinxsearch.com/docs/sphinx3.html 极简概括：由C++编写的高性能全文搜索引擎的开源...
php类和从数据库中检索数据的对象 php
2016-10-12 10:44

回答 1 已采纳 You can start with changing $reg= $this->var; to `$req=$var´ or assign ´$var´ to ´$this->var
php提取特定_如何从数组中提取特定字段 - php
2021-03-22 22:58

阿荣田Toronto的博客我可以将变量存储在现有的全局范围内，例如$_REQUEST['userInfo']，$_REQUEST['foo']和$_REQUEST['bar']等，然后将许多不同的内容放入请求范围内（这将是适当的用法，因为这些数据指的是要求自…php-casperjs获取...
casket:一个轻量级的 PHP ORM
2021-07-10 23:38

棺材最后更新：2014-05-02，克里斯·坦克斯利 Casket 是一个紧凑的 PHP 对象关系管理库。... 实体是需要持久化的单个对象，更常见的是在数据库中。实体看起来像这样： Class Animal { public $id;
没有解决我的问题, 去提问

悬赏问题

¥15 ubuntu22.04上安装ursim-3.15.8.106339遇到的问题
¥15 求螺旋焊缝的图像处理
¥15 blast算法（相关搜索：数据库）
¥15 请问有人会紧聚焦相关的matlab知识嘛？
¥15 网络通信安全解决方案
¥50 yalmip+Gurobi
¥20 win10修改放大文本以及缩放与布局后蓝屏无法正常进入桌面
¥15 itunes恢复数据最后一步发生错误
¥15 关于#windows#的问题：2024年5月15日的win11更新后资源管理器没有地址栏了顶部的地址栏和文件搜索都消失了
¥100 H5网页如何调用微信扫一扫功能？

如何从许多用户的列表中检索单个用户的数据

2条回答 默认 最新

悬赏问题

2条回答默认最新