PHP form generates XML based on MYSQL query

Closed

Description

Hi,

I have a mysql table (see attached for sample). I need to query the database and transform the result into XML; this is to be done using PHP.

First, I need a PHP form that will allow me to select the date range that I want to query in the database (i.e. so that I can narrow down the number of months that the query is looking for. Then a Submit button that runs the query and generate an XML file.

In the database, dates are stored like 2010-03-01 (for march the 1st 2010) but the XML result needs to group all results for march and count them. It also needs to ignore any dates that are "01/01/0001"

The XML needs to look like this (see [url removed, login to view] for an example).

Using the attached sample table; I'd expect the following XML based on a query looking for results between January and May

<chart>

<chart_data>

<row>

<null/>

<string>January 2010</string>

<string>February 2010</string>

<string>March 2010</string>

<string>April 2010</string>

<string>May 2010</string>

</row>

<row>

<string>problem_approveddate</string>

<number>3</number>

<number>2</number>

<number>3</number>

<number>3</number>

<number>3</number>

</row>

<row>

<string>problem_knownerrordate</string>

<number>1</number>

<number>2</number>

<number>3</number>

<number>1</number>

<number>2</number>

</row>

<row>

<string>problem_closeddate</string>

<number>1</number>

<number>0</number>

<number>1</number>

<number>1</number>

<number>3</number>

</row>

</chart_data>

</chart>

Skills: MySQL, PHP, XML

See more: range query, submit button generates mysql query, mysql query xml, php form xml, the php group, null, mysql query, menu form, xml http, form submit xml, php databases, chart example, xml transform, menu select php, http form submit, narrow result, table based, mysql select xml, php xml table example, mysql database query form, based reference, chart 2010, xml file mysql sample, mysql query php, php submenu

Project ID: #783517

Awarded to:

netxpertindia

NetXpertIndia is a customer-specific service oriented company has got a Professional and creative team. We are the Professional Web Development Company having rich experience in Web design and development. Our team can More

$30 USD in 0 days
(86 Reviews)
6.8

6 freelancers are bidding on average $43 for this job

dagdya99

Ready to start now

$30 USD in 1 day
(115 Reviews)
6.7
mantislin

Hi sir, let me do it now! thanks, kimi.

$30 USD in 1 day
(129 Reviews)
6.6
MAnkita

Hello,Please refer your PMB.Thank you.

$100 USD in 1 day
(56 Reviews)
6.6
CCDeveloper

Can do it right away. Please contact me.

$35 USD in 0 days
(5 Reviews)
3.2
Ajun

Please check PMB

$30 USD in 0 days
(2 Reviews)
2.0