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

START TRANSACTION;



--
-- Database: `dishaedu_web`
--

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

--
-- Table structure for table `achievement`
--

CREATE TABLE `achievement` (
  `achiev_id` int(11) NOT NULL,
  `achiev_name` varchar(300) NOT NULL,
  `achiev_des` longtext NOT NULL,
  `achiev_img` varchar(300) NOT NULL,
  `achiev_creatdate` varchar(300) NOT NULL,
  `achiev_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `achievement`
--

INSERT INTO `achievement` (`achiev_id`, `achiev_name`, `achiev_des`, `achiev_img`, `achiev_creatdate`, `achiev_recycle`) VALUES
(1, 'Award From ZEE Network', 'Our Chairman Mr. N. R. Dutta is receiving Education Excellence award under Industry Institute Partnership Venture from CEO of ZEE NETWORK', '../upload/achievement/1713040067.jpg', 'Apr 14, 2024 1:02 am', 1),
(2, 'Awards From ASSOCHAM INDIA', '', '../upload/achievement/1713509997.png', 'Apr 19, 2024 12:03 pm', 1);

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

--
-- Table structure for table `all_tag`
--

CREATE TABLE `all_tag` (
  `all_tag_sl_no` int(11) NOT NULL,
  `all_tag_id` varchar(255) NOT NULL,
  `all_tag_catagory` varchar(255) NOT NULL,
  `all_tag_get_id` varchar(255) NOT NULL,
  `all_tag_for` varchar(255) NOT NULL,
  `all_tag_title` varchar(255) NOT NULL,
  `all_tag_url` varchar(255) NOT NULL,
  `all_tag_up_by` varchar(255) NOT NULL,
  `all_tag_upload_date` varchar(255) NOT NULL,
  `all_tag_edit_date` varchar(255) NOT NULL,
  `all_tag_pos` int(11) NOT NULL,
  `all_tag_recycle` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `alumni`
--

CREATE TABLE `alumni` (
  `alu_id` int(11) NOT NULL,
  `alu_name` varchar(300) NOT NULL,
  `alu_designation` varchar(300) NOT NULL,
  `alu_des` longtext NOT NULL,
  `alu_img` varchar(300) NOT NULL,
  `alu_creatdate` varchar(300) NOT NULL,
  `alu_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `alumni`
--

INSERT INTO `alumni` (`alu_id`, `alu_name`, `alu_designation`, `alu_des`, `alu_img`, `alu_creatdate`, `alu_recycle`) VALUES
(1, 'ARIJITA MAJUMDAR', 'APPLICCATION DEVELOPMENT SENIOR ANALYST', 'ACCENTURE, KOLKATA', '../upload/alumni/1713339795.png', 'Apr 17, 2024 1:13 pm', 1),
(2, 'ANUSHMITA SAMANTA', 'DATA ANALYST TEAM LEAD', 'WIPRO', '../upload/alumni/1713340148.png', 'Apr 17, 2024 1:19 pm', 1),
(3, 'DEBARTH CHATTERJEE', 'PURSUING PHD', 'IIT KANPUR', '../upload/alumni/1713340190.png', 'Apr 17, 2024 1:19 pm', 1),
(4, 'RAMESH THAKUR', 'EPU MANAGER', 'ALSTOM INDIA TRANSPORT LTD', '../upload/alumni/1713340235.png', 'Apr 17, 2024 1:20 pm', 1);

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `con_id` int(11) NOT NULL,
  `con_type` varchar(300) NOT NULL,
  `con_name` varchar(50) NOT NULL,
  `con_no` varchar(15) NOT NULL,
  `con_whatsapp` varchar(30) NOT NULL,
  `con_subject` varchar(30) NOT NULL,
  `con_email` varchar(100) NOT NULL,
  `con_address` varchar(500) NOT NULL,
  `con_message` varchar(200) NOT NULL,
  `con_creatdate` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`con_id`, `con_type`, `con_name`, `con_no`, `con_whatsapp`, `con_subject`, `con_email`, `con_address`, `con_message`, `con_creatdate`) VALUES
