Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <meta http-equiv="X-UA-Compatible" content="IE=edge">
- <meta name="viewport" content="width=device-width, initial-scale=1">
- <meta name="description" content="">
- <meta name="author" content="">
- <title>Sales Portal</title>
- <!-- Bootstrap Core CSS -->
- <link href="../bower_components/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
- <!-- MetisMenu CSS -->
- <link href="../bower_components/metisMenu/dist/metisMenu.min.css" rel="stylesheet">
- <!-- Custom CSS -->
- <link href="../dist/css/sb-admin-2.css" rel="stylesheet">
- <!-- Custom Fonts -->
- <link href="../bower_components/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
- <link href="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.11.4/themes/smoothness/jquery-ui.css">
- <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
- <!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
- <!--[if lt IE 9]>
- <script src="https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
- <script src="https://oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
- <![endif]-->
- <script>
- // This is an old version, for a more recent version look at
- // https://jsfiddle.net/DRSDavidSoft/zb4ft1qq/2/
- function maxLengthCheck(object)
- {
- if (object.value.length > object.maxLength)
- object.value = object.value.slice(0, object.maxLength)
- }
- </script>
- <script>
- $(function() {
- $( "#name1" ).autocomplete({
- source: 'suggestproduct.php'
- });
- });
- </script>
- <script type="text/javascript">
- $(document).ready(function(){
- $('#name1').on('change',function(){
- var pr = $(this).val();
- if(pr){
- $('#price').attr('value',0);
- $.ajax({
- type:'POST',
- url:'ajaxData.php',
- data:'pr='+pr,
- success:function(html){
- $('#price').html(html);
- }
- });
- }else{
- $('#price').val(0);
- }
- });
- </script>
- </head>
- <body>
- <div id="wrapper">
- <!-- Navigation -->
- <nav class="navbar navbar-default navbar-static-top" role="navigation" style="margin-bottom: 0">
- <div class="navbar-header">
- <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
- <span class="sr-only">Toggle navigation</span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- <span class="icon-bar"></span>
- </button>
- <a class="navbar-brand" href="index.html">UnivFranchisee</a>
- </div>
- <!-- /.navbar-header -->
- <ul class="nav navbar-top-links navbar-right">
- <!-- /.dropdown -->
- <li class="dropdown">
- <a class="dropdown-toggle" data-toggle="dropdown" href="#">
- <i class="fa fa-bell fa-fw"></i> <i class="fa fa-caret-down"></i>
- </a>
- <ul class="dropdown-menu dropdown-alerts">
- <li>
- <a href="#">
- <div>
- <i class="fa fa-comment fa-fw"></i> New Comment
- <span class="pull-right text-muted small">4 minutes ago</span>
- </div>
- </a>
- </li>
- <li class="divider"></li>
- <li>
- <a href="#">
- <div>
- <i class="fa fa-twitter fa-fw"></i> 3 New Followers
- <span class="pull-right text-muted small">12 minutes ago</span>
- </div>
- </a>
- </li>
- <li class="divider"></li>
- <li>
- <a href="#">
- <div>
- <i class="fa fa-envelope fa-fw"></i> Message Sent
- <span class="pull-right text-muted small">4 minutes ago</span>
- </div>
- </a>
- </li>
- <li class="divider"></li>
- <li>
- <a href="#">
- <div>
- <i class="fa fa-tasks fa-fw"></i> New Task
- <span class="pull-right text-muted small">4 minutes ago</span>
- </div>
- </a>
- </li>
- <li class="divider"></li>
- <li>
- <a href="#">
- <div>
- <i class="fa fa-upload fa-fw"></i> Server Rebooted
- <span class="pull-right text-muted small">4 minutes ago</span>
- </div>
- </a>
- </li>
- <li class="divider"></li>
- <li>
- <a class="text-center" href="#">
- <strong>See All Alerts</strong>
- <i class="fa fa-angle-right"></i>
- </a>
- </li>
- </ul>
- <!-- /.dropdown-alerts -->
- </li>
- <!-- /.dropdown -->
- <li class="dropdown">
- <a class="dropdown-toggle" data-toggle="dropdown" href="#">
- <i class="fa fa-user fa-fw"></i> <i class="fa fa-caret-down"></i>
- </a>
- <ul class="dropdown-menu dropdown-user">
- <li><a href="#"><i class="fa fa-user fa-fw"></i> User Profile</a>
- </li>
- <li><a href="#"><i class="fa fa-gear fa-fw"></i> Settings</a>
- </li>
- <li class="divider"></li>
- <li><a href="login.html"><i class="fa fa-sign-out fa-fw"></i> Logout</a>
- </li>
- </ul>
- <!-- /.dropdown-user -->
- </li>
- <!-- /.dropdown -->
- </ul>
- <!-- /.navbar-top-links -->
- <div class="navbar-default sidebar" role="navigation">
- <div class="sidebar-nav navbar-collapse">
- <ul class="nav" id="side-menu">
- <li class="sidebar-search">
- <div class="input-group custom-search-form">
- <input type="text" class="form-control" placeholder="Search...">
- <span class="input-group-btn">
- <button class="btn btn-default" type="button">
- <i class="fa fa-search"></i>
- </button>
- </span>
- </div>
- <!-- /input-group -->
- </li>
- <li>
- <a href="#"><i class="fa fa-dashboard fa-fw"></i> Master<span class="fa arrow"></span></a>
- <ul class="nav nav-second-level">
- <li>
- <a href="unit_master.html"> Unit Master</a>
- </li>
- <li>
- <a href="ctype.html"> Card Type</a>
- </li>
- <li>
- <a href="#">Card Master</a>
- </li>
- <li>
- <a href="#">Activate Card</a>
- </li>
- <li>
- <a href="#">Value Card Recharge Req.</a>
- </li>
- <li>
- <a href="#">Car Segment</a>
- </li>
- <li>
- <a href="#">Service Master</a>
- </li>
- <li>
- <a href="#">Discount Master</a>
- </li>
- <li>
- <a href="#">Product Category Master</a>
- </li>
- <li>
- <a href="#">Product Master</a>
- </li>
- <li>
- <a href="#">Rate Master</a>
- </li>
- <li>
- <a href="#">Download Master</a>
- </li>
- <li>
- <a href="#">Stock Master</a>
- </li>
- <li>
- <a href="#">Vendor Master</a>
- </li>
- <li>
- <a href="#">Purchase Entry</a>
- </li>
- <li>
- <a href="#">Branch Office Master</a>
- </li>
- <li>
- <a href="#">Create User</a>
- </li>
- </ul>
- </li>
- <li>
- <a href="#"><i class="fa fa-sitemap fa-fw"></i> Franchize<span class="fa arrow"></span></a>
- <ul class="nav nav-second-level">
- <li>
- <a href="#">Create Franchisee</a>
- </li>
- <li>
- <a href="#">Manage Royality</a>
- </li>
- <li>
- <a href="#">Manage BM Calls</a>
- </li>
- </ul>
- <!-- /.nav-second-level -->
- </li>
- <li>
- <a href="#"><i class="fa fa-wrench fa-fw"></i> Application<span class="fa arrow"></span></a>
- <ul class="nav nav-second-level">
- <li>
- <a href="#">Latest News & Events</a>
- </li>
- <li>
- <a href="#">Target Vs. Acheivement</a>
- </li>
- <li>
- <a href="#">Schemes And Offers</a>
- </li>
- <li>
- <a href="#">Change Password</a>
- </li>
- </ul>
- <!-- /.nav-second-level -->
- </li>
- <li>
- <a href="#"><i class="fa fa-files-o fa-fw"></i> Admin Sale<span class="fa arrow"></span></a>
- <ul class="nav nav-second-level">
- <li>
- <a href="#">Purchase Request</a>
- </li>
- <li>
- <a href="#">Balance Amount</a>
- </li>
- <li>
- <a href="#">Proposal Invoice</a>
- </li>
- <li>
- <a href="#">Sale WithOut PO</a>
- </li>
- </ul>
- <!-- /.nav-second-level -->
- </li>
- <li>
- <a href="#"><i class="fa fa-bar-chart-o fa-fw"></i> Report<span class="fa arrow"></span></a>
- <ul class="nav nav-second-level">
- <li>
- <a href="#">Stock Report</a>
- </li>
- <li>
- <a href="#">Value Card Report</a>
- </li>
- <li>
- <a href="#">Service Report</a>
- </li>
- <li>
- <a href="#">Proposal Invoice Report</a>
- </li>
- <li>
- <a href="#">Admin Sale Report</a>
- </li>
- <li>
- <a href="#">Franchise Sale Report</a>
- </li>
- <li>
- <a href="#">Job Card Report</a>
- </li>
- <li>
- <a href="#">Royalty Reports</a>
- </li>
- <li>
- <a href="#">Target Vs Achievment Reports</a>
- </li>
- </ul>
- <!-- /.nav-second-level -->
- </li>
- <li>
- <a href="#"><i class="fa fa-files-o fa-fw"></i> Help</a>
- <ul class="nav nav-second-level">
- </ul>
- <!-- /.nav-second-level -->
- </li>
- </ul>
- </div>
- <!-- /.sidebar-collapse -->
- </div>
- <!-- /.navbar-static-side -->
- </nav>
- <div id="page-wrapper">
- <div class="row">
- <div class="col-lg-12">
- <h1 class="page-header">Sales Portal</h1>
- </div>
- <!-- /.col-lg-12 -->
- </div>
- <!-- /.row -->
- <div class="row">
- <div class="col-lg-12">
- <div class="panel panel-default">
- <div class="panel-heading">
- Fields marked with <span style="color: red">*</span> are compulsory.</div>
- <div class="panel-body">
- <div class="row">
- <form method='POST' action='createfr.php'>
- <div class="col-lg-6">
- <div class="form-group">
- <label>Product Name</label>
- <span style="color: red">*</span>
- <input name="name1" id='name1' required class="form-control">
- </div>
- </div>
- <!-- /.col-lg-6 (nested) -->
- <div class="col-lg-6">
- <div class="form-group">
- <label>Customer Name</label>
- <span style="color: red">*</span>
- <input name="cname" required class="form-control">
- </div>
- </div>
- <div class="col-lg-6">
- <div class="form-group">
- <label>Mobile Number</label>
- <span style="color: red">*</span>
- <input type="number" maxlength="10" oninput="maxLengthCheck(this)" name="num1" required class="form-control">
- </div>
- </div>
- <div class="col-lg-6">
- <div class="form-group">
- <label>Email ID</label>
- <input type="email" name="eid1" class="form-control">
- </div>
- </div>
- <div class="col-lg-6">
- <div class="form-group">
- <label>Purchase Date</label>
- <input name="pdate" class="form-control" type="date" Disabled value="<?php echo date('Y-m-d'); ?>">
- </div>
- </div>
- <div class="col-lg-6">
- <div class="form-group">
- <label>Price</label>
- <span style="color: red">*</span>
- <input type="number" name="price" id='price'class="form-control">
- </div>
- </div>
- <!-- /.col-lg-6 (nested) -->
- </div>
- <div class="row text-center">
- <button name="submit" type="submit" class="btn btn-default">Submit</button>
- <button type="reset" class="btn btn-default">Clear</button>
- </div>
- </form>
- <?php
- if(isset($_POST["submit"]))
- {
- $data1=$_POST["name1"];
- $data6=$_POST["num1"];
- $data7=$_POST["eid1"];
- $data12=$_POST["pdate"];
- // DATABASE Details SET server user and password
- $servername='localhost'; $username='root'; $password='';
- $dbname='franchisee'; $tbname='sales';
- // Create connection
- $conn = mysqli_connect($servername, $username, $password);
- // Check connection
- if (!$conn) {
- die("Connection failed: " . mysqli_connect_error());
- }
- $sql = "INSERT INTO $tbname (name,uid,pass,cname,addr,mob,email,cst,stax,vat,rlty,sdate,edate)
- VALUES ('$data1','$data2','$data3','$data4','$data5',$data6,'$data7',$data8,$data9,$data10,$data11,'$data12','$data13')";
- //Create DB
- if(!mysqli_query($conn,"CREATE DATABASE IF NOT EXISTS $dbname")){echo "Error Creating DB : " . $sql . "<br>" . mysqli_error($conn);}
- //Create Table
- if(!mysqli_query($conn,"CREATE TABLE IF NOT EXISTS `$dbname`.`$tbname` (id int(11) NOT NULL UNIQUE AUTO_INCREMENT,name varchar(25),uid varchar(20) PRIMARY KEY,mob int(15),email varchar(50),pdate date)")){echo "Error Creating Table : " . $sql . "<br>" . mysqli_error($conn);}
- //Select DB
- mysqli_select_db($conn, $dbname);
- if (mysqli_query($conn, $sql)) {
- echo "<br/><h3>User: ".$data2." added successfully</h3><br/>";
- } else {
- echo "Error: " . $sql . "<br>" . mysqli_error($conn);
- }
- }
- ?>
- <!-- /.row (nested) -->
- </div>
- <!-- /.panel-body -->
- </div>
- <!-- /.panel -->
- </div>
- <!-- /.col-lg-12 -->
- </div>
- <!-- /.row -->
- </div>
- <!-- /#page-wrapper -->
- </div>
- <!-- /#wrapper -->
- <!-- jQuery -->
- <script src="../bower_components/jquery/dist/jquery.min.js"></script>
- <!-- Bootstrap Core JavaScript -->
- <script src="../bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
- <!-- Metis Menu Plugin JavaScript -->
- <script src="../bower_components/metisMenu/dist/metisMenu.min.js"></script>
- <!-- Custom Theme JavaScript -->
- <script src="../dist/js/sb-admin-2.js"></script>
- <script src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.11.4/i18n/jquery-ui-i18n.js"></script>
- <script src=""></script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement