3v4l.org

run code in 300+ PHP versions simultaneously
<?php class RequestSQL { public $ar=array(); /////////////////////////////////return Other Name Page (Il faut inserer var $url) public function link_pages($pdo,$url){ $dbb=$pdo->prepare('SELECT link FROM other_np WHERE link=:vurl'); $dbb->execute(array('vurl' => $url)); $res=$dbb->fetch(); if($res){return $ar="other";} else{ $dbb=$pdo->prepare('SELECT link FROM art_np WHERE link=:vurl'); $dbb->execute(array('vurl' => $url)); $res=$dbb->fetch(); if($res){return $ar="Article";} else{ return $ar="Error"; } } } public function trends_selectAll($pdo){ $i=0; $dbb=$pdo->query('SELECT * FROM trends LIMIT 0,5'); while($res=$dbb->fetch()) { $ar[]=$res; } return $ar; } public function carrousel_selectNote($pdo){ $i=0; $dbb=$pdo->query('SELECT * FROM art_all left join art_info on art_all.artID=art_info.infoID WHERE info="top"'); while($res=$dbb->fetch()) { $ar[]=$res; } return $ar; } public function new_popular_selectLIMIT($pdo,$pagination){ $i=0; if($pagination>=0){$start=$pagination*5; $end=$start+5;}else{$start=0; $end=5;} $sql='SELECT * FROM art_all LIMIT '.$start.','.$end; $dbb=$pdo->query($sql); while($res=$dbb->fetch()) { $ar[]=$res; } return $ar; } public function category_around_the_word($pdo,$pagination){ $i=0; if($pagination>=0){$start=$pagination*5; $end=$start+5;} $sql='SELECT * FROM art_all LIMIT '.$start.','.$end; $dbb=$pdo->query($sql); while($res=$dbb->fetch()) { $ar[]=$res; } return $ar; } }
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/0vqGS
function name:  (null)
number of ops:  1
compiled vars:  none
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   57     0  E > > RETURN                                                   1

Class RequestSQL:
Function link_pages:
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 14, Position 2 = 17
Branch analysis from position: 14
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 17
2 jumps found. (Code = 43) Position 1 = 29, Position 2 = 32
Branch analysis from position: 29
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 32
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/0vqGS
function name:  link_pages
number of ops:  35
compiled vars:  !0 = $pdo, !1 = $url, !2 = $dbb, !3 = $res, !4 = $ar
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   10     0  E >   RECV                                             !0      
          1        RECV                                             !1      
   12     2        INIT_METHOD_CALL                                         !0, 'prepare'
          3        SEND_VAL_EX                                              'SELECT+link+FROM+other_np+WHERE+link%3D%3Avurl'
          4        DO_FCALL                                      0  $5      
          5        ASSIGN                                                   !2, $5
   13     6        INIT_METHOD_CALL                                         !2, 'execute'
          7        INIT_ARRAY                                       ~7      !1, 'vurl'
          8        SEND_VAL_EX                                              ~7
          9        DO_FCALL                                      0          
   14    10        INIT_METHOD_CALL                                         !2, 'fetch'
         11        DO_FCALL                                      0  $9      
         12        ASSIGN                                                   !3, $9
   15    13      > JMPZ                                                     !3, ->17
         14    >   ASSIGN                                           ~11     !4, 'other'
         15      > RETURN                                                   ~11
         16*       JMP                                                      ->34
   17    17    >   INIT_METHOD_CALL                                         !0, 'prepare'
         18        SEND_VAL_EX                                              'SELECT+link+FROM+art_np+WHERE+link%3D%3Avurl'
         19        DO_FCALL                                      0  $12     
         20        ASSIGN                                                   !2, $12
   18    21        INIT_METHOD_CALL                                         !2, 'execute'
         22        INIT_ARRAY                                       ~14     !1, 'vurl'
         23        SEND_VAL_EX                                              ~14
         24        DO_FCALL                                      0          
   19    25        INIT_METHOD_CALL                                         !2, 'fetch'
         26        DO_FCALL                                      0  $16     
         27        ASSIGN                                                   !3, $16
   20    28      > JMPZ                                                     !3, ->32
         29    >   ASSIGN                                           ~18     !4, 'Article'
         30      > RETURN                                                   ~18
         31*       JMP                                                      ->34
   21    32    >   ASSIGN                                           ~19     !4, 'Error'
         33      > RETURN                                                   ~19
   23    34*     > RETURN                                                   null

End of function link_pages

Function trends_selectall:
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 42) Position 1 = 9
Branch analysis from position: 9
2 jumps found. (Code = 44) Position 1 = 13, Position 2 = 7
Branch analysis from position: 13
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 7
2 jumps found. (Code = 44) Position 1 = 13, Position 2 = 7
Branch analysis from position: 13
Branch analysis from position: 7
filename:       /in/0vqGS
function name:  trends_selectAll
number of ops:  15
compiled vars:  !0 = $pdo, !1 = $i, !2 = $dbb, !3 = $ar, !4 = $res
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   26     0  E >   RECV                                             !0      
          1        ASSIGN                                                   !1, 0
   27     2        INIT_METHOD_CALL                                         !0, 'query'
          3        SEND_VAL_EX                                              'SELECT+%2A+FROM+trends+LIMIT+0%2C5'
          4        DO_FCALL                                      0  $6      
          5        ASSIGN                                                   !2, $6
   28     6      > JMP                                                      ->9
          7    >   ASSIGN_DIM                                               !3
          8        OP_DATA                                                  !4
          9    >   INIT_METHOD_CALL                                         !2, 'fetch'
         10        DO_FCALL                                      0  $9      
         11        ASSIGN                                           ~10     !4, $9
         12      > JMPNZ                                                    ~10, ->7
   29    13    > > RETURN                                                   !3
   30    14*     > RETURN                                                   null

End of function trends_selectall

Function carrousel_selectnote:
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 42) Position 1 = 9
Branch analysis from position: 9
2 jumps found. (Code = 44) Position 1 = 13, Position 2 = 7
Branch analysis from position: 13
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 7
2 jumps found. (Code = 44) Position 1 = 13, Position 2 = 7
Branch analysis from position: 13
Branch analysis from position: 7
filename:       /in/0vqGS
function name:  carrousel_selectNote
number of ops:  15
compiled vars:  !0 = $pdo, !1 = $i, !2 = $dbb, !3 = $ar, !4 = $res
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   32     0  E >   RECV                                             !0      
          1        ASSIGN                                                   !1, 0
   33     2        INIT_METHOD_CALL                                         !0, 'query'
          3        SEND_VAL_EX                                              'SELECT+%2A+FROM+art_all+left+join+art_info+%0A%09++++++++++%09on+art_all.artID%3Dart_info.infoID+%0A%09++++++++++%09WHERE+info%3D%22top%22'
          4        DO_FCALL                                      0  $6      
          5        ASSIGN                                                   !2, $6
   36     6      > JMP                                                      ->9
          7    >   ASSIGN_DIM                                               !3
          8        OP_DATA                                                  !4
          9    >   INIT_METHOD_CALL                                         !2, 'fetch'
         10        DO_FCALL                                      0  $9      
         11        ASSIGN                                           ~10     !4, $9
         12      > JMPNZ                                                    ~10, ->7
   37    13    > > RETURN                                                   !3
   38    14*     > RETURN                                                   null

End of function carrousel_selectnote

