- Home
- Categorie
- Coding e Sistemistica
- PHP
- settare una variabile di sessione
-
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
-
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
-
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
-
ti salvi in una nuova sessione che lo ha già fatto
-
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?
-
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
}
-
perfetto grazie