約 182,194 件
https://w.atwiki.jp/ce00582/pages/2334.html
?php require("calldata.php"); $sql = "SELECT * FROM plan"; $result = mysql_query($sql, $link); while( $row = mysql_fetch_row( $result ) ){ $plan = $row[0]; } $sql = "SELECT * FROM policy"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } $maxn=$n; for ($n=1;$n $maxn;$n++){ $num=$matrix[$n][1]; $px1[$num]=$matrix[$n][2]; $px2[$num]=$matrix[$n][3]; $px3[$num]=$matrix[$n][4]; } $p = $px1[$plan]; $g = $px2[$plan]; $r= $px3[$plan]; $sql = "SELECT * FROM eli98"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $mgen[$year][$age] = $matrix[$n][3]; $fgen[$year][$age] = $matrix[$n][4]; } $sql = "SELECT * FROM eli77"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $byear =$matrix[$n][1]; $jyo[$byear] = $matrix[$n][2]; } $price[10]=1; for ($year=11;$year 100;$year++){ $price[$year]=(1+$g)*$price[$year-1]; } for ($year=10;$year 100;$year++){ $e1=0; for ($age=20;$age 100;$age++){ $byear=$year-$age+2000; $syear=$byear; if ($syear 1950)$syear=1950; $e1=0; $e1=$e1+0.75*260*$price[$year]*2*25*$mgen[$year][$age]*$jyo[$byear]/1000; $e1=$e1+0.75*220*$price[$year]*1.3*25*$fgen[$year][$age]*$jyo[$byear]/1000; $gen[$year][$age]=$e1/10000; } } $sql = "truncate eli101"; $exe= mysql_query($sql,$link); for ($year=10;$year 100;$year++){ for ($age=20;$age 100;$age++){ $x=$gen[$year][$age]; $sql = "insert into eli101 values($year,$age,$x)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); print("101 世代基礎現役遺族 計算終了"); ?
https://w.atwiki.jp/ce00582/pages/2336.html
?php require("calldata.php"); $sql = "SELECT * FROM plan"; $result = mysql_query($sql, $link); while( $row = mysql_fetch_row( $result ) ){ $plan = $row[0]; } $sql = "SELECT * FROM policy"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } $maxn=$n; for ($n=1;$n $maxn;$n++){ $num=$matrix[$n][1]; $px1[$num]=$matrix[$n][2]; $px2[$num]=$matrix[$n][3]; $px3[$num]=$matrix[$n][4]; } $p = $px1[$plan]; $g = $px2[$plan]; $r= $px3[$plan]; $sql = "SELECT * FROM eli98"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $mgen[$year][$age] = $matrix[$n][3]; $fgen[$year][$age] = $matrix[$n][4]; } $sql = "SELECT * FROM eli77"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $byear =$matrix[$n][1]; $jyo[$byear] = $matrix[$n][2]; } $price[10]=1; for ($year=11;$year 100;$year++){ $price[$year]=(1+$g)*$price[$year-1]; } for ($year=10;$year 100;$year++){ $e1=0; for ($age=20;$age 100;$age++){ $byear=$year-$age+2000; $syear=$byear; if ($syear 1950)$syear=1950; $e1=0; $e1=$e1+0.75*260*$price[$year]*2*25*$mgen[$year][$age]*$jyo[$byear]/1000; $e1=$e1+0.75*220*$price[$year]*1.3*25*$fgen[$year][$age]*$jyo[$byear]/1000; $gen[$year][$age]=$e1/10000; } } $sql = "truncate eli99"; $exe= mysql_query($sql,$link); for ($year=10;$year 100;$year++){ for ($age=20;$age 100;$age++){ $x=$gen[$year][$age]; $sql = "insert into eli99 values($year,$age,$x)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); print("99 世代現役遺族 計算終了"); ?
https://w.atwiki.jp/ce00582/pages/2275.html
?php require("calldata.php"); $sql = "SELECT * FROM data22"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $car =$matrix[$n][2]; $mint[$age][$car] = $matrix[$n][3]; } for ($age = 15;$age 70;$age++){ for ($car = 1;$car 51;$car++){ $mint[$age][$car]=$mint[$age][$car]/10000; } } $sql = "truncate eli22"; $exe= mysql_query($sql,$link); for ($age = 15;$age 70;$age++){ for ($car = 1;$car 51;$car++){ $x=$mint[$age][$car]; $sql = "insert into eli22 values($age,$car,$x)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); print("22 女子待期者 計算終了"); ?
https://w.atwiki.jp/ce00582/pages/461.html
?php require("calldata.php"); $sql = "SELECT * FROM ordata17"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $n=$n+1; } for ($n=1; $n 141; $n++) { $no=$matrix[$n][1]; $m=$matrix[$n][2]; $mbra[$no][$m]=$matrix[$n][3]; } $sql = "SELECT * FROM ordata18"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $n=$n+1; } for ($n=1; $n 141; $n++) { $no=$matrix[$n][1]; $m=$matrix[$n][2]; $fbra[$no][$m]=$matrix[$n][3]; } for ($age=0; $age 100; $age++) { $no=floor($age/5)+1; $startm[$age]=($mbra[$no][4]+$mbra[$no][5])/50; } for ($age=0; $age 100; $age++) { $no=floor($age/5)+1; $startf[$age]=($fbra[$no][4]+$fbra[$no][5])/50; } $sql = "truncate pdata18"; $exe= mysql_query($sql,$link); for ($age=0; $age 100; $age++) { $x=$startm[$age]; $y=$startf[$age]; $sql = "insert into pdata18 values($age,$x,$y)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); ?
https://w.atwiki.jp/ce00582/pages/2248.html
?php require("calldata.php"); $sql = "SELECT * FROM eli10"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $m2[$year][$age] = $matrix[$n][3]; $f2[$year][$age] = $matrix[$n][4]; } $sql = "SELECT * FROM data0902"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $zm2[$year][$age] = $matrix[$n][3]; $zf2[$year][$age] = $matrix[$n][4]; } $sql = "SELECT * FROM data0903"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $matrix[$n][4] =$row[3]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $zm3[$year][$age] = $matrix[$n][3]; $zf3[$year][$age] = $matrix[$n][4]; } for ($age=20;$age 60;$age++){ $rate[$age]=$zf3[8][$age]/$zm2[8][$age]; } for ($year=10;$year 100;$year++){ $ch = 1.3; If ($year 30)$ch = 1.3 + 0.18 * ($year - 30) / 25; for ($age=20;$age 60;$age++){ $f3[$year][$age]=$rate[$age]*$m2[$year][$age]/$ch; } } $sql = "truncate eli49"; $exe= mysql_query($sql,$link); for ($year=10;$year 100;$year++){ for ($age=20;$age 60;$age++){ $x=$f3[$year][$age]; $sql = "insert into eli49 values($year,$age,$x)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); print("49 厚生3号被保険者 計算終了"); ?
https://w.atwiki.jp/semi-blog/pages/17.html
■投稿コメント数 ?php $sql_comment = "select * from comment where kiji_id = " . $id; $sql_data = mysql_query($sql_comment, $connect); if ($sql_data) { $num_comment = mysql_num_rows($sql_data); } else { $num_comment = 0; } ? ?php printf(" a href=\"blog_shosai.php?id=%d#comment\" コメント(%d) /a ", $id, $num_comment); ? ※対象の記事に対して何件のコメントが投稿されているか表示。
https://w.atwiki.jp/line2emyu/pages/53.html
メモに戻る L2J_JPのHPからダウンロード 31031.htmをC \l2j-server\gameserver\data\html\merchantに移動 gm_shop.sqlをC \l2j-server\gameserver\sqlに移動 EasyPHPとNabicat起動 Nabicat内のspawnlistテーブルを右クリック「テーブルを削除」 l2jdbを右クリック「バッチファイルを実行する」 C \l2j-server\gameserver\sql\spawnlist.sqlを選ぶ l2jdbを右クリック「バッチファイルを実行する」 C \l2j-server\gameserver\sql\gm_shopを選ぶ
https://w.atwiki.jp/ce00582/pages/2303.html
?php require("calldata.php"); $sql = "SELECT * FROM data82"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $car = $matrix[$n][2]; $wage[$age][$car]= $matrix[$n][3]; } For ($age = 15;$age 70;$age++){ For ($car = 1;$car 50;$car++){ $mwage[$age][$car]=$wage[$age][$car]/(240*10000); } } $sql = "truncate eli82"; $exe= mysql_query($sql,$link); For ($age = 15;$age 70;$age++){ For ($car = 1;$car 50;$car++){ $x=$mwage[$age][$car]; $sql = "insert into eli82 values($age,$car,$x)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); print("82 男子被保険者報酬 計算終了"); ?
https://w.atwiki.jp/ce00582/pages/2308.html
?php require("calldata.php"); $sql = "SELECT * FROM data83"; $result = mysql_query($sql, $link); $n=1; while( $row = mysql_fetch_row( $result ) ){ $matrix[$n][1] = $row[0]; $matrix[$n][2] =$row[1]; $matrix[$n][3] =$row[2]; $n=$n+1; } $maxn=$n; for ($n=1; $n $maxn; $n++) { $age =$matrix[$n][1]; $car = $matrix[$n][2]; $wage[$age][$car]= $matrix[$n][3]; } For ($age = 15;$age 70;$age++){ For ($car = 1;$car 50;$car++){ $fwage[$age][$car]=$wage[$age][$car]/(210*10000); } } $sql = "truncate eli83"; $exe= mysql_query($sql,$link); For ($age = 15;$age 70;$age++){ For ($car = 1;$car 50;$car++){ $x=$fwage[$age][$car]; $sql = "insert into eli83 values($age,$car,$x)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); print("83 女子被保険者報酬 計算終了"); ?
https://w.atwiki.jp/tak_is/pages/15.html
Knowledge オブジェクト情報取得 オブジェクト間の依存情報取得 外部キーの情報を一覧で取得 tnsnames.oraの場所を探す Oracleが応答しない(Oracle11g) 異なるバージョンでのデータ移行 表領域の使用率確認・拡張 パスワードを無期限にする(11g) SQLパフォーマンス調査 インポート・エクスポートまとめ リスナーが起動しない(タイムアウトする) 小ネタ集 オラクルエラー対処法 障害発生時にすること ORA-12514(リスナー接続エラー) ORA-12516(Oracle接続不可) ORA-12528(Oracle起動エラー) ORA-00257(アーカイブログエラー) PL/SQL プログラミング SQLPlusでストアドを実行する ストアドからファイル出力する Triggerで自分自身のテーブルを参照する 全オブジェクト削除SQL その他 Oracleライセンス SQL*Plusを便利に使う フォルダ内のSQLファイルの一括実行 LinuxでOracleメモ