How to how a table with previously collected data in a custom form page?

Question

I have a table named "Table1" in my Drupal, where I added fields by getting the inputs via form. The form is created by custom module. My next requirement was to again create another form, but this time I want to show the user by means of a Table format, the previously collected data in the form page itself. But I got stuck in this part.

The idea is: I want to bring the contents of "Table1" having attributes "empid" and "empname" in the right side of Form Page, so that the user can check the contents and enter current input accordingly. How is it possible?

Answer 1

Yes you can do this. First of all you need to fetch the 'Table1' data in top of the form.

$query = db_select('Table1' , 'tb');
    $query->fields('tb');
    $results = $query->execute()->fetchAll();

//table structure

$Details = '<table><tr><td style="width:15%;"></td><td style="width:30%;">Employee Id</td><td style="width:10%;">Employee Name</td></tr>';
    foreach($results as $res)
    {
        $Details .= '<td>'.$res->empid.'</td>';
        $Details .= '<td>$'.$res->empname.'</td>';  
    }

$form['details'] = array(
        '#type' => 'item',
        '#markup' => $Details,
        '#suffix' => '</div>'
    );

$form['eid'] = array(
    '#type' => 'textfield' ,
    '#title' => t('Employee Id'),
    '#maxlength' => 45,
    '#required'=> true,
);
$form['ename'] = array(
    '#type' => 'textfield' ,
    '#title' => t('Employee Name'),
    '#maxlength' => 45,
    '#required'=> true,
);  


 $form['submit'] = array(
        '#type' => 'submit' ,
        '#value' => 'Submit'
    );