· 7 years ago · Jan 08, 2019, 01:58 PM
1<?php
2error_reporting(E_ALL);
3ini_set('display_errors', 'on');
4date_default_timezone_set('UTC');
5
6echo "mysql<br />";
7$config['db']['hostname'] = 'localhost';
8$config['db']['username'] = 'root';
9$config['db']['password'] = 'tau7110';
10$config['db']['database'] = 'test';
11
12$mysqli = new mysqli($config['db']['hostname'], $config['db']['username'], $config['db']['password']);
13$mysqli->set_charset('utf8');
14$mysqli->select_db($config['db']['database']);
15
16/* $sql = "CREATE TABLE IF NOT EXISTS `testTable` (
17 `id` int(11) NOT NULL AUTO_INCREMENT,
18 `point` bigint(20) NOT NULL DEFAULT '0',
19 PRIMARY KEY (`id`)
20 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT";
21$mysqli->query($sql); */
22
23/* $sql = "insert into `testTable` set point = 1";
24$mysqli->query($sql); */
25
26$sql = "select * from `testTable`";
27$query = $mysqli->query($sql);
28
29echo '<xmp>';
30while($row = $query->fetch_array(MYSQLI_ASSOC)) {
31 print_r($row);
32}
33echo '</xmp>';
34
35echo "Memcache<br />";
36
37$mc = new Memcache();
38$mc->addServer("localhost", 11211);
39
40$mc->set("foo", "Hello!");
41$mc->set("bar", "Memcached...");
42
43$arr = array(
44 $mc->get("foo"),
45 $mc->get("bar")
46);
47echo '<xmp>';
48print_r($arr);
49echo '</xmp>';
50
51echo "Redis<br />";
52require_once("Redis.php");
53//Redis 서버 ì—°ê²°(호스트 IP, PORT, [ì ‘ì†ë¹„밀번호])<p></p>
54
55//ì ‘ì†ë¹„밀번호가 ì—†ì„ ê²½ìš°ëŠ” ìƒëžµ
56$r = new Redis("127.0.0.1", 6379, "tau7110");
57$r->execute("zadd", "rank_class", 100, "lovedev");
58$r->execute("zadd", "rank_class", 101, "kim");
59$result = $r->execute("zrange", "rank_class", 0, -1);
60echo "<xmp>";
61print_r($result);
62$foo = $r->execute("ping");
63print_r($foo);
64$foo = $r->execute("sadd", "test", "hello");
65print_r($foo);
66echo '</xmp>';
67//anything what you want command ~~~ blah~~blah~~
68
69//must close connection(잊지 마세요~)
70$r->close();
71exit;
72phpinfo();
73?>