チェンジセット 94: trunk/install/php/showplaylist.php
- コミット日時:
- 2010/02/28 22:28:26 (15 年前)
- ファイル:
凡例:
- 変更無し
- 追加
- 削除
- 更新
- コピー
- 移動
trunk/install/php/showplaylist.php
r83 r94 115 115 FROM foltia_subtitle , foltia_program 116 116 WHERE foltia_program.tid = foltia_subtitle.tid 117 AND foltia_subtitle.tid = $filesplit[0] 118 "; 119 $rs = m_query($con, $query, "DBクエリに失敗しました"); 120 $rowdata = pg_fetch_row($rs, $row); 117 AND foltia_subtitle.tid = ? 118 "; 119 //$rs = m_query($con, $query, "DBクエリに失敗しました"); 120 $rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0])); 121 $rall = $rs->fetchAll(); 122 $rowdata = $rall[$row]; 121 123 //print" $fName./$rowdata[1]//$rowdata[2]<BR>\n"; 122 124 $title = $rowdata[1]; … … 130 132 FROM foltia_subtitle , foltia_program 131 133 WHERE foltia_program.tid = foltia_subtitle.tid 132 AND foltia_subtitle.tid = $filesplit[0] 133 AND foltia_subtitle.countno = $filesplit[1] 134 "; 135 $rs = m_query($con, $query, "DBクエリに失敗しました"); 136 $rowdata = pg_fetch_row($rs, $row); 134 AND foltia_subtitle.tid = ? 135 AND foltia_subtitle.countno = ? 136 "; 137 //$rs = m_query($con, $query, "DBクエリに失敗しました"); 138 $rs = sql_query($con, $query, "DBクエリに失敗しました",array($filesplit[0],$filesplit[1])); 139 $rall = $rs->fetchAll(); 140 $rowdata = $rall[$row]; 137 141 //print" $fName./$rowdata[1]/$rowdata[2]/$rowdata[3]<BR>\n"; 138 142 $title = $rowdata[1]; … … 197 201 } 198 202 199 $rs = m_query($con, $query, "DBクエリに失敗しました"); 200 $maxrows = pg_num_rows($rs); 201 202 if ($maxrows > 0){ 203 for ($row = 0; $row < $maxrows; $row++) { 204 $rowdata = pg_fetch_row($rs, $row); 205 203 //$rs = m_query($con, $query, "DBクエリに失敗しました"); 204 $rs = sql_query($con, $query, "DBクエリに失敗しました"); 205 $rowdata = $rs->fetch(); 206 if ($rowdata) { 207 do { 206 208 $tid = htmlspecialchars($rowdata[0]); 207 209 $title = htmlspecialchars($rowdata[1]); … … 235 237 print "</tr>\n 236 238 "; 237 }//for 239 } while ($rowdata = $rs->fetch()); 238 240 }else{ 239 241 print " … … 262 264 "; 263 265 264 $rs = m_query($con, $query, "DBクエリに失敗しました"); 265 $maxrows = pg_num_rows($rs); 266 267 268 if ($maxrows > 0){ 266 //$rs = m_query($con, $query, "DBクエリに失敗しました"); 267 $rs = sql_query($con, $query, "DBクエリに失敗しました"); 268 $rowdata = $rs->fetch(); 269 if ($rowdata) { 269 270 print "<hr> 270 271 <p align=\"left\">未読タイトルを表示します。<br> … … 279 280 "; 280 281 281 for ($row = 0; $row < $maxrows; $row++) { 282 $rowdata = pg_fetch_row($rs, $row); 283 282 do { 284 283 $tid = htmlspecialchars($rowdata[0]); 285 284 $title = htmlspecialchars($rowdata[1]); 286 285 287 288 286 print "<tr><td>$tid</td><td>$title</td></tr>\n"; 289 287 290 }//for 288 } while ($rowdata = $rs->fetch()); 291 289 print "</tbody></table>\n"; 292 290 }//if maxrows
