mismatch_editprofile 编辑

<?php 
// 内容框里怎么读出数据库的存值?? 3/7
// 更新会一直上传图片   原图片是否能删除？
require_once('comment/startsession.php');
$title = "View Profile";
require_once('comment/header.php');
require_once('comment/navmenu.php');
require_once('dbc.php');
date_default_timezone_set('PRC');

if(isset($_SESSION['user_id'])) {
    echo '<p>You are logged in as '.$_SESSION['username'].', <a href="mismatch_logout">LogOut</a></p>';
    $user_id = $_SESSION['user_id'];
}
if (isset($_POST['submit'])) {

    $firstname = mysqli_real_escape_string($dbc,trim($_POST['firstname']));
    $lastname = mysqli_real_escape_string($dbc,trim($_POST['lastname']));
    $gender = mysqli_real_escape_string($dbc,trim($_POST['gender']));
    $birthday = mysqli_real_escape_string($dbc,trim($_POST['date']));
    $city = mysqli_real_escape_string($dbc,trim($_POST['city']));
    $state = mysqli_real_escape_string($dbc,trim($_POST['state']));
    $picture = mysqli_real_escape_string($dbc,trim($_FILES['picture']['name']));
    $screenshot_type = $_FILES['picture']['type'];// 类型格式 image/jpeg
    $screenshot_size = $_FILES['picture']['size']/1024;
    // echo $screenshot_type.'<br>';
    // echo $screenshot_size.'<br>';

    if (!empty($firstname) && !empty($lastname) && !empty($gender) && !empty($city) && !empty($state) && !empty($picture)) {
        //检测文件类型及大小限制
        if (($screenshot_type == 'image/png' || $screenshot_type == 'image/gif' || $screenshot_type == 'image/jpeg') && ($screenshot_size > 0) && ($screenshot_size <= MAXFILESIZE)) {
            //如果图片上传成功
            if($_FILES['picture']['error'] == 0){
                //确定好文件名与图片路径
                $target = UPLOADPATH.time().$picture;
                if (move_uploaded_file($_FILES['picture']['tmp_name'], $target)) {
                    //增加了时间变量 需要与路径名一直
                    $picture = time().$picture;
                    $user_id = $_SESSION['user_id'];
                    $query = "update match_user set first_name='$firstname',last_name='$lastname',gender='$gender',birthday='$birthday',city='$city',state='$state',picture='$picture' where user_id = $user_id";
                    // echo $query;
                    // die();
                    mysqli_query($dbc,$query) or die('error in insert');
                    echo '<p style="color:green">update seccessful,first_name='.$firstname.', last_name='.$lastname.', gender='.$gender.', birthday='.$birthday.', city='.$city.', state='.$state.', picture='.$picture.'</p>';
                }

            }
        }else{
            echo 'picture only allow png,gif,jpg and file size need < '.(MAXFILESIZE/1024).'KB in size.';
    }

}else{
    echo 'please insert all info';
    }
}
$user_id = $_SESSION['user_id'];
$query = "select * from match_user where user_id = $user_id";
        $data = mysqli_query($dbc,$query);
        while ($row = mysqli_fetch_array($data)) {
            echo $row['first_name'].'<br>';
            echo $row['last_name'].'<br>';
            echo $row['gender'].'<br>';
            echo date("Y-m-d",strtotime($row['birthday'])).'<br>';//将时间转化为时间戳后取格式
            echo $row['city'].'<br>';
            echo $row['state'].'<br>';
            echo '<img src="'.UPLOADPATH.$row['picture'].'" width="100px" height=100px><br>';

        }
?>

    <hr>
    
    <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data">
        <fieldset>
            <legend>Personal Information</legend>
            <!-- 最大上传32k -->
            <input type="hidden" name="MAX_FILE_SIZE" value="<?php echo MAXFILESIZE; ?>" />
            <label for="firstname"> First name:</label>
            <input type="text" name="firstname" id="firstname" value="<?php if (!empty($first_name)) echo $firstname; ?>"/><br>
            <label for="lastname">Last name:</label>
            <input type="text" name="lastname" id="lastname" value="<?php if (!empty($lastname)) echo $lastname; ?>"><br>
            <label>Gender:</label>
            <select name="gender">
                <option value="male">Male</option>
                <option value="female">Female</option>
            </select><br>
            <label for="date">Birthday:</label>

            <input type="date" name="date" value="<?php echo date("Y-m-d"); ?>"><br>
            <label for="city">City:</label>
            <input type="text" name="city" id="city" value="<?php if (!empty($city)) echo $city; ?>"><br>
            <label for="state">State:</label>
            <input type="text" name="state" id="state" value="<?php if (!empty($state)) echo $state; ?>"><br>
            <label for="picture">Picture:</label>
            <input type="file" name="picture" id="picture" value=""><br>
            <!-- <img src="'.<?php  if(!empty($target)) echo  $target;?>.'" width="100px" height="100px"> -->
              
             

            <hr />
            <input type="submit" name="submit" value="Submit" />
        </fieldset>
        
    </form>    

<?php
require_once('comment/footer.php');
mysqli_close($dbc);
?>