CodeIgniter Forums - Search Results

Pages (2): 1 2 Next »

Search Results

Thread: Possibly bug or incorrect code?
Post: RE: Possibly bug or incorrect code?

If it returns one row only then it must be because that the query only got one row, check the rows of your table and see if they are active, chances are there is only one row which has an active colum...

Thread: Showing cool charts
Post: Showing cool charts

I made a website that receives reports e.g a status of a machine, now I think it'll be a lot cooler to show some chart but I don't know what data should it presents. Should I use line chart and sho...

Thread: What is the best way to handle stored procedure?
Post: RE: What is the best way to handle stored procedur...

A link to an article or a video should be nice. Guys?

Thread: What is the best way to handle stored procedure?
Post: What is the best way to handle stored procedure?

Like affected tables or if something went wrong how would we handle those?

Thread: Database connection error when live on server (SOLVED)
Post: RE: Database connection error when live on server

Diederik Wrote: (07-02-2017, 01:51 PM) -- The error message is pretty clear, you do connect to the MySQL server but it says: Access denied for user 'usr'@'ip' (using password: YES). So either the ...

Thread: Database connection error when live on server (SOLVED)
Post: Database connection error when live on server (SOL...

I configure a VirtualBox VM for my server running UBUNTU (LAMP setup) and now after putting my project on the server it fails to connect to the database. Error PHP Code: -- mysqli::real_connect...

Thread: How to make this query a little bit more readable?
Post: RE: How to make this query a little bit more reada...

John_Betong Wrote: (03-18-2017, 07:39 PM) -- Try PHP heredoc Wrote: (03-18-2017, 05:39 PM) -- PHP Code: -- /* BEWARE ONLY LINEFEED AFTER FIRST ____TMP AND ; AFTER LAST ____TMP NO SPACES ALLOWED...

Thread: How to make this query a little bit more readable?
Post: RE: How to make this query a little bit more reada...

PaulD Wrote: (03-18-2017, 03:29 PM) -- If you are going to spread it out for readability, how about something like: PHP Code: -- return $this->db->from("reports AS a") ->select("a.id, ...

Thread: How to make this query a little bit more readable?
Post: RE: How to make this query a little bit more reada...

skunkbad Wrote: (03-18-2017, 11:06 AM) -- meSmashsta Wrote: (03-18-2017, 10:43 AM) -- PHP Code: -- $fname_format = "CONCAT(b.last_name, ', ', b.first_name, ' ', b.middle_name) AS full_name"; $...

Thread: How to make this query a little bit more readable?
Post: How to make this query a little bit more readable?

PHP Code: -- $fname_format = "CONCAT(b.last_name, ', ', b.first_name, ' ', b.middle_name) AS full_name"; $this->db->select("a.id, b.id AS employee_id, {$fname_format}, c.id AS machine_id, c.titl...

Thread: Query Builder "FROM * table AS a"
Post: RE: Query Builder "FROM * table AS a"

I got it working.

Thread: Query Builder "FROM * table AS a"
Post: Query Builder "FROM * table AS a"

How do you do that in code igniter? I have this Stored Procedure that I want to reproduce in Codeigniter's Query Builder. Thanks in advance guys! Code: -- DELIMITER // CREATE PROCEDURE get_repo...

Thread: Changing my hosts file is not working
Post: Changing my hosts file is not working

I'm trying to redirect bing.com to google.com, so when I enter bing.com on my browser address I should be redirected to google.com instead but it's just not working... I opened the hosts file using...

Thread: What is the smtp server Codeigniter uses?
Post: RE: What is the smtp server Codeigniter uses?

ragingTorch Wrote: (01-17-2017, 09:46 PM) -- Without any config it will use PHP mail function, check out below link for some setup instructions. https://www.codeigniter.com/user_guide/libraries/emai...

Thread: What is the smtp server Codeigniter uses?
Post: What is the smtp server Codeigniter uses?

I don't have a smtp server on my machine, but Codeigniter allows me to send emails, how is that possible? Does Codeigniter comes with an smtp server?

Thread: Model concept question
Post: RE: Model concept question

Thanks for your suggestions guys, but I'm already fine with my implementations plus I have a golden thumb to not touch the core apis.

Thread: Model concept question
Post: RE: Model concept question

venkat Wrote: (01-16-2017, 02:00 AM) -- meSmashsta Wrote: (01-16-2017, 01:09 AM) -- venkat Wrote: (01-16-2017, 12:40 AM) -- meSmashsta Wrote: (01-15-2017, 10:40 PM) -- venkat Wrote: (01-15-2017, ...

Thread: Model concept question
Post: RE: Model concept question

venkat Wrote: (01-16-2017, 12:40 AM) -- meSmashsta Wrote: (01-15-2017, 10:40 PM) -- venkat Wrote: (01-15-2017, 10:27 PM) -- Are you executing the same query in get_users() and get_user() method? --...

Thread: Model concept question
Post: RE: Model concept question

venkat Wrote: (01-15-2017, 10:27 PM) -- Are you executing the same query in get_users() and get_user() method? -- Yes!!

Thread: Model concept question
Post: Model concept question

I have two controllers that have two models which have the exact same method which performs the exact same queries. PHP Code: -- // model 1 $this->model1->get_users(); // model 2 $this->model...