add_staf_chk.php

来自「一个很不错的oa系统,简单好用,数据库是用mysql5,所以大家要注意,不要因为」· PHP 代码 · 共 15 行

<?php
	session_start(); 
	include "../inc/chec.php";
	include "../conn/conn.php";
	include "../inc/func.php";
$g_sql = "select id,u_member from tb_group where id = ".$_POST[u_group];
	$g_result = mysql_query($g_sql,$conn);
	$g_rows = mysql_fetch_row($g_result);
	$g_mem = $g_rows[1].$_POST[u_name].",";
	$a_sql = "update tb_group set u_member = '".$g_mem."' where id = ".$_POST[u_group];
	mysql_query($a_sql,$conn);
	$sqlstr = "insert into tb_users (u_user,u_pwd,u_name,u_sex,u_birth,u_address,u_tel,u_email,u_depart,is_on) values('".$_POST[u_user]."','".$_POST[u_pwd]."','".$_POST[u_name]."','".$_POST[u_sex]."','".$_POST[u_birth]."','".$_POST[u_address]."','".$_POST[u_tel]."','".$_POST[u_email]."','".$_POST[u_depart]."',1)";
	$result = mysql_query($sqlstr,$conn);
	re_message($result,"show_staf.php");
?>