这篇文章主要为大家详细介绍了php 查询数据库显示小图,点击小图弹出大图的功能实例,具有一定的参考价值,可以用来参考一下。
php查询数据库显示小图,点击小图弹出大图,感兴趣的小伙伴,下面一起跟随四海网的小编罗X来看看吧。
/**
* 查询数据库显示小图,点击小图弹出大图
*
* @param
* @arrange (512.笔记) www.q1010.com
**/
//Get all the images in the database (use a WHERE clause to limit what it finds)
$sql = mysql_query("SELECT * FROM database_name");
//Start A counter we will start at 1
$i = 1;
//Get all the returned results, save them in an array, and loop throught the array
//to display all the returned results
while($row = mysql_fetch_array($sql)){
//Create a list from the returned image file, and make a $width and $height variable
list($width, $height) = getimagesize("url/to/large/image/".$row['img_file_name']);
//Add 30 to the returned width and height so it will fit in the popup window
//If it still doesn't fit, change the two thirtys to a larger number.
$width += 30;
$height += 30;
//Use javascript to make the popup
//Everytime the script runs through, $i will change so we can have dynamic popup window sizes
echo "
<script type="text/javascript">
function load".$i."(){
var load = window.open('url/to/large/image/".$row['img_file_name']."', ' ', 'scrollbars=no,menubar=no,height=".$height.",width=".$width.",resizable=no,toolbar=no,location=no,status=no');
}
</script>";
//This will display our thumbnail on the screen and make a link to the popup function
//that was just created in the above javascript.
echo'
<p>
<a href="javascript:load'.$i.'()">
<img src="url/to/thumb/image/'.$row['img_file_name'].'" />
</a>
</p>';
//Add one to $i
$i++;
}
/*** 来自四海网(www.q1010.com) ***/
本文来自:http://www.q1010.com/173/313-0.html
注:关于php 查询数据库显示小图,点击小图弹出大图的功能实例的内容就先介绍到这里,更多相关文章的可以留意四海网的其他信息。
关键词:查询数据库
四海网收集整理一些常用的php代码,JS代码,数据库mysql等技术文章。