Writing data from a database to another with a submit function

Question

i know this type of question is too easy for people here but im a beginner in PHP/SQL and so for personal learning reasons i am making a system of override papers for classes that are full in terms of capacity. It works by the student filling the override form, its submitted into an override database with the professor name. When the professor logs in, he sees the override forms requested into his class. After the professor accepts the form, it goes to the head of department for him to accept also. Now, the question is here: How do i make it when the professor clicks "Accept", it would write the same data with one extra row (called comments for comments that the professor has for the head of department) into the heads database and remove it from the current override database so that it isnt there anymore since the professor has accepted the override.

i tried doing it as a form and it works, it submits to the Head's database but whenever i try to add the comments part or any new column into the code, it stops writing to the database. Also, if there are like multiple overrides in the database showing up for the professor, and one is accepted/denied, it would write all of them overrides into the database instead of the one accepted/denied. It would be great to guide me where i did my mistake in the code. Please ignore the style of my code since i am a php beginner and its messy for now.

Here is what i was able to make, this is the whole class code:

    


query("SELECT usertype FROM student WHERE username = '$user'")->fetch_object()->usertype;
$mysqli  = new Mysqli($servername, $username, $password, $dbname) or mysqli_error($mysqli);
$name = $mysqli->query("SELECT name FROM student WHERE username = '$user'")->fetch_object()->name;    
?>
 
            Welcome !
          


    
        Personal Details
        
            First Name    
query("SELECT name FROM student WHERE username = '$user'")->fetch_object()->name;  
print_r($name);
?>
        


        
            Mid. Name    
query("SELECT mname FROM student WHERE username = '$user'")->fetch_object()->mname;  
print_r($mname);
?>
        


        
            Last Name    
query("SELECT fname FROM student WHERE username = '$user'")->fetch_object()->fname;  
print_r($fname);
?>
        


        
            Student ID    
query("SELECT sid FROM student WHERE username = '$user'")->fetch_object()->sid;  
print_r($sid);
?>
        



            Email           
query("SELECT email FROM student WHERE username = '$user'")->fetch_object()->email;  
print_r($email);
?>
        


        
            Phone No.    
query("SELECT phone FROM student WHERE username = '$user'")->fetch_object()->phone;  
print_r($phone);
?>
        



    Scolarship    
query("SELECT Scolarship FROM student WHERE username = '$user'")->fetch_object()->Scolarship;  
print_r($Scolarship);
?>

    

   



    
        Subject Details


            Subject  
            
        

    
        
            Section  
            
        

    

        
            Semester
            
        
    


    
        Agreement


 By checking this box, i am fully responsible for the data entered above. I am also providing my official online signature to be liable in however the site may use it for.

       * Date and time are recorded for various reasons.




                 Current Date & Time : 




    


       




query("SELECT * FROM Overrides WHERE professor = '$user1'"); 
$num_rows = mysqli_num_rows($overrides);
?>
    

    
      ";
         echo "
Mid. Name:   " . $row['mname'] . "
";
         echo "
Fam. Name:   " . $row['fname'] . "
";
         echo "
Student ID:    " . $row['sid'] . "
";
         echo "
Scolarship:     " . $row['sc'] . "
";
         echo "
Phone No:     " . $row['phone'] . "
";
         echo "
Email:           " . $row['email'] . "
";
         echo "
Class:           " . $row['class'] . "
";
         echo "
Section:         " . $row['section'] . "
";
         echo "
Semester:      " . $row['semester'] . "
"; 
             $name = $row['name'];
         $mname = $row['mname'];
         $fname = $row['fname'];
         $sid = $row['sid'];
         $sc = $row['sc'];
         $phone = $row['phone'];
         $email = $row['email'];
         $class = $row['class'];
         $section = $row['section'];
         $semester = $row['semester'];

         ?>



            
Notes & Comments:







    


prepare("INSERT INTO `headforms`(`name`,`mname`,`fname`,`sid`,`email`,`phone`,`sc`,`class`,`section`,`semester`,`comments`) VALUES (?,?,?,?,?,?,?,?,?,?,?)");
$prepare->bind_param("sssssssssss", $name, $mname, $fname, $sid, $email, $phone, $sc, $class, $section, $semester, $_POST['comments']); $prepare->execute();   } ?>
        
                

    


prepare("INSERT INTO `deanforms`(`name`,`mname`,`fname`,`sid`,`email`,`phone`,`sc`,`class`,`section`,`semester`) VALUES (?,?,?,?,?,?,?,?,?,?)");
$prepare->bind_param("ssssssssss", $name, $mname, $fname, $sid, $email, $phone, $sc, $class, $section, $semester); $prepare->execute(); } ?>
    

    
    





query("SELECT * FROM headforms WHERE professor = '$user2'"); 
$num_rows2 = mysqli_num_rows($headforms);


echo "Overrides today: " . $num_rows2; 
    while($row2 = mysqli_fetch_array($headforms)) {
         echo "

First Name: " . $row2['name'] . "
";
         echo "
Middle Name: " . $row2['mname'] . "
";
         echo "
Family Name: " . $row2['fname'] . "
";
         echo "
Student ID: " . $row2['sid'] . "
";
         echo "
Scolarship: " . $row2['sc'] . "
";
         echo "
Phone No: " . $row2['phone'] . "
";
         echo "
Email: " . $row2['email'] . "
";
         echo "
Class: " . $row2['class'] . "
";
         echo "
Section: " . $row2['section'] . "
";
         echo "
Semester: " . $row2['semester'] . "
";
}

