PHP drop down list from MySQL database that will post to another table.

I am very new to PHP and am looking for some help with a problem that I am facing. I currently have a form which post to a table in MySQL.

At the moment all the fields (apart from date) have to be inputted manually.

I would like to be able to have a number of the fields as selection drop down boxes, populated from seperate tables in the database. This will aid the user and provide uniform data that can easily be analysed.

I have spent days trying to find the exact code to perform this task, so would be grateful if somebody has an answer for me.

Here is the code so far, (the fields I wish to have as drop down boxes are Model, Repair Carried Out & Work Source:

Expand|Select|Wrap|Line Numbers

 
<head>

<script type="text/javascript" src="js/jquery.js" /></script>

    <script type="text/javascript" src="js/jquery-ui.js" /></script>

<script type="text/javascript" src="js/lisa.js" /></script>

  <link href="css/jquery.css" media="screen" rel="stylesheet" type="text/css" />
 
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Untitled Document</title>

<style type="text/css">

<!--

body {

    margin: 0; /* it's good practice to zero the margin and padding of the body element to account for differing browser defaults */

    padding: 0;

    text-align: center; /* this centers the container in IE 5* browsers. The text is then set to the left aligned default in the #container selector */

    color: #000000;

    font-family: Arial, Helvetica, sans-serif;

    font-size: 100%;

    background-color: #FFF;

}

.oneColFixCtrHdr #container {

    width: 780px;  /* using 20px less than a full 800px width allows for browser chrome and avoids a horizontal scroll bar */

    background: #FFFFFF;

    margin: 0 auto; /* the auto margins (in conjunction with a width) center the page */

    border: 1px solid #000000;

    text-align: left; /* this overrides the text-align: center on the body element. */

}

.oneColFixCtrHdr #header {

    padding: 0 10px 0 20px;  /* this padding matches the left alignment of the elements in the divs that appear beneath it. If an image is used in the #header instead of text, you may want to remove the padding. */

    background-color: #FFF;

}

.oneColFixCtrHdr #header h1 {

    margin: 0; /* zeroing the margin of the last element in the #header div will avoid margin collapse - an unexplainable space between divs. If the div has a border around it, this is not necessary as that also avoids the margin collapse */

    padding: 10px 0; /* using padding instead of margin will allow you to keep the element away from the edges of the div */

}

.oneColFixCtrHdr #mainContent {

    padding: 0 20px; /* remember that padding is the space inside the div box and margin is the space outside the div box */

    background: #FFFFFF;

    text-align: right;

}

.oneColFixCtrHdr #footer {

    padding: 0 10px;

    background-color: #FFF;

}

.oneColFixCtrHdr #footer p {

    margin: 0; /* zeroing the margins of the first element in the footer will avoid the possibility of margin collapse - a space between divs */

    padding: 10px 0; /* padding on this element will create space, just as the the margin would have, without the margin collapse issue */

}

-->

</style>
 
</head>
 
<body class="oneColFixCtrHdr">
 
<div id="container">

  <div id="header">

    <h1>Header</h1>

  <!-- end #header --></div>

  <div id="mainContent">

    <form method="POST" action="download_pdf.php" name="input" onSubmit="return validate()">

     <table width="70%" border="0" align="center">

       <tr>

         <td>Owners Name</td>

         <td><input type="text" name="Owners_Name" /></td>

       </tr>

       <tr>

         <td>Model </td>

         <td><input type="text" name="Model" /></td>

       </tr>

       <tr>

         <td>Reg No. </td>

         <td><input type="text" name="Reg_No" /></td>

       </tr>

       <tr>

         <td>Mileage </td>

         <td><input type="text" name="Mileage" /></td>

       </tr>

       <tr>

         <td>Repairs Carried Out </td>

         <td><input type="text" name="Repairs_Carried_Out" /></td>

       </tr>

       <tr>

         <td>Repair Date </td>

         <td><input type="text" name="Repair_Date" id="Repair_Date" /></td>

       </tr>

       <tr>

         <td>Invoice Number </td>

         <td><input type="text" name="Invoice_Number" /></td>

       </tr>

       <tr>

         <td>VIN (17 digits)</td>

         <td><input type="text" name="VIN" /></td>

       </tr>

       <tr>

         <td>Total Repair Cost </td>

         <td><input type="text" name="Total_Repair_Cost" /></td>

       </tr>

       <tr>

         <td>Paint Cost </td>

         <td><input type="text" name="Paint_Cost" /></td>

       </tr>

       <tr>

         <td>Labour Cost </td>

         <td><input type="text" name="Labour_Cost" /></td>

       </tr>

       <tr>

         <td>Parts Cost </td>

         <td><input type="text" name="Parts_Cost" /></td>

       </tr>

       <tr>

         <td>Work Source </td>

         <td><input type="text" name="Work_Source" /></td>

       </tr>

     </table>

     <br/>

     <br/>

      <input type="submit" value="Save" /></form> 
 
  <!-- end #mainContent --></div>

  <div id="footer">

    <p>Footer</p>

  <!-- end #footer --></div>

<!-- end #container --></div>

</body>

</html>

May 5 '10 #1

Subscribe Post Reply

2463

dlite922

1,584

Expert 1GB

Do you know how to connect and query a mysql DB from PHP?

If not click this: lmgtfy.com?q=PHP%20MySQL%20Tutorial

Let me know if you get stuck anywhere,

Dan

May 6 '10 #2

Similar topics

dynamic drop-down list in array

by: Jonny Tango | last post by:

Hello everyone. Q. How do I create a dynamically-generated drop-down list for use in an array. I'm using PHP with a MySQL database (through phpMyAdmin) My database table is called...

PHP

Updating drop-down list, based on selection from another d-d list

by: CJM | last post by:

Not sure if this is entirely on-topic.... I would ideally like to present an initial list based on one DB table. The user selects an item, and the 2nd list is updated to show items from the DB...

ASP / Active Server Pages

Updating The Drop-Down List On One Window From Another

by: Robert Nurse | last post by:

Hi All, I'm trying to alter the contents of a drop-down (select) list on the parent window from a child window in IE 6. After opening the child window, I set its opener to reference the parent...

Javascript

table only not form and data access page, drop down list to drop down list

by: jcombalicer | last post by:

How will you make a drop down list that rely information from another drop down list with the help of row source, sql and query not with the of form, pages and vba. Every department has...

Microsoft Access / VBA

Populating a drop down list from the db

by: lewindha | last post by:

Hey guys I'm trying to populate a drop down list with values from a db table. When I view the page, the drop list is empty. Here is the code: private void populateClients() { string...

C# / C Sharp

Displaying drop-down list boxes for every row in a DataGrid \ Repe

by: Eric Dan | last post by:

Hi, Even tough I was able to implement what I want in a weird and non efficient way, I would like to get an opinion what is the right way to achieve my task: Scenario: â€¢ Display a DataGrid...

ASP.NET

drop down list in ASP.Net

by: bbdobuddy | last post by:

Hi, I have a problem that maybe you can help me with. I am pulling values from a database table and I don't know how to set the drop down list so it will show the specific value that I pulled...

Visual Basic .NET

Filling drop down list from database

by: jaeden99 | last post by:

I have a two drop down list box. The first contains district name(district id is the value) and the the second will contain the user name based on the district selected in the first drop down list....

.NET Framework

asp drop down list based on table

by: deerick | last post by:

Hi there I want to know how to add a drop down list based on value from a table in an asp form. Then I want the user to be able to submit the form, and the drop down list value that they have...

ASP / Active Server Pages

getAttribute of value from drop down list

by: maminx | last post by:

I have this script... var td = document.createElement('td'); var p = document.createElement('p'); var label = document.createElement('label'); var span =...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General