Skip to content

Instantly share code, notes, and snippets.

@Luguan

Luguan/sparaArbete.php

Last active August 29, 2015 14:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Luguan/535353094cc15c2f8888 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Luguan/535353094cc15c2f8888 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. Luguan revised this gist Jun 7, 2015. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions sparaArbete.php
    View file
    Original file line number Diff line number Diff line change
    @@ -31,11 +31,11 @@
    function addItems($user, $today, $kommentar, $franvaro, $uppgift){
    global $dbh;

    $addStmt = $dbh->prepare('INSERT INTO Arbetsuppgift(Date, Namn, Kommentar, Narvaro, Extrauppgift) VALUES(:date, :username, :kommentar, :narvaro, :extrauppgift)');
    $addStmt = $dbh->prepare('INSERT INTO Arbetsuppgift(Date, Namn, Kommentar, Narvaro, Extrauppgift) VALUES(:date, :username, :kommentar, :narvaro, :uppgift)');
    $addStmt->bindValue (':date', $today);
    $addStmt->bindValue (':username', $user);
    $addStmt->bindValue (':kommentar', $kommentar);
    $addStmt->bindValue (':narvaro', $narvaro);
    $addStmt->bindValue (':narvaro', $$franvaro);
    $addStmt->bindValue (':uppgift', $uppgift);

    return $addStmt->execute();
  2. Luguan revised this gist Jun 7, 2015. 1 changed file with 6 additions and 6 deletions.
    12 changes: 6 additions & 6 deletions sparaArbete.php
    View file
    Original file line number Diff line number Diff line change
    @@ -3,16 +3,16 @@

    if (isset($_POST['Field4']))
    {
    $frånvaro=htmlspecialchars($_POST['field106']);
    $franvaro=htmlspecialchars($_POST['field106']);

    if ($_POST['Field106']=="Second Choice")
    $frånvaro="Närvarande";
    $franvaro="Närvarande";

    else if ($_POST['Field106']=="Third Choice")
    $frånvaro="Sen ankomst";
    $franvaro="Sen ankomst";

    else if ($_POST['Field106']=="Forth Choice")
    $frånvaro="Frånvarande";
    $franvaro="Frånvarande";

    $uppgift;
    $extra= $_POST['text'];
    @@ -22,13 +22,13 @@
    $uppgift=$uppgift." ".$extra[$i];
    }

    addItems($_SESSION['username'], date("Ymd"), $_POST['Field4'], $frånvaro, $uppgift);
    addItems($_SESSION['username'], date("Ymd"), $_POST['Field4'], $franvaro, $uppgift);

    echo '<script language="javascript">';
    echo 'alert("message successfully sent")';
    echo '</script>';
    }
    function addItems($user, $today, $kommentar, $narvaro, $uppgift){
    function addItems($user, $today, $kommentar, $franvaro, $uppgift){
    global $dbh;

    $addStmt = $dbh->prepare('INSERT INTO Arbetsuppgift(Date, Namn, Kommentar, Narvaro, Extrauppgift) VALUES(:date, :username, :kommentar, :narvaro, :extrauppgift)');
  3. Luguan revised this gist Jun 3, 2015. 1 changed file with 3 additions and 5 deletions.
    8 changes: 3 additions & 5 deletions sparaArbete.php
    View file
    Original file line number Diff line number Diff line change
    @@ -13,7 +13,10 @@

    else if ($_POST['Field106']=="Forth Choice")
    $frånvaro="Frånvarande";

    $uppgift;
    $extra= $_POST['text'];

    for ($i=0; $i<count($extra); $i++){
    $extra[$i]= $extra[$i];
    $uppgift=$uppgift." ".$extra[$i];
    @@ -24,11 +27,6 @@
    echo '<script language="javascript">';
    echo 'alert("message successfully sent")';
    echo '</script>';

    $extra= $_POST['text'];

    $i = 0;

    }
    function addItems($user, $today, $kommentar, $narvaro, $uppgift){
    global $dbh;
  4. Luguan revised this gist Jun 2, 2015. 1 changed file with 3 additions and 20 deletions.
    23 changes: 3 additions & 20 deletions sparaArbete.php
    View file
    Original file line number Diff line number Diff line change
    @@ -1,10 +1,8 @@
    <?php
    session_start();
    $dbh = new PDO('mysql:host=julkalender3d.se.mysql;dbname=julkalender3d_s', 'julkalender3d_s', 'amax3Ds');

    if (isset($_POST['Field4']))
    {

    $dbh = new PDO('mysql:host=julkalender3d.se.mysql;dbname=julkalender3d_s', 'julkalender3d_s', 'amax3Ds');
    $frånvaro=htmlspecialchars($_POST['field106']);

    if ($_POST['Field106']=="Second Choice")
    @@ -27,36 +25,21 @@
    echo 'alert("message successfully sent")';
    echo '</script>';

    //För att kunna hantera svenska bokstäver
    mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $connection);

    $extra= $_POST['text'];

    $i = 0;

    $query = "INSERT INTO Arbetsuppgift (Date,Namn,Kommentar,Narvaro,Extrauppgift) VALUES ('$today','$user','$kommentar','$frånvaro','$uppgift')";

    mysql_query($query);

    if(mysql_query($query,$connection)){
    echo "Records added successfully.";
    // echo count($extra);

    }
    else{
    echo "ERROR: Could not able to execute " .$query. " " . mysql_error($connection);
    }
    }
    function addItems($user, $today, $kommentar, $narvaro, $uppgift){
    global $dbh;

    $addStmt =dbh->prepare('INSERT INTO Arbetsuppgift(Date, Namn, Kommentar, Narvaro, Extrauppgift) VALUES(:date, :username, :kommentar, :narvaro, :extrauppgift)');
    $addStmt = $dbh->prepare('INSERT INTO Arbetsuppgift(Date, Namn, Kommentar, Narvaro, Extrauppgift) VALUES(:date, :username, :kommentar, :narvaro, :extrauppgift)');
    $addStmt->bindValue (':date', $today);
    $addStmt->bindValue (':username', $user);
    $addStmt->bindValue (':kommentar', $kommentar);
    $addStmt->bindValue (':narvaro', $narvaro);
    $addStmt->bindValue (':uppgift', $uppgift);

    return addStmt->execute();
    return $addStmt->execute();
    }
    ?>
  5. Luguan revised this gist May 27, 2015. 1 changed file with 11 additions and 7 deletions.
    18 changes: 11 additions & 7 deletions sparaArbete.php
    View file
    Original file line number Diff line number Diff line change
    @@ -3,8 +3,7 @@

    if (isset($_POST['Field4']))
    {
    $frånvaro;
    $kommentar;

    $dbh = new PDO('mysql:host=julkalender3d.se.mysql;dbname=julkalender3d_s', 'julkalender3d_s', 'amax3Ds');
    $frånvaro=htmlspecialchars($_POST['field106']);

    @@ -30,10 +29,6 @@

    //För att kunna hantera svenska bokstäver
    mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $connection);

    // To protect MySQL injection for Security purpose
    $kommentar = stripslashes($kommentar);
    $frånvaro=stripslashes($frånvaro);

    $extra= $_POST['text'];

    @@ -52,7 +47,16 @@
    echo "ERROR: Could not able to execute " .$query. " " . mysql_error($connection);
    }
    }
    function addItems($user, $today, $kommentar, $frånvaro, $uppgift){
    function addItems($user, $today, $kommentar, $narvaro, $uppgift){
    global $dbh;

    $addStmt =dbh->prepare('INSERT INTO Arbetsuppgift(Date, Namn, Kommentar, Narvaro, Extrauppgift) VALUES(:date, :username, :kommentar, :narvaro, :extrauppgift)');
    $addStmt->bindValue (':date', $today);
    $addStmt->bindValue (':username', $user);
    $addStmt->bindValue (':kommentar', $kommentar);
    $addStmt->bindValue (':narvaro', $narvaro);
    $addStmt->bindValue (':uppgift', $uppgift);

    return addStmt->execute();
    }
    ?>
  6. Luguan revised this gist May 27, 2015. 1 changed file with 14 additions and 20 deletions.
    34 changes: 14 additions & 20 deletions sparaArbete.php
    View file
    Original file line number Diff line number Diff line change
    @@ -1,11 +1,10 @@
    <?php
    session_start();

    $frånvaro;
    $kommentar;

    if (isset($_POST['Field4']))
    {
    $frånvaro;
    $kommentar;
    $dbh = new PDO('mysql:host=julkalender3d.se.mysql;dbname=julkalender3d_s', 'julkalender3d_s', 'amax3Ds');
    $frånvaro=htmlspecialchars($_POST['field106']);

    @@ -17,11 +16,17 @@

    else if ($_POST['Field106']=="Forth Choice")
    $frånvaro="Frånvarande";
    $uppgift;
    for ($i=0; $i<count($extra); $i++){
    $extra[$i]= $extra[$i];
    $uppgift=$uppgift." ".$extra[$i];
    }

    addItems($_SESSION['username'], date("Ymd"), $_POST['Field4'], $frånvaro, $uppgift);

    echo '<script language="javascript">';
    echo 'alert("message successfully sent")';
    echo '</script>';
    $kommentar=$_POST['Field4'];

    //För att kunna hantera svenska bokstäver
    mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $connection);
    @@ -30,23 +35,9 @@
    $kommentar = stripslashes($kommentar);
    $frånvaro=stripslashes($frånvaro);

    //Hämta dagens datum
    $today = date("Ymd");

    $extra= $_POST['text'];
    // echo $extra;

    //Tilldela användarnamn från tidigare sidan till $user
    $user= $_SESSION['username'];
    $extra= $_POST['text'];

    $i = 0;
    $uppgift;
    for ($i=0; $i<count($extra); $i++){

    $extra[$i]= $extra[$i];

    $uppgift=$uppgift." ".$extra[$i];
    }
    $i = 0;

    $query = "INSERT INTO Arbetsuppgift (Date,Namn,Kommentar,Narvaro,Extrauppgift) VALUES ('$today','$user','$kommentar','$frånvaro','$uppgift')";

    @@ -61,4 +52,7 @@
    echo "ERROR: Could not able to execute " .$query. " " . mysql_error($connection);
    }
    }
    function addItems($user, $today, $kommentar, $frånvaro, $uppgift){

    }
    ?>
  7. Luguan revised this gist May 27, 2015. 1 changed file with 16 additions and 32 deletions.
    48 changes: 16 additions & 32 deletions sparaArbete.php
    View file
    Original file line number Diff line number Diff line change
    @@ -1,80 +1,64 @@
    <?php

    session_start();
    $frånvaro;
    $kommentar;
    session_start();
    $frånvaro;
    $kommentar;

    if (isset($_POST['Field4']))
    {
    $dbh = new PDO('mysql:host=julkalender3d.se.mysql;dbname=julkalender3d_s', 'julkalender3d_s', 'amax3Ds');
    $frånvaro=htmlspecialchars($_POST['field106']);

    if ($_POST['Field106']=="Second Choice")
    $frånvaro="Närvarande";
    if ($_POST['Field106']=="Second Choice")
    $frånvaro="Närvarande";

    else if ($_POST['Field106']=="Third Choice")
    $frånvaro="Sen ankomst";
    $frånvaro="Sen ankomst";

    else if ($_POST['Field106']=="Forth Choice")
    $frånvaro="Frånvarande";
    $frånvaro="Frånvarande";

    echo '<script language="javascript">';
    echo 'alert("message successfully sent")';

    echo '</script>';
    $kommentar=$_POST['Field4'];

    $connection = mysql_connect("julkalender3d.se.mysql","julkalender3d_s","amax3Ds")
    or die("ERROR: Could not connect. " . mysqli_connect_error());

    //För att kunna hantera svenska bokstäver
    mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $connection);

    // To protect MySQL injection for Security purpose
    $kommentar = stripslashes($kommentar);
    $frånvaro=stripslashes($frånvaro);
    $frånvaro=stripslashes($frånvaro);

    //Hämta dagens datum
    $today = date("Ymd");

    $extra= $_POST['text'];
    // echo $extra;

    // Selecting Database
    $databas=mysql_select_db("julkalender3d_s");

    //Tilldela användarnamn från tidigare sidan till $user
    // $user= $_POST['username'];
    $user=$_SESSION['username'];



    $user= $_SESSION['username'];

    $i = 0;
    $uppgift;
    /* for ($i=0; $i<count($extra); $i++){
    for ($i=0; $i<count($extra); $i++){

    $extra[$i]= $extra[$i];

    $uppgift=$uppgift." ".$extra[$i];
    }*/



    }

    $query = "INSERT INTO Arbetsuppgift (Date,Namn,Kommentar,Narvaro,Extrauppgift) VALUES ('$today','$user','$kommentar','$frånvaro','$uppgift')";
    $query = "INSERT INTO Arbetsuppgift (Date,Namn,Kommentar,Narvaro,Extrauppgift) VALUES ('$today','$user','$kommentar','$frånvaro','$uppgift')";

    // mysql_query($query);
    $success= mysql_query($query,$connection);
    mysql_query($query);

    if($success==true){
    if(mysql_query($query,$connection)){
    echo "Records added successfully.";
    // echo count($extra);

    }
    else{
    echo "ERROR: Could not able to execute " .$query. " " . mysql_error($connection);
    }

    mysql_close($connection);
    }
    ?>
  8. Luguan created this gist May 27, 2015.
    80 changes: 80 additions & 0 deletions sparaArbete.php
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,80 @@
    <?php

    session_start();
    $frånvaro;
    $kommentar;

    if (isset($_POST['Field4']))
    {
    $frånvaro=htmlspecialchars($_POST['field106']);

    if ($_POST['Field106']=="Second Choice")
    $frånvaro="Närvarande";

    else if ($_POST['Field106']=="Third Choice")
    $frånvaro="Sen ankomst";

    else if ($_POST['Field106']=="Forth Choice")
    $frånvaro="Frånvarande";

    echo '<script language="javascript">';
    echo 'alert("message successfully sent")';

    echo '</script>';
    $kommentar=$_POST['Field4'];

    $connection = mysql_connect("julkalender3d.se.mysql","julkalender3d_s","amax3Ds")
    or die("ERROR: Could not connect. " . mysqli_connect_error());

    //För att kunna hantera svenska bokstäver
    mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'", $connection);

    // To protect MySQL injection for Security purpose
    $kommentar = stripslashes($kommentar);
    $frånvaro=stripslashes($frånvaro);

    //Hämta dagens datum
    $today = date("Ymd");

    $extra= $_POST['text'];
    // echo $extra;

    // Selecting Database
    $databas=mysql_select_db("julkalender3d_s");

    //Tilldela användarnamn från tidigare sidan till $user
    // $user= $_POST['username'];
    $user=$_SESSION['username'];




    $i = 0;
    $uppgift;
    /* for ($i=0; $i<count($extra); $i++){
    $extra[$i]= $extra[$i];
    $uppgift=$uppgift." ".$extra[$i];
    }*/




    $query = "INSERT INTO Arbetsuppgift (Date,Namn,Kommentar,Narvaro,Extrauppgift) VALUES ('$today','$user','$kommentar','$frånvaro','$uppgift')";

    // mysql_query($query);
    $success= mysql_query($query,$connection);

    if($success==true){
    echo "Records added successfully.";
    // echo count($extra);

    }
    else{
    echo "ERROR: Could not able to execute " .$query. " " . mysql_error($connection);
    }

    mysql_close($connection);
    }
    ?>