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

Popular posts from this blog

Student Result Management System

TOP RECRUITMENT COMPANIES IN INDIA

What Is The Job Role Of A Customer Support Executive?