How to Insert & Update & select record Using SugarBean

Hi Parvez . Use this

— Insert —

$bean = BeanFactory::newBean("Cases");

$bean->name = 'Mehul Bhandari';

$bean->description = $ticket_description;

$bean->status = $ticket_status;

$bean->where_did_you_find_us_c = $ticket_where_did_you_find_us;

$bean->priority = $ticket_priority;

$bean->product_c = $product;

$sugar_case_id = $bean->save(); // Here getting generated case id......

— Update —

$bean = BeanFactory::getBean("Cases",$sugar_case_id); // Case id that you want to change

$bean->name = 'Mehul S Bhandari - Change';

$bean->description = $ticket_description;

$bean->status = $ticket_status;

$bean->where_did_you_find_us_c = $ticket_where_did_you_find_us;

$bean->priority = $ticket_priority;

$bean->product_c = $product;

$bean->save();

— Select —

Select Statement based on ID

    $chkbean = BeanFactory::newBean("Cases");

    $searcharray = array('id'=>$ID_XYZ);

    $chkbeanarray = $chkbean->retrieve_by_string_fields($searcharray);

    if(count($chkbeanarray)>0)

    {

        $chkbeandata = $chkbeanarray->fetched_row;

        $id = $chkbeandata['id'];

        $name = $chkbeandata['name'];

    }

Yes its Works for me ..

Thank you ...