xcdha / jiasuqi Goto Github PK

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

CREATE TABLE `user` (
  `ID` int(11) NOT NULL,
  `UserName` text NOT NULL,
  `PassWord` text NOT NULL,
  `Info` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

ALTER TABLE `user`
  ADD PRIMARY KEY (`ID`);

ALTER TABLE `user`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;

<?php
    $lianJie = mysqli_connect("localhost", "root", "", "jiasuqi");
    // 提示数据库状态
    if ($lianJie) {
        // echo "数据库就绪";
    } else {
        echo "数据库错误";
    }
?>