How to Make ID Card Using PHP Mysql and HTML

-
In this article, you will learn How to Make an ID Card Using PHP Mysql and HTML.


  • index.php
  • view.php
  • id.php
  • print.php
  • upload.php
index.php
<?php 
mysql_connect('localhost','root','');
mysql_select_db('id_card');

?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="css/form.css"/>
</head>
<body>
  <div class="wrapper">
  <div class="header">
  <ul>
  <li><a href="index.php">Entry</a></li>
  <li><a href="view.php">View</a></li>
  <li><a href="print.php">Print</a></li>
  </ul>
  </div>
    <div class="inner_wrapper">
      <form method="POST" action="upload.php" enctype="multipart/form-data">
        <div class="row1">
       <h1>Form</h1>
     </div>
   <div class="row2">
  <div class="name1">
     <h2>Name</h2>
  </div>
  <div class="name2">
     <input type="text" name="name" placeholder="Name" />
  </div>
   </div>
   <div class="row3">
  <div class="qual1">
       <h2>Qualification</h2>
  </div>
  <div class="qual2">
       <select name="qualification" required="true"/>
    <option selected="true" disabled="true">Highest Qualification</option>
    <option value="MCA">MCA</option>
    <option value="MBA">MBA</option>
    <option value="M.A.">M.A.</option>
    <option value="M.Com">M.Com</option>
    <option value="B.Com">B.Com</option>
    <option value="BA">BA</option>
    <option value="BCA">BCA</option>
    <option value="BBA">BBA</option>
    <option value="DCA">DCA</option>
    <option value="+2">+2</option>
      <option value="10th">10th</option>
    </select>
  </div>
   </div>
   <div class="row4">
  <div class="com1">
     <h2>Company Name</h2>
  </div>
  <div class="com2">
     <input type="text" name="company" placeholder="Company Name"/>
  </div>
   </div>
   <div class="row5">
  <div class="des1">
     <h2>Designation</h2>
  </div>
  <div class="des2">
     <input type="text" name="designation" placeholder="Designation"/>
  </div>
   </div>
   <div class="row6">
    <div class="img1">
     <h2>Image</h2>
  </div>
  <div class="img2">
     <input type="file" name="file" />
  </div>
   </div>
   <div class="row7">
     <input type="submit" name="submit"/>
  <input type="reset" name="Reset"/>
   </div>
   </form>
 </div>
  </div>
</body>
</html>

view.php
<?php mysql_connect('localhost','root','');
mysql_select_db('id_card');
?>
<html>
<head><title>Report</title>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style>
table,tr,th,td{
border:1px solid;
border-collapse:collapse;
}
.print{
text-align:center;
margin:20px;
float:left;
}
button{
border-radius:5px;
cursor:pointer;
width:50px;
height:25px;
}
table{
    float: left;
    margin-left: -380px;
 margin-top:20px;
}
</style>
</head>
<body>
  <div class="header">
  <ul>
  <li><a href="index.php">Entry</a></li>
  <li><a href="view.php">View</a></li>
  <li><a href="print.php">Print</a></li>
  </ul>
  </div>
  
 <table>
 <tr>
 <th>Id</th>
 <th>Name</th>
 <th>Qualification</th>
 <th>Company Name</th>
 <th>Designation</th>
 <th>Image</th>
 <th>View</th>
 </tr>
 <?php 
 $query="select * from form ";
 $query1=mysql_query($query);
 while($result=mysql_fetch_array($query1)) { 
 ?>
 <tr>
 <td><?php echo $result['id'];?></td>
 <td><?php echo $result['name'];?></td>
 <td><?php echo $result['qualification'];?></td>
 <td><?php echo $result['company_name'];?></td>
 <td><?php echo $result['designation'];?></td>
 <td><?php echo $result['file'];?></td>
 <td><a href="id.php?id=<?php echo $result['id'];?>">View</a></td>
 </tr>
 <?php } ?>
 </table>
 <div class="print">
 <a href="print.php"><button>Print</button></a>
 </div>
</body>
</html>
id.php
<?php mysql_connect('localhost','root','');
mysql_select_db('id_card');
$id=$_GET['id'];
?>
<html>
<head><title>ID Card</title>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
</head>
<body>
  <div class="wrapper">
    <div class="header">
  <ul>
  <li><a href="index.php">Entry</a></li>
  <li><a href="view.php">View</a></li>
  <li><a href="print.php">Print</a></li>
  </ul>
  </div>
    <div class="inner_wrapper">
   <div class="col1">
    <?php
  $query="select * from form where id='$id'";
  $query1=mysql_query($query);
  while($result=mysql_fetch_array($query1)) { ?>
     <img src="image/<?php echo $result['file']; ?>" />
   </div>
   <div class="col2">
     <ul>
    <li>Name</li>
    <li>Qualification</li>
    <li>Company Name</li>
    <li>Designation</li> 
  </ul>
   </div>
   <div class="col3">
     <ul>
    <li>:</li>
    <li>:</li>
    <li>:</li>
    <li>:</li>
  </ul>
   </div>
   <div class="col4">
     <ul>
 
    <li><?php echo $result['name']; ?></li>
    <li><?php echo $result['qualification']; ?></li>
    <li><?php echo $result['company_name']; ?></li>
    <li><?php echo $result['designation']; ?></li>
  
   <?php } ?>
  </ul>
   </div>
 </div>
 <div class="back">
   <a href="index.php"><button>Back to Index</button></a>
 </div>
  </div>
