Please enable JavaScript.

Coggle requires JavaScript to display documents.

股票交易平台 (版本1 (索引页 index.php (引入 common.php 配置文件 (数据库操作 http://blog.csdn…

- - - - 定义默认时区 date_default_timezone_set();
      - 定义 ROOT 为当前文件所在的目录
        define('ROOT',dirname(FILE));
      - 数据库操作
        http://blog.csdn.net/hao54216/article/details/53894251
        
        链接数据库
        
        $servername="localhost";
        $username="root";
        $userpassword="**";
        $conn = new mysqli($servername,$username,$userpassword);
        if($conn->connect_error){
        die('连接失败'.$conn->connect_error);
        }else{
        echo "连接成功";
        }
        
        数据库查询
        
        $sql = 'SELECT name, pwd FROM person where name="daxiong"'; $retval = mysqli_query( $conn, $sql ); if(! $retval ) { die('无法读取数据: ' . mysqli_error($conn)); }else{ echo '读到数据'; $row = mysqli_fetch_array($retval, MYSQL_ASSOC); $name .=$row['name']; $pwd .=$row['pwd']; }
        
        http://www.jb51.net/article/33642.htm
        
        建库
        
        $createdatabase="create database mystockdb"; if($conn->query($createdatabase)==true){ echo "创建数据库成功"; }else{ echo "Error creating database: " . $conn->error; }
        
        使用库
        
        $usedb="USE mystockdb"; 或者mysqli_select_db( $conn, 'RUNOOB' ); if($conn->query($usedb)==true){//执行 echo "选择数据库成功"; }else{ echo "Error use mystockdb " . $conn->error; }
        
        插入数据
        
        $createtable="create table person(id int(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY,name text,pwd text)"; if($conn->query($createtable)==true){//执行 echo "创建表person成功"; }else{ echo "Error creating table: " . $conn->error; }
- - - - 定义默认时区 date_default_timezone_set();
      - 定义 ROOT 为当前文件所在的目录
        define('ROOT',dirname(FILE));