[code] <?php $toDay = date('Ymd'); //오늘 $yesterDay = $toDay -1; // 어제 date("Y-m-d H:i:s"); //24시간으로 출력 date("Y-m-d h:i:s"); // 12시간으로 출력 date("Ymd"); //날짜까지만 출력 date("h:i:s"); // 시간만 출력 date("Y-m-d H:i:s",time());…
//일반 $row_num = "row_number() over(ORDER BY `board_seq` ASC)"; //상태에 따른 처리(예:숨김 행 따로) $row_num2 = "row_number() over(PARTITION BY `state` ORDER BY CASE WHEN `state` = 'Y' THEN false ELSE 'none'…
/* Start transaction */ mysqli_begin_transaction($db_connect); try{ $query = "INSERT INTO `board` SET "; $query.= "`title` = '$title', "; $query.= "`contents` = '$new_contents', "; $query.= "`state` = '$state', "; $query.= "`writer_id`…
PHP + MSSQL https://learn.microsoft.com/ko-kr/sql/connect/php/microsoft-php-driver-for-sql-server?view=sql-server-ver16 PHP + IIS https://learn.microsoft.com/ko-kr/iis/application-frameworks/scenario-build-a-php-website-on-iis/overview-build-a-php-website-on-iis
$Tb_S092 = preg_replace('/[ |\t]+/', ' ', $Tb_S092); $Tb_S092 = preg_replace('/\s{2,}/', ' ', $Tb_S092); $Tb_S092 = preg_replace('/\s{2,}/u', ' ', $Tb_S092); $Tb_S092 = preg_replace('/[\s]+/', ' ', $Tb_S092);