Download Code: PHP-Based Online Student Management System

Download Code PHP-Based Online Student Management System

Student Management System in PHP

A Student Management System (SMS) is a web-based application that helps educational institutions manage important student information, faculty, staff, and other resources. It provides an efficient way to track student data, such as attendance, grades, and course enrollment. The system also assists in administrative tasks like scheduling classes and managing finances.

Advantages of PHP for Student Management Systems

PHP is a popular programming language for building web applications due to its flexibility and scalability. It allows developers to create powerful, secure, and reliable student management systems. Using PHP and MySQL, educational institutions can create custom systems tailored to their specific needs. These systems are easy to use and open-source, making them affordable for institutions with limited budgets.

How a PHP-Based Student Management System Works

A student management system built with PHP and MySQL helps educational institutions manage student data securely and efficiently. It enables the tracking of attendance, grades, and progress while allowing administrators to store and manage reports. By using PHP, institutions can create custom reports and analyze student information more effectively.

Benefits of Using PHP for Student Management

Cost-Efficient: PHP is an open-source language, so schools can save money on development costs.
Ease of Use: PHP-based systems often come with intuitive interfaces, making it easier for administrators to manage student data without technical expertise.
Flexibility: Developers can customize the system to fit the specific needs of the institution.
Streamlined Administrative Tasks: The system makes tasks like tracking grades, attendance, and progress easier and faster.

Creating a Student Management System in PHP

Creating a custom student management system in PHP is an excellent way to manage school data. With the help of free and open-source software packages, educational institutions can quickly set up a system tailored to their requirements. These systems allow schools to manage student progress, keep track of enrollment, and generate reports with ease.

How to Run the Student Management System Project in PHP

To run the PHP-based Student Management System project, follow these steps:

Download the Source Code: Download the ZIP file containing the project source code and SQL file.
Extract the ZIP File: Extract the project folder related to the system.
Move to the Local Server: Copy the project folder to the “htdocs” directory of your local server (e.g., XAMPP).
Create a Database: Open PHPMyAdmin (localhost/phpmyadmin), create a new database for the system (ensure PHP version is at least 7.1).
Import SQL File: Import the SQL file into the created database.
Check Database Settings: Open the source code files and ensure the database name is correctly configured.
Login to Admin Panel: Open the admin panel and log in using the provided credentials.

Additional Information

In addition to providing the source code for student management systems, I also offer high-quality software development services, thesis writing, website development, and web application development. If you require any assistance, feel free to contact me via email.

index PHP

<?php
session_start();
error_reporting(0);
include('includes/dbconnection.php');

if(isset($_POST['login'])) 
  {
    $username=$_POST['username'];
    $password=md5($_POST['password']);
    $sql ="SELECT ID FROM tbladmin WHERE UserName=:username and Password=:password";
    $query=$dbh->prepare($sql);
    $query-> bindParam(':username', $username, PDO::PARAM_STR);
$query-> bindParam(':password', $password, PDO::PARAM_STR);
    $query-> execute();
    $results=$query->fetchAll(PDO::FETCH_OBJ);
    if($query->rowCount() > 0)
{
foreach ($results as $result) {
$_SESSION['sturecmsaid']=$result->ID;
}


  if(!empty($_POST["remember"])) {
//COOKIES for username
setcookie ("user_login",$_POST["username"],time()+ (10 * 365 * 24 * 60 * 60));
//COOKIES for password
setcookie ("userpassword",$_POST["password"],time()+ (10 * 365 * 24 * 60 * 60));
} else {
if(isset($_COOKIE["user_login"])) {
setcookie ("user_login","");
if(isset($_COOKIE["userpassword"])) {
setcookie ("userpassword","");
        }
      }
}
$_SESSION['login']=$_POST['username'];
echo "<script type='text/javascript'> document.location ='dashboard.php'; </script>";
} else{
echo "<script>alert('Invalid Details');</script>";
}
}

?><!--  Orginal Author Name: Mayuri.K. 
 for any PHP, Codeignitor, Laravel OR Python work contact me at mdkhairnar92@gmail.com  
 Visit website : https://mayurik.com -->  
