Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!