Em Andamento

Need PHP script to create MySQL record based on html form

need to write PHP script to use html form to create MySql record containing multiple files as well as text fields. some files or data are required some are optional. File names are the names of the files in the local FS. Files can be in Word or PDF. For each PDF file, a number of pages need to be calculated and stored in the table.

CREATE TABLE Data (

Field1 VARCHAR(16),

Field2 blob,

Field3 blob,

Field4 VARCHAR(16),

Field5 VARCHAR(16),

Field6 VARCHAR(16),

Field7 VARCHAR(16),

File1Name VARCHAR(128),

File1PageNumber INT,

File2Name VARCHAR(128),

File2PageNumber INT,

File3Name VARCHAR(128),

File3PageNumber INT,

File4Name VARCHAR(128),

File4PageNumber INT,

File5Name VARCHAR(128),

File5PageNumber INT,

RecordInsertionDate datetime DEFAULT NULL);

ColumnsToInclude indicates columns from Data that need to be included in the fill in html form.

CREATE TABLE ColumnsToInclude (

ColumnName varchar(64) DEFAULT NULL,

ColumnDescription varchar(128) DEFAULT NULL,

ColumnEditIndicator BOOLEAN DEFAULT FALSE,

ColumnFileIndicator BOOLEAN DEFAULT FALSE,

ColumnRequiredIndicator BOOLEAN DEFAULT FALSE,

RecordInsertionDate datetime DEFAULT NULL);

The first page of the form should look like this:

Please provide the following information:

Column1Description: Field 1 text box

Column2Description: Field 2 text box

Column3Description: Field 3 text box

Column4Description: Field 4

Prease prepare the following required files:

Column5Description:

Column6Description:

Please indicate which of the following optional files will be included:

Column1Description: checkbox

Column1Description: checkbox

Column1Description: checkbox

after that, each file needs to be uploaded on a separate page.

At the end, there should be preview of all data, including the link to uploaded files and submit button, which will create DB record.

Habilidades: Engenharia, Linux, MySQL, PHP, Gestão de projetos, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: php script null, php create table, create table php, fill in form word, calculated fields form, word to pdf create, php script create table, create pdf file, mysql script php pdf, php html form, php table pdf, write linux script, html pdf checkbox, linux mysql create, prepare html, html form data, html form submit link, html submit file, html table text table, php form create, submit form preview button, submit mysql page, html required checkbox, php script preview submit, mysql page number

Acerca do Empregador:
( 19 comentários ) United States

ID do Projeto: #3013534

Premiar a:

TopOfStack

See private message.

$34 USD em 1 dia
(162 Avaliações)
7.0

12 freelancers estão ofertando em média $28 para este trabalho

mentorvisionpak

See private message.

$34 USD em 1 dia
(34 Comentários)
6.0
ITPEOPLES

See private message.

$34 USD em 1 dia
(13 Comentários)
4.2
diaconsultancyvw

See private message.

$34 USD em 1 dia
(13 Comentários)
3.2
itsali0009

See private message.

$16.15 USD em 1 dia
(15 Comentários)
3.1
jack0stone

See private message.

$34 USD em 1 dia
(9 Comentários)
2.6
alienwebsl

See private message.

$32.3 USD em 1 dia
(6 Comentários)
2.7
krish7vw

See private message.

$29.75 USD em 1 dia
(13 Comentários)
2.3
chinthanapannila

See private message.

$19.98 USD em 1 dia
(2 Comentários)
0.0
rstripathi

See private message.

$32.3 USD em 1 dia
(0 Comentários)
0.0
amirthagdss

See private message.

$34 USD em 1 dia
(2 Comentários)
0.0
joinatanu

See private message.

$5.95 USD em 1 dia
(0 Comentários)
3.0