Page 1 of 1

Write a .PHP file in your text editor

Posted: Sun Mar 20, 2011 6:57 pm
by ashurubal
Hi guys,
i am pretty New with .php.
Could Anyone suggest me anything on this topic.
any Idea or Programming code will be very beneficial.



<?xml version="1.0"?>
<financial_data>

<invoice>
<name>John Aldridge</name>
<company>HSBC</company>
<amount>5.50</amount>
<invoice_id>1</invoice_id>
</invoice>

<invoice>
<name>Sharon Messier</name>
<company>Barclays</company>
<amount>8.20</amount>
<invoice_id>2</invoice_id>
</invoice>

</financial_data>

-----

and a MySQL database


available which details the subtotals. There are two tables:

Table 1 is 'tblInvoice'
Table 2 is 'tblInvoiceItems'


mysql> SELECT * FROM tblInvoice;
+-----------+-------------+
| InvoiceID | InvoiceType |
+-----------+-------------+
| 1 | Computer |
| 2 | Software |
+-----------+-------------+
2 rows in set (0.00 sec)


mysql> SELECT * FROM tblInvoiceItems;
+----------------+----------------------+-----------------+--------+
| InvoiceItemsID | tblInvoice_InvoiceID | Description | Amount |
+----------------+----------------------+-----------------+--------+
| 1 | 1 | Fixing computer | 1 |
| 2 | 1 | Reports | 2.5 |
| 3 | 1 | Consulting | 2 |
| 4 | 2 | Programming | 4.2 |
| 5 | 2 | Help with Word | 3 |
| 6 | 2 | Consulting | 1 |
+----------------+----------------------+-----------------+--------+
6 rows in set (0.00 sec)



Generate a visual report in HTML that displays the name of the recipient,
which company they are from, the type of invoice, and a break-down of
the item details.

Write a .PHP file in your text editor on your local machine.

Re: Write a .PHP file in your text editor

Posted: Sun Mar 20, 2011 7:05 pm
by John Cartwright
Homework?