Closed

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

71 freelancers are bidding on average £526 for this job

dreamci

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
(207 Reviews)
8.7
graphicaa

Hello I am checking the attached document / website , I will submit my detailed estimation with in 50 minutes Thanks for your patient Gopal

£750 GBP in 25 days
(706 Reviews)
9.3
linuxfreak1985

Hi,i have gone through your post, i can understand now what you need to be done, as i am expert developer and created over 5000 web/apps with 5 star ratings my expertise in Core-PHP / CodeIgnitor and Laravel Frameworks More

£750 GBP in 7 days
(1028 Reviews)
8.6
mituld

Hello! i checked the attached 3 pdf and read the specification This project is very interesting for me and perfect fit with my skills. I am available now and can start immediately. Hope to work with you and also i a More

£700 GBP in 12 days
(480 Reviews)
8.2
idragon712

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
(100 Reviews)
7.8
Friends4it

We already have built large scale applications, CRMs, ERPs and huge systems can be found at [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] More

£750 GBP in 15 days
(404 Reviews)
8.0
junkyfunky

Hello, I've read your project description and I want to tell you that I can design and build a Professional and simple database management script for you as per your [login to view URL] have a quick chat to discuss th More

£280 GBP in 10 days
(241 Reviews)
7.6
phpdeveloper100

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)
7.4
markninja

Hello, I will develop a simple database management script. I am very confident to complete this job on high quality of work.I am available 10 am-8 pm YOUR time zone. Here are some PHP based websites that required More

£250 GBP in 7 days
(190 Reviews)
7.8
abstractsoftweb

Hello sir. I have good skills and experiences as you requested on your project. You can see my results as follow. https://www.freelancer.com/u/abstractsoftweb?w=f I am very interested in your project. If you hire me, More

£300 GBP in 7 days
(165 Reviews)
7.6
einnovention

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

£250 GBP in 15 days
(163 Reviews)
7.2
contriverz

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
(121 Reviews)
7.8
maamekal

Yes, I have seen it very care fully and I am perfect understood so please give me a chance to work for you I am highly interested in this project. Sure, You must see my team skill than you think why we are best for th More

£250 GBP in 7 days
(175 Reviews)
7.2
erashrafkamal

✅PHP EXPERT,,,,,I CAN START NOW✅ Hello there, Thanks for job posting. I have read the description carefully and give you 100% assistance as PHP Developer to create you a simple database management script. Skills- More

£1250 GBP in 25 days
(53 Reviews)
7.1
an1566706

Hi, We have understood your requirement. And, have done this previously with perfection. We have 7+ professional development experience. Looking forward to discuss your project on chat to share with you our Portfolio

£250 GBP in 7 days
(80 Reviews)
6.7
exaltedsol

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
(171 Reviews)
6.9
schoudhary1553

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
(94 Reviews)
6.8
itpathsolutions

Honestly, I am still going through your job description. But as far as the skills concern, you can totally rely on me. I can also adjust the pricing once we are clear on requirements. Let's have a quick chat to discus More

£2500 GBP in 7 days
(38 Reviews)
6.3
Alka700

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
(63 Reviews)
6.3
jamesmartin81

Hi, I am ready to start right away. I have reviewed your job description as well and very confident to handle this project perfectly. I will do multiple revision in your project with 100% satisfaction work guaranteed More

£250 GBP in 4 days
(219 Reviews)
6.4