<html>
<head>
<meta charset="utf-8"/>
<title>book</title>
<script src="jquery.js"></script>
<script src="book.js"></script>
<script src="play.js"></script>
</head>
<body onload="sample()">
<p id="table">準備中</p>
<input type="button" value="テスト" onClick="play()" />
<input type="button" value="check" onClick="check()" />
</body>
</html>
var number;
var title=new Array();
var pic=new Array();
var point;
function sample(){
point=0;
var urlx;
urlx ="book.php";
$.get(urlx, function (csvdata) {
var str = csvdata.split(",");
var s;
number=str.length/2;
for (s =1; s <number+1;s++ ){
title[s]=str[2*s-2];
pic[s]=str[2*s-1];
}
$("#table").html(number);
});
}
function play(){
var strx;
point=point+1;
strx="<h2>"+title[point]+"</h2>";
strx=strx+"<br>";
strx=strx+"<img src=\""+pic[point]+"\" width=500 height=500>";
$("#table").html(strx);
}
function check(){
var urlx;
urlx ="check.php?pic="+pic[point];
$.get(urlx, function (csvdata) {
});
}
<?php
require('calldata.php');
$sql="SELECT t,p,c FROM book2";
$result = mysql_query($sql);
$sx=0;
while($row = mysql_fetch_assoc($result)){
$sx=$sx+1;
$a[$sx]=$row['t'];
$b[$sx]=$row['p'];
$c[$sx]=$row['c'];
}
$n=$sx;
$sx=0;
for($s=1;$s<$n;$s++){
if($c[$s]<50)$sx=$sx+1;
if($c[$s]<50)$ax[$sx]=$a[$s];
if($c[$s]<50)$bx[$sx]=$b[$s];
}
$n=$sx;
for($s=1;$s<$n;$s++){
print($ax[$s]);
print(",");
print($bx[$s]);
print(",");
}
$s=$n;
print($ax[$s]);
print(",");
print($bx[$s]);
mysql_close($link);
?>
function play(){
var strx;
point=point+1;
strx="<h2>"+title[point]+"</h2>";
strx=strx+"<br>";
strx=strx+"<img src=\""+pic[point]+"\" width=500 height=500>";
$("#table").html(strx);
}
function check(){
var urlx;
urlx ="check.php?pic="+pic[point];
$.get(urlx, function (csvdata) {
});
}
最終更新：2013年12月12日 07:18
