www.webdeveloper.com
Results 1 to 2 of 2

Thread: Add field to displaying mysql row

  1. #1
    Join Date
    Feb 2006
    Posts
    352

    Post Add field to displaying mysql row

    Good day to you all,
    I'm still learning the wicked database world and i found a piece of code which read and display a db table without me telling each colum totle and field name.

    Here is my code:

    PHP Code:

    ...
    if (!
    mysql_connect($db_host$db_user$db_pwd))
        die(
    "Can't connect to database");

    if (!
    mysql_select_db($database))
        die(
    "Can't select database");

    // sending query
    $result mysql_query("SELECT * FROM {$table}");
    if (!
    $result) {
        die(
    "Query to show fields from table failed");
    }

    $fields_num mysql_num_fields($result);

    echo 
    "<h1>Table: {$table}</h1>";
    echo 
    "<table border='0' id=\"table\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><tr>";
    echo 
    "<td id=\"title\">options</td>";
    // printing table headers
    for($i=0$i<$fields_num$i++)
    {
        
        
    $field mysql_fetch_field($result);
        echo 
    "<td id=\"title\">{$field->name}</td>";
    }
    echo 
    "</tr>\n";
    // printing table rows
    $s 0;
    while((
    $row mysql_fetch_row($result)) !== false){
        
    $s++;
        
        echo 
    "<tr>";
        echo 
    "<td id=\"fields".($s 1)."\"><a href=\"delete_table_row_db.php?id=" $s[id]. "\" title=\"DELETE : Row ID #:" $s[id] . "\"><img src=\"Template/Images/delete.png\" border=\"0\"/></a><INPUT TYPE=\"checkbox\" name=\"" $row['id'] . "\"></td>";

        
    // $row is array... foreach( .. ) puts every element
        // of $row to $cell variable
        
    foreach($row as $cell)
        
            echo 
    "<td id=\"fields".($s 1)."\">$cell</td>";

        echo 
    "</tr>\n";
    }
    mysql_free_result($result); 
    In the part :

    PHP Code:

    <td id=\"fields".($s 1)."\"><a href=\"delete_table_row_db.php?id=" $s[id]. "\" title=\"DELETE : Row ID #:" $s[id] . "\"><img src=\"Template/Images/delete.png\" border=\"0\"/></a><INPUT TYPE=\"checkbox\" name=\"" $row['id'] . "\"></td>"
    What i'm trying to do is to add options to the row, ex: delete, edit...

    My only problem is that I cannot find the var to put which would tell which row it is.

    Can somebody help me ?
    Thanks!
    That's why we are not alone on earth, to help each other !
    Let's REbuild that for ourselves !

  2. #2
    Join Date
    Mar 2010
    Posts
    2,803
    To display checkboxes on each row to give the user the option to select that row for deleting, I would do something like this:

    PHP Code:
    echo '<td align="center"><input  type="checkbox" name="chkDelUsers[]" value="'.$row['uniqueID_from db_table'].'" /></td>'
    This will send an array of checked checkboxes, called chkDelUsers, with values of the id to delete from the database.

    In the script that processes the form data I would have something like this (I haven't shown any validation code)

    PHP Code:
     
    //get the id's to delete
    $delMe $_POST['chkDelUsers'];
     
    foreach(
    $delMe as $key => $value) {
        
    //code to delete selected records
        
    $query 'delete from tableName where someColumn = "'.$value.'"';
        .
        .
        .

    Then when you redisplay the html table, the previously selected rows will be gone because they are no longer in the database.
    Last edited by tirna; 04-29-2010 at 06:03 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles