-- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 02, 2024 at 04:07 PM
-- Server version: 10.1.38-MariaDB
-- PHP Version: 7.3.2

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `new_student_reg`
--

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

--
-- Table structure for table `bio_data`
--

CREATE TABLE `bio_data` (
  `id` int(200) NOT NULL,
  `sname` varchar(122) NOT NULL,
  `othernames` varchar(123) NOT NULL,
  `nationality` varchar(112) NOT NULL,
  `state_of_origin` varchar(121) NOT NULL,
  `lga` varchar(121) NOT NULL,
  `dob` varchar(111) NOT NULL,
  `gender` varchar(245) NOT NULL,
  `religion` varchar(100) NOT NULL,
  `phoneno` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `addresss` varchar(100) NOT NULL,
  `department` varchar(100) NOT NULL,
  `school` varchar(100) NOT NULL,
  `sessionse` varchar(100) NOT NULL,
  `passport` varchar(100) NOT NULL,
  `mode` varchar(10) NOT NULL,
  `sign` varchar(22) NOT NULL,
  `health_disability` varchar(31) NOT NULL,
  `disability_details` varchar(23) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bio_data`
--

INSERT INTO `bio_data` (`id`, `sname`, `othernames`, `nationality`, `state_of_origin`, `lga`, `dob`, `gender`, `religion`, `phoneno`, `email`, `addresss`, `department`, `school`, `sessionse`, `passport`, `mode`, `sign`, `health_disability`, `disability_details`) VALUES
(1, 'dam', 'sam', 'Ogun', 'fffffffff', 'fyfyjyfyj', '2024-10-02', 'male', 'wsdwdw', 'dwdw', 'damilare@gmail.com', '12fff', 'wdwd', 'cww', 'wdwd', '462446166_122136727652335396_8735002385287302992_n.jpg', '', '', '', ''),
(4, 'dam', 'sam', 'Ogun', 'fffffffff', 'fyfyjyfyj', '2024-10-03', 'male', 'wsdwdw', 'dwdw', 'damilare@gmail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', 'WhatsApp_Image_2024-10-30_at_17.03.18_2bcf8773-removebg-preview.png', '', 'WhatsApp_Image_2024-10', 'yes', 'AFEGEG'),
(5, 'dam', 'dan', 'hcgncggc', 'fffffffff', 'fyfyjyfyj', '2024-10-02', 'male', 'wsdwdw', 'dwdw', 'damilare@gmail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', 'WhatsApp_Image_2024-10-30_at_17.03.18_2bcf8773-removebg-preview.png', 'Caps', 'WhatsApp_Image_2024-10', 'no', 'AFEGEG'),
(6, 'dam', 'sam', 'Ogun', 'fffffffff', 'fyfyjyfyj', '2024-11-02', 'male', 'wsdwdw', 'dwdw', 'admin@mail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', 'dddd.png', 'Caps', 'dddd.png', 'no', 'AFEGEG'),
(7, 'dam', 'dan', 'Ogun', 'fffffffff', 'fyfyjyfyj', '2024-10-30', 'male', 'wsdwdw', 'dwdw', 'damilare@gmail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', 'dddd.png', 'Caps', 'dddd.png', 'no', ''),
(8, 'dam', 'sam', 'hcgncggc', 'fffffffff', 'fyfyjyfyj', '2024-11-06', 'male', 'wsdwdw', 'dwdw', 'Admin@gmail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', '399183897_1021877575730785_4458402860370642011_n.jpg', 'Caps', 'images - 2022-12-20T22', 'no', ''),
(9, 'dam', 'sam', 'Ogun', 'fffffffff', 'fyfyjyfyj', '2024-11-02', 'male', 'wsdwdw', 'dwdw', 'damilare884@gmail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', 'healthcare.png', 'Caps', 'healthcare.png', 'no', ''),
(10, 'Okon', 'Benedict', 'Ogun', 'fffffffff', 'fyfyjyfyj', '2024-11-09', 'male', 'wsdwdw', 'dwdw', 'charleseffiong01@gmail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', 'WIN_20240930_16_40_18_Pro.jpg', 'Caps', 'WIN_20240220_18_38_53_', 'no', ''),
(11, 'dam', 'sam', 'Ogun', 'fffffffff', 'fyfyjyfyj', '2024-11-01', 'male', 'wsdwdw', 'dwdw', 'charleseffiong01@gmail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', 'download (4).png', 'Caps', 'kisspng-west-african-s', 'no', 'AFEGEG'),
(12, 'AFELOGUN', 'JOSHUA', 'Ogun', 'fffffffff', 'fyfyjyfyj', '2024-11-01', 'male', 'wsdwdw', 'dwdw', 'damilare@gmail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', 'download (4).png', 'Caps', '399183897_102187757573', 'no', ''),
(13, 'runsewe', 'sam', 'Ogun', 'fffffffff', 'fyfyjyfyj', '2024-11-01', 'male', 'wsdwdw', 'dwdw', 'damilare884@gmail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', 'admission1.jpg', 'Caps', 'admission2 - Copy.jpg', 'no', 'AFEGEG'),
(14, 'runsewe', 'sam', 'Ogun', 'fffffffff', 'fyfyjyfyj', '2024-11-01', 'male', 'wsdwdw', 'dwdw', 'damilare884@gmail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', 'admission2 - Copy.jpg', 'Caps', 'admission1.jpg', 'no', 'AFEGEG'),
(15, 'runsewe', 'sam', 'hcgncggc', 'fffffffff', 'fyfyjyfyj', '2024-11-02', 'female', 'wsdwdw', 'dwdw', 'damilares884@gmail.com', '12fff', 'cdxffgx', 'wdwd', 'wdwd', 'admission1.jpg', 'TRANSFER', 'admission1 - Copy.jpg', 'no', '');

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

--
-- Table structure for table `guarantor_form`
--

CREATE TABLE `guarantor_form` (
  `id` int(100) NOT NULL,
  `Guarantor_name` varchar(123) NOT NULL,
  `rel_student` varchar(342) NOT NULL,
  `readress` varchar(245) NOT NULL,
  `rephone` varchar(100) NOT NULL,
  `person_email` varchar(100) NOT NULL,
  `occupation` varchar(100) NOT NULL,
  `job_title` varchar(222) NOT NULL,
  `employer_name` varchar(222) NOT NULL,
  `office_phone` varchar(222) NOT NULL,
  `office_email` varchar(222) NOT NULL,
  `declarer_name` varchar(222) NOT NULL,
  `declarer_names` varchar(111) NOT NULL,
  `Guarantor_pic` varchar(100) NOT NULL,
  `Guarantor_signature` varchar(100) NOT NULL,
  `sname` varchar(23) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `guarantor_form`
--

INSERT INTO `guarantor_form` (`id`, `Guarantor_name`, `rel_student`, `readress`, `rephone`, `person_email`, `occupation`, `job_title`, `employer_name`, `office_phone`, `office_email`, `declarer_name`, `declarer_names`, `Guarantor_pic`, `Guarantor_signature`, `sname`) VALUES
(1, 'cd efv', 'GFBF', '12fff', 'GBDB', 'cvev@gmail.com', 'grefh', 'ddd', '12fff', 'edthge', 'egshh@gmail.com', 'EGREG', 'grgreg', 'CS001.pdf', 'CS001.pdf', 'Okon '),
(2, 'cd efv', 'GFBF', '12fff', 'GBDB', 'cvev@gmail.com', 'grefh', 'ddd', '12fff', 'edthge', 'egshh@gmail.com', 'EGREG', 'fewfwe', 'WhatsApp_Image_2024-10-30_at_17.03.18_2bcf8773-removebg-preview.png', 'WhatsApp Image 2024-10-13 at 20.19.27_bf6004f2.jpg', ''),
(3, 'cd efv', 'GFBF', '12fff', 'GBDB', 'cvev', 'grefh', 'ddd', '12fff', 'edthge', 'egshh@gmail.com', 'tdtgdtgdxt', 'grgreg', 'dddd.png', 'WhatsApp_Image_2024-10-30_at_17.03.18_2bcf8773-removebg-preview.png', ''),
(4, 'cd efv', 'GFBF', '12fff', 'GBDB', 'cvev', 'grefh', 'ddd', '12fff', 'edthge', 'egshh@gmail.com', 'tdtgdtgdxt', 'fewfwe', 'images - 2022-12-20T223929.064.jpeg', 'healthcare.png', ''),
(5, 'cd efv', 'GFBF', '12fff', 'GBDB', 'cvev@gmail.com', 'grefh', 'ddd', '12fff', 'edthge', 'egshh@gmail.com', 'wefwef', 'grgreg', 'images - 2022-12-20T223929.064.jpeg', 'images - 2022-12-20T223929.064.jpeg', ''),
(6, 'cd efv', 'GFBF', '12fff', 'GBDB', 'cvev', 'grefh', 'ddd', '12fff', 'edthge', 'egshh@gmail.com', 'tdtgdtgdxt', 'fewfwe', 'healthcare.png', 'first-aid-kit.png', ''),
(7, 'cd efv', 'GFBF', '12fff', 'GBDB', 'cvev', 'grefh', 'ddd', '12fff', 'edthge', 'egshh@gmail.com', 'EGREG', 'grgreg', '306908607_778891496696062_2235495783282471147_n.jpg', 'healthcare.png', ''),
(8, 'cd efv', 'GFBF', '12fff', 'GBDB', 'cvev@gmail.com', 'grefh', 'ddd', '12fff', 'edthge', 'egshh@gmail.com', 'tdtgdtgdxt', 'grgreg', 'admission2 - Copy.jpg', 'admission2 - Copy.jpg', 'Korie ');

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

--
-- Table structure for table `jamb`
--

CREATE TABLE `jamb` (
  `Id` int(100) NOT NULL,
  `jamb` varchar(100) NOT NULL,
  `jamb_letter` varchar(100) NOT NULL,
  `sname` varchar(23) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jamb`
--

INSERT INTO `jamb` (`Id`, `jamb`, `jamb_letter`, `sname`) VALUES
(1, 'CS001.pdf', 'CS001.pdf', 'Okon'),
(2, '461510612_17863501857231986_6503731377155764410_n.jpg', '147-1475606_celestial-church-of-christ-logo.png', ''),
(3, '460010661_524298583583843_5225342443175953230_n.jpg', '460010661_524298583583843_5225342443175953230_n.jpg', ''),
(4, '462835986_1122727186519461_3973237044199181828_n.jpg', '462291460_939863668164002_3970867694990745319_n.jpg', ''),
(5, 'first-aid-kit.png', 'healthcare.png', ''),
(6, 'a1-removebg-preview.png', 'images - 2022-12-20T223929.064.jpeg', ''),
(7, 'admission3 - Copy.jpg', 'admission4 - Copy.jpg', 'Korie ');

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

--
-- Table structure for table `medical_report`
--

CREATE TABLE `medical_report` (
  `id` int(100) NOT NULL,
  `fitness_test` varchar(278) NOT NULL,
  `blood_group` varchar(100) NOT NULL,
  `sname` varchar(23) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `medical_report`
--

INSERT INTO `medical_report` (`id`, `fitness_test`, `blood_group`, `sname`) VALUES
(1, '306908607_778891496696062_2235495783282471147_n.jpg', 'admission1 - Copy.jpg', 'Okon'),
(2, 'download (4).png', 'healthcare.png', ''),
(3, 'download (4).png', 'download (4).png', ''),
(4, '', 'admission1 - Copy.jpg', ''),
(5, '', 'admission2 - Copy.jpg', 'Korie ');

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

--
-- Table structure for table `passpprt_sign`
--

CREATE TABLE `passpprt_sign` (
  `Id` int(11) NOT NULL,
  `passport` int(11) NOT NULL,
  `sign` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `passpprt_sign`
--

INSERT INTO `passpprt_sign` (`Id`, `passport`, `sign`) VALUES
(1, 6446473, 0);

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

--
-- Table structure for table `screening_form`
--

CREATE TABLE `screening_form` (
  `id` int(200) NOT NULL,
  `surname` varchar(200) NOT NULL,
  `othernames` varchar(200) NOT NULL,
  `gender` varchar(200) NOT NULL,
  `dob` varchar(200) NOT NULL,
  `residential_address` varchar(200) NOT NULL,
  `health_disability` varchar(342) NOT NULL,
  `disability_details` varchar(200) NOT NULL,
  `sponsor_name` varchar(200) NOT NULL,
  `parent_address` varchar(200) NOT NULL,
  `parent_phone` varchar(200) NOT NULL,
  `parent_email` varchar(200) NOT NULL,
  `nationality` varchar(200) NOT NULL,
  `state_of_origin` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `lga` varchar(200) NOT NULL,
  `education_background` varchar(200) NOT NULL,
  `first_sitting` varchar(200) NOT NULL,
  `second_sitting` varchar(200) NOT NULL,
  `jamb_score` varchar(200) NOT NULL,
  `exam_year` varchar(200) NOT NULL,
  `referee_name` varchar(200) NOT NULL,
  `referee_occupation` varchar(200) NOT NULL,
  `referee_address` varchar(200) NOT NULL,
  `referee_phone` varchar(200) NOT NULL,
  `referee_email` varchar(200) NOT NULL,
  `declarer_name` varchar(200) NOT NULL,
  `passport` varchar(100) NOT NULL,
  `form_progress` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `screening_form`
--

INSERT INTO `screening_form` (`id`, `surname`, `othernames`, `gender`, `dob`, `residential_address`, `health_disability`, `disability_details`, `sponsor_name`, `parent_address`, `parent_phone`, `parent_email`, `nationality`, `state_of_origin`, `city`, `lga`, `education_background`, `first_sitting`, `second_sitting`, `jamb_score`, `exam_year`, `referee_name`, `referee_occupation`, `referee_address`, `referee_phone`, `referee_email`, `declarer_name`, `passport`, `form_progress`) VALUES
(1, 'samuel', 'dan', 'male', '2024-10-01', '12fff', 'no', 'AFEGEG', '12fff', 'chnccggc', 'gc cgbfxgfbc', 'chhchc @GMAIL.COM', 'hcgncggc', 'fffffffff', 'ffffffffffff', 'fyfyjyfyj', 'hthths', 'h4thnt4', 'ethteh', 'ethyzth', ' bgvnvhvn', 'hvvhjvhjj', 'cghyvjjhyjyg', '12fff', 'ghhgh', 'WR3T35@GAMIL.COM', 'regeg', 'images (1).jpeg', ''),
(2, 'dam', 'sam', 'male', '2024-10-01', '12fff', 'no', 'AFEGEG', '12fff', 'GT3T4T', 'QE4T3', 'chhchc @GMAIL.COM', 'hcgncggc', 'fffffffff', 'ffffffffffff', 'fyfyjyfyj', 'fgfgg', 'ggg', 'sdgg', 'SFGEGREG', ' bgvnvhvn', 'WER4E', 'WEFWR3R', '12fff', 'ghhgh', 'WR3T35@GAMIL.COM', 'dddg', 'WhatsApp Image 2024-09-25 at 06.48.25_8a0f0296.jpg', ''),
(3, 'dam', 'sam', 'male', '2024-10-01', '12fff', 'no', 'AFEGEG', '12fff', 'chnccggc', 'gc cgbfxgfbc', 'chhchc @GMAIL.COM', 'FER4', 'fffffffff', 'ffffffffffff', 'fyfyjyfyj', 'dsfweg', 'fewfwe', 'wfew', 'cghgv', ' bgvnvhvn', 'hvvhjvhjj', 'cghyvjjhyjyg', '12fff', 'swsw', 'asf@gmail.com', 'dddg', 'WhatsApp Image 2024-10-17 at 21.04.09_d5c706c1.jpg', ''),
(4, 'samuel', 'dan', 'male', '2024-10-04', '12fff', 'no', 'AFEGEG', '12fff', 'chnccggc', 'gc cgbfxgfbc', 'chhchc @GMAIL.COM', 'nigeria', 'fffffffff', 'ffffffffffff', 'fyfyjyfyj', 'ewfewf', 'ewfewf', 'ff', 'cghgv', ' bgvnvhvn', 'hvvhjvhjj', 'cghyvjjhyjyg', '12fff', 'ghhgh', 'WR3T35@GAMIL.COM', 'dddg', 'images (6).jpeg', '50');

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

--
-- Table structure for table `state_org`
--

CREATE TABLE `state_org` (
  `id` int(100) NOT NULL,
  `states` varchar(100) NOT NULL,
  `sname` varchar(23) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `state_org`
--

INSERT INTO `state_org` (`id`, `states`, `sname`) VALUES
(1, '147-1475606_celestial-church-of-christ-logo.png', 'Okon'),
(2, 'sanwoolu.jpg', ''),
(3, '399183897_1021877575730785_4458402860370642011_n.jpg', ''),
(4, '360_F_568990905_bmJd1P0siAH0Cwokz0Lsc3ZLNrICkE1l.jpg', ''),
(5, 'admission1.jpg', '');

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

--
-- Table structure for table `student_jamb_reg`
--

CREATE TABLE `student_jamb_reg` (
  `id` int(23) NOT NULL,
  `jamb_reg_no` varchar(100) NOT NULL,
  `sname` varchar(100) NOT NULL,
  `fullname` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_jamb_reg`
--

INSERT INTO `student_jamb_reg` (`id`, `jamb_reg_no`, `sname`, `fullname`) VALUES
(1, '202441713356CA	', 'Owolabi ', 'Daniel Gbenga\r\n'),
(2, '202441878785EA	', 'Ige ', 'Itunuoluwa Ope\r\n'),
(3, '202441877628DA	', 'Ige ', 'Ayomide Oluwaseun\r\n'),
(4, '202441993551BAP	', 'Ekezie ', 'Ezinne Mercy'),
(5, '202441999609CFP	', 'Shittu ', ' Fatima Ajokeade'),
(6, '202441068300FA	', 'Adebayo ', ' Isreal Adeniji\r\n'),
(7, '202440915351EF	', 'Oyeladun ', 'Israel Ayomide\r\n'),
(8, '202440438624DF	', 'Oyeladun ', 'Rebecca \r\n'),
(9, '202440805988EA	', 'Sunday ', ' Favour Chisom\r\n\r\n'),
(10, '202442008389BFP	', 'Obey ', 'Oriyomi Boluwatife\r\n\r\n'),
(11, '202440548211GA	', 'Kalu ', 'Oluchi Goodness\r\n\r\n\r\n'),
(12, '202441825962FF	', 'Arigbabuowo ', 'Zainab Motunrayo\r\n\r\n\r\n'),
(13, '202441404768GF	', 'Ita ', ' Gospel Okon\r\n\r\n\r\n'),
(14, '202440234359BF	', 'Salu ', 'Micheal Oluwatimileyin\r\n\r\n\r\n\r\n'),
(15, '202440562352DF	', 'Ayobami ', ' Omotayo Mustapha\r\n\r\n\r\n\r\n\r\n'),
(16, '202440285765FF	', 'Bello ', 'Qudus Opeyemi\r\n\r\n\r\n\r\n\r\n'),
(17, '202441894981JF	', 'Macaulay ', 'Emmanuel Temitope\r\n\r\n\r\n\r\n\r\n\r\n'),
(18, '202440035526AF	', 'Okanlawon ', 'Adam Abidem\r\n\r\n\r\n\r\n\r\n\r\n'),
(19, '202441425657CF	', 'Ajibade ', 'Ireoluwa Precious\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(20, '202440111012BA	', 'Adewale ', 'Jeremiah Abiodun\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(21, '202440998908HA	', 'Amusa ', 'Idris Olansile\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(22, '202440768503DA	', 'Ijeh ', 'Emmanuel Triumphant\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(23, '202440614107EA	', 'Ebeh ', 'Williams Uchenna\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(24, '202441003958JA	', 'Odunuga ', 'Farouk Olamide Abolere\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(25, '202441069239BA	', 'Osunkoya ', 'Oluwatimileyin Michael\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(26, '202440160729EA	', 'Badmus ', 'Malik Michael\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(27, '202440583136EF	', 'Quaseem ', 'Aliyat Oluwadamilola\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(28, '202440576011EF	', 'Okon ', 'Israel Bassey\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(29, '202441258078CA	', 'Onabodu ', ' Tafeek Olarenwaju\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(30, '202441862429CF	', 'Oladotun ', 'Oluwaseyifunmi Emmanuel\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(31, '202440351643DA	', 'Sanyaolu ', 'Elijah Abiola\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(32, '202441919005FF	', 'Odighe ', 'David Kema\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(33, '202441043364JA	', 'Adekolujo ', 'Muhammad Adetomiwa\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n'),
(34, '202441605611JF	', 'Ohelobo ', 'Joshua Oheholume\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n');

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

--
-- Table structure for table `student_table`
--

CREATE TABLE `student_table` (
  `student _id` int(11) NOT NULL,
  `sname` varchar(255) NOT NULL,
  `fname` varchar(255) NOT NULL,
  `lname` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `saddress` varchar(255) NOT NULL,
  `dob` varchar(255) NOT NULL,
  `sstate` varchar(255) NOT NULL,
  `nationality` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `mode` varchar(255) NOT NULL,
  `Program_Courses` varchar(255) NOT NULL,
  `jambscore` varchar(255) NOT NULL,
  `progress_percentage` varchar(100) NOT NULL,
  `jamb_reg_no` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `student_table`
--

INSERT INTO `student_table` (`student _id`, `sname`, `fname`, `lname`, `gender`, `saddress`, `dob`, `sstate`, `nationality`, `email`, `phone`, `mode`, `Program_Courses`, `jambscore`, `progress_percentage`, `jamb_reg_no`) VALUES
(1, 'Okon', 'Benedict', 'Efffiong ', 'male', '1, Kusebuinu Str. Opebi', '1994-09-09', 'Akwa Ibom ', 'Nigerian', 'charleseffiong01@gmail.com', '08174147793', 'Part-time', 'ND-Computer-Engineering', 'nil', '', '202441713356CA'),
(2, 'AFELOGUN', 'JOSHUA', 'MAYOWA', 'male', '52, Oluwole Street, Off Matogun. Ogun State ', '2007-08-01', 'OGUN STATE ', 'NIGERIAN ', 'mayowajoshua611@gmail.com', '09030411282', 'full-time', 'ND-Electrical/Electronics-Engineering', '179', '', '202441878785EA'),
(3, 'Ekezie ', 'Mercy', 'Ezinne ', 'female', 'Num 33 Morgan estate ', '2003-05-05', 'Ebonyi state', 'Nigeria ', 'ekezieezinne756@gmail.com', '09014867403', 'Part-time', 'ND-Business-Administration', 'No jam', '', '202441877628DA'),
(4, 'Ebeh', 'Williams', 'Uchenna', 'male', '6 iya bukky, lambe junction. Ogun state ', '2004-05-27', 'Ebonyi', 'Nigeria ', 'Ebehwilliams25@gmail.com', '08148367868', 'full-time', 'ND-Computer-Science', '151', '', '202441999609CFP'),
(5, 'OYELEKAN', 'MARY', 'ADEOLA', 'female', 'NO. 22, FATUSI STREET, EJIGBO LAGOS STATE', '2003-05-30', 'OGUN', 'NIGERIAN', 'adeolamary516@gmail.com', '07041710546', 'full-time', 'ND-Business-Administration', '158', '', ''),
(6, 'Ayobami', 'Omotayo', 'Mustapha ', 'male', '72, okesuna street, Lagos island, Lagos state ', '2006-08-14', 'Oyo', 'Nigeria ', 'tayomustapha567@gmail.com', '07058545289', 'full-time', 'ND-Computer-Engineering', '155', '', ''),
(7, 'Shittu', 'Fatima', 'Ajokeade', 'female', '46 Aina road Agiliti', '2003-01-17', 'Ogun State', 'Nigerian', 'Ajokeade22@gmail.com', '09030245416', 'Part-time', 'ND-Business-Administration', '0', '', '202441999609CFP'),
(8, 'Akinleye', 'Israel', 'Oluwatosin', 'male', '36,olowora road, lagos', '2000-06-16', 'Lagos', 'Nigeria', 'srloluwatosin@gmail.com', '+2349030012741', 'online', 'ND-Electrical/Electronics-Engineering', '*', '', ''),
(9, 'AKOREDE', 'FATHIA', 'TEMILEYIN', 'female', '8 Aishata Ijaoba Street, Ilupeju Estate, Abule-Eko, Ijede, Ikorodu, Lagos.', '2006-04-29', 'OYO', 'Nigerian', 'akoredetemileyin482@gmail.com', '08153429745', 'full-time', 'ND-Business-Administration', '148', '', ''),
(10, 'john', 'james', 'gate', 'male', '25, Olutimilehin Street, Ejigbo', '2003-09-09', 'LAGOS', 'NIGERIA', 'forjustded@gmail.com', '08162768687', 'Part-time', 'ND-Computer-Science', '226', '', '202440285765FF'),
(12, 'EZEONYE', 'DANIEL', 'CHIEMERIE', 'male', 'LEKKI PHASE 1, JUDE NWOYE STREET, THOMAS ESTATE LAGOS STATE', '2003-06-13', 'ANAMBRA ', 'NIGERIA', 'chiemeriedaniel39@gmail.com', '09077769892', 'Part-time', 'ND-Electrical/Electronics-Engineering', '140', '', ''),
(13, 'Amaechi ', 'Uchechukwu ', 'Peter-Mary ', 'male', '5, essumei str Whitehouse okoko ', '2007-03-20', 'Imo', 'Nigeria ', 'uchechukwupetermary@gmail.com', '09067076197', 'Part-time', 'ND-Electrical/Electronics-Engineering', '255', '', ''),
(14, 'Olayiwola', 'Kolawole', 'Ibrahim', 'male', 'Unity Zone Ikorodu Lagos ', '1988-12-12', 'Oyo', 'Nigeria', 'emperrorconsult@gmail.com', '08167657166', 'full-time', 'ND-Electrical/Electronics-Engineering', '280', '', ''),
(15, 'Okanlawon', 'Adam', 'Abidemi', 'male', '2,shorodoye Street  Eyita Ikorodu Lagos ', '2003-04-11', 'Kwara State ', 'Nigeria ', 'adamokanlawon187@gmail.com', '09063990172', 'full-time', 'ND-Computer-Science', '156', '', ''),
(16, 'Adeleke ', 'Samiat', 'Oreoluwa ', 'female', '39odulami street ', '2008-09-25', 'Lagos state', 'Nigerian ', 'adelekeyetude5@gmail.com', '08077471316', 'full-time', 'ND-Business-Administration', '142', '', ''),
(17, 'Samson ', 'Okumhede ', 'Destiny ', 'male', 'No.4. Araromi adebread, sabo, yaba, \r\n', '1996-09-20', 'Edo state ', 'Nigeria ', 'destinysamson0002@gmail.com', '07047813496', 'full-time', 'ND-Business-Administration', '116', '', ''),
(18, 'Ayela', 'Adedotun', 'Daniel', 'male', 'No. 2 ori-Okuta Estate Agric Ikorodu ', '2005-11-25', 'Ondo State', 'Nigeria', 'ayelamojirayo60@gmail.com', '09023468026', 'Part-time', 'ND-Business-Administration', '0', '', ''),
(19, 'Hassan ', 'Sheriff ', 'Olamilekan ', 'male', 'No 16 oke oniyo ', '2006-09-18', 'Ekiti ', 'Yoruba ', 'hassansherif753@gmail.com', '09065410711', 'Part-time', 'ND-Business-Administration', '134', '', ''),
(20, 'Elimby', 'Sonia', 'Chidera ', 'female', '24 alh animashun ', '2004-08-27', 'Imo', 'Cameroon ', 'elimbysonia3@gmail.com', '09135023228', 'full-time', 'ND-Business-Administration', '135 ', '', ''),
(21, 'Orji ', 'Amaka ', 'Gifty ', 'female', 'Obiagu nnewi ', '2003-04-22', 'Anambra state ', 'Nigerian', 'amakagifty37@gmail.com', '07043655031', 'Part-time', 'ND-Business-Administration', '145', '', ''),
(22, 'Adebayo ', 'Damilola ', 'Victor ', 'male', 'House 1, Road 1, Estate 1, Redeemetion City Of God ', '2001-02-25', 'Osun ', 'Nigeria ', 'ayomidami012@gmail.com', '09036089863', 'full-time', 'ND-Business-Administration', '142', '', ''),
(23, 'Adebayo ', 'Isreal ', 'Adeniji', 'male', '55 lbukun olu street akoka yaba lagos', '2005-04-12', 'Ogun state ', 'Christian ', 'Adebayoisreal256@gmail.com', '07066044354', 'full-time', 'ND-Business-Administration', '147', '', ''),
(24, 'Adegoke ', 'Aisat', 'Adesewa', 'female', 'No 20 Ibeju Lekki', '2000-04-09', 'Oyo State', 'Nigerian', 'aisatadegoke1@gmail.com', '07050325262', 'full-time', 'ND-Business-Administration', '145', '', ''),
(25, 'Sholeye', 'Samiat', 'Oyinlola', 'female', '7 Oriyomi Streeet Abeokuta', '2006-01-01', 'sholeye', 'Ogun State', 'sholeyesamiat@gmail.com', '08101173769', 'full-time', 'ND-Business-Administration', '149', '', ''),
(26, 'Korie ', 'Uchechi ', 'Gift ', 'female', '3,debari bus stop off perdor road, somolu Lagos State,Nigeria ', '2004-12-04', 'IMO state ', 'Nigeria ', 'uchechigiftkorie@gmail.com', '9118388177', 'full-time', 'ND-Business-Administration', '148', '', ''),
(27, 'Oluwole ', 'Mary ', 'Suliyat ', 'female', '16 glover street ', '2007-02-28', 'Ogun state ', 'Lagos ', 'suliatoluwole7@gmail.com', '07080173877', 'full-time', 'ND-Business-Administration', '147', '', ''),
(28, 'Amos ', 'Benedict ', 'Zanch ', 'male', 'Sabon garin doguwa ', '2006-01-05', 'Kano', 'Nigeria ', 'mondayamos4142002@gmail.com', '09074026098', 'full-time', 'ND-Business-Administration', '138', '', ''),
(29, 'Liadi', 'Ajoke', 'Olamide', 'female', 'Itogbe num 24 orile agege ', '2007-08-03', 'Lagos state ', 'Reading ', 'liadiajoke5@gmail.com', '09070343167', 'full-time', 'ND-Business-Administration', '136', '', ''),
(30, 'Adewale', 'Jeremiah ', 'Abiodun ', 'male', '33 Paul adeoye street tipper garage itele ogun state ', '2007-01-05', 'Oyo state ', 'Nigerian', 'giftedmountzion@gmail.com', '07066781212', 'full-time', 'ND-Computer-Science', '135', '', ''),
(31, 'RASHEED ', 'ABISADE ', 'AYOMIDE ', 'female', 'New garage ', '2005-06-16', 'Osun ', 'Christ', 'rasheedabisade2@gmail.com', '09029218860', 'online', 'ND-Business-Administration', '148', '', ''),
(32, 'Omosuyi ', 'Seyifunmi', 'Testimony ', 'female', 'Off alade street ', '2004-09-17', 'Ondo state ', 'Nigerian ', 'seyimofe143@gmail.com', '08147513429', 'full-time', 'ND-Business-Administration', '148', '', ''),
(33, 'Nwali', 'Joshua', 'Ebuka', 'male', '13 subulade street iyana iyesi ota Ogun state', '2004-10-10', 'Ebonyi', 'Nigeria', 'nwalijoshua545@gmail.com', '09151605293', 'full-time', 'ND-Business-Administration', '144', '', ''),
(34, 'Opayemi', 'Sayo', 'Christiana', 'female', '30b unity avenue,Oko-ito ,gberigbe ,ikorodu,Lagos state.', '2007-12-18', 'Osun state', 'Nigeria', 'opayemisayo@gmail.com', '07047374131', 'full-time', 'ND-Computer-Science', '147', '', ''),
(35, 'Dada', 'Damilare', 'Ezekiel ', 'male', 'Abuja,Amac ,kabusa', '2006-10-12', 'Akiti', 'Nigeria', 'dadadamilare955@gmail.com', '08148969180', 'full-time', 'ND-Electrical/Electronics-Engineering', '145', '', ''),
(36, 'Oloruntoba', 'Joseph', '', 'male', '24 idogogo street, okgi state', '2007-03-20', 'Ondo', 'Nigerian', 'oloruntobajoseph511@gmail.com', '07043035250', 'Part-time', 'ND-Business-Administration', '148', '', ''),
(37, 'Otioro', 'Wisdom', 'Edet', 'select_gender', '1 koshebino street oregun\r\nOregun', '1998-07-08', 'Akwa ibom ', 'Nigerian ', 'wisdomotioro@gmail.com', '08131801739', 'Part-time', 'ND-Business-Administration', '230', '', ''),
(38, 'Adesanya ', 'Victor ', 'OLUWASEGUN ', 'male', 'No 10 erijiyan drive off SHOLA MARTINCE street, Abule egba Lagos', '2024-09-09', 'Ogun state ', 'Lagos state ', 'olamidevictor184@gmail.com', '08101545227', 'Part-time', 'ND-Computer-Science', '139', '', ''),
(39, 'Oyedun ', 'Rebecca', 'Oluwanife', 'female', 'No. 4 ori Okuta Estate Agric, Ikorodu', '2007-07-18', 'Ondo State', 'Nigeria', 'oluwanifemioyedun140@gmail.com', '08082423763', 'full-time', 'ND-Business-Administration', '157', '', ''),
(40, 'Oyedun', 'Israel ', 'Ayomide', 'male', 'No. 4 Ori Okuta Estate Agric, Ikorodu Lagos', '2005-11-25', 'Ondo State', 'Nigeria', 'ayedunisreal96@gmail.com', '09033853257', 'full-time', 'ND-Business-Administration', '155', '', ''),
(41, 'MAWONELEH', 'JUNIOR', 'ALLEN', 'male', 'No. 13 Olateju Ilesanmi street Baruwa inside, Ipaja Lagos.', '2003-01-02', 'Kwara State', 'Nigerian', 'mawonelehallenjunior@gmail.com', '+2348109277009', 'full-time', 'ND-Computer-Science', '148', '', ''),
(42, 'Sai\'d', 'Alliyyah ', 'Motunrayo ', 'female', '10A Aladelola Street ,Ikosi. Ketu.\r\nKetu', '2006-05-20', 'Lagos', 'Nigeria', 'abenialliyyah@gmail.com', '09031210842', 'full-time', 'ND-Computer-Science', '145', '', ''),
(43, 'Ilonuba', 'Tobechukwu', 'wisdom', 'male', 'Orlu ebsense ihioma imo state', '2003-06-04', 'Imo state', 'Nigeria', 'tobechukwuilonuba10@gmail.com', '9155710728', 'online', 'ND-Computer-Science', '148', '', ''),
(44, 'Okunlola', 'Oriyomi ', 'Olayinka ', 'male', '9 balogun kuku ', '2004-05-08', 'Oyo', ' Christian', 'Oriyomiola43@gmail.com', '08087485593', 'Part-time', 'ND-Electrical/Electronics-Engineering', '145', '', ''),
(45, 'Peter', 'Joshua', 'Onyekachi', 'male', '76 IBB WAY CALABAR', '10/11/2005', 'EBNOYI', 'Nigeria', 'Joshuapeter709@gmail', '09165837764', 'full-time', 'ND-Computer-Science', '140', '', ''),
(46, 'Ilonuba', 'Tobechukwu', 'wisdom', 'male', 'Orlu ebsense ihioma imo state', '2003-06-04', 'Imo state', 'Nigeria', 'tobechukwuilonuba10@gmail.com', '9155710728', 'online', 'ND-Computer-Science', '148', '', ''),
(47, 'Bantefa', 'Basit', 'Olufela ', 'male', '17,odemo street lusada', '2006-03-28', 'Ogun State ', 'Nigerian ', 'basitbantenfa326@gmail.com', '09039125720', 'full-time', 'ND-Computer-Engineering', '149', '', ''),
(48, 'ABDULFATAI ', 'MISTURA ', 'OLAMIDE ', 'female', '20 celetu Aga ', '2005-10-22', 'Ogun state ', 'Nigeria ', 'Adenijimistura49@gmail.com', '09035489135', 'Part-time', 'ND-Computer-Science', '141', '', ''),
(49, 'Nwebonyi', 'Jude', 'Chukwuebuka', 'male', '3 Aba road Onitsha ', '2006-07-12', 'Ebonyi', 'Nigerian', 'rodrickbellingham5@gmail.com', '09116882987', 'full-time', 'ND-Computer-Engineering', '149', '', ''),
(50, 'Lawal', 'Jamiu', 'Olamilekan', 'male', '10 komolafe str ayetoro itele Ado-Odo otta Ogun state ', '2002-04-11', 'Osun', 'Nigeria ', 'lawaljamiu252@gmail.com', '8130307876', 'full-time', 'ND-Business-Administration', '149', '', ''),
(51, 'Kumasa', 'Victoria', 'Mawusede', 'female', 'Sunny Ajose Ajara Agamathen Street Badagry ', '2006-11-21', 'Lagos', 'Nigerian', 'victoriakumasa9@gmail.com', '08120827782', 'full-time', 'ND-Business-Administration', '140', '', ''),
(52, 'SHITTU ', 'FAWAS ', 'ABIODUN ', 'male', 'Araromi ', '2007-12-24', 'Lagos state ', 'NIGERIA ', 'shittufawas48@gmail.com', '08106035047', 'full-time', 'ND-Business-Administration', '137', '', ''),
(53, 'Olajide ', 'Idowu ', 'Abosede ', 'female', 'Lagos Nigeria \r\nIkotun ', '2006-09-16', 'Ekiti ', 'Efon ', 'olajideidowu400@gmail.com', '07010339163', 'online', 'ND-Business-Administration', '142', '', ''),
(54, 'Daniel ', 'Edebo', 'Ojomaje ', 'male', ' Sangotedo\r\nLakowe ajegule street num 21. ', '2002-05-20', 'Kogi state ', 'Nigeria ', 'ojomajedaniel@gmail.com', '08156509567', 'Part-time', 'ND-Business-Administration', '100', '', ''),
(55, 'Akinyemi ', 'Amudat ', 'Dada ', 'female', 'No 5 Felix street satellite town ', '2024-09-20', 'Lagos state ', 'Christian ', 'akinyemiamudat01@gmail.com', '08161287253', 'full-time', 'ND-Business-Administration', '136', '', ''),
(56, 'Amanchukwu ', 'Miracle ', 'Chinenye', 'female', 'Church bostop', '2006-03-31', 'Anambra ', 'Nigeria', 'miraclechinenye91@gmail.com', '07076922711', 'full-time', 'ND-Business-Administration', '144', '', ''),
(57, 'Hamzat', 'Idris', 'Olansile', 'male', 'Orirta Challenge Ibadan off Ogudipe Street', '2007-11-12', 'Oyo State', 'Nigeria', 'hamzatidrisolansile@gmail.com', '08162871053', 'full-time', 'ND-Computer-Science', '142', '', ''),
(58, 'Ajibade', 'Ireoluwa ', 'Precious ', 'female', '4, Remi Agbeniyi street, owode weigh bridge, ikorodu road, Lagos ', '2008-11-13', 'Oyo', 'Nigeria', 'ajibadeireoluwa8@gmail.com', '09037388108', 'full-time', 'ND-Computer-Science', '189', '', ''),
(59, 'ijeh', 'Emmanuel ', 'Triumphant ', 'male', '05 church str off baake str iju ota ogun state', '2006-04-06', 'Abia state', 'Nigeria ', 'triumphantijeh@gmail.com', '07038120309', 'full-time', 'ND-Computer-Science', '186', '', ''),
(60, 'Lukman ', 'Ademola ', 'Ishola', 'male', 'Bamishi kuje Abuja ', '2003-12-25', 'Ibadan ', 'Nigerian ', 'kizzdemor964@gmail.com', '07026237944,08123227549', 'full-time', 'ND-Business-Administration', '140', '', ''),
(61, 'Chukwuemeka', 'Isreal ', 'Chukwuemeka ', 'male', ' Number 2 Aladewura street water, by water bus stop Alimosho Lagos ', '2007-05-20', 'Anambra ', 'Nigeria ', 'gmft7654@gmail.com', '09066039425', 'full-time', 'ND-Computer-Science', '142', '', ''),
(62, 'CHIDIEBERE ', 'DIVINE', 'UGOCHI', 'female', 'No 14, ifalara street muta 3, adiyan gasline alagbado Ogun state ', '2008-09-03', 'IMO STATE', 'NIGERIAN ', 'chidieberemartins01@gmail.com', '07015648909', 'full-time', 'ND-Computer-Science', '146', '', ''),
(63, 'Kalu', 'Oluchi', 'Goodness ', 'female', 'No 2,great challenge road ', '2003-03-16', 'Abia', 'Nigerian ', 'oluchikalu519@gmail.com', '09012527153', 'Part-time', 'ND-Business-Administration', '146', '', ''),
(64, 'Atolagbe ', 'Habeeb', 'Babajide', 'male', '12 anjorin street olokodana ', '2003-03-19', 'Kwara state', 'Nigerian ', 'Atolagbehabeeb80@gmail.com', '09169024743', 'select', 'ND-Business-Administration', '149', '', ''),
(65, 'Adediran ', 'Toyosi', 'Oluwasegun', 'male', '4,oyotedo street,opeilu,agbado.ogun state .', '1999-02-08', 'Ogun state ', 'Nigeria ', 'adediranoluwatoyosi4@gmail.com', '09133010011', 'full-time', 'ND-Computer-Science', '162', '', ''),
(66, 'Adeniyi', 'Adebayo', 'Olasunkanmi', 'male', '06 upper campus lagos \r\nIsland', '2002-01-25', 'Lagos-State', 'Nigerian', 'adeniyiadebayo200@gmail.com', '09044915244', 'full-time', 'ND-Business-Administration', '147', '', ''),
(67, 'Folarin ', 'Wasiu', 'Adedeji', 'male', '1 Alakan steel ', '2005-06-08', 'Ikorodu', 'Nigeria ', 'folarinwasiu99@gmail.com', '09052198662', 'full-time', 'ND-Business-Administration', '147', '', ''),
(68, 'Ayite', 'Savior', 'Tobi', 'female', '4, Ajibade Street, Ilasamaja, Lagos State', '2000-07-30', 'Ogun State', 'Nigerian', 'dessysgrace@gmail.com', '07086973322', 'Part-time', 'ND-Business-Administration', '137', '', ''),
(69, 'Sunmola ', 'Aliyah ', 'Opeymi ', 'female', 'Adesomoju ', '2008-12-06', 'Lagos ', 'Nigerian ', 'ganiyatomoshewasunmola@gmail.com', '08056968879', 'full-time', 'ND-Business-Administration', '147', '', ''),
(70, 'Olugbenga', 'Boluwatife ', 'Adebukola', 'female', '24,owonikoko street,Lagos state ', '2006-01-31', 'Ogun state ', 'Nigeria ', 'Babet948@gmail.com', '09127024819', 'full-time', 'ND-Business-Administration', '146', '', ''),
(71, 'Joseph ', 'Anuoluwa ', 'Ayeni ', 'male', 'Olambe ogun state ', '1999-11-19', 'Osun state Nigeria ', 'Nigeria ', 'ayenijosephanuolowa8@gmail.com', '09041829279', 'full-time', 'ND-Computer-Science', '148', '', ''),
(72, 'Bamgboshe', 'Adinni', 'Thoteme', 'male', 'Kweme, badagry west Lagos', '1997-06-03', 'Lagos-State', 'Nigerian', 'bamgboseadinni@gmail.com', '09125214254', 'full-time', 'ND-Business-Administration', '148', '', ''),
(73, 'Odunuga', 'Farouk Olamide', ' Abolere', 'male', '91, cemetery street, Ebutte meta , Yaba, Lagos ', '2008-03-01', 'Lagos ', 'Nigeria ', 'teeslawal@yahoo.com', '08066446468', 'full-time', 'ND-Computer-Science', '148', '', ''),
(74, 'Babatunde', 'Habeeb', 'Segun', 'male', 'No. 1 Unity & Peace Estate Sango Ota', '2007-09-11', 'Ogun-State', 'Nigerian', 'seunhabeeb98@gmail.com', '07015428152', 'full-time', 'ND-Business-Administration', '148', '', ''),
(75, 'Adebayo ', 'Kareem ', 'Gbolahan ', 'male', 'Hopeful street number 21', '2005-09-17', 'Oshogbo', 'Nigeria ', 'adebayogbolahan508@gmail.com', '9168225875', 'full-time', 'ND-Computer-Science', '140', '', ''),
(76, 'Aderounmu', 'Rahmon', 'Temitope', 'male', 'No 8 Lawrence onipede Gberigbe ikorodu Lagos ', '2002-01-18', 'Kwara ', 'Nigeria ', 'kashamadupe0247@gmail.com', '09133640038', 'full-time', 'ND-Computer-Science', '146', '', ''),
(77, 'Aderounmu', 'Rahmon', 'Temitope', 'male', 'No 8 Lawrence onipede Gberigbe ikorodu Lagos ', '2002-01-18', 'Kwara ', 'Nigeria ', 'kashamadupe0247@gmail.com', '09133640038', 'full-time', 'ND-Computer-Science', '146', '', ''),
(78, 'Dennispoums', 'Dennispoums', 'Dennispoums', '1', 'Tirgu Mures', '1988-02-05', 'Romania', 'russian', 'addingtonlou99@gmail.com', '83295771427', 'full-time', 'ND-Business-Administration', 'Dennispoums', '', ''),
(79, 'Olabokunde', 'Daniel', 'Olamilekan', 'male', '71 Brickfield Ebute Metta Lagos', '2003-07-02', 'Lagos-State', 'Nigeria', 'averolastborn@gmail.com', '08088746543', 'full-time', 'ND-Business-Administration', '147', '', ''),
(80, 'Badmus', 'Malik', 'Michael', 'male', 'No. 2 Banana layout Ajah', '2006-06-26', 'Oyo State', 'Nigeria', 'juwonkizzy@gmail.com', '08104547167', 'select', 'ND-Computer-Science', '141', '', ''),
(81, 'Ayinde ', 'Bolaji ', 'Opeyemi', 'male', 'Adeyemo str no 40 ogun radio ', '2003-10-28', 'Lagos', 'Agege', 'ballyjay397@gmail.com', '07048160648', 'full-time', 'ND-Business-Administration', '139', '', ''),
(82, 'ITA', 'Gospel', 'Okon ', 'male', 'Block 2 Elere police barracks Agege Lagos ', '2002-08-22', 'Akwa iBom ', 'INI ', 'Gospelita888@gmail.com', '07037024480', 'full-time', 'ND-Computer-Engineering', '137', '', ''),
(83, 'AKANNI', 'QUADRI', 'OLAKUNLE', 'male', '2,lamidi street, agbado road ogun state ', '2004-08-31', 'Ogun state', 'Nigeria ', 'olabliss6@gmail.com', '09035280889', 'Part-time', 'ND-Business-Administration', '149', '', ''),
(84, 'Daniel ', 'Temitope', ' Uriel', 'male', '16 Porporo Compound, Boekoh Badagry', '2004-12-26', 'Ogun', 'Nigeria', 'topedaniel970@gmail.com', '08146369215', 'full-time', 'ND-Business-Administration', '147', '', ''),
(85, 'Odighe', 'David ', 'Kema', 'male', '1 folarin street alimosho Lagos ', '2024-10-04', 'Delta ', 'Nigeria ', 'odighedavidokema@gmail.com', '0911546967', 'full-time', 'ND-Electrical/Electronics-Engineering', '133', '', ''),
(86, 'Oni', 'Oluwatofunmi ', 'Druscilla ', 'female', 'No:3\r\nLemumo close water bus stop Iyana ipaja road', '2006-06-16', 'Saki west', 'Oyo ', 'onianu46@gmail.com', '08103952648', 'online', 'ND-Business-Administration', '139', '', ''),
(87, 'Oyeniyi ', 'Sanmi ', 'Goodness ', 'male', '1 ariyibi close ', '2006-05-10', 'Osun state', 'Nigeria', 'sanmigoodness20@gmail.com', '08068767867', 'Part-time', 'ND-Computer-Engineering', '132', '', ''),
(88, 'Adah', 'Benjamine ', 'Ohenne', 'male', '15, Olufumilayo street off ile-po oke-odo Rd Lagos', '2003-06-13', 'Benue state ', 'Nigeria ', 'benjaminadah25@gmail.com', '09014414507', 'Part-time', 'ND-Computer-Science', '204', '', ''),
(89, 'Onabodu ', 'Taofeek', 'Olarewaju', 'male', 'No. 1 Kajola Adefisan Ijebu-Ode', '2007-11-21', 'Ogun', 'Nigeria', 'olarenwajutaofeek40@gmail.com', '07031976421', 'full-time', 'ND-Electrical/Electronics-Engineering', '139', '', ''),
(90, 'Obey', 'Oriyomi', 'Boluwatife', 'male', 'No. 1 Sikirat Yusuf  Oriokuta Agric ', '2006-09-07', 'Oyo State', 'Nigeria', 'danieladeshile89@gmail.com', '09159744810', 'Part-time', 'ND-Business-Administration', 'o', '', ''),
(91, 'Onibiyo', 'Lekan ', 'Ojo ', 'male', 'Tolu road Alakara bus stop', '2003-06-13', 'Osun state', 'Boluwaduro ', 'oluwalekan057@gmail.com', '09151038263', 'Part-time', 'ND-Business-Administration', '140', '', ''),
(92, 'Erinfolami ', 'Ramon', 'Abiodun ', 'male', '36, Ali balogun onipetesi ijoko Ogun state ', '2003-12-07', 'Ogun', 'Nigeria ', 'ramonwerl@gmail.com', '09113261201', 'full-time', 'ND-Electrical/Electronics-Engineering', '145', '', ''),
(93, 'Erinfolami ', 'Ramon', 'Abiodun ', 'male', '36, Ali balogun onipetesi ijoko Ogun state ', '2003-12-07', 'Ogun', 'Nigeria ', 'ramonwerl@gmail.com', '09113261201', 'full-time', 'ND-Electrical/Electronics-Engineering', '145', '', ''),
(94, 'Oseni ', 'Waris ', 'Korede ', 'male', 'No 9 Onasanya street Bariga Lagos ', '2004-12-28', 'Kwara state', 'Nigerian', 'kte606@gmail.com', '08084589304', 'full-time', 'ND-Business-Administration', '0', '', ''),
(95, 'OLABIYI ', 'AYOMIDE', 'HABEEB', 'male', 'NO,49 JAGUNMOLU STREET BARIGA LAGOS STATE ', '2002-07-08', 'OYO STATE ', 'NIGERIA ', 'olaeuro29@gmail.com', '08121223526', 'full-time', 'Select-Program', '205', '', ''),
(96, 'Akewushola ', 'Rabiat ', 'Ashabi ', 'female', 'No 3 cementry road ', '2005-04-01', 'Oya state', 'Nigeria ', 'Oluwashindara5262@gmail.com', '09063175262', 'Part-time', 'ND-Business-Administration', '145', '', ''),
(97, 'Oden', 'Joseph ', 'Ezinnah', 'male', '10 Alubarika street bariga lagos', '2004-05-04', 'Cross river', 'Nigeria ', 'odendavid00@gmail.com', '07010035910', 'full-time', 'ND-Business-Administration', '172', '', ''),
(108, 'Jinadu ', 'Lukman', 'Agboola', 'male', 'Beside Kush Bar Beach, Okun Idado, Ibeju Lekki, Lagos', '2008-04-08', 'Lagos', 'Nigeria ', 'djwater2004@gmail.com', '09027786792', 'full-time', 'ND-Computer-Engineering', '144', '', ''),
(109, 'Moshood', 'Oluwadamilare', 'Jahmah', 'male', '2 segun Famuagu street off welder bus stop', '2001-09-09', 'Osun State', 'Nigeria', 'oluwadamilarejamah@gmail.com', '07037865941', 'Part-time', 'ND-Computer-Engineering', '153', '', '');

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

--
-- Table structure for table `waec`
--

CREATE TABLE `waec` (
  `Id` int(100) NOT NULL,
  `schoolname` varchar(100) NOT NULL,
  `years` varchar(100) NOT NULL,
  `fwaec` varchar(100) NOT NULL,
  `school_name` varchar(100) NOT NULL,
  `year` varchar(100) NOT NULL,
  `swaec` varchar(100) NOT NULL,
  `examination_Type_one` varchar(100) NOT NULL,
  `examination_Type_two` varchar(122) NOT NULL,
  `sname` varchar(23) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `waec`
--

INSERT INTO `waec` (`Id`, `schoolname`, `years`, `fwaec`, `school_name`, `year`, `swaec`, `examination_Type_one`, `examination_Type_two`, `sname`) VALUES
(2, 'clear vision school ', '2022', '360_F_470641754_F1mWYYTnmPDLYTo6G6SUF5t0AhfmJ01o.jpg', 'Okon', '2020', 'WhatsApp Image 2024-10-13 at 20.19.27_bf6004f2.jpg', '12', '23', 'Okon'),
(3, 'clear vision school ', '2022', 'dddd.png', 'clear vision school ', '2020', 'dddd.png', '', '', ''),
(4, 'clear vision school ', '2022', 'dddd.png', 'runsewe', '2020', 'dddd.png', '', '', ''),
(5, 'clear vision school ', '2022', 'dddd.png', '', '', '', 'Waec', 'select', ''),
(6, 'clear vision school ', '2022', 'Screenshot 2024-11-01 095705.png', '', '', '', 'Waec', 'select', ''),
(7, 'clear vision school ', '2022', 'download (4).png', '', '', '', 'Waec', 'select', ''),
(8, 'clear vision school', '2022', 'download (4).png', 'runsewe', '2020', 'images - 2022-12-20T223929.064.jpeg', 'Waec', 'Waec', ''),
(9, 'clear vision school', '2022', 'admission1.jpg', ',', '', '', 'Neco', 'select', '');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `jamb`
--
ALTER TABLE `jamb`
  ADD PRIMARY KEY (`Id`);

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

--
-- Indexes for table `passpprt_sign`
--
ALTER TABLE `passpprt_sign`
  ADD PRIMARY KEY (`Id`);

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

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

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

--
-- Indexes for table `student_table`
--
ALTER TABLE `student_table`
  ADD PRIMARY KEY (`student _id`);

--
-- Indexes for table `waec`
--
ALTER TABLE `waec`
  ADD PRIMARY KEY (`Id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bio_data`
--
ALTER TABLE `bio_data`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `guarantor_form`
--
ALTER TABLE `guarantor_form`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `jamb`
--
ALTER TABLE `jamb`
  MODIFY `Id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `medical_report`
--
ALTER TABLE `medical_report`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `passpprt_sign`
--
ALTER TABLE `passpprt_sign`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `screening_form`
--
ALTER TABLE `screening_form`
  MODIFY `id` int(200) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `state_org`
--
ALTER TABLE `state_org`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `student_jamb_reg`
--
ALTER TABLE `student_jamb_reg`
  MODIFY `id` int(23) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `student_table`
--
ALTER TABLE `student_table`
  MODIFY `student _id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=110;

--
-- AUTO_INCREMENT for table `waec`
--
ALTER TABLE `waec`
  MODIFY `Id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;
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 */;
