Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: Display Loading Image While Page Loads
Post: RE: Display Loading Image While Page Loads

kayinja.denis Wrote: (09-25-2018, 12:19 PM) -- Pertti Wrote: (09-18-2018, 01:32 AM) -- This is what is generally called N+1 problem, where you create 1 query for every N items you need. This is usua...
17,984 Views
19 Replies
09-27-2018, 12:09 AM
kayinja.denis
    Thread: Display Loading Image While Page Loads
Post: RE: Display Loading Image While Page Loads

Pertti Wrote: (09-18-2018, 01:32 AM) -- This is what is generally called N+1 problem, where you create 1 query for every N items you need. This is usually bad approach, as each DB query, no matter ho...
17,984 Views
19 Replies
09-25-2018, 12:19 PM
kayinja.denis
    Thread: Display Loading Image While Page Loads
Post: RE: Display Loading Image While Page Loads

php_rocs Wrote: (09-18-2018, 11:24 AM) -- @kayinja.denis, Basically, what I'm saying is taking the foreach loop and converting it into your database view.  Then when you call the database view it ...
17,984 Views
19 Replies
09-19-2018, 12:08 AM
kayinja.denis
    Thread: Display Loading Image While Page Loads
Post: RE: Display Loading Image While Page Loads

php_rocs Wrote: (09-18-2018, 05:39 AM) -- @kayinja.denis, ...OR...you could create a view that does the work for you and all you would have to do is call the view. -- Hello thanks but that quer...
17,984 Views
19 Replies
09-18-2018, 11:08 AM
kayinja.denis
    Thread: Display Loading Image While Page Loads
Post: RE: Display Loading Image While Page Loads

Pertti Wrote: (09-18-2018, 01:32 AM) -- This is what is generally called N+1 problem, where you create 1 query for every N items you need. This is usually bad approach, as each DB query, no matter ho...
17,984 Views
19 Replies
09-18-2018, 11:04 AM
kayinja.denis
    Thread: Display Loading Image While Page Loads
Post: RE: Display Loading Image While Page Loads

php_rocs Wrote: (09-17-2018, 07:39 AM) -- @kayinja.denis, Any reason why it takes so long to go through the calculations? -- yes, I've two loops one for students and the other is for subject, in or...
17,984 Views
19 Replies
09-17-2018, 10:46 PM
kayinja.denis
    Thread: Display Loading Image While Page Loads
Post: Display Loading Image While Page Loads

Hello, I've a challenge, I've a view which display student's report card but it takes long to go through all calculations  and returning the results. so i'd like to display Loading Image While...
17,984 Views
19 Replies
09-16-2018, 06:16 AM
kayinja.denis
    Thread: Open in a new window
Post: RE: Open in a new window

kierownik Wrote: (07-07-2018, 07:02 AM) -- where you make the link https://www.w3schools.com/tags/tryit.asp?filename=tryhtml_link_target -- seriously it doesn't work for me. I use js to send dat...
3,939 Views
4 Replies
07-09-2018, 03:00 PM
kayinja.denis
    Thread: Open in a new window
Post: RE: Open in a new window

kierownik Wrote: (07-07-2018, 03:48 AM) -- Use the following code in the view Code: -- target="_blank" -- -- hey  :-/ :-/ where do you place it..... please more info
3,939 Views
4 Replies
07-07-2018, 06:27 AM
kayinja.denis
    Thread: Open in a new window
Post: Open in a new window

Hello, I have this code but I'd like the view to open in a new window, I've tried various sources but failed to work PHP Code: -- public function getStudentReport()    {        $schoolorclass = $...
3,939 Views
4 Replies
07-07-2018, 01:02 AM
kayinja.denis
    Thread: Create a Cumulative Sum Column in codeigniter
Post: RE: Create a Cumulative Sum Column in codeigniter

kayinja.denis Wrote: (01-08-2018, 12:52 PM) -- I have this table pc_expenditure Code: -- MariaDB [paper2]> select * from pc_expenditure; -- +----------------------+-------------------------+-...
23,236 Views
4 Replies
01-10-2018, 02:44 AM
kayinja.denis
    Thread: Create a Cumulative Sum Column in codeigniter
Post: RE: Create a Cumulative Sum Column in codeigniter

jreklund Wrote: (01-08-2018, 01:45 PM) -- Do you need the individual ID? If not just run SUM on the whole thing. Code: -- SELECT SUM(amount_spent) AS cumulative_sum FROM pc_expenditure; -- If you r...
23,236 Views
4 Replies
01-08-2018, 02:17 PM
kayinja.denis
    Thread: Create a Cumulative Sum Column in codeigniter
Post: Create a Cumulative Sum Column in codeigniter

I have this table pc_expenditure Code: -- MariaDB [paper2]> select * from pc_expenditure; -- +----------------------+-------------------------+-------------------+---------------+-------------...
23,236 Views
4 Replies
01-08-2018, 12:52 PM
kayinja.denis
    Thread: Active tab or menu
Post: Active tab or menu

why is it when i select one tab even the other gets highlighted like it is in the image attached. I mean I've five menu/tabs; Fee type Expense Type Invoice Payment History Expense but when i select "E...
5,670 Views
3 Replies
07-25-2017, 07:52 AM
kayinja.denis
    Thread: how to use order by codeigniter
Post: RE: how to use order by codeigniter

Martin7483 Wrote: (06-21-2017, 05:33 AM) -- Why not just use the unique id of each record as the key for your array? PHP Code: -- $returnArray[$item->id] = strtolower($value) == 'obj' ? $item :...
26,078 Views
8 Replies
06-22-2017, 10:45 PM
kayinja.denis
    Thread: how to use order by codeigniter
Post: RE: how to use order by codeigniter

Martin7483 Wrote: (06-21-2017, 03:48 AM) -- The order in which you call the methods does not matter. Query Builder sorts them out for you and will place everything in the correct order. This is yo...
26,078 Views
8 Replies
06-21-2017, 04:17 AM
kayinja.denis
    Thread: how to use order by codeigniter
Post: RE: how to use order by codeigniter

InsiteFX Wrote: (06-21-2017, 03:19 AM) -- order_by should be after all where commands and should be the last command before retrieving the query ... -- thanks for reply, i changed my order  PHP ...
26,078 Views
8 Replies
06-21-2017, 04:06 AM
kayinja.denis
    Thread: how to use order by codeigniter
Post: how to use order by codeigniter

am trying to use order by but i don't get all the results in table. i have payment table  Code: -- payments={           paymentid|academicID| studentID| invoiceID| amount              1     |  ...
26,078 Views
8 Replies
06-21-2017, 02:58 AM
kayinja.denis
    Thread: Undefined valuable
Post: RE: Undefined valuable

Well guys thanks I got it to work changed this  PHP Code: -- public function get_school()     {         $this->db->select('*');         $this->db->from('setting');         return $this->db-...
14,265 Views
14 Replies
05-11-2017, 10:21 PM
kayinja.denis
    Thread: Undefined valuable
Post: RE: Undefined valuable

neuron Wrote: (05-09-2017, 01:07 AM) -- in get_school method you are returning object of row objects, you need to fetch only one row.  update your method: PHP Code: -- public function get_school()...
14,265 Views
14 Replies
05-11-2017, 06:29 AM
kayinja.denis

Theme © iAndrew 2016 - Forum software by © MyBB