(2, 'Admission', 'Kallol Dey Sarkar', '09735907380', '9735907380', 'CIVIL ENGINEERING (DIPLOMA)', 'kalloldeysarkar1996@gmail.com', 'Runibari, Nishiganj\r\nCoochBehar, West Bengal, Pin-736157', '', '2024-04-23 16:15:03'),
(3, 'Index Registration', 'Abdul Hannan ', '7003877581', '', 'Bachelor of Medical Laboratory', 'hannan742147@gmail.com', '', '', '2024-07-24 16:57:53'),
(4, 'Index Registration', 'Tamij sk ', '8145070107', '', 'Bachelor of Physiotherapy( PAR', 'physiosahin94@gnmail.com', '', '', '2024-08-02 20:35:13'),
(5, 'Index Registration', 'Golam Esdani', '8001278150', '', 'GNM ( NURSING  )', 'golamesdani292@gmail.com', '', '', '2024-08-25 17:46:56'),
(6, 'Contact Page', 'SUMAN KOLEY', '7047463093', '', 'Application for the post of Cl', 'koley2002suman@gmail.com', '', 'Respected sir, \r\n               I Suman Koley completed BSC critical care technology from College of Paramedical and Allied Health Science , WBUHS, . Now I am working in ICU at SHARANYA MULTI SPECIALI', '2024-09-30 10:04:15'),
(7, 'Index Registration', 'Sandip Kumar Mahato', '8536910152', '', 'B.Sc. in Critical Care Technol', 'kumarmahatos22@gmail.com', '', '', '2024-09-30 12:00:52'),
(8, 'Index Registration', 'Biprojit dey ', '9707628218', '', 'Bachelor of Physiotherapy( PAR', 'deybiki758@gmail.com', '', '', '2024-11-04 13:36:33'),
(9, 'Contact Page', 'Poulami Pan', '7364995090', '', 'Post of Clinical instructor', 'poulamipan1@gmail.com', '', 'Is there any post available for clinical instructor at your nursing institution?', '2024-11-05 10:24:49'),
(10, 'Contact Page', 'Suman sarkar', '7908273868', '', 'Gnm course ', '', '', '', '2025-05-18 20:23:51'),
(11, 'Contact Page', '9635192842', '9635192842', '', 'Cmc', 'masumhasan146@gmail.com', '', 'Hi', '2025-10-14 18:20:52'),
(12, 'Contact Page', 'Md Sahabuddin', '7908610860', '', 'CMS &ED', 'mdsahabuddin6580@gmail.com', '', '', '2025-10-16 15:51:00'),
(13, 'Index Registration', 'Md Sahabuddin', '7908610860', '', 'CMS & EDT( Professional Skill ', 'mdsahabuddin6580@gmail.com', '', '', '2025-10-16 15:54:27'),
(14, 'Contact Page', 'Md Sahabuddin', '7908610860', '', 'CMS&ED', 'mdsahabuddin6580@gmail.com', '', 'আমি cms ed  করতে ইচà§ছà§ক টাই কত koroch হবে ', '2025-10-16 15:58:36');

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `course_id` int(11) NOT NULL,
  `course_name` varchar(300) NOT NULL,
  `course_dept` varchar(300) NOT NULL,
  `course_short_des` longtext NOT NULL,
  `course_long_des` longtext NOT NULL,
  `course_long_des_two` longtext NOT NULL,
  `course_img` varchar(300) NOT NULL,
  `course_duration` varchar(300) NOT NULL,
  `course_intake` varchar(300) NOT NULL,
  `course_creatdate` varchar(300) NOT NULL,
  `course_position` int(11) NOT NULL,
  `course_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`course_id`, `course_name`, `course_dept`, `course_short_des`, `course_long_des`, `course_long_des_two`, `course_img`, `course_duration`, `course_intake`, `course_creatdate`, `course_position`, `course_recycle`) VALUES
(7, 'GNM Nursing', '1', 'The GNM (General Nursing and Midwifery) Nursing course at Disha Career Academy prepares students to build a rewarding career in healthcare. This program focuses on nursing care, midwifery, patient management, and community health services. With expert faculty, practical training, and placement support, the course ensures students develop the skills and confidence to serve in hospitals, clinics, and healthcare centers.', '<p>The <strong>General Nursing and Midwifery (GNM) Nursing course</strong> at <strong>Disha Career Academy</strong> is designed to prepare students for a professional career in the field of healthcare and nursing. This program focuses on equipping learners with the knowledge, practical skills, and compassionate approach required to serve patients and communities effectively.</p>\r\n\r\n<p>Throughout the course, students are trained in <strong>fundamentals of nursing, medical-surgical nursing, community health, midwifery, child health, mental health nursing, and emergency care.</strong> In addition, emphasis is placed on communication skills, ethical practices, and hands-on clinical exposure to ensure a strong foundation for future healthcare professionals.</p>\r\n\r\n<p>At DCA, we provide <strong>modern classrooms, well-equipped labs, experienced faculty, and clinical training opportunities</strong> in reputed hospitals and healthcare centers. This ensures that students not only gain academic knowledge but also practical confidence to handle real-life situations in the medical field.</p>\r\n\r\n<p>The GNM Nursing program opens diverse career pathways, including roles in <strong>government and private hospitals, community health centers, nursing homes, clinics, NGOs, and international healthcare organizations.</strong> Graduates can also pursue higher studies such as <strong>B.Sc. Nursing or Post Basic Nursing</strong> for advanced opportunities.</p>\r\n\r\n<p>By choosing GNM Nursing at Disha Career Academy, students take the first step towards becoming <strong>skilled, responsible, and compassionate healthcare professionals</strong>, ready to make a difference in society.</p>\r\n', '', '../upload/course/1756879952.png', '3.5', '60', 'Sep 2, 2025 2:45 pm', 0, 1),
(8, 'CMS & EDT', '6', 'CMS & ED (Community Medical Services & Essential Drugs) is a professional diploma program that prepares students to deliver essential healthcare services at the community level. Over a span of 18 months, this course offers a balanced mix of theory and practical training in:', '<p><strong>CMS &amp; ED (Community Medical Services &amp; Essential Drugs)</strong></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p><strong>Diagnosis &amp; treatment</strong> of common diseases and ailments</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Safe use of essential medicines</strong> and primary drug administration</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>First aid &amp; emergency care</strong>, including wound dressing and injections</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Preventive healthcare</strong> and awareness for rural populations</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>This program is especially designed to strengthen rural healthcare, where access to doctors and hospitals is often limited. CMS &amp; ED graduates are trained to function as reliable <strong>Rural Health Practitioners or Village Doctors</strong>, offering affordable and effective medical services to underserved communities.</p>\r\n\r\n<h3>🌟 Career Opportunities after CMS &amp; ED</h3>\r\n\r\n<p>Students completing this diploma have multiple career pathways, such as:</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Starting their <strong>own healthcare practice</strong> as a Rural Health Practitioner</p>\r\n	</li>\r\n	<li>\r\n	<p>Working in <strong>private clinics, nursing homes, or health centers</strong></p>\r\n	</li>\r\n	<li>\r\n	<p>Joining <strong>NGOs and public health organizations</strong> focused on rural care</p>\r\n	</li>\r\n	<li>\r\n	<p>Serving as <strong>community healthcare workers</strong> in villages and semi-urban areas</p>\r\n	</li>\r\n	<li>\r\n	<p>Using this diploma as a <strong>foundation for advanced healthcare studies</strong> in the future</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>With the rising need for accessible healthcare in India, especially in rural areas, CMS &amp; ED professionals are gaining recognition and respect. This diploma is an excellent choice for those passionate about healthcare and committed to serving society, while also building a <strong>stable and respected career</strong> in the medical field.</p>\r\n', '', '../upload/course/1757576833.jpg', '1.5 Years', '60', 'Sep 11, 2025 1:16 pm', 0, 1),
(9, 'NEET - UG ', '3', 'NEET-UG is the national-level entrance exam for admission into MBBS, BDS, AYUSH, and other medical courses in India. Our NEET coaching program provides structured classes, expert faculty guidance, regular mock tests, and study materials to help students secure top ranks and achieve their dream of becoming doctors.', '<p><strong><a href=\"https://neet.nta.nic.in/\">NEET-UG</a> (National Eligibility cum Entrance Test for Undergraduate) is the gateway to medical careers in India, offering admission into MBBS, BDS, AYUSH, Veterinary Science, and other allied health science courses. It is one of the most competitive exams in the country, and students require dedicated preparation to succeed. At Disha Career Academy, our NEET coaching program is designed to provide a strong foundation in Physics, Chemistry, and Biology, along with exam-oriented strategies that maximize performance.</strong></p>\r\n\r\n<p><strong>Our program includes:</strong></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p><strong>Comprehensive classroom sessions</strong> covering <a href=\"https://ncert.nic.in/\">NCERT</a> and advanced concepts</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Regular mock tests &amp; practice papers</strong> based on the latest exam pattern</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>One-on-one mentorship and doubt-clearing sessions</strong> with expert faculty</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Updated study materials and test series</strong> for systematic revision</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Time management and exam strategy training</strong> to boost confidence</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><strong>Career Opportunities after NEET-UG:</strong></p>\r\n\r\n<ul>\r\n	<li>\r\n	<p>MBBS (Bachelor of Medicine and Bachelor of Surgery)</p>\r\n	</li>\r\n	<li>\r\n	<p>BDS (Bachelor of Dental Surgery)</p>\r\n	</li>\r\n	<li>\r\n	<p>BAMS, BHMS, and BUMS (AYUSH courses)</p>\r\n	</li>\r\n	<li>\r\n	<p>BVSc &amp; AH (Veterinary Science and Animal Husbandry)</p>\r\n	</li>\r\n	<li>\r\n	<p>B.Sc. Nursing and other paramedical courses in some institutes</p>\r\n	</li>\r\n</ul>\r\n\r\n<p><strong>With the right guidance and hard work, NEET-UG aspirants can turn their medical dreams into reality. Disha Career Academy ensures that every student receives personalized support, quality education, and the best preparation environment to achieve success in this highly competitive exam.</strong></p>\r\n', '', '../upload/course/1757577165.jpg', '1 year', '60', 'Sep 11, 2025 1:22 pm', 0, 1),
(10, 'JENPAS-UG', '3', 'JENPAS-UG 1 Year Long-Term Course is designed for students preparing to build their career in nursing and paramedical fields. With expert faculty, structured study plans, regular mock tests, and doubt-clearing sessions, this program provides complete guidance to crack the JENPAS-UG entrance exam successfully.', '<p><strong>The JENPAS-UG 1 Year Long-Term Course is a specially designed program for aspirants who want to pursue nursing and paramedical careers through the West Bengal Joint Entrance Examination Board&rsquo;s JENPAS-UG entrance exam. This course provides students with a strong foundation in Physics, Chemistry, Biology, English, and Logical Reasoning &ndash; the core subjects of the exam.</strong></p>\r\n\r\n<p>Throughout the year, students receive:</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p><strong>Comprehensive classroom coaching</strong> with expert faculty guidance</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Detailed study materials</strong> covering the latest syllabus and exam pattern</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Chapter-wise tests and full-length mock exams</strong> for practice and performance analysis</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Doubt-clearing sessions</strong> to strengthen weak areas</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Personalized mentorship and time management tips</strong> for exam preparation</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>This course ensures that students develop not only subject knowledge but also exam confidence. With a structured schedule and continuous evaluation, the JENPAS-UG 1 Year Long-Term Course is the perfect choice for students who aim to secure admission into top GNM, ANM, B.Sc. Nursing, and Paramedical institutions in West Bengal.</p>\r\n', '<h2>📘 <strong>JENPAS-UG 1 Year Long-Term Course &ndash; Syllabus</strong></h2>\r\n\r\n<p>The syllabus is based on <strong>Class XI &amp; XII level subjects</strong> under the West Bengal Council of Higher Secondary Education (WBCHSE) and equivalent boards.</p>\r\n\r\n<h3>🔹 <strong>Subjects Covered</strong></h3>\r\n\r\n<ol>\r\n	<li>\r\n	<p><strong>Biology</strong></p>\r\n\r\n	<ul>\r\n		<li>\r\n		<p>Diversity of the Living World</p>\r\n		</li>\r\n		<li>\r\n		<p>Cell Structure and Function</p>\r\n		</li>\r\n		<li>\r\n		<p>Human Physiology</p>\r\n		</li>\r\n		<li>\r\n		<p>Plant Physiology</p>\r\n		</li>\r\n		<li>\r\n		<p>Reproduction</p>\r\n		</li>\r\n		<li>\r\n		<p>Genetics and Evolution</p>\r\n		</li>\r\n		<li>\r\n		<p>Ecology and Environment</p>\r\n		</li>\r\n		<li>\r\n		<p>Biotechnology and Its Applications</p>\r\n		</li>\r\n	</ul>\r\n	</li>\r\n	<li>\r\n	<p><strong>Physics</strong></p>\r\n\r\n	<ul>\r\n		<li>\r\n		<p>Physical World, Units &amp; Measurements</p>\r\n		</li>\r\n		<li>\r\n		<p>Motion of System of Particles &amp; Rigid Body</p>\r\n		</li>\r\n		<li>\r\n		<p>Work, Energy &amp; Power</p>\r\n		</li>\r\n		<li>\r\n		<p>Laws of Motion</p>\r\n		</li>\r\n		<li>\r\n		<p>Gravitation</p>\r\n		</li>\r\n		<li>\r\n		<p>Thermodynamics &amp; Kinetic Theory</p>\r\n		</li>\r\n		<li>\r\n		<p>Oscillations &amp; Waves</p>\r\n		</li>\r\n		<li>\r\n		<p>Electrostatics &amp; Current Electricity</p>\r\n		</li>\r\n		<li>\r\n		<p>Magnetic Effects of Current &amp; Magnetism</p>\r\n		</li>\r\n		<li>\r\n		<p>Optics &amp; Dual Nature of Matter</p>\r\n		</li>\r\n		<li>\r\n		<p>Atoms &amp; Nuclei</p>\r\n		</li>\r\n		<li>\r\n		<p>Electronic Devices</p>\r\n		</li>\r\n	</ul>\r\n	</li>\r\n	<li>\r\n	<p><strong>Chemistry</strong></p>\r\n\r\n	<ul>\r\n		<li>\r\n		<p>Some Basic Concepts of Chemistry &amp; Structure of Atom</p>\r\n		</li>\r\n		<li>\r\n		<p>Classification of Elements &amp; Periodicity</p>\r\n		</li>\r\n		<li>\r\n		<p>Chemical Bonding and Molecular Structure</p>\r\n		</li>\r\n		<li>\r\n		<p>States of Matter, Thermodynamics &amp; Equilibrium</p>\r\n		</li>\r\n		<li>\r\n		<p>The Redox Reaction &amp; The Chemical Kinetics</p>\r\n		</li>\r\n		<li>\r\n		<p>The p-Block, d-Block and f-Block Elements</p>\r\n		</li>\r\n		<li>\r\n		<p>The Hydrogen &amp; The s-Block Element (Alkali &amp; Alkaline earth metals)</p>\r\n		</li>\r\n		<li>\r\n		<p>The Organic Chemistry: Hydrocarbons, Biomolecules, Polymers, Environmental Chemistry</p>\r\n		</li>\r\n	</ul>\r\n	</li>\r\n	<li>\r\n	<p><strong>English</strong></p>\r\n\r\n	<ul>\r\n		<li>\r\n		<p>Vocabulary &amp; Grammar</p>\r\n		</li>\r\n		<li>\r\n		<p>Synonyms, Antonyms, Spelling corrections</p>\r\n		</li>\r\n		<li>\r\n		<p>Comprehension passages</p>\r\n		</li>\r\n		<li>\r\n		<p>Error detection &amp; Sentence improvement</p>\r\n		</li>\r\n	</ul>\r\n	</li>\r\n	<li>\r\n	<p><strong>Logical Reasoning</strong></p>\r\n\r\n	<ul>\r\n		<li>\r\n		<p>Analogy &amp; Classification</p>\r\n		</li>\r\n		<li>\r\n		<p>Series (Number, Letter, Figure)</p>\r\n		</li>\r\n		<li>\r\n		<p>Coding-Decoding</p>\r\n		</li>\r\n		<li>\r\n		<p>Blood Relations</p>\r\n		</li>\r\n		<li>\r\n		<p>Direction Sense &amp; Ranking Test</p>\r\n		</li>\r\n		<li>\r\n		<p>Venn Diagrams &amp; Syllogism</p>\r\n		</li>\r\n		<li>\r\n		<p>Clock &amp; Calendar Problems</p>\r\n		</li>\r\n	</ul>\r\n	</li>\r\n</ol>\r\n', '../upload/course/1757586272.jpg', '1', '60', 'Sep 11, 2025 3:50 pm', 0, 1);

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

--
-- Table structure for table `data`
--

CREATE TABLE `data` (
  `data_sl_no` int(11) NOT NULL,
  `data_ref_id` varchar(255) NOT NULL,
  `data_catagory` varchar(255) NOT NULL,
  `data_title` varchar(255) NOT NULL,
  `data_short_des` longtext NOT NULL,
  `data_img` varchar(255) NOT NULL,
  `data_long_des` longtext NOT NULL,
  `data_seo_title` varchar(255) NOT NULL,
  `data_seo_keyword` varchar(255) NOT NULL,
  `data_seo_tag` longtext NOT NULL,
  `data_up_by` varchar(255) NOT NULL,
  `data_up_date` varchar(255) NOT NULL,
  `data_edit_date` varchar(255) NOT NULL,
  `data_count` int(11) NOT NULL,
  `data_position` int(11) NOT NULL,
  `data_recycle` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `data` (`data_sl_no`, `data_ref_id`, `data_catagory`, `data_title`, `data_short_des`, `data_img`, `data_long_des`, `data_seo_title`, `data_seo_keyword`, `data_seo_tag`, `data_up_by`, `data_up_date`, `data_edit_date`, `data_count`, `data_position`, `data_recycle`) VALUES
(61, '', 'facility', 'Teaching and Research', '', '', '', '', '', '', '', 'May 14, 2024 2:57 pm', '', 0, 2, 1),
(62, '', 'facility', 'Infrastructure ', '', '', '', '', '', '', '', 'May 14, 2024 2:57 pm', '', 0, 1, 1),
(47, '', 'facility', 'Facility', '', '../upload/facility/1715150457.jpg', '', '', '', '', '', 'May 8, 2024 12:10 pm', '', 0, 6, 1),
(58, '', 'facility', 'Hostel Facilities', '', '', '', '', '', '', '', 'May 14, 2024 2:54 pm', '', 0, 5, 1),
(59, '', 'facility', 'Laboratories', '', '', '', '', '', '', '', 'May 14, 2024 2:56 pm', '', 0, 3, 1),
(55, '', 'image gallery', 'DISHA', '', '../upload/gallery/1715157888.jpg', '', '', '', '', '', 'May 8, 2024 2:14 pm', '', 0, 0, 1),
(56, '', 'our group', 'Disha Career Academy', '', '../upload/group/1719208584.jpg', '<h1><em><strong>Under Construction</strong></em></h1>\r\n', '', '', 'http://kallol.digix.in/kallol/mcrs/', '', 'May 9, 2024 3:23 pm', '', 0, 0, 1),
(45, 'about8663420240507181210', 'single_page', 'PLACEMENT TRAINING', 'At Disha Career Academy, placements are not just about finding a job—it’s about building a future. We understand that every student dreams of turning their learning into a rewarding career, and our Placement Cell ensures just that.\r\n\r\nThrough continuous industry interactions, career counseling, internships, and mock interviews, we prepare students to face the real-world job market with confidence. Our tie-ups with reputed hospitals, clinics, hotels, and institutions open the door to multiple career pathways.\r\n\r\nDCA takes pride in its 100% Placement Assistance policy, ensuring that each student gets the right guidance to achieve their professional goals. Whether in healthcare, hospitality, pharma, or education, our students step into their careers fully prepared and highly skilled.\r\n\r\n👉 With us, your journey doesn’t end at education—it begins with a career!\r\n', '438681.webp', '<h2>🌟 <strong>Our Placement Support Includes:</strong></h2>\r\n\r\n<p>✅ <strong>100% Placement Assistance</strong> &ndash; Career counseling, resume building, and interview preparation<br />\r\n✅ <strong>Industry Tie-ups</strong> &ndash; Collaborations with reputed hospitals, nursing homes, hotels, and healthcare organizations<br />\r\n✅ <strong>Internship Opportunities</strong> &ndash; Hands-on training through internships and real-world projects<br />\r\n✅ <strong>Skill Development Workshops</strong> &ndash; Communication, Spoken English, personality development, and soft skills training<br />\r\n✅ <strong>Job Fairs &amp; Campus Drives</strong> &ndash; Regular recruitment drives with industry experts and HR professionals</p>\r\n\r\n<h2>ðŸ¥ <strong>Sectors Where Our Students Get Placed:</strong></h2>\r\n\r\n<ul>\r\n	<li>\r\n	<p><strong>Healthcare &amp; Paramedical:</strong> Nursing Homes, Clinics, Rural Health Services, Diagnostic Labs</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Pharma &amp; CMS:</strong> Community Healthcare, Private Practice, Medical Service Centers</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Hospitality &amp; Hotel Management:</strong> Hotels, Resorts, Food &amp; Beverage Industry, Customer Service Roles</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Education &amp; Training:</strong> Tutoring, Spoken English Training, Support Roles in Academics</p>\r\n	</li>\r\n</ul>\r\n\r\n<hr />\r\n<h2>ðŸŒ <strong>Our Commitment</strong></h2>\r\n\r\n<p>We are proud to have guided hundreds of students towards a <strong>successful career path</strong>. Whether it&rsquo;s preparing for higher education, competitive exams, or skill-based jobs, <strong>DCA ensures that no student is left behind.</strong></p>\r\n\r\n<p>At DCA, <strong>your success is our mission.</strong><br />\r\n✨ Together, we prepare not just for jobs&mdash;but for a brighter future.</p>\r\n', '', '', '', 'master_admin', '7 May, 2024, 6:12 pm', '2 September, 2025, 1:48 pm', 0, 0, 1),
(63, '', 'faculty', 'Indrani Sasmal ', 'Nursing ', '../upload/faculty/1718014161.jpeg', 'Nursing Faculty ', '', '', '', '', 'Jun 10, 2024 3:39 pm', '', 0, 0, 0),
(64, '', 'faculty', 'Kana Rana ', 'Nursing ', '', 'Nursing Faculty ', '', '', '', '', 'Jun 10, 2024 3:40 pm', '', 0, 0, 0),
(65, '', 'faculty', 'Afsana Khatun ', 'Nursing ', '', 'Nursing Faculty ', '', '', '', '', 'Jun 10, 2024 3:45 pm', '', 0, 0, 0),
(79, 'about4011620250829163356', 'single_page', 'CHAIRMAN’S SPEAKS', 'It is my honor and privilege to welcome you to Disha Career Academy, a place where dreams are nurtured and transformed into reality. From the very beginning, our vision has been clear – to provide quality education, career-focused training, and skill development so that every student can find the right direction in life.', '443065.', '<p>Dear Students, Parents, and Well-Wishers,</p>\r\n\r\n<p>It gives me immense pleasure to welcome you to <strong>Disha Career Academy</strong> &ndash; an institution built with the vision of empowering young minds through education, skill development, and career guidance.</p>\r\n\r\n<p>At DCA, we believe that education is not limited to classrooms and textbooks; it is about <strong>shaping personalities, instilling confidence, and preparing students for the challenges of life.</strong> Our mission is to ensure that every learner receives quality teaching, modern resources, and the right direction to achieve success in academics as well as in their career.</p>\r\n\r\n<p>Over the years, Disha Career Academy has grown into a trusted name for competitive exam coaching, paramedical and nursing courses, hotel management, and spoken English training. The trust of parents and the achievements of our students inspire us to strive harder each day.</p>\r\n\r\n<p>As Chairman, my constant goal is to see every student walk out of this academy with <strong>knowledge in their mind, skills in their hand, and confidence in their heart.</strong></p>\r\n\r\n<p>I invite you to be a part of this journey and allow us to guide you towards a brighter, successful future.</p>\r\n\r\n<p>With Best Wishes,<br />\r\n<strong>Mr. Sahabul Houque</strong><br />\r\nChairman, Disha Career Academy</p>\r\n', '', '', '', 'master_admin', '29 August, 2025, 4:33 pm', '2 September, 2025, 2:16 pm', 0, 0, 1),
(80, 'about8779620250829163412', 'single_page', 'DIRECTOR’S SPEAKS', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', '613206.', '', '', '', '', 'master_admin', '29 August, 2025, 4:34 pm', '', 0, 0, 1),
(81, 'about1073220250829163516', 'single_page', 'PRINCIPAL’S SPEAKS', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industrys standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.', '85922.', '', '', '', '', 'master_admin', '29 August, 2025, 4:35 pm', '', 0, 0, 1),
(83, '', 'video gallery', 'DISHA', 'https://www.youtube.com/embed/ry_Dquo6gUw?si=ZzMC5NdPOd6VkNg_', '', '', '', '', '', '', 'Sep 1, 2025 1:01 pm', '', 0, 0, 1),
(84, '', 'video gallery', 'DISHA', 'https://www.youtube.com/embed/ayefSTAnCR8?si=CRddpLwv_3gkzG6m', '', '', '', '', '', '', 'Sep 1, 2025 1:01 pm', '', 0, 0, 1),
(7, 'about2562520240417142002', 'single_page', 'ABOUT', 'WELCOME TO Disha Career Academy\r\n', '535197.jpg', '<p><strong>Disha Career Academy</strong> is dedicated to empowering students with career-focused education and skills. From competitive exam coaching to professional courses like Nursing, Hotel Management, CMS &amp; EDT, and Spoken English, we provide quality training with experienced faculty, modern facilities, and personalized guidance.</p>\r\n\r\n<p>ðŸ“ Based in Berhampore, we help students achieve their academic goals and build a successful career with confidence.</p>\r\n', '', '', '<h2>ðŸ« <strong>About Disha Career Academy</strong></h2>\r\n\r\n<p><strong>Disha Career Academy (DCA)</strong>, established in Berhampore, Murshidabad, is a trusted name in career-oriented education and skill development. With a vision to empower students through <strong>quality teaching, modern learning techniques, and professional training</strong>, DCA has been guiding young minds to achieve their academic dreams and career goals.</p>\r\n\r\n<p>At DCA, we believe that education is not only about textbooks and classrooms but also about developing confidence, discipline, and practical skills. Our academy offers a wide range of programs including:</p>\r\n\r\n<ul>\r\n	<li>\r\n	<p><strong>Competitive Exam Coaching</strong> &ndash; NEET-UG, JENPAS-UG, and other healthcare entrance exams</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Professional &amp; Skill Development Courses</strong> &ndash; GNM Nursing, CMS &amp; EDT, Hotel Management, Paramedical Programs</p>\r\n	</li>\r\n	<li>\r\n	<p><strong>Language &amp; Soft Skill Training</strong> &ndash; Spoken English and Personality Development</p>\r\n	</li>\r\n</ul>\r\n\r\n<p>With a team of experienced faculty, well-structured study materials, regular mock tests, and a student-friendly learning environment, DCA ensures that every learner gets <strong>personalized attention</strong> and the right academic guidance.</p>\r\n\r\n<p>Our <strong>infrastructure</strong> is equipped with modern classrooms, digital learning support, and interactive teaching methods, making the learning experience more effective.</p>\r\n\r\n<p>Over the years, <strong>Disha Career Academy</strong> has built a strong reputation for <strong>academic excellence, career-focused education, and value-based training.</strong> We take pride in our students&rsquo; success, many of whom have secured seats in reputed institutions and built promising careers in diverse fields.</p>\r\n\r\n<p>At the core of our mission lies the belief:<br />\r\n<strong>&ldquo;Education is empowerment &ndash; and every student deserves the right direction for success.&rdquo;</strong></p>\r\n\r\n<p>With this spirit, <strong>DCA continues to inspire, guide, and transform lives</strong> by preparing students for not only exams but for the challenges of life and career ahead.</p>\r\n', 'master_admin', '17 April, 2024, 2:20 pm', '2 September, 2025, 1:37 pm', 2, 0, 1),
(8, 'BLOG1568620240417155911', 'blog', ' Unlocking Opportunities: A Guide to Disha Institute Admissions', 'In the bustling landscape of education, finding the right institution can be akin to discovering a treasure trove of opportunities. Disha Institute stands tall as an emblem of excellence, offering a transformative journey for aspiring learners. In this blog, we delve into the intricacies of MRGS Institute admissions, unlocking the doors to a world of knowledge, innovation, and growth.', '../upload/blog/1582870005.jpg', '<p><strong>Discovering Disha&nbsp;&nbsp;Institute:</strong> Disha&nbsp;Institute, a beacon of academic brilliance, is renowned for its commitment to holistic education. Nestled in a serene campus adorned with state-of-the-art facilities, the institute fosters an environment conducive to intellectual exploration and personal development.</p>\r\n\r\n<p>&nbsp;</p>\r\n', '', 'MRGS', '', 'master_admin', '17 April, 2024, 3:59 pm', '23 December, 2024, 2:23 pm', 180, 0, 0),
(78, 'BLOG2381420250211134806', 'blog', 'NEET-UG 2025 : INDIAN\'S ONLY MEDICAL ENTRANCE EXAM', '', '../upload/blog/116919130.jpg', '<p>The National Eligibility Cum Entrance Test (Undergraduate) or NEET-UG, Formerly the All-India Pre-Medical Test (AIPMT), is an All-India Pre-Medical Entrance Test for Students Who Wish to Pursue Undergraduate Medical (MBBS), Dental (BDS) &amp; AYUSH (BAMS, BUMS, BHMS, Etc.) Courses in Government &amp; Private Institutions in India. The Exam is Conducted Once in a Year by National Testing Agency (NTA).</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<h3><strong>ELIGIBILITY OF NEET-UG 2025</strong></h3>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<table border=\"1\" cellspacing=\"0\" style=\"width:750px\">\r\n	<tbody>\r\n		<tr>\r\n			<td style=\"width:120.25pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CRITERIA</strong></p>\r\n			</td>\r\n			<td style=\"width:402.55pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DETAILS</strong></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"width:120.25pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; AGE LIMIT</strong></p>\r\n\r\n			<p>&nbsp;</p>\r\n			</td>\r\n			<td style=\"width:402.55pt\">\r\n			<ul>\r\n				<li>Candidates must be at least 17 years old by December 31, 2025.</li>\r\n				<li>No upper age limit as per the Hon&#39;ble Supreme Court&rsquo;s order.</li>\r\n			</ul>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"width:120.25pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp;QUALIFICATION</strong></p>\r\n			</td>\r\n			<td style=\"width:402.55pt\">\r\n			<ul>\r\n				<li>Must have passed 10+2 or equivalent</li>\r\n				<li>with Physics, Chemistry, Biology / Biotechnology, and English individually.</li>\r\n			</ul>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"width:120.25pt\">\r\n			<p><strong>&nbsp; &nbsp; MINIMUM MARKS</strong></p>\r\n			</td>\r\n			<td style=\"width:402.55pt\">\r\n			<ul>\r\n				<li>General &ndash; 50% ; General PH &ndash; 45% ; OBC/SC/ST &ndash; 40% ;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; OBC-PH/SC-PH/ST-PH &ndash; 40%</li>\r\n				<li>Aggregate Marks in Physics, Chemistry, Biology &amp; Passing Marks in English Subject</li>\r\n			</ul>\r\n\r\n			<p>&nbsp;</p>\r\n\r\n			<ul>\r\n				<li><strong><em>N.B :</em></strong><em> Marks obtained in Mathematics are not to be considered for eligibility for admission to Undergraduate Medical Courses</em></li>\r\n			</ul>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<h3><strong>EXAM PATTERN OF NEET-UG</strong></h3>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<table border=\"1\" cellspacing=\"0\" style=\"width:750px\">\r\n	<tbody>\r\n		<tr>\r\n			<td style=\"width:127.35pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CONTENT(S)</strong></p>\r\n			</td>\r\n			<td style=\"width:395.45pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DESCRIPTION</strong></p>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"width:127.35pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MODE OF</strong></p>\r\n\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; EXAMINATION</strong></p>\r\n			</td>\r\n			<td style=\"width:395.45pt\">\r\n			<ul>\r\n				<li>Offline Pen-Paper OMR-Based Examination</li>\r\n			</ul>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"width:127.35pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NUMBER OF</strong></p>\r\n\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;QUESTIONS</strong></p>\r\n			</td>\r\n			<td style=\"width:395.45pt\">\r\n			<ul>\r\n				<li>180 Qs. will have to be Answered</li>\r\n			</ul>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"width:127.35pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;NUMBER OF</strong></p>\r\n\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp; SUBJECTS</strong></p>\r\n			</td>\r\n			<td style=\"width:395.45pt\">\r\n			<ul>\r\n				<li>Four Subjects &mdash; Physics, Chemistry, Botany, &amp; Zoology</li>\r\n			</ul>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"width:127.35pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp;MARKING SCHEME</strong></p>\r\n			</td>\r\n			<td style=\"width:395.45pt\">\r\n			<ul>\r\n				<li>+4 Marks for Each Correct Answer</li>\r\n				<li>-1 for Each Incorrect Answer</li>\r\n			</ul>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"width:127.35pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp;DURATION OF EXAM</strong></p>\r\n			</td>\r\n			<td style=\"width:395.45pt\">\r\n			<ul>\r\n				<li>3 Hours (180 Minutes)</li>\r\n			</ul>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"width:127.35pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp;TOTAL QUESTIONS</strong></p>\r\n\r\n			<p><strong>&nbsp; &nbsp; &nbsp;TO BE ATTEMPTED</strong></p>\r\n			</td>\r\n			<td style=\"width:395.45pt\">\r\n			<ul>\r\n				<li>180 Questions</li>\r\n			</ul>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"width:127.35pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp; &nbsp;TOTAL MARKS</strong></p>\r\n			</td>\r\n			<td style=\"width:395.45pt\">\r\n			<ul>\r\n				<li>720</li>\r\n			</ul>\r\n			</td>\r\n		</tr>\r\n		<tr>\r\n			<td style=\"width:127.35pt\">\r\n			<p><strong>&nbsp; &nbsp; &nbsp; QUESTION TYPE</strong></p>\r\n			</td>\r\n			<td style=\"width:395.45pt\">\r\n			<ul>\r\n				<li>MCQs (Multiple Choice Questions)</li>\r\n			</ul>\r\n\r\n			<ul>\r\n				<li>&ldquo;Only One Option will be Correct&rdquo;</li>\r\n			</ul>\r\n			</td>\r\n		</tr>\r\n	</tbody>\r\n</table>\r\n', 'Education', 'NEET-UG 2025', '<p><strong>Author</strong></p>\r\n\r\n<p>Mr. Debojyoti Ghosh,&nbsp;Project Director</p>\r\n', 'master_admin', '11 February, 2025, 1:48 pm', '11 February, 2025, 2:04 pm', 587, 0, 1),
(9, 'NEWS4497920240417161951', 'news', 'Embark on Your Engineering Journey: Admission News from Camellia School of Engineering & Technology (CSET)', 'Camellia School of Engineering & Technology (CSET) invites aspiring engineers and technologists to embark on a transformative educational journey. With a legacy of academic excellence, state-of-the-art infrastructure, and a commitment to nurturing future-ready professionals, CSET opens its doors to passionate individuals eager to shape the future of technology and innovation.', '../upload/news/1849355140.jpg', '<p><strong>Admission Announcement:</strong></p>\r\n\r\n<p>Applications are now open for admission to various undergraduate and postgraduate programs at CSET for the upcoming academic year. Whether you aspire to pursue a Bachelor&#39;s degree in Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, or wish to specialize further with a Master&#39;s degree, CSET offers a diverse range of programs to suit your interests and career goals.</p>\r\n\r\n<p><strong>Key Highlights:</strong></p>\r\n\r\n<ul>\r\n	<li><strong>World-Class Faculty:</strong> Learn from distinguished faculty members who are experts in their respective fields, dedicated to imparting knowledge, fostering critical thinking, and mentoring students towards academic and professional excellence.</li>\r\n	<li><strong>Cutting-Edge Infrastructure:</strong> Experience learning in a conducive environment equipped with modern laboratories, smart classrooms, libraries stocked with a vast repository of books and journals, and recreational facilities to support your overall development.</li>\r\n	<li><strong>Industry Exposure:</strong> Gain invaluable real-world experience through industry collaborations, internships, industrial visits, and guest lectures by industry stalwarts, ensuring that you are well-prepared to meet the demands of the ever-evolving industry landscape.</li>\r\n	<li><strong>Research Opportunities:</strong> Engage in cutting-edge research across various domains, contribute to innovation, and make a meaningful impact on society with access to state-of-the-art research facilities, research grants, and collaboration opportunities.</li>\r\n	<li><strong>Student Support Services:</strong> Receive personalized academic counseling, career guidance, mentorship, and support services to ensure your holistic development, well-being, and success throughout your academic journey.</li>\r\n</ul>\r\n', '', 'admission, camellia, engineering', '<p><strong>Admission Criteria:</strong></p>\r\n\r\n<ul>\r\n	<li>For undergraduate programs, candidates must have completed their higher secondary education (10+2) with a strong academic record in relevant subjects.</li>\r\n	<li>For postgraduate programs, candidates must hold a Bachelor&#39;s degree in the relevant field with satisfactory academic performance.</li>\r\n	<li>Admission criteria may vary depending on the program and are subject to the rules and regulations set by the university and regulatory authorities.</li>\r\n</ul>\r\n\r\n<p><strong>How to Apply:</strong> Interested candidates can apply online through the official website of CSET or visit the campus to collect application forms and brochure. The application process includes submission of relevant documents, academic transcripts, and payment of application fees as per the instructions provided.</p>\r\n\r\n<p><strong>Important Dates:</strong></p>\r\n\r\n<ul>\r\n	<li>Application Start Date: [Insert Start Date]</li>\r\n	<li>Application Deadline: [Insert Deadline Date]</li>\r\n	<li>Entrance Examination Date (if applicable): [Insert Date]</li>\r\n	<li>Announcement of Results: [Insert Date]</li>\r\n</ul>\r\n\r\n<p><strong>Conclusion:</strong> Seize the opportunity to join a vibrant academic community dedicated to excellence, innovation, and holistic development. Apply to Camellia School of Engineering &amp; Technology (CSET) and embark on a journey of discovery, growth, and success. For more information, visit our website, contact our admissions office, or schedule a campus visit to experience the essence of CSET firsthand. Your future begins here!</p>\r\n', 'master_admin', '17 April, 2024, 4:19 pm', '', 5, 0, 1),
(11, '', 'approval', 'EOA Report 2020-2021', '', '../upload/approvals/1713600586.pdf', '', '', '', '', '', 'Apr 20, 2024 1:39 pm', '', 0, 0, 1),
(12, '', 'approval', 'EOA Report 2021-22', '', '../upload/approvals/1713600629.pdf', '', '', '', '', '', 'Apr 20, 2024 1:40 pm', '', 0, 0, 1),
(13, '', 'mandatory disclosures', 'Mandatory Disclosures', '', '../upload/md/1713603561.pdf', '', '', '', '', '', 'Apr 20, 2024 2:29 pm', '', 0, 0, 1),
(14, '', 'our group', 'MCRS NURSING INSTITUTE', '', '../upload/group/1719208622.png', '<h1><strong><em>Under Construction&nbsp;</em></strong></h1>\r\n', '', '', 'http://kallol.digix.in/kallol/mcrs/', '', 'Apr 20, 2024 5:46 pm', '', 0, 0, 1),
(15, '', 'our group', 'MEDITECH NURSING INSTITUTE', '', '../upload/group/1715199692.jpeg', '', '', '', 'https://meditechnursinginstitute.com/', '', 'Apr 20, 2024 5:50 pm', '', 0, 0, 1),
(49, '', 'gallery catagory', 'DISHA', '', '', '', '', '', '', '', '8 May, 2024, 1:47 pm', '', 0, 0, 1),
(25, '', 'mission vision', 'VISION', 'At Disha Career Academy, our vision is to become a leading institution in shaping the future of young minds through quality education, scientific parenting guidance, and value-based learning.\r\n\r\nWe aim to:\r\n\r\n🌱 Create a nurturing environment where every child can discover their true potential.\r\n\r\n📖 Inspire lifelong learning and curiosity beyond the classroom.\r\n\r\nðŸ« Build a strong foundation for students to succeed in higher education, careers, and life.\r\n\r\nðŸŒ Contribute to society by developing responsible, confident, and compassionate individuals.\r\n\r\nOur vision is to see every student grow as a capable, ethical, and future-ready citizen.', '../upload/mv/1713770660.png', '', '', '', '', '', 'Apr 22, 2024 12:49 pm', '', 0, 0, 1),
(26, '', 'mission vision', 'MISSION', 'At Disha Career Academy, our mission is to empower students with the knowledge, skills, and values needed to excel in education and life. We are committed to:\r\n\r\n📚 Delivering quality education with innovative and student-friendly teaching methods.\r\n\r\n🧠 Guiding parents with scientific parenting support to nurture holistic development.\r\n\r\n🎯 Preparing students not just for exams, but for a successful future and responsible citizenship.\r\n\r\nðŸ† Creating a disciplined, caring, and inspiring environment that encourages curiosity, confidence, and character building.\r\n\r\nWe believe that true education is not only about academic success but also about shaping personalities, instilling values, and building leaders of tomorrow.', '../upload/mv/1713770693.png', '', '', '', '', '', 'Apr 22, 2024 12:50 pm', '', 0, 0, 1),
(27, '', 'infrastructure-campus-life', 'Infrastructure for Excellence', 'Camellia lnstitutes are built on the belief that the learning environment must be wholly supportive or academic aspirations by ensuring that the best infrastructure and ambience. Each canpus is superbly laid out to provide an idyllic setting. Sports and culture is encouraged. The academic infrastructure 15 in true with the needs of modern needs.', '../upload/infra/1713778175.png', '', '', '', '', '', 'Apr 22, 2024 2:59 pm', '', 0, 0, 1),
(28, '', 'infrastructure-campus-life', 'Library & Book Bank', 'An institute is a storehouse of knowledge. Enthusiastic students require a massive collection of books to quench their thirst for knowledge. The central library houses over 23,000 Books about 250 journals of national and international repute, 82 magazines of relevance to engineering and management fields, major dailies, newsletters and a number of electronic on-ine-academic publications. The library has software based networking system and will soon have the multimedia support to further facilitate the learning experience.\r\n\r\nAll colleges have also established a separate Book Bank which has a collection of nearly 15,000 books. All colleges also subscribe to journals such as IEEE Computer, IETE Journal of Research, IEE Technical Review, Asia Pacific, Business Decision (IIM Kolkata), Journal of Information Science and knowledge of Education.', '../upload/infra/1713778322.png', '', '', '', '', '', 'Apr 22, 2024 3:02 pm', '', 0, 0, 1),
(32, '', 'admission', 'DIPLOMA ', 'JEXPO ', '', '35% at the Madhyamik or its equivalent examination & JEXPO ', '', '', '', '', 'Apr 22, 2024 5:59 pm', '', 0, 0, 1),
(33, '', 'admission', 'DIPLOMA', 'JEXPO', '', '45% marks in both Physical Science & Mathematics at the Madhyamik or its equivalent examination & Without JEXPO', '', '', '', '', 'Apr 22, 2024 6:02 pm', '', 0, 0, 1),
(34, '', 'admission', 'B.TECH(1st Year)(ALL STREAM)', 'WB-JEE/JEE-Main', '', 'HS or equivalent (Physics, Mathematics & Chemistry/Biotechnology/Biology) Minimum of 45% marks (40% for SC / ST / PWD / OBC candidate)', '', '', '', '', 'Apr 22, 2024 6:02 pm', '', 0, 0, 1),
(35, '', 'admission', 'B.TECH(Lateral)(ALL STREAM)', 'JELET', '', 'Diploma Candidates with JELET-2015 any rank [ Candidate having all semester cleared mark sheet ]', '', '', '', '', 'Apr 22, 2024 6:03 pm', '', 0, 0, 1),
(36, '', 'admission', 'B.TECH(Lateral)(ALL STREAM)', 'JELET', '', 'Diploma Candidates without JELET-2015 rank can take admission [Candidate having all semester cleared mark sheet or if last semester mark sheet is pending then the candidate can take provisional admission]', '', '', '', '', 'Apr 22, 2024 6:03 pm', '', 0, 0, 1),
(37, '', 'admission', 'B.TECH(Lateral)(ALL STREAM)', 'JELET', '', 'B.Sc Degree Candidates With Mathematics At 10+2 Level & 60% Marks (50% Marks For Candidates Belonging To Reserved Categories) in the Qualifying Examination can take admission in Lateral entry(any stream)', '', '', '', '', 'Apr 22, 2024 6:04 pm', '', 0, 0, 1),
(38, '', 'admission', 'M.TECH in Civil (GEO-TECHNICAL)', 'GATE/PGET(Conducted by WBUT)', '', 'Candidate with B.TECH / B.E / AMIE, degree holders in B.E / B.TECH in CEVIL engineering or equivalent with 60% marks can apply', '', '', '', '', 'Apr 22, 2024 6:04 pm', '', 0, 0, 1),
(39, '', 'admission process', '', '', '../upload/notice/360_F_443709361_sJzfVArJOVIf6q3pkzU1S1lwvbInE1Id.jpg', '<h3><strong>Step 1: Enquiry &amp; Counseling</strong></h3>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Visit our campus or contact us through phone/WhatsApp.</p>\r\n	</li>\r\n	<li>\r\n	<p>Get detailed course information and career guidance from our academic counselors.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h3><strong>Step 2: Application Form</strong></h3>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Collect the admission form from our office or download it from the website.</p>\r\n	</li>\r\n	<li>\r\n	<p>Fill in all required details carefully.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h3><strong>Step 3: Document Submission</strong></h3>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Submit the completed form along with the following documents:</p>\r\n\r\n	<ul>\r\n		<li>\r\n		<p>Recent passport-size photographs</p>\r\n		</li>\r\n		<li>\r\n		<p>Secondary &amp; Higher Secondary Mark sheets (X &amp; XII)</p>\r\n		</li>\r\n		<li>\r\n		<p>ID Proof (Aadhar Card / Voter ID / Passport)</p>\r\n		</li>\r\n		<li>\r\n		<p>Address Proof</p>\r\n		</li>\r\n		<li>\r\n		<p>Any other required certificates</p>\r\n		</li>\r\n	</ul>\r\n	</li>\r\n</ul>\r\n\r\n<h3><strong>Step 4: Admission Confirmation</strong></h3>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Pay the admission fee to confirm your seat.</p>\r\n	</li>\r\n	<li>\r\n	<p>Receive your official Admission Receipt &amp; Student ID.</p>\r\n	</li>\r\n</ul>\r\n\r\n<h3><strong>Step 5: Orientation &amp; Class Commencement</strong></h3>\r\n\r\n<ul>\r\n	<li>\r\n	<p>Attend the orientation program.</p>\r\n	</li>\r\n	<li>\r\n	<p>Get your study materials and class schedule.</p>\r\n	</li>\r\n	<li>\r\n	<p>Begin your academic journey with <strong>Disha Career Academy</strong>.</p>\r\n	</li>\r\n</ul>\r\n', '', '', '<p>The admission process at <strong>Disha Career Academy</strong> is designed to be <strong>simple, transparent, and student-friendly</strong>. From the moment a student makes an enquiry, our dedicated counselors provide proper guidance about courses, eligibility, and career opportunities. After filling out the application form, students need to submit the required academic and identification documents for verification. Once the admission fee is paid, the seat is officially confirmed. Finally, students receive their orientation, study materials, and class schedule &mdash; marking the beginning of their academic journey with Disha Career Academy.</p>\r\n', '', '', '', 0, 0, 1),
(75, '', 'training-placement-partner', 'ok', '', '../upload/tpp/1734936432.png', '', '', '', '', '', 'Dec 23, 2024 12:17 pm', '', 0, 0, 1),
(76, '', 'training', 'dx', 'dxs', '../upload/training/1734936643.jpg', '<p>rr</p>\r\n', '', '', '<p>rr</p>\r\n', '', 'Dec 23, 2024 12:20 pm', '', 0, 0, 1),
(41, '', 'placement record', 'Student Edit', 'Test Edit', '../upload/placement-record/1713871868.png', '', '', '', '', '', 'Apr 23, 2024 5:00 pm', '', 0, 0, 1),
(57, '', 'facility', 'Projects', 'Project Description', '../upload/facility/1715675692.jpg', '', '', '', '', '', 'May 14, 2024 2:04 pm', '', 0, 7, 1),
(60, '', 'facility', 'Libraries', '', '', '', '', '', '', '', 'May 14, 2024 2:57 pm', '', 0, 4, 1),
(85, '', 'faculty', 'SMRITI MANDAL', 'Academic  Counsellor', '../upload/faculty/1756801373.png', 'Academic  Counsellor', '', '', 'Smriti Mandal is a dedicated Academic Counsellor at Disha Career Academy, guiding students in choosing the right career paths and academic opportunities. With excellent communication and mentoring skills, she helps students set clear goals, stay motivated, and achieve success through proper planning and support.', '', 'Sep 2, 2025 1:52 pm', '', 0, 0, 1),
(86, '', 'faculty', 'SAMIM HOSSAIN', 'HOSTEL IN CHARGE', '../upload/faculty/1756801714.png', 'HOSTEL IN CHARGE', '', '', '', '', 'Sep 2, 2025 1:58 pm', '', 0, 0, 1),
(87, '', 'faculty', 'ALLARAKHHA  SK', 'TREASURER', '../upload/faculty/1756801837.png', 'TREASURER', '', '', '', '', 'Sep 2, 2025 2:00 pm', '', 0, 0, 1),
(88, '', 'faculty', 'NASIBUR  RAHAMAN', 'Head of The Department', '../upload/faculty/1756802197.jpg', 'Head of The Department', '', '', '', '', 'Sep 2, 2025 2:06 pm', '', 0, 0, 1),
(90, 'about2546020251105132203', 'single_page', '', 'sdvsdv', '55539.php', '<p>sdvsdv</p>\r\n', 'dsvsdv', 'dsv', '<p>dsvsdv</p>\r\n', 'master_admin', '5 November, 2025, 1:22 pm', '5 November, 2025, 1:23 pm', 0, 0, 1);

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

--
-- Table structure for table `department`
--

CREATE TABLE `department` (
  `dept_id` int(11) NOT NULL,
  `dept_name` varchar(300) NOT NULL,
  `dept_img` varchar(300) NOT NULL,
  `dept_creatdate` varchar(300) NOT NULL,
  `dept_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `department`
