//募集中のランキングのデータを格納する
$t_rank_id = array();
$t_rank_title = array();
$t_rank_user_id = array();
$t_rank_date = array();
$movie_youtube = array();
$movie_img = array();
$user_message = array();
$user_url = array();
$user_sns_id = array();
$is_favo = false;
$rank_count = 0;
$user_movie_count = 0;
try {
$dbh = connectDB();
$user_movie_count = countMovie($dbh, $_SESSION['user_id']);
$sql = 'SELECT * FROM ranking WHERE 1';
$stmt = $dbh->prepare($sql);
$stmt->execute();
//ランキングの数だけループを回し、データを取得
while (true) {
$rec = $stmt->fetch(PDO::FETCH_ASSOC);
if ($rec == false) {
break;
}
//取得しているランキングの動画数を確認
$sql2 = 'SELECT count(*) as count FROM movie WHERE rank_id = ?';
$data[] = $rec['rank_id'];
$stmt2 = $dbh->prepare($sql2);
$stmt2->execute($data);
$data = array();
$rank_title = array();
$rank_date = array();
$get = sanitize($_GET);
$isGet = isset($get['id']);
if (isset($_FILES['user_img'])) {
$user_img = $_FILES['user_img'];
}
if (isset($_POST['own_rank_notice'])) {
$own_rank_notice = $_POST['own_rank_notice'];
}
if (isset($_POST['new_rank_notice'])) {
$new_rank_notice = $_POST['new_rank_notice'];
}
try {
$dbh = connectDB();
$user_movie_count = countMovie($dbh, isset($get['id']) == true ? $get['id'] : $_SESSION['user_id']);
if ($user_img['size'] == 0 || isset($user_img) == false) {
$smarty->assign("upload_message", "");
} else {
if ($user_img['size'] > 0 && $user_img['size'] < 1000000 && (strrchr($user_img['name'], '.') == '.jpg' || strrchr($user_img['name'], '.') == '.jpeg' || strrchr($user_img['name'], '.') == '.png')) {
move_uploaded_file($user_img['tmp_name'], './image/user_img/' . $user_img['name']);
$_SESSION['user_img_path'] = 'image/user_img/' . $user_img['name'];
$sql = 'UPDATE user SET user_img_path = ? WHERE user_id = ?';
$stmt = $dbh->prepare($sql);
$data[] = 'image/user_img/' . $user_img['name'];
$data[] = $_SESSION['user_id'];
$stmt->execute($data);
$data = array();
$smarty->assign("upload_message", "画像を変更しました。");
} else {
$smarty->assign("upload_message", "画像ファイルを選択してください。");
