http://153.126.154.106/verify_20170828/20170831_rank.php

‘);

if ($dbh == null){
print(‘接続に失敗しました。
‘);
}else{
print(‘MySQL-DB接続に成功しました。
‘);
}

$sql0 = <<query($sql0);
$result0 = $stmt0->fetch(PDO::FETCH_NUM);

$sql1 = <<query($sql1);
$result = $stmt1->fetch(PDO::FETCH_NUM);

$sql2 = ‘SELECT count(*) FROM verify_t_rank ‘;
$stmt2 = $dbh->query($sql2);
$result2 = $stmt2->fetch(PDO::FETCH_NUM);

$sql3 = ‘SELECT rank FROM verify_t_rank WHERE (id = (select MAX( id ) from verify_t))’;
$stmt3 = $dbh->query($sql3);
$result3 = $stmt3->fetch(PDO::FETCH_NUM);

print(‘
‘);
//print(‘#1—- :’.$result[0].”
“);
//print(‘#2—- :’.$result[1].”
“);
//print(‘#3—- :’.$result[2].”
“);
//print(‘#4—- :’.$result[3].”
“);

//print(‘#4—- :’.$result3[0].”
“);

print(‘このPhotoは、全’.$result2[0].”件のうち
“);
print(‘第 ‘.$result3[0].”位で似ています！
“);

$sql4 = ‘select * from verify_t_rank’;
$stmt4 = $dbh->query($sql4);

print(‘
verify_t_rankテーブル全表示
‘);

?>

fetch(PDO::FETCH_NUM)){
print(‘

‘);
print(‘

‘);
// print(‘

‘);

print(‘

‘);
print(‘

‘);
print(‘

‘);
print(‘

‘);
print(‘

‘);
print(‘

‘);
}
?>

id	photo1	photo2	BL	conf	rank
‘.$result4[0].’	‘.$result4[1].’	‘.’‘.”.$result4[1].’	‘.’‘.”.$result4[1].’	‘.$result4[3].’	‘.$result4[4].’	‘.$result4[5].’

getMessage());
die();
}

$dbh = null;

echo ‘
MySQL-DBクローズしました’;

?>