下拉菜单在编辑时没有选择php中的选定选项

i'm selecting option while adding,but selected option is not in edit dropdown.
What will be the issue?

Edit Appointment.php:

<?php
include_once 'config.php';
$id = $_REQUEST['id'];
$query="SELECT p.*,u.fileno FROM patients AS p,users AS u WHERE p.id_patient='$id' AND p.users_id_user=u.id_user";
$resultPatient=$db->select($query);
if(isset($_POST['requesttype'])&&$_POST['requesttype'] == 'editPatient'){
    $updateInfo=array();
    $updateInfo['name'] = $_REQUEST['name'];
    $updateInfo['email'] = $_REQUEST['email'];
    $updateInfo['age'] = $_REQUEST['age'];
    /*$updateInfo['age'] = $_REQUEST['age'];
    $updateInfo['gender'] = $_REQUEST['gender'];*/
    $updateInfo['phone'] = str_replace(array('(',')',' ','-'), array('','','',''),$_REQUEST['phone']);
    $updateInfo['date'] = date('d-m-Y', strtotime($_REQUEST['date']));
    $updateInfo['time'] = $_REQUEST['time'];
    $updateInfo['confirm_status'] = 'c';
    $date=date('Y-m-d H:i:s');
    $updateInfo['date_updated']=$date;
    $updateCondition=" id_patient='".$id."'";
    $res=$db->update('patients', $updateInfo,$updateCondition);
    $id=$resultPatient[0]['users_id_user'];
    $where="t.users_id_user='$id' AND";
    $query="SELECT t.device_id,t.platforms_id_platform as id_platform FROM tokens as t WHERE $where t.device_id!=''";
    $resultTokens=$db->select($query);
    if($resultTokens)
    {
        include_once 'Gcm.php';
        include_once 'Apns.php';
        $deviceTokens=array();
        $deviceTokens1=array();
        $alert='Your appointment is confirmed on '.$updateInfo['date'].' at '.$updateInfo['time'];
        foreach($resultTokens as $token)
        {
            if($token['id_platform']=='1'&&$token['device_id']!='')
                $deviceTokens[]=$token['device_id'];
            if($token['id_platform']=='2'&&$token['device_id']!='')
                $deviceTokens1[]=$token['device_id'];
        }
        if(count($deviceTokens)>0)
        {
            $apns=new Apns();
            $apns->apnsPush($deviceTokens,$alert);
        }
        if(count($deviceTokens1)>0)
        {
            $gcm = new GCM();
            $message = array("m" => $alert);
            $result = $gcm->send_notification($deviceTokens1,$message);
        }
    }
    header("Location:appointments.php?m=u");
} 
$querySlot = "SELECT * FROM slots";
$resultSlot=$db->select($querySlot);

$query="select * from photos where type='service'";
$resultUsers1=$db->select($query);
include_once 'header.php';

?>
<script type="text/javascript" src="js/jquery.timepicker.js"></script>
  <link rel="stylesheet" type="text/css" href="js/jquery.timepicker.css" />
<script>
                $(function() {
                    $('#basicExample').timepicker();
                });
            </script>
<!-- Sidebar begins -->
<div id="sidebar">

    <!-- Left Main menu begins -->
        <?php include_once 'menu.php'; ?>
    <!-- Left Main menu ends -->


    <!-- Secondary nav --> 
    <div class="secNav">
        <div class="secWrapper">
            <!--div class="secTop">
            </div-->

            <!-- Tabs container -->
            <div id="tab-container" class="tab-container">
            <div id="general">

                    <!-- Sidebar big buttons -->
                     <div id="general" style="display: block;" class="active">
                      <ul class="subNav">
                        <li><a href="add_appointment.php" title=""><span class="icos-images2"></span>Add Appointment</a></li>
                        <li class="activeli"><a href="appointments.php" title="" class="this"><span class="icos-images2"></span>View/Edit Appointments</a></li>
                        <li><a href="appointments_history.php" title=""><span class="icos-images2"></span>Appointments History</a></li>
                        <li><a href="reminder_settings.php" title=""><span class="icos-images2"></span>View/Edit Reminder Settings</a></li>
                        <li><a href="add_reminder_settings.php" title=""><span class="icos-images2"></span>Add Reminder Settings</a></li>
                        <li><a href="medicine_reminder_settings.php" title=""><span class="icos-images2"></span>View/Edit Medicine Reminder Settings</a></li>
                        <li><a href="add_medicine_reminder_settings.php" title=""><span class="icos-images2"></span>Add Medicine Reminder Settings</a></li>
                    </ul>
                </div>   
                </div>                

            </div>


       </div> 
       <div class="clear"></div>
   </div>