<!DOCTYPE html>
<html lang="en">
  <head>
  
    <title>Edu Authorities Student Management System|| Login Page</title>
    <!-- plugins:css -->
    <link rel="stylesheet" href="assets/vendors/simple-line-icons/css/simple-line-icons.css">
    <link rel="stylesheet" href="assets/vendors/flag-icon-css/css/flag-icon.min.css">
    <link rel="stylesheet" href="assets/vendors/css/vendor.bundle.base.css">
    <!-- endinject -->
    <!-- Plugin css for this page -->
    <!-- End plugin css for this page -->
    <!-- inject:css -->
    <!-- endinject -->
    <!-- Layout styles -->
    <link rel="stylesheet" href="assets/css/style.css">
   <style>
     .content-wrapper{
          background-image: url('assets/images/background.jpg');
          background-size: cover;
     }
   </style>
  </head>
  <body>
    <div class="container-scroller">
      <div class="container-fluid page-body-wrapper full-page-wrapper">
        <div class="content-wrapper d-flex align-items-center auth">
          <div class="row flex-grow">
            <div class="col-lg-4 mx-auto">
              <div class="auth-form-light text-center p-5">
                <div class="brand-logo">
                  <img src="assets/images/logo.png">
                </div>
                <h4>Hello! let's get started</h4>
                <h6 class="font-weight-light">Sign in to continue.</h6>
                <form class="pt-3" id="login" method="post" name="login">
                  <div class="form-group">
                    <input type="text" class="form-control form-control-lg" placeholder="enter your username" required="true" name="username" value="<?php if(isset($_COOKIE["user_login"])) { echo $_COOKIE["user_login"]; } ?>" >
                  </div>
                  <div class="form-group">
                    
                    <input type="password" class="form-control form-control-lg" placeholder="enter your password" name="password" required="true" value="<?php if(isset($_COOKIE["userpassword"])) { echo $_COOKIE["userpassword"]; } ?>">
                  </div>
                  <div class="mt-3">
                    <button class="btn btn-success btn-block loginbtn" name="login" type="submit">Login</button>
                  </div>
                  <div class="my-2 d-flex justify-content-between align-items-center">
                    <div class="form-check">
                      <label class="form-check-label text-muted">
                        <input type="checkbox" id="remember" class="form-check-input" name="remember" <?php if(isset($_COOKIE["user_login"])) { ?> checked <?php } ?> /> Keep me signed in </label>
                    </div>
                    <a href="forgot-password.php" class="auth-link text-black">Forgot password?</a>
                  </div>
         <!--          <div class="mb-2">
                    <a href="../index.php" class="btn btn-block btn-facebook auth-form-btn">
                      <i class="icon-social-home mr-2"></i>Back Home </a>
                  </div> -->
                  
                </form>
              </div>
            </div>
          </div>
        </div>
        <!-- content-wrapper ends -->
      </div>
      <!-- page-body-wrapper ends -->
    </div>
    <!-- container-scroller -->
    <!-- plugins:js -->
    <script src="assets/vendors/js/vendor.bundle.base.js"></script>
    <!-- endinject -->
    <!-- Plugin js for this page -->
    <!-- End plugin js for this page -->
    <!-- inject:js -->
    <script src="assets/js/off-canvas.js"></script>
    <script src="assets/js/bootstrap.min.js"></script>
    <!-- endinject -->
  </body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

<?php

session_start();

error_reporting(0);

include('includes/dbconnection.php');

if(isset($_POST['login']))

