在php和mysql中创建多维数组

// 创建一个二维数组
$array = array(
    array("Apple", "Banana", "Cherry"),
    array("Dog", "Elephant", "Fox"),
    array("Grapes", "Honeydew", "Kiwi")
);

// 创建一个三维数组
$array = array(
    array(
        array("Red", "Green", "Blue"),
        array("Yellow", "Orange", "Purple")
    ),
    array(
        array("Cat", "Dog", "Rabbit"),
        array("Bird", "Fish", "Turtle")
    )
);

// 创建一个带有键名的多维数组
$array = array(
    "fruits" => array("Apple", "Banana", "Cherry"),
    "animals" => array("Dog", "Elephant", "Fox"),
    "colors" => array("Red", "Green", "Blue")
);

-- 创建一个存储商品信息的表
CREATE TABLE products (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50),
    price DECIMAL(10, 2)
);

-- 创建一个存储商品分类信息的表
CREATE TABLE categories (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50)
);

-- 在products表中添加一个外键列，关联categories表的id列
ALTER TABLE products ADD category_id INT;
ALTER TABLE products ADD CONSTRAINT fk_category FOREIGN KEY (category_id) REFERENCES categories(id);

-- 插入示例数据
INSERT INTO categories (name) VALUES ('Electronics'), ('Clothing');
INSERT INTO products (name, price, category_id) VALUES ('iPhone', 999.99, 1), ('T-shirt', 19.99, 2), ('Headphones', 79.99, 1);

-- 查询所有分类及其对应的商品
SELECT c.name AS category, p.name AS product, p.price
FROM categories c
JOIN products p ON c.id = p.category_id;