Closed

Help with CRUD using PHP, MySQL, Bootstrap, JS and Ajax.

We are building a web database application with PHP, Bootstrap, w3css, JS, AJAX, etc. I need help with one form.

DESCRIPTION

This consists of a list of records. The left column has two icons, one for viewing (eye icon), the other for editing (pencil icon). The users with the bit "isAdmin" can add, view, and edit. All others can only view.

When the ' view' button (eye icon) is clicked, a modal dialog appears showing selected fields of the current record with their values and a 'close' button. The user can pick values and copy to them to the clipboard.

When the 'edit' button (pencil icon) is clicked, a similar modal dialog appears, with the selected record values, and a set of buttons to Delete, Add, Clone, Close and Save.

The 'trash' button (red trash icon), asks for confirmation before it stores a '1' value in the 'isVoid' field in the record, and displays the message: 'Record has been deleted. Click Close'. The message clears and the form closes when the user clicks on 'Close' or on the 'x' button (x icon) on the upper right hand corner of the form. This function does not erase the record.

There is a message section.

The add button (plus icon), clears the fields and allows user entry. The user clicks on the 'save' button (check icon) to save and on the 'close' (x icon) button to close.

The 'clone' button asks for confirmation and makes a copy of the record, with a new ID (record number), same Company, and all other fields blank. The new record is the current record and is shown in the modal dialog ready for edit. A message is displayed; 'Clone record ready for edit'. The new record is not created in the database until the user clicks on the 'save' button. Messages will preferably display in the modal's footer, to the left of the buttons.

The 'close' button as well as the x button, both close de modal dialog without making any changes. If changes have been made to the fields, displays a message: "Changes will be lost. Click 'close' again to discard all changes, click 'save' to save". The message stays until the user clicks 'save', or 'close'. Clicking on 'save' does not close the dialog.

The 'save' button saves the values shown in modal into the record and keeps the modal open for further edits, or the 'close' button is pressed. After each save, display the message: 'Record Saved'. The message clears when the user clicks on the dialog. 'Save' does not close the dialog.

Clicking away from the dialog, clicking on the 'close' button, or clicking on the x button will have the same effect: a) check if there are changes, b) if there are not then close, otherwise, warn that changes will be lost, c) wait for confirmation and disable closing with other than the 'close' button, etc.

WORKING

This should be implemented in a manner to minimize network traffic, dynamically retrieving ONLY the record that needs to be processed, only after the user clicks.

The task must be accomplished using bootstrap modal forms, PHP, MySQL, Javascript and Ajax, using the existing code as a basis for display and interaction with the user.

The code is to be delivered installed on the same server where it is provided.

WHAT WE HAVE ALREADY

We already have a database, the base form, two modals, icon buttons and tooltips.

Tags and values need to be added.

We will supply a link and the credentials needed to access the database and server via FTP where to install this.

Each function could be a Milestone.

If you are interested, we can supply a link to let you view the partially working model.

Skills: AJAX, Javascript, MySQL, PHP, Software Architecture

See more: php mysql web database application code generator free, ajax web chat using php mysql jquery, image upload using php mysql ajax jquery, ajax autocomplete search using php mysql, dynamic drop using php mysql using ajax, point sales using php mysql ajax, ajax autocomplete using php mysql, build web database jsf, build web chat application vb net, ticket web database application tutorial, build basic database webpage mysql, export netbeans java database application mysql, projects j2me web database application, build inventory database using mysql, java database application mysql netbeans, netbeasn web database application, thesis web based application mysql apache php pdf, best update data using php mysql ajax, web database application css design, build web database reports, java database application mysql, ajax live search using php mysql, document tracking system program using php mysql, ajax data grid system using php mysql, online survey using php mysql

About the Employer:
( 2 reviews ) Miraflores, Peru

Project ID: #15805076

57 freelancers are bidding on average $433 for this job

coolguyinus2004