{

$username=$_POST['username'];

$password=md5($_POST['password']);

$sql ="SELECT ID FROM tbladmin WHERE UserName=:username and Password=:password";

$query=$dbh->prepare($sql);

$query-> bindParam(':username', $username, PDO::PARAM_STR);

$query-> bindParam(':password', $password, PDO::PARAM_STR);

$query-> execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

if($query->rowCount() > 0)

{

foreach ($results as $result) {

$_SESSION['sturecmsaid']=$result->ID;

}

if(!empty($_POST["remember"])) {

//COOKIES for username

setcookie ("user_login",$_POST["username"],time()+ (10 * 365 * 24 * 60 * 60));

//COOKIES for password

setcookie ("userpassword",$_POST["password"],time()+ (10 * 365 * 24 * 60 * 60));

} else {

if(isset($_COOKIE["user_login"])) {

setcookie ("user_login","");

if(isset($_COOKIE["userpassword"])) {

setcookie ("userpassword","");

}

$_SESSION['login']=$_POST['username'];

echo "<script type='text/javascript'> document.location ='dashboard.php'; </script>";

} else{

echo "<script>alert('Invalid Details');</script>";

}

?><!-- Orginal Author Name: Mayuri.K.

for any PHP, Codeignitor, Laravel OR Python work contact me at mdkhairnar92@gmail.com

Visit website : https://mayurik.com -->

<!DOCTYPE html>

<head>

<title>Edu Authorities Student Management System|| Login Page</title>

<style>

.content-wrapper{

background-image: url('assets/images/background.jpg');

background-size: cover;

}

</style>

</head>

<body>

</div>

<h4>Hello! let's get started</h4>

<h6 class="font-weight-light">Sign in to continue.</h6>

</div>

</div>

<button class="btn btn-success btn-block loginbtn" name="login" type="submit">Login</button>

</div>

<input type="checkbox" id="remember" class="form-check-input" name="remember" <?php if(isset($_COOKIE["user_login"])) { ?> checked <?php } ?> /> Keep me signed in </label>

</div>

<a href="forgot-password.php" class="auth-link text-black">Forgot password?</a>

</div>

<!-- <div class="mb-2">

</div> -->

</form>

</div>

</div>

</div>

</body>

</html>

logout PHP

<?php
session_start();
session_unset();
session_destroy();
header('location:index.php');

?><!--  Orginal Author Name: Mayuri K. 
 for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com  
 Visit website : www.mayurik.com -->

<?php

session_start();

session_unset();

session_destroy();

header('location:index.php');

?><!-- Orginal Author Name: Mayuri K.

for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com

Visit website : www.mayurik.com -->

eduauth SQL

-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 12, 2023 at 11:32 AM
-- Server version: 10.4.22-MariaDB
-- PHP Version: 7.4.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `student`
--

-- --------------------------------------------------------

--
-- Table structure for table `tbladmin`
--

CREATE TABLE `tbladmin` (
  `ID` int(10) NOT NULL,
  `AdminName` varchar(120) DEFAULT NULL,
  `UserName` varchar(120) DEFAULT NULL,
  `MobileNumber` bigint(10) DEFAULT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `Password` varchar(200) DEFAULT NULL,
  `AdminRegdate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbladmin`
--

INSERT INTO `tbladmin` (`ID`, `AdminName`, `UserName`, `MobileNumber`, `Email`, `Password`, `AdminRegdate`) VALUES
(1, 'Mayuri K', 'mayurik', 9090909090, 'mayuri.infospace@gmail.com', 'cd92a26534dba48cd785cdcc0b3e6bd1', '2023-02-12 04:36:52');

-- --------------------------------------------------------

--
-- Table structure for table `tblclass`
--

CREATE TABLE `tblclass` (
  `ID` int(5) NOT NULL,
  `ClassName` varchar(50) DEFAULT NULL,
  `Section` varchar(20) DEFAULT NULL,
  `CreationDate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblclass`
--

INSERT INTO `tblclass` (`ID`, `ClassName`, `Section`, `CreationDate`) VALUES
(1, 'First Standard', 'A', '2023-02-12 09:47:47'),
(2, 'Second Standard', 'A', '2023-02-12 09:48:29'),
(3, 'Third Standard', 'A', '2023-02-12 09:49:06');

-- --------------------------------------------------------

--
-- Table structure for table `tblnotice`
--

CREATE TABLE `tblnotice` (
  `ID` int(5) NOT NULL,
  `NoticeTitle` mediumtext DEFAULT NULL,
  `ClassId` int(10) DEFAULT NULL,
  `NoticeMsg` mediumtext DEFAULT NULL,
  `CreationDate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblnotice`
--

INSERT INTO `tblnotice` (`ID`, `NoticeTitle`, `ClassId`, `NoticeMsg`, `CreationDate`) VALUES
(1, 'Notice regarding Christmas Holiday', 1, '<p style=\"box-sizing: inherit; margin-right: 0px; margin-bottom: 20px; margin-left: 0px; font-family: Roboto; font-size: 15px; line-height: 26px; color: rgb(68, 68, 68);\">Dear Parent<br style=\"box-sizing: inherit;\">The classes will remain off on 25.12.20(Friday) on account of Christmas and on 26.12.20(Saturday) on account of fourth Saturday.<br style=\"box-sizing: inherit;\">However the office will remain open on 26.12.20(Saturday) between 10:00am to 2:00pm.</p><p style=\"box-sizing: inherit; margin-right: 0px; margin-bottom: 20px; margin-left: 0px; font-family: Roboto; font-size: 15px; line-height: 26px; color: rgb(68, 68, 68);\">Note:All fee related /other issues can be addressed between the given timings.</p>', '2023-02-12 10:04:05');

-- --------------------------------------------------------

--
-- Table structure for table `tblpage`
--

CREATE TABLE `tblpage` (
  `ID` int(10) NOT NULL,
  `PageType` varchar(200) DEFAULT NULL,
  `PageTitle` mediumtext DEFAULT NULL,
  `PageDescription` mediumtext DEFAULT NULL,
  `Email` varchar(200) DEFAULT NULL,
  `MobileNumber` bigint(10) DEFAULT NULL,
  `UpdationDate` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `tblpublicnotice`
--

CREATE TABLE `tblpublicnotice` (
  `ID` int(5) NOT NULL,
  `NoticeTitle` varchar(200) DEFAULT NULL,
  `NoticeMessage` mediumtext DEFAULT NULL,
  `CreationDate` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblpublicnotice`
--

INSERT INTO `tblpublicnotice` (`ID`, `NoticeTitle`, `NoticeMessage`, `CreationDate`) VALUES
(1, 'water supply unviability ', '<b style=\"color: rgb(32, 33, 36); font-family: arial, sans-serif;\">municipal corporation has temporarily ceased the water supply due to some repair works.</b><br>', '2023-02-12 10:27:07');

-- --------------------------------------------------------

--
-- Table structure for table `tblstudent`
--

CREATE TABLE `tblstudent` (
  `ID` int(10) NOT NULL,
  `StudentName` varchar(200) DEFAULT NULL,
  `StudentEmail` varchar(200) DEFAULT NULL,
  `StudentClass` varchar(100) DEFAULT NULL,
  `Gender` varchar(50) DEFAULT NULL,
  `DOB` date DEFAULT NULL,
  `StuID` varchar(200) DEFAULT NULL,
  `FatherName` mediumtext DEFAULT NULL,
  `MotherName` mediumtext DEFAULT NULL,
  `ContactNumber` bigint(10) DEFAULT NULL,
  `AltenateNumber` bigint(10) DEFAULT NULL,
  `Address` mediumtext DEFAULT NULL,
  `UserName` varchar(200) DEFAULT NULL,
  `Password` varchar(200) DEFAULT NULL,
  `Image` varchar(200) DEFAULT NULL,
  `DateofAdmission` timestamp NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tblstudent`
--

INSERT INTO `tblstudent` (`ID`, `StudentName`, `StudentEmail`, `StudentClass`, `Gender`, `DOB`, `StuID`, `FatherName`, `MotherName`, `ContactNumber`, `AltenateNumber`, `Address`, `UserName`, `Password`, `Image`, `DateofAdmission`) VALUES
(1, 'Raghav Jain', 'raghav@gmail.com', '1', 'Male', '2023-02-12', 'FSA-1001', 'Shantilal', 'Jiya', 9090909090, 8080808080, 'Cinemax Theater, nashik road&nbsp;', 'raghav@gmail.com', '1b89744e90c7de7e76f25f281b924f44', '10c4a583ccb72d42c58230673f5923571676196769.jpg', '2023-02-12 10:12:49');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbladmin`
--
ALTER TABLE `tbladmin`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblclass`
--
ALTER TABLE `tblclass`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblnotice`
--
ALTER TABLE `tblnotice`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblpage`
--
ALTER TABLE `tblpage`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblpublicnotice`
--
ALTER TABLE `tblpublicnotice`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `tblstudent`
--
ALTER TABLE `tblstudent`
  ADD PRIMARY KEY (`ID`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbladmin`
--
ALTER TABLE `tbladmin`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tblclass`
--
ALTER TABLE `tblclass`
  MODIFY `ID` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tblnotice`
--
ALTER TABLE `tblnotice`
  MODIFY `ID` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tblpage`
--
ALTER TABLE `tblpage`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tblpublicnotice`
--
ALTER TABLE `tblpublicnotice`
  MODIFY `ID` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `tblstudent`
--
ALTER TABLE `tblstudent`
  MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

-- phpMyAdmin SQL Dump

-- version 5.1.3

-- https://www.phpmyadmin.net/

-- Host: 127.0.0.1

-- Generation Time: Feb 12, 2023 at 11:32 AM

-- Server version: 10.4.22-MariaDB

-- PHP Version: 7.4.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;

SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8mb4 */;

-- Database: `student`

-- --------------------------------------------------------

-- Table structure for table `tbladmin`

CREATE TABLE `tbladmin` (

`ID` int(10) NOT NULL,

`AdminName` varchar(120) DEFAULT NULL,

`UserName` varchar(120) DEFAULT NULL,

`MobileNumber` bigint(10) DEFAULT NULL,

`Email` varchar(200) DEFAULT NULL,

`Password` varchar(200) DEFAULT NULL,

`AdminRegdate` timestamp NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `tbladmin`

INSERT INTO `tbladmin` (`ID`, `AdminName`, `UserName`, `MobileNumber`, `Email`, `Password`, `AdminRegdate`) VALUES

(1, 'Mayuri K', 'mayurik', 9090909090, 'mayuri.infospace@gmail.com', 'cd92a26534dba48cd785cdcc0b3e6bd1', '2023-02-12 04:36:52');

-- --------------------------------------------------------

-- Table structure for table `tblclass`

CREATE TABLE `tblclass` (

`ID` int(5) NOT NULL,

`ClassName` varchar(50) DEFAULT NULL,

`Section` varchar(20) DEFAULT NULL,

`CreationDate` timestamp NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `tblclass`

INSERT INTO `tblclass` (`ID`, `ClassName`, `Section`, `CreationDate`) VALUES

(1, 'First Standard', 'A', '2023-02-12 09:47:47'),

(2, 'Second Standard', 'A', '2023-02-12 09:48:29'),

(3, 'Third Standard', 'A', '2023-02-12 09:49:06');

-- --------------------------------------------------------

-- Table structure for table `tblnotice`

CREATE TABLE `tblnotice` (

`ID` int(5) NOT NULL,

`NoticeTitle` mediumtext DEFAULT NULL,

`ClassId` int(10) DEFAULT NULL,

`NoticeMsg` mediumtext DEFAULT NULL,

`CreationDate` timestamp NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `tblnotice`

INSERT INTO `tblnotice` (`ID`, `NoticeTitle`, `ClassId`, `NoticeMsg`, `CreationDate`) VALUES

(1, 'Notice regarding Christmas Holiday', 1, '<p style=\"box-sizing: inherit; margin-right: 0px; margin-bottom: 20px; margin-left: 0px; font-family: Roboto; font-size: 15px; line-height: 26px; color: rgb(68, 68, 68);\">Dear Parent<br style=\"box-sizing: inherit;\">The classes will remain off on 25.12.20(Friday) on account of Christmas and on 26.12.20(Saturday) on account of fourth Saturday.<br style=\"box-sizing: inherit;\">However the office will remain open on 26.12.20(Saturday) between 10:00am to 2:00pm.</p><p style=\"box-sizing: inherit; margin-right: 0px; margin-bottom: 20px; margin-left: 0px; font-family: Roboto; font-size: 15px; line-height: 26px; color: rgb(68, 68, 68);\">Note:All fee related /other issues can be addressed between the given timings.</p>', '2023-02-12 10:04:05');

-- --------------------------------------------------------

-- Table structure for table `tblpage`

CREATE TABLE `tblpage` (

`ID` int(10) NOT NULL,

`PageType` varchar(200) DEFAULT NULL,

`PageTitle` mediumtext DEFAULT NULL,

`PageDescription` mediumtext DEFAULT NULL,

`Email` varchar(200) DEFAULT NULL,

`MobileNumber` bigint(10) DEFAULT NULL,

`UpdationDate` date DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

-- Table structure for table `tblpublicnotice`

CREATE TABLE `tblpublicnotice` (

`ID` int(5) NOT NULL,

`NoticeTitle` varchar(200) DEFAULT NULL,

`NoticeMessage` mediumtext DEFAULT NULL,

`CreationDate` timestamp NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `tblpublicnotice`

INSERT INTO `tblpublicnotice` (`ID`, `NoticeTitle`, `NoticeMessage`, `CreationDate`) VALUES

(1, 'water supply unviability ', '<b style=\"color: rgb(32, 33, 36); font-family: arial, sans-serif;\">municipal corporation has temporarily ceased the water supply due to some repair works.</b><br>', '2023-02-12 10:27:07');

-- --------------------------------------------------------

-- Table structure for table `tblstudent`

CREATE TABLE `tblstudent` (

`ID` int(10) NOT NULL,

`StudentName` varchar(200) DEFAULT NULL,

`StudentEmail` varchar(200) DEFAULT NULL,

`StudentClass` varchar(100) DEFAULT NULL,

`Gender` varchar(50) DEFAULT NULL,

`DOB` date DEFAULT NULL,

`StuID` varchar(200) DEFAULT NULL,

`FatherName` mediumtext DEFAULT NULL,

`MotherName` mediumtext DEFAULT NULL,

`ContactNumber` bigint(10) DEFAULT NULL,

`AltenateNumber` bigint(10) DEFAULT NULL,

`Address` mediumtext DEFAULT NULL,

`UserName` varchar(200) DEFAULT NULL,

`Password` varchar(200) DEFAULT NULL,

`Image` varchar(200) DEFAULT NULL,

`DateofAdmission` timestamp NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table `tblstudent`

INSERT INTO `tblstudent` (`ID`, `StudentName`, `StudentEmail`, `StudentClass`, `Gender`, `DOB`, `StuID`, `FatherName`, `MotherName`, `ContactNumber`, `AltenateNumber`, `Address`, `UserName`, `Password`, `Image`, `DateofAdmission`) VALUES

(1, 'Raghav Jain', 'raghav@gmail.com', '1', 'Male', '2023-02-12', 'FSA-1001', 'Shantilal', 'Jiya', 9090909090, 8080808080, 'Cinemax Theater, nashik road ', 'raghav@gmail.com', '1b89744e90c7de7e76f25f281b924f44', '10c4a583ccb72d42c58230673f5923571676196769.jpg', '2023-02-12 10:12:49');

-- Indexes for dumped tables

-- Indexes for table `tbladmin`

ALTER TABLE `tbladmin`

ADD PRIMARY KEY (`ID`);

-- Indexes for table `tblclass`

ALTER TABLE `tblclass`

ADD PRIMARY KEY (`ID`);

-- Indexes for table `tblnotice`

ALTER TABLE `tblnotice`

ADD PRIMARY KEY (`ID`);

-- Indexes for table `tblpage`

ALTER TABLE `tblpage`

ADD PRIMARY KEY (`ID`);

-- Indexes for table `tblpublicnotice`

ALTER TABLE `tblpublicnotice`

ADD PRIMARY KEY (`ID`);

-- Indexes for table `tblstudent`

ALTER TABLE `tblstudent`

ADD PRIMARY KEY (`ID`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `tbladmin`

ALTER TABLE `tbladmin`

MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

-- AUTO_INCREMENT for table `tblclass`

ALTER TABLE `tblclass`

MODIFY `ID` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

-- AUTO_INCREMENT for table `tblnotice`

ALTER TABLE `tblnotice`

MODIFY `ID` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

-- AUTO_INCREMENT for table `tblpage`

ALTER TABLE `tblpage`

MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT;

-- AUTO_INCREMENT for table `tblpublicnotice`

ALTER TABLE `tblpublicnotice`

MODIFY `ID` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

-- AUTO_INCREMENT for table `tblstudent`

ALTER TABLE `tblstudent`

MODIFY `ID` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Download Code: PHP-Based Online Student Management System

index PHP

logout PHP

eduauth SQL

Related Posts:

Leave a Comment Cancel Reply