Skip to content

Instantly share code, notes, and snippets.

View KimiyukiYamauchi's full-sized avatar

Kimiyuki Yamauchi KimiyukiYamauchi

42 followers · 20 following
View GitHub Profile
@KimiyukiYamauchi
KimiyukiYamauchi / emp_sal_graph.php
Created February 6, 2014 08:48
<?php
// 出力形式、文字コードの指定
header('Content-type: text/html; charset=UTF-8');
// 必要パッケージの読み込み
require_once('jpgraph/jpgraph.php');
require_once('jpgraph/jpgraph_bar.php');
// データの設定
$datax=array();
@KimiyukiYamauchi
KimiyukiYamauchi / common2.php
Created December 20, 2013 12:04
<?php
// 日本語の文字コード設定などを予め定義
mb_internal_encoding("UTF-8");
mb_language("ja");
setlocale(LC_ALL,"ja_JP.UTF-8");
// csv
$bbs_file = "bbs.csv";
// エスケープを行うラップ関数を定義
function h($str) {
@KimiyukiYamauchi
KimiyukiYamauchi / index.php
Created December 20, 2013 12:01
<?php include("common2.php"); ?>
<?php include("formhelpers.php"); ?>
<!DOCTYPE html>
<html>
<head>
<title>ひよこ掲示板 </title>
<meta charset="utf8">
<style>
body {
background-color: #f0e6ac;
@KimiyukiYamauchi
KimiyukiYamauchi / create_bbs_tbl.sql
Created December 20, 2013 11:58
drop table if exists bbs;
create table bbs
(post_id int primary key,
name varchar(20) ,
comment varchar(400),
time datetime
) engine=innodb;
@KimiyukiYamauchi
KimiyukiYamauchi / select_emp2_pdo.php
Created December 20, 2013 04:40
<?php
// Load the form helper functions.
require 'formhelpers.php';
// 部門番号の選択
$deptno_choices = array();
$dsn = 'mysql:dbname=testphp;host=localhost';
$user = 'test';
$password = 'pass';
try{
@KimiyukiYamauchi
KimiyukiYamauchi / select_emp_pdo.php
Created December 20, 2013 04:36
<?php
// Load the form helper functions.
require 'formhelpers.php';
// 部門番号の選択
$deptno_choices = array();
$dsn = 'mysql:dbname=testphp;host=localhost';
$user = 'test';
$password = 'pass';
@KimiyukiYamauchi
KimiyukiYamauchi / select_emp2_mysqli.php
Created December 20, 2013 02:26
<?php
// Load the form helper functions.
require 'formhelpers.php';
$db = mysqli_connect('localhost','test','pass','testphp');
if (! $db) { die("Can't connect: " . mysqli_connect_error()); }
// 部門番号の選択
$deptno_choices = array();
$sql = 'select deptno from departments order by deptno';
@KimiyukiYamauchi
KimiyukiYamauchi / select_emp_mysqli.php
Created December 20, 2013 02:21
<?php
// Load the form helper functions.
require 'formhelpers.php';
$db = mysqli_connect('localhost','test','pass','testphp');
if (! $db) { die("Can't connect: " . mysqli_connect_error()); }
// 部門番号の選択
$deptno_choices = array();
@KimiyukiYamauchi
KimiyukiYamauchi / select_emp2.php
Last active December 31, 2015 05:19
<?php
// Load PEAR MDB2
require 'MDB2.php';
// Load the form helper functions.
require 'formhelpers.php';
require 'connect_mysql.php';
// Connect to the database
@KimiyukiYamauchi
KimiyukiYamauchi / select_emp.php
Created December 13, 2013 04:27
<?php
// Load PEAR MDB2
require 'MDB2.php';
// Load the form helper functions.
require 'formhelpers.php';
require 'connect_mysql.php';
// Connect to the database