?>

query("SELECT * FROM registrarforms WHERE professor = '$user3'"); 
$num_rows3 = mysqli_num_rows($registrarforms);


echo "Overrides today: " . $num_rows3; 
    while($row3 = mysqli_fetch_array($registrarforms)) {
         echo "

First Name: " . $row3['name'] . "
";
         echo "
Middle Name: " . $row3['mname'] . "
";
         echo "
Family Name: " . $row3['fname'] . "
";
         echo "
Student ID: " . $row3['sid'] . "
";
         echo "
Scolarship: " . $row3['sc'] . "
";
         echo "
Phone No: " . $row3['phone'] . "
";
         echo "
Email: " . $row3['email'] . "
";
         echo "
Class: " . $row3['class'] . "
";
         echo "
Section: " . $row3['section'] . "
";
         echo "
Semester: " . $row3['semester'] . "
";
}
?>



query("SELECT * FROM deanforms WHERE professor = '$user4'"); 
$num_rows4 = mysqli_num_rows($deanforms);


echo "Overrides today: " . $num_rows4; 
    while($row4 = mysqli_fetch_array($deanforms)) {
         echo "

First Name: " . $row4['name'] . "
";
         echo "
Middle Name: " . $row4['mname'] . "
";
         echo "
Family Name: " . $row4['fname'] . "
";
         echo "
Student ID: " . $row4['sid'] . "
";
         echo "
Scolarship: " . $row4['sc'] . "
";
         echo "
Phone No: " . $row4['phone'] . "
";
         echo "
Email: " . $row4['email'] . "
";
         echo "
Class: " . $row4['class'] . "
";
         echo "
Section: " . $row4['section'] . "
";
         echo "
Semester: " . $row4['semester'] . "
";
}
}

?>


        
            
                You are not authorized to access this page. Please login.

Don't mind the whole code above, the part i am doing the work in is here:

query("SELECT * FROM Overrides WHERE professor = '$user1'"); 
$num_rows = mysqli_num_rows($overrides);
?>
    

    
      ";
         echo "
Mid. Name:   " . $row['mname'] . "
";
         echo "
Fam. Name:   " . $row['fname'] . "
";
         echo "
Student ID:    " . $row['sid'] . "
";
         echo "
Scolarship:     " . $row['sc'] . "
";
         echo "
Phone No:     " . $row['phone'] . "
";
         echo "
Email:           " . $row['email'] . "
";
         echo "
Class:           " . $row['class'] . "
";
         echo "
Section:         " . $row['section'] . "
";
         echo "
Semester:      " . $row['semester'] . "
"; 
             $name = $row['name'];
         $mname = $row['mname'];
         $fname = $row['fname'];
         $sid = $row['sid'];
         $sc = $row['sc'];
         $phone = $row['phone'];
         $email = $row['email'];
         $class = $row['class'];
         $section = $row['section'];
         $semester = $row['semester'];

         ?>



            
Notes & Comments:







    


prepare("INSERT INTO `headforms`(`name`,`mname`,`fname`,`sid`,`email`,`phone`,`sc`,`class`,`section`,`semester`,`comments`) VALUES (?,?,?,?,?,?,?,?,?,?,?)");
$prepare->bind_param("sssssssssss", $name, $mname, $fname, $sid, $email, $phone, $sc, $class, $section, $semester, $_POST['comments']); $prepare->execute();   } ?>
        
                

    


prepare("INSERT INTO `deanforms`(`name`,`mname`,`fname`,`sid`,`email`,`phone`,`sc`,`class`,`section`,`semester`) VALUES (?,?,?,?,?,?,?,?,?,?)");
$prepare->bind_param("ssssssssss", $name, $mname, $fname, $sid, $email, $phone, $sc, $class, $section, $semester); $prepare->execute(); } ?>

dboverride.php:

    prepare("INSERT INTO `Overrides`(`name`,`mname`,`fname`,`sid`,`email`,`phone`,`sc`,`class`,`section`,`semester`) VALUES (?,?,?,?,?,?,?,?,?,?)");
$prepare->bind_param("ssssssssss", $_POST['name'], $_POST['mname'], $_POST['fname'], $_POST['sid'], $_POST['email'], $_POST['phone'], $_POST['sc'], $_POST['class'], $_POST['section'], $_POST['semester']);
$prepare->execute();
if ($prepare) {
echo 'Your form has been submitted';
} else {
echo 'Sorry';
}
?>

Ron · Accepted Answer

why instead of adding a whole new row with the same content, you do not create a column "approved_prof" or just "approved", and if it is on the first stage, the default value would be 0, when the professor approves it, you will have to just update the value from 0 to 1, and then check any records that match "approved"="1", to be show to the Head of Dept, so he approves it, at which point you can update it to =2 .... you save alot of mysql resources this way. and checks/updates are much easier

Writing data from a database to another with a submit function

Answers (1)

Related Questions