note 130102 added to function.mysqli-connect
| From: | Anonymous | Date: | Fri, 28 Feb 2025 18:12:55 +0000 |
| Subject: | note 130102 added to function.mysqli-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-221928@lists.php.net to get a copy of this message | ||
Drop the existing tables
DROP TABLE IF EXISTS invoiceItems???;
DROP TABLE IF EXISTS invoices???;
DROP TABLE IF EXISTS products???;
DROP TABLE IF EXISTS customers???;
-- Create table customers???
CREATE TABLE customers??? (
customerID CHAR (5) PRIMARY KEY,
customerName VARCHAR(30) NOT NULL,
address VARCHAR(20) NOT NULL,
city VARCHAR(30) NOT NULL,
provinceID CHAR(2) NOT NULL,
postalCode CHAR(6) NOT NULL
);
-- Create table products???
CREATE TABLE products??? (
productID CHAR(10) PRIMARY KEY,
description VARCHAR(100) NOT NULL,
price DECIMAL(6,2),
unit CHAR(6)
);
-- Create table invoices???
CREATE TABLE invoices??? (
invoiceNumber CHAR(7) PRIMARY KEY,
invoiceDate DATE NOT NULL DEFAULT CURRENT_DATE(),
customerID CHAR(5) NOT NULL,
orderConfirmID CHAR(6),
shipBy VARCHAR(20),
CONSTRAINT fkCustomer??? FOREIGN KEY (customerID) REFERENCES customers???(customerID)
);
CREATE TABLE invoiceItems???
(
invoiceNumber CHAR(7),
productID CHAR(10),
invoiceQTY INTEGER NOT NULL,
CONSTRAINT pkInoiceItems??? PRIMARY KEY (invoiceNumber, productID),
CONSTRAINT fkInvoices??? FOREIGN KEY (invoiceNumber) REFERENCES invoices???(invoiceNumber),
CONSTRAINT fkProducts??? FOREIGN KEY (productID) REFERENCES products???(productID)
);
-- Insert to products???
INSERT INTO products??? (productID, description, price)
VALUES
('BL4002', '24"w SURFACE SLIDER', 79.00),
('BL4003', '30"w SURFACE SLIDER', 88.00),
('BL4004', '48"w SURFACE SLIDER', 126.00),
('BL602', '16"w x 22"h x 3 1/2"d White powder coated',
60.00),
('BL612', '16"w x 22"h x 3 1/2"d White powder coated
Surface-mounted', 65.00),
('ES2424', '24"w x 24"h x 4 1/2"d White powder coated',
80.00),
('ES3024', '30"w x 24"h x 4 1/2"d White powder coated',
90.00),
('JV2519', '25"x19 2DR. WH.VAN. C/W CULTURED MARBLE TOP', 280.00),
('GS2426', '24"w x 26"h x 4 1/2"d White powder coated',
120.00),
('GS3026', '30"w x 26"h x 4 1/2"d White powder coated',
150.00),
('JV1917', '19"x 17 1DR. WH.VAN. C/W CULTURED MARBLE TOP', 250.00),
('JV3119', '31"x 19 2DR. WH.VAN. C/W CULTURED MARBLE TOP', 300.00);
-- Insert into customers???
INSERT INTO customers??? (customerID, customerName, address, city, provinceID, postalCode)
VALUES
('AA002', 'The Palm Tree Nursery', '987 6th Ave', 'Santa
Fe', 'NM', '11121'),
('CA043', 'Carlton Regional Clinic', '589 Central Ave.',
'Carlton', 'QE', 'F0C1B3'),
('AC001', 'Avondale Community Bank', '256 Main St.',
'Avondale', 'ON', 'N6A0B3'),
('KC156', 'Key Community College System', '35 Indiana Ave.',
'Walker', 'IN','46004');
-- Insert into invoices???
INSERT INTO invoices??? (invoiceNumber, customerID, orderConfirmID, shipBy)
VALUES
('5010601','AA002', '240401', 'FedEx'),
('5011301','CA043', '240201', 'FedEx'),
('5011302','AC001', '240202', 'Canada Post'),
('5012301','CA043', '240211', 'UPS'),
('5020301','CA043', '240213', 'FedEx'),
('5020302','KC156', '240214', 'Canada Post');
-- Insert into invoiceItems???
INSERT INTO invoiceItems??? (invoiceNumber, productID, invoiceQTY)
VALUES
('5010601', 'BL4002', 20),
('5010601', 'BL4003', 35),
('5010601', 'BL4004', 15),
('5011301', 'BL602', 10),
('5011301', 'BL612', 10),
('5011301', 'ES2424', 5),
('5011302', 'BL612', 20),
('5011302', 'ES3024', 10),
('5012301', 'BL612', 50),
('5020301', 'ES2424', 5),
('5020301', 'JV2519', 5),
('5020301', 'BL602', 20),
('5020302', 'GS2426', 8),
('5020302', 'GS3026', 2),
('5020302', 'JV1917', 20),
('5020302', 'JV2519', 8),
('5020302', 'JV3119', 2);
----
Server IP: 45.112.84.4
Probable Submitter: 45.112.84.18 (proxied: 184.144.65.135)
----
Manual Page -- https://php.net/manual/en/function.mysqli-connect.php
Edit -- https://main.php.net/note/edit/130102
Del: integrated -- https://main.php.net/note/delete/130102/integrated
Del: useless -- https://main.php.net/note/delete/130102/useless
Del: bad code -- https://main.php.net/note/delete/130102/bad+code
Del: spam -- https://main.php.net/note/delete/130102/spam
Del: non-english -- https://main.php.net/note/delete/130102/non-english
Del: in docs -- https://main.php.net/note/delete/130102/in+docs
Del: other reasons-- https://main.php.net/note/delete/130102
Reject -- https://main.php.net/note/reject/130102
Search -- https://main.php.net/manage/user-notes.php