n数毎に（割る）

for ($i = 1; $i < 10; $i++) {
    echo $i;
    if ($i % 3 == 0) {
        echo "<br />";
    }
}

配列を文字列に

//状況：state
$q_cate = $dbh->query("SELECT cate_ID, cate_nam FROM org_category ORDER by cate_ID");
while($row_cate = $q_cate->fetch(PDO::FETCH_ASSOC)){
echo '
<label>
<input type="checkbox" name="cate_ID[]" value="'. $row_cate["cate_ID"] .'" />'. $row_cate["cate_nam"] .'
</label>&nbsp;';
if (($row_cate["cate_ID"] == 10)||($row_cate["cate_ID"] == 16)){echo '<br />';}
}

if (isset($_POST["state"])){
　$sct_state = $_POST["state"];
　$q_state = implode(",", $sct_state) . "\n"
}

ID検索

<input type="text" name="kokyaku_cd" size="8" id="kokyaku_cd" value="">
<a href="javascript:void(0)" onClick="window.open('select_org.php?a=000','search','width=640,height=480,left=1000,top=280');" class="ID_KENSAKU_BUTTON">組織ID検索</a>

戻るbutton

<input type="button" onClick="location.href=\''. $URL_self .'?'. $URL_Q .'\'" value="　戻る　" class="butt_sml">

PHP：PDO

　QUERY　

$sql = 'select id, name from shouhin';
$stmt = $dbh->query($sql);

while($result = $stmt->fetch(PDO::FETCH_ASSOC)){
   print($result['id']);
   print($result['name'].'<br>');
}


　INSERT　

$sql = 'insert into shouhin (id, name) values (?, ?)';
$stmt = $dbh->prepare($sql);
$flag = $stmt->execute(array(6, '扇風機'));


　UPDATE 　

$sql = 'update shouhin set name = ? where id = ?';
$stmt = $dbh->prepare($sql);
$flag = $stmt->execute(array('クーラー', 6));
 
 
　DELETE 　

$sql = 'delete from shouhin where id = :delete_id';
$stmt = $dbh->prepare($sql);
$flag = $stmt->execute(array(':delete_id' => 6));


　MAX　

$query="SELECT MAX(mag_num) as maxno FROM org_magazine WHERE org_id='$page_code_1'";
$stmt = $dbh->query($query);
$stmt->execute();
$result = $stmt->fetch( PDO::FETCH_ASSOC );
$new_mag_num = $result["maxno"]+1;


　COUNT　

$sql = 'SELECT * FROM テーブル名 '; $stmt = $dbh->query($sql); $stmt->execute(); $count=$stmt->rowCount();


　SUM　

□テーブルのa1の合計を求める。

$stmt = $pdo -> prepare("SELECT SUM(a1) as a1 FROM テーブル名 WHERE y=:y");
$stmt -> bindParam(':y', $y, PDO::PARAM_STR);
$stmt -> execute();
if($row = $stmt -> fetch()){
$kei = $row['a1'];
}

□複数フィールドa1,a2,a3の値を合計する。

$stmt = $pdo -> prepare("SELECT SUM(a1 + a2 + a3) as goukei FROM テーブル名 WHERE y=:y");
$stmt -> bindParam(':y', $y, PDO::PARAM_STR);
$stmt -> execute();
if($row = $stmt -> fetch()){
$kei = $row['goukei'];

}

$q_sumprice_all = "
SELECT SUM(pay_price) AS totPrice FROM org_casher_history";
$res2 = $dbh->prepare("$q_sumprice_all");
$res2->execute();
$row2 = $res2->fetch(PDO::FETCH_ASSOC);
echo number_format(intval($row2["totPrice"]))；

PHP：0埋&削除

// 0埋め5桁で表示する

echo sprintf("%05d", 123);     // "00123"

// 0埋め10桁で表示する

echo sprintf("%010d", 123);    // "0000000123"

// 0埋め10桁文字列を表示する

echo sprintf("%010s", "abc");  // "0000000abc"

// 指定しないとスペース埋めで表示する

echo sprintf("%10s", "abc");   // "       abc"

echo sprintf("%10d", 123);     // "       123"

// マイナスを指定すると左詰めで表示される

echo sprintf("%-10s", "abc");  // "abc       "

echo sprintf("%-10d", 123);    // "123       "

// 数字列の場合は文字列は表示できない

echo sprintf("%010d", "hoge"); // "0000000000"

PHP・MySQL 最小値・最大値

$dbh = new PDO($DSN , $DBUSER , $DBPASS);

$query="select min(id) as id_min, max(id) as id_max from test";

$stmt = $dbh->query($query);

$stmt->execute();

$result = $stmt->fetch( PDO::FETCH_ASSOC );

$min = $result['id_min'];

$max = $result['id_max'];