Information
Administrator
$host = "host=localhost";//host ที่ใช้ในการติดต่อกับ Server
$port = "port=5432";//หมายเลข port ที่ใช้ (บางเครื่องอาจจะใช้ 5433 หรือเลขอื่น)
$dbname = "dbname=sensor2019";//ใส่ชื่อฐานข้อมูลที่ต้องการทำการเชื่อมต่อ
$credentials = "user=postgres password=!giscidatabase";
$objDB = mysql_connect( "$host $port $dbname $credentials" );
//*** Add Condition ***//
if($_POST["hdnCmd"] == "Add")
{
$strSQL = "INSERT INTO ## ";
$strSQL .="(ID,Name,Email,Tell,User,Passtword) ";
$strSQL .="VALUES ";
$strSQL .="('".$_POST["txtAddID"]."','".$_POST["txtAddName"]."' ";
$strSQL .=",'".$_POST["txtEmail"]."' ";
$strSQL .=",'".$_POST["txtAddTelle"]."','".$_POST["txtAddUser"]."' ";
$strSQL .=",'".$_POST["txtAddPasstword"]."') ";
$objQuery = mysql_query($strSQL);
if(!$objQuery)
{
echo "Error Save [".mysql_error()."]";
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
//*** Update Condition ***//
if($_POST["hdnCmd"] == "Update")
{
$strSQL = "UPDATE administrator SET ";
$strSQL .="ID = '".$_POST["txtEditID"]."' ";
$strSQL .=",Name = '".$_POST["txtEditName"]."' ";
$strSQL .=",Email = '".$_POST["txtEditEmail"]."' ";
$strSQL .=",Tell = '".$_POST["txtEdiTell"]."' ";
$strSQL .=",User = '".$_POST["txtEditUser"]."' ";
$strSQL .=",Passtword = '".$_POST["txtEditPasstword"]."' ";
$strSQL .="WHERE ID = '".$_POST["hdnEditID"]."' ";
$objQuery = pg_query($strSQL);
if(!$objQuery)
{
echo "Error Update [".mysql_error()."]";
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
//*** Delete Condition ***//
if($_GET["Action"] == "administrator.php")
{
$strSQL = "DELETE FROM administrator ";
$strSQL .="WHERE ID = '".$_GET["ID"]."' ";
$objQuery = mysql_query($strSQL);
if(!$objQuery)
{
echo "Error Delete [".mysql_error()."]";
}
//header("location:$_SERVER[PHP_SELF]");
//exit();
}
$strSQL = "SELECT * FROM administrator";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
mysql_close($objConnect);
?>