????????????????????
??????????????????
ÿØÿà
 JFIF 

  
 
  ÿÛ C      


!"$"$ÿÛ C
    
ÿÂ p 

" 

ÿÄ  

 

  
        
 ÿÄ 


 

           
ÿÚ 

   
ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   
@  

adadasdasdasasdasdas


.....................................................................................................................................????????????????????
??????????????????
ÿØÿà
 JFIF 

  
 
  ÿÛ C      


!"$"$ÿÛ C
    
ÿÂ p 

" 

ÿÄ  

 

  
        
 ÿÄ 


 

           
ÿÚ 

   
ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   
@  

adadasdasdasasdasdas


.....................................................................................................................................<?php
$conn = mysqli_connect("localhost", "root", "", "kttc-admission");

if ($conn === false) {
    die("ERROR: Could not connect. " . mysqli_connect_error());
}

// Retrieve and sanitize inputs
$course = mysqli_real_escape_string($conn, $_POST['course']);
$duration = mysqli_real_escape_string($conn, $_POST['duration']);
$amount = mysqli_real_escape_string($conn, $_POST['amount']);
 
// ✅ Check if course already exists
$check_query = "SELECT * FROM course WHERE course = '$course'";
$check_result = mysqli_query($conn, $check_query);

if (mysqli_num_rows($check_result) > 0) {
    // course already exists, show error and redirect
    echo '<script>alert("Error: This course already exists. Please use a different one."); window.location.href = "add-course.php";</script>';
    exit;
}

// ✅ Now insert course only if course is unique
$insert_sql = "INSERT INTO course (course, duration, amount, status)  
        VALUES ('$course', '$duration', '$amount', 1)";

if (mysqli_query($conn, $insert_sql)) {
    echo '<script>alert("Course Created Successfully."); window.location.href="add-course.php";</script>';
} else {
    echo "ERROR: Unable to execute $insert_sql. " . mysqli_error($conn);
}

mysqli_close($conn);
?>