</div>
<!-- Sidebar ends -->


<!-- Content begins -->
<div id="content">
    <div class="contentTop">
        <span class="pageTitle"><span class="icon-screen"></span>Edit Appointment</span>
        <div class="clear"></div>
    </div>

    <!-- Breadcrumbs line -->
    <div class="breadLine">
        <div class="bc">
            <ul id="breadcrumbs" class="breadcrumbs">
                <li><a href="#">Dashboard</a></li>
                <li><a href="appointments.php">Appointments</a></li>
                <li class="current"><a href="#" title="">Edit Appointment</a></li>
            </ul>
        </div>

    </div>
    <!-- Main content -->
    <div class="wrapper">


        <div class="fluid">
            <form name="formEditAppointment" id="usualValidate" class="main" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST" enctype="multipart/form-data">
                <div class="widget grid6 chartWrapper" style="width:100%;min-height:550px;">
                    <div class="whead"><h6>Edit Appointment Information</h6><div class="clear"></div></div>
                    <div class="formRow">
                        <div class="grid3"><label>File No:<span class="req">*</span></label></div>
                        <div class="grid9"><?php echo stripslashes($resultPatient[0]['fileno']);?></div>
                        <div class="clear"></div>
                    </div>
                    <div class="formRow">
                        <div class="grid3"><label>Name:<span class="req">*</span></label></div>
                        <div class="grid9"><input type="text" class="required" name="name" id="name" value="<?php echo stripslashes($resultPatient[0]['name']);?>"/></div>
                        <div class="clear"></div>
                    </div>
                    <div class="formRow">
                        <div class="grid3"><label>Email:</label></div>
                        <div class="grid9"><input type="text" class="email" name="email" id="email" value="<?php echo stripslashes($resultPatient[0]['email']);?>"/></div>
                        <div class="clear"></div>
                    </div>
                    <div class="formRow">
                        <div class="grid3"><label>Age:</label></div>
                        <div class="grid9"><input type="text" class="required" name="age" id="age" value="<?php echo stripslashes($resultPatient[0]['age']);?>"/></div>
                        <div class="clear"></div>
                    </div>
                    <div class="formRow">
                        <div class="grid3"><label>Service:<span class="req">*</span></label></div>
                        <div class="grid9 searchDrop"><select data-placeholder="select service..." class="select" style="width: 100%" name="id_service"> 

                            <?php if($resultUsers1 && count($resultUsers1)>0)
                                foreach($resultUsers1 as $user)
                                {?>                
                                <option value="<?php echo $user['id_photo']?>"<?php if($user['id_photo']==$user['title']) { ?> selected="selected" <?php } ?>><?php echo $user['title'];?></option>
                            <?php }?>
                            </select></div>
                        <div class="clear"></div>
                    </div>

                    <div class="formRow">
                        <div class="grid3"><label>Phone:</label></div>
                        <div class="grid9"><input type="text" name="phone" id="phone" value="<?php echo stripslashes($resultPatient[0]['phone']);?>"/></div>
                        <div class="clear"></div>
                    </div>
                    <div class="formRow">
                        <div class="grid3"><label>Date:</label></div>
                        <div class="grid9"><input type="text" class="required datepicker" name="date" id="date" value="<?php echo date('d-m-Y',strtotime($resultPatient[0]['date']));?>"/></div>
                        <div class="clear"></div>
                    </div>
                    <div class="formRow">
                        <div class="grid3"><label>Time:</label></div>
                        <div class="grid9 searchDrop">
                           <input id="basicExample" type="text" name="time"  class="time" value="<?php echo stripslashes($resultPatient[0]['time']);?>" style="width:80px"/>
                        </div>
                        <div class="clear"></div>
                    </div>
                    <input type="hidden" value="<?php echo $id; ?>" name="id" id="id_patient"/>
                    <input type="hidden" value="editPatient" name="requesttype"/>
                    <div class="formRow">

                        <div class="formSubmit">

                            <input class="buttonM bRed" id="next1" value="Save" type="submit">
                            <div class="clear"></div>
                        </div>     <div class="clear"></div>                   
                    </div>
                    <div class="clear"></div></div>

            </form>
       </div>

    </div>
    <!-- Main content ends -->

</div>
<!-- Content ends -->

</body>
</html>

Add Appointment.php:

<?php
include_once 'config.php';
if(isset($_POST['requesttype'])&&$_POST['requesttype'] == 'addPatient'){
    $insertInfo=array();
    $insertInfo['users_id_user'] = $_REQUEST['id_user'];
    $insertInfo['name'] = $_REQUEST['name'];
    $insertInfo['email'] = $_REQUEST['email'];
    $insertInfo['age'] = $_REQUEST['age'];
    $insertInfo['gender'] = $_REQUEST['act'];
    $insertInfo['service_id']=$_REQUEST['id_service'];
    $insertInfo['phone'] = str_replace(array('(',')',' ','-'), array('','','',''),$_REQUEST['phone']);
    $insertInfo['date'] = date('d-m-Y', strtotime($_REQUEST['date']));
    $insertInfo['time'] = $_REQUEST['time'];
    $insertInfo['confirm_status'] = 'c';
    $date=date('Y-m-d H:i:s');
    $insertInfo['date_created']=$date;
    $insertInfo['date_updated']=$date;
    $res=$db->insert('patients', $insertInfo);
    $id=$_REQUEST['id_user'];
    $where="t.users_id_user='$id' AND";
    $query="SELECT t.device_id,t.platforms_id_platform as id_platform FROM tokens as t WHERE $where t.device_id!=''";
    $resultTokens=$db->select($query);
    if($resultTokens)
    {
        include_once 'Gcm.php';
        include_once 'Apns.php';
        $deviceTokens=array();
        $deviceTokens1=array();
        $alert='Your appointment is confirmed on '.$insertInfo['date'].' at '.$insertInfo['time'];
        foreach($resultTokens as $token)
        {
            if($token['id_platform']=='1'&&$token['device_id']!='')
                $deviceTokens[]=$token['device_id'];
            if($token['id_platform']=='2'&&$token['device_id']!='')
                $deviceTokens1[]=$token['device_id'];
        }
        if(count($deviceTokens)>0)
        {
            $apns=new Apns();
            $apns->apnsPush($deviceTokens,$alert);
        }
        if(count($deviceTokens1)>0)
        {
            $gcm = new GCM();
            $message = array("m" => $alert);
            $result = $gcm->send_notification($deviceTokens1,$message);
        }
    }
    header("Location:appointments.php?m=a");
} 
$query="SELECT * FROM users";
$resultUsers=$db->select($query);



//$query="SELECT * FROM services";
$query="select * from photos where type='service'";
$resultUsers1=$db->select($query);
include_once 'header.php';

?>
  <script type="text/javascript" src="js/jquery.timepicker.js"></script>
  <link rel="stylesheet" type="text/css" href="js/jquery.timepicker.css" />
<script>
                $(function() {
                    $('#basicExample').timepicker();
                });
            </script>
<!-- Sidebar begins -->
<div id="sidebar">

    <!-- Left Main menu begins -->
        <?php include_once 'menu.php'; ?>
    <!-- Left Main menu ends -->


    <!-- Secondary nav --> 
    <div class="secNav">
        <div class="secWrapper">
            <!--div class="secTop">
            </div-->

            <!-- Tabs container -->
            <div id="tab-container" class="tab-container">
            <div id="general">

                    <!-- Sidebar big buttons -->
                     <div id="general" style="display: block;" class="active">
                      <ul class="subNav">
                        <li class="activeli"><a href="add_appointment.php" title="" class="this"><span class="icos-images2"></span>Add Appointment</a></li>
                        <li><a href="appointments.php" title=""><span class="icos-images2"></span>View/Add Appointments</a></li>
                        <li><a href="appointments_history.php" title=""><span class="icos-images2"></span>Appointments History</a></li>
                        <li><a href="reminder_settings.php" title=""><span class="icos-images2"></span>View/Add Reminder Settings</a></li>
                        <li><a href="add_reminder_settings.php" title=""><span class="icos-images2"></span>Add Reminder Settings</a></li>
                        <li><a href="medicine_reminder_settings.php" title=""><span class="icos-images2"></span>View/Add Medicine Reminder Settings</a></li>
                        <li><a href="add_medicine_reminder_settings.php" title=""><span class="icos-images2"></span>Add Medicine Reminder Settings</a></li>
                    </ul>
                </div>   
                </div>                

            </div>


       </div> 
       <div class="clear"></div>
   </div>
</div>
<!-- Sidebar ends -->


<!-- Content begins -->
<div id="content">
    <div class="contentTop">
        <span class="pageTitle"><span class="icon-screen"></span>Add Appointment</span>
        <div class="clear"></div>
    </div>

    <!-- Breadcrumbs line -->
    <div class="breadLine">
        <div class="bc">
            <ul id="breadcrumbs" class="breadcrumbs">
                <li><a href="#">Dashboard</a></li>
                <li><a href="appointments.php">Appointments</a></li>
                <li class="current"><a href="#" title="">Add Appointment</a></li>
            </ul>
        </div>

    </div>
    <!-- Main content -->
    <div class="wrapper">


        <div class="fluid">
            <form name="formAddAppointment" id="usualValidate" class="main" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST" enctype="multipart/form-data">
                <div class="widget grid6 chartWrapper" style="width:100%;min-height:680px;">
                    <div class="whead"><h6>Add Appointment Information</h6><div class="clear"></div></div>
                    <div class="formRow">
                        <div class="grid3"><label>File No:<span class="req">*</span></label></div>
                        <div class="grid9 searchDrop"><select data-placeholder="Choose a File No..." class="select" style="width: 100%" name="id_user"> 
                                <option value='0'>All</option>
                            <?php if($resultUsers && count($resultUsers)>0)
                                foreach($resultUsers as $user)
                                {?>                
                                <option value="<?php echo $user['id_user']?>"><?php echo $user['fileno']?></option>
                            <?php }?>
                            </select></div>
                        <div class="clear"></div>
                    </div>
                    <div class="formRow">
                        <div class="grid3"><label>Name:<span class="req">*</span></label></div>
                        <div class="grid9"><input type="text" class="required" name="name" id="name"/></div>
                        <div class="clear"></div>
                    </div>
                    <div class="formRow">
                        <div class="grid3"><label>Email:</label></div>
                        <div class="grid9"><input type="text" class="email" name="email" id="email"/></div>
                        <div class="clear"></div>
                    </div>
                    <div class="formRow">
                        <div class="grid3"><label>Age:</label></div>
                        <div class="grid9"><input type="text" class="required" name="age" id="age"/></div>
                        <div class="clear"></div>
                    </div>



                    <div class="formRow">
                        <div class="grid3"><label>Sex:</label></div>
                        <div class="grid9 check"><label for="solve" class="mr20">Male:</label><input style="margin-top:5px;" type="radio" id="solve"  name="act" value="m" class="required"/><label for="solve1"  class="mr20">Female:</label><input style="margin-top:5px;" type="radio" id="solve1"  name="act" value="f" /></div>
                        <div class="clear"></div>
                    </div>        

                   <div class="formRow">
                        <div class="grid3"><label>Service:<span class="req">*</span></label></div>
                        <div class="grid9 searchDrop"><select data-placeholder="select service..." class="select" style="width: 100%" name="id_service"> 
                                <option value='0'>All</option>
                            <?php if($resultUsers1 && count($resultUsers1)>0)
                                foreach($resultUsers1 as $user)
                                {?>                
                                <option value="<?php echo $user['id_photo']?>"><?php echo $user['title']?></option>
                            <?php }?>
                            </select></div>
                        <div class="clear"></div>
                    </div>

                    <div class="formRow">
                        <div class="grid3"><label>Phone:</label></div>
                        <div class="grid9"><input type="text" name="phone" id="phone" /></div>
                        <div class="clear"></div>
                    </div>
                    <div class="formRow">
                        <div class="grid3"><label>Date:</label></div>
                        <div class="grid9"><input type="text" class="required datepicker" name="date" id="date" value="<?php echo date('d-m-Y',strtotime('now'));?>"/></div>
                        <div class="clear"></div>
                    </div>
                    <div class="formRow">
                        <div class="grid3"><label>Time:</label></div>
                        <div class="grid9 searchDrop">
                           <input id="basicExample" type="text" class="time" style="width:80px" name="time"/>
                        </div>
                        <div class="clear"></div>
                    </div>
                    <input type="hidden" value="addPatient" name="requesttype"/>
                    <div class="formRow">

                        <div class="formSubmit">

                            <input class="buttonM bRed" id="next1" value="Save" type="submit">
                            <div class="clear"></div>
                        </div>     <div class="clear"></div>                   
                    </div>
                    <div class="clear"></div></div>

            </form>
       </div>

    </div>
    <!-- Main content ends -->

</div>
<!-- Content ends -->

</body>
</html>

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

1条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
douxunzui1519 2015-02-26 06:15
关注
Find this code <?php if($user['id_photo']==$user['title']) { ?>. You should check the database value with the option value when you edit. Replace with <?php if($user['id_photo']==$resultPatient[0]['id_photo']) { ?> and check.

本回答被题主选为最佳回答 , 对您是否有帮助呢?

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

评论

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

报告相同问题？

关注问题

下拉菜单在编辑时没有选择php中的选定选项 php
2015-02-26 06:09

回答 1 已采纳 Find this code <?php if($user['id_photo']==$user['title']) { ?>. You should check the databa
如何在PHP中选择下拉菜单中的哪个选项？ html php
2017-04-06 14:12

回答 4 已采纳 This way: Select should be named and options only have value <TD> <select id = "myLi
PHP / HTML在sql查询的下拉列表中显示选定的选项 html mysql php
2017-01-30 02:34

回答 3 已采纳 You can do it with less repetition using ternary operators: function access_option($access) {
php 获取菜单选中,获取的下拉菜单中选择项目，并在PHP
2021-05-08 06:56

佯良的博客使用它，我已经从数据库中获取列表联盟(如预期该列表中填充)下面的下拉列表获取的下拉菜单中选择项目，并在PHPCoalitionsinclude_once 'connection.php';$sql_coalition = mysqli_query($conn, "SELECT coalition ...
如何在PHP中的动态下拉列表中显示选定的值 php
2019-05-11 10:00

回答 2 已采纳 You can approach this as <?php $selectedOption = ''; if($_POST){ $selectedOption = $_POST['se
提交表单时保留PHP创建的下拉菜单值 php
2017-10-04 18:02

回答 2 已采纳 When you're looping through, check if the submitted value equals the current value. If it does, s
使用下拉菜单从mysql表中选择值时填充html表单 javascript php
2018-09-05 11:22

回答 2 已采纳 You can apply new attribute in order to get more then one value from drop down list. Solution
html下拉菜单提交后保留选中值而不返回默认值
2020-12-13 21:29

复制代码代码如下:<... <body> <?php // 获取select值 $select_value = ...php // 如果在上面获取的值和这个option里的值一样， // 就打印selected，让这个option默认被选中 echo $select_value == ‘option1
在php中显示下拉选中的选项 html php
2015-12-15 11:17

回答 3 已采纳 <select name="v" class='Product'> <option value="fkt">Flipkart</option>
如何从php下拉菜单中添加选择和更新图像 html javascript jquery php
2015-04-16 23:40

回答 2 已采纳 Not sure what you plan to do with 'facePic' as I don't see it in your output. For your PHP: echo
使用php在下拉菜单中缩写状态 database php
2015-11-20 03:10

回答 2 已采纳 That is why code indentation is so important.. You were missing closing PHP tags at two places. Re
php中下拉列表怎么弄,如何访问PHP中多选下拉列表中选择的值？
2021-03-25 10:07

weixin_39605894的博客我使用Jquery Multiselect Widget有一个带有mulitselect选项的下拉列表框.我正在使用MySql数据库中的数据填充下拉列表.我无法将多个值传递给$_POST中的php文件.我的HTML& Multiselect DropDown的PHP代码.Last 1 ...
如何在PHP中更改SQL查询与用户选择的下拉菜单相关 html mysql php sql
2016-12-25 22:14

回答 1 已采纳 try this: $jobtype = isset($_POST['varjobtype']) ? $_POST['varjobtype'] : ''; $industry = isset($
php如何制作一级下拉菜单,excel中下拉菜单如何制作，一级、二级下拉菜单做法有什么区别...
2021-04-29 02:49

aurging的博客 Excel下拉菜单是一个比较实用的技巧，当我们需要输入重复的内容的时候比较的方便，比如给学生输入性别、班级、户籍等等，今天就给大家介绍一下excel下拉菜单的制作方法。首先给大家介绍一下不做excel下拉菜单也可以...
wordpress下拉菜单_下拉导航：如何在WordPress上维护选定的选项
2020-06-19 18:39

daique1908的博客在上一教程中，我们学习了如何使用select元素进行导航并在页面加载时保持选定的选项。为了演示它，我们使用了一个带有一些静态页面的示例项目。今天，我们将更进一步，讨论将此功能集成到WordPress网站中所需的...
没有解决我的问题, 去提问

悬赏问题

¥100 c语言，请帮蒟蒻写一个题的范例作参考
¥15 名为“Product”的列已属于此 DataTable
¥15 安卓adb backup备份应用数据失败
¥15 eclipse运行项目时遇到的问题
¥15 关于#c##的问题：最近需要用CAT工具Trados进行一些开发
¥15 南大pa1 小游戏没有界面，并且报了如下错误，尝试过换显卡驱动，但是好像不行
¥15 没有证书，nginx怎么反向代理到只能接受https的公网网站
¥50 成都蓉城足球俱乐部小程序抢票
¥15 yolov7训练自己的数据集
¥15 esp8266与51单片机连接问题(标签-单片机|关键词-串口)（相关搜索：51单片机|单片机|测试代码）

下拉菜单在编辑时没有选择php中的选定选项

1条回答 默认 最新

悬赏问题

1条回答默认最新