php + mysql 调用数据库内容 =》简介

最新推荐文章于 2022-10-04 15:50:46 发布

历史的旋律

最新推荐文章于 2022-10-04 15:50:46 发布

阅读量339

点赞数

分类专栏： php 技巧

本文链接：https://blog.csdn.net/qq_16644789/article/details/50272151

版权

php 技巧专栏收录该内容

3 篇文章 0 订阅

订阅专栏

1. php 代码 =》index.php

<?php include "conn.php" ;?>

<html>

<body>

   <?php
                                            $result= mysql_query("select * from jianjie where id=3 order by id desc");
                                            while($row= mysql_fetch_array($result)){
                                            ?>
    <p>

     <?php echo $row["neirong"] ; ?>



    </p>
    <?php

    }
    ?>

</body>

</html>

----------------------***************-------------------------************----------------

2. 数据库配置

<?php

$mysql = mysql_connect("localhost","root","root");
mysql_select_db("ceshi_jianjie");
mysql_query("set names UTF8");

date_default_timezone_set("PRC");

?>

-------------------------****************--------------------------***************-----------------------

3.数据库 =》 ceshi_jianjie.sql

/*
Navicat MySQL Data Transfer

Source Server         : root
Source Server Version : 50540
Source Host           : localhost:3306
Source Database       : ceshi

Target Server Type    : MYSQL
Target Server Version : 50540
File Encoding         : 65001

Date: 2015-12-12 02:44:04
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for jianjie
-- ----------------------------
DROP TABLE IF EXISTS `jianjie`;
CREATE TABLE `jianjie` (
`id` int(8) DEFAULT NULL,
`neirong` text COMMENT '内容=》简介'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of jianjie
-- ----------------------------
INSERT INTO `jianjie` VALUES ('2', '222');
INSERT INTO `jianjie` VALUES ('3', '333');
INSERT INTO `jianjie` VALUES ('5', '555');

-- ----------------------------
-- Table structure for list
-- ----------------------------
DROP TABLE IF EXISTS `list`;
CREATE TABLE `list` (
`id` int(8) DEFAULT NULL,
`neirong` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of list
-- ----------------------------
INSERT INTO `list` VALUES ('1', '111');
INSERT INTO `list` VALUES ('2', '22');
INSERT INTO `list` VALUES ('3', '333');
INSERT INTO `list` VALUES ('4', '444');
INSERT INTO `list` VALUES ('5', '555');
INSERT INTO `list` VALUES ('6', '666');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(8) DEFAULT NULL,
`name` varchar(12) DEFAULT NULL,
`list` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '1', '1');

--------------------*****************------------------*****************---------------

历史的旋律

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
php + mysql 调用数据库内容 =》简介

1. php 代码 =》index.php $result= mysql_query("select * from jianjie where id=3 order by id desc");
复制链接

扫一扫