<?php
//code for adding the child theme inclusion so we don't break anything
?>
<!--the game begins here-->

<!--Self written code of the form submission-->

<?php
function add_data_func_table() {
	//Fistly we check if the tables exist, if not , constructing it
	global $wpdb;
	//below set the prefix of wp_ in the table name
	$nitk_table= $wpdb->prefix. "nitk_alumni_db";
	//this check below checks if the table this exist, if not, the if code is executed
	if ($wpdb->get_var("SHOW TABLES LIKE '$nitk_table'") != $nitk_table ) {
		//creating the sql table of the alumni database here.
		//Now we do charset collation before creation which basically mean adding sql useful stuff such as encoding charset etc in the table. Collate means combining so it combine all the info
		$charset = $wpdb->get_charset_collate();
		$sql_query = "CREATE TABLE $nitk_table (
					id mediumint(9) NOT NULL AUTO_INCREMENT,
					name varchar(30) NOT NULL,
					year int(4) NULL,
					branch varchar(30) NULL,
					city varchar(20) NULL,
					phone bigint(15) null,
					email varchar(320) NOT NULL,
					age int(3) NULL,
					UNIQUE KEY id (id)
						)$charset;";

		//This reuire statment is reuired for running of the dbDelta function which is stored in upgrade.php file
		require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
		//dbDelta checks and create the table by executing sql statement of the above
		dbDelta($sql_query);
	}
ob_start();
	?>
<!--Now we are making form in which we will take the data and then use wpdb->insert to put it in table-->
<form action="#" method="post" >
	<label>Name</label>
		<input type="text" name="alum_name">
	<label>Year</label>
		<input type="text" name="alum_year">
	<label>Branch</label>
		<input type="text" name="alum_branch">
	<label>City</label>
		<input type="text" name="alum_city">
	<label>Phone</label>
		<input type="text" name="alum_phone">
	<label>Email</label>
		<input type="text" name="alum_email">
	<label>Age</label>
		<input type="text" name="alum_age">

		<input type="submit" name="submit_form" value="Submit">
</form>

<?php
$html = ob_get_clean();
if (isset($_POST['submit_form'])) {
	$nitk_table= $wpdb->prefix. "nitk_alumni_db";
	$name = $_POST['alum_name'];
	$year = $_POST['alum_year'];
	$branch = $_POST['alum_branch'];
	$city = $_POST['alum_city'];
	$phone = $_POST['alum_phone'];
	$email = $_POST['alum_email'];
	$age = $_POST['alum_age'];
	$wpdb->insert(
		$nitk_table,
		array(
		'name' => $name,
		'year' => $year,
		'branch' => $branch,
		'city' => $city,
		'phone' => $phone,
		'email' => $email,
		'age' => $age
			)
		);
	$html = "<p>You form has been successfully submitted $name </p>";
}
return $html;
}

?>
<!--Adding shortcode so it can be used directly on page-->
<?php add_shortcode( 'add_data_nitk', 'add_data_func_table' );
?>
<!--Jane kya hoga rama re-->