Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problems with AJAX/JQuery. Creatiung a HTML form that contains three input fields and an update button. After user enters an email in the email field,

Problems with AJAX/JQuery. Creatiung a HTML form that contains three input fields and an update button. After user enters an email in the email field, the form auto populates other fields. Display a message asks if user needs to update the information. If so, use can update the information (After user hits the Update button, display a message saying your information has been updated. Keep other parts on the screen as it is) . Do all these using AJAX/JQuery.

------index.html-----------

include('db.php'); $email=$_POST['email']; $address=$_POST['address']; $phone=$_POST['phone'];

$stmt = $DBcon->prepare("INSERT INTO student(email,address,phone) VALUES(:email, :address,:phone)");

$stmt->bindparam(':email', $email); $stmt->bindparam(':address', $address); $stmt->bindparam(':phone', $sphone); if($stmt->execute()) { $res="Data Inserted Successfully:"; echo json_encode($res); } else { $error="Not Inserted,Some Probelm occur."; echo json_encode($error); } ?>

Email:
Address:
Phone:

----------db.sql---------

CREATE TABLE USER_INFO

(EMAIL varchar(40) NOT NULL,

ADDRESS VARCHAR(100) NOT NULL,

PHONE VARCHAR(10) NOT NULL,

PRIMARY KEY (EMAIL) );

INSERT INTO USER_INFO(

Email,

Address,

Phone)

values('fake@ppp.com', '123 Easy St.', '555555555');

INSERT INTO USER_INFO(

Email,

Address,

Phone)

values('notreal@ppp.com', '555 Main St.', '123456789');

INSERT INTO USER_INFO(

Email,

Address,

Phone)

values('unreal@pp.com', '8008 5th Ave.', '987654321');

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design

Authors: Marion Donnie Dutton Don F. Seaman

14th Edition Globel Edition

1292107634, 978-1292107639

More Books

Students also viewed these Databases questions

Question

4. What will the team agreement contain?

Answered: 1 week ago