Simple Php Report From Existing Mysql Database

This will be a simple project if you are good with PHP & MySQL…

I have an existing MySQL database full of data that I want you to create a custom report page that allows me to easily view and manage my data.

I realize I can view the data using MyPhpAdmin, but I want a dynamic report that I can view via my browser that shows me the data in an easier viewing format, filters, etc.

Let me explain in detail:

My database has 2 tables…I receive order details from PayPal’s IPN that adds data to my database.

There are several fields added to my database for each order, but I am only interested in seeing certain fields.

So the Main report with the following Column/Field Names in order of Left to Right:

time
txn_type
receiver_email
first_name last_name
payer_email
item_name
mc_gross
payment_status
custom

Each order will be displayed on separate rows…with the NEWEST order on the top.

That’s really it for the main report, but I would like to add the following features:

==============================
1.

I would like filters created so that I can click on a filter and just see the orders based on the selected filter.

Here are the filters wanted:

The below are in the following format:

Filter Name
Database Column/Field Name – data variable

——————-
New Purchases
txn_type – web_accept
——————-
New Subscriptions
txn_type – subscr_signup
——————-
Recurring Subscription Payments
txn_type – subscr_payment
——————-
Subscriptions Cancels
txn_type – subscr_cancel
——————-
Subscriptions EOT
txn_type – subscr_eot
——————-
Subscriptions Failed
txn_type – subscr_failed
——————-
Refunds
payment status – Refunded
——————-

==============================
2.

At the end of each row will be these options: View Del

View – Allows me to view ALL of the fields in the database for that particular order.

Del – Allows me to delete a complete order record from the database. Please add a popup warning to eliminate accidental deletes.

==============================
3.

Row Background Colors. I would like to make the cell background of each row color coded so at a glance I know what the status of the order is. These colors will be based on the the following:

——————-
txn_type – web_accept –> #CEFFFF
——————-
txn_type – subscr_signup –> #66FF66
——————-
txn_type – subscr_payment –> #CCFFCC
——————-
txn_type – subscr_cancel –> #FF8080
——————-
txn_type – subscr_eot –> #FF3535
——————-
txn_type – subscr_failed –> #C0C0C0
——————-
payment status – Refunded –> #FFBA53
——————-
everything else –> #FFFFFF
——————-

==============================
ADDITIONAL REQUESTS:

– Del link pop up warning “Are You Sure You Want to Delete…”

– Newest Orders go to TOP row of report

– If adding Paging plz put 100 rows per page

– plz make it nice to look at…creating code is one thing…making it look professional makes me VERY happy 🙂

==============================

I think that is it! Hopefully that makes sense 🙂

Please let me know if you have any questions.

Once we agree and are ready to get started I will give you full FTP and Database access to my server so can build & test the scripts right on my server.

p.s. showing me an example of nice looking reports you have generated via PMB would be a good way to win the bid 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *