3v4l.org

run code in 300+ PHP versions simultaneously
<?php $con=mysqli_connect("db4free.net","thesis","tribiana7584913","library"); $password = $_POST["password"]; $username = $_POST["username"]; $statement = mysqli_prepare($con, "SELECT * FROM user_tbl where user_name = ? AND password = ? AND account_ID in (1,2) and status = 'Active'"); mysqli_stmt_bind_param($statement, "ss", $username,$password); mysqli_stmt_execute($statement); mysqli_stmt_store_result($statement); mysqli_stmt_bind_result($statement,$userID,$username,$password,$emailadd,$accountID,$status); $user = array(); while(mysqli_stmt_fetch($statement)){ $user[userID] = $userID; $user[username] = $username; $user[password] = $password; $user[emailadd] = $emailadd; $user[accountID] = $accountID; } echo json_encode($user); mysqli_stmt_close($statement); mysqli_close($con); ?>
Finding entry points
Branch analysis from position: 0
1 jumps found. (Code = 42) Position 1 = 56
Branch analysis from position: 56
2 jumps found. (Code = 44) Position 1 = 60, Position 2 = 41
Branch analysis from position: 60
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 41
2 jumps found. (Code = 44) Position 1 = 60, Position 2 = 41
Branch analysis from position: 60
Branch analysis from position: 41
filename:       /in/aN1IE
function name:  (null)
number of ops:  71
compiled vars:  !0 = $con, !1 = $password, !2 = $username, !3 = $statement, !4 = $userID, !5 = $emailadd, !6 = $accountID, !7 = $status, !8 = $user
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    2     0  E >   INIT_FCALL_BY_NAME                                       'mysqli_connect'
          1        SEND_VAL_EX                                              'db4free.net'
          2        SEND_VAL_EX                                              'thesis'
          3        SEND_VAL_EX                                              'tribiana7584913'
          4        SEND_VAL_EX                                              'library'
          5        DO_FCALL                                      0  $9      
          6        ASSIGN                                                   !0, $9
    4     7        FETCH_R                      global              ~11     '_POST'
          8        FETCH_DIM_R                                      ~12     ~11, 'password'
          9        ASSIGN                                                   !1, ~12
    5    10        FETCH_R                      global              ~14     '_POST'
         11        FETCH_DIM_R                                      ~15     ~14, 'username'
         12        ASSIGN                                                   !2, ~15
    7    13        INIT_FCALL_BY_NAME                                       'mysqli_prepare'
         14        SEND_VAR_EX                                              !0
         15        SEND_VAL_EX                                              'SELECT+%2A+FROM+user_tbl+where+user_name+%3D+%3F+AND+password+%3D+%3F+AND+account_ID+in+%281%2C2%29+and+status+%3D+%27Active%27'
         16        DO_FCALL                                      0  $17     
         17        ASSIGN                                                   !3, $17
    8    18        INIT_FCALL_BY_NAME                                       'mysqli_stmt_bind_param'
         19        SEND_VAR_EX                                              !3
         20        SEND_VAL_EX                                              'ss'
         21        SEND_VAR_EX                                              !2
         22        SEND_VAR_EX                                              !1
         23        DO_FCALL                                      0          
    9    24        INIT_FCALL_BY_NAME                                       'mysqli_stmt_execute'
         25        SEND_VAR_EX                                              !3
         26        DO_FCALL                                      0          
   11    27        INIT_FCALL_BY_NAME                                       'mysqli_stmt_store_result'
         28        SEND_VAR_EX                                              !3
         29        DO_FCALL                                      0          
   12    30        INIT_FCALL_BY_NAME                                       'mysqli_stmt_bind_result'
         31        SEND_VAR_EX                                              !3
         32        SEND_VAR_EX                                              !4
         33        SEND_VAR_EX                                              !2
         34        SEND_VAR_EX                                              !1
         35        SEND_VAR_EX                                              !5
         36        SEND_VAR_EX                                              !6
         37        SEND_VAR_EX                                              !7
         38        DO_FCALL                                      0          
   15    39        ASSIGN                                                   !8, <array>
   17    40      > JMP                                                      ->56
   18    41    >   FETCH_CONSTANT                                   ~24     'userID'
         42        ASSIGN_DIM                                               !8, ~24
         43        OP_DATA                                                  !4
   19    44        FETCH_CONSTANT                                   ~26     'username'
         45        ASSIGN_DIM                                               !8, ~26
         46        OP_DATA                                                  !2
   20    47        FETCH_CONSTANT                                   ~28     'password'
         48        ASSIGN_DIM                                               !8, ~28
         49        OP_DATA                                                  !1
   21    50        FETCH_CONSTANT                                   ~30     'emailadd'
         51        ASSIGN_DIM                                               !8, ~30
         52        OP_DATA                                                  !5
   22    53        FETCH_CONSTANT                                   ~32     'accountID'
         54        ASSIGN_DIM                                               !8, ~32
         55        OP_DATA                                                  !6
   17    56    >   INIT_FCALL_BY_NAME                                       'mysqli_stmt_fetch'
         57        SEND_VAR_EX                                              !3
         58        DO_FCALL                                      0  $34     
         59      > JMPNZ                                                    $34, ->41
   25    60    >   INIT_FCALL                                               'json_encode'
         61        SEND_VAR                                                 !8
         62        DO_ICALL                                         $35     
         63        ECHO                                                     $35
   26    64        INIT_FCALL_BY_NAME                                       'mysqli_stmt_close'
         65        SEND_VAR_EX                                              !3
         66        DO_FCALL                                      0          
   27    67        INIT_FCALL_BY_NAME                                       'mysqli_close'
         68        SEND_VAR_EX                                              !0
         69        DO_FCALL                                      0          
   28    70      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
163.32 ms | 1400 KiB | 15 Q