Wednesday, October 5, 2022
HomePHPEasy methods to Search Worker knowledge from Database utilizing PHP

Easy methods to Search Worker knowledge from Database utilizing PHP


<?php

require_once(“config.php”);

?>

<!DOCTYPE html>

<html lang=“en”>

<head>

<meta httpequiv=“content-type” content material=“textual content/html; charset=UTF-8”>

<meta charset=“utf-8”>

<title>PHP GURUKUL | DEMO</title>

<meta title=“generator” content material=“Bootply” />

<meta title=“viewport” content material=“width=device-width, initial-scale=1, maximum-scale=1”>

<hyperlink href=“https://phpgurukul.com/how-to-search-employee-data-from-database-using-php/css/bootstrap.min.css” rel=“stylesheet”>

<![if lt IE 9]>

<script src=“//html5shim.googlecode.com/svn/trunk/html5.js”></script>

<![endif]>

<hyperlink href=“css/kinds.css” rel=“stylesheet”>  

</head>

<physique>

<nav class=“navbar navbar-default navbar-fixed-top” function=“navigation”>

<div class=“navbar-header”>  

<h4 fashion=“padding-left: 100px;padding-top: 20px;”>PHP GURUKUL | Programming Weblog</h4>

</div>

</nav>

 

<div class=“container-fluid”>

  <!middle>

  <div class=“col-sm-8”>

    <div class=“row”>

      <div class=“col-xs-12”>

        <h3 fashion=“padding-left: 100px;”>Search worker knowledge from database on the foundation of Title, E mail, Cellular Quantity and Worker ID</h3>

<hr >

<kind title=“bwdatesdata” motion=“” methodology=“put up” motion=“”>

  <desk width=“100%” peak=“117”  border=“0”>

<tr>

    <th width=“27%” peak=“63” scope=“row”>Search :</th>

    <td width=“73%”>

<enter id=“searchdata” sort=“textual content” title=“searchdata” required=“true” class=“form-control”>

     </td>

  </tr>

 

<tr>

    <th width=“27%” peak=“63” scope=“row”></th>

    <td width=“73%”>

     <button class=“btn-primary btn” sort=“submit” title=“search”>Submit</button>

  </tr>

</desk>

     </kind>

      </div>

    </div>

    <hr>

      <div class=“row”>

      <div class=“col-xs-12”>

<?php if(isset($_POST[‘search’])) {

$sdata=$_POST[‘searchdata’];

  ?>

<h3 fashion=“padding-left: 100px;shade:blue”>End result towards <?php echo $sdata;?> key phrase</h3>

<hr >

<div class=“row”>

<desk class=“desk table-bordered” width=“100%”  border=“0” fashion=“padding-left:40px”>

<thead>

                      <tr>

                      <th scope=“col”>S.NO</th>

                      <th scope=“col”>Worker Title</th>

                      <th scope=“col”>Division</th>

                      <th scope=“col”>Cellular Quantity</th>

                      <th scope=“col”>E mail</th>

                      <th scope=“col”>Worker ID</th>

                       <th scope=“col”>Becoming a member of Date</th>

                       </tr>

                          </thead>

<?php

$ret=mysqli_query($con,“choose * from  tblempdata the place EmployeeName like ‘%$sdata%’ || E mail like ‘%$sdata%’ || MobileNumber like ‘%$sdata%’ || EmpID like ‘%$sdata%'”);

$num=mysqli_num_rows($ret);

if($num>0){

$cnt=1;

whereas ($row=mysqli_fetch_array($ret)) {

?>

<tbody>

<tr knowledgeexpanded=“true”>

            <td><?php echo $cnt;?></td>

                  <td><?php  echo $row[‘EmployeeName’];?></td>

                  <td><?php  echo $row[‘Department’];?></td>

                  <td><?php  echo $row[‘MobileNumber’];?></td>

                  <td><?php  echo $row[‘Email’];?></td>

                  <td> <?php  echo $row[‘EmpID’];?></td>

                  <td><?php  echo $row[‘JoiningDate’];?></td>

                </tr>

                 <?php

$cnt=$cnt+1;

} } else { ?>

  <tr>

    <td colspan=“8”> No document discovered towards this search</td>

  </tr>

<?php } }?>

</tbody>

</desk>

</div>

      </div>

    </div>

  </div><!/middle>

  <hr>

</div><!/containerfluid>

<! script references >

<script src=“//ajax.googleapis.com/ajax/libs/jquery/2.0.2/jquery.min.js”></script>

<script src=“js/bootstrap.min.js”></script>

</physique>

</html>

 

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments