<html>
<head>
<meta charset="utf-8"/>
<title>music</title>
<script src="jquery.js"></script>
<script src="music.js"></script>
</head>
<body>
<p>
<label for="year">年を選択：</label>
<select id="year" name="year">
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013" selected>2013</option>
</select>
</p>
<p>
<label for="month">月を選択：</label>
<select id="month" name="month">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4" selected>4</option>
</select>
</p>
<p>
<label for="week">週を選択：</label>
<select id="week" name="week">
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4" selected>4</option>
</select>
</p>
<input type="button" value="テスト" onClick="sample()" />
<p id="table"></p>
</body>
</html>
function sample(){
var urlx;
var y1,m1,w1;
y1=$("#year").val();
m1=$("#month").val();
w1=$("#week").val();
urlx ="music.php?year="+y1;
urlx=urlx+"&month="+m1;
urlx=urlx+"&week="+w1;
$.get(urlx, function (mdata) {
var str = mdata.split("△");
var s;
var memo;
memo = "<table>";
for (s = 0; s < str.length;s++ ){
memo=memo+"<tr>";
memo=memo+"<td>";
memo=memo+str[s];
memo=memo+"</td>";
memo=memo+"</tr>";
}
memo = memo + "</table>";
$("#table").html(memo);
});
}
<?php
require('calldata.php');
$y1 = $_GET['year'];
$m1 = $_GET['month'];
$w1 = $_GET['week'];
$sql="SELECT y,m,w,r,a,t FROM music where y=";
$str1=" and m=";
$str2=" and w=";
$sql=$sql.$y1.$str1.$m1.$str2.$w1;
$result = mysql_query($sql);
$sx=0;
while ($row = mysql_fetch_assoc($result)) {
$sx=$sx+1;
$a[$sx]=$row['a'];
$r[$sx]=$row['r'];
$y[$sx]=$row['y'];
$m[$sx]=$row['m'];
$w[$sx]=$row['w'];
$t[$sx]=$row['t'];
}
$n=$sx;
for($s=1;$s<$n;$s++){
print($r[$s]);
print("△");
print($a[$s]);
print("△");
print($t[$s]);
print("△");
}
$s=$n;
print($r[$s]);
print("△");
print($a[$s]);
print("△");
print($t[$s]);
mysql_close($link);
?>
最終更新：2013年12月09日 20:27
