3v4l.org

run code in 300+ PHP versions simultaneously
<?php function getListTableForeignKeysSQL($table, $database = null) { $sql = "SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, ". "k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ ". "FROM information_schema.key_column_usage k /*!50116 ". "INNER JOIN information_schema.referential_constraints c ON ". " c.constraint_name = k.constraint_name AND ". " c.table_name = '$table' */ WHERE k.table_name = '$table'"; $databaseNameSql = null === $database ? "'$database'" : 'DATABASE()'; $sql .= " AND k.table_schema = $databaseNameSql /*!50116 AND c.constraint_schema = $databaseNameSql */"; $sql .= " AND k.`REFERENCED_COLUMN_NAME` is not NULL"; return $sql; } echo getListTableForeignKeysSQL('AreaLayoutsUsingPresets'). "\n"; echo getListTableForeignKeysSQL('AreaLayoutsUsingPresets', 'concrete5db'). "\n";
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/nouui
function name:  (null)
number of ops:  12
compiled vars:  none
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
   18     0  E >   INIT_FCALL                                               'getlisttableforeignkeyssql'
          1        SEND_VAL                                                 'AreaLayoutsUsingPresets'
          2        DO_FCALL                                      0  $0      
          3        CONCAT                                           ~1      $0, '%0A'
          4        ECHO                                                     ~1
   20     5        INIT_FCALL                                               'getlisttableforeignkeyssql'
          6        SEND_VAL                                                 'AreaLayoutsUsingPresets'
          7        SEND_VAL                                                 'concrete5db'
          8        DO_FCALL                                      0  $2      
          9        CONCAT                                           ~3      $2, '%0A'
         10        ECHO                                                     ~3
         11      > RETURN                                                   1

Function getlisttableforeignkeyssql:
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 11, Position 2 = 16
Branch analysis from position: 11
1 jumps found. (Code = 42) Position 1 = 17
Branch analysis from position: 17
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 16
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/nouui
function name:  getListTableForeignKeysSQL
number of ops:  27
compiled vars:  !0 = $table, !1 = $database, !2 = $sql, !3 = $databaseNameSql
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    3     0  E >   RECV                                             !0      
          1        RECV_INIT                                        !1      null
   10     2        ROPE_INIT                                     5  ~5      '++c.table_name+%3D+%27'
          3        ROPE_ADD                                      1  ~5      ~5, !0
          4        ROPE_ADD                                      2  ~5      ~5, '%27+%2A%2F+WHERE+k.table_name+%3D+%27'
          5        ROPE_ADD                                      3  ~5      ~5, !0
          6        ROPE_END                                      4  ~4      ~5, '%27'
          7        CONCAT                                           ~8      'SELECT+DISTINCT+k.%60CONSTRAINT_NAME%60%2C+k.%60COLUMN_NAME%60%2C+k.%60REFERENCED_TABLE_NAME%60%2C+k.%60REFERENCED_COLUMN_NAME%60+%2F%2A%2150116+%2C+c.update_rule%2C+c.delete_rule+%2A%2F+FROM+information_schema.key_column_usage+k+%2F%2A%2150116+INNER+JOIN+information_schema.referential_constraints+c+ON+++c.constraint_name+%3D+k.constraint_name+AND+', ~4
    5     8        ASSIGN                                                   !2, ~8
   11     9        TYPE_CHECK                                    2          !1
         10      > JMPZ                                                     ~10, ->16
         11    >   ROPE_INIT                                     3  ~12     '%27'
         12        ROPE_ADD                                      1  ~12     ~12, !1
         13        ROPE_END                                      2  ~11     ~12, '%27'
         14        QM_ASSIGN                                        ~14     ~11
         15      > JMP                                                      ->17
         16    >   QM_ASSIGN                                        ~14     'DATABASE%28%29'
         17    >   ASSIGN                                                   !3, ~14
   12    18        ROPE_INIT                                     5  ~17     '+AND+k.table_schema+%3D+'
         19        ROPE_ADD                                      1  ~17     ~17, !3
         20        ROPE_ADD                                      2  ~17     ~17, '+%2F%2A%2150116+AND+c.constraint_schema+%3D+'
         21        ROPE_ADD                                      3  ~17     ~17, !3
         22        ROPE_END                                      4  ~16     ~17, '+%2A%2F'
         23        ASSIGN_OP                                     8          !2, ~16
   13    24        ASSIGN_OP                                     8          !2, '+AND+k.%60REFERENCED_COLUMN_NAME%60+is+not+NULL'
   14    25      > RETURN                                                   !2
   15    26*     > RETURN                                                   null

End of function getlisttableforeignkeyssql

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
160.62 ms | 1403 KiB | 15 Q