Create me a simple database management script

This script will be a framework used to control a set of custom database tables and needs to:

1. Use a dokuwiki auth file for user authentication, but does not need to display data or pages within dokuwiki.

2. Be written in PHP (7.3 compatible) with a MySQL backend. Make use of dymanic inpage loading via javascript to increase speed and reduce the need for full page refreshes. 3rd party PHP Framework is negotiable and must be well known if required (I.E. CakePHP etc.) 3rd party frameworks with licencing fees will not be accepted

3. Allow me to create new database tables to store specific data (I.E. name each column)

4. Allow me to enter and modify single rows in a database with freetext, use columns from other existing database tables (select the relevant table and column during setup) with multiselect ticklist, single select radio button or text search or, set up a list with descriptions which may be used as single radio or multiple ticklist.

5. Allow me to enable/disable entire tables from use with warnings if columns of data are used to populate other areas.

6. Allow me to export selected tables to tabbed csv files or (preferably) prebuilt excel template

7. Allow me to display data from within each table as an html page with options to exclude database rows based on user criteria (I.E. if date of review is within the past 300 days, do not display the row, only display rows where "supplier status" is "current"). HTML should be basic tables with definable colour coding based on criteria. I will need to be able to modify any entry using double click.

8. Allow for daily cronjob to send email warnings based on criteria (I.E. when "date of last review" is more than "300 days ago" email "risk owner" with this message "XXXX"). Ensure that emails are combined for each person so they will only receive a single email with all their notifications. There should also be an alerts page for each user which contains all details of these generated alerts.

9. Bug fixes must be applied free of charge for a period of at least 3 months following project completion. New features would be considered as a separate project and therefore by chargeable.

10. Code must be well commented and of a high standard to allow future developers to work with it. If the project is completed to a high standard, you will be given first refusal for future development work.

11. Any requirement for ongoing licencing fees will be rejected. Code must be provided in its entirety with no encryption (I.E. ioncube etc) and will not be property of the coder following project completion.

12. Information security is paramount and must be considered at all stages. Chances for data breaches should be minimised and there should be no scope to gain access to data without an appropriate login. Ideally tools such as burp-suite will be used by the coder to verify security prior to project delivery. Information Security issues detected by penetration testing within the 3 months following project completion must be fixed without extra charge.

13. There must be levels of access for users. "Admin" (can do anything and set up new sheets), "Modify All", "Modify all within specific tables", "Modify owned rows within specific tables only", "View only"

This script is currently working as an excel file with named ranges and VBA code for ticklists. On successful project acceptance a copy of the spreadsheet can be supplied but no data entry will be required by the coder. All data entry and setup will be done by me.

This project may appear complex but in actuality is very simple once the requirements are properly understood. Feel free to message me for clarifications.

Full specification will be provided if your bid is appropriate. Examples of tables I may use this script to create are attached in pdf. The coder will not be required to perform any data entry, only to create the management script.

Skills: PHP, MySQL, Javascript, HTML

See more: simple project management script, create simple database using access, create simple database, read xml file create mysql database php script, create simple database excel, create simple database programming, acces 2007 create simple database, create simple database hotel booking system, create simple database gui interface, create mysql database installtion script php project, create simple database android, oracle create simple database, create simple database order management microsoft access, create simple database application android, simple news management script, program create simple database, simple database search script, simple document management script, create simple database matlab

About the Employer:
( 3 reviews ) Kempston, United Kingdom

Project ID: #22041112

51 freelancers are bidding on average £453 for this job


Nice to meet you I have more than 15 years development experience and a great team, we can complete your project with clean code and best practices We are working on hourly rate 40usd / hour. Please check my profile More

£500 GBP in 5 days
(198 Reviews)

How are you? I have checked your description carefully one by one. My name is Yanying Ding, a full stack web developer with extensive knowledge in the PHP and Mysql database area. I have rich experience in the Core PHP More

£500 GBP in 10 days
(92 Reviews)

we are ready to discuss all [login to view URL] open Message box so that we discuss it in detail Expertise ================== - PHP - Cryptocurrency - Code Ignator - Magento - Laravel - Wordpress - Zen-cart - X-Cart - Webs More

£486 GBP in 12 days
(85 Reviews)

Hi there , Hope you doing great !!! Your given requirements review out very well and its should be performed out accordingly with topmost skills. My $kype contriverz1988 I am a full stack developer and having expe More

£750 GBP in 12 days
(107 Reviews)

Hi from [login to view URL], Thanks for sparing time on my bid, please discuss with me. please check some working projects have [login to view URL] [login to view URL] [login to view URL] https More

£300 GBP in 7 days
(165 Reviews)

Hello Sir/Madam!! Please ignore the rating as its our second profile. I’m “Master Expert in PHP & WordPress” and immediately available to discuss and start working on your project. I have developed/completed 350+ webs More

£400 GBP in 5 days
(148 Reviews)

Hello , I am full stack developer mainly working on software and script development, having vast experience on 3rd party APIs integration and customization, I have gone through from your requirement and understood com More

£550 GBP in 12 days
(107 Reviews)

I have gone through your requirement, So I'm perfectly able to do this Job and I assure you that it will give you quality work in less than anticipating time. I appreciate it if you give me an interview call once to di More

£500 GBP in 7 days
(62 Reviews)

I reviewed your post and perceived what you want. I'm very familiar with laravel via many projects. I built several large systems by laravel from ground. They are ecommerce system and realestate systems. Here are my s More

£500 GBP in 7 days
(42 Reviews)

Hi, I am 9+ years experienced Senior Software Engineer with team of additional Experienced Software Developers, we have have completed several projects in past which includes developing Complex/Responsive web apps, Des More

£250 GBP in 5 days
(39 Reviews)

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

£750 GBP in 10 days
(55 Reviews)

Hi, Greetings of day! Thank's for providing with an opportunity to bid on your project. After reading your description carefully, I understood your needs exactly. I am an experienced developer. My skills are  : - Bac More

£500 GBP in 7 days
(14 Reviews)

Hello, sir! I have read your job description carefully. As a senior full stack developer who has rich experiences in ecommerce website development, I have been working for 6 years in information technology. Also I hav More

£500 GBP in 7 days
(29 Reviews)

Hi, I just reviewed your project description and interested in your job now. I am a full-stack developer who have rich experience in web development. Especially I have great knowledge and experience in PHP, Codeignite More

£500 GBP in 7 days
(28 Reviews)

⭐⭐⭐⭐⭐Dear Client. How are you?⭐⭐⭐⭐⭐ I have review requirements and gathered features for your project. I have gained 5+years of experience and expertise working on PHP based Frameworks and Libraries. And I have exte More

£300 GBP in 7 days
(20 Reviews)

PHP, MySQL, Javascript, HTML skilled professional with the required expertise. Can help to deliver the solution as needed on the expected lines. Please private message me to discuss the project further. Hope to build a More

£600 GBP in 7 days
(76 Reviews)

⭐⭐Hello, there. I'm specialized in database management system. I can fix your problem easily. I have 5 years of experience of web projects, Hope to be chosen and I will give you a good result. Best regards.

£250 GBP in 10 days
(21 Reviews)

Hi I have read your requirement carefully and came to the conclusion that I could help you. Actually I have been programming for over 10 years and I have got many experiences in this field. [login to view URL] https: More

£600 GBP in 7 days
(22 Reviews)

Hi, I have reviewed your all of the attached PDF and I am very much clear with your requirement. >> Please let me know when you are available for discussion. I am interested to work with you. Being 8+ years of work exp More

£500 GBP in 7 days
(38 Reviews)

Hello How are you? I can perfectly handle your project to build a data management system and I have excellent skills and experience in this field. I am a full stack PHP expert with 7+ years experience and I can deliver More

£500 GBP in 7 days
(21 Reviews)