Posts Tagged ‘height’

用PHP生成MYSQL数据字典

Posted in 默认分类 on 二月 12th, 2011 by admin – Be the first to comment

写文档什么是最麻烦的事情. 能交给程序做就让程序做吧. 于是有了这个生成程序

PHP代码

/*
Name: 生成mysql数据字典
URI: http://www.simcn.com/dict-tools
Version: 1.0
Author: Mark.Chen
Author URI: http://www.simcn.com
*/

//Set Server
$dbserver="localhost";
$dbusername="root";
$dbpassword="max197997";

//接收get参数
if($_GET['db']==''){
    $database = 'oms';
}else{
    $database = $_GET['db'];
}

$mysql_conn=@mysql_connect("$dbserver","$dbusername","$dbpassword") or die("Mysql connect is error.");

mysql_select_db($database,$mysql_conn);
$result = mysql_list_tables($database,$mysql_conn);
mysql_query('SET NAMES utf8',$mysql_conn);
while ($tableList = mysql_fetch_array($result)){
    $table = $tableList[0];
    $field_result= mysql_query("SELECT * FROM
                               INFORMATION_SCHEMA.COLUMNS
                               WHERE
                               table_name = '$table' AND table_schema = '$database'",$mysql_conn
                                );

    echo '
'.chr(13);
    echo '


'.chr(13);
    echo '


'.chr(13);
    while ($f = mysql_fetch_array($field_result)){
        echo '
'.chr(13);
        echo '


'.chr(13);
        echo '


'.chr(13);
        echo '


'.chr(13);
        echo '


'.chr(13);
        echo '


'.chr(13);
        echo '

'.chr(13);
    }
    echo '
'.$table.'

字段名
数据类型
默认值
字符编码
备注

'.$f['COLUMN_NAME'].''.$f['COLUMN_TYPE'].''.$f['COLUMN_DEFAULT'].''.$f['COLLATION_NAME'].''.$f['COLUMN_COMMENT'].'


';

}
mysql_close($mysql_conn);

html风格页面

用于解决iframe自适应高度

Posted in 默认分类 on 六月 18th, 2009 by admin – Be the first to comment 
function reinitIframe(){
	var iframe = document.getElementById("frame_content");
	try{
		var bHeight = iframe.contentWindow.document.body.scrollHeight;
		var dHeight = iframe.contentWindow.document.documentElement.scrollHeight;
		var height = Math.max(bHeight, dHeight);
		iframe.height =  height;
	}catch (ex){}
}
window.setInterval("reinitIframe()", 1000);

在新浪站上看到的不错，收藏下.

目前我们自己常用的

调用页面.

被调用页面

        window.onload = function(){
                var height = Math.max(document.body.scrollHeight, document.documentElement.scrollHeight);
                parent.call_frame(height)
            }