php编辑页面来编辑数据

Question

Hy there this side paras I am new in php development so here i am stuck with my code. It's not working as expected. Here is my code and I got error at line 46 but I dont know actually what is the error please help me to find it out

<?php
session_start();
    if(isset($_SESSION['uid']))
    {
        echo "";
    }
else
{
    header('location: ../login.php');
}

?>

<?php  
include ('header.php');
include ('titlehead.php');
?>  
<table align="center" border="1">
<form action="" method="post">
<tr>
<th>Enter Standerd</th>
<td><input type="number" name="standerd" placeholder="Enter Standerd"/></td>
<th>Enter Student Name</th>
<td><input type="name" name="stuname" placeholder="Enter Student Name"/></td>
<td colspan="2"><input type="submit" name="submit" value="Search"></td>
</tr>
</form>
</table>
<table align="center" width="80%" border="1" style="margin-top:10px;">
    <tr style="background-color:#000; color:#fff;">
        <th>No.</th>
        <th>Image</th>
        <th>Name</th>
        <th>Roll No.</th>
        <th>Edit</th>

    </tr>
    <?php
if(isset($_POST['submit']))
{
    include('../dbcon.php');
    $standerd = $_POST['standerd'];
    $name= $_POST['stuname'];
    $qry="SELECT * FROM `student`where standerd='$standerd' AND stuname='$name'";
    $run=mysqli_query($con,$qry);
    if(mysqli_num_rows($run)<1)
    {
        echo "<tr><td>No Records Found</td></tr>";
    }
    else
    {   
        $count=0;
        while($data=mysqli_fetch_assoc($run))
        {
            $count++;
            ?>
            <tr>
                <td><?php echo $count;?></td>
                <td><img src="../dataimg/<?php echo $data['image'];?>" style="widht:50px;" height='50px';/></td>
                <td><?php  echo $data['name']; ?></td>
                <td><?php  echo $data['rollno']; ?></td>
                <td>Edit</td>
          </tr>

          <?php
        }
    }
}
    ?>
</table> 

so here is my problem enter image description here

Answer 1

Your query has an error. I believe you forgot a whitespace between studentand where.

SELECT * FROM `student` where standerd='$standerd' AND stuname='$name'

Otherwise check your credentials.