</body>
</html>
print.php
<?php mysql_connect('localhost','root','');
mysql_select_db('id_card');
?>
<html>
<head><title>ID Card</title>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style>
.inner_wrapper{
margin:20px;
}
</style>
</head>
<body>
  <div class="wrapper">
    <div class="header">
  <ul>
  <li><a href="index.php">Entry</a></li>
  <li><a href="view.php">View</a></li>
  <li><a href="print.php">Print</a></li>
  </ul>
  </div><br><br>
    <?php
 $query="select * from form ";
 $query1=mysql_query($query);
 while($result=mysql_fetch_array($query1)) { ?>
      <div class="inner_wrapper">
     <div class="col1">
       <img src="image/<?php echo $result['file']; ?>" />
     </div>
   <div class="col2">
     <ul>
    <li>Name</li>
    <li>Qualification</li>
    <li>Company Name</li>
    <li>Designation</li> 
  </ul>
   </div>
   <div class="col3">
     <ul>
    <li>:</li>
    <li>:</li>
    <li>:</li>
    <li>:</li>
  </ul>
   </div>
   <div class="col4">
     <ul class="info">
    <li><?php echo $result['name']; ?></li>
    <li><?php echo $result['qualification']; ?></li>
    <li><?php echo $result['company_name']; ?></li>
    <li><?php echo $result['designation']; ?></li>
  </ul>
   </div>
 </div>
    <?php } ?>
    <div class="back">
   <a href="index.php"><button>Back to Index</button></a>
    </div>
  </div>
</body>
</html>
upload.php
<?php
mysql_connect('localhost','root','');
mysql_select_db('id_card');
if(isset($_POST['submit'])=='submit')
{    
    $name=$_POST['name'];
 $qual=$_POST['qualification'];
 $com=$_POST['company'];
 $desg=$_POST['designation'];
 $file = rand(1000,100000)."-".$_FILES['file']['name'];
    $file_loc = $_FILES['file']['tmp_name'];
 $file_size = $_FILES['file']['size'];
 $file_type = $_FILES['file']['type'];
 $folder="image/";
 
 // new file size in KB
 $new_size = $file_size/1024;  
 // new file size in KB
 
 // make file name in lower case
 $new_file_name = strtolower($file);
 // make file name in lower case
 
 $final_file=str_replace(' ','-',$new_file_name);
 
 if(move_uploaded_file($file_loc,$folder.$final_file))
 {
  $sql="INSERT INTO form(name,qualification,company_name,designation,file,type,size) VALUES('$name','$qual','$com','$desg','$final_file','$file_type','$new_size')";
  mysql_query($sql);
  ?>
  <script>
  alert('successfully uploaded');
        window.location.href='view.php?success';
        </script>
  <?php
 }
 else
 {
  ?>
  <script>
  alert('error while uploading file');
        window.location.href='index.php?fail';
        </script>
  <?php
 }
}
?>
Download the Source Code

Comments

Post a Comment

Popular posts from this blog

TOP RECRUITMENT COMPANIES IN INDIA

-
Image
Placement organization plays a vital role in matching potential candidates to employers. Today, the whole scenario of recruiting talented people has changed drastically as every company approaches placement agencies to hire candidates that would be valuable assets in the future. Every agency thoroughly checks the background details of candidates, interviews them, and trains them with professionals. Before going into detail about the top recruitment companies, we need to see the advantages of hiring through these organizations. Benefits For Recruiting Through Agencies:-  For the past, many year’s recruitment companies are taking the road map of agencies to hire the workforce, which has proven helpful as follow, 1. Quick hiring process 2. Meeting the purposes 3. Negotiate salary TOP RECRUITMENT COMPANIES IN INDIA 1. RANSSTAD INDIA Keeping the legacy of 28 years, the company has 57K+ temporary employees on-site and over 500K placement to date. The Ransstad is one of the best recruitme...
Read more

Best Indian Colleges For MBA

-
Image
  Every Master’s degree plays an important role in any student’s career. For pursuing a Master’s degree selection of the right college is a must. There are many best Indian colleges for MBA. These colleges will provide proper guidance and grooming which is the major need of every MBA student. Prestige Institute of Management And Research The organization has been Accredited Thrice Consecutively by NAAC with the most noteworthy Grade A++ now. The Institute is ISO 9001:2015 affirmed. In acknowledgment of its Performance and High principles in giving quality schooling, the Institute has been presented Autonomous Status by the University Grants Commission 2006, 2012, 2018 just as Devi Ahilya Vishwavidyalaya on the proposal of a powerful master board of trustees named by UGC to assess the Institute. This is a crucial achievement for the Institute. Eminence Institute of Management and Research is pleased to have set up AIC – Prestige Inspire Foundation under the aegis of Atal Innovation ...
Read more

Boost Your Brand New Site Up Google’s Ranking

-
Image
  The best way to rank any of your sites is through Google. There’s a no-brainer to that. Google is regarded as one of the most powerful tools to help you boost your site. If you have developed a brand new site, you should be aware of the effectiveness and importance of google. Google is the world’s biggest search engine which holds 88% of total searches and contains the world’s information, including webpages, images, videos, and much other information. Google SEO  is the most powerful tool to grow your website organically and the rest of other techniques include  Social Media Marketing , Email Marketing, Pay-Per-Click (PPC), and others. All sites want to rank up their sites on Google’s first page as most of the clicks come through the first page only; more than 75% of people don’t tend to go past Google’s first page. Step by Step Guide: Boost your Brand New Site up Google’s ranking To make your site grow, you should target to appear on google’s first page as more  ...
Read more