<%if session("username")="" then%> <%end if%> <% if request("action")="del_one" then openconn set rs=server.CreateObject("adodb.recordset") sql="delete from tblvideo Where idvideo='"&replace(Request.QueryString("nid"),"'","''")&"'" Conn.execute (sql) Response.Redirect("?saoviet=13&Quan-ly-video.html") end if%> <% if request("action")="submit" then tenvideo=replace(request("tenvideo"),"'","''") link=replace(request("link"),"'","''") iddichvu=replace(request("iddichvu"),"'","''") openconn set rs=server.CreateObject("adodb.recordset") sql="insert into tblvideo(tenvideo,link,iddichvu) values(N'"&tenvideo&"','"&link&"','"&iddichvu&"')" conn.execute(sql) response.Redirect("?saoviet=13&Quan-ly-video.html") %> <%end if%>

QUẢN LÝ VIDEO

Thuộc dự án <% i=1 openconn set rs1= server.CreateObject("adodb.recordset") rs1.open "select * from tbldichvu order by thutu ASC", conn,3,1 if not rs1.eof then do while not rs1.eof %> style="background-color:#E3E2DE; color:#000000;"<%else%><%end if%> value='<%=rs1("iddichvu")%>'>  <%=rs1("name")%> <% rs1.movenext i=i+1 loop end if rs1.close %> Tiêu đề Liên kết

<% openconn set rs=server.CreateObject("adodb.recordset") rs.open"Select * from tblvideo order by idvideo 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 %> <% openconn set rs1=server.CreateObject("adodb.recordset") rs1.open"Select * from tbldichvu where iddichvu="&rs("iddichvu")&"",conn,3,1 %> <% rs1.close %> <% if j=RS.PageSize then exit do end if j=j+1 i = i + 1 RS.MoveNext loop %>  TIÊU ĐỀ  TIÊU ĐỀ QUẢN LÝ <%=rs("tenvideo")%> <%=rs1("name")%> "> ');" href="#"> <% 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 %>