mysqli
Affichage des articles dont le libellé est mysqli. Afficher tous les articles
Affichage des articles dont le libellé est mysqli. Afficher tous les articles

Php : How To Search And Filter Data In Html Table Using Php And MySQL

19 Comments

Php How To Filter Data In Html Table Using Php And MySQL


________________________________________________________
In this Php Tutorial we will see How To Use Search Data In Html Table Using MySQL Database And Php .

 I Use In This Tutorial:
- NetBeans IDE .
- XAMPP .
- PhpMyAdmin .
 




Php Source Code:

<?php

if(isset($_POST['search']))
{
    $valueToSearch = $_POST['valueToSearch'];
    // search in all table columns
    // using concat mysql function
    $query = "SELECT * FROM `users` WHERE CONCAT(`id`, `fname`, `lname`, `age`) LIKE '%".$valueToSearch."%'";
    $search_result = filterTable($query);
    
}
 else {
    $query = "SELECT * FROM `users`";
    $search_result = filterTable($query);
}

// function to connect and execute the query
function filterTable($query)
{
    $connect = mysqli_connect("localhost", "root", "", "test_db");
    $filter_Result = mysqli_query($connect, $query);
    return $filter_Result;
}

?>

<!DOCTYPE html>
<html>
    <head>
        <title>PHP HTML TABLE DATA SEARCH</title>
        <style>
            table,tr,th,td
            {
                border: 1px solid black;
            }
        </style>
    </head>
    <body>
        
        <form action="php_html_table_data_filter.php" method="post">
            <input type="text" name="valueToSearch" placeholder="Value To Search"><br><br>
            <input type="submit" name="search" value="Filter"><br><br>
            
            <table>
                <tr>
                    <th>Id</th>
                    <th>First Name</th>
                    <th>Last Name</th>
                    <th>Age</th>
                </tr>

      <!-- populate table from mysql database -->
                <?php while($row = mysqli_fetch_array($search_result)):?>
                <tr>
                    <td><?php echo $row['id'];?></td>
                    <td><?php echo $row['fname'];?></td>
                    <td><?php echo $row['lname'];?></td>
                    <td><?php echo $row['age'];?></td>
                </tr>
                <?php endwhile;?>
            </table>
        </form>
        
    </body>
</html>



///////////////OUTPUT: 
php html table find
Search For W
                     

Php: Insert Update Delete Search In MySQL Database Using Php

21 Comments

Php Add , Edit , Remove , Find In MySQL Database Using Php With Source Code


________________________________________________________
In this Php Tutorial we will see How To Insert Update Delete Search Data In MySQL Database Table From html From With Php .

 I Use In This Tutorial:
- NetBeans IDE .
- XAMPP .
- PhpMyAdmin .

Part 1


Part 2



Php Source Code:

<?php

$host = "localhost";
$user = "root";
$password ="";
$database = "test_db";

$id = "";
$fname = "";
$lname = "";
$age = "";

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

// connect to mysql database
try{
    $connect = mysqli_connect($host, $user, $password, $database);
} catch (mysqli_sql_exception $ex) {
    echo 'Error';
}

// get values from the form
function getPosts()
{
    $posts = array();
    $posts[0] = $_POST['id'];
    $posts[1] = $_POST['fname'];
    $posts[2] = $_POST['lname'];
    $posts[3] = $_POST['age'];
    return $posts;
}

// Search

if(isset($_POST['search']))
{
    $data = getPosts();
    
    $search_Query = "SELECT * FROM users WHERE id = $data[0]";
    
    $search_Result = mysqli_query($connect, $search_Query);
    
    if($search_Result)
    {
        if(mysqli_num_rows($search_Result))
        {
            while($row = mysqli_fetch_array($search_Result))
            {
                $id = $row['id'];
                $fname = $row['fname'];
                $lname = $row['lname'];
                $age = $row['age'];
            }
        }else{
            echo 'No Data For This Id';
        }
    }else{
        echo 'Result Error';
    }
}


// Insert
if(isset($_POST['insert']))
{
    $data = getPosts();
    $insert_Query = "INSERT INTO `users`(`fname`, `lname`, `age`) VALUES ('$data[1]','$data[2]',$data[3])";
    try{
        $insert_Result = mysqli_query($connect, $insert_Query);
        
        if($insert_Result)
        {
            if(mysqli_affected_rows($connect) > 0)
            {
                echo 'Data Inserted';
            }else{
                echo 'Data Not Inserted';
            }
        }
    } catch (Exception $ex) {
        echo 'Error Insert '.$ex->getMessage();
    }
}

// Delete
if(isset($_POST['delete']))
{
    $data = getPosts();
    $delete_Query = "DELETE FROM `users` WHERE `id` = $data[0]";
    try{
        $delete_Result = mysqli_query($connect, $delete_Query);
        
        if($delete_Result)
        {
            if(mysqli_affected_rows($connect) > 0)
            {
                echo 'Data Deleted';
            }else{
                echo 'Data Not Deleted';
            }
        }
    } catch (Exception $ex) {
        echo 'Error Delete '.$ex->getMessage();
    }
}

