진행중

Write a simple PHP 7.3 script to view and edit a set of MySQL tables

Main table: [login to view URL]

`id` Autoincrement

`asset` Free text

`description` Free text

`consequences` Free text

`concerns` Array of "id" from informationsecurityconcerns.sql. Selectable by ticklist of "description" from informationsecurityconcerns.sql. Display "description" as comma separated list when viewing.

`documents` Free Text

`legislation` Free Text

`soa` Two arrays of "id" from "[login to view URL]" and "[login to view URL]" selectable by ticklist of "title". Display "clause - title" when viewing as comma separated list.

`mitigations` Free Text

`probability` value 1-5 as radio buttons, display "definition" from [login to view URL] when editing. Display "value - description" from [login to view URL] when viewing

`impact` value 1-5 as radio buttons, display "definition" from "[login to view URL]" where "type" is "financial" or "informationsecurity" when editing. Display "value - description" when viewing

`owner` Free Text

`reviewdate` Update to current date on edit or click of "reviewed" button

`editdate` Update to current date on edit

`reviewby` "ID" from "[login to view URL]". Display "username" as dropdown when editing. Display "username" when viewing. Dropdown next to "reviewed" button.

`editby` "ID" from "[login to view URL]". Display "username" as dropdown when editing. Display "username" when viewing

`archive` set as "0" for current entries, set as "1" for saved data before a modification

`previousid` array of archived "ID"

Viewing:

Simple table. with dropdown at the top showing "username" from "[login to view URL]" to select who is editing/reviewing

Headings:

Asset - description - consequences - concerns - impact - probability - score(1) - owner - last reviewed(2) - last edited(3) - archive (5) - Reviewed(4)

1. Multiply "impact" and "probability" values (1-25). This can be done either by PHP from the database values or a new database column can be added to the table to store it

2. Display "reviewdate" and "username"

3. Display "editdate" and "username"

4. Button to mark as reviewed

5. Link to display all archived rows for this entry

Only show unarchived entries in main view.

Colouring:

Conditional formatting based on "score". Categories are 1-2 (green), 3-8 (light green), 9-12 (light yellow), 13-19 (light orange), 20-25 (light red). Colours must be hex codes.

Secondary conditional formatting to colour row as light orange when "reviewdate" is more than 300 days but less than 365 days ago, and colour light red when "reviewdate" is more than 365 days ago. This should override the score conditional formatting.

Editing:

As described in table. Must be able to edit without page refreshes (jquery preferable) by double clicking on a cell in the displayed table. Prompt to select user from top dropdown.

Old entries must be archived if the "editdate" is not "today". If the editdate is "today" do not archive the old entry and just make the changes.

Requirements:

1. Prepared statements for insert/update, connection and read queries

2. PDO database connection

3. Compatible with PHP 7.3 to 7.4

4. Do not break into and out of PHP. Have a single php block at the top of the script. Create and modify the table using PHP. Minimal static HTML.

5. Table can be generated using <table> or <div>. If <div>, CSS file must also be written.

6. Script must be able to view and modify existing data and add new rows for project to be complete.

7. No PHP frameworks (laravel, cakephp, etc) are to be used.

Expected price will be under £100.

기술: PHP, MySQL, 자바 스크립트, jQuery

확대 보기: simple php pop3 read script, simple php http proxy script, simple php data database script, simple php ajax upload script, simple php image resizecrop script, simple php rent car script, simple php smtp email script, simple php file transfer script, free simple php video uploading script, simple php login registration script, simple php online catalog script, simple php pixel tracking script, simple php smtp mail script, simple php soap post script, write simple php proxy, simple php file hosting script, write simple php script

고용주 소개:
( 3건의 리뷰 ) Kempston, United Kingdom

프로젝트 ID: #24499790

수상자:

coolguyinus2004

I need a server from your or a domain to finish this today. PHP/MYSQL core coding expert with 15+ years of experience to finish this.

£125 GBP (3일 이내)
(353건의 리뷰)
7.7

이 프로젝트의 입찰 현황은 다음과 같습니다. 입찰자: 45명, 평균 입찰가: £131

ambientinfotech

Hello, I have read your job details carefully and as per your need you want to Write a simple PHP 7.3 script to view and edit a set of MySQL tables I have more than 8 years of experience in this field and I will assu 더 보기

£100 GBP (2일 이내)
(275 리뷰)
7.3
vw580939vw

Dear Sir, This looks doable, we offer GBP7/hour and bidding for 10 hours for now, if we will require more time, will update you in advance. We can start on an immediate basis. Thank you. - Prakash WeTheDevelopers

£78 GBP (3일 이내)
(168 리뷰)
7.4
michealperfect

