コメント |
@DIV
<?
# **********************************************************
# 外部ファイル
# **********************************************************
require_once( "conf.php" );
require_once( "{$conf_common_path1}common.php" );
require_once( "{$conf_common_path2}db.php" );
# **********************************************************
# 接続
# **********************************************************
$SQL = new DB( "localhost", "lightbox", "root", "" );
$Query = "select * from 商品マスタ where 商品コード = '0001'";
$Column = $SQL->QueryEx( $Query );
if ( $Column ) {
print "<PRE>";
print_r( $Column );
print "</PRE>";
}
else {
print "該当データは存在しません<br>";
}
$Query = "select * from 商品マスタ where 商品コード = '9999'";
$Column = $SQL->QueryEx( $Query );
if ( $Column ) {
print "<PRE>";
print_r( $Column );
print "</PRE>";
}
else {
print "該当データは存在しません<br>";
}
# **********************************************************
# 接続解除
# **********************************************************
$SQL->Close();
# **********************************************************
# デバッグ
# **********************************************************
DispData( $_POST['debug'] == 'yes', TRUE );
?>
@END
[[↓実行結果]]
@LINE
@HTML
<PRE>Array
(
[0] => 0001
[商品コード] => 0001
[1] => スポーツ用品−−−−−−−−−−−−−−−0001
[商品名] => スポーツ用品−−−−−−−−−−−−−−−0001
[2] => 8570
[在庫評価単価] => 8570
[3] => 8820
[販売単価] => 8820
[4] => G20
[商品分類] => G20
[5] => 1
[商品区分] => 1
[6] => 2005-05-27 00:00:00
[作成日] => 2005-05-27 00:00:00
[7] => 2005-08-23 00:00:00
[更新日] => 2005-08-23 00:00:00
)
</PRE>該当データは存在しません<br>
@HEND
|