douxiajia6720 2017-08-16 08:03
浏览 27

使用mysqli使用php连接数据库

It's not working. The code i used is

    <?php
        $conn=mysqli_connect('127.0.0.1','root','');
        if(!$conn)
        {
            echo "Connection Not Established";
        }
        if(!mysqli_select_db($conn,'lpractice'))
        {
            echo "Database Not Found!";
        }
        $res=mysqli_query($conn,"select * from signup");
        echo "<table>";
            while($row= mysql_fetch_array($res))
            {
                echo "<tr>";
                echo "<td>" . $row['name'] . "</td>";
                echo "<td>" . $row['email'] . "</td>";
                echo "<td>" . $row['age'] . "</td>";
                echo "<td>" . $row['sex'] . "</td>";
                echo "</tr>"

            }
        echo "</table>";
    ?>

And the output coming is

"; while($row= mysql_fetch_array($res)) { echo ""; echo "" . $row['name'] . ""; echo "" . $row['email'] . ""; echo "" . $row['age'] . ""; echo "" . $row['sex'] . ""; echo "" } echo ""; ?>
  • 写回答

3条回答 默认 最新

  • dream6120 2017-08-16 08:09
    关注

    mysqli_fetch_array not mysql_fetch_array and you're missing a ; after your echo "</tr>"

    评论

报告相同问题?

悬赏问题

  • ¥15 多址通信方式的抗噪声性能和系统容量对比
  • ¥15 winform的chart曲线生成时有凸起
  • ¥15 msix packaging tool打包问题
  • ¥15 finalshell节点的搭建代码和那个端口代码教程
  • ¥15 用hfss做微带贴片阵列天线的时候分析设置有问题
  • ¥15 Centos / PETSc / PETGEM
  • ¥15 centos7.9 IPv6端口telnet和端口监控问题
  • ¥20 完全没有学习过GAN,看了CSDN的一篇文章,里面有代码但是完全不知道如何操作
  • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
  • ¥20 海浪数据 南海地区海况数据,波浪数据