Skip to content

Instantly share code, notes, and snippets.

func select(){
let sql2: String = "select * from koko"
let (resultSet, err) = SD.executeQuery(sql2)
if err != nil {
println("error")
@yuyutata
yuyutata / SwiftData.swift
Created July 22, 2015 15:49
Koko event with swift data
if let err = SD.createTable( "koko",
withColumnNamesAndTypes: [
"id2": .StringVal,
"web": .StringVal,
"toki": .DataVal,
]){
println("テーブルは既に存在しています!")
}else{
println("テーブルを作成しました!")
}
@yuyutata
yuyutata / json.php
Created June 20, 2015 09:28
json.php
<?php
mysql_connect('localhost', 'root', 'root') or die(mysql_error());
echo 'database connected';
mysql_select_db('shop_sample') or die(mysql_error());
echo '<br />Database shop_sample selected';
mysql_query('SET NAMES UTF8');
$name = $_POST['name'];
@yuyutata
yuyutata / json.php
Created June 20, 2015 09:27
json.php
<?php
mysql_connect('localhost', 'root', 'root') or die(mysql_error());
echo 'database connected';
mysql_select_db('shop_sample') or die(mysql_error());
echo '<br />Database shop_sample selected';
mysql_query('SET NAMES UTF8');
$name = $_POST['name'];
//Construct url object via string
var url = NSURL(string: "http://localhost/json/json_test.php")
let config = NSURLSessionConfiguration.defaultSessionConfiguration()
let session = NSURLSession(configuration: config)
var req = NSMutableURLRequest(URL: url!)
var json:NSData!
//今後動的にすることを想定
let hoge:String = "hogehogehoge"
@yuyutata
yuyutata / shop.php
Created June 18, 2015 14:56
shop.php
<?php
mysql_connect('localhost', 'root', 'root') or die(mysql_error());
echo 'database connected';
mysql_select_db('shop_sample') or die(mysql_error());
echo '<br />Database shop_sample selected';
mysql_query('SET NAMES UTF8');
$name = $_POST['name'];
@yuyutata
yuyutata / NSURLSession.swift
Created June 18, 2015 14:50
NSURLSession.swift
var url = NSURL(string: "http://localhost/json/php_MySQL.php")
let config = NSURLSessionConfiguration.defaultSessionConfiguration()
let session = NSURLSession(configuration: config)
var req = NSMutableURLRequest(URL: url!)
req.HTTPMethod = "POST"
req.HTTPBody = "id=13&name=Jack".dataUsingEncoding(NSUTF8StringEncoding)
var task = session.dataTaskWithRequest(req, completionHandler: {
(data, resp, err) in
println(resp.URL!)
println(NSString(data: data, encoding: NSUTF8StringEncoding))
@yuyutata
yuyutata / login_sample2.php
Created June 14, 2015 08:22
login sample
<?php
$myId = $_POST['my_id'];
$password = $_POST['password'];
$save = $_POST['save'];
//Cookieに保存
if ($save == 'on'){
setcookie('my_id', $myId, time() + 60 * 60 * 24 * 14);
$message = 'login info registered';
} else {
@yuyutata
yuyutata / sample.php
Created June 14, 2015 08:02
sample.php
<?php
if (isset($_COOKIE['my_id'])) {
$myId = $_COOKIE['my_id'];
} else {
$myId = '';
}
?>
<form action="cookie_sample2.php" method="post">
@yuyutata
yuyutata / NSDate.swift
Last active August 29, 2015 14:23
NSDate
var Interval = NSDate()
var Time = NSDate().timeIntervalSinceDate(Interval)
println(Time)