Skip to content

Instantly share code, notes, and snippets.

@apivat60

apivat60/เว็บแอป ค้นหาข้อมูลจากชีต (5 พย 63)

Last active April 11, 2022 21:10
Show Gist options
  • Save apivat60/8a83a95945df7387c7f46ef8df3fa7be to your computer and use it in GitHub Desktop.
Save apivat60/8a83a95945df7387c7f46ef8df3fa7be to your computer and use it in GitHub Desktop.
Download ZIP
Raw
เว็บแอป ค้นหาข้อมูลจากชีต (5 พย 63)
<!DOCTYPE html>
<html>
<head>
<base target="_top">
</head>
<body>
<h1>ข้อมูลนักเรียน</h1>
<?var url = getUrl();?>
<form method="post" action="<?= url ?>" >
<label>ค้นหาข้อมูล</label><br>
<input type="text" name="search" value="<?= search ?>" />
<input type="submit" name="searchButton" value="Search" />
</form><br>
<table border="1" cellpadding="5px" >
<?var tableData = getSheetData();?>
<?for(var i = 0; i < tableData.length; i++) { ?>
<?if(i == 0) { ?>
<tr>
<?for(var j = 0; j < tableData[i].length; j++) { ?>
<th><?= tableData[i][j] ?></th>
<? } ?>
</tr>
<? } else { ?>
<? var rowArray = tableData[i];
var stringSearch = rowArray.toString().toLowerCase();
if(stringSearch.indexOf(search.toLowerCase()) != -1 || search == '') { ?>
<tr>
<? for(var j = 0; j < tableData[i].length; j++) { ?>
<td><?= tableData[i][j] ?></td>
<? } ?>
</tr>
<? }} ?>
<? } ?>
</table>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment