MyDesign | Kod Arşivi - Anasayfaya Dön   No banner in farm
Anasayfa Araştır Forum Gelişmiş Arama Siteniz İçin En Hit İçerikler RSS İçerik Ekle Scriptler Destekleyenler Kadromuz Reklam İletişim Giriş Sayfası Yap  Sık Kullanılanlara Ekle
Bu Kategorinin En Yeni Kodları:


Bu Kategorinin En Çok Görüntülenen Kodları:






Arama:
Gelişmiş Arama


No banner in farm



En Çok Görüntülenen Kodlar:


Üye Girişi:
 Üye Ol



Anasayfa > SQL > Kodlar

Tablolar içerisinde veri aramak

Veritabanında bulunan tablolarda veri aramak.

Kategori : SQL
Gönderen : SiNLeSs
Telif :
Tarih : 14 Nisan 2009
Örnek Dosya : Bulunmamakta
Okunma Sayısı : 8983
Puan
: 5,5 / 10 (2 Oy)
Puan Verin :
Google Bookmarks  del.icio.us  Digg  Yahoo! MyWeb  Windows Live  Furl
 
 
<P><CODE>//&nbsp;------------------------------------------------------------------- <BR>//&nbsp;Advanced&nbsp;RSS&nbsp;Ticker&nbsp;(Ajax&nbsp;invocation)&nbsp;core&nbsp;file <BR>//&nbsp;Author:&nbsp;Dynamic&nbsp;Drive&nbsp;(http://www.dynamicdrive.com) <BR>//&nbsp;------------------------------------------------------------------- <BR><BR>//Relative&nbsp;URL&nbsp;syntax: <BR>var&nbsp;lastrssbridgeurl="lastrss/bridge.php" <BR><BR>//Absolute&nbsp;URL&nbsp;syntax.&nbsp;Uncomment&nbsp;below&nbsp;line&nbsp;if&nbsp;you&nbsp;wish&nbsp;to&nbsp;use&nbsp;an&nbsp;absolute&nbsp;reference: <BR>//var&nbsp;lastrssbridgeurl="http://"+window.location.hostname+"/lastrss/bridge.php" <BR><BR>////////////No&nbsp;need&nbsp;to&nbsp;edit&nbsp;beyond&nbsp;here////////////// <BR><BR>function&nbsp;createAjaxObj(){ <BR>var&nbsp;httprequest=false <BR>if&nbsp;(window.XMLHttpRequest){&nbsp;//&nbsp;if&nbsp;Mozilla,&nbsp;Safari&nbsp;etc <BR>httprequest=new&nbsp;XMLHttpRequest() <BR>if&nbsp;(httprequest.overrideMimeType) <BR>httprequest.overrideMimeType('text/xml') <BR>} <BR>else&nbsp;if&nbsp;(window.ActiveXObject){&nbsp;//&nbsp;if&nbsp;IE <BR>try&nbsp;{ <BR>httprequest=new&nbsp;ActiveXObject("Msxml2.XMLHTTP"); <BR>}&nbsp; <BR>catch&nbsp;(e){ <BR>try{ <BR>httprequest=new&nbsp;ActiveXObject("Microsoft.XMLHTTP"); <BR>} <BR>catch&nbsp;(e){} <BR>} <BR>} <BR>return&nbsp;httprequest <BR>} <BR><BR>//&nbsp;------------------------------------------------------------------- <BR>//&nbsp;Main&nbsp;RSS&nbsp;Ticker&nbsp;Object&nbsp;function <BR>//&nbsp;rssticker_ajax(RSS_id,&nbsp;cachetime,&nbsp;divId,&nbsp;divClass,&nbsp;delay,&nbsp;optionallogicswitch) <BR>//&nbsp;------------------------------------------------------------------- <BR><BR>function&nbsp;rssticker_ajax(RSS_id,&nbsp;cachetime,&nbsp;divId,&nbsp;divClass,&nbsp;delay,&nbsp;logicswitch){ <BR>this.RSS_id=RSS_id&nbsp;//Array&nbsp;key&nbsp;indicating&nbsp;which&nbsp;RSS&nbsp;feed&nbsp;to&nbsp;display <BR>this.cachetime=cachetime&nbsp;//Time&nbsp;to&nbsp;cache&nbsp;feed,&nbsp;in&nbsp;minutes.&nbsp;0=no&nbsp;cache. <BR>this.tickerid=divId&nbsp;//ID&nbsp;of&nbsp;ticker&nbsp;div&nbsp;to&nbsp;display&nbsp;information <BR>this.delay=delay&nbsp;//Delay&nbsp;between&nbsp;msg&nbsp;change,&nbsp;in&nbsp;miliseconds. <BR>this.logicswitch=(typeof&nbsp;logicswitch!="undefined")?&nbsp;logicswitch&nbsp;:&nbsp;"" <BR>this.mouseoverBol=0&nbsp;//Boolean&nbsp;to&nbsp;indicate&nbsp;whether&nbsp;mouse&nbsp;is&nbsp;currently&nbsp;over&nbsp;ticker&nbsp;(and&nbsp;pause&nbsp;it&nbsp;if&nbsp;it&nbsp;is) <BR>this.pointer=0 <BR>this.opacitysetting=0.2&nbsp;//Opacity&nbsp;value&nbsp;when&nbsp;reset.&nbsp;Internal&nbsp;use. <BR>this.title=[],&nbsp;this.link=[],&nbsp;this.description=[],&nbsp;this.pubdate=[]&nbsp;//Arrays&nbsp;to&nbsp;hold&nbsp;each&nbsp;component&nbsp;of&nbsp;an&nbsp;RSS&nbsp;item <BR>this.ajaxobj=createAjaxObj() <BR>document.write('&lt;div&nbsp;id="'+divId+'"&nbsp;class="'+divClass+'"&nbsp;&gt;Veri&nbsp;Yükleniyor...&lt;/div&gt;') <BR>if&nbsp;(window.getComputedStyle)&nbsp;//detect&nbsp;if&nbsp;moz-opacity&nbsp;is&nbsp;defined&nbsp;in&nbsp;external&nbsp;CSS&nbsp;for&nbsp;specified&nbsp;class <BR>this.mozopacityisdefined=(window.getComputedStyle(document.getElementById(this.tickerid),&nbsp;"").getPropertyValue("-moz-opacity")==1)?&nbsp;0&nbsp;:&nbsp;1 <BR>this.getAjaxcontent() <BR>} <BR><BR>//&nbsp;------------------------------------------------------------------- <BR>//&nbsp;getAjaxcontent()-&nbsp;Makes&nbsp;asynchronous&nbsp;GET&nbsp;request&nbsp;to&nbsp;"bridge.php"&nbsp;with&nbsp;the&nbsp;supplied&nbsp;parameters <BR>//&nbsp;------------------------------------------------------------------- <BR><BR>rssticker_ajax.prototype.getAjaxcontent=function(){ <BR>if&nbsp;(this.ajaxobj){ <BR>var&nbsp;instanceOfTicker=this <BR>var&nbsp;parameters="id="+encodeURIComponent(this.RSS_id)+"&amp;cachetime="+this.cachetime+"&amp;bustcache="+new&nbsp;Date().getTime() <BR>this.ajaxobj.onreadystatechange=function(){instanceOfTicker.initialize()} <BR>this.ajaxobj.open('GET',&nbsp;lastrssbridgeurl+"?"+parameters,&nbsp;true) <BR>this.ajaxobj.send(null) <BR>} <BR>} <BR><BR>//&nbsp;------------------------------------------------------------------- <BR>//&nbsp;initialize()-&nbsp;Initialize&nbsp;ticker&nbsp;method. <BR>//&nbsp;-Gets&nbsp;contents&nbsp;of&nbsp;RSS&nbsp;content&nbsp;and&nbsp;parse&nbsp;it&nbsp;using&nbsp;JavaScript&nbsp;DOM&nbsp;methods&nbsp; <BR>//&nbsp;------------------------------------------------------------------- <BR><BR>rssticker_ajax.prototype.initialize=function(){&nbsp; <BR>if&nbsp;(this.ajaxobj.readyState&nbsp;==&nbsp;4){&nbsp;//if&nbsp;request&nbsp;of&nbsp;file&nbsp;completed <BR>if&nbsp;(this.ajaxobj.status==200){&nbsp;//if&nbsp;request&nbsp;was&nbsp;successful <BR>var&nbsp;xmldata=this.ajaxobj.responseXML <BR>if(xmldata.getElementsByTagName("item").length==0){&nbsp;//if&nbsp;no&nbsp;&lt;item&gt;&nbsp;elements&nbsp;found&nbsp;in&nbsp;returned&nbsp;content <BR>document.getElementById(this.tickerid).innerHTML="&lt;b&gt;Error&lt;/b&gt;&nbsp;fetching&nbsp;remote&nbsp;RSS&nbsp;feed!&lt;br&nbsp;/&gt;"+this.ajaxobj.responseText <BR>return <BR>} <BR>var&nbsp;instanceOfTicker=this <BR>this.feeditems=xmldata.getElementsByTagName("item") <BR>//Cycle&nbsp;through&nbsp;RSS&nbsp;XML&nbsp;object&nbsp;and&nbsp;store&nbsp;each&nbsp;peice&nbsp;of&nbsp;an&nbsp;item&nbsp;inside&nbsp;a&nbsp;corresponding&nbsp;array <BR>for&nbsp;(var&nbsp;i=0;&nbsp;i&lt;this.feeditems.length;&nbsp;i++){ <BR>this.title[i]=this.feeditems[i].getElementsByTagName("title")[0].firstChild.nodeValue <BR>this.link[i]=this.feeditems[i].getElementsByTagName("link")[0].firstChild.nodeValue <BR>this.description[i]=this.feeditems[i].getElementsByTagName("description")[0].firstChild.nodeValue <BR>this.pubdate[i]=this.feeditems[i].getElementsByTagName("pubDate")[0].firstChild.nodeValue <BR>} <BR>document.getElementById(this.tickerid).onmouseover=function(){instanceOfTicker.mouseoverBol=1} <BR>document.getElementById(this.tickerid).onmouseout=function(){instanceOfTicker.mouseoverBol=0} <BR>this.rotatemsg() <BR>} <BR>} <BR>} <BR><BR>//&nbsp;------------------------------------------------------------------- <BR>//&nbsp;rotatemsg()-&nbsp;Rotate&nbsp;through&nbsp;RSS&nbsp;messages&nbsp;and&nbsp;displays&nbsp;them <BR>//&nbsp;------------------------------------------------------------------- <BR><BR>rssticker_ajax.prototype.rotatemsg=function(){ <BR>var&nbsp;instanceOfTicker=this <BR>if&nbsp;(this.mouseoverBol==1)&nbsp;//if&nbsp;mouse&nbsp;is&nbsp;currently&nbsp;over&nbsp;ticker,&nbsp;do&nbsp;nothing&nbsp;(pause&nbsp;it) <BR>setTimeout(function(){instanceOfTicker.rotatemsg()},&nbsp;100) <BR>else{&nbsp;//else,&nbsp;construct&nbsp;item,&nbsp;show&nbsp;and&nbsp;rotate&nbsp;it! <BR>var&nbsp;tickerDiv=document.getElementById(this.tickerid) <BR>var&nbsp;linktitle='&lt;div&nbsp;class="rsstitle"&gt;&lt;a&nbsp;href="'+this.link[this.pointer]+'"&gt;'+this.title[this.pointer]+'&lt;/a&gt;&lt;/div&gt;' <BR>var&nbsp;description='&lt;div&nbsp;class="rssdescription"&gt;'+this.description[this.pointer]+'&lt;/div&gt;' <BR>var&nbsp;feeddate='&lt;div&nbsp;class="rssdate"&gt;'+this.pubdate[this.pointer]+'&lt;/div&gt;' <BR>if&nbsp;(this.logicswitch.indexOf("description")==-1)&nbsp;description="" <BR>if&nbsp;(this.logicswitch.indexOf("date")==-1)&nbsp;feeddate="" <BR>var&nbsp;tickercontent=linktitle+feeddate+description&nbsp;//STRING&nbsp;FOR&nbsp;FEED&nbsp;CONTENTS&nbsp; <BR>this.fadetransition("reset")&nbsp;//FADE&nbsp;EFFECT-&nbsp;RESET&nbsp;OPACITY <BR>tickerDiv.innerHTML=tickercontent <BR>this.fadetimer1=setInterval(function(){instanceOfTicker.fadetransition('up',&nbsp;'fadetimer1')},&nbsp;100)&nbsp;//FADE&nbsp;EFFECT-&nbsp;PLAY&nbsp;IT <BR>this.pointer=(this.pointer&lt;this.feeditems.length-1)?&nbsp;this.pointer+1&nbsp;:&nbsp;0 <BR>setTimeout(function(){instanceOfTicker.rotatemsg()},&nbsp;this.delay)&nbsp;//update&nbsp;container&nbsp;every&nbsp;second <BR>} <BR>} <BR><BR>//&nbsp;------------------------------------------------------------------- <BR>//&nbsp;fadetransition()-&nbsp;cross&nbsp;browser&nbsp;fade&nbsp;method&nbsp;for&nbsp;IE5.5+&nbsp;and&nbsp;Mozilla/Firefox <BR>//&nbsp;------------------------------------------------------------------- <BR><BR>rssticker_ajax.prototype.fadetransition=function(fadetype,&nbsp;timerid){ <BR>var&nbsp;tickerDiv=document.getElementById(this.tickerid) <BR>if&nbsp;(fadetype=="reset") <BR>this.opacitysetting=0.2 <BR>if&nbsp;(tickerDiv.filters&nbsp;&amp;&amp;&nbsp;tickerDiv.filters[0]){ <BR>if&nbsp;(typeof&nbsp;tickerDiv.filters[0].opacity=="number")&nbsp;//IE6+ <BR>tickerDiv.filters[0].opacity=this.opacitysetting*100 <BR>else&nbsp;//IE&nbsp;5.5 <BR>tickerDiv.style.filter="alpha(opacity="+this.opacitysetting*100+")" <BR>} <BR>else&nbsp;if&nbsp;(typeof&nbsp;tickerDiv.style.MozOpacity!="undefined"&nbsp;&amp;&amp;&nbsp;this.mozopacityisdefined){ <BR>tickerDiv.style.MozOpacity=this.opacitysetting <BR>} <BR>if&nbsp;(fadetype=="up") <BR>this.opacitysetting+=0.2 <BR>if&nbsp;(fadetype=="up"&nbsp;&amp;&amp;&nbsp;this.opacitysetting&gt;=1) <BR>clearInterval(this[timerid]) <BR>}&nbsp; <BR>&nbsp;</CODE></P></BLOCKQUOTE>
 
 

Tablolar içerisinde veri aramak için yazılan yorumlar

Serhat  { 08 Kasım 2010 }
Kodlar Cok Kafa Karıştırıyor. :)

Yorum ekleyin

Anasayfa > SQL > Kodlar > Tablolar içerisinde veri aramak
Kategoriler:


Forum:



Bağlantılar:


En Son Yorumlanan İçerikler:


Murat Yavuz | Site Haritası | Gizlilik Bildirimi | 54.197.132.255 | 0,12 Saniye
© Copyright 2004-2017 MyDesign | Kod Arşivi. Tüm Hakları Saklıdır.
MyDesign | Kod Arşivi, en iyi görünüm için, 1024x768 ve üzeri çözünürlük tavsiye eder.