deleting records

Discussion in 'JavaScript and AJAX' started by ravi951, Aug 17, 2011.

  1. ravi951

    ravi951 New Member

    Joined:
    Aug 9, 2011
    Messages:
    10
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    web developer
    Location:
    hyderabad
    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. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,645
    Likes Received:
    87
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    http://blog.pradeep.net.in
    How is the order important here? Does this code work??
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice