DX推進をサポートする情報サイト
/* 書式設定 */
body {
font-family: sans-serif,メイリオ, Meiryo;
color:#2E2E2E;
font-size:12px;
line-height:24px;
}
input,textarea {
font-size:12px;
cursor:pointer;
}
td {
padding-left:3;
font-size:12px;
line-height: 24px;
}
<?php echo ""; ?>
<?php
//DBへの接続
$host = 'localhost'; //サーバ名
$user = 'root'; //ユーザ名
$pass = '********'; //DBのパスワード（自環境のパスワードに書き換えのこと）
$dbnm = 'sales'; //データベース名
$conn = mysqli_connect($host,$user,$pass,$dbnm) or die("er 接続できません");
//登録データの受信
$fnc = filter_input(INPUT_POST, 'fnc');
$set_customerCode = filter_input(INPUT_POST, 'set_customerCode');
$set_customerName = filter_input(INPUT_POST, 'set_customerName');
$set_zipcode = filter_input(INPUT_POST, 'set_zipcode');
$set_address1 = filter_input(INPUT_POST, 'set_address1');
$set_address2 = filter_input(INPUT_POST, 'set_address2');
//データ有無チェック
$mess = null; //$messのリセット（これを定義しないとwarning）
if(isset($fnc)){
if(empty($set_customerCode)){
$mess = '得意先コードが未登録です。';
if(empty($set_customerName)){
$mess = '得意先コードと得意先名が未登録です。';
}
}else{
if(empty($set_customerName)){
$mess = '得意先名が未登録です。';
}else{
$set_customerName = mb_convert_kana($set_customerName,'AKS'); //文字の全角化
$set_customerName = str_replace(' ','',$set_customerName); //空白をとる
$set_customerName = "'$set_customerName'"; //varcharの変数を"''"囲む
}
}
if(empty($set_zipcode)){
$set_zipcode = 'null'; //データがなければ'null'を代入
}else{
$set_zipcode = "'$set_zipcode'";
}
if(empty($set_address1)){
$set_address1 = 'null'; //データがなければ'null'を代入
}else{
$set_address1 = "'$set_address1'";
}
if(empty($set_address2)){
$set_address2 = 'null'; //データがなければ'null'を代入
}else{
$set_address2 = mysqli_real_escape_string($conn,$set_address2);
$set_address2 = "'$set_address2'";
}
}
//データ登録
if(empty($mess)){ //データチェックで問題がない（$messに何もデータがない）
if(isset($set_customerCode)){
$sql = "insert into customer_list
(
customerCode
,customerName
,zipcode
,address1
,address2
) values (
$set_customerCode
,'$set_customerName'
,$set_zipcode
,$set_address1
,$set_address2
) on duplicate key update
customerName = $set_customerName
,zipcode = $set_zipcode
,address1 = $set_address1
,address2 = $set_address2
;";
mysqli_query($conn,$sql) or die ("error $sql");
}
}
//検索データ受信
$search_customerName = filter_input(INPUT_POST, 'search_customerName');
$search_customerName = mb_convert_kana($search_customerName,'AK'); //文字の全角化
if(empty($search_customerName) or $search_customerName == '得意先名検索'){
$clrcus = "color:#a9a9a9;";
$search_customerName_display = '得意先名検索';
$where_customer = null;
}else{
$clrcus = null;
$search_customerName_display = $search_customerName;
$where_customer = "where customerName like '%$search_customerName%'";
}
//ソートデータ受信
$select_sort = filter_input(INPUT_POST, 'select_sort');
$sort_display = 'ソート';
$SORT = null;
switch($select_sort){
case 1:
$SORT = 'order by customerName';
$sort_display = '得意先名昇順';
break;
case 2:
$SORT = 'order by customerName desc';
$sort_display = '得意先名降順';
break;
}
echo <<<EOT
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="utf-8">
<link rel="stylesheet" href="/style.css" type="text/css">
<title>得意先一覧表</title>
<script type="text/javascript">
<!--
var ajax = new XMLHttpRequest();
function changeText1() {
ajax.onload = function() {
document.getElementById('textMessege1').value = ajax.responseText;
document.getElementById('textMessege1').style.color = '#404040';
}
ajax.open('GET','/ajax_text_null.php',true);
ajax.send(null);
}
-->
</script>
</head>
<body>
<table>
<tr>
<td width="100">得意先一覧表</td>
<form method="POST" action="{$_SERVER['PHP_SELF']}">
<td width="130px">
<input type="text" name="search_customerName" style="width:120px;height:20px;{$clrcus}"
value="{$search_customerName_display}" id="textMessege1" onClick="changeText1();">
</td>
<td width="60px">
<input type="submit" value="検索" style="width:100%;">
</td>
</form>
<form method="POST" action="{$_SERVER['PHP_SELF']}">
<td width="60px">
<input type="submit" value="クリア" style="width:60px;">
</td>
</form>
<td>{$mess}<td>
<form method="POST" action="{$_SERVER['PHP_SELF']}">
<td width="110px">
<select type="text" name="select_sort" onchange="submit(this.form)" style="width:100px;height:24px;">
<option value="{$select_sort}">{$sort_display}
<option value="1">得意先名昇順
<option value="2">得意先名降順
<option value="">解除
</select>
</td>
</form>
</tr>
</table>
<table bgcolor="#a9a9a9" cellspacing="1px" style="font-size:12px;" >
<tr bgcolor="#D3D3D3" style="height:24px;" align="center">
<td width="90">得意先コード</td>
<td width="200">得意先名</td>
<td width="70">郵便番号</td>
<td width="200">住所1</td>
<td width="200">住所2</td>
<td width="60">登録</td>
</tr>
<tr bgcolor="white" style="height:24px;" align="left">
<form method="POST" action="{$_SERVER['PHP_SELF']}">
<input type="hidden" name="fnc" value="1">
<td>
<input type="text" name="set_customerCode" style="width:98px;">
</td>
<td>
<input type="text" name="set_customerName" style="width:198px;">
</td>
<td>
<input type="text" name="set_zipcode" style="width:68px;">
</td>
<td>
<input type="text" name="set_address1" style="width:198px;">
</td>
<td>
<input type="text" name="set_address2" style="width:198px;">
</td>
<td>
<input type="submit" value="新規" style="width:60px;">
</td>
</form>
</tr>
EOT;
//DBからデータを抽出
$sql = "select customerCode,customerName,zipcode,address1,address2 from customer_list
$where_customer
$SORT;";
$res = mysqli_query($conn,$sql) or die("エラー $sql");
while($row = mysqli_fetch_array($res)){ //while(){ ～ }繰り返し処理
$customerCode = $row["customerCode"];
$customerName = $row["customerName"];
$zipcode = $row["zipcode"];
$address1 = $row["address1"];
$address2 = $row["address2"];
echo <<<EOT
<tr bgcolor="white" style="height:24px;" align="left">
<form method="POST" action="{$_SERVER['PHP_SELF']}">
<input type="hidden" name="fnc" value="1">
<input type="hidden" name="set_customerCode" value="{$customerCode}">
<td width="100">
{$customerCode}
</td>
<td>
<input type="text" name="set_customerName" style="width:198px;" value="{$customerName}">
</td>
<td>
<input type="text" name="set_zipcode" style="width:68px;" value="{$zipcode}">
</td>
<td>
<input type="text" name="set_address1" style="width:198px;" value="{$address1}">
</td>
<td>
<input type="text" name="set_address2" style="width:198px;" value="{$address2}">
</td>
<td>
<input type="submit" value="修正" style="width:60px;">
</td>
</form>
</tr>
EOT;
} //← 繰り返し処理の }
echo <<<EOT
</table>
</body>
</html>
EOT;
?>