Download Code: PHP and MySQL Student Study Center Desk Management System – Source Code

Projects Inventory

5 months ago

Download Code PHP and MySQL Student Study Center Desk Management System – Source Code

Student Study Center Desk Management System – PHP and MySQL Source Code

This project is called the Student Study Center Desk Management System, a web-based application developed using PHP and a MySQL database. The system is designed to help study centers manage the desks assigned to students. It features a clean and user-friendly interface, built with the Bootstrap Framework and AdminLTE Template. The system includes several useful functionalities for desk management.

How Does the Student Study Center Desk Management System Work?

The Student Study Center Desk Management System is designed with an admin interface that can only be accessed by administrators or staff members. The primary function of this system is to allocate and manage student desk assignments.

Upon first use, the system requires the management to populate a list of students and desks. From there, they can assign students to specific desks by selecting the student’s name and the corresponding desk. The system also allows management to view and manage the history of desk assignments and generate reports based on specific dates.

Features and Functionalities

The Student Study Center Desk Management System offers the following features:

Login and Logout functionality
Dashboard Page for system overview
Student List Management to maintain student records
Desk List Management for managing available desks
Student Desk Allocation Management to assign or unassign desks
Generate Date-wise Reports for tracking desk allocations over time
Manage System Users to control admin and staff access
Manage System Information for updating system details
Update Account Details for modifying user profiles

Technologies Used

The system was built using the following technologies:

XAMPP (local web server)
VS Code Editor
MySQL Database for storing data
HTML, CSS, JavaScript, and jQuery for front-end development
Ajax for dynamic content loading
DataTables Library for interactive tables
Select2 Library for improved form controls
Bootstrap Framework for responsive design
AdminLTE Template for the admin panel layout
FontAwesome Icons for visual elements

How to Run the System

Requirements:

Download and install a local web server such as XAMPP.
Download the source code zip file (provided with the project).

System Installation/Setup:

Enable the GD Library in your php.ini file.
Open the XAMPP Control Panel and start Apache and MySQL.
Extract the downloaded source code zip file.
Copy the extracted folder to the XAMPP “htdocs” directory.
Open PHPMyAdmin in a browser (e.g., http://localhost/phpmyadmin).
Create a new database called sscdms_db.
Import the SQL file (located in the database folder) called sscdms_db.sql into the database.
Open the Student Study Center Desk Management System in a browser (e.g., http://localhost/php-sscdms/).

Default Admin Access:

Username: admin
Password: admin123

Conclusion

This Student Study Center Desk Management System project in PHP and MySQL is designed to help manage desk allocations in a study center. It is perfect for educational purposes and can be easily customized to suit specific needs. Feel free to modify the source code to align with your own project requirements.

index PHP

<?php require_once('config.php'); ?>
<?php redirect('./admin') ?>

1 2	<?php require_once('config.php'); ?> <?php redirect('./admin') ?>

login PHP

<?php require_once('../config.php') ?>
<!DOCTYPE html>
<html lang="en" class="" style="height: auto;">
 <?php require_once('inc/header.php') ?>
<body class="hold-transition login-page">
  <script>
    start_loader()
  </script>
  <style>
    body{
      background-image: url("<?php echo validate_image($_settings->info('cover')) ?>");
      background-size:cover;
      background-repeat:no-repeat;
      backdrop-filter: contrast(1);
    }
    #page-title{
      text-shadow: 6px 4px 7px black;
      font-size: 3.5em;
      color: #fff4f4 !important;
      background: #8080801c;
    }
  </style>
  <h1 class="text-center text-white px-4 py-5" id="page-title"><b><?php echo $_settings->info('name') ?></b></h1>
<div class="login-box">
  <!-- /.login-logo -->
  <div class="card card-navy my-2">
    <div class="card-body">
      <p class="login-box-msg">Please enter your credentials</p>
      <form id="login-frm" action="" method="post">
        <div class="input-group mb-3">
          <input type="text" class="form-control" name="username" autofocus placeholder="Username">
          <div class="input-group-append">
            <div class="input-group-text">
              <span class="fas fa-user"></span>
            </div>
          </div>
        </div>
        <div class="input-group mb-3">
          <input type="password" class="form-control"  name="password" placeholder="Password">
          <div class="input-group-append">
            <div class="input-group-text">
              <span class="fas fa-lock"></span>
            </div>
          </div>
        </div>
        <div class="row">
          <div class="col-8">
            <a href="<?php echo base_url ?>">Go to Website</a>
          </div>
          <!-- /.col -->
          <div class="col-4">
            <button type="submit" class="btn btn-primary  bg-gradient-teal border-0 btn-block">Sign In</button>
          </div>
          <!-- /.col -->
        </div>
      </form>
      <!-- /.social-auth-links -->

      <!-- <p class="mb-1">
        <a href="forgot-password.html">I forgot my password</a>
      </p> -->
      
    </div>
    <!-- /.card-body -->
  </div>
  <!-- /.card -->
</div>
<!-- /.login-box -->

<!-- jQuery -->
<script src="<?= base_url ?>plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="<?= base_url ?>plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- AdminLTE App -->
<script src="<?= base_url ?>dist/js/adminlte.min.js"></script>

<script>
  $(document).ready(function(){
    end_loader();
  })
</script>
</body>
</html>

<?php require_once('../config.php') ?>

<!DOCTYPE html>

<?php require_once('inc/header.php') ?>

start_loader()

</script>

<style>

body{

background-image: url("<?php echo validate_image($_settings->info('cover')) ?>");

background-size:cover;

background-repeat:no-repeat;

backdrop-filter: contrast(1);

}

#page-title{

text-shadow: 6px 4px 7px black;

font-size: 3.5em;

color: #fff4f4 !important;

background: #8080801c;

}

</style>

<p class="login-box-msg">Please enter your credentials</p>

</div>

</div>

<a href="<?php echo base_url ?>">Go to Website</a>

</div>

</div>

</div>

</form>

<!-- <p class="mb-1">

<a href="forgot-password.html">I forgot my password</a>

</p> -->

</div>

</div>

</div>

$(document).ready(function(){

end_loader();

})

</script>

</body>

</html>

sscdms_db SQL

-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 14, 2023 at 07:51 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 8.1.5

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

--
-- Database: `sscdms_db`
--

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

--
-- Table structure for table `assign_list`
--

CREATE TABLE `assign_list` (
  `id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `desk_id` int(11) NOT NULL,
  `remarks` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `assign_list`
--

INSERT INTO `assign_list` (`id`, `student_id`, `desk_id`, `remarks`, `status`, `created_at`) VALUES
(2, 3, 1, 'Sample Assign', 1, '2023-03-14 14:03:46');

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

--
-- Table structure for table `desk_list`
--

CREATE TABLE `desk_list` (
  `id` int(11) NOT NULL,
  `code` varchar(20) NOT NULL,
  `description` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `desk_list`
--

INSERT INTO `desk_list` (`id`, `code`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'A101', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris pellentesque, diam sit amet facilisis iaculis, lorem est hendrerit velit, a semper augue felis tristique urna.', 1, '2023-03-14 10:56:01', NULL),
(2, 'A102', 'Nulla hendrerit erat eget placerat laoreet. Vivamus porta augue non bibendum pulvinar. Duis pellentesque orci eu bibendum pellentesque.', 1, '2023-03-14 10:57:34', NULL),
(3, 'A103', 'Aenean quis congue orci. Pellentesque quis felis purus. Etiam mi ipsum, consequat cursus scelerisque quis, tincidunt volutpat magna.', 1, '2023-03-14 10:59:18', NULL),
(4, 'B101', 'Suspendisse non lorem non ligula tincidunt aliquam.', 1, '2023-03-14 10:59:34', NULL),
(5, 'B102', 'Integer sollicitudin massa ut metus porta, vel posuere nunc fermentum. Curabitur quis sapien a nisl placerat pellentesque at sed mi.', 1, '2023-03-14 10:59:55', NULL),
(6, 'B103', 'Proin tempus, nisl et consequat convallis, nulla erat facilisis ante, eu sollicitudin nulla eros nec quam.', 1, '2023-03-14 11:00:13', NULL);

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

--
-- Table structure for table `student_list`
--

CREATE TABLE `student_list` (
  `id` int(11) NOT NULL,
  `regno` varchar(50) NOT NULL,
  `name` text NOT NULL,
  `contact` text NOT NULL,
  `email` text NOT NULL,
  `address` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `student_list`
--

INSERT INTO `student_list` (`id`, `regno`, `name`, `contact`, `email`, `address`, `status`, `created_at`, `updated_at`) VALUES
(2, '2023031400001', 'Mark Cooper', '09123456789', 'mcooper@mail.com', 'Sample Address only', 1, '2023-03-14 10:41:52', '2023-03-14 10:43:55'),
(3, '2023031400002', 'Claire Blake', '0912345987', 'cblake@mail.com', 'Sample Address 101', 1, '2023-03-14 10:47:10', NULL);

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

--
-- Table structure for table `system_info`
--

CREATE TABLE `system_info` (
  `id` int(30) NOT NULL,
  `meta_field` text NOT NULL,
  `meta_value` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `system_info`
--

INSERT INTO `system_info` (`id`, `meta_field`, `meta_value`) VALUES
(1, 'name', 'Student Study Center Desk Management System'),
(6, 'short_name', 'SMS - SSCDMS'),
(11, 'logo', 'uploads/logo.png?v=1678759793'),
(13, 'user_avatar', 'uploads/user_avatar.jpg'),
(14, 'cover', 'uploads/cover.png?v=1678759983'),
(17, 'phone', '456-987-1231'),
(18, 'mobile', '09123456987 / 094563212222 '),
(19, 'email', 'info@xyzsanitizationservices.com'),
(20, 'address', '7087 Henry St. Clifton Park, NY 12065');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(50) NOT NULL,
  `firstname` varchar(250) NOT NULL,
  `middlename` text DEFAULT NULL,
  `lastname` varchar(250) NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `avatar` text DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `type` tinyint(1) NOT NULL DEFAULT 0,
  `date_added` datetime NOT NULL DEFAULT current_timestamp(),
  `date_updated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='2';

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `firstname`, `middlename`, `lastname`, `username`, `password`, `avatar`, `last_login`, `type`, `date_added`, `date_updated`) VALUES
(1, 'Adminstrator', '', 'Admin', 'admin', '0192023a7bbd73250516f069df18b500', 'uploads/avatars/1.png?v=1678760026', NULL, 1, '2021-01-20 14:02:37', '2023-03-14 10:13:46');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `assign_list`
--
ALTER TABLE `assign_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `desk_list`
--
ALTER TABLE `desk_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `student_list`
--
ALTER TABLE `student_list`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `system_info`
--
ALTER TABLE `system_info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `assign_list`
--
ALTER TABLE `assign_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `desk_list`
--
ALTER TABLE `desk_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `student_list`
--
ALTER TABLE `student_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `system_info`
--
ALTER TABLE `system_info`
  MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
