Editing MySQL record with PHP

nasirmunir · March 23rd, 2009, 11:17 AM

Situation:
There is a page that displays information about a user in a tabular form.
I want to create an edit link across each record for a user to update information.

Question: how do I associate that "edit" link with a particular record. The record being generated from the database?

eg: a user click on users information, that gives bunch of records. Now the user wants to edit a particular record. The user clicks on that record, using some edit link, and the edit page opens up, with fields filled out from the previous page.

This is what I have done: on the user information page I am displaying information by using getUsers() function that basically joins three tables and displays user id, name, and contact. My problem is how can I associate that edit button/link to a particular row, or in other words how can I uniquely identify that row? If I could identify that then I can use $_POST variable to generate a query by passing that as a parameter and then displaying result accordingly. Problem is how to get that row by some identifier? Any help would be appreciated. Thanks.

Code:

<?
                        $users = getUsers() ;
                        while($userReport = mysql_fetch_assoc($users)){
                        //var_dump($userReport) ;
                        ?>
                        <tr>
                            <td><?=$userReport["concat(u.first_name, ' ', u.last_name)"]?></td> 
                            <td><?=$userReport['project_name']?></td>
                            <td><?=$userReport['contact']?></td>
                            <td ><input type="submit" value="Edit"/></td>
                        </tr>
                        <?
                        }
                        ?>

anees_muhd · March 24th, 2009, 12:34 AM

You can do this in many ways

In all, you need an Identifier to recognize each User(Record)
Hope you have an ID to do this in table

So your while loop will be

while($userReport = mysql_fetch_assoc($users)){
//var_dump($userReport) ;
?>
<tr>
<td><?=$userReport["concat(u.first_name, ' ', u.last_name)"]?></td>
<td><?=$userReport['project_name']?></td>
<td><?=$userReport['contact']?></td>
<td ><a href="edit_user.php?id=<?=$userReport['id']
?>">Edit</a></td>
</tr>
<?
}

So that when you click on Edit link of a user it calls the edit_user.php with a GET variable id contains its identifier.

In another method you can pass the Id as a POST Variable.
Here we need to do this using Javascript, with the help of a hidden variable

PHP Code:


			
<script language="javascript">
    function edit_user(user_id) {
        document.getElementById('user_id_for_edit').value = user_id;
        document.frm_details.submit();
    }
</script>
    <form name="frm_details" action="edit_user.php" method="post">
    <input type="hidden" name="user_id_for_edit" id="user_id_for_edit" value="" />
    <?
    $users = getUsers() ;
    while($userReport = mysql_fetch_assoc($users)){
    //var_dump($userReport) ;
    ?>
    <tr>
        <td><?=$userReport["concat(u.first_name, ' ', u.last_name)"]?></td> 
        <td><?=$userReport['project_name']?></td>
        <td><?=$userReport['contact']?></td>
        <td><a href="javascript:edit_user('<?=$userReport['id']?>')">Edit</a></td>
    </tr>
    <?
    }
    ?>
    </form>

(Code not Tested!)

Regards
Anees