분류 전체보기
-
테이블이 없는경우 접속시 테이블 생성그누보드 2020. 5. 6. 18:52
// 테이블 생성 if(!sql_query(" DESCRIBE g5_banner ", false)) { sql_query(" CREATE TABLE `g5_banner` ( `bn_id` int(11) NOT NULL auto_increment, `bn_subject` varchar(255) NOT NULL default '', `bn_alt` varchar(255) NOT NULL default '', `bn_url` varchar(255) NOT NULL default '', `bn_device` varchar(10) NOT NULL default '', `bn_position` varchar(255) NOT NULL default '', `bn_border` tinyint(4) NOT NULL de..
-
이름 마스킹 처리(맨앞과 뒤만 출력)PHP 2020. 5. 6. 18:52
function markingName($text){ $length = mb_strlen($text, "utf-8"); $andMarking = ""; for($i = 2; $i { $andMarking .= "*"; } $sMarking = mb_substr($text, 0, 1, 'utf-8'); $eMarking = mb_substr($text, $length - 1, $length, 'utf-8'); return $sMarking.$andMarking.$eMarking; }?>
-
핸드폰 구분자 넣기PHP 2020. 5. 6. 18:51
function format_phone($phone){ $phone = preg_replace("/[^0-9]/", "", $phone); $length = strlen($phone); switch($length){ case 11 : return preg_replace("/([0-9]{3})([0-9]{4})([0-9]{4})/", "$1-$2-$3", $phone); break; case 10: return preg_replace("/([0-9]{3})([0-9]{3})([0-9]{4})/", "$1-$2-$3", $phone); break; case 9: return preg_replace("/([0-9]{2})([0-9]{3})([0-9]{4})/", "$1-$2-$3", $phone); break..
-
날짜계산 함수PHP 2020. 5. 6. 18:51
function diffdate($date1, $date2){ $diff = abs(strtotime($date2) - strtotime($date1)); $years = floor($diff / (365*60*60*24)); $months = floor(($diff - $years * 365*60*60*24) / (30*60*60*24)); $days = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24)/ (60*60*24)); $time = floor(($diff - $years * 365*60*60*24 - $months*30*60*60*24 - $days * 60*60*24)/ (60*60)) ; $minute = floor(($diff -..
-
날짜PHP 2020. 5. 6. 18:50
$last = date("t", strtotime($year."-".$month."-01 00:00:00")); //해당달의 마지막 날짜한달전 $start = date("Y-m-01", strtotime("-1 month", time())); $end = date("Y-m-".date("t", strtotime($start)), strtotime("-1 month", time())); //시작일~~종료일 출력 $start = strtotime($sc["sc_date_start"]); $end = strtotime($sc["sc_date_end"]); while ($start
-
배열생성JAVA 2020. 5. 6. 18:47
int[] a = new int[3]; int[] b; b = new int[3]; //선언된 변수가 배열변수가 아니다 //int c; //c = new int[3]; // error //배열만들기 ArrayList tmpAry = new ArrayList(); //배열입력 tmpAry.add("aaa"); tmpAry.add("bbb"); //출력 System.out.println(tmpAry); //배열출력 System.out.println(tmpAry.get(1)); //원하는 위치의 배열값출력 System.out.println(tmpAry.indexOf("bb")); //해당값을 가지고잇는 index출력 tmpAry.forEach(idx -> System.out.println(idx)); // 반..
-
메소드JAVA 2020. 5. 6. 18:46
package test01; public class Test { static int a = 0; int c = 0; Test() { this.a++; this.c++; } public int getNum(int num) { return num; } public static class test2 { int p = 0; String str = "aaaaa"; int tmpNum; public void setNum(int num) { this.tmpNum = num; } } public void say_nick(String nick) { //equals 같은경우 if("fool".equals(nick)) { return; } System.out.println("별명은 "+ nick + " 입니다."); } p..