• G
    User Attivo •

    settare una variabile di sessione

    settare una variabile di sessione
    salve, ho questo script per l'inserimento dei dati:

    <?php
    session_start();
    ?>

    <?php

    $id_user = $_SESSION['id_user'];
    $user = $_SESSION['user'];
    $gender = $_SESSION['gender'];
    $year=$_SESSION['year'];
    $month=$_SESSION['month'];
    $day=$_SESSION['day'];
    $country = $_SESSION['country'];
    $test_arousal_photo1 = $_SESSION['test_arousal_photo1'];
    $test_valence_photo1 = $_SESSION['test_valence_photo1'];
    $test_arousal_photo2 = $_SESSION['test_arousal_photo2'];
    $test_valence_photo2 = $_SESSION['test_valence_photo2'];
    $test_arousal_photo3 = $_SESSION['test_arousal_photo3'];
    $test_valence_photo3 = $_SESSION['test_valence_photo3'];
    $test_arousal_photo4 = $_SESSION['test_arousal_photo4'];
    $test_valence_photo4 = $_SESSION['test_valence_photo4'];
    $test_arousal_photo5 = $_SESSION['test_arousal_photo5'];
    $test_valence_photo5 = $_SESSION['test_valence_photo5'];
    $test_arousal_photo6 = $_SESSION['test_arousal_photo6'];
    $test_valence_photo6 = $_SESSION['test_valence_photo6'];
    $test_arousal_photo7 = $_SESSION['test_arousal_photo7'];
    $test_valence_photo7 = $_SESSION['test_valence_photo7'];
    $test_arousal_photo8 = $_SESSION['test_arousal_photo8'];
    $test_valence_photo8 = $_SESSION['test_valence_photo8'];
    $test_arousal_photo9 = $_SESSION['test_arousal_photo9'];
    $test_valence_photo9 = $_SESSION['test_valence_photo9'];
    $test_arousal_photo10 = $_SESSION['test_arousal_photo10'];
    $test_valence_photo10 = $_SESSION['test_valence_photo10'];

    if($test_arousal_photo1==null){$test_arousal_photo1="NULL";}
    if($test_valence_photo1==null){$test_valence_photo1="NULL";}
    if($test_arousal_photo2==null){$test_arousal_photo2="NULL";}
    if($test_valence_photo2==null){$test_valence_photo2="NULL";}
    if($test_arousal_photo3==null){$test_arousal_photo3="NULL";}
    if($test_valence_photo3==null){$test_valence_photo3="NULL";}
    if($test_arousal_photo4==null){$test_arousal_photo4="NULL";}
    if($test_valence_photo4==null){$test_valence_photo4="NULL";}
    if($test_arousal_photo5==null){$test_arousal_photo5="NULL";}
    if($test_valence_photo5==null){$test_valence_photo5="NULL";}
    if($test_arousal_photo6==null){$test_arousal_photo6="NULL";}
    if($test_valence_photo6==null){$test_valence_photo6="NULL";}
    if($test_arousal_photo7==null){$test_arousal_photo7="NULL";}
    if($test_valence_photo7==null){$test_valence_photo7="NULL";}
    if($test_arousal_photo8==null){$test_arousal_photo8="NULL";}
    if($test_valence_photo8==null){$test_valence_photo8="NULL";}
    if($test_arousal_photo9==null){$test_arousal_photo9="NULL";}
    if($test_valence_photo9==null){$test_valence_photo9="NULL";}
    if($test_arousal_photo10==null){$test_arousal_photo10="NULL";}
    if($test_valence_photo10==null){$test_valence_photo10="NULL";}

    $connessione=mysql_connect("localhost", " ");
    $selezione_db=mysql_select_db("guest_book", $connessione);

    echo "welcome ";
    echo" <BR><BR><BR><BR> your values:<BR>
    <BR>test arousal photo1= ". $test_arousal_photo1 ."<br>test valence photo1= " .$test_valence_photo1 .
    "<br>test arousal photo2= " . $test_arousal_photo2 . "<br>test valence photo2= " . $test_valence_photo2 .
    "<br>test arousal photo3= " . $test_arousal_photo3 . "<br>test valence photo3= " . $test_valence_photo3 .
    "<br>test arousal photo4= " . $test_arousal_photo4 . "<br>test valence photo4= " . $test_valence_photo4 .
    "<br>test arousal photo5= " . $test_arousal_photo5 . "<br>test valence photo5= " . $test_valence_photo5 .
    "<br>test arousal photo6= " . $test_arousal_photo6 . "<br>test valence photo6= " . $test_valence_photo6 .
    "<br>test arousal photo7= " . $test_arousal_photo7 . "<br>test valence photo7= " . $test_valence_photo7 .
    "<br>test arousal photo8= " . $test_arousal_photo8 . "<br>test valence photo8= " . $test_valence_photo8 .
    "<br>test arousal photo9= " . $test_arousal_photo9 . "<br>test valence photo9= " . $test_valence_photo9 .
    "<br>test arousal photo10= " . $test_arousal_photo10 . "<br>test valence photo10= " . $_SESSION['test_valence_photo10'];

    $query="INSERT INTO messaggi (id_user,user,gender,date_of_birth,country,test_arousal_photo1,test_valence_photo1,test_arousal_photo2,test_valence_photo2,test_arousal_photo3,test_valence_photo3,test_arousal_photo4,test_valence_photo4,test_arousal_photo5,test_valence_photo5,test_arousal_photo6,test_valence_photo6,test_arousal_photo7,test_valence_photo7,test_arousal_photo8,test_valence_photo8,test_arousal_photo9,test_valence_photo9,test_arousal_photo10,test_valence_photo10,date)";
    $query.=" VALUES ('$id_user','$user','$gender','$year-$month-$day','$country',$test_arousal_photo1,$test_valence_photo1,$test_arousal_photo2,$test_valence_photo2,$test_arousal_photo3,$test_valence_photo3,$test_arousal_photo4,$test_valence_photo4,$test_arousal_photo5,$test_valence_photo5,$test_arousal_photo6,$test_valence_photo6,$test_arousal_photo7,$test_valence_photo7,$test_arousal_photo8,$test_valence_photo8,$test_arousal_photo9,$test_valence_photo9,$test_arousal_photo10,$test_valence_photo10, now())" ;

    $inserimento=mysql_query($query);
    mysql_close($connessione);

    ?>

    <html>
    <head>
    <p><BR>
    <BR>
    </p>
    <p><BR>
    <BR>
    <img src="image value.JPG" alt="image value" width="600 height=" height="748"800" /> <img src="valence-arousal.JPG" alt="valence arousal" width="551" height="540" /></p>
    <p><p align="right">
    <title></title>
    </head>

    <?php
    session_start();
    ?>

    <?php

    $id_user = $_SESSION['id_user'];
    $user = $_SESSION['user'];
    $gender = $_SESSION['gender'];
    $year=$_SESSION['year'];
    $month=$_SESSION['month'];
    $day=$_SESSION['day'];
    $country = $_SESSION['country'];
    $test_arousal_photo1 = $_SESSION['test_arousal_photo1'];
    $test_valence_photo1 = $_SESSION['test_valence_photo1'];
    $test_arousal_photo2 = $_SESSION['test_arousal_photo2'];
    $test_valence_photo2 = $_SESSION['test_valence_photo2'];
    $test_arousal_photo3 = $_SESSION['test_arousal_photo3'];
    $test_valence_photo3 = $_SESSION['test_valence_photo3'];
    $test_arousal_photo4 = $_SESSION['test_arousal_photo4'];
    $test_valence_photo4 = $_SESSION['test_valence_photo4'];
    $test_arousal_photo5 = $_SESSION['test_arousal_photo5'];
    $test_valence_photo5 = $_SESSION['test_valence_photo5'];
    $test_arousal_photo6 = $_SESSION['test_arousal_photo6'];
    $test_valence_photo6 = $_SESSION['test_valence_photo6'];
    $test_arousal_photo7 = $_SESSION['test_arousal_photo7'];
    $test_valence_photo7 = $_SESSION['test_valence_photo7'];
    $test_arousal_photo8 = $_SESSION['test_arousal_photo8'];
    $test_valence_photo8 = $_SESSION['test_valence_photo8'];
    $test_arousal_photo9 = $_SESSION['test_arousal_photo9'];
    $test_valence_photo9 = $_SESSION['test_valence_photo9'];
    $test_arousal_photo10 = $_SESSION['test_arousal_photo10'];
    $test_valence_photo10 = $_SESSION['test_valence_photo10'];

    if($test_arousal_photo1==null){$test_arousal_photo1="NULL";}
    if($test_valence_photo1==null){$test_valence_photo1="NULL";}
    if($test_arousal_photo2==null){$test_arousal_photo2="NULL";}
    if($test_valence_photo2==null){$test_valence_photo2="NULL";}
    if($test_arousal_photo3==null){$test_arousal_photo3="NULL";}
    if($test_valence_photo3==null){$test_valence_photo3="NULL";}
    if($test_arousal_photo4==null){$test_arousal_photo4="NULL";}
    if($test_valence_photo4==null){$test_valence_photo4="NULL";}
    if($test_arousal_photo5==null){$test_arousal_photo5="NULL";}
    if($test_valence_photo5==null){$test_valence_photo5="NULL";}
    if($test_arousal_photo6==null){$test_arousal_photo6="NULL";}
    if($test_valence_photo6==null){$test_valence_photo6="NULL";}
    if($test_arousal_photo7==null){$test_arousal_photo7="NULL";}
    if($test_valence_photo7==null){$test_valence_photo7="NULL";}
    if($test_arousal_photo8==null){$test_arousal_photo8="NULL";}
    if($test_valence_photo8==null){$test_valence_photo8="NULL";}
    if($test_arousal_photo9==null){$test_arousal_photo9="NULL";}
    if($test_valence_photo9==null){$test_valence_photo9="NULL";}
    if($test_arousal_photo10==null){$test_arousal_photo10="NULL";}
    if($test_valence_photo10==null){$test_valence_photo10="NULL";}

    $connessione=mysql_connect("localhost", "");
    $selezione_db=mysql_select_db("guest_book", $connessione);

    echo "welcome ";
    echo" <BR><BR><BR><BR> your values:<BR>
    <BR>test arousal photo1= ". $test_arousal_photo1 ."<br>test valence photo1= " .$test_valence_photo1 .
    "<br>test arousal photo2= " . $test_arousal_photo2 . "<br>test valence photo2= " . $test_valence_photo2 .
    "<br>test arousal photo3= " . $test_arousal_photo3 . "<br>test valence photo3= " . $test_valence_photo3 .
    "<br>test arousal photo4= " . $test_arousal_photo4 . "<br>test valence photo4= " . $test_valence_photo4 .
    "<br>test arousal photo5= " . $test_arousal_photo5 . "<br>test valence photo5= " . $test_valence_photo5 .
    "<br>test arousal photo6= " . $test_arousal_photo6 . "<br>test valence photo6= " . $test_valence_photo6 .
    "<br>test arousal photo7= " . $test_arousal_photo7 . "<br>test valence photo7= " . $test_valence_photo7 .
    "<br>test arousal photo8= " . $test_arousal_photo8 . "<br>test valence photo8= " . $test_valence_photo8 .
    "<br>test arousal photo9= " . $test_arousal_photo9 . "<br>test valence photo9= " . $test_valence_photo9 .
    "<br>test arousal photo10= " . $test_arousal_photo10 . "<br>test valence photo10= " . $_SESSION['test_valence_photo10'];

    $query="INSERT INTO messaggi (id_user,user,gender,date_of_birth,country,test_arousal_photo1,test_valence_photo1,test_arousal_photo2,test_valence_photo2,test_arousal_photo3,test_valence_photo3,test_arousal_photo4,test_valence_photo4,test_arousal_photo5,test_valence_photo5,test_arousal_photo6,test_valence_photo6,test_arousal_photo7,test_valence_photo7,test_arousal_photo8,test_valence_photo8,test_arousal_photo9,test_valence_photo9,test_arousal_photo10,test_valence_photo10,date)";
    $query.=" VALUES ('$id_user','$user','$gender','$year-$month-$day','$country',$test_arousal_photo1,$test_valence_photo1,$test_arousal_photo2,$test_valence_photo2,$test_arousal_photo3,$test_valence_photo3,$test_arousal_photo4,$test_valence_photo4,$test_arousal_photo5,$test_valence_photo5,$test_arousal_photo6,$test_valence_photo6,$test_arousal_photo7,$test_valence_photo7,$test_arousal_photo8,$test_valence_photo8,$test_arousal_photo9,$test_valence_photo9,$test_arousal_photo10,$test_valence_photo10, now())" ;

    $inserimento=mysql_query($query);
    mysql_close($connessione);

    ?>

    <html>
    <head>
    <p><BR>
    <BR>
    </p>
    <p><BR>
    <BR>
    <img src="image value.JPG" alt="image value" width="600 height=" height="748"800" /> <img src="valence-arousal.JPG" alt="valence arousal" width="551" height="540" /></p>
    <p><p align="right">
    <title></title>
    </head>

    la mia richiesta è questa:
    come settare una variabile di sessione che indica che l'utente ha già inserito i dati in una sessione e quindi non farglieli reinserire?

    grazie

    0
  • S
    User Attivo •

    beh basta vedere se una variabile di sessione esiste if (isset($_SESSION['nome_var'])) se si vuol dire che lo ha gié fatto.

    Comunque mi sembra mega incasinato quel codice, sembra che qualcosa non va nella progettazione 😐

    0
  • G
    User Attivo •

    ciao, grazie della risposta..
    vorrei che alla fine la mia sessione si chiuda e che una volta che sono stato inseriti i dati nel db, l'utente nn possa pou' farlo, cioè, se clikka su aggiorna adesso li inserisce 2 volte..vorrei evitare questo. grazie

    0
  • S
    User Attivo •

    ti salvi in una nuova sessione che lo ha già fatto

    0
  • G
    User Attivo •

    ciao skyline,
    questa è la mia ultima pagina dove inserisco tutto nel db:

    <?php
    session_start();
    ?>
    <?php
    $id_user = $_SESSION['id_user'];
    $user = $_SESSION['user'];
    $gender = $_SESSION['gender'];
    $year=$_SESSION['year'];
    $month=$_SESSION['month'];
    $day=$_SESSION['day'];
    $country = $_SESSION['country'];
    $test_arousal_photo1 = $_SESSION['test_arousal_photo1'];
    $test_valence_photo1 = $_SESSION['test_valence_photo1'];
    $test_arousal_photo2 = $_SESSION['test_arousal_photo2'];
    $test_valence_photo2 = $_SESSION['test_valence_photo2'];
    $test_arousal_photo3 = $_SESSION['test_arousal_photo3'];
    $test_valence_photo3 = $_SESSION['test_valence_photo3'];
    $test_arousal_photo4 = $_SESSION['test_arousal_photo4'];
    $test_valence_photo4 = $_SESSION['test_valence_photo4'];
    $test_arousal_photo5 = $_SESSION['test_arousal_photo5'];
    $test_valence_photo5 = $_SESSION['test_valence_photo5'];
    $test_arousal_photo6 = $_SESSION['test_arousal_photo6'];
    $test_valence_photo6 = $_SESSION['test_valence_photo6'];
    $test_arousal_photo7 = $_SESSION['test_arousal_photo7'];
    $test_valence_photo7 = $_SESSION['test_valence_photo7'];
    $test_arousal_photo8 = $_SESSION['test_arousal_photo8'];
    $test_valence_photo8 = $_SESSION['test_valence_photo8'];
    $test_arousal_photo9 = $_SESSION['test_arousal_photo9'];
    $test_valence_photo9 = $_SESSION['test_valence_photo9'];
    $test_arousal_photo10 = $_SESSION['test_arousal_photo10'];
    $test_valence_photo10 = $_SESSION['test_valence_photo10'];

    if($test_arousal_photo1==null){$test_arousal_photo1="NULL";}
    if($test_valence_photo1==null){$test_valence_photo1="NULL";}
    if($test_arousal_photo2==null){$test_arousal_photo2="NULL";}
    if($test_valence_photo2==null){$test_valence_photo2="NULL";}
    if($test_arousal_photo3==null){$test_arousal_photo3="NULL";}
    if($test_valence_photo3==null){$test_valence_photo3="NULL";}
    if($test_arousal_photo4==null){$test_arousal_photo4="NULL";}
    if($test_valence_photo4==null){$test_valence_photo4="NULL";}
    if($test_arousal_photo5==null){$test_arousal_photo5="NULL";}
    if($test_valence_photo5==null){$test_valence_photo5="NULL";}
    if($test_arousal_photo6==null){$test_arousal_photo6="NULL";}
    if($test_valence_photo6==null){$test_valence_photo6="NULL";}
    if($test_arousal_photo7==null){$test_arousal_photo7="NULL";}
    if($test_valence_photo7==null){$test_valence_photo7="NULL";}
    if($test_arousal_photo8==null){$test_arousal_photo8="NULL";}
    if($test_valence_photo8==null){$test_valence_photo8="NULL";}
    if($test_arousal_photo9==null){$test_arousal_photo9="NULL";}
    if($test_valence_photo9==null){$test_valence_photo9="NULL";}
    if($test_arousal_photo10==null){$test_arousal_photo10="NULL";}
    if($test_valence_photo10==null){$test_valence_photo10="NULL";}

    $connessione=mysql_connect("localhost", "");
    $selezione_db=mysql_select_db("guest_book", $connessione);

    echo "welcome ";
    echo" <BR><BR><BR><BR> your values:<BR>
    <BR>test arousal photo1= ". $test_arousal_photo1 ."<br>test valence photo1= " .$test_valence_photo1 .
    "<br>test arousal photo2= " . $test_arousal_photo2 . "<br>test valence photo2= " . $test_valence_photo2 .
    "<br>test arousal photo3= " . $test_arousal_photo3 . "<br>test valence photo3= " . $test_valence_photo3 .
    "<br>test arousal photo4= " . $test_arousal_photo4 . "<br>test valence photo4= " . $test_valence_photo4 .
    "<br>test arousal photo5= " . $test_arousal_photo5 . "<br>test valence photo5= " . $test_valence_photo5 .
    "<br>test arousal photo6= " . $test_arousal_photo6 . "<br>test valence photo6= " . $test_valence_photo6 .
    "<br>test arousal photo7= " . $test_arousal_photo7 . "<br>test valence photo7= " . $test_valence_photo7 .
    "<br>test arousal photo8= " . $test_arousal_photo8 . "<br>test valence photo8= " . $test_valence_photo8 .
    "<br>test arousal photo9= " . $test_arousal_photo9 . "<br>test valence photo9= " . $test_valence_photo9 .
    "<br>test arousal photo10= " . $test_arousal_photo10 . "<br>test valence photo10= " . $_SESSION['test_valence_photo10'];

    $query="INSERT INTO messaggi (id_user,user,gender,date_of_birth,country,test_arousal_photo1,test_valence_photo1,test_arousal_photo2,test_valence_photo2,test_arousal_photo3,test_va lence_photo3,test_arousal_photo4,test_valence_photo4,test_arousal_photo5,test_valence_photo5,test_arousal_photo6,test_valence_photo6,test_arousal_phot o7,test_valence_photo7,test_arousal_photo8,test_valence_photo8,test_arousal_photo9,test_valence_photo9,test_arousal_photo10,test_valence_photo10,date) ";
    $query.=" VALUES ('$id_user','$user','$gender','$year-$month-$day','$country',$test_arousal_photo1,$test_valence_photo1,$test_arousal_photo2,$test_valence_photo2,$test_arousal_photo3,$test_valence_photo3,$test_a rousal_photo4,$test_valence_photo4,$test_arousal_photo5,$test_valence_photo5,$test_arousal_photo6,$test_valence_photo6,$test_arousal_photo7,$test_vale nce_photo7,$test_arousal_photo8,$test_valence_photo8,$test_arousal_photo9,$test_valence_photo9,$test_arousal_photo10,$test_valence_photo10, now())" ;

    $inserimento=mysql_query($query);
    mysql_close($connessione);

    ?>
    come metto cio che mi hai detto?

    0
  • T
    ModSenior •

    alla fine fai

    $_SESSION['noripeti'] = true;

    e le operazioni le metti in un

    if(!isset($_SESSION['noripeti']))
    {
    // Faccio le operazioni da fare una sola volta
    }

    0
  • G
    User Attivo •

    perfetto grazie

    0
Effettua l'accesso per rispondere