Lukket

Budget Form filler

** posted on March 1st

What do I need?

=================

A simple script wrote in PHP that allow fill a form and storage the results in a MySQL database.

Where does the scripts and files should be placed?

=======================================

All the scripts and files should be paleced at [url removed, login to view] (I can do that, once received the source)

- [url removed, login to view]: script that allow fill anew form, using the information at [url removed, login to view] file

- [url removed, login to view]: script that allow search at planette_abook database / address_book table and select ONE customer from the table.

Data base structure and details:

Database name: planette_abook

username: planette_abook

Password: wp47shwn53

location: localhost

table: address_book

Fields:

customer_id: Unique ID

company: Customer Company Name (text)

address: Customer address (text)

tel: Customer Telephone (text)

mobile: Customer Mobile phone (text)

contact: Customer contact name(text)

e-mail: Customer e-mail (text)

type: Customer type (text)

table: insp_generals

Fields:

date: date of the inspection

insp_id: Inspection ID

customer_id: Customer Id (linked with ID at address_book table)

inspector: Inspector name

ticket; ticket number

notes: Inspection note

table: insp_details

Fields:

insp_id: Inspection ID

item_detail: Item detail

item_cost: Item cost

item_qty: Item qty

item_total: Item total cost (cost*qty)

[url removed, login to view] description.

====================

This script should allow fill a new, save or retrive an Inspection form, search and select a customer from addres_book table, update customer information (Company name and Contact name do not be changed). This script should use the information [url removed, login to view] to show the appropiates field in the form.

- Search Customer: Should browse fields company and contacts from adress_nbook table ordered by company + customer, allow a simple search text box where customer can refine the search with an string as part of company or contact. Customer must be able to select ONE record and return to the main screen.

- Fields company and contact must not be editable, the other fields shon should be edited and Updated at the addres_book table when "Save & Sent by e-mail" is pressed at the end of the process.

- No. es the Insp_Id and must be an unique refrence generetade by the script, it is not an editable field.

- The body of the form should be retrived from the [url removed, login to view] where is storage the caption and the price (both of them not editable). The script should calculate qty * cost in each item and totalize this at the end of the screen.

- The Search text box at the up right side of the screen is used to search this string as part of any of each fields of the table insp_generals, allowing to select one of the shown records an refresh the result in the main screen. All the refresh items should be editable (NOT Company, NOT contact). If Saved, insp_general fields, insp_details field and address-book fields must be updated

NOTE that when ever Save & Sent by e-mail be pressed insp_general fields, insp_details field and address-book fields must be updated.

Add Customer button should execute the screen [url removed, login to view] not developed at this project (this script allow to insert a new record to the address_book table)

[url removed, login to view] Syntax description

=============================

This file should be used to generate the form information that is not static, at th middle section of the screen.

- If the line begins with < the script should also show the content as the line as reference, this is not a field of the form, is only a line label.

- Other case the first part of the line is the caption, the second (after a colom) is the cost.

- The section finish with <>.

- After that there is a final line with the e-mail address where the form should be sent.

What we expect to receive:

=======================

- [url removed, login to view]

- [url removed, login to view]

- other files (if needed)

- written instructions about how to install

Attached files:

Ins

Færdigheder: HTML, MySQL, PHP, Shell Script, Web Design

Se mere: mysql php form filler script, what is search string, what is record in data structure, what is a search string, what does it cost to design a website, update data base by form & php, table data structure, string in data structure, string data structure, search text string, price of design label, price label design, php form search mysql database, phone case design website, phone book data structure, how to process the data base, how to design website using phone, how to design a php website on a mobile phone, finish line com, e book company be, design phone case website, design label price, data structure reference book, data structure in c notes, data structure book

Om arbejdsgiveren:
( 3 bedømmelser ) Panama, United States

Projekt-ID: #969088

9 freelancere byder i gennemsnit $188 for dette job

agilesols

lets do it....

$250 USD in 8 dage
(221 bedømmelser)
7.6
zeke

Dear Customer! I am an expert PHP/MySQL developer with over 6 years of experience and very interested in your project. Ready to start immediately and finish as soon as possible. My bid is for fast professional servi Mere

$200 USD in 2 dage
(175 bedømmelser)
7.1
mantislin

Hi sir, can do this for you!

$250 USD in 6 dage
(157 bedømmelser)
6.7
stefanache

Hello, Please see PMB. Thanks.

$120 USD in 4 dage
(16 bedømmelser)
5.0
joseluisCC

Dear Sir. Let me show you my proposal. Estimado señor. Déjeme hacerle llegar mi propuesta.

$220 USD in 4 dage
(9 bedømmelser)
4.3
triadb

Hi, please check PM

$150 USD in 14 dage
(13 bedømmelser)
4.0
Lauris79

Details sent in PM

$200 USD in 4 dage
(3 bedømmelser)
3.4
romesh2005

Hi, Lets start. Thanks!!

$150 USD in 2 dage
(6 bedømmelser)
3.0
powerplugin

I can help you.

$150 USD in 6 dage
(0 bedømmelser)
0.0