<%if session("username")="" then%> <%end if%> <% if request("action")="del_one" then openconn set rs=server.CreateObject("adodb.recordset") sql="delete from tblpartner Where idpartner='"&replace(Request.QueryString("nid"),"'","''")&"'" Conn.execute (sql) Response.Redirect("?saoviet=31&Quan-ly-quang-cao.html") end if%> <% if request("action")="submit" then names=replace(request("names"),"'","''") pathanh=replace(request("pathanh"),"'","''") URL=replace(request("URL"),"'","''") openconn set rs=server.CreateObject("adodb.recordset") sql="insert into tblpartner(name,logo,url) values(N'"&names&"','"&pathanh&"',N'"&URL&"')" conn.execute(sql) response.Redirect("?saoviet=31&Quan-ly-quang-cao.html") %> <%end if%>
QUẢN LÝ QUẢNG CÁO
Tiêu đề quảng cáo
Ảnh quảng cáo   Tải ảnh..
Liên kết
<% openconn set rs=server.CreateObject("adodb.recordset") rs.open"Select * from tblpartner order by idpartner DESC",conn,3,1 If Request.QueryString("page") = "" Then intCurrentPage = 1 Else intCurrentPage = CInt(Request.QueryString("page")) End If RS.PageSize = 10 If rs.PageCount > 0 then rs.AbsolutePage = intCurrentPage Else intCurrentPage = 0 End If j=1 i=1 do while not rs.eof %> <% if j=RS.PageSize then exit do end if j=j+1 i = i + 1 RS.MoveNext loop %>
 TÊN QUẢNG CÁO  HÌNH ẢNH QUẢN LÝ
<%= rs("Name") %> " border="0" width="100"> ">Sửa thông tin ');" href="#">Xóa thông tin
<% If rs.PageCount > 1 then 'Print Previous Page if required If intCurrentPage <> 1 then Response.Write "Trang trước" Else Response.Write "Trang trước" End If 'Print direct access page numbers. For intCount = 1 to rs.PageCount If intCount = 1 then Response.Write " | " End If If intCount = intCurrentPage then Response.Write ""&intCount & " | " Else Response.Write "" & intCount & " | " End If Next 'Print Next Page if required If intCurrentPage <> rs.PageCount then Response.Write "Trang sau" Else Response.Write "Trang sau" End If End If Response.Write "
Trang " & intCurrentPage & " / " & rs.PageCount %>