Results 1 to 2 of 2

Thread: deleting using javascript

  1. #1

    Thread Starter
    Member
    Join Date
    Jul 2011
    Posts
    55

    deleting using javascript

    hi all,
    i want javascript function to delete the selected records for the given php program below....
    also i am not getting field values in correct order one field is more than its field...
    kindly tell me how to do it......
    Code:
    <?php
    $host="localhost"; // Host name
    $username="root"; // Mysql username
    $password="";     // Mysql password
    $db_name="test"; // Database name
    $tbl_name="emp"; // Table name
    
    // Connect to server and select databse.
    mysql_connect($host, $username, $password)or die("cannot connect");
    mysql_select_db($db_name)or die("cannot select DB");
    $sql="SELECT * FROM emp";
    $result=mysql_query($sql);
    $count=mysql_num_rows($result);
    ?>
    <table width="400" border="0" cellspacing="1" cellpadding="0">
    <tr>
    <td><form name="form1" method="post" action="">
    <table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
    <tr>
    <td align="center" bgcolor="white"><strong>EmpNo</strong></td>
    <td align="center" bgcolor="white"><strong>EmpName</strong></td>
    <td align="center" bgcolor="white"><strong>Desig</strong></td>
    </tr>
    <?php
    while($rows=mysql_fetch_array($result, MYSQL_ASSOC))
    {
    
    ?>
    <tr>
    <td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
    <td bgcolor="#FFFFFF"><?php echo $rows['empno']; ?></td>
    <td bgcolor="#FFFFFF"><?php echo $rows['empname']; ?></td>
    <td bgcolor="#FFFFFF"><?php echo $rows['desig']; ?></td>
    </tr>
    <?php
    }
    ?>
    <tr>
    <td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
    </tr>
    <?php
    // Check if delete button active, start this
    if($_POST['delete'])
    {
    //print_r($_POST);
    //exit;
    for($i=0;$i<count($_POST['checkbox']);$i++)
    {
    $del_id = $checkbox[$i];
    $sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
    $result = mysql_query($sql);
    }
    
    // if successful redirect to delete_multiple5.php
    if($result){
    echo "<meta http-equiv=\"refresh\" content=\"0;URL=h_delete.php\">";
    }
    }
    mysql_close();
    ?>
    </table>
    </form>
    </td>
    </tr>
    </table>

  2. #2
    Frenzied Member
    Join Date
    Jan 2008
    Posts
    1,754

    Re: deleting using javascript

    Give your table an ID first then:

    Code:
    function deleteRow(i){
        document.getElementById('myTable').deleteRow(i)
    }

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width