thanks a lot.. this simple
thanks a lot.. this simple program helps me in my project.. keep sharing.
<?php if(!$conn){ } ?>
<!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8" name="viewport" content="width=device-width, initial-scale=1"/> <link rel="stylesheet" type="text/css" href="css/bootstrap.css"/> </head> <body> <nav class="navbar navbar-default"> <div class="container-fluid"> <a class="navbar-brand" href="https://sourcecodester.com">Sourcecodester</a> </div> </nav> <div class="col-md-3"></div> <div class="col-md-6 well"> <h3 class="text-primary">PHP - Simple Filter Data By Daily</h3> <hr style="border-top:1px dotted #ccc;"/> <button type="button" class="btn btn-success" data-toggle="modal" data-target="#form_modal"><span class="glyphicon glyphicon-plus"></span> Add Product </button> <br /><br /> <form method="POST" class="form-inline" action=""> <label>Select a Day</label> <input type="date" class="form-control" name="date" required="required"/> <button class="btn btn-primary" name="filter"><span class="glyphicon glyphicon-search"></span> Filter</button> <a href="index.php" class="btn btn-warning"><span class="glyphicon glyphicon-refresh"></span></a> </form> <br /> <table class="table table-bordered"> <thead class="alert alert-info"> <tr> <th>Product Name</th> <th>Supplier Name</th> <th>Qty</th> <th>Date Released</th> </tr> </thead> <tbody style="background-color:#fff;"> <?php include 'get_day.php'?> </tbody> </table> </div> <div class="modal fade" id="form_modal" aria-hidden="true"> <div class="modal-dialog"> <div class="modal-content"> <form method="POST" action="save_product.php"> <div class="modal-header"> <h4 class="modal-title">Add Product</h4> </div> <div class="modal-body"> <div class="col-md-2"></div> <div class="col-md-8"> <div class="form-group"> <label>Product Name</label> <input type="text" class="form-control" name="product_name" required="required"/> </div> <div class="form-group"> <label>Supplier Name</label> <input type="text" class="form-control" name="supplier" required="required"/> </div> <div class="form-group"> <label>Quantity</label> <input type="number" class="form-control" name="qty" required="required"/> </div> <div class="form-group"> <label>Date Released</label> <input type="date" class="form-control" name="date_released" required="required"/> </div> </div> </div> <div style="clear:both;"></div> <div class="modal-footer"> <button class="btn btn-primary" name="save"><span class="glyphicon glyphicon-save"></span> Save</button> <button type="button" class="btn btn-danger" data-dismiss="modal"><span class="glyphicon glyphicon-remove"></span> Close</button> </div> </form> </div> </div> </div> <script src="js/jquery-3.2.1.min.js"></script> <script src="js/bootstrap.js"></script> </body> </html>
<?php require_once 'conn.php'; $product_name = $_POST['product_name']; $supplier = $_POST['supplier']; $qty = $_POST['qty']; $date_released = $_POST['date_released']; echo $date_released; mysqli_query($conn, "INSERT INTO `product` VALUES('', '$product_name', '$supplier', '$qty', '$date_released')"); } ?>
<?php require 'conn.php'; $date = $_POST['date']; $query = mysqli_query($conn, "SELECT * FROM `product` WHERE `date_released` = '$date' ORDER BY `product_name`") or die(mysqli_error()); ?> <tr> <td><?php echo $fetch['product_name']?></td> <td><?php echo $fetch['supplier']?></td> <td><?php echo $fetch['qty']?></td> </tr> <?php } }else{ ?> <?php $query = mysqli_query($conn, "SELECT * FROM `product` ORDER BY `date_released`") or die(mysqli_error()); ?> <tr> <td><?php echo $fetch['product_name']?></td> <td><?php echo $fetch['supplier']?></td> <td><?php echo $fetch['qty']?></td> </tr> <?php } ?> <?php } ?>