Posts

Showing posts from May, 2020

Vehicle Parking Management System

Image
Project Name:  Company Visitor Management System Programming Language:  PHP Database:  MySQLi User Interface Design       :   HTML, AJAX,JQUERY,JAVASCRIPT Web Browser:   Google Chrome, Mozilla, IE8, OPERA Software/Application:  XAMPP / Wamp The project has made with PHP and Mysqli. Using this application adds the record of vehicle IN/OUT. Module:- Dashboard Vehicle Category In-Vehicle Out Vehicle Search Reports How to run the Vehicle Parking Management System 1. Download the  zip file 2. Extract the file and copy the vpms folder 3.Paste inside root directory(for xampp xampp/htdocs) 4. Open PHPMyAdmin (http://localhost/phpmyadmin) 5. Create a database with name vpmsdb 6. Import vpmsdb.sql file(given inside the zip package ) 7.Run the script http://localhost/vpms (frontend) Free Download  

How to Import Data in PHP using Mysql Database

Image
index.php <html> Mhead> <title>Import Data in PHP</title> </head> <body> <form action="import.php" method="post" name="upload_excel" enctype="multipart/form-data"> <fieldset> <legend>Import CSV/Excel file</legend> <div class="control-group"> <div class="control-label"> <label>CSV/Excel File:</label> </div> <div class="controls"> <input type="file" name="file" id="file" class="input-large"> </div> </div> <div class="control-group"> <div class="controls"> <button type="submit" id="submit" name="Import" class="btn btn-primary button-loading" data-loading-text="Loading...">Upload</

How to Make Active or Inactive in PHP With Mysql Database

Image
<?php mysql_connect('localhost','root',''); mysql_select_db('database'); if(!empty($_GET['status_id'])&&isset($_GET['status_id'])) { $status_id = $_GET['status_id']; $status = $_GET['status']; $query = "update menus set status = '$status' where id = '$status_id'"; mysql_query($query); header("location:menus.php"); } // Active / De-Active Record ?> <html> <head> <title>Active/Deactive</title> </head> <body> <form method="POST"> <table border="1"> <?php $query = "select * from table"; $result = mysql_query($query); $row = mysql_fetch_assoc($result) ?> <tr> <th>Items db</th> <?php $status = $row['status']; if($status == 1): ?> <td style="text-align:center;"

How to File Upload in Database using PHP

Image
Follow below steps: HTML Code: file.php <html> <head> <title>File Upload</title> <form method="post" enctype="multipart/form-data" action="upload.php"> <input class="tbl2" type="file" name="f"><span class="txt1">(Type : .jp/* /* eg, .jpg, .gif, .png)</span> <input class="butt2 bt" type="submit" value="save" name="save"> </form> </body> </html> PHP Code: upload.php <?php include('db.php'); if(!empty($_REQUEST['save'])) { $st2=1; $filename=$_FILES['f']['name']; $filepath=$_FILES['f']['tmp_name']; $ext=end(explode('.',$filename)); $query="show table status like 'product'"; $fullfilename=$id.".".$ext; { $query="insert into product(filename) values('$fullfilename'