最新の防災ストーリー

最近話された防災ストーリー

「防災トランプのはじめて教室」で話された防災ストーリーを公開しています。

get_var(“SELECT COUNT(*) FROM wp_bt_stories;”);
$str = “現在データベースに登録されている防災ストーリーは” .$num .”話です。”;
$str = str_replace(array(“\r\n”,”\r”,”\n”), ”, $str);
echo $str;
?>

get_results(“SELECT * FROM wp_bt_stories ORDER BY spetime DESC;”);
$counter = 0;
foreach ($rows as $row) {
$counter = $counter + 1;
echo ”

“;
echo ”

“;
echo $row->age;
echo “代 “;
if (1==$row->gen){
echo “男性　”;
}else if(2==$row->gen){
echo “女性　”;
}
echo “		 “;
echo ““;
echo $row->title;
echo ““;
echo “（”;
$str = $row->spetime;
echo date(“Y年m月d日”, strtotime($str));
echo “）”;
echo “
“;
if(1==$row->cat){
if(1==$row->number){
echo “tr101shr“;
}else if(2==$row->number){
echo “tr102shr“;
}else if(3==$row->number){
echo “tr103shr“;
}else if(4==$row->number){
echo “tr104shr“;
}else if(5==$row->number){
echo “tr105shr“;
}else if(6==$row->number){
echo “tr106shr“;
}else if(7==$row->number){
echo “tr107shr“;
}else if(8==$row->number){
echo “tr108shr“;
}else if(9==$row->number){
echo “tr109shr“;
}else if(10==$row->number){
echo “tr110shr“;
}else if(11==$row->number){
echo “tr111shr“;
}else if(12==$row->number){
echo “tr112shr“;
}else if(13==$row->number){
echo “tr113shr“;
}
}else if(2==$row->cat){
if(1==$row->number){
echo “tr201shr“;
}else if(2==$row->number){
echo “tr202shr“;
}else if(3==$row->number){
echo “tr203shr“;
}else if(4==$row->number){
echo “tr204shr“;
}else if(5==$row->number){
echo “tr205shr“;
}else if(6==$row->number){
echo “tr206shr“;
}else if(7==$row->number){
echo “tr207shr“;
}else if(8==$row->number){
echo “tr208shr“;
}else if(9==$row->number){
echo “tr209shr“;
}else if(10==$row->number){
echo “tr210shr“;
}else if(11==$row->number){
echo “tr211shr“;
}else if(12==$row->number){
echo “tr212shr“;
}else if(13==$row->number){
echo “tr213shr“;
}
}else if(3==$row->cat){
if(1==$row->number){
echo “tr301shr“;
}else if(2==$row->number){
echo “tr302shr“;
}else if(3==$row->number){
echo “tr303shr“;
}else if(4==$row->number){
echo “tr304shr“;
}else if(5==$row->number){
echo “tr305shr“;
}else if(6==$row->number){
echo “tr306shr“;
}else if(7==$row->number){
echo “tr307shr“;
}else if(8==$row->number){
echo “tr308shr“;
}else if(9==$row->number){
echo “tr309shr“;
}else if(10==$row->number){
echo “tr310shr“;
}else if(11==$row->number){
echo “tr311shr“;
}else if(12==$row->number){
echo “tr312shr“;
}else if(13==$row->number){
echo “tr313shr“;
}
}else if(4==$row->cat){
if(1==$row->number){
echo “tr412shr“;
}else if(2==$row->number){
echo “tr412shr“;
}else if(3==$row->number){
echo “tr412shr“;
}else if(4==$row->number){
echo “tr412shr“;
}else if(5==$row->number){
echo “tr412shr“;
}else if(6==$row->number){
echo “tr412shr“;
}else if(7==$row->number){
echo “tr412shr“;
}else if(8==$row->number){
echo “tr412shr“;
}else if(9==$row->number){
echo “tr412shr“;
}else if(10==$row->number){
echo “tr412shr“;
}else if(11==$row->number){
echo “tr412shr“;
}else if(12==$row->number){
echo “tr412shr“;
}else if(13==$row->number){
echo “tr413shr“;
}
}
echo “		 “;
echo $row->content;
echo “

“;
echo ”

“;
if( 100 == $counter) {
break;
}
}
?>;