Function new_popular_selectlimit:
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 5, Position 2 = 10
Branch analysis from position: 5
1 jumps found. (Code = 42) Position 1 = 12
Branch analysis from position: 12
1 jumps found. (Code = 42) Position 1 = 23
Branch analysis from position: 23
2 jumps found. (Code = 44) Position 1 = 27, Position 2 = 21
Branch analysis from position: 27
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 21
2 jumps found. (Code = 44) Position 1 = 27, Position 2 = 21
Branch analysis from position: 27
Branch analysis from position: 21
Branch analysis from position: 10
1 jumps found. (Code = 42) Position 1 = 23
Branch analysis from position: 23
filename:       /in/0vqGS
function name:  new_popular_selectLIMIT
number of ops:  29
compiled vars:  !0 = $pdo, !1 = $pagination, !2 = $i, !3 = $start, !4 = $end, !5 = $sql, !6 = $dbb, !7 = $ar, !8 = $res
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   40     0  E >   RECV                                             !0      
          1        RECV                                             !1      
          2        ASSIGN                                                   !2, 0
   41     3        IS_SMALLER_OR_EQUAL                                      0, !1
          4      > JMPZ                                                     ~10, ->10
          5    >   MUL                                              ~11     !1, 5
          6        ASSIGN                                                   !3, ~11
          7        ADD                                              ~13     !3, 5
          8        ASSIGN                                                   !4, ~13
          9      > JMP                                                      ->12
         10    >   ASSIGN                                                   !3, 0
         11        ASSIGN                                                   !4, 5
   42    12    >   CONCAT                                           ~17     'SELECT+%2A+FROM+art_all+LIMIT+', !3
         13        CONCAT                                           ~18     ~17, '%2C'
         14        CONCAT                                           ~19     ~18, !4
         15        ASSIGN                                                   !5, ~19
   43    16        INIT_METHOD_CALL                                         !0, 'query'
         17        SEND_VAR_EX                                              !5
         18        DO_FCALL                                      0  $21     
         19        ASSIGN                                                   !6, $21
   44    20      > JMP                                                      ->23
         21    >   ASSIGN_DIM                                               !7
         22        OP_DATA                                                  !8
         23    >   INIT_METHOD_CALL                                         !6, 'fetch'
         24        DO_FCALL                                      0  $24     
         25        ASSIGN                                           ~25     !8, $24
         26      > JMPNZ                                                    ~25, ->21
   45    27    > > RETURN                                                   !7
   46    28*     > RETURN                                                   null

End of function new_popular_selectlimit

Function category_around_the_word:
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 5, Position 2 = 9
Branch analysis from position: 5
1 jumps found. (Code = 42) Position 1 = 20
Branch analysis from position: 20
2 jumps found. (Code = 44) Position 1 = 24, Position 2 = 18
Branch analysis from position: 24
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 18
2 jumps found. (Code = 44) Position 1 = 24, Position 2 = 18
Branch analysis from position: 24
Branch analysis from position: 18
Branch analysis from position: 9
filename:       /in/0vqGS
function name:  category_around_the_word
number of ops:  26
compiled vars:  !0 = $pdo, !1 = $pagination, !2 = $i, !3 = $start, !4 = $end, !5 = $sql, !6 = $dbb, !7 = $ar, !8 = $res
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   48     0  E >   RECV                                             !0      
          1        RECV                                             !1      
          2        ASSIGN                                                   !2, 0
   49     3        IS_SMALLER_OR_EQUAL                                      0, !1
          4      > JMPZ                                                     ~10, ->9
          5    >   MUL                                              ~11     !1, 5
          6        ASSIGN                                                   !3, ~11
          7        ADD                                              ~13     !3, 5
          8        ASSIGN                                                   !4, ~13
   50     9    >   CONCAT                                           ~15     'SELECT+%2A+FROM+art_all+LIMIT+', !3
         10        CONCAT                                           ~16     ~15, '%2C'
         11        CONCAT                                           ~17     ~16, !4
         12        ASSIGN                                                   !5, ~17
   51    13        INIT_METHOD_CALL                                         !0, 'query'
         14        SEND_VAR_EX                                              !5
         15        DO_FCALL                                      0  $19     
         16        ASSIGN                                                   !6, $19
   52    17      > JMP                                                      ->20
         18    >   ASSIGN_DIM                                               !7
         19        OP_DATA                                                  !8
         20    >   INIT_METHOD_CALL                                         !6, 'fetch'
         21        DO_FCALL                                      0  $22     
         22        ASSIGN                                           ~23     !8, $22
         23      > JMPNZ                                                    ~23, ->18
   53    24    > > RETURN                                                   !7
   54    25*     > RETURN                                                   null

End of function category_around_the_word

End of class RequestSQL.

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
173.47 ms | 1411 KiB | 13 Q