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.
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
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
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.
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