Pass sql as string to controller in codeigniter

Question

In my controller I have:

$query = $this->db->query("select * from table");

I want to have a file myquery.sql in which the only contents of that file are:

select * from table

And so I can do something like:

$query = $this->db->query(myquery.sql);

What is the right syntax to do this?

As for why, the query I'm using is 700 lines and I didn't want it to make my otherwise concise controller difficult to navigate through. I wanted to use a stored procedure but couldn't get it to work and read somewhere that stored procedures don't play nice with Code Igniter, but maybe one day I'll try again. — David
– David, Commented Jul 19, 2016 at 2:32

FirstOne · Accepted Answer · 2016-07-19 00:56:40Z

2

You should be able to achieve that using:

$query = $this->db->query(file_get_contents('myquery.sql'));

2 Comments

David Over a year ago

Thanks guys, that got it to work. It literally required the full path all the way down to the drive letter though, which is annoying...why can't I just use the filename like I can with an include statement?

FirstOne Over a year ago

@DavidBrooks TBH, I don't know how to answer that path problem. Maybe codeigniter is messing things up, but I really don't know.

Collectives™ on Stack Overflow

Pass sql as string to controller in codeigniter

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related