php+javascript幻灯片生成代码
<?php $bbsconn=mysql_connect("localhost","root",""); mysql_select_db("lsmsql",$bbsconn); $kind="幻灯片"; $sql="select * from sa_article where kind='$kind' order by articleid desc limit 0,6"; $result=mysql_query($sql); $pics=$links=$texts=""; while ($rows=mysql_fetch_array($result)){ $pics.="/attached/".$rows['source']."|"; $links.="show.php?id=".$rows['articleid']."|"; $texts.=$rows['title']."|"; } $pics=substr($pics,0,-1); $links=substr($links,0,-1); $texts=substr($texts,0,-1);
<!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"><head><meta http-equiv="content-type" content="text/html; charset=gb2312" /><title>幻灯片</title></head><body><table width="300" border="1"> <tr> <td><script type=text/javascript><!-- var focus_width=300; var focus_height=200; var text_height=20; var swf_height = focus_height+text_height var pics="<?=$pics" var links="<?=$links" var texts="<?=$texts" document.write('<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="'+ focus_width +'" height="'+ swf_height +'">'); document.write('<param name="allowscriptaccess" value="samedomain"><param name="movie" value="playswf.swf"><param name=wmode value=transparent><param name="quality" value="high">'); document.write('<param name="menu" value="false"><param name=wmode value="opaque">'); document.write('<param name="flashvars" value="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'">'); document.write('<embed src="playswf.swf" wmode="opaque" flashvars="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'" menu="false" bgcolor="#dadada" quality="high" width="'+ focus_width +'" height="'+ swf_height +'" allowscriptaccess="samedomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />'); document.write('</object>'); //--> </script> </td> </tr></table></body></html>
教程地址:http://www.phprm.com/code/33627.html
欢迎转载!但请带上文章地址^^