Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

hello, im having a problem with my VS Code. I have my webpage linked to my PHP but and it loads the information in the

hello, im having a problem with my VS Code. I have my webpage linked to my PHP but and it loads the information in the charts. but it wont add/delete/edit the information. here is my code:

    Week3 Pa - Lacie   

Current Users:

First Name Date of Birth Favorite Color Favorite Place to Visit Nickname
" name="UserNo">
" name="UserNo">

Enter your first name:

Enter your date of birth:

Enter your favorite color:

Enter your favorite place to visit:

Enter your Nickname:

Here is the SQL code:

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00";

-- Database: cis224_wk3pa CREATE DATABASE IF NOT EXISTS cis224_wk3pa DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; USE cis224_wk3pa;

-- Table structure for table personal_info DROP TABLE IF EXISTS personal_info; CREATE TABLE personal_info ( UserNo int(11) NOT NULL, FullName varchar(50) NOT NULL, Birthdate varchar(25) NOT NULL, FavoriteColor varchar(50) NOT NULL, FavoritePlace varchar(50) NOT NULL, Nickname varchar(25) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Data for table personal_info INSERT INTO personal_info (UserNo, FullName, Birthdate, FavoriteColor, FavoritePlace, Nickname) VALUES (1, 'Administrator', 'January 1, 2000', 'Green', 'Home', 'Admin'), (2, 'Your Name', 'Your B-Day', 'Your Color', 'Your Place', 'Nickname');

-- Indexes for table personal_info ALTER TABLE personal_info ADD PRIMARY KEY (UserNo);

-- AUTO_INCREMENT for table personal_info ALTER TABLE personal_info MODIFY UserNo int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; COMMIT;

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

Demystifying Databases A Hands On Guide For Database Management

Authors: Shiva Sukula

1st Edition

8170005345, 978-8170005346

More Books

Students also viewed these Databases questions

Question

5. If yes, then why?

Answered: 1 week ago

Question

6. How would you design your ideal position?

Answered: 1 week ago