I want to pull data from a database and be able to view it and search it from within the admin panel of my site.
Data is to be pulled from a sales table and will include:
sale id
first name
last name
paypal email
receiver email
time stamp
product
product id
price
member id
affiliate id
payment type
The data should be displayed pretty much just as it is in phpmyadmin, but within the template of my admin panel. Showing 100 rows per page. Sorted by sale id in descending order.
I’ll want the ability to choose and search within any of the items from the list.
For example choose ‘sale id’ from a dropdown and search ‘123’
Both ‘member id’ & ‘affiliate id’ results will be live links, simply to another part of my admin panel, members.php?action=search&search=id&criteria={id} with the relevant id number appended to the end.
Thats it. Easy stuff.
