Problem. Write/run a PHP script that lists an input user's transactions in a 'nested' fashion as illustrated by the output below. This listing feature will be one of the user 'services' provided in your Assignment 01 project.

1. Give an image of the PHP code. (large enough to read)
2. Package the retrieve and display algorithm as a function.

The output is as illustrated.

Here the program inputs for my database tables were bert2 and 888, the ucid and password respectively. (Use you own different data.) The output lists for each one of the input user's accounts, the transactions for that account.

Use the HTML

tag as a line separator as shown.

The contents should be in bold and italic font as shown. The $ signs are required.

Your snapshot of the output should include the browser URL.

--------------------------------------------------------------------------------------

bert2 001 balance: $150.00 most recent

$10.00 timestamp mail copy: 'N'

$90.00 timestamp mail copy: 'Y'

$50. 00 timestamp mail copy: 'N'

--------------------------------------------------------------------------------------

bert2 002 balance: 400.00 most recent

$350.00 timestamp mail copy: 'N'

$50.00 timestamp mail copy: 'Y'

--------------------------------------------------------------------------------------

This uses phpMyAdmin as the data base, this is my transaction table that the php code needs to get its info from. The code needs to mimic the example layout above but using my table.

Twith Fium Pre + - X + NIITSIMI T . Indee Awet Verice IS 2000 Di Cw Pric cybe In Nic m 140 In w x W c w eb.niji.olumsalphpMyAdmirvindecohotoke-8.6545047060061bd4d761x92/ MAURL-22sql.php?domd488&table-transactions server=1&target=&token=6986:5450470600611017602 phpMyAdmin Browse Structure Sou Search Insert Export Import Operations Triggers soll nadu Showing rows 0-415 total. Query took 0.0006 seconds) SELECT * FROM 'transactions Recent Free mud83 - New + Ons + transactions + Us Profiling [InlineEditExplain SQL11 Create PHP Code 1 Refresh Number of rows. 25 Fierrows. Search this table Sort by key None + Options - ucid account amount timestamp mail Lell i Copy Delete mot 001 10.00 2020 01 25 13 45:30 Y D FG Coy Deli md132 001 1000 2020-01-25 14 53 55 Y D Edit Copy Delete md488 002 5.00 2020-01-25 06.3642 N D Lot fi Copy Delete md403 002 50 2020 01 26 14 54:19 N D EG Cony Delete md188 02 1500 2020-02-13 1657 15 Y Check All With selected Change Delete Export Number of rows: 25 iter row: Search this tablo Query results operations Print vice Print view with full text) Export Display chart Create view Twith Fium Pre + - X + NIITSIMI T . Indee Awet Verice IS 2000 Di Cw Pric cybe In Nic m 140 In w x W c w eb.niji.olumsalphpMyAdmirvindecohotoke-8.6545047060061bd4d761x92/ MAURL-22sql.php?domd488&table-transactions server=1&target=&token=6986:5450470600611017602 phpMyAdmin Browse Structure Sou Search Insert Export Import Operations Triggers soll nadu Showing rows 0-415 total. Query took 0.0006 seconds) SELECT * FROM 'transactions Recent Free mud83 - New + Ons + transactions + Us Profiling [InlineEditExplain SQL11 Create PHP Code 1 Refresh Number of rows. 25 Fierrows. Search this table Sort by key None + Options - ucid account amount timestamp mail Lell i Copy Delete mot 001 10.00 2020 01 25 13 45:30 Y D FG Coy Deli md132 001 1000 2020-01-25 14 53 55 Y D Edit Copy Delete md488 002 5.00 2020-01-25 06.3642 N D Lot fi Copy Delete md403 002 50 2020 01 26 14 54:19 N D EG Cony Delete md188 02 1500 2020-02-13 1657 15 Y Check All With selected Change Delete Export Number of rows: 25 iter row: Search this tablo Query results operations Print vice Print view with full text) Export Display chart Create view