- Beranda
- Komunitas
- Tech
- Programmer Forum
[Help] ASP classic database
TS
upiljandaprawan
[Help] ASP classic database
Agan2 master programming, ane nuwbie mo tanya cara bikin table model gini gmn ya?
![[Help] ASP classic database](https://s.kaskus.id/images/2012/11/14/2146770_20121114090030.jpg)
ane uda bikin seperti ini:
![[Help] ASP classic database](https://s.kaskus.id/images/2012/11/14/2146770_20121114091047.JPG)
ini script ane:
Gmn cara untuk nampilin data Days sama Date nya dengan gunain database SQL gt?
Thanks gan
Spoiler for contoh table:
ane uda bikin seperti ini:
Spoiler for web:
ini script ane:
Spoiler for script:
[removed]
var d=new Date()
var weekday=new Array("Sunday","Monday","Tuesday","Wednesday","Thursday",
"Friday","Saturday")
var month=new Array("January","February","March","April","May","June","July","August",
"September","October","November","December")
[removed]
<%
%>
<html>
<head>
<link rel="stylesheet" type="text/css" href="css\\style.css"/>
<link type="text/css" href="css/smoothness/jquery-ui-1.8.17.custom.css" rel="stylesheet" />
[removed][removed]
[removed][removed]
[removed]
$(function(){
$( "#datepicker" ).datepicker({
beforeShowDay:function(date){
if(date.toString().indexOf('Sun ')!=-1 ||date.toString().indexOf('Sat ')!=-1 )
return [1,'red'];
else
return [1];
},
duration : 'normal'
});
$( "#datepicker2" ).datepicker({
beforeShowDay:function(date){
if(date.toString().indexOf('Sun ')!=-1 ||date.toString().indexOf('Sat ')!=-1 )
return [1,'red'];
else
return[1];
},
duration : 'normal'
});
})
[removed]
<style type="text/css">
body{ font: 62.5% "Trebuchet MS", sans-serif; margin: 0px;}
</style>
<title>Rintis NSICC Lab - Add/Edit THF </title>
</head>
<body>
<form name="frmTH" method="post">
<br>
<table width=75% border=0 cellpadding=0 cellspacing=0 align=center bgcolor=lavender>
<tr><td colspan=6><td colspan=6 align=center><font face="arial" size=4 color="blue">New Temp & Humid Form</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width=75% border=0 cellpadding=1 cellspacing=1 align=center bgcolor=#c0c0c0>
<tr><td colspan=30> </td></tr>
<tr class="smallfontcat1">
<td> THF Date:
......</td>
<td> Created By:</td>
<td><input type="text" readonly></td>
</tr>
<tr class="smallfontcat1">
<td> THF Ref:
RSyyTHLmm-dd-x</td>
<td> Requested By:</td>
<td><select><option></option></select></td>
</tr>
<tr class="smallfontcat1">
<td> From:
<input type="text" id="datepicker" name="txtfromdate">
To:
<input type="text" id="datepicker2" name="txttodate"></td>
</tr>
<tr>
<td colspan=6 align=center width="100%">
<div style="overflow: auto;height: 250px; width: 900px;">
<table width=100% border=1 cellpadding=0 cellspacing=0 bgcolor=#FFFFFF align=center>
<tr class="smallfontcat1">
<tr class=smallfontcat3>
<td rowspan=2 width="2%" align=center>No.</td>
<td rowspan=2 width="5%" align=center>Day</td>
<td rowspan=2 width="5%" align=center>Date</td>
<td colspan=4 width="20%" align=center> Room A </td>
<td colspan=4 width="20%" align=center> Room B </td>
<td colspan=4 width="20%" align=center> Room C </td>
<td colspan=4 width="20%" align=center> Room D </td>
<td colspan=4 width="20%" align=center> Room E </td>
</tr>
<tr class=smallfontcat3>
<td width="5%" align=center>Time</td>
<td width="5%" align=center>Temp</td>
<td width="5%" align=center>Hum</td>
<td width="5%" align=center>Person</td>
<td width="5%" align=center>Time</td>
<td width="5%" align=center>Temp</td>
<td width="5%" align=center>Hum</td>
<td width="5%" align=center>Person</td>
<td width="5%" align=center>Time</td>
<td width="5%" align=center>Temp</td>
<td width="5%" align=center>Hum</td>
<td width="5%" align=center>Person</td>
<td width="5%" align=center>Time</td>
<td width="5%" align=center>Temp</td>
<td width="5%" align=center>Hum</td>
<td width="5%" align=center>Person</td>
<td width="5%" align=center>Time</td>
<td width="5%" align=center>Temp</td>
<td width="5%" align=center>Hum</td>
<td width="5%" align=center>Person</td>
</tr>
</table>
</table>
</form>
</body>
</html>
var d=new Date()
var weekday=new Array("Sunday","Monday","Tuesday","Wednesday","Thursday",
"Friday","Saturday")
var month=new Array("January","February","March","April","May","June","July","August",
"September","October","November","December")
[removed]
<%
%>
<html>
<head>
<link rel="stylesheet" type="text/css" href="css\\style.css"/>
<link type="text/css" href="css/smoothness/jquery-ui-1.8.17.custom.css" rel="stylesheet" />
[removed][removed]
[removed][removed]
[removed]
$(function(){
$( "#datepicker" ).datepicker({
beforeShowDay:function(date){
if(date.toString().indexOf('Sun ')!=-1 ||date.toString().indexOf('Sat ')!=-1 )
return [1,'red'];
else
return [1];
},
duration : 'normal'
});
$( "#datepicker2" ).datepicker({
beforeShowDay:function(date){
if(date.toString().indexOf('Sun ')!=-1 ||date.toString().indexOf('Sat ')!=-1 )
return [1,'red'];
else
return[1];
},
duration : 'normal'
});
})
[removed]
<style type="text/css">
body{ font: 62.5% "Trebuchet MS", sans-serif; margin: 0px;}
</style>
<title>Rintis NSICC Lab - Add/Edit THF </title>
</head>
<body>
<form name="frmTH" method="post">
<br>
<table width=75% border=0 cellpadding=0 cellspacing=0 align=center bgcolor=lavender>
<tr><td colspan=6><td colspan=6 align=center><font face="arial" size=4 color="blue">New Temp & Humid Form</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<table width=75% border=0 cellpadding=1 cellspacing=1 align=center bgcolor=#c0c0c0>
<tr><td colspan=30> </td></tr>
<tr class="smallfontcat1">
<td> THF Date:
......</td>
<td> Created By:</td>
<td><input type="text" readonly></td>
</tr>
<tr class="smallfontcat1">
<td> THF Ref:
RSyyTHLmm-dd-x</td>
<td> Requested By:</td>
<td><select><option></option></select></td>
</tr>
<tr class="smallfontcat1">
<td> From:
<input type="text" id="datepicker" name="txtfromdate">
To:
<input type="text" id="datepicker2" name="txttodate"></td>
</tr>
<tr>
<td colspan=6 align=center width="100%">
<div style="overflow: auto;height: 250px; width: 900px;">
<table width=100% border=1 cellpadding=0 cellspacing=0 bgcolor=#FFFFFF align=center>
<tr class="smallfontcat1">
<tr class=smallfontcat3>
<td rowspan=2 width="2%" align=center>No.</td>
<td rowspan=2 width="5%" align=center>Day</td>
<td rowspan=2 width="5%" align=center>Date</td>
<td colspan=4 width="20%" align=center> Room A </td>
<td colspan=4 width="20%" align=center> Room B </td>
<td colspan=4 width="20%" align=center> Room C </td>
<td colspan=4 width="20%" align=center> Room D </td>
<td colspan=4 width="20%" align=center> Room E </td>
</tr>
<tr class=smallfontcat3>
<td width="5%" align=center>Time</td>
<td width="5%" align=center>Temp</td>
<td width="5%" align=center>Hum</td>
<td width="5%" align=center>Person</td>
<td width="5%" align=center>Time</td>
<td width="5%" align=center>Temp</td>
<td width="5%" align=center>Hum</td>
<td width="5%" align=center>Person</td>
<td width="5%" align=center>Time</td>
<td width="5%" align=center>Temp</td>
<td width="5%" align=center>Hum</td>
<td width="5%" align=center>Person</td>
<td width="5%" align=center>Time</td>
<td width="5%" align=center>Temp</td>
<td width="5%" align=center>Hum</td>
<td width="5%" align=center>Person</td>
<td width="5%" align=center>Time</td>
<td width="5%" align=center>Temp</td>
<td width="5%" align=center>Hum</td>
<td width="5%" align=center>Person</td>
</tr>
</table>
</table>
</form>
</body>
</html>
Gmn cara untuk nampilin data Days sama Date nya dengan gunain database SQL gt?
Thanks gan
0
884
Kutip
1
Balasan
Komentar yang asik ya
Urutan
Terbaru
Terlama
Komentar yang asik ya
Komunitas Pilihan