Forum

Cod: Selectaţi tot

 <?php
   if(isset($_POST['submit'])) 
   {
     $id=$_POST['id'];
	 $anul=$_POST['anul'];
	 $luna=$_POST['luna'];
     $dellists="Delete from anunt where id='$id'";
     mysql_query($dellists) or die("NU se poate sterge anunturile!");
	 $delusers="Delete from anunt where anul='$id'";
     mysql_query($delusers) or die("Atentie, nu se poate sterge anuntul!");
     print "Anunt sters!   <a href='stergere_anunt.php'>Inapoi la stergere!</a>";  
   }   
   else 
   {
      print "Toate anunturile anuale sunt sterse!<br>";
      print "<form action='stergere_anunt.php' method='post'>";
      $getlists="SELECT * from anunt";
      $getlists2=mysql_query($getlists) or die("Nu se poate afisa lista cu anunt!");
      print "<select name='id'>";
      while($getlists3=mysql_fetch_array($getlists2))
      {
         print "<option value='$getlists3[anul]'>$getlists3[anul]</option>";
      }
      print "</select>";
      print "<input type='submit' name='submit' value='Sterge anunt!'></form>";
   }
?>

Cod: Selectaţi tot

if(isset($_POST['submit']))
{
$anul=$_POST['anul'];
$luna=$_POST['luna'];
 $dellists="DELETE FROM `anunt` WHERE `anul`='$anul' AND `luna`='$luna'";
 mysql_query($dellists) or die("NU se poate sterge anunturile!");
}

Cod: Selectaţi tot

 <?php
$utilizator=mysql_real_escape_string($_GET['id_materie']);
// Se verifica daca sunt date de la formular
if (isset($_POST['id_materie'])) {
// Se preiau datele
$id_materie=($_POST['id_materie']);
// Se face DELETE
$cerereSQL = "DELETE FROM `materii` WHERE `id_materie` ='".$id_materie."' LIMIT 1";
mysql_query($cerereSQL) or die("NU se poate STERGE!");
}
echo'<a href="afisare_materii.php">inapoi</a>';
?>