1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / olunne-energy.com /
Filename : add-input.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 () );

//Add Price Information

if(isset($_POST['submit']))
{
    $name = mysqli_real_escape_string($con, $_POST['name']);
    $price = mysqli_real_escape_string($con, $_POST['price']);
  
    $sql1 =mysqli_query($con,"SELECT `name` FROM `prices` WHERE `name`='$name' ");
	$count=mysqli_num_rows($sql1);

	if($count>0)
    {
	$msg="Product already exists";
    $type = "warning";

    } else{

    $sql2="INSERT INTO `prices` (`name`,`price`) VALUES  ('$name','$price')";
    $result1=mysqli_query($con,$sql2);
      if($result1){ 
          $msg="Price Information Updated Successfully!";
          $type = "success";
          }else{
          $msg="Failed to Update Price Information";
          $type = "warning";
      }

}
}
?>

 <!--/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> Add Input</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">Add New</h6>

            </div>

            <?php if(isset($msg)) { ?>
                <div class="error-wrapper-<?php echo $type?>">
                <span class="message-<?php echo $type?>"><?php echo $msg; ?></span>
                </div>
                <?php }?>
            <div class="contact-grids  mt-5 ">
                    <form action="" method="post" class="signin-form">
                        <div class="input-grids">
                          <label class="mb-2" style="color:black;font-size:16px;">Name </label>
                          <input type="text" name="name" id=""  class="contact-input" required="" />
                        </div>
                        <div class="input-grids">
                         <label class="mb-2" style="color:black;font-size:16px;">Price </label>
                         <input type="text" name="price" id=""  class="contact-input" required="" />
                       </div>
                     
                        <div class="submit-w3l-button text-lg-right">
                            <button type="submit" name="submit" 
                            class="btn btn-style btn-primary">Add +</button>
                        </div>
                    </form>

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


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