[vagrant@localhost ~]mysql -u root create database contact_php; grant all on contact_php.* to dbuser@localhost identified by 'hogehoge'; use contact_php create table entries ( id int not null auto_increment primary key, name varchar(255), email varchar(255), memo text, created datetime, modified datetime ); [vagrant@localhost ~]$ mysql -u dbuser -p contact_php
config.php
<?php define('DSN','mysql:host=localhost;dbname=contact_php'); define('DB_USER','dbuser'); define('DB_PASSWORD','hogehoge'); define('SITE_URL','http://192.168.33.10:8000/'); define('ADMIN_URL', SITE_URL.'admin/'); error_reporting(E_ALL & ~E_NOTICE); session_set_cookie_params(0, '/contacts_php'); [/php] function.php [php] <?php function connectDb(){ try { return new PDO(DSN, DB_USER, DB_PASSWORD); } catch (PDOException $e){ echo $e->getMessage(); exit; } } function h($s){ return htmlspecialchars($s, ENT_QUOTES, "UTF-8"); }