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 | ||
---|---|---|---|---|---|---|
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started