????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 = $_POST['team']; // SQL-fråga för att kontrollera om posten redan finns $sql = "SELECT * FROM MaifFormularA WHERE team = '$team' AND clientinfo = '$clientinfo'"; $result = $conn->query($sql); if ($result->num_rows > 0) { header("location: index_u-a.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ärsvaren $training_feeling = $_POST['training_feeling']; $at_training_feeling = $_POST['at_training_feeling']; $competition_feeling = $_POST['competition_feeling']; $learn_new_things = $_POST['learn_new_things']; $fun_exercises = $_POST['fun_exercises']; $feel_safe_with_coach = $_POST['feel_safe_with_coach']; $speak_freely_to_coach = $_POST['speak_freely_to_coach']; $coach_listens = $_POST['coach_listens']; $coach_knowledge = $_POST['coach_knowledge']; $coach_explains = $_POST['coach_explains']; $coach_help = $_POST['coach_help']; $coach_praise = $_POST['coach_praise']; $coach_encourage = $_POST['coach_encourage']; $friends_at_training = $_POST['friends_at_training']; $feel_safe_in_group = $_POST['feel_safe_in_group']; $speak_freely_in_group = $_POST['speak_freely_in_group']; $friends_listen = $_POST['friends_listen']; $group_is_nice = $_POST['group_is_nice']; $comments = $conn->real_escape_string($_POST['comments']); // SQL-instruktion för att lägga in svaren i databasen $sql = "INSERT INTO MaifFormularA ( team, clientinfo, training_feeling, at_training_feeling, competition_feeling, learn_new_things, fun_exercises, feel_safe_with_coach, speak_freely_to_coach, coach_listens, coach_knowledge, coach_explains, coach_help, coach_praise, coach_encourage, friends_at_training, feel_safe_in_group, speak_freely_in_group, friends_listen, group_is_nice, comments ) VALUES ( '$team', '$clientinfo', '$training_feeling', '$at_training_feeling', '$competition_feeling', '$learn_new_things', '$fun_exercises', '$feel_safe_with_coach', '$speak_freely_to_coach', '$coach_listens', '$coach_knowledge', '$coach_explains', '$coach_help', '$coach_praise', '$coach_encourage', '$friends_at_training', '$feel_safe_in_group', '$speak_freely_in_group', '$friends_listen', '$group_is_nice', '$comments' )"; if ($conn->query($sql) === TRUE) { header("location: index_u-a.php?message=Tack! Alla dina svar har sparats!"); } else { header("location: index_u-a.php?message=Något gick fel, försök igen, gärna från en annan enhet!"); } // Stäng anslutningen $conn->close(); ?>