
みんなでこのサイトを作りましょう!→[コラビスマイルとは?] →[会員登録はこちら] →[ご意見・ご要望はこちら]
みんなでつくるマップ新着情報
//問合せ文定義 $data = "SELECT m.map_cd as cd, map_title as title, dv.div_nm as type_nm, date_format(m.inst_date, '%Y\.%m\.%d') AS inst_date FROM {$g_tbl['map']} AS m LEFT JOIN {$g_tbl['div']} AS dv ON m.map_type = dv.div_cd AND dv.div_type = 'map_type' WHERE map_open = 2 ORDER BY inst_date DESC LIMIT 5"; //print $data; $data = stripslashes($data); // $data = mb_convert_encoding(stripslashes($data), "eucJP-win", "UTF-8"); //db object $db = new gf_DB(); $column_new = $db->execute($data); /* to_char(m.inst_date, 'YYYY\.MM\.DD') AS inst_date */ if ($column_new) { echo "- \n";
// 一覧表示
while($column_new) {
foreach ($column_new as $col_k => $col_v) { $column_new[$col_k] = stripslashes($col_v); }
// foreach ($column_new as $col_k => $col_v) { $column_new[$col_k] = mb_convert_encoding(stripslashes($col_v), "UTF-8", "eucJP-win"); }
$obj_new = new gf_form($column_new);
// 特殊文字を HTML エンティティに変換する
$obj_new -> Htmlspecialchars();
// メールアドレス、URLをリンクタグに入れる
$obj_new -> Ch_mail_url();
// 改行を
- echo "{$column_new['inst_date']}"; ?>
- "> echo mb_strimwidth($column_new['title'], 0, 50, "...", utf8); ?> unset($obj_new); //オブジェクト破棄 $column_new = $db->fetch(); } echo "
にする $obj_new -> Br (); $column_new = $obj_new ->Data(); ?>