未分類 – ページ 67

2015/01/012014/12/30

2015年元旦

あけましておめでとうございます
2015年初投稿です

抱負

今年はましなプログラマになる

なにかの言語を深く知って、テストコードを書いてCIする

自分のサービスをリリースする

でいきたいと思います
今年もよろしくお願いします

2014/12/312014/12/30

2014年大晦日

本日は2014年、大晦日なので今年のまとめを

記事投稿数

このブログはWordpressを使っているのでデータベース調べました

合計：215
1月：3
2月：4
3月：12
4月：9
5月：14
6月：4
7月：13
8月：34
9月：30
10月：31
11月：30
12月：31

今日の分は足しました
地味に7月21日から毎日1件以上の投稿が続いています！

調べたPHPはこれ
データベースユーザー名(user)、パスワード(password)、データベース名(database)は変えてます

<?php
$link = mysqli_connect('localhost','user','password','database') or die('db connection error' . mysqli_error($link));

$q = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-01-01'";
$result = mysqli_query($link, $q);
$row = mysqli_fetch_array($result);
echo '合計：', $row[0], PHP_EOL;

$q = array();
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-01-01' and post_date < '2014-02-01';";
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-02-01' and post_date < '2014-03-01';";
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-03-01' and post_date < '2014-04-01';";
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-04-01' and post_date < '2014-05-01';";
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-05-01' and post_date < '2014-06-01';";
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-06-01' and post_date < '2014-07-01';";
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-07-01' and post_date < '2014-08-01';";
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-08-01' and post_date < '2014-09-01';";
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-09-01' and post_date < '2014-10-01';";
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-10-01' and post_date < '2014-11-01';";
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-11-01' and post_date < '2014-12-01';";
$q[] = "select count(*) from wp_posts where post_status = 'publish' and post_type = 'post' and post_date >= '2014-12-01' and post_date < '2015-01-01';";
foreach ($q as $i => $sql) {
  $result = mysqli_query($link, $sql);
  $row = mysqli_fetch_array($result);
  echo $i+1, '月：', $row[0], PHP_EOL;
}

5分で書いたPHPなのでこんなもんで