dongliang1941 2018-03-14 09:09
浏览 116
已采纳

我的PHP代码中出现了一些语法错误,我无法解决

I am getting some syntax error in my PHP code, which I am unable to solve. Please have a look at this and help me to solve this. Here Is The Screenshot.

I have attached the screenshot of the error which I am getting on line 14.

<?php
    $link = mysqli_connect('localhost','root','','satyam');
    if(isset($_POST['name']))
    {
        $name = $_POST['name'];
        $sql = "SELECT * FROM students WHERE name='".$name."'";
        $sql_run = mysqli_query($link,$sql);
        if($row=mysqli_fetch_array($sql_run))
        {
            $name = $row["name"];
            $roll = $row["roll"];
            $branch = $row["branch"];
            $address = $row["address"];
            echo 'Name: '.$name.' Roll: '.$roll.' Branch: '.$branch.' Address: '.$address';
        } else {
            echo "No Record Found";
        }
    }
?>
  • 写回答

5条回答 默认 最新

  • drl9940 2018-03-14 09:11
    关注

    You added an extra unnecessary single quote (') end of the following line

    echo 'Name: ' . $name . ' Roll: ' . $roll . ' Branch: ' . $branch . ' Address: ' . $address;
    

    This code works fine.

    $link = mysqli_connect('localhost','root','','satyam');
    if(isset($_POST['name'])) {
        $name    = $_POST['name'];
        $sql     = "SELECT * FROM students WHERE name='" . $name."'";
        $sql_run = mysqli_query($link,$sql);
        if($row = mysqli_fetch_array($sql_run)) {
            $name    = $row["name"];
            $roll    = $row["roll"];
            $branch  = $row["branch"];
            $address = $row["address"];
            echo 'Name: ' . $name . ' Roll: ' . $roll . ' Branch: ' . $branch . ' Address: ' . $address;
        } else {
            echo "No Record Found";
        }
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(4条)

报告相同问题?

悬赏问题

  • ¥15 YoloV5 第三方库的版本对照问题
  • ¥15 请完成下列相关问题!
  • ¥15 drone 推送镜像时候 purge: true 推送完毕后没有删除对应的镜像,手动拷贝到服务器执行结果正确在样才能让指令自动执行成功删除对应镜像,如何解决?
  • ¥15 求daily translation(DT)偏差订正方法的代码
  • ¥15 js调用html页面需要隐藏某个按钮
  • ¥15 ads仿真结果在圆图上是怎么读数的
  • ¥20 Cotex M3的调试和程序执行方式是什么样的?
  • ¥20 java项目连接sqlserver时报ssl相关错误
  • ¥15 一道python难题3
  • ¥15 牛顿斯科特系数表表示