Skip to content

Instantly share code, notes, and snippets.

View cnevinc's full-sized avatar

Nevin cnevinc

37 followers · 27 following
View GitHub Profile
@cnevinc
cnevinc / runHello
Created January 6, 2014 14:36
d:
cd D:\DEV\Google\
"google_appengine\dev_appserver.py" HelloGAEProject/
@cnevinc
cnevinc / helloworld.php
Created January 6, 2014 16:51
<?php
echo 'Hello, World!';
?>
@cnevinc
cnevinc / app.yaml
Created January 6, 2014 16:52
application: helloworld
version: 1
runtime: php
api_version: 1
handlers:
- url: /.*
script: helloworld.php
@cnevinc
cnevinc / helloworld.php
Last active January 2, 2016 10:59
<?php
require_once 'google/appengine/api/users/UserService.php';
use google\appengine\api\users\User;
use google\appengine\api\users\UserService;
$user = UserService::getCurrentUser(); // 如果使用者已經登入，此處的$user不為null
if ($user===null) {
header('Location: ' . // 如果未登入，將使用者導向登入頁面，
@cnevinc
cnevinc / app.yaml
Last active January 2, 2016 10:59
application: helloworld
version: 1
runtime: php
api_version: 1
handlers:
- url: /stylesheets #當GAE收到http request帶有"stylesheets"字樣的URL時
static_dir: stylesheets #,會去"stylesheets"這個資料夾找相對應的資源顯示給使用者
- url: /.* #除此之外，其他的request
@cnevinc
cnevinc / helloworld.php
Created January 7, 2014 03:16
<head>
<link type="text/css" rel="stylesheet" href="/stylesheets/main.css" />
</head>
@cnevinc
cnevinc / mysql_connect.php
Last active January 2, 2016 11:19
// Production on Google Cloud SQL
$db = new PDO('mysql:unix_socket=/cloudsql/regal-center-453:guestbook;dbname=guestbook;charset=utf8','root', ''); // 不用指定密碼因為已經給該project/application權限
// Development on Local Machine
$db = new PDO('mysql:host=localhost;dbname=guestbook'); // 我沒指定帳號密碼因為我GRANT ALL ON *.* to '@locahost'
@cnevinc
cnevinc / uploadApp.bat
Created January 8, 2014 02:31
"google_appengine/appcfg.py" update HelloGAEProject
@cnevinc
cnevinc / helloworld3.php
Last active January 2, 2016 18:19
<?php
require_once 'google/appengine/api/users/UserService.php';
use google\appengine\api\users\User;
use google\appengine\api\users\UserService;
$user = UserService::getCurrentUser(); // 如果使用者已經登入，此處的$user不為null
if ($user===null) {
header('Location: ' . // 如果未登入，將使用者導向登入頁面，
@cnevinc
cnevinc / schema.sql
Created January 9, 2014 21:48
CREATE DATABASE `guestbook` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `guestbook`;
CREATE TABLE `message` (
`id` int(10) NOT NULL auto_increment,
`message` text NOT NULL,
`user` varchar(50) NOT NULL,
PRIMARY KEY (`id`)