Accessing MySQL built-in functions using Codeigniter

Question

If I have a MySQL statement like this:

$sql="SELECT `name`, DATE(`time`), FROM `students` WHERE `id`='5'";

I am using CodeIgniter and trying to fetch the result in object format rather than array format (i.e. not using row_array())

$query=$db1->query($sql);
$row=$query->row();

I can get the name as

echo $row->name;

I cannot get the value of date with this method.

Any Ideas how I can get the date with this method, with something like:

echo $row->date;

?

Clemens · Accepted Answer · 2012-02-02 14:05:13Z

1

You should be able to use your own field names in SQL like so:

$sql="SELECT `name`, DATE(`time`) as mydate, FROM `students` WHERE `id`='5'";

and subsequently access it like

echo $row->mydate;

answered Feb 2, 2012 at 14:05

Clemens

1863 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Naveed Hasan Over a year ago

Thanks! It works. But can if I want to protect it, should I use it with quotes,double-quotes or backticks?

Clemens Over a year ago

If you look for a way to prevent bad userdata in your SQL queries look here stackoverflow.com/questions/3797613/… or google.

Michael Mior · Accepted Answer · 2012-02-02 14:04:10Z

1

If you want the column in the result set to be named date, then add AS date after the DATE expression. You'll then be able to access it as $row->date.

answered Feb 2, 2012 at 14:04

Michael Mior

28.9k10 gold badges95 silver badges118 bronze badges

Collectives™ on Stack Overflow

Accessing MySQL built-in functions using Codeigniter

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related