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.
Write a .PHP file in your text editor
Moderator: General Moderators
- John Cartwright
- Site Admin
- Posts: 11470
- Joined: Tue Dec 23, 2003 2:10 am
- Location: Toronto
- Contact: