|  |  | 
          
            | คือต้องการให้เช็คว่าล๊อคอินมาแร้วหรือยัง และต้องการให้ส่งค่าว่าใครล๊อคอินไปทุกๆหน้าจนกว่าจะ logout ออก แต่หน้าที่เป็น การเพิ่ม/แก้ไข/ลบ ในหน้าเดียวกันดันไม่รู้ว่าต้องใส่ค่าอะไรไว้ตรงไหนบ้างอ่ะค่ะ
 
 
 Code (PHP)
 
 <?php session_start();
include ("../conn/connect_db_server.php");
if($_SESSION['id_admin'] == "")
{
	echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>";
		echo "<script language=\"JavaScript\"> alert('ท่านยังไม่ได้ทำการ Login นะค่ะ') </script>";
		echo "<meta http-equiv='refresh' content='0;URL=../index.php'>"; 
		exit();
}
$id_admin=$_GET['id_admin'];
include "function.php";
$date_today=date("Y-m-d");
$date_today=displaydate($date_today); 
?>
<div class="row">
                  <div class="col-md-2"></div>
<? include("../conn/connect_db_server.php");
if($_POST["hdnCmd"] == "Add")
{
	$strSQL = "INSERT INTO data_advertising ";
	$strSQL .="(id,id_adv,name_adv,id_project,id_media,status,date_today) ";
	$strSQL .="VALUES ";
	$strSQL .="('','".$_POST["txtAddid_adv"]."','".$_POST["txtAddname_adv"]."' ";
	$strSQL .=",'".$_POST["txtAddid_project"]."' ";
	$strSQL .=",'".$_POST["txtAddid_media"]."','".$_POST["txtAddstatus"]."' ";
	$strSQL .=",'$date_today') ";
	$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 data_advertising SET ";
	$strSQL .="id_adv = '".$_POST["txtEditid_adv"]."' ";
	$strSQL .=",name_adv = '".$_POST["txtEditname_adv"]."' ";
	$strSQL .=",id_project = '".$_POST["txtEditid_project"]."' ";
	$strSQL .=",id_media = '".$_POST["txtEditid_media"]."' ";
	$strSQL .=",status = '".$_POST["txtEditstatus"]."' ";
	$strSQL .=",date_today = '".$_POST["txtEditdate_today"]."' ";
	$strSQL .="WHERE id = '".$_POST["hdnEditid"]."' ";
	$objQuery = mysql_query($strSQL);
	if(!$objQuery)
	{
		echo "Error Update [".mysql_error()."]";
	}
	//header("location:$_SERVER[PHP_SELF]");
	//exit();
}
//*** Delete Condition ***//
if($_GET["Action"] == "Del")
{
	$strSQL = "DELETE FROM data_advertising ";
	$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 data_advertising WHERE id_project = $id_project and status ='2' ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
       
 
  <div class="col-md-10"> <h3>Walk in / Call จากสื่อ โครงการ </h3>
   <form name="frmMain" method="post" action="<?php echo $_SERVER["PHP_SELF"];?>?id_project=<?php echo "$id_project";?>">
<input type="hidden" name="hdnCmd" value="">
<input type="hidden" name="id" value="">
<table class="table">
  <tr>
  <td> <div align="center">id </div></td>
    <td> <div align="center">รหัสสื่อโฆษณา </div></td>
    <td> <div align="center">ชื่อสื่อโฆษณา </div></td>
    <td> <div align="center">โครงการ</div></td>
    <td> <div align="center">ประเภทสื่อ</div></td>
    <td> <div align="center">สถานะ</div></td>
    <td> <div align="center">เวลา </div></td>
    <td> <div align="center">Edit </div></td>
    <td> <div align="center">Delete </div></td>
  </tr>
<?php
 $i=1; 
while($objResult = mysql_fetch_array($objQuery))
{
?>
  <?php
	if($objResult["id"] == $_GET["id"] and  $_GET["Action"] == "Edit")
	{
  ?>
  <tr>
<td><div align="center"><?=$i++;?></div></td>
<td><div align="center">
<input type="text" name="txtEditid_adv" size="5" value="<?php echo $objResult["id_adv"];?>">
<input type="hidden" name="hdnEditid" size="5" value="<?php echo $objResult["id"];?>">
</div></td>
<td><input type="text" name="txtEditname_adv" size="20" value="<?php echo $objResult["name_adv"];?>"></td>
<td><input type="text" name="txtEditid_project" size="20" value="<?php echo $objResult["id_project"];?>"></td>
<td><div align="center"><input type="text" name="txtEditid_media" size="2" value="<?php echo $objResult["id_media"];?>"></div></td>
<td align="right"><input type="text" name="txtEditstatus" size="5" value="<?php echo $objResult["status"];?>"></td>
<td align="right"><input type="text" name="txtEditdate_today" size="5" value="<?php echo $objResult["date_today"];?>"></td>
<td colspan="2" align="right"><div align="center">
<input name="btnUpdate" type="button" id="btnUpdate" value="Update" onClick="frmMain.hdnCmd.value='Update';frmMain.id.value='<?php echo $objResult["id"]; ?>';frmMain.submit();" class="btn btn-success">
<input name="btnAdd" type="button" id="btnCancel" value="Cancel" OnClick="window.location='<?php echo $_SERVER["PHP_SELF"];?>?id_project=<?php echo "$id_project";?>';" class="btn btn-danger">
</div></td>
</tr>
  <?php
	}
  else
	{
  ?>
  <tr>
   <td><div align="center"><?=$i++;?></div></td>
    <td><div align="center"><?php echo $objResult["id_adv"];?></div></td>
    <td><?php echo $objResult["name_adv"];?></td>
    <td><?php echo $objResult["id_project"];?></td>
    <td><div align="center"><?php echo $objResult["id_media"];?></div></td>
    <td align="right"><?php echo $objResult["status"];?></td>
    <td align="right"><?php echo $objResult["date_today"];?></td>
    <td align="center"><a href="<?php echo $_SERVER["PHP_SELF"];?>?Action=Edit&id=<?php echo $objResult["id"];?>&id_project=<?php echo "$id_project";?>"><img src="img/icon/edite.png" width="30" height="30"></a></td>
	<td align="center"><a href="JavaScript:if(confirm('Confirm Delete?')==true){window.location='<?php echo $_SERVER["PHP_SELF"];?>?Action=Del&id=<?php echo $objResult["id"];?>&id_project=<?php echo "$id_project"; ?>';}"><img src="img/icon/delete.png" width="30" height="30"></a></td>
  </tr>
  <?php
	}
	?>
    <?php
	
}
?>
  <tr>
  <td align="right"></td>
    <td><div align="center"><input type="text" name="txtAddid_adv" size="5"></div></td>
    <td><input type="text" name="txtAddname_adv" size="20"></td>
    <td><input type="text" name="txtAddid_project" size="20"></td>
    <td><div align="center"><input type="text" name="txtAddid_media" size="2"></div></td>
    <td align="right"><input type="text" name="txtAddstatus" size="5"></td>
    <td align="right"></td>
    <td colspan="2" align="right"><div align="center">
      <input name="btnAdd" type="button" id="btnAdd" value="Add" OnClick="frmMain.hdnCmd.value='Add';frmMain.id.value='<?php echo "$id_project";?>';frmMain.id_admin.value='<?php echo "$id_admin";?>';frmMain.submit();" class="btn btn-default">
    
    </div></td>
  </tr>
</table>
</form>
      </div>
                      
                      </div>
 
 
 Tag : PHP, MySQL
 
 
 |  
            |  |  
            | 
              
                |  |  |  |  
                |  | 
                    
                      | Date :
                          2015-02-19 10:39:31 | By :
                          gungging302 | View :
                          890 | Reply :
                          6 |  |  |  
                |  |  |  |  |  
            |  |  
		            |  |