Welcome Guest, Not a member yet? Register   Sign In
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...
3,492 Views
7 Replies
07-05-2017, 05:53 PM
meSmashsta
    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...
1,511 Views
1 Replies
07-05-2017, 05:31 PM
meSmashsta
    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?
2,433 Views
1 Replies
07-05-2017, 07:55 AM
meSmashsta
    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?
2,433 Views
1 Replies
07-05-2017, 06:06 AM
meSmashsta
    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 ...
4,450 Views
3 Replies
07-02-2017, 02:17 PM
meSmashsta
    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...
4,450 Views
3 Replies
07-02-2017, 01:16 PM
meSmashsta
    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...
4,842 Views
6 Replies
03-19-2017, 01:38 AM
meSmashsta
    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, ...
4,842 Views
6 Replies
03-18-2017, 05:41 PM
meSmashsta
    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"; $...
4,842 Views
6 Replies
03-18-2017, 05:39 PM
meSmashsta
    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...
4,842 Views
6 Replies
03-18-2017, 10:43 AM
meSmashsta
    Thread: Query Builder "FROM * table AS a"
Post: RE: Query Builder "FROM * table AS a"

I got it working.
1,222 Views
1 Replies
03-18-2017, 10:41 AM
meSmashsta
    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...
1,222 Views
1 Replies
03-18-2017, 10:21 AM
meSmashsta
    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...
2,897 Views
3 Replies
01-17-2017, 11:16 PM
meSmashsta
    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...
2,675 Views
3 Replies
01-17-2017, 10:18 PM
meSmashsta
    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?
2,675 Views
3 Replies
01-17-2017, 09:17 PM
meSmashsta
    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.
7,563 Views
10 Replies
01-17-2017, 04:06 AM
meSmashsta
    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, ...
7,563 Views
10 Replies
01-16-2017, 02:20 AM
meSmashsta
    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? --...
7,563 Views
10 Replies
01-16-2017, 01:09 AM
meSmashsta
    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!!
7,563 Views
10 Replies
01-15-2017, 10:40 PM
meSmashsta
    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...
7,563 Views
10 Replies
01-15-2017, 10:16 PM
meSmashsta

Theme © iAndrew 2016 - Forum software by © MyBB