How to Insert & Update & select record Using SugarBean

Question

how to insert,update and select record using sugarbean? please reply...

Parvezalam Kaliya · Accepted Answer

Hi Parvez . Use this &mdash; Insert &mdash; $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...... &mdash; Update &mdash; $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(); &mdash; Select &mdash; 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']; }