PHP show_user_details_by_id 예제들

예제 #1

파일: user_create_blog.php 프로젝트: WeiliangXing/firewall-network-security

ob_start();
require_once "../includes/db_connection.php";
require_once "../includes/functions.php";
require_once "../includes/session.php";
?>

<?php 
require_once "user_create_blog.php";
?>

<?php 
if (isset($_GET['user_id'])) {
    $_SESSION["user_id"] = $_GET['user_id'];
}
$user = show_user_details_by_id("users", $_SESSION["user_id"]);
?>

<?php 
if (isset($_GET['submit'])) {
    // form was submitted
    $title = $_GET["title"];
    $content = $_GET["content"];
    $query = "INSERT INTO blogs(";
    $query .= "subject_id, title, view_counts,content, create_time, update_time";
    $query .= ") VALUES (";
    $query .= "{$_SESSION["user_id"]}, '{$title}', 1, '{$content}',null,null";
    $query .= ")";
    $result = mysqli_query($connection, $query);
    if ($result) {
        redirect_to("user_main.php?id={$_SESSION["user_id"]}");

예제 #2

파일: edit_user.php 프로젝트: WeiliangXing/firewall-network-security

<?php

require_once "../includes/db_connection.php";
require_once "../includes/functions.php";
global $user;
if (isset($_GET['id'])) {
    $id = $_GET['id'];
    $user = show_user_details_by_id("users", $id);
}
?>

<?php 
if (isset($_GET['submit'])) {
    // form was submitted
    $username = $_GET["username"];
    $password = $_GET["password"];
    if ($_GET["gender"] == "Male") {
        $gender = (int) 1;
    } else {
        $gender = (int) 0;
    }
    $major = $_GET["major"];
    $annual_salary = (int) $_GET["annual_salary"];
    $remark = $_GET["remark"];
    $query = "UPDATE users SET ";
    $query .= "user_name = '{$username}', ";
    $query .= "password = '******', ";
    $query .= "gender = {$gender}, ";
    $query .= "major = '{$major}', ";
    $query .= "annual_salary = {$annual_salary}, ";
    $query .= "remark = '{$remark}' ";

예제 #3

파일: show_user.php 프로젝트: WeiliangXing/firewall-network-security

<?php

require_once "../includes/db_connection.php";
require_once "../includes/functions.php";
require_once "../includes/session.php";
?>

<?php 
$_SESSION["adimn_blog_id"] = null;
?>

<?php 
if (isset($_GET['id'])) {
    $user = show_user_details_by_id("users", $_GET['id']);
    $_SESSION["adimn_user_id"] = $user['id'];
}
?>

<?php 
$layout_context = "admin";
include "../includes/layouts/header.php";
?>

<div>
	<p>
		<a href="manage_content.php">Back</a>
	</p>
	<p>
		<table id="t01">
		  <tr>
		    <td>Username</td>