--

INSERT INTO `department` (`dept_id`, `dept_name`, `dept_img`, `dept_creatdate`, `dept_recycle`) VALUES
(1, 'Nursing Courses', '63411.svg', '4 May, 2024, 8:20 pm', 1),
(2, 'Competitive Exam Prep', '710916.svg', '4 May, 2024, 8:21 pm', 1),
(3, 'Entrance Exam Prep', '190125.svg', '2 September, 2025, 2:36 pm', 1),
(4, 'Management Courses', '515076.svg', '3 September, 2025, 10:58 am', 1),
(5, 'Pharmacy Courses', '13610.svg', '3 September, 2025, 11:00 am', 1),
(6, 'Professional Skill Courses', '166281.svg', '3 September, 2025, 11:32 am', 1);

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

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `faq_sl_no` int(11) NOT NULL,
  `faq_id` varchar(255) NOT NULL,
  `faq_catagory` varchar(255) NOT NULL,
  `faq_get_id` varchar(255) NOT NULL,
  `faq_q` varchar(255) NOT NULL,
  `faq_ans` longtext NOT NULL,
  `faq_up_by` varchar(255) NOT NULL,
  `faq_upload_date` varchar(255) NOT NULL,
  `faq_edit_date` varchar(255) NOT NULL,
  `faq_recycle` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `notice`
--

CREATE TABLE `notice` (
  `notice_id` int(11) NOT NULL,
  `notice_name` varchar(300) NOT NULL,
  `notice_pdf` varchar(300) NOT NULL,
  `notice_short_des` longtext NOT NULL,
  `notice_creatdate` varchar(300) NOT NULL,
  `notice_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notice`
--

INSERT INTO `notice` (`notice_id`, `notice_name`, `notice_pdf`, `notice_short_des`, `notice_creatdate`, `notice_recycle`) VALUES
(2, 'Internal Exam Notice', '../upload/notice/1714833917.pdf', 'We are excited to announce the upcoming internal examination at MRGS. This examination is a crucial component of your academic journey, designed to assess your understanding and mastery of the course material covered during this semester. Please carefully read the following details regarding the examination.', 'Apr 22, 2024 1:55 pm', 1),
(3, 'svdvsdv', '../upload/notice/1762328812.pdf', 'sdvsdv', 'Nov 5, 2025 1:16 pm', 0),
(4, 'sacasc', '../upload/notice/1762328899.pdf', 'ascasc', 'Nov 5, 2025 1:17 pm', 0);

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

--
-- Table structure for table `online_admission`
--

CREATE TABLE `online_admission` (
  `oa_id` int(11) NOT NULL,
  `oa_clg` varchar(255) DEFAULT NULL,
  `oa_dept` varchar(255) DEFAULT NULL,
  `oa_course` varchar(255) DEFAULT NULL,
  `oa_session` varchar(100) NOT NULL,
  `oa_name` varchar(255) DEFAULT NULL,
  `oa_g_name` varchar(255) DEFAULT NULL,
  `oa_mom_name` varchar(255) DEFAULT NULL,
  `oa_email` varchar(255) DEFAULT NULL,
  `oa_phone` varchar(10) DEFAULT NULL,
  `oa_g_phone` varchar(20) NOT NULL,
  `oa_dob` varchar(300) DEFAULT NULL,
  `oa_gender` varchar(10) DEFAULT NULL,
  `oa_birth_nation` varchar(100) NOT NULL,
  `oa_birth_domicile` varchar(100) NOT NULL,
  `oa_aadhar` varchar(100) NOT NULL,
  `oa_marital` varchar(100) NOT NULL,
  `oa_caste` varchar(100) NOT NULL,
  `oa_mp_institute` varchar(255) DEFAULT NULL,
  `oa_mp_marks` varchar(10) DEFAULT NULL,
  `oa_mp_uni` varchar(255) DEFAULT NULL,
  `oa_mp_year` varchar(10) DEFAULT NULL,
  `oa_hs_institute` varchar(255) DEFAULT NULL,
  `oa_hs_marks` varchar(10) DEFAULT NULL,
  `oa_hs_uni` varchar(255) DEFAULT NULL,
  `oa_hs_year` varchar(10) DEFAULT NULL,
  `oa_entrance_name` varchar(300) NOT NULL,
  `oa_entrance_rank` varchar(30) NOT NULL,
  `oa_address` varchar(255) DEFAULT NULL,
  `oa_address2` varchar(255) DEFAULT NULL,
  `oa_state` varchar(255) DEFAULT NULL,
  `oa_dist` varchar(255) DEFAULT NULL,
  `oa_city` varchar(255) DEFAULT NULL,
  `oa_zip` varchar(10) DEFAULT NULL,
  `oa_creatdate` varchar(300) DEFAULT NULL,
  `oa_action` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `online_admission`
--

INSERT INTO `online_admission` (`oa_id`, `oa_clg`, `oa_dept`, `oa_course`, `oa_session`, `oa_name`, `oa_g_name`, `oa_mom_name`, `oa_email`, `oa_phone`, `oa_g_phone`, `oa_dob`, `oa_gender`, `oa_birth_nation`, `oa_birth_domicile`, `oa_aadhar`, `oa_marital`, `oa_caste`, `oa_mp_institute`, `oa_mp_marks`, `oa_mp_uni`, `oa_mp_year`, `oa_hs_institute`, `oa_hs_marks`, `oa_hs_uni`, `oa_hs_year`, `oa_entrance_name`, `oa_entrance_rank`, `oa_address`, `oa_address2`, `oa_state`, `oa_dist`, `oa_city`, `oa_zip`, `oa_creatdate`, `oa_action`) VALUES
(1, 'MCRS COLLEGE OF HEALTH SCIENCES', 'PARAMEDICAL ', 'Bachelor of Medical Laboratory Technology', '', 'Raju Chhetri', 'b', 'b', 'MCRS@gmail.com', '9477015715', '', '2012-12-24', 'Male', '', '', '', '', '', 'kkha', '82', 'wbbse', '2000', 'kkha', '62', 'wbhsce', '2002', 'wbjee', '555', 'Nadibhag Mollapara 1 No Sarani, Digberia, Badu Road', '', 'West Bengal', 'n24pgs', 'Kolkata', '700128', 'Jun 24, 2024 12:03 pm', '1'),
(2, 'MEDITECH NURSING INSTITUTE', 'NURSING ', 'GNM ', '', 'SAYANTIKA NASKAR', 'AVIJIT NASKAR', 'SONALI NASKAR', 'naskarsayantika68@gmail.com', '9123968710', '', '2004-03-03', 'Female', '', '', '', '', '', 'SIR N.N.GIRLS HIGH SCHOOL', '63.2', 'WBBSE', '2019', 'SIR N.N.GIRLS HIGH SCHOOL', '75.6', 'WBCHSE', '2001', 'N/A', 'N/A', '2/2 SODUEPUR SECOND LANE KOLKATA', '', 'WEST BENGAL', 'KOLKATA', '', '700084', 'Jul 10, 2024 2:39 pm', '1'),
(3, 'MEDITECH NURSING INSTITUTE', 'NURSING ', 'GNM ', '', 'DIPTI DEY', 'KRISHNA PADA DEY', 'NIBEDITA DEY', 'deyd21499@gmail.com', '9339466058', '', '2006-05-21', 'Female', '', '', '', '', '', 'BHARATI BALIKA VIDYALAYA', '63.71', 'WBBSE', '2022', 'BHARATI BALIKA VIDYALAYA', '86.2', 'WBCHSE', '2024', 'N/A', 'N/A', 'DHOKRASAHID, NUTANGANJ', '', 'WEST BENGAL', 'PURBA BARDHAMAN', '', '713102', 'Jul 10, 2024 2:45 pm', '1'),
(4, 'MEDITECH NURSING INSTITUTE', 'NURSING ', 'GNM ', '', 'IYESA SULTANA', 'ASRAF ', 'SAMINA BEGUM', 'iyesasultana816@gmail.com', '6294848604', '', '2006-01-28', 'Female', '', '', '', '', '', 'BHARATI BALIKA VIDYALAYA', '67.57', 'WBBSE', '2022', 'BHARATI BALIKA VIDYALAYA', '72.08', 'WBCHSE', '2024', 'N/A', 'N/A', 'KHAGRAGORH ROAD', '', 'WEST BENGAL', 'PURBA BARDHAMAN', '', '713101', 'Jul 10, 2024 2:59 pm', '1'),
(5, 'MEDITECH NURSING INSTITUTE', 'NURSING ', 'GNM ', '', 'SHRUTI DAS', 'SAHADEB DAS', 'RAKHI DAS', 'shrutidas10032006@gmail.com', '8293557218', '', '2006-03-10', 'Female', '', '', '', '', '', 'SAKTIGARH GIRLS HIGH SCHOOL', '68.85', 'WBBSE', '2021', 'SAKTIGARH GIRLS HIGH SCHOOL', '50', 'WBCHSE', '2024', 'N/A', 'N/A', 'SAKTIGARH UTTAR BAZAR,', '', 'WEST BENGAL', 'PURBA BARDHAMAN', '', '713149', 'Jul 10, 2024 3:50 pm', '1'),
(6, 'MEDITECH NURSING INSTITUTE', 'NURSING ', 'GNM ', '', 'RUPALI MAHATO', 'ANIL MAHATO', 'SANKARI MAHATO', 'mahatorupali09@gmail.com', '6297156483', '', '2006-12-31', 'Female', '', '', '', '', '', 'BAIDYADANGA GIRLS HIGH SCHOOL', '51', 'WBBSE', '2022', 'BAIDYADANGA GIRLS HIGH SCHOOL', '73', 'WBCHSE', '2024', 'N/A', 'N/A', 'SAKTIGARH UTTAR BAZAR,', '', 'WEST BENGAL', 'PURBA BARDHAMAN', '', '713149', 'Jul 10, 2024 3:59 pm', '1'),
(7, 'MCRS NURSING INSTITUTE', 'NURSING ', 'GNM ', '2024', 'Digix Test Student', 'Test', 'Test', 't@g.com', '9879879874', '8528528528', '2023-01-04', 'Male', 'Indian', 'Indian', '987498749874', 'Single', 'General', 'NNHS', '74.8', 'WBBSC', '2012', 'NHS', '59.9', 'WBCHSC', '2014', 'WBJEE', '5620', 'Test Address 1', 'Test Address 2', 'West Bengal', 'CoochBehar', 'Nishiganj', '736157', 'Aug 6, 2024 3:57 pm', '1'),
(8, '', 'Competitive Exams', 'GNM ', '2024-2025', 'Mohubul Hoque', 'Sahad  Ali', 'Khateja bibi', 'md@ggd.com', '8513805935', '85445', '2024-12-27', 'Male', 'india', 'indian', '2243t', 'Married', 'OBC', '4', '11', '11', '11', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', 'Dec 23, 2024 3:01 pm', '1');

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `s_id` int(11) NOT NULL,
  `s_position` varchar(300) NOT NULL,
  `s_name` varchar(300) NOT NULL,
  `s_img` varchar(300) NOT NULL,
  `s_about` varchar(300) NOT NULL,
  `s_url` varchar(300) NOT NULL,
  `s_creatdate` varchar(300) NOT NULL,
  `s_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`s_id`, `s_position`, `s_name`, `s_img`, `s_about`, `s_url`, `s_creatdate`, `s_recycle`) VALUES
(6, '', 'Spoken English ', '../upload/slider/1757577576.png', '', '', 'Sep 2, 2025 1:30 pm', 1);

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

--
-- Table structure for table `testimonial`
--

CREATE TABLE `testimonial` (
  `testimoni_id` int(11) NOT NULL,
  `testimoni_name` varchar(300) NOT NULL,
  `testimoni_designation` varchar(300) NOT NULL,
  `testimoni_des` longtext NOT NULL,
  `testimoni_img` varchar(300) NOT NULL,
  `testimoni_creatdate` varchar(300) NOT NULL,
  `testimoni_recycle` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` (`testimoni_id`, `testimoni_name`, `testimoni_designation`, `testimoni_des`, `testimoni_img`, `testimoni_creatdate`, `testimoni_recycle`) VALUES
(1, 'Riya Das', 'GNM Student', '\"Disha Career Academy আমার জনà§য সঠিক পথপà§রদরà§শক হয়েছে। ভরà§তি থেকে শà§রà§ করে পà§রতিটি ধাপে তারা আমাকে সহযোগিতা করেছে। আজ আমি আতà§মবিশà§বাসের সাথে GNM পড়ছি à¦বং জানি আমার কà§যারিয়ার সঠিক হাতে আছে।\"', '../upload/testimonial/1757576089.jpg', 'Apr 14, 2024 1:45 am', 1),
(2, 'Raju Mondal', 'CMS & ED Student', '\"আমি সবসময় চেয়েছিলাম গà§রাম বাংলার মানà§ষের সেবা করতে। CMS & ED কোরà§সের মাধà§যমে à¦খন সেটা সমà§ভব হচà§ছে। Disha Career Academy-র গাইডেনà§স আর সাপোরà§ট আমার সà§বপà§ন পূরণের পথে নিয়ে যাচà§ছে।\"', '../upload/testimonial/1757576173.jpeg', 'Sep 11, 2025 1:06 pm', 1),
(3, 'Mohammad Ali', 'NEET Aspirant', '\"NEET পরীকà§ষার জনà§য আমি Disha Career Academy-তে ভরà§তি হই। à¦খানকার সà§টাডি মেটেরিয়াল, মক টেসà§ট আর পারà§সোনাল মেনà§টরশিপ আমাকে পà§রচà§র আতà§মবিশà§বাস দিয়েছে। আমি নিশà§চিত আমার ভবিষà§যৎ চিকিৎসক হওয়ার সà§বপà§ন à¦খান থেকেই পূরà§ণ হবে।\"', '../upload/testimonial/1757576407.png', 'Sep 11, 2025 1:10 pm', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `achievement`
--
ALTER TABLE `achievement`
  ADD PRIMARY KEY (`achiev_id`);

--
-- Indexes for table `all_tag`
--
ALTER TABLE `all_tag`
  ADD PRIMARY KEY (`all_tag_sl_no`);

--
-- Indexes for table `alumni`
--
ALTER TABLE `alumni`
  ADD PRIMARY KEY (`alu_id`);

--
-- Indexes for table `contact`
--
ALTER TABLE `contact`
  ADD PRIMARY KEY (`con_id`);

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  ADD PRIMARY KEY (`course_id`);

--
-- Indexes for table `data`
--
ALTER TABLE `data`
  ADD PRIMARY KEY (`data_sl_no`);

--
-- Indexes for table `department`
--
ALTER TABLE `department`
  ADD PRIMARY KEY (`dept_id`);

--
-- Indexes for table `faq`
--
ALTER TABLE `faq`
  ADD PRIMARY KEY (`faq_sl_no`);

--
-- Indexes for table `notice`
--
ALTER TABLE `notice`
  ADD PRIMARY KEY (`notice_id`);

--
-- Indexes for table `online_admission`
--
ALTER TABLE `online_admission`
  ADD PRIMARY KEY (`oa_id`);

--
-- Indexes for table `slider`
--
ALTER TABLE `slider`
  ADD PRIMARY KEY (`s_id`);

--
-- Indexes for table `testimonial`
--
ALTER TABLE `testimonial`
  ADD PRIMARY KEY (`testimoni_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

--
-- AUTO_INCREMENT for table `all_tag`
--
ALTER TABLE `all_tag`
  MODIFY `all_tag_sl_no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `alumni`
--
ALTER TABLE `alumni`
  MODIFY `alu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `contact`
--
ALTER TABLE `contact`
  MODIFY `con_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `courses`
--
ALTER TABLE `courses`
  MODIFY `course_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `data`
--
ALTER TABLE `data`
  MODIFY `data_sl_no` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;

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

--
-- AUTO_INCREMENT for table `faq`
--
ALTER TABLE `faq`
  MODIFY `faq_sl_no` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notice`
--
ALTER TABLE `notice`
  MODIFY `notice_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `online_admission`
--
ALTER TABLE `online_admission`
  MODIFY `oa_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

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

--
-- AUTO_INCREMENT for table `testimonial`
--
ALTER TABLE `testimonial`
  MODIFY `testimoni_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
COMMIT;