Show me website and i need ftp to review PHP code and also i need cpanel login to review database too. Once i review all i will tell you price and time for this project. till then i cant virtually say anything. Message More

$370 USD in 10 days
(343 Reviews)
7.6
AxonTech

Hello, Yes, We are interested. Please share the link with us to review. We've highly expertise and skilled Team having skills with HTML, CSS, AJAX, JavaScript, MySQL, PHP and Custom Development. You can also V More

$427 USD in 8 days
(106 Reviews)
7.2
$555 USD in 10 days
(79 Reviews)
7.2
nsweb

Hello, I'm professional web developer since 2006. I have big experience with PHP, Ajax, Bootstrap etc. Also, I already developed modal dialogs. I have read your requirements and understand what you need. I will de More

$300 USD in 10 days
(90 Reviews)
7.0
tranngocanh1702

Hi, I am Anna with more than 5 years experience in PHP, Laravel framework, Slim, CodeIgniter, MySQL, PostgreSQL, HTML, CSS, Javascript, jQuery, Vuejs, Ajax, WordPress template & plugin, WooCommerce. I am able to More

$600 USD in 12 days
(95 Reviews)
7.2
$555 USD in 10 days
(27 Reviews)
7.1
$555 USD in 14 days
(108 Reviews)
6.6
fashionsoft

Hello Sir,  I have just read your project description and understood all the basic requirements mentioned in there as I have more than 10 years of experience in this field.  So can we please discuss more now to get s More

$750 USD in 7 days
(73 Reviews)
6.5
JinNg

Hi, My name is Jin. Lets talk about your project. 1. You require assistance with 1 data entry form in your existing CRUD system. 2. I see that you have taken the time to list out all your requirements in detai More

$280 USD in 4 days
(33 Reviews)
6.6
shreeyait

[url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view]

$780 USD in 15 days
(69 Reviews)
7.1
maksimchukmak

Hello! My name is Maksim, from Kiev, Ukraine (UTF + 2) We are the company Intobi. Our developers have huge experience in developing different enterprise solutions. Our team has experience with such technologies More

$555 USD in 10 days
(25 Reviews)
6.6
ravichedwal

hello sir i am very good php developer please chat with me once so we can make a very good web app for you sir thanks sir

$666 USD in 10 days
(68 Reviews)
6.3
hjr122413

Hi. Thanks for your posting. I am familiar with CRUD using php, mysql and ajax. I have read your requirements carefully. I absolutely can meet your requirements. *************************************************** More

$250 USD in 3 days
(45 Reviews)
6.0
$250 USD in 3 days
(131 Reviews)
6.1
brendanmullan90

Hello there, my name is Brendan. I have read your project specifications and would love to come on board and complete this task for you. I am available to begin immediately. - 9 years experience in Web Development & More

$333 USD in 3 days
(46 Reviews)
5.5
darshring

I Will Give You Great Successful Changes and Many Helps!!! Hello, how are you? I'm glad to tell you about your project. As you can see at my profile, i am a PHP, MySQL and Javascript Expert and have great skills an More

$555 USD in 10 days
(24 Reviews)
5.6
ludiac

Hi there, We've reviewed the detailed description of requirements you have supplied and would like to review the already done work. Once we have that, we can review the additional work needed and can get you an acc More

$300 USD in 5 days
(23 Reviews)
5.9
libxml1

Hi, I'm interested and would like to see the mentioned partially working model. I'm a full stack web developer and can finish the work quickly, contact me any time!

$350 USD in 3 days
(45 Reviews)
5.8
alexandersergee

Hello! How do you do. This project is a piece of cake. I am very interested in your job. After reading about the job description I was thrilled to discover that all the requirements you need from applicants precisel More

$611 USD in 10 days
(3 Reviews)
5.7
logicshine

Dear Sir, This is Rajesh from Tech-Bee. We are a team of experienced professionals specialized website and mobile app development. I have gone through the requirement and interested to work on this project involving More

$600 USD in 5 days
(27 Reviews)
5.6