ddakker님의 블로그

declare
  Cursor emp_cursor is
   Select seq,subject from board;
begin 
  dbms_output.put_line('seq subject');
  dbms_output.put_line('------ ---- -------');
  for c1 in emp_cursor loop
        
    dbms_output.put_line(to_char(c1.seq) || ' ' || c1.subject);
    insert into insert_test(test)values(c1.subject);
  end loop;
        
end;

index: 





	
cell 1-1
	
cell 1-2


	
cell 2-1
	
cell 2-2


	
cell 3-1
	
cell 3-2

/**
 * 화페단위 등 3자리수마다 콤마찍기
 * @param value		문자열
 * ex) new dak.utils.StringUtil().getMoneyFormatter("123456")
 */
getMoneyFormatter: function(value) {
	value = value.replace(/,/ig, "");
	value = (value=String(value)).match(RegExp("^[0-9]{"+(value.length%3||3)+"}|[0-9]{3}","g"));
	if( value == null || value == "" || value == "null" )
		return "";
	else
		return value;
}

 
var dak = {}; 
dak.utils = {};

dak.utils.CommonUtil = function(){}

dak.utils.CommonUtil.prototype = {
	
	/**
	 * 숫자만 입력 가능하게
	 * new dak.utils.CommonUtil().onlyNumber(event);, onKeyDown 이벤트
	 * @param e	Event
	 * @return
	 */
	onlyNumber: function(e){
		var event = e ? e : event;
		var target = event.target ? event.target : event.srcElement;
		target.setAttribute("stryle", "ime-mode:disabled");
		// BackSpace,Delete, <-, ->, Tab 키 통과
		if( e.keyCode == 8 || e.keyCode == 46 || e.keyCode == 37 || e.keyCode == 39 || e.keyCode == 9 || e.keyCode >= 48 && e.keyCode <= 57 || e.keyCode >= 96 && e.keyCode <= 105 ) {
	    } else {
	    	if( e.preventDefault ){
	    		e.preventDefault();
	    	}else{
	    		e.returnValue = false;
	    	}
	    }
	}
}

$arr = array();

$obj["a"] = 1;
$obj["b"] = 2;
array_push($arr, $obj);

$obj["a"] = 9;
$obj["b"] = 0;
array_push($arr, $obj);

for( $i=0; $i<count($arr); $i++ ){
	echo "<br />arr[".$i."] a : " . $arr[$i]["a"];
	echo "<br />arr[".$i."] a : " . $arr[$i]["b"];
}

$sql = "select seq,title,content,file_ori,hit,regdate,file_phy from php_test order by seq desc limit 10";
$rs = mysql_query($sql, $connect);

$list = array();
while( $row = mysql_fetch_object( $rs ) ){
	$map;
	foreach( $row as $key => $data ){		
		$map[$key] = $row[$key];		
	}
	array_push($list, $map);
}

for( $i=0; $i<count($list); $i++ ){
	echo ( "" );
	echo ( "	". $list[$i][seq]  . "" );
	echo ( "	". $list[$i][title]  . "" );	
	echo ( "	". substr($list[$i][regdate], 0, 10)  . "" );
	echo ( "	". $list[$i][hit]  . "" );
	echo ( "" );
}

echo("==================== printParameter ====================
");
foreach( $_REQUEST as $key => $data ){
	if( strlen($key) < 20 && $key != "PHPSESSID" ){
		echo("==== " . $key . " : " . $data . "

");
	}
}
echo("==================== printParameter ====================
");