v 1.3.3 grocery CRUD - an automatic Codeigniter CRUD

[eluser]web-johnny[/eluser]
[quote author="tieungao" date="1304512259"]hi web-johny,

When u done the future features of grocery?[/quote]

This week probably I will have ready a new version with a file upoader and relation 1-n .

[eluser]web-johnny[/eluser]
Hi guys . I've just updated grocery crud . The new version is now v.1.0.3 and I add two basic features.
1- Uploading file
2- The Relation 1-n for tables.
You can see the new features at http://www.web-and-development.com/groce...w/examples .

[eluser]tieungao[/eluser]
This is great!

Thank you this is what im waiting for.

Can u make an example how to put grocery togetther with HMVC?

[eluser]web-johnny[/eluser]
[quote author="tieungao" date="1304808711"]This is great!

Thank you this is what im waiting for.

Can u make an example how to put grocery togetther with HMVC?[/quote]

I think Sajjad has your answer in the post http://ellislab.com/forums/viewthread/186696/

[eluser]Unknown[/eluser]
Hi,

I'm a new in codeigniter. Today I install Grocery_CRUD and i have a problem with somethink like that:

Code:

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

SHOW COLUMNS FROM

Filename: /home/fresh4u/public_html/mobile/third_party/grocery_crud/models/grocery_model.php

Line Number: 226

My serwer use php5 datebase is in mysql5 what can by wrong?

[eluser]web-johnny[/eluser]
You didnt' insert the set_table . Please read the installation for codeigniter first. You can add the example database to test if it works and you have to run the controller examples .

[eluser]web-johnny[/eluser]
grocery CRUD is now on his own domain : www.grocerycrud.com

[eluser]darrentaytay[/eluser]
Good work mate, really nice piece of kit.

[eluser]web-johnny[/eluser]
Thanks I really appreciate it.

[eluser]timj[/eluser]
Hello, I've asked this question of the developer by email and the answer I received made no sense to me, so I am sending it to a wider list in the hopes someone can explain this to me.

I want to build a few callbacks that build a query thus: 'SELECT from database WHERE client_id = $uri->segment(3)';

If I do this:

Code:

$crud->set_table('orders');
$crud->where('client_id = 1');

I get a list of records in the orders table that are related only to client_id 1, so I know this product can work. This is exactly what I want, except with '1' as a variable. When I offer a variable, this product tells me it doesn't know what to do with the data.

I was offered this as a possible solution:

Code:

function manage_orders($state = 'list', $id)
{
    if( ($state == 'list' || $state == 'ajax_list') )
    {
        $session = $this->session->userdata("client_id");
        if(!empty($id))
        {
            $this->session->set_userdata(array("client_id" => $id));
        }
        elseif(empty($id) && !empty($session))
        {
            $id = $session;
        }
        if(!empty($id))
            $this->grocery_crud->where('client_id',$id);
        }
...
}

However, this "solution" throws a lot of errors and doesn't produce a variable this product can understand:

Fatal error: Uncaught exception 'Exception' with message 'The state is unknown , I don't know what I will do with your data!' in /home/public_html/application/third_party/grocery_crud/libraries/grocery_crud.php:2398 Stack trace: #0 /home/public_html/application/controllers/test.php(105): grocery_CRUD->render() #1 /home/public_html/system/core/CodeIgniter.php(339): Test->manage_orders('2') #2 /home/public_html/index.php(201): require_once('/home/...') #3 {main} thrown in /home/public_html/application/third_party/grocery_crud/libraries/grocery_crud.php on line 2398

It seems to me the thing I want to do is what EVERY PERSON who uses this product at any length would ultimately want to do, quickly build nested CRUD tables.

If someone can help me I'd appreciate it. And I would suggest that this simple functionality be built in as an option in future releases.