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_photo 1="NULL";}
if($test_valence_photo1==null){$test_valence_photo 1="NULL";}
if($test_arousal_photo2==null){$test_arousal_photo 2="NULL";}
if($test_valence_photo2==null){$test_valence_photo 2="NULL";}
if($test_arousal_photo3==null){$test_arousal_photo 3="NULL";}
if($test_valence_photo3==null){$test_valence_photo 3="NULL";}
if($test_arousal_photo4==null){$test_arousal_photo 4="NULL";}
if($test_valence_photo4==null){$test_valence_photo 4="NULL";}
if($test_arousal_photo5==null){$test_arousal_photo 5="NULL";}
if($test_valence_photo5==null){$test_valence_photo 5="NULL";}
if($test_arousal_photo6==null){$test_arousal_photo 6="NULL";}
if($test_valence_photo6==null){$test_valence_photo 6="NULL";}
if($test_arousal_photo7==null){$test_arousal_photo 7="NULL";}
if($test_valence_photo7==null){$test_valence_photo 7="NULL";}
if($test_arousal_photo8==null){$test_arousal_photo 8="NULL";}
if($test_valence_photo8==null){$test_valence_photo 8="NULL";}
if($test_arousal_photo9==null){$test_arousal_photo 9="NULL";}
if($test_valence_photo9==null){$test_valence_photo 9="NULL";}
if($test_arousal_photo10==null){$test_arousal_phot o10="NULL";}
if($test_valence_photo10==null){$test_valence_phot o10="NULL";}
$connessione=mysql_connect("localhost", "");
$selezione_db=mysql_select_db("guest_book", $connessione);
echo "welcome ";
echo"
your values:
test arousal photo1=". $test_arousal_photo1 ."
test valence photo1= " .$test_valence_photo1 .
"
test arousal photo2=" . $test_arousal_photo2 . "
test valence photo2= " . $test_valence_photo2 .
"
test arousal photo3=" . $test_arousal_photo3 . "
test valence photo3= " . $test_valence_photo3 .
"
test arousal photo4=" . $test_arousal_photo4 . "
test valence photo4= " . $test_valence_photo4 .
"
test arousal photo5=" . $test_arousal_photo5 . "
test valence photo5= " . $test_valence_photo5 .
"
test arousal photo6=" . $test_arousal_photo6 . "
test valence photo6= " . $test_valence_photo6 .
"
test arousal photo7=" . $test_arousal_photo7 . "
test valence photo7= " . $test_valence_photo7 .
"
test arousal photo8=" . $test_arousal_photo8 . "
test valence photo8= " . $test_valence_photo8 .
"
test arousal photo9=" . $test_arousal_photo9 . "
test valence photo9= " . $test_valence_photo9 .
"
test arousal photo10=" . $test_arousal_photo10 . "
test valence photo10= " . $_SESSION['test_valence_photo10'];
$query="INSERT INTO messaggi (id_user,user,gender,date_of_birth,country,test_ar ousal_photo1,test_valence_photo1,test_arousal_phot o2,test_valence_photo2,test_arousal_photo3,test_va lence_photo3,test_arousal_photo4,test_valence_phot o4,test_arousal_photo5,test_valence_photo5,test_ar ousal_photo6,test_valence_photo6,test_arousal_phot o7,test_valence_photo7,test_arousal_photo8,test_va lence_photo8,test_arousal_photo9,test_valence_phot o9,test_arousal_photo10,test_valence_photo10,date) ";
$query.=" VALUES ('$id_user','$user','$gender','$year-$month-$day','$country',$test_arousal_photo1,$test_valenc e_photo1,$test_arousal_photo2,$test_valence_photo2 ,$test_arousal_photo3,$test_valence_photo3,$test_a rousal_photo4,$test_valence_photo4,$test_arousal_p hoto5,$test_valence_photo5,$test_arousal_photo6,$t est_valence_photo6,$test_arousal_photo7,$test_vale nce_photo7,$test_arousal_photo8,$test_valence_phot o8,$test_arousal_photo9,$test_valence_photo9,$test _arousal_photo10,$test_valence_photo10, now())" ;
$inserimento=mysql_query($query);
mysql_close($connessione);
?>
<html>
<head>
</p>
[img]image value.JPG[/img] [img]valence-arousal.JPG[/img]</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_photo 1="NULL";}
if($test_valence_photo1==null){$test_valence_photo 1="NULL";}
if($test_arousal_photo2==null){$test_arousal_photo 2="NULL";}
if($test_valence_photo2==null){$test_valence_photo 2="NULL";}
if($test_arousal_photo3==null){$test_arousal_photo 3="NULL";}
if($test_valence_photo3==null){$test_valence_photo 3="NULL";}
if($test_arousal_photo4==null){$test_arousal_photo 4="NULL";}
if($test_valence_photo4==null){$test_valence_photo 4="NULL";}
if($test_arousal_photo5==null){$test_arousal_photo 5="NULL";}
if($test_valence_photo5==null){$test_valence_photo 5="NULL";}
if($test_arousal_photo6==null){$test_arousal_photo 6="NULL";}
if($test_valence_photo6==null){$test_valence_photo 6="NULL";}
if($test_arousal_photo7==null){$test_arousal_photo 7="NULL";}
if($test_valence_photo7==null){$test_valence_photo 7="NULL";}
if($test_arousal_photo8==null){$test_arousal_photo 8="NULL";}
if($test_valence_photo8==null){$test_valence_photo 8="NULL";}
if($test_arousal_photo9==null){$test_arousal_photo 9="NULL";}
if($test_valence_photo9==null){$test_valence_photo 9="NULL";}
if($test_arousal_photo10==null){$test_arousal_phot o10="NULL";}
if($test_valence_photo10==null){$test_valence_phot o10="NULL";}
$connessione=mysql_connect("localhost", "giorgio", "pdoigroig");
$selezione_db=mysql_select_db("guest_book", $connessione);
echo "welcome ";
echo"
your values:
test arousal photo1=". $test_arousal_photo1 ."
test valence photo1= " .$test_valence_photo1 .
"
test arousal photo2=" . $test_arousal_photo2 . "
test valence photo2= " . $test_valence_photo2 .
"
test arousal photo3=" . $test_arousal_photo3 . "
test valence photo3= " . $test_valence_photo3 .
"
test arousal photo4=" . $test_arousal_photo4 . "
test valence photo4= " . $test_valence_photo4 .
"
test arousal photo5=" . $test_arousal_photo5 . "
test valence photo5= " . $test_valence_photo5 .
"
test arousal photo6=" . $test_arousal_photo6 . "
test valence photo6= " . $test_valence_photo6 .
"
test arousal photo7=" . $test_arousal_photo7 . "
test valence photo7= " . $test_valence_photo7 .
"
test arousal photo8=" . $test_arousal_photo8 . "
test valence photo8= " . $test_valence_photo8 .
"
test arousal photo9=" . $test_arousal_photo9 . "
test valence photo9= " . $test_valence_photo9 .
"
test arousal photo10=" . $test_arousal_photo10 . "
test valence photo10= " . $_SESSION['test_valence_photo10'];
$query="INSERT INTO messaggi (id_user,user,gender,date_of_birth,country,test_ar ousal_photo1,test_valence_photo1,test_arousal_phot o2,test_valence_photo2,test_arousal_photo3,test_va lence_photo3,test_arousal_photo4,test_valence_phot o4,test_arousal_photo5,test_valence_photo5,test_ar ousal_photo6,test_valence_photo6,test_arousal_phot o7,test_valence_photo7,test_arousal_photo8,test_va lence_photo8,test_arousal_photo9,test_valence_phot o9,test_arousal_photo10,test_valence_photo10,date) ";
$query.=" VALUES ('$id_user','$user','$gender','$year-$month-$day','$country',$test_arousal_photo1,$test_valenc e_photo1,$test_arousal_photo2,$test_valence_photo2 ,$test_arousal_photo3,$test_valence_photo3,$test_a rousal_photo4,$test_valence_photo4,$test_arousal_p hoto5,$test_valence_photo5,$test_arousal_photo6,$t est_valence_photo6,$test_arousal_photo7,$test_vale nce_photo7,$test_arousal_photo8,$test_valence_phot o8,$test_arousal_photo9,$test_valence_photo9,$test _arousal_photo10,$test_valence_photo10, now())" ;
$inserimento=mysql_query($query);
mysql_close($connessione);
?>
<html>
<head>
</p>
[img]image value.JPG[/img] [img]valence-arousal.JPG[/img]</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
Rispondi quotando