:
function postadd()
{

:
:
//insert in another table
      $qry = "INSERT INTO va_locked_slot (va_emp_id,slot_number,capacity_req_date,capacity_req_tm_fr,booking_mode
                                    ,created_by,created_date, request_id
                                   )";
      $qry .= " VALUES ('$operator', '$slot_number','$capacity_req_date','$capacity_req_tm_fr', '$booking_mode'
                            ,'$userid', '$created_date', '$request_id'
                            )"  ;

            $recs = $db->getrows($qry); >>>>> how to catch constraint error here

/*
table stru for refernece
DROP TABLE IF EXISTS va_locked_slot;
CREATE TABLE va_locked_slot
(
va_emp_id INT(11) NOT NULL,
slot_number INT(11) NOT NULL,             -- this can be dropped suggested by dhananjay acc primary key will change
capacity_req_tm_fr VARCHAR(10) NOT NULL,  -- (x 11:15, 11:30 etc) addn suggested by dhananjay acc primary key will change
capacity_req_date VARCHAR(20) NOT NULL,
booking_mode VARCHAR(10) ,               -- addn suggested by dhananjay
created_date VARCHAR(20),
created_by INT(11),
request_id INT(11),
PRIMARY KEY(va_emp_id,capacity_req_tm_fr,capacity_req_date)
);
*/



}

      $db = &atkGetDb();

    //30.Sep.2017 refer atk/db/classatkdb.inc
      $haltonerror_org = $db->m_haltonerror;
      $db->m_haltonerror = false; //#IMP#otherwise Uniq Key Constraint error is thrown ut with abort
       :
       :
      $flag = true;
      //-- 1st qry
      $qry = "INSERT INTO qry (material_type) VALUES ('rollbacktest')";
      $result = $db->getrows($qry);
      //if ($db->hasError() && $db->getErrorType() != "user")
      if ($db->hasError())
        {
          //triggerError($record, null, '', $db->getErrorMsg());
          $msg1="Qry1False".$db->getErrorMsg();
          $flag = false;  //mark as error
        }

      //-- 2nd qry
          :
          :

    $db->m_haltonerror = $haltonerror_org; //#IMP# RESTORE orgval otherwise Uniq Key Constraint error is thrown ut with abort