select from dropdown list containing sql data

Question

Pls help. I am working on a php project and this requires adding and altering data from the SQL database. There are two tables involved with this: emp which contains employee details and pay containing payroll records for each employee.

I would like to have a dropdown list containing all employee names (empname) from the database. Below the list is a form where the user shall input the payroll details. These details will then be saved into the SQL pay table corresponding to the employee name selected.

I've tried searching over the web but it doesn't seem to similar to my problem. How should I do this? Thanks!

Do you want to create a simple ddl using db table?

Muhammad Zeeshan
– Muhammad Zeeshan

2011-05-27 05:57:17 +00:00
Commented May 27, 2011 at 5:57 — Muhammad Zeeshan
– Muhammad Zeeshan, Commented May 27, 2011 at 5:57

Deele · Accepted Answer · 2011-05-27 06:08:39Z

1

Wihtout knowing any more details about your datbase, table structure and other stuff, this is closes that I could get.

<?php
/* Connect to SQL and retreive data */
$sqlConf = array('u'=>'username','p'=>'password','h'=>'localhost','d'=>'myDatabase');
$sqlCon = mysql_connect($sqlConf['h'], $sqlConf['u'], $sqlConf['p']);
if ($sqlCon) {
    $emp = array();
    mysql_select_db($sqlConf['d'], $con);
    $result = mysql_query("SELECT * FROM emp");
    while($row = mysql_fetch_array($result)) { $emp[] = $row; }
    mysql_close($sqlCon);
}
/* Generate select box contents */
$html = '<select name="emp">';
$html .= '<option>Employee list</option>';
if (!empty($emp)) {
    foreach ($emp as $k => $v) {
        $html .= '<option value="'.$v['empid'].'">'.$v['empname'].'</option>';
    }
}
$html .= '</select>';
/* Output */
echo $html;
?>

answered May 27, 2011 at 6:08

Deele

3,6792 gold badges35 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ben G · Accepted Answer · 2011-05-27 05:56:08Z

0

Sounds like you need to learn some basic php/SQL. The basic outlines of the problem are:

Query the dropdown list from SQL, and display in an option-select.
When they the form submit, send a corresponding query to update the database.

Is there some particular aspect of this problem that you can't get past?

answered May 27, 2011 at 5:56

Ben G

26.9k35 gold badges112 silver badges177 bronze badges

Comments

inquam · Accepted Answer · 2011-05-27 05:59:31Z

0

This can be solved in any number of ways and the overall structure, design and layout of your application would dictate which route to go.

You could have classes that represent your database objects, classes that represent your forms, you could print your forms by mixing php and html like a crazy person and so on and so on.

Then it all depends on if you will be using ajax or not.

So give us a bit more information about how your application is designed and that will probably help.

If you have not started at all I would suggest you to look into some of the many frameworks. Zend Framework or Symphony for example. They have a good way of handling db abstractions and forms creation etc.

answered May 27, 2011 at 5:59

inquam

12.9k17 gold badges66 silver badges106 bronze badges

2 Comments

Loop Designs Over a year ago

I've already started. It's almost done. I just wanted to give the dropdown list a try coz what i did was to display a list of all employees and all there is to do is to click on the radio button corresponding to the empID and the user will just have to click an edit or delete button. But having to show the entire list of employees seem to mace the screen crowded so i'm looking for other options, like the dropdown list

inquam Over a year ago

In the same fashion you loop through the employees and create the radiobuttons you could then create <option> tags to your drop down instead.

Collectives™ on Stack Overflow

select from dropdown list containing sql data

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related