jQuery Grid Plugin - jqGrid - Topic: jqgrid php: how to report an error in dialog http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-php-how-to-report-an-error-in-dialog Simple:Press Version 5.7.5.3 kobruleht on jqgrid php: how to report an error in dialog http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-php-how-to-report-an-error-in-dialog#p23202 Discussion http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-php-how-to-report-an-error-in-dialog#p23202 You shoult set http response code to 4xx

In this case jqGrid reports error.

]]> Mon, 16 May 2011 12:20:54 +0300 galli2000 on jqgrid php: how to report an error in dialog http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-php-how-to-report-an-error-in-dialog#p22966 Discussion http://www.trirand.com/blog/?page_id=393/discussion/jqgrid-php-how-to-report-an-error-in-dialog#p22966 Hello,

I'm currently using the jqGrid php implementation with a manual transaction for adding a record in the grid.

E.g.:

$oper = jqGridUtils::GetParam('oper');
if ($oper == 'add') {

    $grid->trans = false;       // disable the transaction
    try {

        jqGridDB::beginTransaction($conn);

        $reference = jqGridUtils::GetParam('reference');
        $name = jqGridUtils::GetParam('name');
        $brand = jqGridUtils::GetParam('brand');
        $price = jqGridUtils::GetParam('price');
        $total_quantity_left = jqGridUtils::GetParam('total_quantity_left');
        $product = jqGridDB::prepare($conn,
                                     "INSERT INTO product (id, reference, name, brand, price, total_quantity_left) VALUES (NULL,?,?,?,?,?)",
                                     array($reference,
                                           $name,
                                           $brand,
                                           $price,
                                           $total_quantity_left,
                                           )
                                     );
        $stock1 = jqGridDB::prepare($conn,
                                    "INSERT INTO stock (id, shop_id, product_id, quantity) SELECT NULL, 1, (SELECT MAX(id) FROM product), ?",
                                    array(jqGridUtils::GetParam('quantity_shop1'))
                                    );
        $stock2 = jqGridDB::prepare($conn,
                                    "INSERT INTO stock (id, shop_id, product_id, quantity) SELECT NULL, 2, (SELECT MAX(id) FROM product), ?",
                                    array(jqGridUtils::GetParam('quantity_shop2'))
                                    );

        jqGridDB::execute($product);
        jqGridDB::execute($stock1);
        jqGridDB::execute($stock2);
        jqGridDB::commit($conn);

    } catch(Exception $e) {
        jqGridDB::rollBack($conn);
        echo $e->getMessage();
    }

}

This works fine so far.

The problem that I have now is that I want to inform the user if an error occurred during the transaction: typically I'd like to popup a error dialog showing the $e->getMessage(), or the cause of the error

Since the error is detected at the php level, how do I invoke a javascript code portion to achieve this (alert(...) or $.jqgrid.info_dialog(...) I guess)?

Thanks,

jerome

]]> Thu, 28 Apr 2011 17:37:05 +0300