WordPress, Shopify ir PHPFusion programuotojų bendruomenė

Parašė JaWa· 2010 Spa. 19 17:10:52

Sveiki. kaip galima sita dalyka perdaryti, kad surasius daugiau negu 1 id stulpeliu ir paspaudus mygtuka "trinti" issitrintu jie visi is db ?

<?php
if (ini_get('register_globals') != 1) {
if ((isset($_POST) == true) && (is_array($_POST) == true)) extract($_POST, EXTR_OVERWRITE);
if ((isset($_GET) == true) && (is_array($_GET) == true)) extract($_GET, EXTR_OVERWRITE);
}
require_once "maincore.php";
require_once THEMES."templates/header.php";

opentable("trinti");

if (isset($_POST['add'])) {

dbquery("delete from ".$db_prefix."downloads where download_url='$id'");

}
echo "<table class=tbl align=center>";
echo "<tr>
<form name='punish' method='post' action='".$PHP_SELF."'>
<td align='center' class='tbl2'><textarea name='id' rows='40' cols='2000' class='textbox' style='width:400px'></textarea><br>
<input type='submit' name='add' value='Trinti' class='button'>
</td></form></tr></table>";

closetable();

require_once THEMES."templates/footer.php";
?>

pvz:

Parašė avice· 2010 Spa. 20 17:10:55

formos pavizdys:

 
<form action="ADRESAS" method="post">
<textarea name="id" cols=10 rows=10></textarea>
<input type="submit" value="trinti">
</form>

forma uzpildyt turetum taip:

vienoj eilej vienas skaicius

o cia script:

<?PHP
$id = $_POST["id"];
$visiid = explode("
", $id);
for($all = 0; $all < count($visiid); $all++){
?>
<?php
$zz = "$visiid[$all],";
$result = mysql_query("DELETE  FROM test  WHERE id IN('$zz')");
?>
<?
}
?>

cia tik pavizdys ....

Parašė JaWa· 2010 Spa. 21 16:10:41

neveikia vistiek ... Stai dar vienas kodas. bet kai ikeliu linkus stulpeliu, man vistiek 1 istrina ... :/

<?php
require_once "maincore.php";
if(!iSUPERADMIN) exit('Access denied! :@');
require_once THEMES."templates/header.php";
 
 
/*
And2s's productions 8) 
(c) 2010 
*/
 
 
if (isset($_POST['delete'], $_POST['urls'])) {
 $to_delete = explode("\n", $_POST['urls']);
  $err = 0; $query = '';
  $i = 0;
 foreach ($to_delete as $url) {
 $query .= ($i !== 0 ? 'OR ' : '') . "download_url = '".addslashes($url)."'";
 $i++;
 }
   $result = dbquery("DELETE FROM ".DB_PREFIX."downloads WHERE ($query)");
  if (!$result) {
   $err = 1; 
  } 
 
 if ($err !== 0) {
  opentable('Klaida');
   echo "<center>Nepavyko ištrinti/center>\n";
  closetable();
 } else {
  opentable('Pavyko');
   echo "<center>Visi siuntiniai pagal jūsų įrašytas nuorodas sėkmingai ištrinti!</center>\n";
  closetable();
 }
}
 
opentable("Trinimas");
 echo "<form method='post' action=''>\n";
 echo "<textarea name='urls' class='textbox' rows='15' cols='20' style='width:400px'></textarea><br />\n";
 echo "<input type='submit' name='delete' value='Šalinti' class='button' />\n";
 echo "</form>\n";
closetable();
 
require_once THEMES."templates/footer.php";
?>

Parašė avice· 2010 Spa. 21 18:10:42

<?php
if (ini_get('register_globals') != 1) {
if ((isset($_POST) == true) && (is_array($_POST) == true)) extract($_POST, EXTR_OVERWRITE);
if ((isset($_GET) == true) && (is_array($_GET) == true)) extract($_GET, EXTR_OVERWRITE);
}
require_once "maincore.php";
require_once THEMES."templates/header.php";
 
opentable("trinti");
 
if (isset($_POST['add'])) {
 
?>
 <?PHP
      $id = $_POST["id"];
      $visiid = explode("
      ", $id);
      for($all = 0; $all < count($visiid); $all++){
      ?>
      <?php
      $zz = "$visiid[$all],";
      $result = mysql_query("DELETE FROM ".$db_prefix."downloads where download_id IN('$zz')");
      ?>
      <?
      }
      ?>
<?
 
 
}
echo "<table class=tbl align=center>";
echo "<tr>
<form name='punish' method='post' action='".$PHP_SELF."'>
<td align='center' class='tbl2'><textarea name='id' rows='40' cols='2000' class='textbox' style='width:400px'></textarea><br>
<input type='submit' name='add' value='Trinti' class='button'>
</td></form></tr></table>";
 
closetable();
 
require_once THEMES."templates/footer.php";
?>

daviau koda galejai ir isidet.
viskas cia veikia pats meginau.

Parašė avice· 2010 Spa. 21 21:10:37

kai kopijuoji sita vieta:

$visiid = explode("
 
      "

pakeisk i :

$visiid = explode("
"

biski tarpeliu prisidejo ;D