ต้องการเพิ่มวันที่ปัจจุบัน-fname-lname ต่อ จากcode เดิมที่มีอยู่แล้ว
Code (PHP) <? include("connectdb.php");
$today = date("Y-m-d");
$tt = date("H:i:s");
?>
--------------------------------------------------------
<? $strSQL10 = "select l.id,l.name,l.strdate,l.strtime,l.enddate,l.endtime,fname,lname,r.name as rname,l.mstatus from meeting_list l ";
$strSQL10 .= " left outer join meeting_room r on r.id = l.room ";
$strSQL10 .= " where l.user = '".$_SESSION["member_id"]."'";
$strSQL10 .= " ORDER BY l.id DESC ";
--------------------------เพิ่มcode ใหม่----------------------------------
$strSQL = "INSERT INTO meeting_list";
$strSQL .= "('id', 'date', 'strdate', 'enddate', 'strtime', 'endtime', 'room', 'room_type', 'name', 'qty', 'user', 'conduct', 'conduct_1', 'conduct_2', 'conduct_3', 'conduct_2_qty', 'conduct_3_qty', 'budget', 'mstatus', 'fname', 'lname')";
$strSQL .= "VALUES";
$strSQL .= " ( ' '', '$today', '', '','','','','','','','','','','','','','','','','',' ".$_SESSION["member_fname"]." ',' ".$_SESSION["member_lname"]." ')";
$objQuery = mysql_query($strSQL);
$objQuery10 = mysql_query($strSQL10) or die ("Error Query [".$strSQL10."]");
?>
Tag PHP, MySQL
ประวัติการแก้ไข
Date :
2015-12-16 10:32:29By :
baby137View :
1153Reply :
12
Code (PHP) echo $strSQL;
Date :
2015-12-16 11:55:39By :
mr.win
Code (PHP) $strSQL = "INSERT INTO meeting_list (date, fname, lname) VALUES (NOW(),$_SESSION["member_fname"],$_SESSION["member_lname"])";
Date :
2015-12-16 14:12:01By :
noMerzy
Code (PHP) $strSQL = 'INSERT INTO meeting_list (date, fname, lname) VALUES (NOW(),"' . $_SESSION["member_fname"] . '","' . $_SESSION["member_lname"] . '")';
Date :
2015-12-16 14:28:07By :
noMerzy
1. ลอง echo $_SESSION["member_fname"] ; ดูครับว่ามีตัวแปลมาไหม
Date :
2015-12-16 14:50:38By :
noMerzy
$now = date("Y-m-d H:i:s")
Date :
2015-12-16 23:19:30By :
noMerzy
Server 03
Load balance : Server 03
