iframe com ajax ...

jow · Novembro 21, 2008

Galera vou postar um frame aki com ajax, testado e 100% funcionando, com mysql ....

config/conexao.asp

<%
dim cnn
sub abre_conectar
set cnn=server.CreateObject("adodb.connection")
'Abrimos uma conexão com o banco de dados - [IMPORTANTE] altere os dados abaixo com as informações de sua base de dados
cnn.Open("DRIVER={MySQL ODBC 3.51 Driver};SERVER=Seu enreço de servidor;PORT=3306;DATABASE=sSua base de dados;USER=Seuusuario;PASSWORD=Suasenha;OPTION=3;") 
end sub
sub fecha_conectar
     cnn.close
     Set cnn = nothing
end sub 
%>

default.asp

<% Response.addHeader "pragma", "no-cache"
Response.CacheControl = "Private"
Response.Expires = 0 %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Ajax Rotating Includes Script</title>
<script type="text/javascript">

/***********************************************
* Dynamic Ajax Content- © Dynamic Drive DHTML code library (www.dynamicdrive.com)
* This notice MUST stay intact for legal use
* Visit Dynamic Drive at http://www.dynamicdrive.com/ for full source code
***********************************************/

var loadedobjects=""
var rootdomain="http://"+window.location.hostname

function ajaxpage(url, containerid){
var page_request = false
if (window.XMLHttpRequest) // if Mozilla, Safari etc
page_request = new XMLHttpRequest()
else if (window.ActiveXObject){ // if IE
try {
page_request = new ActiveXObject("Msxml2.XMLHTTP")
} 
catch (e){
try{
page_request = new ActiveXObject("Microsoft.XMLHTTP")
}
catch (e){}
}
}
else
return false
page_request.onreadystatechange=function(){
loadpage(page_request, containerid)
}
page_request.open('GET', url, true)
page_request.send(null)
}

function loadpage(page_request, containerid){
if (page_request.readyState == 4 && (page_request.status==200 || window.location.href.indexOf("http")==-1))
document.getElementById(containerid).innerHTML=page_request.responseText
}

function loadobjs(){
if (!document.getElementById)
return
for (i=0; i<arguments.length; i++){
var file=arguments[i]
var fileref=""
if (loadedobjects.indexOf(file)==-1){ //Check to see if this object has not already been added to page before proceeding
if (file.indexOf(".js")!=-1){ //If object is a js file
fileref=document.createElement('script')
fileref.setAttribute("type","text/javascript");
fileref.setAttribute("src", file);
}
else if (file.indexOf(".css")!=-1){ //If object is a css file
fileref=document.createElement("link")
fileref.setAttribute("rel", "stylesheet");
fileref.setAttribute("type", "text/css");
fileref.setAttribute("href", file);
}
}
if (fileref!=""){
document.getElementsByTagName("head").item(0).appendChild(fileref)
loadedobjects+=file+" " //Remember this object as being already added to page
}
}
}

</script>

<style type="text/css">
#leftcolumn{
float:left;
width:150px;
height: 400px;
border: 3px solid black;
padding: 5px;
padding-left: 8px;

}

#leftcolumn a{
padding: 3px 1px;
display: block;
width: 100%;
text-decoration: none;
font-weight: bold;
border-bottom: 1px solid gray;
}

#leftcolumn a:hover{
background-color: #FFFF80;
}

#rightcolumn{
float:left;
width:550px;
min-height: 400px;
border: 3px solid black;
margin-left: 10px;
padding: 5px;
padding-bottom: 8px;
}

* html #rightcolumn{ /*IE only style*/
height: 400px;
}
</style>
</head>

<body>
<!--#include file="config/conexao.asp"-->
<%
call abre_conectar
sql = "SELECT * FROM categorias "
set rs = cnn.execute(sql) %>

<div id="leftcolumn">
<% while not rs.eof%>
<a href="java script:ajaxpage('pagina.asp?acao=<%=rs("id")%>', 'rightcolumn');"><%=rs("classificacao")%></a>
 <%rs.movenext
    wend%></div>
<div id="rightcolumn"><h3>I Frame com Ajax Jow Xavier</h3></div>
<div style="clear: left; margin-bottom: 1em"></div>
<%
call fecha_conectar
set tab = nothing
%>
</body>
</html>

pagina.asp

<% Response.addHeader "pragma", "no-cache"
Response.CacheControl = "Private"
Response.Expires = 0 %>
<!--#include file="config/conexao.asp"-->
<%

vacao = request.QueryString("acao")

call abre_conectar
sql = "SELECT * FROM produtos WHERE id_categoria =  '"&vacao&"' "
set rs = cnn.execute(sql)

%>

<img src="../novo/lojista/admin/<%=rs("foto")%>">

Link para visualizar on line ::: http://www.visaopedestais.com.br/nova%20pasta

abraçosssss e espero q gostem ....

Entrar

iframe com ajax ...

Pergunta

jow

Link para o comentário

Compartilhar em outros sites

0 respostass a esta questão

Posts Recomendados

Participe da discussão

Estatísticas dos Fóruns

Navegação

Atividades