約 181,968 件
https://w.atwiki.jp/ce00582/pages/395.html
?php require("calldata.php"); $sql = "SELECT * FROM pgdata05"; $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; } for ($n=1; $n 5501; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $m2[$year][$age] = $matrix[$n][3]; $f2[$year][$age] = $matrix[$n][4]; } $sql = "SELECT * FROM pdata12"; $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; } for ($n=1; $n 56; $n++) { $age =$matrix[$n][1]; $gamma[$age] = $matrix[$n][2]; $alpha[$age] = $matrix[$n][3]; $beta[$age] = $matrix[$n][4]; } $sql = "SELECT * FROM pdata11"; $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 46; $n++) { $age =$matrix[$n][1]; $theta[$age] = $matrix[$n][2]; } $sql = "SELECT * FROM pdata13"; $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 2201; $n++) { $age =$matrix[$n][1]; $car = $matrix[$n][2]; $startmis[$age][$car]= $matrix[$n][3]; } $sql = "SELECT * FROM pdata14"; $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 2201; $n++) { $age =$matrix[$n][1]; $car = $matrix[$n][2]; $startmos[$age][$car]= $matrix[$n][3]; } For ($year = 5;$year 100;$year++){ For ($age = 15;$age 69;$age++){ $byear=$year-$age+2000; $m2by[$byear][$age]=$m2[$year][$age]; } } For ($byear = 1941;$byear 1990;$byear++){ $startage =2005-$byear; For ($car=1;$car 50;$car++){ $mis[$byear][$startage][$car] = $startmis[$startage][$car]; $mos[$byear][$startage][$car] = $startmos[$startage][$car]; } For ($age = $startage+1;$age 65;$age++){ $z1 = (1-$gamma[$age-1]) * $m2by[$byear][$age-1]; $z2 = $m2by[$byear] [$age] - $z1; If ($z2 0) { $z2 = 0; } $z3=(1-$theta[$age])*$z2; $z4 = $theta[$age]*$z2; $mis[$byear][$age][1]=$z3; $z5 = 0; For ($car=1;$car 50;$car++){ $z5 = $z5 + $mos[$byear][$age-1][$car]; } If ($z5 == 0){ $z5 = 1; } $v = $z4 / $z5; If ($v 1){ $v = 1; } For ($car=2;$car 50;$car++){ $mis[$byear][$age][$car] = (1-$gamma[$age-1]) * $mis[$byear][$age-1][$car-1] + $v * $mos[$byear][$age-1][$car-1]; } For ($car=1;$car 50;$car++){ $mos[$byear][$age][$car] = ($gamma[$age-1] - $alpha[$age-1] - $beta[$age-1]) * $mis[$byear][$age-1][$car] + (1- $v) * $mos[$byear][$age-1][$car]; } } $z1 = 0; For ($car=1;$car 25;$car++){ $z1 = $z1 + $mis[$byear][64][$car]+$mos[$byear][64][$car]; } $mnew[$byear] = $z1; } $sql = "truncate pgdata12"; $exe= mysql_query($sql,$link); for ($byear=1941;$byear 1990;$byear++){ $x=$mnew[$byear]; $sql = "insert into pgdata12 values($byear,$x)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); ?
https://w.atwiki.jp/ce00582/pages/394.html
?php require("calldata.php"); $sql = "SELECT * FROM pgdata05"; $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; } for ($n=1; $n 5501; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $m2[$year][$age] = $matrix[$n][3]; $f2[$year][$age] = $matrix[$n][4]; } $sql = "SELECT * FROM pdata10"; $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; } for ($n=1; $n 56; $n++) { $age =$matrix[$n][1]; $gamma[$age] = $matrix[$n][2]; $alpha[$age] = $matrix[$n][3]; $beta[$age] = $matrix[$n][4]; } $sql = "SELECT * FROM pdata11"; $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 46; $n++) { $age =$matrix[$n][1]; $theta[$age] = $matrix[$n][2]; } $sql = "SELECT * FROM pdata13"; $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 2201; $n++) { $age =$matrix[$n][1]; $car = $matrix[$n][2]; $startmis[$age][$car]= $matrix[$n][3]; } $sql = "SELECT * FROM pdata14"; $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 2201; $n++) { $age =$matrix[$n][1]; $car = $matrix[$n][2]; $startmos[$age][$car]= $matrix[$n][3]; } For ($year = 5;$year 100;$year++){ For ($age = 15;$age 69;$age++){ $byear=$year-$age+2000; $m2by[$byear][$age]=$m2[$year][$age]; } } For ($byear = 1941;$byear 1990;$byear++){ $startage =2005-$byear; For ($car=1;$car 50;$car++){ $mis[$byear][$startage][$car] = $startmis[$startage][$car]; $mos[$byear][$startage][$car] = $startmos[$startage][$car]; } For ($age = $startage+1;$age 65;$age++){ $z1 = (1-$gamma[$age-1]) * $m2by[$byear][$age-1]; $z2 = $m2by[$byear] [$age] - $z1; If ($z2 0) { $z2 = 0; } $z3=(1-$theta[$age])*$z2; $z4 = $theta[$age]*$z2; $mis[$byear][$age][1]=$z3; $z5 = 0; For ($car=1;$car 50;$car++){ $z5 = $z5 + $mos[$byear][$age-1][$car]; } If ($z5 == 0){ $z5 = 1; } $v = $z4 / $z5; If ($v 1){ $v = 1; } For ($car=2;$car 50;$car++){ $mis[$byear][$age][$car] = (1-$gamma[$age-1]) * $mis[$byear][$age-1][$car-1] + $v * $mos[$byear][$age-1][$car-1]; } For ($car=1;$car 50;$car++){ $mos[$byear][$age][$car] = ($gamma[$age-1] - $alpha[$age-1] - $beta[$age-1]) * $mis[$byear][$age-1][$car] + (1- $v) * $mos[$byear][$age-1][$car]; } } $z1 = 0; For ($car=25;$car 50;$car++){ $z1 = $z1 + $mis[$byear][64][$car]+$mos[$byear][64][$car]; } $mnew[$byear] = $z1; } $sql = "truncate pgdata11"; $exe= mysql_query($sql,$link); for ($byear=1941;$byear 1990;$byear++){ $x=$mnew[$byear]; $sql = "insert into pgdata11 values($byear,$x)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); ?
https://w.atwiki.jp/ce00582/pages/3015.html
?php $handle = fopen("data68.csv", "r"); $n = 1; while (($csvdata = fgetcsv($handle,100000,",")) !== FALSE) { for ($c=0; $c 3; $c++) { $data[$n] = $csvdata[$c]; $n = $n +1; } } fclose($handle); require("calldata.php"); $sql = "truncate ben68"; $exe= mysql_query($sql,$link); $maxn=94*55+1; for ($n=1;$n $maxn;$n++){ $year=$data[3*$n-2]; $age=$data[3*$n-1]; $x=$data[3*$n]; $sql = "insert into ben68 values($year,$age,$x)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); print("68 有配偶率 計算終了"); ?
https://w.atwiki.jp/ce00582/pages/2220.html
?php $handle = fopen("data.csv", "r"); $n = 1; while (($csvdata = fgetcsv($handle, 1000, ",")) !== FALSE) { for ($c=0; $c 3; $c++) { $data[$n] = $csvdata[$c]; $n = $n +1; } } fclose($handle); require("calldata.php"); $sql = "truncate pdata01"; $exe= mysql_query($sql,$link); for ($age=1;$age 3;$age++){ $x=$data[age]; $y=$data[age]; $sql = "insert into pdata01 values($age,$x,$y)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); ?
https://w.atwiki.jp/ce00582/pages/2223.html
?php $handle = fopen("data04.csv", "r"); $n = 1; while (($csvdata = fgetcsv($handle,100000,",")) !== FALSE) { for ($c=0; $c 4; $c++) { $data[$n] = $csvdata[$c]; $n = $n +1; } } fclose($handle); require("calldata.php"); $sql = "truncate egdata04"; $exe= mysql_query($sql,$link); for ($n=1;$n 10001;$n++){ $year=$data[4*$n-3]; $age=$data[4*$n-2]; $x=$data[4*$n-1]; $y=$data[4*$n]; $sql = "insert into egdata04 values($year,$age,$x,$y)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); ?
https://w.atwiki.jp/ce00582/pages/2219.html
?php $handle = fopen("data.csv", "r"); $n = 1; while (($csvdata = fgetcsv($handle, 1000, ",")) !== FALSE) { for ($c=0; $c 3; $c++) { $data[$n] = $csvdata[$c]; $n = $n +1; } } fclose($handle); require("calldata.php"); $sql = "truncate pdata01"; $exe= mysql_query($sql,$link); for ($age=0;$age 100;$age++){ $x=$age; $y=$age; $sql = "insert into pdata01 values($age,$x,$y)"; $exe= mysql_query($sql,$link); } $close_flag = mysql_close($link); ?
https://w.atwiki.jp/ce00582/pages/372.html
?php require("calldata.php"); $sql = "SELECT * FROM pgdata02"; $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; } for ($n=1; $n 5501; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $mrou[$year][$age] = $matrix[$n][3]; $frou[$year][$age] = $matrix[$n][4]; } $sql = "SELECT * FROM pdata05"; $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; } for ($n=1; $n 5501; $n++) { $year =$matrix[$n][1]; $age =$matrix[$n][2]; $mhrate[$year][$age] = $matrix[$n][3]; $fhrate[$year][$age] = $matrix[$n][4]; } for ($year=0; $year 100; $year++) { for ($age=15; $age 70; $age++) { $mh[$year][$age]=$mhrate[$year][$age]*$mrou[$year][$age]; $fh[$year][$age]=$fhrate[$year][$age]*$frou[$year][$age]; } } $sql = "truncate pgdata03"; $exe= mysql_query($sql,$link); for ($year=0;$year 100;$year++){ for ($age=15;$age 70;$age++){ $x1=$mh[$year][$age]; $x2=$fh[$year][$age]; $sql = "insert into pgdata03 values($year,$age,$x1,$x2)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); $today = date("H i s"); print($today); print(","); for ($year=0; $year 99; $year++) { for ($age=20; $age 70; $age++) { print($mh[$year][$age]); print(","); print($fh[$year][$age]); print(","); } } $year=99; for ($age=20; $age 69; $age++) { print($mh[$year][$age]); print(","); print($fh[$year][$age]); print(","); } $age=69; print($mh[$year][$age]); print(","); print($fh[$year][$age]); ?
https://w.atwiki.jp/semi-blog/pages/16.html
■コメント一覧 table tr th 記事タイトル /th th 投稿者 /th th 日付 /th th 削除 /th /tr ?php $sql = "select * from comment order by id desc"; $data = mysql_query($sql, $connect); while ($record = mysql_fetch_array($data, MYSQL_NUM)) { print(" tr "); $id = $record[0]; $kiji_id = $record[1]; $namae = $record[3]; $date = $record[4]; $sql_kiji = "select * from kiji where id =" . $kiji_id; $data_kiji = mysql_query($sql_kiji, $connect); if ($record_kiji = mysql_fetch_array($data_kiji, MYSQL_NUM)) { $kenmei = $record_kiji[2]; } printf(" td a href=\"kanri_com_shosai.php#%d\" %s /td ", $id, $kenmei); printf(" td %s /td ", $namae); printf(" td %s /td ", $date); printf(" td center a href=\"kanri_com_sakujo.php?id=d\" ■ /a /center /td ", $id); printf(" /tr \n"); } mysql_close($connect); ? /table ※上記はあくまで一例。 ※親記事タイトルからコメントの詳細へリンクしている。 ■コメント削除 ?php $id = $_GET[ id ]; $sql = "delete from comment where id =" .$id; $data = mysql_query($sql, $connect); if ($data = False) { die("エラーが発生しました。"); } else { print(" p コメントを削除しました。 /p "); } mysql_close($connect); ? ■コメント詳細 ?php $sql_com = "select * from comment order by id desc"; $data_com = mysql_query($sql_com, $connect); while ($record_com = mysql_fetch_array($data_com, MYSQL_NUM)) { $com_id = $record_com[0]; $com_honbun = $record_com[2]; $com_namae = $record_com[3]; $com_date = $record_com[4]; ? a name=" ?php echo $com_id; ? " /a table tr th 投稿日 /th td ?php echo $com_date; ? /td /tr tr th 投稿者 /th td ?php echo $com_namae; ? /td /tr tr th colspan="2" 本文 /th /tr tr td colspan="2" ?php echo nl2br($com_honbun); ? /td /tr tr td colspan="2" center ?php printf(" a href=\"kanri_com_sakujo.php?id=%d\" 削除 /a ", $com_id); ? /center /td /tr /table ※コメントの詳細と削除用リンクを表示した一例。 ※特別いるものでもない(爆)
https://w.atwiki.jp/ma-100140/pages/53.html
コマンドライン版のPHPからunixODBCを使ってみよう。 メインの部分は以下 $conn = odbc_connect( "SQLServer", "uid", "pass"); #$sql = "select * from 社員コードテーブル ;"; $rs = odbc_exec($conn,$sql); if (odbc_error()) { echo odbc_errormsg($conn); exit(1) ; }//end of if 実行すると、なぜかデータを表示するけど、エラー セグメンテーション違反です なんだろう?ネットで探すと、ああ、ある。これだな。 http //d.hatena.ne.jp/root8537/20140916/1410880230 phpのソースの中の以下のソースみたい。 /ext/odbc/php_odbc.c #endif /* HAVE_ADABAS */ default rc = SQLColAttributes(result- stmt, (SQLUSMALLINT)(i+1), SQL_COLUMN_DISPLAY_SIZE, NULL, 0, NULL, displaysize); displaysize = displaysize = result- longreadlen ? displaysize result- longreadlen; /* Workaround for Oracle ODBC Driver bug (#50162) when fetching TIMESTAMP column */ if (result- values[i].coltype == SQL_TIMESTAMP) { displaysize += 3; } //result- values[i].value = (char *)emalloc(displaysize + 1); //rc = SQLBindCol(result- stmt, (SQLUSMALLINT)(i+1), SQL_C_CHAR, result- values[i].value, // displaysize + 1, result- values[i].vallen); //コメントアウトした部分を以下のように変更。displaysize + 1をdisplaysize + 4に変更。 result- values[i].value = (char *)emalloc(displaysize + 4); rc = SQLBindCol(result- stmt, (SQLUSMALLINT)(i+1), SQL_C_CHAR, result- values[i].value, displaysize + 4, result- values[i].vallen); break; } } return 1; } phpを再コンパイルして、make install でapacheを再起動。 もう一度実行してみる。 エラーはでなくなりました。 これで心配なく使えます。 unixODBCでDB2を使った時のnullの問題
https://w.atwiki.jp/ce00582/pages/2236.html
?php require("calldata.php"); $sql = "SELECT * FROM data68"; $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++) { $a[$n] =$matrix[$n][1]; $b[$n] = $matrix[$n][2]; } for ($year=5; $year 30; $year++) { for ($age=15; $age 70; $age++) { $n = floor($age / 5) - 2; $wife[$year][$age] = $a[$n] + ($b[$n] - $a[$n]) * ($year - 5) / 25; } } for ($year=30; $year 100; $year++) { for ($age=15; $age 70; $age++) { $n = floor($age / 5) - 2; $wife[$year][$age] = $b[$n]; } } $sql = "truncate eli68"; $exe= mysql_query($sql,$link); $maxn=94*55+1; for ($year=5; $year 100; $year++) { for ($age=15; $age 70; $age++) { $x=0.01*$wife[$year][$age]; $sql = "insert into eli68 values($year,$age,$x)"; $exe= mysql_query($sql,$link); } } $close_flag = mysql_close($link); print("68 有配偶率 計算終了"); ?