
I need a PHP Programmer to filter data from db
- or -
Post a project like this4205
€20(approx. $23)
- Posted:
- Proposals: 5
- Remote
- #510482
- Awarded
Description
Experience Level: Entry
General information for the website: I need a PHP Programmer to filter data from db
Description of requirements/features: Here are the tasks,
database details are provided at the end....
1) Create a script Plain PHP framework to find for the month of Jan, Feb, Mar, Apr, May 2013 list of shops having total number of transactions <=3 and create a xls file as output.
Format of xls file:
Shop id, shop website, Transactions in Jan, Transactions in Feb, Transactions in Mar, Transactions in Apr, Transactions in May.
2) Write a mysql query to find :
i) Top 5 shops by number of transactions
Output: fk_filiale, website,number of transactions
ii) Top 5 customers by number of transactions
Output: id,anrede,nachname,vorname, number of transactions
Database details
Import three scripts from the attachments.
Tables description
1) Table name ‘Kunde’
Columns:
Id: Unique customer id (Same as fk_kunde in transaction)
Nachname: Last name
Vorname: First name
Anrede: herr/frau
Recordbirthdate: date of record creation
2) Table name ‘online_partner’
Columns:
Fk_filiale: shop id ( same as fk_filiale in transaction)
Website: shop website
3) Table name ‘Transaction’
Columns:
Id: Unique transaction id
Fk_filiale: shop id
Fk_kunde: unique customer id
Recordbirthdate : date of transaction
Extra notes:
Description of requirements/features: Here are the tasks,
database details are provided at the end....
1) Create a script Plain PHP framework to find for the month of Jan, Feb, Mar, Apr, May 2013 list of shops having total number of transactions <=3 and create a xls file as output.
Format of xls file:
Shop id, shop website, Transactions in Jan, Transactions in Feb, Transactions in Mar, Transactions in Apr, Transactions in May.
2) Write a mysql query to find :
i) Top 5 shops by number of transactions
Output: fk_filiale, website,number of transactions
ii) Top 5 customers by number of transactions
Output: id,anrede,nachname,vorname, number of transactions
Database details
Import three scripts from the attachments.
Tables description
1) Table name ‘Kunde’
Columns:
Id: Unique customer id (Same as fk_kunde in transaction)
Nachname: Last name
Vorname: First name
Anrede: herr/frau
Recordbirthdate: date of record creation
2) Table name ‘online_partner’
Columns:
Fk_filiale: shop id ( same as fk_filiale in transaction)
Website: shop website
3) Table name ‘Transaction’
Columns:
Id: Unique transaction id
Fk_filiale: shop id
Fk_kunde: unique customer id
Recordbirthdate : date of transaction
Extra notes:
Kailaash B.
100% (15)Projects Completed
19
Freelancers worked with
17
Projects awarded
27%
Last project
7 Oct 2023
Germany
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies