|
|
<?
# **********************************************************
# 外部ファイル
# **********************************************************
require_once( "common.php" );
require_once( "db.php" );
require_once( "model.php" );
# **********************************************************
# 定数定義
# **********************************************************
define( 'PASS_初期画面', 1 );
define( 'PASS_顧客入力', 2 );
define( 'PASS_確認画面', 3 );
define( 'PASS_保証人入力', 4 );
define( 'JUMP_顧客入力', 1 );
define( 'JUMP_保証人入力', 2 );
define( 'VIEW_顧客入力', 'view.php' );
define( 'VIEW_確認画面', 'view2.php' );
define( 'VIEW_最終画面', 'view3.php' );
define( 'VIEW_保証人入力', 'view4.php' );
$SQL = new DB( "localhost", "lightbox", "root" );
# **********************************************************
# 処理コントロール
# **********************************************************
switch ( $_SERVER['REQUEST_METHOD'] ) {
case 'GET':
break;
case 'POST':
switch( $_POST['GNO'] ) {
case PASS_顧客入力:
if ( !CheckData() ) {
$_POST['GNO'] = JUMP_顧客入力;
}
break;
case PASS_保証人入力:
if ( !CheckData2() ) {
$_POST['GNO'] = JUMP_保証人入力;
}
break;
case PASS_確認画面:
if ( !InsertData( $SQL ) ) {
$_POST['GNO'] = JUMP_顧客入力;
}
break;
}
break;
}
# **********************************************************
# ビュー
# **********************************************************
CreateInData( );
switch( $_POST['GNO'] ) {
case PASS_初期画面:
EditMain();
require_once( VIEW_顧客入力 );
break;
case PASS_顧客入力:
require_once( VIEW_保証人入力 );
break;
case PASS_保証人入力:
EditData2();
require_once( VIEW_確認画面 );
break;
case PASS_確認画面:
require_once( VIEW_最終画面 );
break;
default:
EditMain();
require_once( VIEW_顧客入力 );
break;
}
$SQL->Close();
# **********************************************************
# デバッグ
# **********************************************************
DispData();
?>
| |
|
|
|
|
# **********************************************************
# データベースへの更新
# **********************************************************
function InsertData( &$SQL ) {
global $ErrMessage;
$Query = "insert into 顧客マスタ";
$Query .= " values(";
$Query .= Ss( $_POST['In1Email'] );
$Query .= "," . Ss( $_POST['In1Name'] );
$Query .= "," . Ss( $_POST['In1Zip'] );
$Query .= "," . Ss( $_POST['In1Address'] );
$Query .= "," . $_POST['In1Sex'];
$Query .= "," . Ss( $_POST['In1Tel'] );
$Query .= "," . Ss( $_POST['In1Mobile'] );
$Query .= "," . Ss( $_POST['In1Pass1'] );
$Query .= ",";
$Query .= "'";
$Query .= $_POST['In1Yyyy'] . "/";
$Query .= $_POST['In1Mm'] . "/";
$Query .= $_POST['In1Dd'];
$Query .= "'";
$Query .= ")";
if ( !$SQL->Execute( $Query ) ) {
$ErrMessage = "登録に失敗しました";
return FALSE;
}
$Query = "insert into 保証人マスタ";
$Query .= " values(";
$Query .= Ss( $_POST['In1Email'] );
$Query .= "," . Ss( $_POST['In2Name'] );
$Query .= "," . Ss( $_POST['In2Zip'] );
$Query .= "," . Ss( $_POST['In2Address'] );
$Query .= "," . Ss( $_POST['In2Tel'] );
$Query .= "," . Ss( $_POST['In2Relation'] );
$Query .= ")";
if ( !$SQL->Execute( $Query ) ) {
$ErrMessage = "登録に失敗しました";
return FALSE;
}
return TRUE;
}
| |
|
|
入力データ引継ぎ用の埋め込みを view.php に追加 |
|