Delete MySql Rows Problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • imarkdesigns
    New Member
    • Jul 2007
    • 46

    #1

    Delete MySql Rows Problem

    Hello everyone.. a newbie programmer here wants to ask why is my codes for deleting rows from my databse won't work.... seems that this codes spread to the net and no one refuse to correct it...

    can someone correct this...

    #-------

    <!-- Editable Area -->
    <?php

    include ("../dbconnection/connect.php");

    $tbl_name="sche dule"; // Table name

    mysql_connect(" $host", "$username" , "$password" )or die("cannot connect");
    mysql_select_db ("$db_name") or die("cannot select DB");

    $sql="SELECT * FROM $tbl_name";
    $result=mysql_q uery($sql);

    $count=mysql_nu m_rows($result) ;

    ?>

    <?php
    while($rows=mys ql_fetch_array( $result)){
    ?>
    <form name="form1" action="" method="post" enctype="multip art/form-data">
    <table id="alter_rows " align="center" cellpadding="0" cellspacing="0" >
    <tr>
    <td align="center" class="adminche ckbox"> <input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"> </td>
    <td class="admindat e"> <? echo $rows['date']; ?> </td>
    <td class="admintim e"> <? echo $rows['id']; ?> </td>
    <td class="admineve nts"> <? echo $rows['events']; ?> </td>
    <td class="adminven ue"> <? echo $rows['venue']; ?> </td>
    <td class="adminloc ations"> <? echo $rows['locations']; ?> </td>
    </tr>

    </table>
    <?php
    }
    ?>
    <!-- Editable Area -->
    <table cellpadding="0" cellspacing="0" >
    <tr>
    <td><input name="delete" id="delete" type="submit" value="Delete Schedule" /></td>
    </tr>
    </table>
    <?
    // Check if delete button active, start this

    //$delete = $_REQUEST['delete'];
    //
    if($delete){
    for($i=0;$i<$co unt;$i++){
    $del_id = $checkbox[$i];
    $sql = "DELETE FROM schedule WHERE id='$del_id' LIMIT 1";
    $result = mysql_query($sq l);
    }

    // if successful redirect to delete_multiple .php
    if($result){
    echo "<meta http-equiv=\"refresh \" content=\"0;URL =deleterow.php\ ">";
    }
    }
    mysql_close();
    ?>
    </form>


    ------#

    when a DELETE button hits nothing happens...
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    Originally posted by imarkdesigns
    Hello everyone.. a newbie programmer here wants to ask why is my codes for deleting rows from my databse won't work.... seems that this codes spread to the net and no one refuse to correct it...

    can someone correct this...

    #-------

    <!-- Editable Area -->
    <?php

    include ("../dbconnection/connect.php");

    $tbl_name="sche dule"; // Table name

    mysql_connect(" $host", "$username" , "$password" )or die("cannot connect");
    mysql_select_db ("$db_name") or die("cannot select DB");

    $sql="SELECT * FROM $tbl_name";
    $result=mysql_q uery($sql);

    $count=mysql_nu m_rows($result) ;

    ?>

    <?php
    while($rows=mys ql_fetch_array( $result)){
    ?>
    <form name="form1" action="" method="post" enctype="multip art/form-data">
    <table id="alter_rows " align="center" cellpadding="0" cellspacing="0" >
    <tr>
    <td align="center" class="adminche ckbox"> <input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"> </td>
    <td class="admindat e"> <? echo $rows['date']; ?> </td>
    <td class="admintim e"> <? echo $rows['id']; ?> </td>
    <td class="admineve nts"> <? echo $rows['events']; ?> </td>
    <td class="adminven ue"> <? echo $rows['venue']; ?> </td>
    <td class="adminloc ations"> <? echo $rows['locations']; ?> </td>
    </tr>

    </table>
    <?php
    }
    ?>
    <!-- Editable Area -->
    <table cellpadding="0" cellspacing="0" >
    <tr>
    <td><input name="delete" id="delete" type="submit" value="Delete Schedule" /></td>
    </tr>
    </table>
    <?
    // Check if delete button active, start this

    //$delete = $_REQUEST['delete'];
    //
    if($delete){
    for($i=0;$i<$co unt;$i++){
    $del_id = $checkbox[$i];
    $sql = "DELETE FROM schedule WHERE id='$del_id' LIMIT 1";
    $result = mysql_query($sq l);
    }

    // if successful redirect to delete_multiple .php
    if($result){
    echo "<meta http-equiv=\"refresh \" content=\"0;URL =deleterow.php\ ">";
    }
    }
    mysql_close();
    ?>
    </form>


    ------#

    when a DELETE button hits nothing happens...
    I'm going to have to copy this to the PHP forum as well.

    Comment

    • dafodil
      Contributor
      • Jul 2007
      • 389

      #3
      Please check if this variable exists in the file you included:
      $db_name

      I suggest you to use this after you delete instead of detecting $result.
      [code=php]

      if((mysql_affec ted_rows()!=0)& &(mysql_affecte d_rows()!=-1)){
      //your statements goes here
      echo "delete successful!"

      }
      [/code]

      Comment

      • imarkdesigns
        New Member
        • Jul 2007
        • 46

        #4
        Originally posted by dafodil
        Please check if this variable exists in the file you included:
        $db_name

        I suggest you to use this after you delete instead of detecting $result.
        [code=php]

        if((mysql_affec ted_rows()!=0)& &(mysql_affecte d_rows()!=-1)){
        //your statements goes here
        echo "delete successful!"

        }
        [/code]

        looks working on the live site... but not in localhost...??

        um, is there any problem in my localhost or something?
        [i need more rice to eat before i totally understand this LOL!]

        .. and yes i include the db_name...

        Comment

        • mwasif
          Recognized Expert Contributor
          • Jul 2006
          • 802

          #5
          You have 2 problems with the code
          1. Wrong positioning of <form> tag. It should be outside while() and should not contain enctype="multip art/form-data" if you not uploading a file e.g.
            [PHP]<form name="form1" action="" method="post">
            <?php
            while($rows=mys ql_fetch_array( $result)){
            ?>
            <table id="alter_rows " align="center" cellpadding="0" cellspacing="0" >[/PHP]
          2. Change [PHP]if($delete)[/PHP] to [PHP]if(isset($_POST["delete"]))[/PHP]. I am sure live server has register_global s on.

          Comment

          • imarkdesigns
            New Member
            • Jul 2007
            • 46

            #6
            yeah i guess...

            but in the live site it is working... and in my local server where i use xampp, its not working...

            well, it seems ok in the live other than local server... thanks for the help guys! you rock all !!

            Comment

            • dafodil
              Contributor
              • Jul 2007
              • 389

              #7
              Originally posted by imarkdesigns
              yeah i guess...

              but in the live site it is working... and in my local server where i use xampp, its not working...

              well, it seems ok in the live other than local server... thanks for the help guys! you rock all !!
              I think you need to configure something in your local server.
              Post again if you have problems.

              Comment

              Working...