| Server IP : 79.136.114.73 / Your IP : 3.148.217.66 Web Server : Apache/2.4.7 (Ubuntu) PHP/5.5.9-1ubuntu4.29 OpenSSL/1.0.1f System : Linux b8009 3.13.0-170-generic #220-Ubuntu SMP Thu May 9 12:40:49 UTC 2019 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/appsrv.astacus.se/maif/folkhalsan/ |
Upload File : |
<?php
$servername = "localhost"; // Ändra vid behov
$username = "root"; // Din MySQL-användare
$password = "root123"; // Lösenord för MySQL
$dbname = "Maif"; // Namn på databasen
// Skapa anslutning till MySQL
$conn = new mysqli($servername, $username, $password, $dbname);
// Kontrollera anslutningen
if ($conn->connect_error) {
die("Anslutningen misslyckades: " . $conn->connect_error);
}
$clientinfo = $conn->real_escape_string($_SERVER['REMOTE_ADDR'] . " - " . $_SERVER['HTTP_USER_AGENT']);
// Hämta formulärsvaren
$welcome_feeling = $_POST['welcome_feeling'];
$community_feeling = $_POST['community_feeling'];
$management_listens_coaches = $_POST['management_listens_coaches'];
$management_listens_leaders = $_POST['management_listens_leaders'];
$training_feeling = $_POST['training_feeling'];
$competition_feeling = $_POST['competition_feeling'];
$learn_new_things = $_POST['learn_new_things'];
$activities_quality = $_POST['activities_quality'];
$sport_knowledge = $_POST['sport_knowledge'];
$group_lead_knowledge = $_POST['group_lead_knowledge'];
$speak_to_management = $_POST['speak_to_management'];
$management_listens = $_POST['management_listens'];
$values_knowledge = $_POST['values_knowledge'];
$help_from_management = $_POST['help_from_management'];
$friends_in_club = $_POST['friends_in_club'];
$safe_in_club = $_POST['safe_in_club'];
$enjoy_leading_groups = $_POST['enjoy_leading_groups'];
$group_enjoyment = $_POST['group_enjoyment'];
$speak_to_parents = $_POST['speak_to_parents'];
$parent_collaboration = $_POST['parent_collaboration'];
$other_coaches_listen = $_POST['other_coaches_listen'];
$praise_in_club = $_POST['praise_in_club'];
$support_in_club = $_POST['support_in_club'];
$club_engagement = $_POST['club_engagement'];
$intervene_when_needed = $_POST['intervene_when_needed'];
$coaches_encourage_all = $_POST['coaches_encourage_all'];
$praise_participants = $_POST['praise_participants'];
$support_participants = $_POST['support_participants'];
// SQL-fråga för att kontrollera om posten redan finns
$sql = "SELECT * FROM TranareFormular WHERE clientinfo = '".$clientinfo ."'";
$result = $conn->query($sql);
if($result->num_rows > 2) { // En ledare kan vara ledare i flera lag
header("location: index_tranare.php?message=Du har redan skickat in ett svar från den här enheten!");
exit();
}
// SQL-instruktion för att lägga in svaren i databasen
$sql = "INSERT INTO TranareFormular (
clientinfo, welcome_feeling, community_feeling, management_listens_coaches, management_listens_leaders,
training_feeling, competition_feeling, learn_new_things, activities_quality, sport_knowledge,
group_lead_knowledge, speak_to_management, management_listens, values_knowledge,
help_from_management, friends_in_club, safe_in_club, enjoy_leading_groups, group_enjoyment,
speak_to_parents, parent_collaboration, other_coaches_listen, praise_in_club, support_in_club,
club_engagement, intervene_when_needed, coaches_encourage_all, praise_participants, support_participants)
VALUES (
'$clientinfo', '$welcome_feeling', '$community_feeling', '$management_listens_coaches', '$management_listens_leaders',
'$training_feeling', '$competition_feeling', '$learn_new_things', '$activities_quality', '$sport_knowledge',
'$group_lead_knowledge','$speak_to_management', '$management_listens', '$values_knowledge',
'$help_from_management', '$friends_in_club', '$safe_in_club', '$enjoy_leading_groups', '$group_enjoyment',
'$speak_to_parents', '$parent_collaboration', '$other_coaches_listen', '$praise_in_club', '$support_in_club',
'$club_engagement', '$intervene_when_needed', '$coaches_encourage_all', '$praise_participants', '$support_participants')";
if ($conn->query($sql) === TRUE) {
header("location: index_tranare.php?message=Tack! Alla dina svar har sparats!");
} else {
header("location: index_tranare.php?message=Något gick fel, försök igen, gärna från en annan enhet!");
}
// Stäng anslutningen
$conn->close();
?>