3v4l.org

run code in 300+ PHP versions simultaneously
<?php $a = "CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `user` AS select `kunde`.`kundeId` AS `id`,`kunde`.`email1` AS `email`,`kunde`.`password` AS `emailLoginToken`,`kunde`.`passwordHash` AS `passwordHash`,`kunde`.`lastFailedLogin` AS `lastFailedLogin`,`kunde`.`navn1` AS `name`,`kunde`.`efternavn1` AS `lastname`,`kunde`.`telefon1` AS `telephone`,`kunde`.`adresse1` AS `address`,`kunde`.`firmanavn` AS `company`,`kunde`.`postnr` AS `zipcode`,`kunde`.`oprettetDato` AS `creationDate`,`kunde`.`deletedDate` AS `deletedDate`,`kunde`.`approvalStatus` AS `approvalStatus` from `kunde` where ((`kunde`.`nytKundeId` = 0) and (`kunde`.`tempKundeId` = 0) and (isnull(`kunde`.`login`) or (`kunde`.`login` <> 'hest') or isnull(`kunde`.`password`) or (`kunde`.`password` <> 'WasDsaDcSadS')) and (`kunde`.`email1` <> ''))"; $from_pos = strripos($a, ' from '); // find position of FROM $sql = substr($a, 0, $from_pos) . ', `kunde`.`test` AS `test`' . substr($a, $from_pos); echo $sql;
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 62) Position 1 = -2
filename:       /in/Ui8lR
function name:  (null)
number of ops:  20
compiled vars:  !0 = $a, !1 = $from_pos, !2 = $sql
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    2     0  E >   ASSIGN                                                   !0, 'CREATE+ALGORITHM%3DUNDEFINED+DEFINER%3D%60root%60%40%60localhost%60+SQL+SECURITY+DEFINER+VIEW+%60user%60+AS+select+%60kunde%60.%60kundeId%60+AS+%60id%60%2C%60kunde%60.%60email1%60+AS+%60email%60%2C%60kunde%60.%60password%60+AS+%60emailLoginToken%60%2C%60kunde%60.%60passwordHash%60+AS+%60passwordHash%60%2C%60kunde%60.%60lastFailedLogin%60+AS+%60lastFailedLogin%60%2C%60kunde%60.%60navn1%60+AS+%60name%60%2C%60kunde%60.%60efternavn1%60+AS+%60lastname%60%2C%60kunde%60.%60telefon1%60+AS+%60telephone%60%2C%60kunde%60.%60adresse1%60+AS+%60address%60%2C%60kunde%60.%60firmanavn%60+AS+%60company%60%2C%60kunde%60.%60postnr%60+AS+%60zipcode%60%2C%60kunde%60.%60oprettetDato%60+AS+%60creationDate%60%2C%60kunde%60.%60deletedDate%60+AS+%60deletedDate%60%2C%60kunde%60.%60approvalStatus%60+AS+%60approvalStatus%60+from+%60kunde%60+where+%28%28%60kunde%60.%60nytKundeId%60+%3D+0%29+and+%28%60kunde%60.%60tempKundeId%60+%3D+0%29+and+%28isnull%28%60kunde%60.%60login%60%29+or+%28%60kunde%60.%60login%60+%3C%3E+%27hest%27%29+or+isnull%28%60kunde%60.%60password%60%29+or+%28%60kunde%60.%60password%60+%3C%3E+%27WasDsaDcSadS%27%29%29+and+%28%60kunde%60.%60email1%60+%3C%3E+%27%27%29%29'
    4     1        INIT_FCALL                                               'strripos'
          2        SEND_VAR                                                 !0
          3        SEND_VAL                                                 '+from+'
          4        DO_ICALL                                         $4      
          5        ASSIGN                                                   !1, $4
    5     6        INIT_FCALL                                               'substr'
          7        SEND_VAR                                                 !0
          8        SEND_VAL                                                 0
          9        SEND_VAR                                                 !1
         10        DO_ICALL                                         $6      
         11        CONCAT                                           ~7      $6, '%2C+%60kunde%60.%60test%60+AS+%60test%60'
         12        INIT_FCALL                                               'substr'
         13        SEND_VAR                                                 !0
         14        SEND_VAR                                                 !1
         15        DO_ICALL                                         $8      
         16        CONCAT                                           ~9      ~7, $8
         17        ASSIGN                                                   !2, ~9
    6    18        ECHO                                                     !2
         19      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
168.47 ms | 1396 KiB | 17 Q