fuelPHP/データベース操作

fuel/app/config/development/db.php
データベース名変更

fuel/app/classes/controller/origin.php
class Controller_Origin extends Controller{
	public function action_insert()
	{
		DB::insert("users")->set(array(
			"username" => "aaa",
			"password" => "aaaa",
			"role" => "aa"
		))->execute();
	}
}

fuel/app/classes/controller/origin.php
class Controller_Origin extends Controller{
	public function action_select()
	{
		$result = DB::select("*")
		->from("users")
		->where("role", "=", "cc")
		->order_by("id", "desc")
		->execute()
		->as_array();
		
		echo "pre>";
		print_r($result);
	}
}
	

fuel/app/classes/controller/origin.php
class Controller_Origin extends Controller{
	public function action_update()
	{
		$result = DB::update("users")
		->set(array(
			"username" => "abc",
			"password" => "abcd",
			"role" => "xyz"
		))
		->where("id", "=", "1")
		->execute()
		->as_array();
	}
}
	

fuel/app/classes/controller/origin.php
class Controller_Origin extends Controller{
	public function action_update()
	{
		$result = DB::delete("users")
		->where("id", "=", "1")
		->execute()
		->as_array();
	}
}