設為首頁收藏本站
切換到寬版

 找回密碼
 註冊
NetYea 響應式網頁
RWD 新竹網頁設計		 MyPresent.net
聯盟行銷賺分紅 		綠能購物網 手工藝品、客製化商品 管乾淨 專業 清洗水管
搜索
TShopping»討論區 › 軟體設計開發 › 網頁設計 › PHP › javascript php mysql輪播式廣告怎麼傳id值阿
返回列表 發新帖
查看: 3749|回復: 0

[問題] javascript php mysql輪播式廣告怎麼傳id值阿

[複製鏈接]
woff
發表於 2010-6-12 22:43:25 | 顯示全部樓層 |閱讀模式
 
Push to Facebook
大大您好，小弟有各移惑
小弟寫了各輪播式廣告
功能都正常，但是小弟想點擊廣告時，會傳會該廣告id給javascript再傳給PHP寫入MYSQL
小弟目前，已經可以傳id了，但是永遠都是抓最後一個id值，請懂的大大指導一下，我把程式貼下面

  1. <body onLoad="load()">
  2. </body>
  3.   <div align="center">{literal}<script type="text/javascript" src="adv.php"></script>{/literal}</div>
複製代碼


adv.php


  2. <?php
  3. include "global.php";
  4. echo 'document.write(\'<link rel="stylesheet" href="adv.css" type="text/css" />\');';
  5. echo 'var xmlHttp;';
  6. echo 'var xmlHttp2;';
  7. echo 'var xmlHttp3;';
  8. echo 'var imgWidth=700;';
  9. echo 'var imgHeight=200;';
  10. echo 'var _timeOut_=5000;';
  11. echo 'var timeOut=_timeOut_;';
  12. echo 'var timeOut2=_timeOut_/2;';
  13. echo 'var adNum=0; var target="_blank"; var button_Texton=\'#000000\'; var button_Textoff=\'#ffffff\';';
  14. echo 'var buttonLineOn="#99CC33"; var buttonLineOff="#333333";';
  15. echo 'var imgId=new Array();';
  16. echo 'var imgUrl=new Array();';
  17. echo 'var imgText=new Array();';
  18. echo 'var imgLink=new Array();';
  19. echo 'var imgTitle=new Array();';
  20. echo 'var imgAlt=new Array();';
  21. echo 'var ver=2; var firstTime=true;';
  22. echo 'document.write(\'<div id="ad_pic" class="block02">\');';
  23. echo 'document.write(\'<div id="f_div">\');';
  24. echo 'document.write(\'<div id="f_imgDiv">\');';

  26. $sql = @mysql_query("SELECT * FROM net_headeradv ORDER BY num LIMIT 8");
  27. $nowtime = mktime();
  28. while ($row = mysql_fetch_array($sql)) {
  29. $id = $row['id'];
  30. $num = $row['num'];
  31. $img = $row['img'];
  32. $url = $row['url'];
  33. $title = $row['title'];
  34. $starttime = $row['starttime'];
  35. $endtime = $row['endtime'];

  37. if ($nowtime >= $starttime && $endtime >= $nowtime) {
  38. echo 'imgId['.$num.'] = \''.$id.'\';';
  39. echo 'imgUrl['.$num.'] = \''.$img.'\';';   
  40. echo 'imgText['.$num.'] = \''.$num.'\';';
  41. echo 'imgLink['.$num.'] = \''.$url.'\';';
  42. echo 'imgTitle['.$num.'] = \''.$title.'\';';
  43. }
  44. }
  45. echo 'function b_change(n){';
  46. echo 'adNum=n; window.clearInterval(theTimer);  adNum=adNum-1; change();';
  47. echo '}';

  49. //計算載入幾張圖
  50. echo 'var count=0;';
  51. echo 'for (var i=0;i<imgUrl.length;i++) {';
  52. echo 'if( (imgUrl[i]!="") && (imgText[i]!="")&& (imgLink[i]!="")) {';
  53.   echo 'count++;';
  54. echo '} else {';
  55.   echo 'break;';
  56. echo '}';
  57. echo '}';
  58. //gcsse
  59. echo 'var each_width=Math.ceil((imgWidth-(count-1))/count);';
  60. echo 'var last_width=imgWidth-each_width*(count-1)-(count)+1;';

  62. echo 'function change(){';
  63. echo 'if(adNum<(imgUrl.length-1))adNum++;';
  64. echo 'else adNum=1;';
  65. echo 'theTimer=setTimeout("change()", timeOut);';
  66. echo 'document.getElementById("f_img").Id=imgId[adNum];';
  67. echo 'document.getElementById("f_img").src=imgUrl[adNum];';
  68. echo 'document.getElementById("f_img").title=imgTitle[adNum];';
  69. //var f_img=document.getElementById("f_img");
  70. //f_img.src=imgUrl[adNum];
  71. echo 'document.getElementById("f_imgLink").href=imgLink[adNum];';
  72. echo 'for (var i=1;i< count;i++){';
  73.    echo 'if (i !=adNum){';
  74.    echo 'document.getElementById(\'b\'+i).className="button";';
  75.   echo '}';
  76.   echo 'document.getElementById(\'b\'+adNum).className="on"; }';
  77. echo '}';
  78. echo 'document.write(\'<a id="f_imgLink" href="../\'+imgLink[adNum]+\'" target=_blank><img id="f_img" src="" width=\'+imgWidth+\' height=\'+imgHeight+\' border="0" title="" onClick="add()";></a>\');';
  79. echo 'document.write(\'</div>\');';
  80. echo 'document.write(\'<div id="f_infoDiv">\');';
  81. echo 'document.write(\'<div id="f_buttonDiv">\');';
  82. echo 'for (var i=count-1;i>=1;i--){';
  83. echo 'document.write(\'<div id="div_bg\'+i+\'" class="bg"><a id="b\'+i+\'" href="javascript:b_change(\'+i+\')" class="button">\'+imgText[i]+\'</a></div>\');';
  84. echo '}';
  85. echo 'document.write(\'</div>\');';
  86. echo 'document.write(\'</div>\');';
  87. echo 'document.write(\'</div>\');';
  88. echo 'document.write(\'</div>\'); change();';
  89. echo 'function getHttpRequestObject(handler){';
  90. echo 'var httpRequest=null;';
  91. echo 'if(window.XMLHttpRequest){';
  92.   echo 'httpRequest=new XMLHttpRequest();';
  93. echo '}else if(window.ActiveXObject){';
  94.   echo 'var msxmls=["Microsoft.XMLHttp","MSXML2.XMLHttp.4.0","MSXML2.XMLHttp.3.0","MSXML2.XMLHttp"];';
  95.   echo 'for(var i=0;i<msxmls.length;i++){';
  96.    echo 'try{';
  97.     echo 'httpRequest=new ActiveXObject(msxmls[i]);';
  98.     echo 'break;';
  99.    echo '}catch (e){';
  100.     echo 'return null;';
  101.    echo '}';
  102.   echo '}';
  103. echo '}';
  104. echo 'httpRequest.onreadystatechange=handler;';
  105. echo 'return httpRequest;';
  106. echo '}';
  107. echo 'function makeRequest(httpRequest,url){';
  108. echo 'httpRequest.open("GET",url,true);';
  109. echo 'httpRequest.send(null);';
  110. echo '}';
  111. echo 'function loaddata(){';
  112. echo 'if(xmlHttp.readyState==4){';
  113.   echo 'var xmlResult=xmlHttp.responseXML;';
  114.   echo 'var node=xmlResult.documentElement;';
  115.   echo 'if(node.getElementsByTagName("item")[0].firstChild.data!=0){';
  116.    echo 'document.getElementById("f_img").innerHTML="hit按鍵總共被按"+node.getElementsByTagName("item")[0].firstChild.data+"次!";';
  117.   echo '}';
  118. echo '}';
  119. echo '}';
  120. echo 'function loaddata2(){';
  121. echo 'if(xmlHttp2.readyState==4){';
  122.   echo 'var xmlResult2=xmlHttp2.responseXML;';
  123.   echo 'var node2=xmlResult2.documentElement;';
  124.   echo 'if(node2.getElementsByTagName("item")[0].firstChild.data!=0){';
  125.    echo 'document.getElementById("f_img").innerHTML="hit按鍵總共被按"+node2.getElementsByTagName("item")[0].firstChild.data+"次!";';
  126.   echo '}';
  127. echo '}';
  128. echo '}';
  129. echo 'function loaddata3(){';
  130. echo 'if(xmlHttp3.readyState==4){';
  131.   echo 'document.getElementById("f_img").innerHTML=\'\';';
  132. echo '}';
  133. echo '}';
  134. echo 'function load(){';
  135. echo 'xmlHttp=getHttpRequestObject(loaddata);';
  136. echo 'if(xmlHttp!=null){';
  137.   echo 'var url="advhit.php";';
  138.   echo 'makeRequest(xmlHttp,url);';
  139. echo '}else{';
  140.   echo 'alert("瀏覽程式不支援XMLHttpRequest物件!");';
  141. echo '}';
  142. echo '}';
  143. echo 'function add(){';
  144. echo 'xmlHttp2=getHttpRequestObject(loaddata2);';
  145. echo 'if(xmlHttp2!=null){';
  146.   echo 'var url="advhit.php?i=1&id='.$id.'";';
  147.   echo 'var rand=parseInt(Math.random()*999999999);';
  148.   echo 'url=url+"&rand="+rand;';
  149.   echo 'makeRequest(xmlHttp2,url);';
  150. echo '}else{';
  151.   echo 'alert("瀏覽程式不支援XMLHttpRequest物件!");';
  152. echo '}';
  153. echo '}';
  154. ?>
複製代碼


adv.css

  1. #f_div{width:700px; height:200px; margin:0 auto; overflow:hidden;
  2. }
  3. #f_imgDiv{width:700px; height:200px; overflow:hidden;}
  4. #f_img{filter:progid:DXImageTransform.Microsoft.Fade(Overlap=1.00); border:0;}
  5. #f_infoDiv{width:700px;top:-16px;position:relative;background:#333;filter:Alpha(Opacity=70);-moz-opacity: 0.7; opacity: 0.7;}
  6. #f_buttonDiv{width:700px; margin-right:1px; height:18px; overflow:hidden; text-align:left;color:#fff;}
  7. #f_buttonDiv div,#f_buttonDiv .bg{
  8. width:20px;height:18px; background:#333; float:right;
  9. display:table-cell;
  10. vertical-align:middle;
  11. }
  12. /*#f_buttonDiv .bg{width:94px;height:18px; background:#333; float:right; }*/
  13. #f_buttonDiv a{
  14. width:20px;height:18px !important;
  15. float:right;
  16. padding-top:5px;
  17. color:#fff;
  18. /*font-family:Arial, Helvetica, sans-serif;*/
  19. font-family:serif;
  20. font-size:12px;
  21. text-align:center;
  22. /*display:block;*/
  23. overflow:hidden;
  24. text-decoration:none;
  25. /*position:absolute;*/
  26. position:relative;
  27. top:-2px;
  28. }
  29. *+html>body #f_buttonDiv a{top:-1px;}/*ie7*/
  30. #f_buttonDiv div > a{top:-5px;}
  31. #f_buttonDiv a:link,#f_buttonDiv a:visited,#f_buttonDiv a:active{color:#fff;}
  32. #f_buttonDiv a:hover{color:#aaa;}
  33. #f_buttonDiv a.on:link,#f_buttonDiv a.on:visited,#f_buttonDiv a.on:active,#f_buttonDiv a.on:hover{background:#99CC33;color:#000;}
  34. #f_buttonDiv a.on:hover{background:#99CC33;}
複製代碼
 
回復

使用道具 舉報

返回列表 發新帖
高級模式
B Color Image Link Quote Code Smilies
您需要登錄後才可以回帖 登錄 | 註冊

本版積分規則

Archiver|手機版|小黑屋|TShopping

GMT+8, 2025-11-4 14:25 , Processed in 0.020673 second(s), 17 queries .

Powered by Discuz! X3.5

© 2001-2025 Discuz! Team.

快速回復 返回頂部 返回列表