php db connect

 <?php

echo "Hello world!";

$server_name = "localhost";

$user = "root";

$password = "";

//$port = "3306";

$database = "php";

$connect = mysqli_connect($server_name, $user, $password, $database);

mysqli_select_db($connect, $database) or die("DB failed");

$sql_query = "SELECT * FROM members order by idx desc";

//asc 오름차순, desc 내림차순

$result = mysqli_query($connect, $sql_query);

echo "<table border = '1'>";

echo "<tr>";

echo "<th>No</th>";

echo "<th>Name</th>";

echo "<th>Age</th>";

echo "<th>Gender</th>";

echo "<th>등록일</th>";

echo "</tr>";

while ($row = mysqli_fetch_array($result)) {

    echo "<tr>";

    echo "<td>" . $row['idx'] . "</td>";

    echo "<td>" . $row['name'] . "</td>";

    echo "<td>" . $row['age'] . "</td>";

    echo "<td>" . $row['gender'] . "</td>";

    echo "<td>" . $row['regdate'] . "</td>";

    echo "</tr>";

}

echo "</table>";  // 문자열 닫기 수정

mysqli_close($connect);

Excel 365에서 소수3째자리 변경 Excel script source

 function main(workbook: ExcelScript.Workbook) { let selectedSheet = workbook.getActiveWorksheet(); // G:H 열에서 마지막 행을 찾아 소수점 3자리로 포맷 let usedRange = selectedSheet.getRange("G:H").getUsedRange(); let lastRow = usedRange.getRowCount(); // 마지막 행까지의 범위를 지정하여 포맷 적용 selectedSheet.getRange(G2:H${lastRow + 1}).setNumberFormatLocal("#,##0.000"); }