View difference between Paste ID: ad4Y3V1p and jN4iMrDg

 <?php
 
 // php code to Insert data into mysql database from input text
 if(isset($_POST['insert']))
 {
     $hostname = "localhost";
     $username = "root";
     $password = "REMOVED BY USER";
     $databaseName = "emergelogs";
 
     // get values form input text and number
 
     $targetname = $_POST['targetname'];
     $staffname = $_POST['staffname'];
     $actiontaken = $_POST['actiontaken'];
     $description = $_POST['description'];
     $date_of_action = $_POST['date_of_action'];
     $evidence = $_POST['evidence'];
 
     // connect to mysql database using mysqli
 
     $connect = mysqli_connect($hostname, $username, $password, $databaseName);
 
     // mysql query to insert data
 
     $query = "INSERT INTO modlogs(`targetname`, `staffname`, `actiontaken`, `description`, `date_of_action`, `evidence`) VALUES ('$targetname', '$staffname' ,'$actiontaken', '$description', '$date_of_action', '$evidence')";
 
 //THIS WILL GIVE YOU USEFUL INFORMATION
 echo $query;
 
 
     $result = mysqli_query($connect,$query);
 
     // check if mysql query successful
 
     if($result)
     {
         echo 'Data Inserted';
     }
 
     else{
         echo 'Data Not Inserted';
     }
 
     //mysqli_free_result($result);
     mysqli_close($connect);
 }
 
 ?>