<? require_once( "db.php" ); require_once( "function.php" ); # ********************************************************** # 画面表示前のサーバ側の処理 # ********************************************************** # ********************************************************** # クライアント側に表示される画面 # ********************************************************** ?> <SCRIPT language=JavaScript> </SCRIPT> <? require_once( "pagestart.php" ); ?> <!-- ******************************************************* 送信フォーム ******************************************************** --> <FORM name=frmMain method=get action=<?= $_SERVER['SCRIPT_NAME'] ?> > <INPUT name=SendButton type=submit value="検索" > <INPUT name=ReloadButton type=button value="再表示" onClick='location.reload(true);' > <HR size=1 color=black> <?= $LIST ?> </FORM> <? require_once( "pageend.php" ); ?> <? DispData(); ?>
# ********************************************************** # 画面表示前のサーバ側の処理 # ********************************************************** $SQL = new DB( 'localhost', 'lightbox', 'root', '' ); $SQL->Close();
# ********************************************************** # 画面表示前のサーバ側の処理 # ********************************************************** $SQL = new DB( 'localhost', 'lightbox', 'root', '' ); $Query = "select * from 取引データ"; $COLUMN = $SQL->QueryEX( $Query ); while ( $COLUMN ) { print $COLUMN[0] . '/'; print $COLUMN[1] . '/'; print $COLUMN[2] . '/'; print $COLUMN[3] . '/'; print $COLUMN[4] . '/'; print $COLUMN[5] . '/'; print $COLUMN[6] . '/'; print $COLUMN[7] . '/'; print $COLUMN[8] . '/'; print $COLUMN[9] . '/'; print $COLUMN[10] . '/'; print $COLUMN[11] . '<BR>'; $COLUMN = $SQL->QueryEX( "" ); } $SQL->Close();
# ********************************************************** # 画面表示前のサーバ側の処理 # ********************************************************** $SQL = new DB( 'localhost', 'lightbox', 'root', '' ); $Query = "select * from 取引データ"; $COLUMN = $SQL->QueryEX( $Query ); while ( $COLUMN ) { $LIST .= $COLUMN[0] . '/'; $LIST .= $COLUMN[1] . '/'; $LIST .= $COLUMN[2] . '/'; $LIST .= $COLUMN[3] . '/'; $LIST .= $COLUMN[4] . '/'; $LIST .= $COLUMN[5] . '/'; $LIST .= $COLUMN[6] . '/'; $LIST .= $COLUMN[7] . '/'; $LIST .= $COLUMN[8] . '/'; $LIST .= $COLUMN[9] . '/'; $LIST .= $COLUMN[10] . '/'; $LIST .= $COLUMN[11] . '<BR>'; $COLUMN = $SQL->QueryEX( "" ); } $SQL->Close();
$LIST = "<TABLE >"; while ( $COLUMN ) { $LIST .= "<TR>"; $LIST .= "<TD>" . $COLUMN[0] . "</TD>"; $LIST .= "<TD>" . $COLUMN[1] . "</TD>"; $LIST .= "<TD>" . $COLUMN[2] . "</TD>"; $LIST .= "<TD>" . $COLUMN[3] . "</TD>"; $LIST .= "<TD>" . $COLUMN[4] . "</TD>"; $LIST .= "<TD>" . $COLUMN[5] . "</TD>"; $LIST .= "<TD>" . $COLUMN[6] . "</TD>"; $LIST .= "<TD>" . $COLUMN[7] . "</TD>"; $LIST .= "<TD>" . $COLUMN[8] . "</TD>"; $LIST .= "<TD>" . $COLUMN[9] . "</TD>"; $LIST .= "<TD>" . $COLUMN[10] . "</TD>"; $LIST .= "<TD>" . $COLUMN[11] . "</TD>"; $LIST .= "</TR>"; $COLUMN = $SQL->QueryEX( "" ); } $LIST .= "</TABLE>";
$LIST = "<TABLE >"; $LIST .= "<TH>取引区分</TH>"; $LIST .= "<TH>取引日付</TH>"; $LIST .= "<TH>伝票番号</TH>"; $LIST .= "<TH>取引先コード</TH>"; $LIST .= "<TH>商品コード</TH>"; $LIST .= "<TH>数量</TH>"; $LIST .= "<TH>単価</TH>"; $LIST .= "<TH>金額</TH>"; $LIST .= "<TH>消費税</TH>"; $LIST .= "<TH>種別</TH>"; $LIST .= "<TH>備考</TH>"; $LIST .= "<TH>更新フラグ</TH>"; while ( $COLUMN ) { $LIST .= "<TR>"; $LIST .= "<TD>" . $COLUMN[0] . "</TD>"; $LIST .= "<TD>" . $COLUMN[1] . "</TD>"; $LIST .= "<TD>" . $COLUMN[2] . "</TD>"; $LIST .= "<TD>" . $COLUMN[3] . "</TD>"; $LIST .= "<TD>" . $COLUMN[4] . "</TD>"; $LIST .= "<TD>" . $COLUMN[5] . "</TD>"; $LIST .= "<TD>" . $COLUMN[6] . "</TD>"; $LIST .= "<TD>" . $COLUMN[7] . "</TD>"; $LIST .= "<TD>" . $COLUMN[8] . "</TD>"; $LIST .= "<TD>" . $COLUMN[9] . "</TD>"; $LIST .= "<TD>" . $COLUMN[10] . "</TD>"; $LIST .= "<TD>" . $COLUMN[11] . "</TD>"; $LIST .= "</TR>"; $COLUMN = $SQL->QueryEX( "" ); } $LIST .= "</TABLE>";
$LIST = "<TABLE >"; $LIST .= "<TH>取引区分</TH>"; $LIST .= "<TH>取引日付</TH>"; $LIST .= "<TH>伝票番号</TH>"; $LIST .= "<TH>取引先コード</TH>"; $LIST .= "<TH>商品コード</TH>"; $LIST .= "<TH>数量</TH>"; $LIST .= "<TH>単価</TH>"; $LIST .= "<TH>金額</TH>"; $LIST .= "<TH>消費税</TH>"; $LIST .= "<TH>種別</TH>"; $LIST .= "<TH>備考</TH>"; $LIST .= "<TH>更新フラグ</TH>"; while ( $COLUMN ) { $LIST .= "<TR>"; $LIST .= "<TD>" . $COLUMN['取引区分'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['取引日付'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['伝票番号'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['取引先コード'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['商品コード'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['数量'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['単価'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['金額'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['消費税'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['種別'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['備考'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['更新フラグ'] . "</TD>"; $LIST .= "</TR>"; $COLUMN = $SQL->QueryEX( "" ); } $LIST .= "</TABLE>";
# ********************************************************** # 一覧表示 # ********************************************************** function DispList() { global $SQL,$LIST; $Query = "select * from 取引データ"; $COLUMN = $SQL->QueryEX( $Query ); $LIST = "<TABLE >"; $LIST .= "<TH>取引区分</TH>"; $LIST .= "<TH>取引日付</TH>"; $LIST .= "<TH>伝票番号</TH>"; $LIST .= "<TH>取引先コード</TH>"; $LIST .= "<TH>商品コード</TH>"; $LIST .= "<TH>数量</TH>"; $LIST .= "<TH>単価</TH>"; $LIST .= "<TH>金額</TH>"; $LIST .= "<TH>消費税</TH>"; $LIST .= "<TH>種別</TH>"; $LIST .= "<TH>備考</TH>"; $LIST .= "<TH>更新フラグ</TH>"; while ( $COLUMN ) { $LIST .= "<TR>"; $LIST .= "<TD>" . $COLUMN['取引区分'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['取引日付'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['伝票番号'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['取引先コード'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['商品コード'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['数量'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['単価'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['金額'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['消費税'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['種別'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['備考'] . "</TD>"; $LIST .= "<TD>" . $COLUMN['更新フラグ'] . "</TD>"; $LIST .= "</TR>"; $COLUMN = $SQL->QueryEX( "" ); } $LIST .= "</TABLE>"; }
# ********************************************************** # <TH> 挟み込み関数 # ********************************************************** function Th( $strValue ) { return "<TH>" . $strValue . "</TH>"; } # ********************************************************** # <TD> 挟み込み関数 # ********************************************************** function Td( $strValue ) { return "<TD>" . $strValue . "</TD>"; }
# ********************************************************** # 一覧表示 # ********************************************************** function DispList() { global $SQL,$LIST; $Query = "select * from 取引データ"; $COLUMN = $SQL->QueryEX( $Query ); $LIST = "<TABLE >"; $LIST .= Th( '取引区分' ); $LIST .= Th( '取引日付' ); $LIST .= Th( '伝票番号' ); $LIST .= Th( '取引先コード' ); $LIST .= Th( '商品コード' ); $LIST .= Th( '数量' ); $LIST .= Th( '単価' ); $LIST .= Th( '金額' ); $LIST .= Th( '消費税' ); $LIST .= Th( '種別' ); $LIST .= Th( '備考' ); $LIST .= Th( '更新フラグ' ); while ( $COLUMN ) { $LIST .= "<TR>"; $LIST .= Td( $COLUMN['取引区分'] ); $LIST .= Td( $COLUMN['取引日付'] ); $LIST .= Td( $COLUMN['伝票番号'] ); $LIST .= Td( $COLUMN['取引先コード'] ); $LIST .= Td( $COLUMN['商品コード'] ); $LIST .= Td( $COLUMN['数量'] ); $LIST .= Td( $COLUMN['単価'] ); $LIST .= Td( $COLUMN['金額'] ); $LIST .= Td( $COLUMN['消費税'] ); $LIST .= Td( $COLUMN['種別'] ); $LIST .= Td( $COLUMN['備考'] ); $LIST .= Td( $COLUMN['更新フラグ'] ); $LIST .= "</TR>"; $COLUMN = $SQL->QueryEX( "" ); } $LIST .= "</TABLE>"; }