Build me a PHP page to display information from database as per query string parameters also export as PDF
Budget: $10 – $30 USD
Hi,
A very easy and quick project.
I need you to develop a PHP page (responsive) that connects to Oracle 11g database and gets data as per the query string parameters supplied in the URL. Also, provide a button to export as a PDF. That's it. Very simple.
Background Information:
We are planning to send SMS to our customers with the shortened invoice link to view their invoices from their mobiles or desktops. The customer will click on the link and it will display the invoice information. I am attaching the invoice format, it's in PNG, I have marked the fields in RED which will be retrieved from the database.
Important to Note:
1. The data comes from 3 different tables - Header Table - Basic Header Information. Detail Table - Item Details. Payment Table - Payment Information.
2. I will provide the table structure and sample data for all the 3 tables.
3. Server Information - Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips PHP/7.1.25
4. The PHP code should connect to the oracle database using a specific user and password using oci_connect.
5. The parameters for the SQL query to retrieve data should be bind with the query string parameters by using oci_bind_by_name.
6. The page should have a beautiful loader (like loading....) animated until the invoice details are displayed.
7. If there is some connectivity issue or cannot display information, then the proper message should be displayed that there is some connectivity issue, please try again later.
8. The page should be very responsive and should fit any screen size.
9. The page should support Arabic, our database already has Arabic data, so much of the information will be in Arabic.
10. The header table will have only 1 record. The item details table will have multiple records, so you have to consider that as per the items, the page size will expand and you have to loop the item table and display all the items in the middle section. The payment details table will have multiple records but you have to concatenate all the rows and display them in a single line.
11. For confidentiality and security reasons I cannot provide my server for testing. You have to provide a draft and I will run and let you know about the results.
12. The above functions I have provided just as an indication, you are at liberty to use your own methods but make sure that it is secure and best practice.
13. A button at the end to export to PDF.
A very easy and quick project.
I need you to develop a PHP page (responsive) that connects to Oracle 11g database and gets data as per the query string parameters supplied in the URL. Also, provide a button to export as a PDF. That's it. Very simple.
Background Information:
We are planning to send SMS to our customers with the shortened invoice link to view their invoices from their mobiles or desktops. The customer will click on the link and it will display the invoice information. I am attaching the invoice format, it's in PNG, I have marked the fields in RED which will be retrieved from the database.
Important to Note:
1. The data comes from 3 different tables - Header Table - Basic Header Information. Detail Table - Item Details. Payment Table - Payment Information.
2. I will provide the table structure and sample data for all the 3 tables.
3. Server Information - Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips PHP/7.1.25
4. The PHP code should connect to the oracle database using a specific user and password using oci_connect.
5. The parameters for the SQL query to retrieve data should be bind with the query string parameters by using oci_bind_by_name.
6. The page should have a beautiful loader (like loading....) animated until the invoice details are displayed.
7. If there is some connectivity issue or cannot display information, then the proper message should be displayed that there is some connectivity issue, please try again later.
8. The page should be very responsive and should fit any screen size.
9. The page should support Arabic, our database already has Arabic data, so much of the information will be in Arabic.
10. The header table will have only 1 record. The item details table will have multiple records, so you have to consider that as per the items, the page size will expand and you have to loop the item table and display all the items in the middle section. The payment details table will have multiple records but you have to concatenate all the rows and display them in a single line.
11. For confidentiality and security reasons I cannot provide my server for testing. You have to provide a draft and I will run and let you know about the results.
12. The above functions I have provided just as an indication, you are at liberty to use your own methods but make sure that it is secure and best practice.
13. A button at the end to export to PDF.