duanqun7761 2018-06-08 19:57
浏览 21
已采纳

无法使用php获取用于更新记录的数据

Trying to update a record unable to fetch the data from database.Getting a blank page not getting any data from database.

<?php
include 'includes/db.php';
$id = (int)$_GET['appoint_id'];
$sql = "SELECT * FROM appointment WHERE appoint_id = '$id'";
$run = mysqli_query($conn,$sql);
while ($row = mysqli_fetch_assoc($run)){
    $firstname = $row['first_name'];
    $lastname = $row['last_name'];        
}   
?>

<form class="form-horizontal" action="update.php" method="post" role="form">
    <input  type='hidden' value='<?=$id;?>' name='appoint_id'>
    <div class="body">
        <div class="row clearfix">
            <div class="col-sm-6 col-xs-12">
                <div class="form-group">
                    <div class="form-line">
                        <input type="text" class="form-control" value="<?php echo $row['first_name'];?>" name="first_name" id="first_name" required>
                    </div>
                </div>
            </div>
            <div class="col-sm-6 col-xs-12">
                <div class="form-group">
                    <div class="form-line">
                        <input type="text" class="form-control" value="<?php echo $row['last_name'];?>" name="last_name" id="last_name" required>
                    </div>
                </div>
            </div>
        </div>
    </div>
</form>

update.php

<?php include 'includes/db.php';
if(isset($_POST['submit_user'])){
        $ins_sql = "UPDATE first_name,last_name appointment  WHERE appoint_id = '$id' ";
        $run_sql = mysqli_query($conn,$ins_sql);
    }else {
        echo "not updated";
    }
 ?>

Not displaying any errors in error log as well.

  • 写回答

2条回答 默认 最新

  • douqiang1851 2018-06-09 10:54
    关注
    ?php session_start();
    include 'includes/db.php';  
    $id = (int)$_GET['id'];
    $sql = "SELECT * FROM appointment WHERE appoint_id = $id";
    $oppointArr =array();
    $result = mysqli_query($conn,$sql);
    if (mysqli_num_rows($result) > 0) {
    
      while($row = mysqli_fetch_array($result)) {          
           $oppointArr = $row;
           echo "Name: " . $row["first_name"]. "<br>";
          }
      } else {
      echo "0 results";
     }
    //mysqli_close($conn);
     ?>
    

    Query for fetching the data for a particular record

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 测距传感器数据手册i2c
  • ¥15 RPA正常跑,cmd输入cookies跑不出来
  • ¥15 求帮我调试一下freefem代码
  • ¥15 matlab代码解决,怎么运行
  • ¥15 R语言Rstudio突然无法启动
  • ¥15 关于#matlab#的问题:提取2个图像的变量作为另外一个图像像元的移动量,计算新的位置创建新的图像并提取第二个图像的变量到新的图像
  • ¥15 改算法,照着压缩包里边,参考其他代码封装的格式 写到main函数里
  • ¥15 用windows做服务的同志有吗
  • ¥60 求一个简单的网页(标签-安全|关键词-上传)
  • ¥35 lstm时间序列共享单车预测,loss值优化,参数优化算法