[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");
}