-
Notifications
You must be signed in to change notification settings - Fork 1
Home
WhizSid edited this page Jun 29, 2019
·
2 revisions
With the help of arraybase you can use all MySQL functions to manipulate PHP arrays. All syntaxes are same as MySQL. In real world when we are working with commercial projects we are facing some difficulties with their reports. Some times they want same data in different formats in same report. This is an example.
Running a query and fetching data.
| Bill No | Town | User | Product | Qty | Amount |
|---|---|---|---|---|---|
| A | Colombo | Kevin | Bag | 2 | 5000 |
| B | Colombo | Jason | Shirt | 1 | 1900 |
| C | Moratuwa | Jason | Trouser | 4 | 8000 |
| C | Kotte | Jason | Bag | 1 | 2500 |
Running another query and fetching data
| Bill No | Town | User | Amount |
|---|---|---|---|
| A | Colombo | Kevin | 5000 |
| B | Colombo | Jason | 1900 |
| C | Moratuwa | Jason | 10500 |
Running ano....
Why are we running queries for each table? We already have all data in first table. This is a real moment to using ArrayBase.