MindAssets/edusave.php at master · Vishalan/MindAssets · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121

<!DOCTYPE html>


<html lang="en">
	<head>
		<link rel="stylesheet" href="form.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">


<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no">
</head>


	<body>

	<div class="container-fluid">
	<div class="bg"></div>

		<ul class="main">


			<li>	 <a class="text-center" href="personalinfo.php">Personal Details</a></li>
						<li><a  class="text-center" href="familydetails.php">Family details</a></li>
			<li><a  class="active text-center" href="education.php">Education</a></li>
				  <li><a  class="text-center" href="experience.php">Work Experience</a></li>
				  <li><a  class="text-center" href="about.html">Additional Details</a></li>
				  </ul>


		<div class="well" style="height:40%;width:78%;float:right;margin-top:10%;">
		<form>
		<label>Data saved successfully </label>
		<input align="center" type="submit" value="proceed" class="button" formaction="experience.php">
		</form>
		</div>
	</div>

		</body>

		<html>


<?php

$con=mysqli_connect("localhost","riidlorg_mind","mind100","riidlorg_mindassets");

$sq="select id from personalinfo order by id DESC limit 1";
$re= mysqli_query($con,$sq);

	if($row=mysqli_fetch_array($re))
	{
		$id=$row["id"];
	}


//school details


$nameofschool=isset($_POST['schoolname']) ? $_POST['schoolname'] : '';
$board=isset($_POST['schoolboard']) ? $_POST['schoolboard'] : '';
$passyear=isset($_POST['schoolyear']) ? $_POST['schoolyear'] : '';
$percent=isset($_POST['schoolpercent']) ? $_POST['schoolpercent'] : '';


//highschool


$hsname = isset($_POST['hsname']) ? $_POST['hsname'] : '';
$hsboard = isset($_POST['hsboard']) ? $_POST['hsboard'] : '';
$hscourse = isset($_POST['hscourse']) ? $_POST['hscourse'] : '';
$hspass = isset($_POST['hsyear']) ? $_POST['hsyear'] : '';
$hsper = isset($_POST['hspercent']) ? $_POST['hspercent'] : '';

//diploma
$dname = isset($_POST['dname']) ? $_POST['dname'] : '';
$dcourse = isset($_POST['dcourse']) ? $_POST['dcourse'] : '';
$dyear = isset($_POST['dyear']) ? $_POST['dyear'] : '';
$dper = isset($_POST['dpercent']) ? $_POST['dpercent'] : '';

//graduation details
$instname=isset($_POST['uginstitute']) ? $_POST['uginstitute'] : '';
$degree=isset($_POST['degree']) ? $_POST['degree'] : '';
$course=isset($_POST['ugcourse']) ? $_POST['ugcourse'] : '';
$passingyear=isset($_POST['ugyear']) ? $_POST['ugyear'] : '';
$uggrade=isset($_POST['ugpercent']) ? $_POST['ugpercent'] : '';

//post graduation details
$postinstname=isset($_POST['pginstitute']) ? $_POST['pginstitute'] : '';
$postdegree=isset($_POST['pgdegree']) ? $_POST['pgdegree'] : '';
$postcourse=isset($_POST['pgcourse']) ? $_POST['pgcourse'] : '';
$postpassingyear=isset($_POST['pgyear']) ? $_POST['pgyear'] : '';
$pggrade=isset($_POST['pgpercent']) ? $_POST['pgpercent'] : '';


$sql="insert into educationdetails(id, schoolname, board, yearofpassing, percentage, highschoolname, highschoolboard, highschoolcourse, highschoolpassingyear, highschoolpercent, diplomacollgname,
diplomacourse, diplomapassingyear, diplomapercent) values('$id', '$nameofschool','$board','$passyear','$percent', '$hsname', '$hsboard', '$hscourse', '$hspass', '$hsper', '$dname', '$dcourse',
'$dyear', '$dper')";

$sql1="insert into postgraduationdetails(id, collegename, degree, course, yearofpassing, ugpercent, postinstitutename, pgdegree, pgcourse, pgyearofpassing, pgpercent) values('$id',
'$instname', '$degree', '$course', '$passingyear', '$uggrade', '$postinstname', '$postdegree', '$postcourse', '$postpassingyear', '$pggrade')";

$r=mysqli_query($con, $sql);
$r1=mysqli_query($con, $sql1);


?>