使用php更新概要文件 - Update profile using php

Update profile using php

本文关键字：文件更新 php 使用 | 更新日期: 2023-09-27

我正在做项目，我想在点击时使用php-mysql更新用户配置文件在更新按钮上显示第17行有错误。请帮助查找错误。

    <?php
    session_start();
    if(!isset($_SESSION["n"]))
       {
         header("location:error.php");
       }
    if(isset($_POST["s"]))
     {
      $name=$_POST["nm"];
      $lname=$_POST["lnm"];
      $address=$_POST["ad"];
      $u=$_SESSION["un"];
      $query = "SELECT * FROM signup";
      $result=mysqli_query($result,$query) or die(mysqli_connect_error());
      $i=0;
      while($row=mysqli_fetch_array($result))
      {
          $roll[$i]=$row['rollno'];
          $i++;
      }
      $total_elmt=count($roll);
         require_once("vars.php");
$conn=mysqli_connect(host,uname,pass,db) or die(mysqli_connect_error());

         $query="update signup set name='$nm',lname='$lnm',address='$ad' where user_id='$value'";
         $execute=mysqli_query($conn,$query);$r=mysql_affected_rows();
         mysqli_close($conn);
$msg="Your information is submitted successfully";
    }   
    ?>

您需要先打开数据库才能运行select查询。

将这一行移到顶部：

$conn=mysqli_connect(host,uname,pass,db) or die(mysqli_connect_error());
您使用mysqli_query函数错误。应该是

$result=mysqli_query($conn,$query) or die(mysqli_connect_error());

现在我已经更新了您的代码

 <?php
    session_start();
    if(!isset($_SESSION["n"]))
       {
         header("location:error.php");
       }
    if(isset($_POST["s"]))
     {
      $name = $_POST["nm"];
      $lname = $_POST["lnm"];
      $address = $_POST["ad"];
      $u = $_SESSION["un"];
$conn = mysqli_connect(host,uname,pass,db) or die(mysqli_connect_error());
      $query = "SELECT * FROM signup";
      $result = mysqli_query($conn, $query);
      $i=0;
      while($row=mysqli_fetch_array($result))
      {
          $roll[$i]=$row['rollno'];
          $i++;
      }
      $total_elmt=count($roll);
         require_once("vars.php");    
 $query="update signup set name='$nm',lname='$lnm',address='$ad' where user_id='$value'";
    $execute=mysqli_query($conn,$query);
    $r=mysql_affected_rows();
    mysqli_close($conn);
    $msg="Your information is submitted successfully";
        }   
        ?>