php查询数据库，并通过表格展示 |
您所在的位置：网站首页 › php连接数据库查询输出表格内容 › php查询数据库，并通过表格展示 |
php查询数据库，并通过表格展示
|
第一步：创建数据库
创建一个数据库php-crud 第二步：创建数据库表在数据库php-crud下创建一个歌曲表song /* Navicat Premium Data Transfer Source Server : MariaDB Source Server Type : MariaDB Source Server Version : 100605 (10.6.5-MariaDB) Source Host : 127.0.0.1:3306 Source Schema : php-crud Target Server Type : MariaDB Target Server Version : 100605 (10.6.5-MariaDB) File Encoding : 65001 Date: 16/12/2023 20:49:56 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for song -- ---------------------------- DROP TABLE IF EXISTS `song`; CREATE TABLE `song` ( `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '歌曲编号', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '歌曲名', `singer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '歌手', `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述信息', `last_update_time` datetime NULL DEFAULT NULL COMMENT '最后一次修改时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of song -- ---------------------------- INSERT INTO `song` VALUES ('20230822193447', '阴天', '莫文蔚', '', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20230822215824', '赤伶', '执素兮', '', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20230902030903', '直到世界尽头', '张杰', '', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20230906185524', '曾经守候', '张碧晨', '', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20230906185614', '给未来的自己', '梁静茹', '', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20230925223008', '失衡', '梁琪清', '', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20231006181259', '哭砂', '张惠妹', '', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20231006181317', '小小', '容祖儿', '', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20231013232337', '花开忘忧', '周深', '', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20231017163512', '贪杯琥珀', '阿YueYue', '', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20231017163541', '晚风作酒', 'L (桃籽) 、周林枫、三楠', '', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20231103090132', '卿清叙', '圈9', '《猫妖的诱惑》动画OP', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20231110004454', '再见的，不见的', '郁可唯', '《我的女友是机器人》电影主题曲', '2023-12-02 01:30:55'); INSERT INTO `song` VALUES ('20231203192229', '明天', '朱心怡', '《斗破苍穹》决战云岚片尾曲', '2023-12-03 19:23:22'); SET FOREIGN_KEY_CHECKS = 1; 第三步：编写php代码WampServer下的www目录下创建php文件php_select.php 查询MYSQL数据 name single note页面效果如下，注意：EOF里的字符串不能加引号，否则会报错~
|
【本文地址】
今日新闻 |
推荐新闻 |