i am try for search from database code is this below
//this is search form
<!DOCTYPE html>
<title>Search Example
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
Search
//this is show table and search
<?php
$con = mysqli_connect('localhost','root','','labrptdb') or die('Unable To connect');
if(count($_POST)>0) {
$lab = isset($_POST["labno"]) ?? '';
$result=mysqli_query($con,"select * from report where labno = '$lab'");
}
?>
<!DOCTYPE html>
<title>Image retrieve
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<?php
$i=0;
while($row = mysqli_fetch_array($result)) {
if($i%2==0)
$reportname="even";
else
$reportname="odd";
?>
<?php
$i++;
}
?>
ID | NAME | CONTACT NO. | ADDRESS | LAB NO. | AGE | GENDER | REF.DOCTOR | IMAGE | TIME | UPDATE AND DELETE |
<?php echo $row["id"]; ?> | <?php echo $row["name"]; ?> | <?php echo $row["contactno"]; ?> | <?php echo $row["address"]; ?> | <?php echo $row["labno"]; ?> | <?php echo $row["age"]; ?> | <?php echo $row["gender"]; ?> | <?php echo $row["refdoctor"]; ?> | <?php echo ''; ?> | <?php echo $row["datetime"]; ?> | ">Delete
">Update |
<?php
mysqli_close($con);
?>
and the error show
( ! ) Notice: Undefined variable: conn in E:\wamp\www\addform\searchreport_pat.php on line 6
Call Stack
# Time Memory Function Location
1 0.0000 367376 {main}( ) ...\searchreport_pat.php:0
( ! ) Warning: mysqli_affected_rows() expects parameter 1 to be mysqli, null given in E:\wamp\www\addform\searchreport_pat.php on line 6
Call Stack
# Time Memory Function Location
1 0.0000 367376 {main}( ) ...\searchreport_pat.php:0
2 0.0930 400912 mysqli_affected_rows ( ) ...\searchreport_pat.php:6
What I have tried:
<?php
$con = mysqli_connect('localhost','root','','labrptdb') or die('Unable To connect');
if(count($_POST)>0) {
$lab = isset($_POST["labno"]) ?? '';
$result=mysqli_query($con,"select * from report where labno = '$lab'");
}
?>
<?php
$i=0;
while($row = mysqli_fetch_array($result)) {
if($i%2==0)
$reportname="even";
else
$reportname="odd";
?>
<?php echo $row["id"]; ?> <?php echo $row["name"]; ?> <?php echo $row["contactno"]; ?> <?php echo $row["address"]; ?> <?php echo $row["labno"]; ?> <?php echo $row["age"]; ?> <?php echo $row["gender"]; ?> <?php echo $row["refdoctor"]; ?> <?php echo ''; ?> <?php echo $row["datetime"]; ?>
">Delete
">Update <?php
$i++;
}
<?php mysqli_close(con) ; ?>