3v4l.org

run code in 300+ PHP versions simultaneously
<?php define("STATE_ID","3"); define("DATA_CACHE_TIMEOUT","9999"); /** * Class to import data from SECC into SRDB * *@author Rochak Chauhan */ class ImportController extends Controller { public function actionIndex() { $t1=date("r"); $ts1=microtime(true); $tot=0; echo "\r\n<p> ******** Started at $t1 ******** </p>\r\n"; $connection = Yii::app()->db; $command = $connection->createCommand('SELECT * FROM seccsirsa LIMIT 0,10'); $rows = $command->queryAll(); //executes the SQL statement and returns the first row of the //$res = array(); foreach ($rows as $row) { extract($row); echo "\r\n<p>Full Name: $Name_en ($Name_h) </p>\r\n"; $SRDB_District_ID=$this->getDistrictId($District); } $t2=date("r"); $ts2=microtime(true); $diff=($ts2-$ts1); echo "\r\n<p> ******** Stopped at $t2 ******** </p>\r\n"; echo "\r\n<p> ******** Total Execution Time: $diff microseconds ******** </p>\r\n"; echo "\r\n<p> ******** Total Records Imported: $tot ******** </p>\r\n"; } /** *Function to get District ID from District Name * *@param string $District *@param int */ private function getDistrictId($District){ //Select if record exists $District=trim(strtolower($District)); $connection = Yii::app()->db; $connection->active=true; $command = $connection->createCommand("SELECT LR_ID FROM tblLandRegion WHERE lower(LR_Name) = '$District' AND LR_Type='District' "); $row = $command->queryRow(); //If no record found if($row===false){ //Insert record in DB (Master Table) $command = $connection->createCommand("INSERT INTO tblLandRegion (LR_Name,LR_Type) VALUES('$District', 'District') "); $rowCount=$command->execute(); if($rowCount==0){ die("\r\n<hr />FATAL ERROR 0x01: Failed to insert $District in Master table :: ".__FILE__." at line nunber ".__LINE__); } else{ //Cache and Return the PK/ID of the new inserted record. $row = Yii::app()->cache->get('cache_'.$District."_".STATE_ID); if (($row === false) || row($res)) { $District=trim(strtolower($District)); $connection = Yii::app()->db; $command = $connection->createCommand("SELECT LR_ID FROM tblLandRegion WHERE lower(LR_Name) = '$District' AND LR_Type='District' ORDER BY LR_ID DESC"); $row = $command->queryRow(); Yii::app()->cache->set('cache_'.$District."_".STATE_ID, $row, DATA_CACHE_TIMEOUT); } $District_ID=$row['LR_ID']; //Insert record in DB (Reference Table) $command = $connection->createCommand("INSERT INTO tblDistrict (District_ID, State_ID) VALUES('$District_ID', '".STATE_ID."') "); $rowCount=$command->execute(); if($rowCount==0){ die("\r\n<hr />FATAL ERROR 0x02: Failed to insert $District in Reference table :: ".__FILE__." at line nunber ".__LINE__); } return $District_ID; } } else{ //Return the PK/ID of the record. return $row['LR_ID']; } } /** *Function to get City ID from City Name * *@param string $City *@param int */ private function getCityId($City){ //Select if record exists $City=trim(strtolower($City)); $connection = Yii::app()->db; $connection->active=true; $command = $connection->createCommand("SELECT LR_ID FROM tblLandRegion WHERE lower(LR_Name) = '$City' AND LR_Type='City' "); $row = $command->queryRow(); //If no record found if($row===false){ //Insert record in DB (Master Table) $command = $connection->createCommand("INSERT INTO tblLandRegion (LR_Name,LR_Type) VALUES('$City', 'City') "); $rowCount=$command->execute(); if($rowCount==0){ die("\r\n<hr />FATAL ERROR 0x01: Failed to insert $City in Master table :: ".__FILE__." at line nunber ".__LINE__); } else{ //Cache and Return the PK/ID of the new inserted record. $row = Yii::app()->cache->get('cache_'.$City."_".$District); if (($row === false) || row($res)) { $District=trim(strtolower($District)); $connection = Yii::app()->db; $command = $connection->createCommand("SELECT LR_ID FROM tblLandRegion WHERE lower(LR_Name) = '$City' AND LR_Type='City' ORDER BY LR_ID DESC"); $row = $command->queryRow(); Yii::app()->cache->set('cache_'.$City."_".$District, $row, DATA_CACHE_TIMEOUT); } $City_ID=$row['LR_ID']; //Insert record in DB (Reference Table) $command = $connection->createCommand("INSERT INTO tblCity (District_ID, City_ID) VALUES('$District_ID', '$City_ID') "); $rowCount=$command->execute(); if($rowCount==0){ die("\r\n<hr />FATAL ERROR 0x02: Failed to insert $District in Reference table :: ".__FILE__." at line nunber ".__LINE__); } return $City_ID; } } else{ //Return the PK/ID of the record. return $row['LR_ID']; } } } ?>
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/ADueD
function name:  (null)
number of ops:  10
compiled vars:  none
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    2     0  E >   INIT_FCALL                                               'define'
          1        SEND_VAL                                                 'STATE_ID'
          2        SEND_VAL                                                 '3'
          3        DO_ICALL                                                 
    3     4        INIT_FCALL                                               'define'
          5        SEND_VAL                                                 'DATA_CACHE_TIMEOUT'
          6        SEND_VAL                                                 '9999'
          7        DO_ICALL                                                 
   10     8        DECLARE_CLASS                                            'importcontroller', 'controller'
  132     9      > RETURN                                                   1

Class ImportController:
Function actionindex:
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 77) Position 1 = 25, Position 2 = 40
Branch analysis from position: 25
2 jumps found. (Code = 78) Position 1 = 26, Position 2 = 40
Branch analysis from position: 26
1 jumps found. (Code = 42) Position 1 = 25
Branch analysis from position: 25
Branch analysis from position: 40
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 40
filename:       /in/ADueD
function name:  actionIndex
number of ops:  64
compiled vars:  !0 = $t1, !1 = $ts1, !2 = $tot, !3 = $connection, !4 = $command, !5 = $rows, !6 = $row, !7 = $Name_en, !8 = $Name_h, !9 = $SRDB_District_ID, !10 = $District, !11 = $t2, !12 = $ts2, !13 = $diff
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   13     0  E >   INIT_FCALL                                               'date'
          1        SEND_VAL                                                 'r'
          2        DO_ICALL                                         $14     
          3        ASSIGN                                                   !0, $14
   14     4        INIT_FCALL                                               'microtime'
          5        SEND_VAL                                                 <true>
          6        DO_ICALL                                         $16     
          7        ASSIGN                                                   !1, $16
   15     8        ASSIGN                                                   !2, 0
   16     9        ROPE_INIT                                     3  ~20     '%0D%0A%3Cp%3E+%2A%2A%2A%2A%2A%2A%2A%2A+Started+at++'
         10        ROPE_ADD                                      1  ~20     ~20, !0
         11        ROPE_END                                      2  ~19     ~20, '+%2A%2A%2A%2A%2A%2A%2A%2A+%3C%2Fp%3E%0D%0A'
         12        ECHO                                                     ~19
   18    13        INIT_STATIC_METHOD_CALL                                  'Yii', 'app'
         14        DO_FCALL                                      0  $22     
         15        FETCH_OBJ_R                                      ~23     $22, 'db'
         16        ASSIGN                                                   !3, ~23
   19    17        INIT_METHOD_CALL                                         !3, 'createCommand'
         18        SEND_VAL_EX                                              'SELECT+%2A+FROM+seccsirsa+LIMIT+0%2C10'
         19        DO_FCALL                                      0  $25     
         20        ASSIGN                                                   !4, $25
   20    21        INIT_METHOD_CALL                                         !4, 'queryAll'
         22        DO_FCALL                                      0  $27     
         23        ASSIGN                                                   !5, $27
   22    24      > FE_RESET_R                                       $29     !5, ->40
         25    > > FE_FETCH_R                                               $29, !6, ->40
   23    26    >   INIT_FCALL                                               'extract'
         27        SEND_REF                                                 !6
         28        DO_ICALL                                                 
   25    29        ROPE_INIT                                     5  ~32     '%0D%0A%3Cp%3EFull+Name%3A+'
         30        ROPE_ADD                                      1  ~32     ~32, !7
         31        ROPE_ADD                                      2  ~32     ~32, '+%28'
         32        ROPE_ADD                                      3  ~32     ~32, !8
         33        ROPE_END                                      4  ~31     ~32, '%29+%3C%2Fp%3E%0D%0A'
         34        ECHO                                                     ~31
   26    35        INIT_METHOD_CALL                                         'getDistrictId'
         36        SEND_VAR_EX                                              !10
         37        DO_FCALL                                      0  $35     
         38        ASSIGN                                                   !9, $35
   22    39      > JMP                                                      ->25
         40    >   FE_FREE                                                  $29
   30    41        INIT_FCALL                                               'date'
         42        SEND_VAL                                                 'r'
         43        DO_ICALL                                         $37     
         44        ASSIGN                                                   !11, $37
   31    45        INIT_FCALL                                               'microtime'
         46        SEND_VAL                                                 <true>
         47        DO_ICALL                                         $39     
         48        ASSIGN                                                   !12, $39
   32    49        SUB                                              ~41     !12, !1
         50        ASSIGN                                                   !13, ~41
   33    51        ROPE_INIT                                     3  ~44     '%0D%0A%3Cp%3E+%2A%2A%2A%2A%2A%2A%2A%2A+Stopped+at++'
         52        ROPE_ADD                                      1  ~44     ~44, !11
         53        ROPE_END                                      2  ~43     ~44, '+%2A%2A%2A%2A%2A%2A%2A%2A+%3C%2Fp%3E%0D%0A'
         54        ECHO                                                     ~43
   34    55        ROPE_INIT                                     3  ~47     '%0D%0A%3Cp%3E+%2A%2A%2A%2A%2A%2A%2A%2A+Total+Execution+Time%3A+'
         56        ROPE_ADD                                      1  ~47     ~47, !13
         57        ROPE_END                                      2  ~46     ~47, '+microseconds+%2A%2A%2A%2A%2A%2A%2A%2A+%3C%2Fp%3E%0D%0A'
         58        ECHO                                                     ~46
   35    59        ROPE_INIT                                     3  ~50     '%0D%0A%3Cp%3E+%2A%2A%2A%2A%2A%2A%2A%2A+Total+Records+Imported%3A+'
         60        ROPE_ADD                                      1  ~50     ~50, !2
         61        ROPE_END                                      2  ~49     ~50, '++%2A%2A%2A%2A%2A%2A%2A%2A+%3C%2Fp%3E%0D%0A'
         62        ECHO                                                     ~49
   36    63      > RETURN                                                   null

End of function actionindex

Function getdistrictid:
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 26, Position 2 = 124
Branch analysis from position: 26
2 jumps found. (Code = 43) Position 1 = 38, Position 2 = 46
Branch analysis from position: 38
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 46
2 jumps found. (Code = 47) Position 1 = 59, Position 2 = 63
Branch analysis from position: 59
2 jumps found. (Code = 43) Position 1 = 64, Position 2 = 98
Branch analysis from position: 64
2 jumps found. (Code = 43) Position 1 = 115, Position 2 = 122
Branch analysis from position: 115
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 122
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 98
Branch analysis from position: 63
Branch analysis from position: 124
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/ADueD
function name:  getDistrictId
number of ops:  127
compiled vars:  !0 = $District, !1 = $connection, !2 = $command, !3 = $row, !4 = $rowCount, !5 = $res, !6 = $District_ID
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   44     0  E >   RECV                                             !0      
   46     1        INIT_FCALL                                               'trim'
          2        INIT_FCALL                                               'strtolower'
          3        SEND_VAR                                                 !0
          4        DO_ICALL                                         $7      
          5        SEND_VAR                                                 $7
          6        DO_ICALL                                         $8      
          7        ASSIGN                                                   !0, $8
   47     8        INIT_STATIC_METHOD_CALL                                  'Yii', 'app'
          9        DO_FCALL                                      0  $10     
         10        FETCH_OBJ_R                                      ~11     $10, 'db'
         11        ASSIGN                                                   !1, ~11
   48    12        ASSIGN_OBJ                                               !1, 'active'
         13        OP_DATA                                                  <true>
   49    14        INIT_METHOD_CALL                                         !1, 'createCommand'
         15        ROPE_INIT                                     3  ~15     'SELECT+LR_ID+FROM+tblLandRegion+WHERE+lower%28LR_Name%29+%3D+%27'
         16        ROPE_ADD                                      1  ~15     ~15, !0
         17        ROPE_END                                      2  ~14     ~15, '%27+AND+LR_Type%3D%27District%27+'
         18        SEND_VAL_EX                                              ~14
         19        DO_FCALL                                      0  $17     
         20        ASSIGN                                                   !2, $17
   50    21        INIT_METHOD_CALL                                         !2, 'queryRow'
         22        DO_FCALL                                      0  $19     
         23        ASSIGN                                                   !3, $19
   52    24        TYPE_CHECK                                    4          !3
         25      > JMPZ                                                     ~21, ->124
   54    26    >   INIT_METHOD_CALL                                         !1, 'createCommand'
         27        ROPE_INIT                                     3  ~23     'INSERT+INTO+tblLandRegion+%28LR_Name%2CLR_Type%29+VALUES%28%27'
         28        ROPE_ADD                                      1  ~23     ~23, !0
         29        ROPE_END                                      2  ~22     ~23, '%27%2C+%27District%27%29+'
         30        SEND_VAL_EX                                              ~22
         31        DO_FCALL                                      0  $25     
         32        ASSIGN                                                   !2, $25
   55    33        INIT_METHOD_CALL                                         !2, 'execute'
         34        DO_FCALL                                      0  $27     
         35        ASSIGN                                                   !4, $27
   56    36        IS_EQUAL                                                 !4, 0
         37      > JMPZ                                                     ~29, ->46
   57    38    >   ROPE_INIT                                     3  ~31     '%0D%0A%3Chr+%2F%3EFATAL+ERROR+0x01%3A+Failed+to+insert+'
         39        ROPE_ADD                                      1  ~31     ~31, !0
         40        ROPE_END                                      2  ~30     ~31, '+in+Master+table+%3A%3A+'
         41        CONCAT                                           ~33     ~30, '%2Fin%2FADueD'
         42        CONCAT                                           ~34     ~33, '+at+line+nunber+'
         43        CONCAT                                           ~35     ~34, '57'
         44      > EXIT                                                     ~35
         45*       JMP                                                      ->123
   61    46    >   INIT_STATIC_METHOD_CALL                                  'Yii', 'app'
         47        DO_FCALL                                      0  $36     
         48        FETCH_OBJ_R                                      ~37     $36, 'cache'
         49        INIT_METHOD_CALL                                         ~37, 'get'
         50        CONCAT                                           ~38     'cache_', !0
         51        CONCAT                                           ~39     ~38, '_'
         52        FETCH_CONSTANT                                   ~40     'STATE_ID'
         53        CONCAT                                           ~41     ~39, ~40
         54        SEND_VAL_EX                                              ~41
         55        DO_FCALL                                      0  $42     
         56        ASSIGN                                                   !3, $42
   62    57        TYPE_CHECK                                    4  ~44     !3
         58      > JMPNZ_EX                                         ~44     ~44, ->63
         59    >   INIT_FCALL_BY_NAME                                       'row'
         60        SEND_VAR_EX                                              !5
         61        DO_FCALL                                      0  $45     
         62        BOOL                                             ~44     $45
         63    > > JMPZ                                                     ~44, ->98
   63    64    >   INIT_FCALL                                               'trim'
         65        INIT_FCALL                                               'strtolower'
         66        SEND_VAR                                                 !0
         67        DO_ICALL                                         $46     
         68        SEND_VAR                                                 $46
         69        DO_ICALL                                         $47     
         70        ASSIGN                                                   !0, $47
   64    71        INIT_STATIC_METHOD_CALL                                  'Yii', 'app'
         72        DO_FCALL                                      0  $49     
         73        FETCH_OBJ_R                                      ~50     $49, 'db'
         74        ASSIGN                                                   !1, ~50
   65    75        INIT_METHOD_CALL                                         !1, 'createCommand'
         76        ROPE_INIT                                     3  ~53     'SELECT+LR_ID+FROM+tblLandRegion+WHERE+lower%28LR_Name%29+%3D+%27'
         77        ROPE_ADD                                      1  ~53     ~53, !0
         78        ROPE_END                                      2  ~52     ~53, '%27+AND+LR_Type%3D%27District%27+ORDER+BY+LR_ID+DESC'
         79        SEND_VAL_EX                                              ~52
         80        DO_FCALL                                      0  $55     
         81        ASSIGN                                                   !2, $55
   66    82        INIT_METHOD_CALL                                         !2, 'queryRow'
         83        DO_FCALL                                      0  $57     
         84        ASSIGN                                                   !3, $57
   67    85        INIT_STATIC_METHOD_CALL                                  'Yii', 'app'
         86        DO_FCALL                                      0  $59     
         87        FETCH_OBJ_R                                      ~60     $59, 'cache'
         88        INIT_METHOD_CALL                                         ~60, 'set'
         89        CONCAT                                           ~61     'cache_', !0
         90        CONCAT                                           ~62     ~61, '_'
         91        FETCH_CONSTANT                                   ~63     'STATE_ID'
         92        CONCAT                                           ~64     ~62, ~63
         93        SEND_VAL_EX                                              ~64
         94        SEND_VAR_EX                                              !3
         95        FETCH_CONSTANT                                   ~65     'DATA_CACHE_TIMEOUT'
         96        SEND_VAL_EX                                              ~65
         97        DO_FCALL                                      0          
   69    98    >   FETCH_DIM_R                                      ~67     !3, 'LR_ID'
         99        ASSIGN                                                   !6, ~67
   71   100        INIT_METHOD_CALL                                         !1, 'createCommand'
        101        ROPE_INIT                                     3  ~70     'INSERT+INTO+tblDistrict+%28District_ID%2C+State_ID%29+VALUES%28%27'
        102        ROPE_ADD                                      1  ~70     ~70, !6
        103        ROPE_END                                      2  ~69     ~70, '%27%2C+%27'
        104        FETCH_CONSTANT                                   ~72     'STATE_ID'
        105        CONCAT                                           ~73     ~69, ~72
        106        CONCAT                                           ~74     ~73, '%27%29+'
        107        SEND_VAL_EX                                              ~74
        108        DO_FCALL                                      0  $75     
        109        ASSIGN                                                   !2, $75
   72   110        INIT_METHOD_CALL                                         !2, 'execute'
        111        DO_FCALL                                      0  $77     
        112        ASSIGN                                                   !4, $77
   73   113        IS_EQUAL                                                 !4, 0
        114      > JMPZ                                                     ~79, ->122
   74   115    >   ROPE_INIT                                     3  ~81     '%0D%0A%3Chr+%2F%3EFATAL+ERROR+0x02%3A+Failed+to+insert+'
        116        ROPE_ADD                                      1  ~81     ~81, !0
        117        ROPE_END                                      2  ~80     ~81, '+in+Reference+table+%3A%3A+'
        118        CONCAT                                           ~83     ~80, '%2Fin%2FADueD'
        119        CONCAT                                           ~84     ~83, '+at+line+nunber+'
        120        CONCAT                                           ~85     ~84, '74'
        121      > EXIT                                                     ~85
   76   122    > > RETURN                                                   !6
        123*       JMP                                                      ->126
   81   124    >   FETCH_DIM_R                                      ~86     !3, 'LR_ID'
        125      > RETURN                                                   ~86
   83   126*     > RETURN                                                   null

End of function getdistrictid

Function getcityid:
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 26, Position 2 = 121
Branch analysis from position: 26
2 jumps found. (Code = 43) Position 1 = 38, Position 2 = 46
Branch analysis from position: 38
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 46
2 jumps found. (Code = 47) Position 1 = 58, Position 2 = 62
Branch analysis from position: 58
2 jumps found. (Code = 43) Position 1 = 63, Position 2 = 96
Branch analysis from position: 63
2 jumps found. (Code = 43) Position 1 = 112, Position 2 = 119
Branch analysis from position: 112
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 119
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 96
Branch analysis from position: 62
Branch analysis from position: 121
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/ADueD
function name:  getCityId
number of ops:  124
compiled vars:  !0 = $City, !1 = $connection, !2 = $command, !3 = $row, !4 = $rowCount, !5 = $District, !6 = $res, !7 = $City_ID, !8 = $District_ID
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   91     0  E >   RECV                                             !0      
   93     1        INIT_FCALL                                               'trim'
          2        INIT_FCALL                                               'strtolower'
          3        SEND_VAR                                                 !0
          4        DO_ICALL                                         $9      
          5        SEND_VAR                                                 $9
          6        DO_ICALL                                         $10     
          7        ASSIGN                                                   !0, $10
   94     8        INIT_STATIC_METHOD_CALL                                  'Yii', 'app'
          9        DO_FCALL                                      0  $12     
         10        FETCH_OBJ_R                                      ~13     $12, 'db'
         11        ASSIGN                                                   !1, ~13
   95    12        ASSIGN_OBJ                                               !1, 'active'
         13        OP_DATA                                                  <true>
   96    14        INIT_METHOD_CALL                                         !1, 'createCommand'
         15        ROPE_INIT                                     3  ~17     'SELECT+LR_ID+FROM+tblLandRegion+WHERE+lower%28LR_Name%29+%3D+%27'
         16        ROPE_ADD                                      1  ~17     ~17, !0
         17        ROPE_END                                      2  ~16     ~17, '%27+AND+LR_Type%3D%27City%27+'
         18        SEND_VAL_EX                                              ~16
         19        DO_FCALL                                      0  $19     
         20        ASSIGN                                                   !2, $19
   97    21        INIT_METHOD_CALL                                         !2, 'queryRow'
         22        DO_FCALL                                      0  $21     
         23        ASSIGN                                                   !3, $21
   99    24        TYPE_CHECK                                    4          !3
         25      > JMPZ                                                     ~23, ->121
  101    26    >   INIT_METHOD_CALL                                         !1, 'createCommand'
         27        ROPE_INIT                                     3  ~25     'INSERT+INTO+tblLandRegion+%28LR_Name%2CLR_Type%29+VALUES%28%27'
         28        ROPE_ADD                                      1  ~25     ~25, !0
         29        ROPE_END                                      2  ~24     ~25, '%27%2C+%27City%27%29+'
         30        SEND_VAL_EX                                              ~24
         31        DO_FCALL                                      0  $27     
         32        ASSIGN                                                   !2, $27
  102    33        INIT_METHOD_CALL                                         !2, 'execute'
         34        DO_FCALL                                      0  $29     
         35        ASSIGN                                                   !4, $29
  103    36        IS_EQUAL                                                 !4, 0
         37      > JMPZ                                                     ~31, ->46
  104    38    >   ROPE_INIT                                     3  ~33     '%0D%0A%3Chr+%2F%3EFATAL+ERROR+0x01%3A+Failed+to+insert+'
         39        ROPE_ADD                                      1  ~33     ~33, !0
         40        ROPE_END                                      2  ~32     ~33, '+in+Master+table+%3A%3A+'
         41        CONCAT                                           ~35     ~32, '%2Fin%2FADueD'
         42        CONCAT                                           ~36     ~35, '+at+line+nunber+'
         43        CONCAT                                           ~37     ~36, '104'
         44      > EXIT                                                     ~37
         45*       JMP                                                      ->120
  108    46    >   INIT_STATIC_METHOD_CALL                                  'Yii', 'app'
         47        DO_FCALL                                      0  $38     
         48        FETCH_OBJ_R                                      ~39     $38, 'cache'
         49        INIT_METHOD_CALL                                         ~39, 'get'
         50        CONCAT                                           ~40     'cache_', !0
         51        CONCAT                                           ~41     ~40, '_'
         52        CONCAT                                           ~42     ~41, !5
         53        SEND_VAL_EX                                              ~42
         54        DO_FCALL                                      0  $43     
         55        ASSIGN                                                   !3, $43
  109    56        TYPE_CHECK                                    4  ~45     !3
         57      > JMPNZ_EX                                         ~45     ~45, ->62
         58    >   INIT_FCALL_BY_NAME                                       'row'
         59        SEND_VAR_EX                                              !6
         60        DO_FCALL                                      0  $46     
         61        BOOL                                             ~45     $46
         62    > > JMPZ                                                     ~45, ->96
  110    63    >   INIT_FCALL                                               'trim'
         64        INIT_FCALL                                               'strtolower'
         65        SEND_VAR                                                 !5
         66        DO_ICALL                                         $47     
         67        SEND_VAR                                                 $47
         68        DO_ICALL                                         $48     
         69        ASSIGN                                                   !5, $48
  111    70        INIT_STATIC_METHOD_CALL                                  'Yii', 'app'
         71        DO_FCALL                                      0  $50     
         72        FETCH_OBJ_R                                      ~51     $50, 'db'
         73        ASSIGN                                                   !1, ~51
  112    74        INIT_METHOD_CALL                                         !1, 'createCommand'
         75        ROPE_INIT                                     3  ~54     'SELECT+LR_ID+FROM+tblLandRegion+WHERE+lower%28LR_Name%29+%3D+%27'
         76        ROPE_ADD                                      1  ~54     ~54, !0
         77        ROPE_END                                      2  ~53     ~54, '%27+AND+LR_Type%3D%27City%27+ORDER+BY+LR_ID+DESC'
         78        SEND_VAL_EX                                              ~53
         79        DO_FCALL                                      0  $56     
         80        ASSIGN                                                   !2, $56
  113    81        INIT_METHOD_CALL                                         !2, 'queryRow'
         82        DO_FCALL                                      0  $58     
         83        ASSIGN                                                   !3, $58
  114    84        INIT_STATIC_METHOD_CALL                                  'Yii', 'app'
         85        DO_FCALL                                      0  $60     
         86        FETCH_OBJ_R                                      ~61     $60, 'cache'
         87        INIT_METHOD_CALL                                         ~61, 'set'
         88        CONCAT                                           ~62     'cache_', !0
         89        CONCAT                                           ~63     ~62, '_'
         90        CONCAT                                           ~64     ~63, !5
         91        SEND_VAL_EX                                              ~64
         92        SEND_VAR_EX                                              !3
         93        FETCH_CONSTANT                                   ~65     'DATA_CACHE_TIMEOUT'
         94        SEND_VAL_EX                                              ~65
         95        DO_FCALL                                      0          
  116    96    >   FETCH_DIM_R                                      ~67     !3, 'LR_ID'
         97        ASSIGN                                                   !7, ~67
  118    98        INIT_METHOD_CALL                                         !1, 'createCommand'
         99        ROPE_INIT                                     5  ~70     'INSERT+INTO+tblCity+%28District_ID%2C+City_ID%29+VALUES%28%27'
        100        ROPE_ADD                                      1  ~70     ~70, !8
        101        ROPE_ADD                                      2  ~70     ~70, '%27%2C+%27'
        102        ROPE_ADD                                      3  ~70     ~70, !7
        103        ROPE_END                                      4  ~69     ~70, '%27%29+'
        104        SEND_VAL_EX                                              ~69
        105        DO_FCALL                                      0  $73     
        106        ASSIGN                                                   !2, $73
  119   107        INIT_METHOD_CALL                                         !2, 'execute'
        108        DO_FCALL                                      0  $75     
        109        ASSIGN                                                   !4, $75
  120   110        IS_EQUAL                                                 !4, 0
        111      > JMPZ                                                     ~77, ->119
  121   112    >   ROPE_INIT                                     3  ~79     '%0D%0A%3Chr+%2F%3EFATAL+ERROR+0x02%3A+Failed+to+insert+'
        113        ROPE_ADD                                      1  ~79     ~79, !5
        114        ROPE_END                                      2  ~78     ~79, '+in+Reference+table+%3A%3A+'
        115        CONCAT                                           ~81     ~78, '%2Fin%2FADueD'
        116        CONCAT                                           ~82     ~81, '+at+line+nunber+'
        117        CONCAT                                           ~83     ~82, '121'
        118      > EXIT                                                     ~83
  123   119    > > RETURN                                                   !7
        120*       JMP                                                      ->123
  128   121    >   FETCH_DIM_R                                      ~84     !3, 'LR_ID'
        122      > RETURN                                                   ~84
  130   123*     > RETURN                                                   null

End of function getcityid

End of class ImportController.

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
152.79 ms | 1424 KiB | 25 Q