Jump to content


Ahmed Adebiyi Oladapo

Member Since 24 Aug 2016
Offline Last Active Sep 21 2016 02:52 AM
-----

Posts I've Made

In Topic: group by

27 August 2016 - 05:08 PM

Hi o_Odin,
you are cool man to have get this for us, with this I am UNSTOPPABLE with GC.

But how did you found this? :D

Once more thanks a lot

 

 

zrmba, you absolutely right! We can use Active Record before calling GC. Voila:

function help()
{
$crud = new grocery_CRUD();
$this->db
->select('sum(cost) as our_sum')
->group_by('type')
->order_by('our_sum', 'desc');
$crud
->set_table('help')
->columns('type', 'our_sum');
$output = $crud->render();
$this->load->view('WriteHereYourView.php', $output);
}

If we want to see a column like this, which is not in the table, we must specify it in

$crud->columns('type', 'our_sum');

I think it opens a LOT of opportunities :)

 

 

you guys have really helped me as i am totally new to PHP and grocery crud. 

Presently I am having a problem using the having clause. I will be glad if anyone in here can help me

 

 

SELECT Current_Country, count(Training_Status) as Total, Training_Status from Staff_data
GROUP by Current_Country, Training_Status, Service_Status
HAVING Training_Status in ('support staff', 'trained staff') 
AND Service_Status = 'serving'
 
My only problem is the having clause

In Topic: [Script] Login System

27 August 2016 - 04:27 PM

Hi! I'm adding a group management system to this script, so I think I'll do a video but not now.

Anyway you MUST read the GitHub page, 'cause it contains the exact example on how to implement it.

In a couple of words:

Thanks so very much...


In Topic: Exporting Mysql View results in Empty Records

24 August 2016 - 08:44 AM

Have you been able to get this resolved?


In Topic: [Script] Login System

24 August 2016 - 12:31 AM

I am so new to grocery crud, can you please do a short video on how to use this script?