// Edit
if(isset($_POST['update']))
{
    $data = getPosts();
    $update_Query = "UPDATE `users` SET `fname`='$data[1]',`lname`='$data[2]',`age`=$data[3] WHERE `id` = $data[0]";
    try{
        $update_Result = mysqli_query($connect, $update_Query);
        
        if($update_Result)
        {
            if(mysqli_affected_rows($connect) > 0)
            {
                echo 'Data Updated';
            }else{
                echo 'Data Not Updated';
            }
        }
    } catch (Exception $ex) {
        echo 'Error Update '.$ex->getMessage();
    }
}



?>


<!DOCTYPE Html>
<html>
    <head>
        <title>PHP INSERT UPDATE DELETE SEARCH</title>
    </head>
    <body>
        <form action="php_insert_update_delete_search.php" method="post">
            <input type="number" name="id" placeholder="Id" value="<?php echo $id;?>"><br><br>
            <input type="text" name="fname" placeholder="First Name" value="<?php echo $fname;?>"><br><br>
            <input type="text" name="lname" placeholder="Last Name" value="<?php echo $lname;?>"><br><br>
            <input type="number" name="age" placeholder="Age" value="<?php echo $age;?>"><br><br>
            <div>
                <!-- Input For Add Values To Database-->
                <input type="submit" name="insert" value="Add">
                
                <!-- Input For Edit Values -->
                <input type="submit" name="update" value="Update">
                
                <!-- Input For Clear Values -->
                <input type="submit" name="delete" value="Delete">
                
                <!-- Input For Find Values With The given ID -->
                <input type="submit" name="search" value="Find">
            </div>
        </form>
    </body>
</html>


///////////////OUTPUT:  
php add edit remove find
                     

Php : How To Use Mysqli Num Rows In Php

Add Comment

Php Code To Get Number Of Rows In Mysqli Result Using Mysql Database


________________________________________________________
In this Php Tutorial we will see How To Use mysqli_num_rows To Get Number Of Rows From Mysqli Result Using MySQL Database Table In With Php .

 I Use In This Tutorial:
- NetBeans IDE .
- XAMPP .
- PhpMyAdmin .
 




Php Source Code:

<?php

// PHP Using mysqli_num_rows Function
// get number of data in mysqli result

$host = "localhost";

$user = "root";

$pass = "";

$database = "test_db";

$connect = mysqli_connect($host, $user, $pass, $database);

$query = "SELECT * FROM users";

$result = mysqli_query($connect, $query);

$numRow = mysqli_num_rows($result);

echo "<h1>".$numRow."</h1>";


///////////////OUTPUT:  16
                     

Php Code : How To Update MySQL Database Table In Php Using Pdo

1 Comment

Php Code To Update Mysql Database Table Data Using Pdo.


________________________________________________________

 In this Php Tutorial we will Learn How To Update MySQL Database Table Data From Form Inputs In Php using Pdo.
I Use In This Tutorial:
- NetBeans IDE .
- XAMPP .
- PhpMyAdmin .
 




Php Source Code:

<?php

 // php update data in mysql database using PDO

 if(isset($_POST['update']))
{
    try {
        $pdoConnect = new PDO("mysql:host=localhost;dbname=test_db","root","");
    } catch (PDOException $exc) {
        echo $exc->getMessage();
        exit();
    }
    
    // get values form input text and number
    
    $id = $_POST['id'];
    $fname = $_POST['fname'];
    $lname = $_POST['lname'];
    $age = $_POST['age'];
    
    // mysql query to Update data
    
    $query = "UPDATE `users` SET `fname`=:fname,`lname`=:lname,`age`=:age WHERE `id` = :id";
    
    $pdoResult = $pdoConnect->prepare($query);
    
    $pdoExec = $pdoResult->execute(array(":fname"=>$fname,":lname"=>$lname,":age"=>$age,":id"=>$id));
    
    if($pdoExec)
    {
        echo 'Data Updated';
    }else{
        echo 'ERROR Data Not Updated';
    }

 }

 ?>

 <!DOCTYPE html>
<html>
    <head>
        <title>PHP UPDATE DATA USING PDO</title>
        <meta charset="UTF-8">
        <meta name="viewport" content="width=device-width, initial-scale=1.0">
    </head>
    <body>
        <form action="php_update_data_from_mysql_database_using_pdo.php" method="post">
            <input type="text" name="id" required placeholder="Id"><br><br>
            <input type="text" name="fname" required placeholder="First Name"><br><br>
            <input type="text" name="lname" required placeholder="Last Name"><br><br>
            <input type="number" name="age" required placeholder="Age" min="10" max="100"><br><br>
            <input type="submit" name="update" required placeholder="Update Data">
        </form>
    </body>
</html>


///////////////OUTPUT:
                     
php update mysql pdo
Php Update



Inscription à : Articles (Atom)