Ejemplos de DAL_managePerson_vocationaltraining::getLastPerson_vocationaltrainingId en PHP

Ejemplo n.º 1

Archivo: DAL_managePerson_vocationaltraining.php Proyecto: pathumego/easykarma

 public static function addPerson_vocationaltraining($obj_Person_vocationaltraining)
 {
     $db = config::dbconfig();
     $obj_retresult = new returnResult();
     $obj_Person_vocationaltraining->VocationalTrainId = DAL_managePerson_vocationaltraining::getLastPerson_vocationaltrainingId() + 1;
     $sql = "INSERT INTO tbl_person_vocationaltraining (VocationalTrainId,FieldName,CourseName,InstituteId,StartDate,EndDate,CertificateType,PersonId) \n\t\tVALUES (" . common::noSqlInject($obj_Person_vocationaltraining->VocationalTrainId) . "," . "'" . common::noSqlInject($obj_Person_vocationaltraining->FieldName) . "'" . "," . "'" . common::noSqlInject($obj_Person_vocationaltraining->CourseName) . "'" . "," . common::noSqlInject($obj_Person_vocationaltraining->InstituteId) . "," . "'" . common::noSqlInject($obj_Person_vocationaltraining->StartDate) . "'" . "," . "'" . common::noSqlInject($obj_Person_vocationaltraining->EndDate) . "'" . "," . "'" . common::noSqlInject($obj_Person_vocationaltraining->CertificateType) . "'" . "," . common::noSqlInject($obj_Person_vocationaltraining->PersonId) . ");";
     $rs = mysql_query($sql);
     if (mysql_affected_rows() > 0) {
         $obj_retresult->type = 1;
         $obj_retresult->msg = "success";
         $obj_retresult->data = $obj_Person_vocationaltraining;
     } else {
         $obj_retresult->type = 0;
         $obj_retresult->msg = "failed";
     }
     return $obj_retresult;
 }