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

About the Employer:
( 3 reviews ) Miraflores, Peru

Project ID: #15805076

54 freelancers are bidding on average $428 for this job

$555 USD in 10 days
(102 Reviews)
7.4
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
(350 Reviews)
7.6
kssalexander2

Dear sir. I am so interested in your project. As you can see my profile I am talented developer. If I have promise, I never break it. I am ready just now and can do best work for you. Please send me message so tha More

$555 USD in 10 days
(40 Reviews)
7.7
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
(116 Reviews)
7.4
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
(125 Reviews)
7.5
$555 USD in 10 days
(34 Reviews)
7.3
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
(95 Reviews)
7.1
$555 USD in 14 days
(124 Reviews)
6.7
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
(82 Reviews)
6.8
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
(92 Reviews)
7.0
shreeyait

[login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL]

$780 USD in 15 days
(70 Reviews)
7.1
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
(43 Reviews)
6.7
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
(37 Reviews)
6.7
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
(27 Reviews)
6.7
AzzkaNoor

Hello there. I have seen your job posting. I will like to ask some questions. Please come over the chat so we can discuss things. Some intro about me. I am an enthusiastic developer/implementer who does not stop until More

$555 USD in 10 days
(23 Reviews)
6.7
$250 USD in 3 days
(155 Reviews)
6.2
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
(74 Reviews)
6.5
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
(25 Reviews)
6.0
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
WebcoderSaurabh

We have excellent experience in Website Development. I believe my abilities would be perfect for your venture. I am professional website developer/programmer. I have 6+ years of experience in this field. I will be serv More

$555 USD in 10 days
(29 Reviews)
6.1