????JFIF??x?x????'
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']); $team = $conn->real_escape_string($_POST['team']); // SQL-fråga för att kontrollera om posten redan finns $sql = "SELECT * FROM GuardianForm WHERE team = '$team' AND clientinfo = '$clientinfo'"; $result = $conn->query($sql); if ($result && $result->num_rows > 0) { header("location: index_foraldrar.php?message=Du har redan skickat in ett svar från den här enheten för det här laget!"); exit; } // Hämta formulärdata och säkerställ att specialtecken hanteras korrekt $like_club = $conn->real_escape_string($_POST['like_club']); $listen_to_parents = $conn->real_escape_string($_POST['listen_to_parents']); $welcome_feeling = $conn->real_escape_string($_POST['welcome_feeling']); $training_feeling = $conn->real_escape_string($_POST['training_feeling']); $competition_feeling = $conn->real_escape_string($_POST['competition_feeling']); $learn_new_things = $conn->real_escape_string($_POST['learn_new_things']); $training_quality = $conn->real_escape_string($_POST['training_quality']); $speak_to_coaches = $conn->real_escape_string($_POST['speak_to_coaches']); $coaches_listen = $conn->real_escape_string($_POST['coaches_listen']); $coach_knowledge = $conn->real_escape_string($_POST['coach_knowledge']); $help_from_coaches = $conn->real_escape_string($_POST['help_from_coaches']); $help_coaches = $conn->real_escape_string($_POST['help_coaches']); $praise_athletes = $conn->real_escape_string($_POST['praise_athletes']); $encourage_athletes = $conn->real_escape_string($_POST['encourage_athletes']); $friends_during_training = $conn->real_escape_string($_POST['friends_during_training']); $feel_safe_in_club = $conn->real_escape_string($_POST['feel_safe_in_club']); $raise_concerns_to_leaders = $conn->real_escape_string($_POST['raise_concerns_to_leaders']); $parents_listen = $conn->real_escape_string($_POST['parents_listen']); $club_friendliness = $conn->real_escape_string($_POST['club_friendliness']); $active_in_club = $conn->real_escape_string($_POST['active_in_club']); $too_much_engagement = $conn->real_escape_string($_POST['too_much_engagement']); $leader_intervene = $conn->real_escape_string($_POST['leader_intervene']); $parents_cheer = $conn->real_escape_string($_POST['parents_cheer']); $praise_children = $conn->real_escape_string($_POST['praise_children']); $support_children = $conn->real_escape_string($_POST['support_children']); // SQL-fråga för att infoga data $sql = "INSERT INTO GuardianForm ( team, clientinfo, like_club, listen_to_parents, welcome_feeling, training_feeling, competition_feeling, learn_new_things, training_quality, speak_to_coaches, coaches_listen, coach_knowledge, help_from_coaches, help_coaches, coach_praise, coach_encouragement, friends_at_training, feel_safe, raise_concerns_to_leaders, parents_listen, community_nice, active_in_club, club_engagement, coach_intervention, parents_cheer, praise_children, support_children ) VALUES ( '$team', '$clientinfo', '$like_club', '$listen_to_parents', '$welcome_feeling', '$training_feeling', '$competition_feeling', '$learn_new_things', '$training_quality', '$speak_to_coaches', '$coaches_listen', '$coach_knowledge', '$help_from_coaches', '$help_coaches', '$praise_athletes', '$encourage_athletes', '$friends_during_training', '$feel_safe_in_club', '$raise_concerns_to_leaders', '$parents_listen', '$club_friendliness', '$active_in_club', '$too_much_engagement', '$leader_intervene', '$parents_cheer', '$praise_children', '$support_children' )"; if ($conn->query($sql) === TRUE) { header("location: index_foraldrar.php?message=Tack! Alla dina svar har sparats!"); } else { header("location: index_foraldrar.php?message=Något gick fel, försök igen, gärna från en annan enhet!"); } // Stäng anslutningen $conn->close(); ?>