1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / olunne-energy.com /
Filename : dashboard.php
back
<?php
session_start();
error_reporting(0);
include('../config/oconfig.php');
include('includes/checklogin.php');

include 'includes/header.php'; 
$currentTime = date( 'd-m-Y h:i:s A', time () );

//Update Price Information
if(isset($_POST['submit']))
{
  $pid = mysqli_real_escape_string($con, $_POST['prod']);
  $pms = mysqli_real_escape_string($con, $_POST['pms']);

  $updateQuery = "UPDATE `prices` SET `price`='$pms' WHERE `id`='$pid' ";	
			$res = mysqli_query($con, $updateQuery);
            if($res){
                $msg="Price Information Updated Successfully!";
                $type = "success";
        }else{
                $msg="Failed to Update Price Information";
                $type = "warning";
        }
}

if(isset($_GET['del']))
		  {
		          mysqli_query($con,"DELETE FROM  `prices` WHERE `id` = '".$_GET['id']."'");
                  echo "<script>window.location.href='dashboard.php';</script>";

		  }

?>

 <!--/inner-page-->
 <div class="inner-banner py-5">
        <section class="w3l-breadcrumb text-left py-sm-5 ">
            <div class="container">
                <div class="w3breadcrumb-gids">
                    <div class="w3breadcrumb-left text-left">
                        <h2 class="inner-w3-title">
                           Dashboard</h2>
                     
                    </div>
                    <div class="w3breadcrumb-right">
                        <ul class="breadcrumbs-custom-path">
                            <li><a href="index.php">Home</a></li>
                            <li class="active"><span class="fas fa-angle-double-right mx-2"></span> Dashboard</li>
                        </ul>
                    </div>
                </div>

            </div>
        </section>
    </div>
    <!--//inner-page-->


     <!-- contact-form 2 -->
     <section class="w3l-contact-2 py-5" id="contact">
        <div class="container py-lg-4 py-md-3 py-2">
            <div class="title-content text-center">
                <h3 class="title-w3l mb-2"></h3>
                <h6 class="title-subw3hny mb-1">Current Prices</h6>
              
                <?php if(isset($msg)) { ?>
                <div class="error-wrapper-<?php echo $type?>">
                <span class="message-<?php echo $type?>"><?php echo $msg; ?></span>
                </div>
                <?php }?>


            </div>

            <div class="contact-grids  mt-5 ">
                        <?php 
            $query="SELECT * FROM `prices` ";
            $result=mysqli_query($con,$query);
            $cnt=1;
            if(mysqli_num_rows($result)>0){

            while($pro=mysqli_fetch_array($result)){
            $pname=$pro['name']
            ?>

            <form action="" method="post" class="signin-form">
                        <div class="input-grids">
                           <input type="hidden" name="prod" value="<?php echo $pro['id']; ?>">
                          <label class="mb-2" style="color:black;font-size:16px;text-transform:uppercase">
                          <?php echo $pro['name']; ?> </label>
                          <input type="text" name="pms" id="" value="<?php echo $pro['price']; ?>" class="contact-input" required="" />
                        </div>
                     
                        <div class="submit-w3l-button text-lg-right">
                            <button type="submit" name="submit" 
                            class="btn btn-style btn-primary">Update 
                            <span style="text-transform:uppercase"><?php echo $pro['name']; ?></span></button>

                            <a href="?id=<?php echo $pro['id'];?>&del=delete" 
                        onClick="return confirm('Are you sure you want to delete?')" class="btn btn-style btn-danger">
                        Delete</a>
                        </div>
                    </form>

                  
                    <?php } 
                    }else{
                        echo"
                        <div class='card-body'>
                    <p style='text-align:left'> No Product Yet</p>
                        </div>
                        ";
                    }
                    ?>


                   
                  

            </div>
        </div>
    </section>
    <!-- /contact-form-2 -->
    <!-- //contacts -->


<?php 
include 'includes/footer.php';
?>