$objConnect = mysqli_connect('localhost','csitdb','DB@csit2567') or die("Error Connect to Database");
$objDB = mysqli_select_db($objConnect,"dbiclass");
// $objConnect = mysql_connect("localhost","root","987654321") or die("Error Connect to Database");
// $objDB = mysql_select_db("dbstevent");
date_default_timezone_set('Asia/Bangkok');
?>
[e-Event System]
// include 'include/inc_mainmenu.php'; ?>
[ ST-Event System]
คณะวิทยาศาสตร์
มหาวิทยาลัยนเรศวร
//user
if($_POST["chkUserGroup"] == "1")
{
//echo "User";
// Search By user_ID *** escape ***
$_POST['txtUser'] = mysqli_real_escape_string($objConnect, $_POST['txtUser']);
$_POST['txtPassword'] = mysqli_real_escape_string($objConnect, $_POST['txtPassword']);
$strSQL = "SELECT * FROM student where (student.st_id ='".$_POST["txtUser"]."') and (student.st_pwd ='".$_POST["txtPassword"]."')";
//echo $strSQL;
$objQuery = mysqli_query($objConnect, $strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysqli_fetch_array($objQuery);
if(empty($objResult["st_id"]))
{ echo "
Not Found !!! "; }
else {
$_SESSION["SesUser"] = $objResult["st_id"];
header("Location: indexuser.php");
}
}elseif($_POST["chkUserGroup"] == "2"){
//Admin
if($_POST["txtUser"] != "")
{
// Search By user_ID *** escape ***
//echo "Admin";
$_POST['txtUser'] = mysqli_real_escape_string($objConnect, $_POST['txtUser']);
$_POST['txtPassword'] = mysqli_real_escape_string($objConnect, $_POST['txtPassword']);
$strSQL = "SELECT * FROM users where (users.user_id ='".$_POST["txtUser"]."') and (users.user_pwd ='".$_POST["txtPassword"]."')";
$objQuery = mysqli_query($objConnect, $strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysqli_fetch_array($objQuery);
if(empty($objResult["user_id"]))
{ echo "
Not Found !!! "; }
else {
$_SESSION["usergrp_id"] = $objResult["usergrp_id"];
$_SESSION["SesUser_id"] = $objResult["user_id"];
header("Location: eventlist.php");
}
}}
mysqli_close($objConnect);
?>
include 'include/inc_footer.php'; ?>