Select AS Method

Select AS method is part of database class builder for selecting column data into a table with aliases.

Parameters

Update method has 3 required parameters that is column name and value, another parameters are optional. Here is the completed parameters can be used by where methods

$this->db->select_as(string $column_name_or_function, string $alias, bool $force_escape): dbObject

$column_name_or_function

Column Name can be single column name, or can be filled with wildcard "*", or can be filled with MySQL function.

$alias

Alias Aliased name of $column_name_or_function.

Example usage

Here is the examples using select method. See the first of this page for full example.

Basic Usage

For example we assumed want to add new data in blog table. First, in the model:

class Blog_Model extends SENE_Model{
  var $tbl = 'blog';
  var $tbl_as = 'b';
  public function __construct(){
	 parent::__construct();
  }
  public function countList(){
    $this->db->select_as("COUNT(*)","total",0);
    $this->db->from($this->tbl,$this->tbl_as);
    return $this->db->get_first();
  }
  public function translated($id){
    $this->db->select("id","blog_id",0);
    $this->db->select("title","judul",0);
    $this->db->select("content","isi",0);
    $this->db->from($this->tbl,$this->tbl_as);
    $this->db->where_as("id",$id);
    return $this->db->get_first();
  }
  public function allButModified($id){
    $this->db->select("$this->tbl_as.*, id","blog_id",0);
    $this->db->from($this->tbl,$this->tbl_as);
    $this->db->where_as("id",$id);
    return $this->db->get_first();
  }
}

at the controller, we assumed has file named blog.php

class Blog extends Sene_Controller{
  public function __construct(){
    parent::__construct();
    $this->load('blog_model','bm'); #class scope model
  }
  public function index(){
    $blogs = $this->bm->countList();
    $this->debug($blogs);
  }
  public function detail($id){
    $blog = $this->bm->translated($id);
    $this->debug($blog);
  }
  public function all($id){
    $blog = $this->bm->allButModified($id);
    $this->debug($blog);
  }
}