include($_SERVER['DOCUMENT_ROOT']. "/common/includes/conf.php"); ?>
\n";
exit;
}
mysql_query("SET NAMES utf8", $dbHandle);
mysql_select_db( $dbname );
$sel = mysql_query( "SELECT title, type, items, description, capture, url FROM `portfolio`" );
if( !$sel ) {
echo "検索でエラーが発生しました
\n";
exit;
}
// GET変数取得
$id = $_GET["id"];
if(preg_match("/^[0-9]+$/", $id)) {
} else { header("Location: /works/"); }
// DB取り出し
$siteTit = mysql_query( "SELECT title FROM `portfolio`" );
$siteType = mysql_query( "SELECT type FROM `portfolio`" );
$siteItem = mysql_query( "SELECT items FROM `portfolio`" );
$siteTxt = mysql_query( "SELECT description FROM `portfolio`" );
$siteUrl = mysql_query( "SELECT url FROM `portfolio`" );
$siteCap = mysql_query( "SELECT capture FROM `portfolio`" );
// idが無ければエラー
$row = mysql_num_rows($siteTit);
if($id >= $row) {
echo "NOTFOUND...";
exit;
}
// 値の取り出し
$siteTit = mysql_result( ${siteTit}, $id );
$siteType = mysql_result( ${siteType}, $id );
$siteItem = mysql_result( ${siteItem}, $id );
$siteTxt = mysql_result( ${siteTxt}, $id );
$siteUrl = mysql_result( ${siteUrl}, $id );
$siteCap = mysql_result( ${siteCap}, $id );
mysql_free_result( $sel );
mysql_close( $dbHandle );
?>