non so dove metterlo !!
il codice è questo:
---------------------------------------------------------------------
<?php
$id=$_POST['id'];
$Campo1=$_POST['Campo1'];
$Option=$_POST['Option'];
//Nome database, Se metto :memory: creo un db temporaneo
$Nome_db="Test";
///Connessione Db
$db = sqlite_open($Nome_db, 0666);
///Crea tabella se non esiste altrimenti la apre
sqlite_query($db, 'CREATE TABLE Nome_Tabella (id INTEGER PRIMARY KEY, Campo1 VARCHAR(10))');
///Aggiungo record
if ($Option=='A'){
sqlite_query($db, "INSERT INTO Nome_Tabella (Campo1) VALUES ('$Campo1')");
}else{
///Modifico record
if ($Option=='M'){
sqlite_query($db, "UPDATE Nome_Tabella SET Campo1='$Campo1' WHERE id='$id'") ;
}else{
///cancello record
if ($Option=='C'){
sqlite_query($db, "DELETE FROM Nome_Tabella WHERE id = '$id'");
}else{
}
}
}
echo"<table width=\"500\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">";
echo"<tr bgcolor=\"#CCCCCC\"><td width=\"100\">Id</td><td width=\"200\">Dati</td></td>";
echo"<td width=\"100\"> </td><td width=\"100\"> </td></tr>";
////Form per aggiungere dati
echo"<tr><form action=\"index.php\" method=\"POST\"><td> </td><td><input name=\"Campo1\" type=\"text\" value=\"\"></td><td align=\"center\"><input name=\"Option\" type=\"hidden\" value=\"A\"><input type=\"submit\" value=\"Aggiungi\"></td></form>";
echo"<td align=\"center\"> </td></tr>";
////Leggo i dati
$result = sqlite_query($db, 'select * from Nome_Tabella');
while ($riga = sqlite_fetch_array($result)){
$Campo1 = $riga['Campo1'];
$id = $riga['id'];
////Form Modifica cancella dati
echo"<tr><form action=\"index.php\" method=\"POST\"><td><input name=\"id\" type=\"text\" value=\"$id\" size=\"5\"></td><td><input name=\"Campo1\" type=\"text\" value=\"$Campo1\"></td><td align=\"center\"><input name=\"Option\" type=\"hidden\" value=\"M\"><input type=\"submit\" value=\"Modifica\"></td></form>";
echo"<FORM action=\"index.php\" method=\"POST\"><input name=\"id\" type=\"hidden\" value=\"$id\" size=\"5\"><td align=\"center\"><input name=\"Option\" type=\"hidden\" value=\"C\"><input type=\"submit\" value=\"Cancella\"></td></FORM></tr>";
}
echo"</table>";
echo"visualizza";
?>
---------------------------------------------------------------------

Rispondi quotando