You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
WhizSid edited this page Jun 29, 2019
·
2 revisions
ArrayBase Wiki!
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.
Example of usage
Product wise Bill Wise Amount
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
Bill wise Amount
Running another query and fetching data
Bill No
Town
User
Amount
A
Colombo
Kevin
5000
B
Colombo
Jason
1900
C
Moratuwa
Jason
10500
Product wise Amount
Running ano....
Wait! Stop!
Why are we running queries for each table? We already have all data in first table. This is a real moment to using ArrayBase.