php基础七

<!-- 第十三章php操作数据库 -->
<?php
//     $sql = "insert into money(username,age) values('bao3', 25)";
//     $con = mysqli_connect("localhost","root","root");
//     if (!$con) {
//         die('Could not connect:'.mysql_error());
//     }
//     echo '连接成功！';
    
    
//     mysqli_select_db($con, 'mytest');
//     $result = mysqli_query($con, $sql);
//     var_dump($result);
//     mysqli_close($con)
?>

<form action="" method="post">
    用户名：<input type="text" name="username" /><br />
    密码：<input type="password" name="password" /><br />
  重复密码：<input type="password" name="repassword" /><br />
  <input type="submit" value="提交" />
</form>

<?php
    if (trim(@$_POST['password']) != trim(@$_POST['repassword'])) {
        exit('两次密码不一致，请返回上一页');
    }
    
    @$username = trim($_POST['username']);
    @$password = md5(trim($_POST['password']));
    @$time = date('ymd',time());
    $ip = $_SERVER['REMOTE_ADDR'];
    $conn = mysqli_connect('localhost', 'root', 'root');
    if (mysqli_error($conn)) {
        echo mysqli_error($conn);
        exit;
    }
    
    mysqli_select_db($conn, 'book');
    mysqli_set_charset($conn, 'utf-8');
    mysqli_set_charset($conn, 'gb2312');
    $sql = "insert into user(username,password,createtime,createip)
         values('".$username."','".$password."','".$time."','".$ip."')";
    $result = mysqli_query($conn, $sql);
    if ($result) {
        echo '成功';
    }else {
        echo '失败';
    }
    
    echo '当前用户插入的ID为'.mysqli_insert_id($conn);
    mysqli_close($conn);
?>

<!-- 做一个列表显示 -->
<?php
    $conn = mysqli_connect('localhost', 'root', 'root', 'book');
    if (mysqli_errno($conn)) {
        mysqli_error($conn);
        exit;
    }
    mysqli_set_charset($conn, 'utf8');
    mysqli_set_charset($conn, 'gb2312');
    $sql = "select id,username,createtime,createip from user order by id desc";
    $result = mysqli_query($conn, $sql);
    if ($result && mysqli_num_rows($result)) {
        echo '<table width="800" border="1">';
        while ($row = mysqli_fetch_assoc($result)){
            echo '<tr>';
            echo '<td>'.$row['username'].'</td>';
            echo '<td>'<!-- 第十三章php操作数据库 -->
<?php
//     $sql =