Find Jobs
Hire Freelancers

Create a PHP script which produces an html report of the following database

$10-30 USD

Completed
Posted about 7 years ago

$10-30 USD

Paid on delivery
Create a PHP script which produces an html report of the following database: MYSQL database table schema CREATE TABLE `accountlines` ( `accountlines_id` int(11) NOT NULL AUTO_INCREMENT, `borrowernumber` int(11) NOT NULL DEFAULT '0', `accountno` smallint(6) NOT NULL DEFAULT '0', `itemnumber` int(11) DEFAULT NULL, `date` date DEFAULT NULL, `amount` decimal(28,6) DEFAULT NULL, `description` mediumtext COLLATE utf8_unicode_ci, `dispute` mediumtext COLLATE utf8_unicode_ci, `accounttype` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL, `amountoutstanding` decimal(28,6) DEFAULT NULL, `lastincrement` decimal(28,6) DEFAULT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `notify_id` int(11) NOT NULL DEFAULT '0', `notify_level` int(2) NOT NULL DEFAULT '0', `note` text COLLATE utf8_unicode_ci, `manager_id` int(11) DEFAULT NULL, PRIMARY KEY (`accountlines_id`), KEY `acctsborridx` (`borrowernumber`), KEY `timeidx` (`timestamp`), KEY `itemnumber` (`itemnumber`) ) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; The report output should be an HTML table with a summary report showing the total amount outstanding by accounttype. AccountType Amount The report should show data where timestamp is for the current year. You can populate any data you like in the database.
Project ID: 13263965

About the project

17 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I can start now and can create PHP script, kindly initiate chat to discuss more I have 6+ years of working experience with PHP, Wordpress, HTML, CSS, Photoshop, Graphic design etc. Give me one chance to show you my expertise. I look forward to work with you. Regards, Niki
$30 USD in 1 day
5.0 (72 reviews)
6.3
6.3
17 freelancers are bidding on average $45 USD for this job
User Avatar
Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: Web(PHP, MySql, HTML5, Java) and Mobile (Native and Hybrid). I am also an expert in many different frameworks such as CodeIgniter, Laravel, Spring and jQuery. I have over 5 years industry experience in development and graduated with a Masters Degree in IT from the Hong Kong University. My PHP L1 exam score in Freelancer places me in the top 3% of developers. Please have confidence in my skill and quality of work. I assure, I will do my best to work with you on your project to present the best possible outcome for you and your customers. I will also do my best to correct any area of work where quality comes into question, I want to have pride in my service to your company and the final product provided. While I am happy to make adjustments and alterations as your project progresses please understand that I am a dedicated freelancer and any work that is substantially different from the project description may need the awarded fee to be re-negotiated. Feel free to contact me if you have any questions, and please review my 5 star profile. I look forward to working together in partnership on your project and into the future. Regards
$54 USD in 1 day
5.0 (266 reviews)
8.8
8.8
User Avatar
Hello, I am a UK based developer with plenty of experience in PHP. I have written both new projects and maintain a lot of websites for my clients. Please contact me to start creating your report from mysql data.
$55 USD in 1 day
5.0 (72 reviews)
6.4
6.4
User Avatar
A proposal has not yet been provided
$30 USD in 2 days
5.0 (70 reviews)
5.1
5.1
User Avatar
Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now Lets Start Working On it Right Now
$25 USD in 1 day
5.0 (14 reviews)
4.6
4.6
User Avatar
Hi, I am experienced with creating reports from MYSQL Database tables. Happy to take on your project.
$25 USD in 1 day
5.0 (4 reviews)
3.4
3.4
User Avatar
I am a individual that working i IT industry from over 3 years, So if you give me this work i'll do it in cheaper cost. I understood your work
$15 USD in 2 days
5.0 (2 reviews)
1.2
1.2
User Avatar
A proposal has not yet been provided
$40 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UGANDA
Kampala, Uganda
5.0
7
Payment method verified
Member since Feb 15, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.