Hey there! I have read the details of your project and, I can start with your project immediately. I will write PHP script on you MySQL tables. Please send me a message so we can discuss it further. Regards Ahad R W 더 보기

£100 GBP (2일 이내)
(180 리뷰)
6.9
ecommercejui

Hi, I am interested to work with PHP project. I am a professional PHP developer. I have more than 5 years of experience Thanks

£200 GBP (7일 이내)
(104 리뷰)
6.9
Avinavkr

Hello there, I can write a simple PHP 7.3 script to view and edit a set of MySQL tables. I am well versed in PHP and this project exactly fits with my skill sets. I am right candidate for this job. Past Projects: ht 더 보기

£135 GBP (7일 이내)
(138 리뷰)
7.0
avinashjain09

Hi, I have read your requirement and I can do this work. I have expertise in php and mysql. Can we have more discussion. I am looking forward to have a brief discussion with you, what is the best date and time to hav 더 보기

£100 GBP (2일 이내)
(142 리뷰)
6.8
ishpreet11

Hi I am an expert programmer with an experience oi more than 8 years. I have gone through all your description and I can create such standalone script for you without using any framework as you mentioned

£120 GBP (1일 이내)
(115 리뷰)
6.6
amiitkumar19

Hello, I have read your job and i’m presenting my proposal for your consideration as a professional website developer and i have great command over HTML5,CSS,CMS and I have already built many responsive websites .My a 더 보기

£200 GBP (5일 이내)
(69 리뷰)
6.0
irfankhokhar1986

Hi, Greeting of day. I m Expert Professional Full stack developer Having 8+ Years Experience I have more than 124 projects successfully completed here. Can we discuss more about your project related I have gone t 더 보기

£100 GBP (7일 이내)
(105 리뷰)
5.7
dhuvi10

Hi, Hope you are doing fine!! I am here and ready to start the work IMMEDIATELY. I have designed many websites in last 6 years. I believe that I have the drive, energy and knowledge to be perfect for this job. I ha 더 보기

£90 GBP (2일 이내)
(19 리뷰)
5.3
letsstartcoding

ia m well versed with php so i can write php script ready to start work from now

£200 GBP (1일 이내)
(27 리뷰)
5.0
dexteroussolutio

I can BUILD PHP 7.3 VIEW/EDIT CODE SET as per your Requirement once we discuss over PM we can start immediately, our team can work on your time and avail 24/7 Support . Recent work [login to view URL] http://gea 더 보기

£90 GBP (2일 이내)
(54 리뷰)
5.2
webdroid

Hi, I'm an Expert PHP Developer and i understood your project and would love to Write a simple PHP 7.3 script to view and edit a set of MySQL tables for you on time and within your budget. Skills and expertise: HTM 더 보기

£150 GBP (1일 이내)
(24 리뷰)
5.4
lordzephirot

Hi, I have read your job description carefully and i am very interested in this job. I am full stack web developer and i have a strong experience with PHP and Sql. I can start working right now and looking for a good 더 보기

£100 GBP (5일 이내)
(16 리뷰)
4.8
DmitryShashko090

Hi. there. Thank you for your job post. After reading your job description, I felt that I am an enough candidate to take this job on. I have worked for a long time with PHP/MYSQL project. That's why I make a proposal t 더 보기

£200 GBP (3일 이내)
(11 리뷰)
5.0
ozherelevwork

Hello, Robin. How are you? This is Roman from Russia. I read your job description. As I 'm a senior full stack web developer and PHp expert with 6 years of experience, I 'm sure I can perform your project completely. L 더 보기

£100 GBP (2일 이내)
(10 리뷰)
4.7
mdramindz

Hello, I can do it in core php which is compatible in php7.3 to 7.4 you can view my profile here: https://www.freelancer.com/u/mdramindz.html Am ready to go with you immediately please message me so we can quick dis 더 보기

£99 GBP (5일 이내)
(15 리뷰)
4.8
Yaserove

⭐⭐⭐⭐⭐Larave expert⭐⭐⭐⭐⭐ I have read your job description carefully. I am a senior and passionate full stack developer that has rich experiences in ecommerce website development. Working for 7 years in information techn 더 보기

£135 GBP (7일 이내)
(11 리뷰)
4.5
kozachenkodr

Dear client. I have gone through your project carefully, then I am so interested in the job. I am a php developer, well experienced in mysql pdo connection with PHP. I can suggest you jquery datatable for front-end. P 더 보기

£100 GBP (7일 이내)
(13 리뷰)
4.6
tutulsoft

---Ready to do it Right now ---- I read all of you description for the project requirements ............... thank you

£99 GBP (4일 이내)
(5 리뷰)
4.5