Posts

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  
Post a Comment
Read more

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</
Post a Comment
Read more

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;"
Post a Comment
Read more

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'
Post a Comment
Read more

How to Connect the Database in PHP

-
Image
We will tell you how to connect the database in PHP. In any PHP file for insert/Delete/update/fetch data from Mysql database. we have to create a connection with the Mysql database. This connection will be the type of the database is Mysql. Follow the bellow Code to creating a connection with the Mysql database. Method 1: <?php mysql_connect('localhost', 'root', 'pass'); mysql_select_db('databse'); ?> localhost : is the Host of the Server root ; is the username of the Database pass : is the password of the Database database : is the name of the Mysql database Method 2: <?php $dbhost = 'localhost:3306'; $dbuser = 'root'; $dbpass = 'pass'; $conn = mysql_connect($dbhost, $dbuser, $dbpass); if(! $conn ) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close(
Post a Comment
Read more

How to Update Data into Database using PHP

-
Image
index.php <html> <head> <title>Update Data</title> </head> <body> <form method="post" action="update.php" enctype="multipart/form-data"> <div class="name"> <div class="name1"><h1>Student Name:</h1></div> <div class="name2"><input type="text" name="name" value="<?php echo $row['name']; ?>" /></div> </div> <div class="name"> <div class="name1"><h1>Father Name:</h1></div> <div class="name2"><input type="text" name="father_name" value="<?php echo $row['father_name']; ?>" /></div> </div> <div class="name"> <div class="name1"><h1>Mother Name:</h1></div> <div class="name2"><input type="
Post a Comment
Read more

How to Delete Data From Mysql Database

-
Image
table.php <?php include(db.php); ?> <html> <head> <title>Table</title> </head> <body> <div class="table"> <div class="tab1"><h1>Name</h1></div> <div class="tab1"><h1>Father name</h1></div> <div class="tab1"><h1>Mother name</h1></div> <div class="tab1"><h1>E-mail</h1></div> <div class="tab1"><h1>Address</h1></div> <div class="tab1"><h1>DOB</h1></div> <div class="tab1"><h1>Category</h1></div> <div class="tab1"><h1>Image</h1></div> <div class="tab1"><h1>Action</h1></div> <div class="tab1"><h1>Delete</h1></div> <?php $query1 = "select * from n
Post a Comment
Read more