Em Andamento

PHP function shound generate a table in HTML (PHP), which would display selected rows and columns from mysql tbl

Need a PHP function which would render a MySQL table as HTML table. The function will be called like this:

rendertable($table, $query, $ColumnsToInclude)

If $table mysql table with data is not null, $query is not used. If not, mysql $query has to be run on the current DB. $ColumnsToInclude is table listing all the columns in the MySQL $table or $query result to be included in the HTML table.

## Deliverables

Need a PHP function which would render a MySQL table as HTML table. The function will be called like this:

rendertable($table, $query, $ColumnsToInclude)

If $table mysql table with data is not null, $query is not used. If not, mysql $query has to be run on the current DB. $ColumnsToInclude is table listing all the columns in the MySQL $table or $query result to be included in the HTML table. The $ColumnsToInclude has the following format:

CREATE TABLE ColumnsToInclude (

ColumnName varchar(64) DEFAULT NULL,

ColumnDescription varchar(128) DEFAULT NULL,

RecordInsertionDate datetime DEFAULT NULL);

When HTML table is created, it should look like this for all columns from $table or $query result that are in ColumnsToInclude:

Column1 Description | column1row1 | column1row2 | column1row3 | column1row4 |

Column2 Description | column2row1 | column2row2 | column2row3 | column2row4 |

Column3 Description | column3row1 | column3row2 | column3row3 | column3row4 |

Column4 Description | column4row1 | column4row2 | column4row3 | column4row4 |

Column5 Description | column5row1 | column5row2 | column5row3 | column5row4 |

The order of columns should be the same as ColumnsNames in ColumnsToInclude. If there is column in ColumnsToInclude with ColumnName "color", then the color of the corresponding column in the HTML table should be the color in the column 'color' of the correspnding row in the data table. The color value will be in format #FFFFFF. If the color value in the data table is NULL, then the color should be white.

If ColumnName in ColumnsToInclude ends with 'URL', then the data corresponding to the previous ColumnName in the ColumnsToInclude should be linked using the URL in the column of the data table corrsponding to the ColumnName in ColumnsToInclude ending with 'URL'.

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

Ver mais: php function for, php create table, create table php, rows, query table, php function , mysql query, html table, html php, php data table, generate html, format html table, mysql create table data, html create table, create table html, create table using, datetime, function order, tbl, display table, mysql create table, html table project, value management, php current url, table management php

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

ID do Projeto: #3000517

Premiar a:

aczireonline

See private message.

$25.5 USD em 2 dias
(36 Avaliações)
5.0

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

newgroup4u

See private message.

$34 USD in 2 dias
(137 Comentários)
7.4
xsixer

See private message.

$12.75 USD in 2 dias
(124 Comentários)
6.0
sunilexpert

See private message.

$21.25 USD in 2 dias
(68 Comentários)
5.9
dzmitrij

See private message.

$34 USD in 2 dias
(71 Comentários)
5.9
NeoNoXtraOrdnry

See private message.

$25.5 USD in 2 dias
(87 Comentários)
5.7
AyCoder

See private message.

$34 USD in 2 dias
(131 Comentários)
5.5
natedivine

See private message.

$34 USD in 2 dias
(46 Comentários)
5.3
robweb2009

See private message.

$34 USD in 2 dias
(99 Comentários)
5.1
edreamzinc

See private message.

$34 USD in 2 dias
(24 Comentários)
5.1
engmalaa

See private message.

$34 USD in 2 dias
(22 Comentários)
4.4
setiawanutama

See private message.

$25.5 USD in 2 dias
(57 Comentários)
4.3
WebConcept

See private message.

$28.9 USD in 2 dias
(8 Comentários)
3.8
vw7346251vw

See private message.

$34 USD in 2 dias
(16 Comentários)
3.7
ninoeu

See private message.

$34 USD in 2 dias
(20 Comentários)
3.3
vlaervw

See private message.

$34 USD in 2 dias
(9 Comentários)
3.2
sinsopevw

See private message.

$21.25 USD in 2 dias
(6 Comentários)
1.5
danursoviciu

See private message.

$12.75 USD in 2 dias
(3 Comentários)
1.2
praveenmathews

See private message.

$28.05 USD in 2 dias
(3 Comentários)
0.2