COMMIT;

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

-- phpMyAdmin SQL Dump

-- version 5.1.3

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

-- Host: 127.0.0.1

-- Generation Time: Mar 14, 2023 at 07:51 AM

-- Server version: 10.4.24-MariaDB

-- PHP Version: 8.1.5

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

START TRANSACTION;

SET time_zone = "+00:00";

-- Database: `sscdms_db`

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

-- Table structure for table `assign_list`

CREATE TABLE `assign_list` (

`id` int(11) NOT NULL,

`student_id` int(11) NOT NULL,

`desk_id` int(11) NOT NULL,

`remarks` text NOT NULL,

`status` tinyint(1) NOT NULL DEFAULT 1,

`created_at` datetime NOT NULL DEFAULT current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `assign_list`

INSERT INTO `assign_list` (`id`, `student_id`, `desk_id`, `remarks`, `status`, `created_at`) VALUES

(2, 3, 1, 'Sample Assign', 1, '2023-03-14 14:03:46');

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

-- Table structure for table `desk_list`

CREATE TABLE `desk_list` (

`id` int(11) NOT NULL,

`code` varchar(20) NOT NULL,

`description` text NOT NULL,

`status` tinyint(1) NOT NULL DEFAULT 1,

`created_at` datetime NOT NULL DEFAULT current_timestamp(),

`updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `desk_list`

INSERT INTO `desk_list` (`id`, `code`, `description`, `status`, `created_at`, `updated_at`) VALUES

(1, 'A101', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris pellentesque, diam sit amet facilisis iaculis, lorem est hendrerit velit, a semper augue felis tristique urna.', 1, '2023-03-14 10:56:01', NULL),

(2, 'A102', 'Nulla hendrerit erat eget placerat laoreet. Vivamus porta augue non bibendum pulvinar. Duis pellentesque orci eu bibendum pellentesque.', 1, '2023-03-14 10:57:34', NULL),

(3, 'A103', 'Aenean quis congue orci. Pellentesque quis felis purus. Etiam mi ipsum, consequat cursus scelerisque quis, tincidunt volutpat magna.', 1, '2023-03-14 10:59:18', NULL),

(4, 'B101', 'Suspendisse non lorem non ligula tincidunt aliquam.', 1, '2023-03-14 10:59:34', NULL),

(5, 'B102', 'Integer sollicitudin massa ut metus porta, vel posuere nunc fermentum. Curabitur quis sapien a nisl placerat pellentesque at sed mi.', 1, '2023-03-14 10:59:55', NULL),

(6, 'B103', 'Proin tempus, nisl et consequat convallis, nulla erat facilisis ante, eu sollicitudin nulla eros nec quam.', 1, '2023-03-14 11:00:13', NULL);

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

-- Table structure for table `student_list`

CREATE TABLE `student_list` (

`id` int(11) NOT NULL,

`regno` varchar(50) NOT NULL,

`name` text NOT NULL,

`contact` text NOT NULL,

`email` text NOT NULL,

`address` text NOT NULL,

`status` tinyint(1) NOT NULL DEFAULT 1,

`created_at` datetime NOT NULL DEFAULT current_timestamp(),

`updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `student_list`

INSERT INTO `student_list` (`id`, `regno`, `name`, `contact`, `email`, `address`, `status`, `created_at`, `updated_at`) VALUES

(2, '2023031400001', 'Mark Cooper', '09123456789', 'mcooper@mail.com', 'Sample Address only', 1, '2023-03-14 10:41:52', '2023-03-14 10:43:55'),

(3, '2023031400002', 'Claire Blake', '0912345987', 'cblake@mail.com', 'Sample Address 101', 1, '2023-03-14 10:47:10', NULL);

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

-- Table structure for table `system_info`

CREATE TABLE `system_info` (

`id` int(30) NOT NULL,

`meta_field` text NOT NULL,

`meta_value` text NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Dumping data for table `system_info`

INSERT INTO `system_info` (`id`, `meta_field`, `meta_value`) VALUES

(1, 'name', 'Student Study Center Desk Management System'),

(6, 'short_name', 'SMS - SSCDMS'),

(11, 'logo', 'uploads/logo.png?v=1678759793'),

(13, 'user_avatar', 'uploads/user_avatar.jpg'),

(14, 'cover', 'uploads/cover.png?v=1678759983'),

(17, 'phone', '456-987-1231'),

(18, 'mobile', '09123456987 / 094563212222 '),

(19, 'email', 'info@xyzsanitizationservices.com'),

(20, 'address', '7087 Henry St. Clifton Park, NY 12065');

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

-- Table structure for table `users`

CREATE TABLE `users` (

`id` int(50) NOT NULL,

`firstname` varchar(250) NOT NULL,

`middlename` text DEFAULT NULL,

`lastname` varchar(250) NOT NULL,

`username` text NOT NULL,

`password` text NOT NULL,

`avatar` text DEFAULT NULL,

`last_login` datetime DEFAULT NULL,

`type` tinyint(1) NOT NULL DEFAULT 0,

`date_added` datetime NOT NULL DEFAULT current_timestamp(),

`date_updated` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='2';

-- Dumping data for table `users`

INSERT INTO `users` (`id`, `firstname`, `middlename`, `lastname`, `username`, `password`, `avatar`, `last_login`, `type`, `date_added`, `date_updated`) VALUES

(1, 'Adminstrator', '', 'Admin', 'admin', '0192023a7bbd73250516f069df18b500', 'uploads/avatars/1.png?v=1678760026', NULL, 1, '2021-01-20 14:02:37', '2023-03-14 10:13:46');

-- Indexes for dumped tables

-- Indexes for table `assign_list`

ALTER TABLE `assign_list`

ADD PRIMARY KEY (`id`);

-- Indexes for table `desk_list`

ALTER TABLE `desk_list`

ADD PRIMARY KEY (`id`);

-- Indexes for table `student_list`

ALTER TABLE `student_list`

ADD PRIMARY KEY (`id`);

-- Indexes for table `system_info`

ALTER TABLE `system_info`

ADD PRIMARY KEY (`id`);

-- Indexes for table `users`

ALTER TABLE `users`

ADD PRIMARY KEY (`id`);

-- AUTO_INCREMENT for dumped tables

-- AUTO_INCREMENT for table `assign_list`

ALTER TABLE `assign_list`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

-- AUTO_INCREMENT for table `desk_list`

ALTER TABLE `desk_list`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

-- AUTO_INCREMENT for table `student_list`

ALTER TABLE `student_list`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

-- AUTO_INCREMENT for table `system_info`

ALTER TABLE `system_info`

MODIFY `id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

-- AUTO_INCREMENT for table `users`

ALTER TABLE `users`

MODIFY `id` int(50) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

COMMIT;