The usage of the select_array():
$value = array( 'username', 'email', 'firstname' );
$result = DB::select_array( $value ) ->from( 'user' ) ->where( 'userid', '=', '1' ) ->execute() ->as_array();
print_r( $result[0] );
-
2Nice. Now, could you ask your question?Alexander Larikov– Alexander Larikov2013-08-27 05:22:57 +00:00Commented Aug 27, 2013 at 5:22
-
How can use alias in select_array()?mangala– mangala2013-08-27 05:34:52 +00:00Commented Aug 27, 2013 at 5:34
-
if you want to ask like The usage of select_array() in Query builder? then it means the name of fields that you want fetch from the query, and it is good practice to fetch the necessary field instead of all the fields.jogesh_pi– jogesh_pi2013-08-27 05:34:56 +00:00Commented Aug 27, 2013 at 5:34
-
Thanks. but i need all fields with other name. And the query value will passing in the controller itself. I need some suggestion.mangala– mangala2013-08-27 05:37:52 +00:00Commented Aug 27, 2013 at 5:37
Add a comment
|
1 Answer
Try with this might be it helps you.
$value = array(
array('username', 'uname'),
array('email', 'mail'),
array('firstname', 'fname')
);
DB::select_array( $value )
->from( 'user' )
->where( 'userid', '=', '1' )
->execute()
->as_array();
take a look on select_array
1 Comment
mangala
and we can try this one also. $value = array( 'username' =>array('username', 'uname'), 'email' => array('email', 'mail'), 'firstname' => array('firstname', 'fname') );