Jump to content
#FlattenTheCurve ×

Archived

This topic is now archived and is closed to further replies.

Monshery

Not very Simple question but here its is .. its about checkbox's form/delete d..

Recommended Posts

Well basicaly i am trying to make a Admin side of my data base show thats means that php basicaly will print all the lines 1 by 1 in dec order and show them what i am trying to do and cant figure out whats not working is .. i added a check box in every fatch array .... and i am trying to make an array with this check box so i could delete several massages at once if i want here here is the exact code :
[code]
 
<?php
// well basicaly if i make this to work i will know how to delete enough that i will know that i can send me //the array but somewhy it wont send me.
  foreach ($_POST["checkbox"] as $key=>$val)
    echo "key:$key value:$val<BR>\n";
?>
  <table width="444" border="0">

  <tr>

    <td height="23"><div align="left"><span class="style3">my admin</span></div><div align="right"><span class="style5">הודעות מעודכנות להיום</span></div></td>

  </tr>

  <tr>
    <td width="438" height="33" bgcolor="#006699">    <form action="Admin.php" method="POST">
        <table width="437" border="0" style="border-width: 0px">

        <tr>

          <td bgcolor="#FFFFFF" class="style1" style="border-style: none; border-width: medium">

<!-- php database -->

<?php
$post_LINK=mysql_connect('xxxxxxxxx','xxxxxxxx','xxxxxxx') or die("Connection fail");
mysql_select_db('xxxxxxxxx',$post_LINK);
$MASSAGES_links = mysql_query("SELECT * FROM xxxxxxx ORDER BY id DESC",$post_LINK);
while($MASSEGES=mysql_fetch_array($MASSAGES_links))
{
?>

            <div align="right"></div>

            <div align="right">

              <table width="432" height="77" border="0" bgcolor="#FFFFFF">

                  <tr>

                    <td width="167" height="23">
                      <div align="left">

<input type="checkbox" name="checked[<?php print $MASSEGES['id']; ?>]" value="<?php print $MASSEGES['id'];?>">                       
למחיקת הודעה סמן </div></td>

                    <td width="167"><div align="right"><?php echo $MASSEGES['name'];?></div></td>
                    <td width="30"><div align="right">:שם 

                    </div></td>

                    <td width="52"><div align="right"><?php echo $MASSEGES['id'];?>

                    </span></div></td>

                  </tr>

                  <tr>

                    <td height="23" colspan="3"><div align="right"><?php echo $MASSEGES['email'];?></div>

                      <div align="right"></div></td>

                    <td height="23"><div align="right">: נושא</div></td>

                  </tr>

                  <tr>

                    <td height="23" colspan="4"><p align="right">:הודעה</p>
                    <p align="right"><?php echo $MASSEGES['massage'];?></p>

                      <p align="right">----------------------------------------------------------------------------------- </p></td>

                  </tr>

              </table>

              <?php } ?>

            </div></td>

        </tr>

      </table> <input name="deletem" type="submit" id="deletem" value="מחק את ההודעות">
  </form>
      </td>

  </tr>

</table>
[/code]


Thanks in advance sorry for so long code didnt know how to sammorzing it .

Share this post


Link to post
Share on other sites
Don't forget to remove your database connection info when posting.

I'd suggest calling each of the checkboxes the same thing, something like [color=green]todelete[][/color] but with the value of [code=php:0]$MASSEGES['id'][/code] this way you'll end up with an array called [color=green]$todelete[/color] in php and you can use it something like this:

[code]<?php
$delete = implode(",", $todelete); // This creates a string of id's e.g. "1,4,8,"
$limit = count($todelete); // set a limit as a safety precaution

$sql = "DELETE FROM tablename WHERE id IN ($delete) LIMIT $limit";
$result = mysql_query($sql);
if ($result){
  echo "The following ID's were successfully deleted: $delete\n";
}
else {
  echo "There was an error deleting rows from the database\n";
}
?>[/code]

Regards
Huggie

Share this post


Link to post
Share on other sites
i did looked but matey .. id didnt worked iether way . i tryed it again now that i am a bit more awake and still nothing

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.