\u6570\u636e\u5e93\u914d\u7f6e<\/p>\n
\u5728\u914d\u7f6e\u6587\u4ef6\u5939\u91cc\u65b0\u589e\u4e00\u4e2adatabase.php\u6587\u4ef6<\/p>\n
<?php defined(‘SYSPATH’) OR die(‘No direct script access.’);<\/p>\n
return array(
\n‘default’ => array(
\n‘type’ => ‘MySQLi’,
\n‘connection’ => array(
\n‘hostname’ => ‘localhost’,
\n‘database’ => ‘kohana’,
\n‘username’ => ‘root’,
\n‘password’ => ‘password’,
\n‘persistent’ => FALSE,
\n‘ssl’ => NULL,
\n),
\n‘table_prefix’ => ‘db_’,
\n‘charset’ => ‘utf8’,
\n‘caching’ => FALSE,
\n),
\n);<\/p><\/blockquote>\n<\/p>\n
\u6709\u4e24\u79cd\u6570\u636e\u5e93\u5b9e\u4f8b<\/p>\n
1.DB\u6570\u636e\u5e93\u5b9e\u4f8b<\/p>\n
2. database\u6570\u636e\u5e93\u5b9e\u4f8b<\/p>\n
\u5176\u4e2dDB\u662f\u5bf9database\u7684\u518d\u6b21\u5c01\u88c5<\/p>\n
\u4e0b\u9762\u63cf\u8ff0\u4e24\u4e2a\u6570\u636e\u5e93\u5b9e\u4f8b\u7684\u4f7f\u7528<\/p>\n
Database<\/p>\n
\u53d6\u5f97\u65b9\u6cd5:<\/p>\n
\n\n\n<?php\r\n$database=Database::instance();\/\/\u53ef\u4ee5\u53d6\u5f97database\u5b9e\u4f8b\r\n#\u4f8b\u5916\u5728\u6a21\u578b\u4e2d,dababase\u505a\u4e3a\u6a21\u578b\u6784\u9020\u51fd\u6570\u7684\u552f\u4e00\u4e00\u4e2a\u4f20\u9012\u53c2\u6570,\u5e76\u5728\u6a21\u578b\u4e2d\u6709$this->_db\u5c5e\u6027\r\n$database=$this->_db;<\/pre>\n<\/blockquote>\n<\/div>\n\u4f7f\u7528\u65b9\u6cd5:(\u5047\u8bbe\u5728\u6a21\u578b\u4e2d)<\/pre>\n\n\u63d2\u5165\u6570\u636e:\r\n\r\n<?php\r\n$sql=\"INSERT INTO `kohana`.`user` (`name` ,`age` )VALUES ( 'test', '1'), ( 'test2', '2')\";\r\n$dat=$this->_db->query(Database::INSERT,$sql,false<\/a>);<\/pre>\n# return \u8fd4\u56de\u7684\u4e24\u4e2a\u503c\u4e2d,\u7b2c\u4e00\u4e2a\u662f\u81ea\u52a8\u589e\u957f\u7684ID,\u5982\u679c\u6709\u7684\u8bdd,\u7b2c\u4e8c\u662f\u5f71\u54cd\u7684\u884c\u6570<\/pre>\n<\/div>\n<\/div>\n<\/div>\n\u66f4\u65b0\u6570\u636e:<\/div>\n\n<?php\r\n$sql=\"UPDATE `ko_users` SET `user_name` = 'test111q1' \";\r\n$dat=$this->_db->query(Database::UPDATE,$sql,false<\/a>);\r\n#return \u8fd4\u56de\u5f71\u54cd\u884c\u6570\r\n\r\n\u5220\u9664\u6570\u636e:\r\n<?php $sql=\"DELETE FROM `kohana`.`user` WHERE `user`.`id` = 1\"; $dat=$this->_db->query(Database::DELETE,$sql,false<\/a>); #return \u8fd4\u56de\u5f71\u54cd\u884c\u6570<\/pre>\n<\/div>\n\u67e5\u8be2\u6570\u636e:<\/pre>\n\n<?php\r\n$sql=\"select * from ko_com_var\";\r\n$res=$this->_db->query(Database::SELECT<\/a>,$sql,false<\/a>);\r\n#\u5f97\u5230\u6240\u6709\u67e5\u8be2\u6570\u636e\r\n$res->as_array();\r\n#\u5f97\u5230\u4e00\u6761\u67e5\u8be2\u7ed3\u679c\r\n$res->offsetGet(0);\r\n#\u53d6\u5f97\u7279\u5b9a\u8bb0\u5f55\u7684\u6307\u5b9a\u5b57\u6bb5\u503c\r\n$res->get(\"name\");\r\n#\u79fb\u52a8\u6307\u9488\u5e76\u53d6\u5f97\u6307\u5b9a\u5b57\u6bb5\r\n$res->next<\/a>()->get(\"name\");\r\n$res->prev<\/a>()->get(\"name\");\r\n#\u8ba1\u7b97\u53d6\u5f97\u7ed3\u679c\u603b\u6570\r\n$res->count<\/a>();\r\n#\u8fd8\u6709\u5176\u4ed6\u65b9\u6cd5\u4e0d\u5728\u4e00\u4e00\u7f57\u5217,\u8bf7\u67e5\u770b\u624b\u518c<\/pre>\n<\/div>\n\n\u5176\u4ed6\u5e38\u7528\u5e2e\u52a9\u51fd\u6570:<\/div>\n\n<?php\r\n#\u8fc7\u6ee4\u5b57\u7b26\u4e32\u7528,\u4e0d\u77e5\u9053\u4e3a\u4ec0\u4e48\u653e\u5230\u8fd9\u4e2a\u5355\u4f8b\u4e2d,\u8be5\u662f\u516c\u7528\u624d\u5bf9~,\u6216\u8bb8\u662f\u6bcf\u4e2d\u6570\u636e\u5e93\u7684\u8fc7\u6ee4\u7684\u4e1c\u897f\u6709\u5dee\u522b\u5427\r\n$str=$this->_db->escape(\"ddddd ddd\");\r\n#\u8868\u524d\u7f00,\u8fd9\u4e2a\u5e38\u7528~\r\n$str=$this->_db->table_prefix();\r\n#\u8fd8\u6709\u5176\u4ed6\u67e5\u770b\u5e2e\u52a9,\u4e0d\u4ecb\u7ecd\u54af<\/pre>\n<\/div>\n\nDB\u5b9e\u4f8b\u4f7f\u7528(\u4ee5\u4e0b\u6f14\u793a\u5728Kohana\u73af\u5883\u5373\u53ef)<\/div>\n\u6709\u4e24\u79cd\u65b9\u5f0f:<\/div>\n\u7b2c\u4e00\u79cd:<\/div>\n\u4ee5\u4e0b\u7684execute(); \u6709\u4e00\u4e2a\u6570\u636e\u5e93\u9002\u914d\u5668\u53c2\u6570,\u5f53\u6709\u591a\u4e2a\u6570\u636e\u8fde\u63a5\u7684\u65f6\u5019\u6307\u5b9a\u64cd\u4f5c\u90a3\u4e2a\u6570\u636e\u5e93,\u5c31\u662f\u914d\u7f6e\u6587\u4ef6\u7684\u90a3\u4e2aKEY\u503c<\/div>\n\u63d2\u5165\u6570\u636e:<\/div>\n\n<?php\r\n$sql=\"INSERT INTO `kohana`.`user` (`name` ,`age` )VALUES ( 'test', '1'), ( 'test2', '2')\";\r\n#\u5176\u5b9e\u4e5f\u53ef\u4ee5\u7528Database::UPDATE,\u7ed3\u679c\u53ea\u8fd4\u56de\u5f71\u54cd\u884c\u6570,\u4e0d\u8fc7\u8fd8\u662f\u6309\u89c4\u8303\u597d.\u5475\u5475~,\u4e0a\u8ff0Database\u4e5f\u53ef\u4ee5\r\n$dat=DB::query(Database::INSERT,$sql);\r\n$row=$dat->execute();\r\n#\u8fd4\u56de\u7684\u4e24\u4e2a\u503c\u4e2d,\u7b2c\u4e00\u4e2a\u662f\u81ea\u52a8\u589e\u957f\u7684ID,\u5982\u679c\u6709\u7684\u8bdd,\u7b2c\u4e8c\u662f\u5f71\u54cd\u7684\u884c\u6570\r\nKohana::debug($row);<\/pre>\n<\/div>\n\n\u6570\u636e\u66f4\u65b0:<\/div>\n\n<?php\r\n$sql=\"UPDATE `user` SET `name` = 'test2' WHERE `user`.`id` =1 \";\r\n$dat=DB::query(Database::UPDATE,$sql);\r\n$row=$dat->execute();\r\n#\u8fd4\u56de\u5f71\u54cd\u884c\u6570\r\necho<\/a> Kohana::debug($row);<\/pre>\n\u6570\u636e\u5220\u9664:<\/pre>\n\n<?php\r\n$sql=\"DELETE FROM `kohana`.`user` WHERE `user`.`id` = 1\";\r\n$dat=DB::query(Database::DELETE,$sql);\r\n$row=$dat->execute();\r\n#\u8fd4\u56de\u5f71\u54cd\u884c\u6570\r\necho<\/a> Kohana::debug($row);<\/pre>\n<\/div>\n\u6570\u636e\u67e5\u8be2:<\/p><\/div>\n
\n<?php\r\n$sql=\"select * from user\";\r\n$dat=DB::query(Database::SELECT<\/a>,$sql);\r\n#\u6307\u5b9a\u6570\u636e\u5e93\u53d6\u6570\u636e\r\n$row=$dat->execute($database)->offsetGet(0);\r\n#\u9ed8\u8ba4\u6570\u636e\u5e93\u53d6\u6570\u636e,\u548c\u4e0a\u9762\u7684Database\u4e00\u6837,\u90fd\u662f\u8fd4\u56deDatabase_Result_Cached\u5bf9\u8c61,\u5b9e\u73b0\u4e86\u8fed\u4ee3\u5668\u6a21\u5f0f\r\n$rus=$dat->execute();\r\n#\u53d6\u5f97\u90e8\u5206\u7ed3\u679c\r\n$row=$rus->offsetGet(0);\r\n#\u53d6\u5f97\u6240\u6709\u7ed3\u679c\r\n$allrow=$rus->as_array();\r\n#\u53d6\u5f97\u7279\u5b9a\u8bb0\u5f55\u7684\u6307\u5b9a\u5b57\u6bb5\u503c\r\n$no1name=$rus->get(\"name\");\r\n#\u79fb\u52a8\u6570\u7ec4\u6307\u9488,\u5e76\u53d6\u6307\u5b9a\u5b57\u6bb5\u503c\r\n$no2name=$rus->next<\/a>()->get(\"name\");\r\n#\u5f53\u524d\u6307\u9488\r\necho<\/a> $rus->key<\/a>();\r\n#\u79fb\u52a8\u6570\u7ec4\u6307\u9488,\u5e76\u53d6\u6307\u5b9a\u5b57\u6bb5\u503c\r\necho<\/a> $no1name=$rus->prev<\/a>()->get('name');\r\n#\u53d6\u884c\u6570\r\necho<\/a> $rus->count<\/a>();<\/pre>\n<\/div>\n\n\u7b2c\u4e8c\u79cd:(\u5b98\u7f51\u6587\u6863\u79f0\u4e4b\u4e3a\u67e5\u8be2\u5668\u6a21\u5f0f,\u4e0d\u597d\u7528,\u5475\u5475,\u7b80\u5355\u7684\u53ef\u4ee5\u7528\u4e0b)<\/div>\n\u63d2\u5165\u6570\u636e:<\/div>\n\n<?php\r\n$query = DB::insert('user', array<\/a>('user', 'age'))\r\n\t\t->values(array<\/a>('test1', '11'));\r\n$query->execute();\r\n#\u8fd4\u56de\u548c\u4e0a\u9762\u4e00\u6837<\/pre>\n<\/div>\n<\/p>\n
\u66f4\u65b0\u6570\u636e:<\/div>\n\n<?php\r\n$query = DB::update('user')\r\n\t\t->set(array<\/a>('age' => '100'))\r\n\t\t->where('user', '=', 'test1');\r\n$query->execute();\r\n#\u8fd4\u56de\u548c\u4e0a\u9762\u4e00\u6837<\/pre>\n<\/div>\n\u5220\u9664\u6570\u636e:<\/p>\n
\n<?php\r\n$query = DB::delete('user')\r\n\t\t->where('age', 'IN', array<\/a>('100', '11'));\r\n$query->execute();\r\n#\u8fd4\u56de\u548c\u4e0a\u9762\u4e00\u6837<\/pre>\n<\/div>\n\u67e5\u8be2\u6570\u636e:<\/p>\n
\n<?php\r\n$query = DB::select<\/a>()->from('user')->where(\"id\",\"=\",\"1\");\r\n$res=$query->execute();\r\n#\u548c\u4e0a\u9762\u4e00\u6837,$res\u662fDatabase_Result_Cached\u5bf9\u8c61\r\n$res->as_array();\r\n#\u5176\u4ed6\u65b9\u6cd5\u4e0d\u6f14\u793a\u4e86~<\/pre>\n<\/div>\n<\/p>\n
\u9644\u6ce8:<\/pre>\n\u6570\u636e\u7ed1\u5b9a,\u6284\u5b98\u65b9\u5b9e\u4f8b\u4e00\u4e2a,\u8be5\u5f88\u7b80\u5355,\u6bd4\u8f83\u5bb9\u6613\u770b\u61c2<\/pre>\n\n<?php\r\n$query = DB::query(Database::INSERT, 'INSERT INTO users (username, password) VALUES (:user, :pass)') \r\n->bind<\/a>(':user', $username) \r\n->bind<\/a>(':pass', $password); \r\nforeach<\/a> ($new_users as<\/a> $username => $password){ \r\n\t$query->execute();\r\n}<\/pre>\n<\/div>\n","protected":false},"excerpt":{"rendered":"