001.
<?
include
(
"../conn/connect_db_server.php"
);
002.
003.
004.
if
(
$_POST
[
"hdnCmd"
] ==
"Add"
)
005.
{
006.
$strSQL
=
"INSERT INTO data_advertising "
;
007.
$strSQL
.=
"(id,id_adv,name_adv,id_project,id_media,status,date_today) "
;
008.
$strSQL
.=
"VALUES "
;
009.
$strSQL
.=
"('','"
.
$_POST
[
"txtAddid_adv"
].
"','"
.
$_POST
[
"txtAddname_adv"
].
"' "
;
010.
$strSQL
.=
",'"
.
$_POST
[
"txtAddid_project"
].
"' "
;
011.
$strSQL
.=
",'"
.
$_POST
[
"txtAddid_media"
].
"','"
.
$_POST
[
"txtAddstatus"
].
"' "
;
012.
$strSQL
.=
",'$date_today') "
;
013.
$objQuery
= mysql_query(
$strSQL
);
014.
if
(!
$objQuery
)
015.
{
016.
echo
"Error Save ["
.mysql_error().
"]"
;
017.
}
018.
019.
020.
}
021.
022.
023.
if
(
$_POST
[
"hdnCmd"
] ==
"Update"
)
024.
{
025.
$strSQL
=
"UPDATE data_advertising SET "
;
026.
$strSQL
.=
"id = '"
.
$_POST
[
"id"
].
"' "
;
027.
$strSQL
.=
",id_adv = '"
.
$_POST
[
"txtEditid_adv"
].
"' "
;
028.
$strSQL
.=
",name_adv = '"
.
$_POST
[
"txtEditname_adv"
].
"' "
;
029.
$strSQL
.=
",id_project = '"
.
$_POST
[
"txtEditid_project"
].
"' "
;
030.
$strSQL
.=
",id_media = '"
.
$_POST
[
"txtEditid_media"
].
"' "
;
031.
$strSQL
.=
",status = '"
.
$_POST
[
"txtEditstatus"
].
"' "
;
032.
$strSQL
.=
",date_today = '$date_today' "
;
033.
$strSQL
.=
"WHERE id = '"
.
$_POST
[
"id"
].
"' "
;
034.
$objQuery
= mysql_query(
$strSQL
);
035.
if
(!
$objQuery
)
036.
{
037.
echo
"Error Update ["
.mysql_error().
"]"
;
038.
}
039.
040.
041.
}
042.
043.
044.
if
(
$_GET
[
"Action"
] ==
"Del"
)
045.
{
046.
$strSQL
=
"DELETE FROM data_advertising "
;
047.
$strSQL
.=
"WHERE id = '"
.
$_GET
[
"id"
].
"' "
;
048.
$objQuery
= mysql_query(
$strSQL
);
049.
if
(!
$objQuery
)
050.
{
051.
echo
"Error Delete ["
.mysql_error().
"]"
;
052.
}
053.
054.
055.
}
056.
$id_project
=
$_POST
[
'id_project'
];
057.
echo
"$id_project"
;
058.
$strSQL
=
"SELECT * FROM data_advertising WHERE id_project = $id_project "
;
059.
$objQuery
= mysql_query(
$strSQL
)
or
die
(
"Error Query ["
.
$strSQL
.
"]"
);
060.
061.
?>
062.
063.
064.
<div
class
=
"col-md-10"
> <h3>Walk in / Call จากสื่อ โครงการ </h3>
065.
<form name=
"frmMain"
method=
"post"
action=
"<?php echo $_SERVER["
PHP_SELF
"];?>?id_project=<?php echo $_GET["
id_project
"];?>"
>
066.
<input type=
"hidden"
name=
"hdnCmd"
value=
""
>
067.
<input type=
"hidden"
name=
"id"
value=
""
>
068.
<table
class
=
"table"
>
069.
<tr>
070.
<td> <div align=
"center"
>id </div></td>
071.
<td> <div align=
"center"
>รหัสสื่อโฆษณา </div></td>
072.
<td> <div align=
"center"
>ชื่อสื่อโฆษณา </div></td>
073.
<td> <div align=
"center"
>โครงการ</div></td>
074.
<td> <div align=
"center"
>ประเภทสื่อ</div></td>
075.
<td> <div align=
"center"
>สถานะ</div></td>
076.
<td> <div align=
"center"
>เวลา </div></td>
077.
<td> <div align=
"center"
>Edit </div></td>
078.
<td> <div align=
"center"
>
Delete
</div></td>
079.
</tr>
080.
<?php
081.
$i
=1;
082.
while
(
$objResult
= mysql_fetch_array(
$objQuery
))
083.
{
084.
?>
085.
086.
<?php
087.
if
(
$objResult
[
"id"
] ==
$_GET
[
"id"
]
and
$objResult
[
"id_project"
] ==
$_GET
[
"id_project"
]
and
$_GET
[
"Action"
] ==
"Edit"
)
088.
{
089.
?>
090.
<tr>
091.
<td><div align=
"center"
><?=
$i
++;?></div></td>
092.
<td><div align=
"center"
>
093.
<input type=
"text"
name=
"txtEditid_adv"
size=
"5"
value=
"<?php echo $objResult["
id_adv
"];?>"
>
094.
<input type=
"hidden"
name=
"hdnEditid"
size=
"5"
value=
"<?php echo $objResult["
id
"];?>"
>
095.
</div></td>
096.
<td><input type=
"text"
name=
"txtEditname_adv"
size=
"20"
value=
"<?php echo $objResult["
name_adv
"];?>"
></td>
097.
<td><input type=
"text"
name=
"txtEditid_project"
size=
"20"
value=
"<?php echo $objResult["
id_project
"];?>"
></td>
098.
<td><div align=
"center"
><input type=
"text"
name=
"txtEditid_media"
size=
"2"
value=
"<?php echo $objResult["
id_media
"];?>"
></div></td>
099.
<td align=
"right"
><input type=
"text"
name=
"txtEditstatus"
size=
"5"
value=
"<?php echo $objResult["
status
"];?>"
></td>
100.
<td align=
"right"
></td>
101.
<td colspan=
"2"
align=
"right"
><div align=
"center"
>
102.
<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"
>
103.
104.
<input name=
"btnAdd"
type=
"button"
id=
"btnCancel"
value=
"Cancel"
OnClick=
"window.location='<?php echo $_SERVER["
PHP_SELF
"];?>';"
class
=
"btn btn-danger"
>
105.
</div></td>
106.
</tr>
107.
<?php
108.
}
109.
else
110.
{
111.
?>
112.
<tr>
113.
<td><div align=
"center"
><?=
$i
++;?></div></td>
114.
<td><div align=
"center"
><?php
echo
$objResult
[
"id_adv"
];?></div></td>
115.
<td><?php
echo
$objResult
[
"name_adv"
];?></td>
116.
<td><?php
echo
$objResult
[
"id_project"
];?></td>
117.
<td><div align=
"center"
><?php
echo
$objResult
[
"id_media"
];?></div></td>
118.
<td align=
"right"
><?php
echo
$objResult
[
"status"
];?></td>
119.
<td align=
"right"
><?php
echo
$objResult
[
"date_today"
];?></td>
120.
<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>
121.
<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>
122.
</tr>
123.
<?php
124.
}
125.
?>
126.
<?php
127.
}
128.
?>
129.
<tr>
130.
<td align=
"right"
></td>
131.
<td><div align=
"center"
><input type=
"text"
name=
"txtAddid_adv"
size=
"5"
></div></td>
132.
<td><input type=
"text"
name=
"txtAddname_adv"
size=
"20"
></td>
133.
<td><input type=
"text"
name=
"txtAddid_project"
size=
"20"
></td>
134.
<td><div align=
"center"
><input type=
"text"
name=
"txtAddid_media"
size=
"2"
></div></td>
135.
<td align=
"right"
><input type=
"text"
name=
"txtAddstatus"
size=
"5"
></td>
136.
<td align=
"right"
></td>
137.
<td colspan=
"2"
align=
"right"
><div align=
"center"
>
138.
<input name=
"btnAdd"
type=
"button"
id=
"btnAdd"
value=
"Add"
OnClick=
"frmMain.hdnCmd.value='Add';frmMain.submit();"
class
=
"btn btn-default"
>
139.
</div></td>
140.
</tr>
141.
</table>
142.
</form>