📄 File: table.php

Path: /home2/outerorb/dev.outerorbittech.com/bhive/table.php

Size: 1.42 KB

Permissions: 0644

<?php 
// function to add connection page code
include"admin/connection.php";
$qe="
CREATE TABLE `aplicant` (
  `reg_id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  `reg_no` varchar(255) DEFAULT NULL,
  `name` varchar(40) DEFAULT NULL,
  `mobile` varchar(40) DEFAULT NULL,
  `email` varchar(40) DEFAULT NULL,
  `aadhar` varchar(40) DEFAULT NULL,
  `fname` varchar(40) DEFAULT NULL,
  `address` varchar(355) DEFAULT NULL,
  `pin` varchar(40) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `age` varchar(50) DEFAULT NULL,
  `relocate` varchar(20) DEFAULT NULL,
  `education` varchar(50) DEFAULT NULL,
  `institute` varchar(100) DEFAULT NULL,
  `university` varchar(100) DEFAULT NULL,
  `pass` varchar(20) DEFAULT NULL,
  `result` varchar(20) DEFAULT NULL,
  `night` varchar(20) DEFAULT NULL,
  `work` varchar(40) DEFAULT NULL,
  `epf` varchar(40) DEFAULT NULL,
  `fcertificate` varchar(10) DEFAULT NULL,
  `emp` varchar(40) DEFAULT NULL,
  `biodata` varchar(355) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `account` varchar(100) DEFAULT NULL,
  `ifsc` varchar(100) DEFAULT NULL,
  `bank` varchar(100) DEFAULT NULL,
  `pan` varchar(20) DEFAULT NULL,
  `joining` date DEFAULT NULL,
  `salary` varchar(50) DEFAULT NULL,
  `status` varchar(20) DEFAULT 'New'
)";
$sqe=mysqli_query($cn,$qe);
if($sqe)
	{
		echo 'created';
	}
	else 
	{
		// function to show sql query error 
		echo'<br>'.mysqli_error($cn);
	}

?>

← Back to Directory Edit File 🔒 Chmod