3v4l.org

run code in 300+ PHP versions simultaneously
<?php $con = mysql_connect("localhost","C00151376","F16b89a"); if (!$con){ die('Could not connect: ' . mysql_error()); } mysql_select_db("DB_C00151376_CA2", $con); $result = mysql_query("SELECT * FROM classes"); echo "<table border='1'> <tr> <th>Staff</th> <th>Lesson</th> <th>Classroom</th> <th>Date</th> <th>Edit</th> <th>Delete</th> </tr>"; while($row = mysql_fetch_array($result)){ echo "<tr>"; echo "<td>" . mysql_fetch_array(mysql_query("SELECT staff_name FROM staff WHERE ID=".$row['staff'].""))[0]. "</td>"; echo "<td>" . mysql_fetch_array(mysql_query("SELECT lesson_name FROM lesson WHERE ID=".$row['lesson'].""))[0]."</td>"; echo "<td>" . mysql_fetch_array(mysql_query("SELECT classroom_number FROM classroom WHERE ID=".$row['classroom'].""))[0]."</td>"; echo "<td>" . $row['date']. "</td>"; echo '<td> <a href="edit.php?id='.$row['ID'].'"> Edit </a> </td>'; echo '<td> <a href="delete.php?del='.$row['ID'].'"> Delete </a> </td>'; echo "</tr>"; } echo "</table>"; mysql_close($con); ?>
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 8, Position 2 = 12
Branch analysis from position: 8
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 12
1 jumps found. (Code = 42) Position 1 = 75
Branch analysis from position: 75
2 jumps found. (Code = 44) Position 1 = 80, Position 2 = 22
Branch analysis from position: 80
1 jumps found. (Code = 62) Position 1 = -2
Branch analysis from position: 22
2 jumps found. (Code = 44) Position 1 = 80, Position 2 = 22
Branch analysis from position: 80
Branch analysis from position: 22
filename:       /in/o92Hv
function name:  (null)
number of ops:  85
compiled vars:  !0 = $con, !1 = $result, !2 = $row
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    2     0  E >   INIT_FCALL_BY_NAME                                       'mysql_connect'
          1        SEND_VAL_EX                                              'localhost'
          2        SEND_VAL_EX                                              'C00151376'
          3        SEND_VAL_EX                                              'F16b89a'
          4        DO_FCALL                                      0  $3      
          5        ASSIGN                                                   !0, $3
    3     6        BOOL_NOT                                         ~5      !0
          7      > JMPZ                                                     ~5, ->12
    4     8    >   INIT_FCALL_BY_NAME                                       'mysql_error'
          9        DO_FCALL                                      0  $6      
         10        CONCAT                                           ~7      'Could+not+connect%3A+', $6
         11      > EXIT                                                     ~7
    7    12    >   INIT_FCALL_BY_NAME                                       'mysql_select_db'
         13        SEND_VAL_EX                                              'DB_C00151376_CA2'
         14        SEND_VAR_EX                                              !0
         15        DO_FCALL                                      0          
    9    16        INIT_FCALL_BY_NAME                                       'mysql_query'
         17        SEND_VAL_EX                                              'SELECT+%2A+FROM+classes'
         18        DO_FCALL                                      0  $9      
         19        ASSIGN                                                   !1, $9
   11    20        ECHO                                                     '%3Ctable+border%3D%271%27%3E%0A+%3Ctr%3E%0A+%3Cth%3EStaff%3C%2Fth%3E%0A+%3Cth%3ELesson%3C%2Fth%3E%0A+%3Cth%3EClassroom%3C%2Fth%3E%0A+%3Cth%3EDate%3C%2Fth%3E%0A+%3Cth%3EEdit%3C%2Fth%3E%0A++%3Cth%3EDelete%3C%2Fth%3E%0A+%3C%2Ftr%3E'
   21    21      > JMP                                                      ->75
   22    22    >   ECHO                                                     '%3Ctr%3E'
   24    23        INIT_FCALL_BY_NAME                                       'mysql_fetch_array'
         24        INIT_FCALL_BY_NAME                                       'mysql_query'
         25        FETCH_DIM_R                                      ~11     !2, 'staff'
         26        CONCAT                                           ~12     'SELECT+staff_name+FROM+staff+WHERE+ID%3D', ~11
         27        CONCAT                                           ~13     ~12, ''
         28        SEND_VAL_EX                                              ~13
         29        DO_FCALL                                      0  $14     
         30        SEND_VAR_NO_REF_EX                                       $14
         31        DO_FCALL                                      0  $15     
         32        FETCH_DIM_R                                      ~16     $15, 0
         33        CONCAT                                           ~17     '%3Ctd%3E', ~16
         34        CONCAT                                           ~18     ~17, '%3C%2Ftd%3E'
         35        ECHO                                                     ~18
   25    36        INIT_FCALL_BY_NAME                                       'mysql_fetch_array'
         37        INIT_FCALL_BY_NAME                                       'mysql_query'
         38        FETCH_DIM_R                                      ~19     !2, 'lesson'
         39        CONCAT                                           ~20     'SELECT+lesson_name+FROM+lesson+WHERE+ID%3D', ~19
         40        CONCAT                                           ~21     ~20, ''
         41        SEND_VAL_EX                                              ~21
         42        DO_FCALL                                      0  $22     
         43        SEND_VAR_NO_REF_EX                                       $22
         44        DO_FCALL                                      0  $23     
         45        FETCH_DIM_R                                      ~24     $23, 0
         46        CONCAT                                           ~25     '%3Ctd%3E', ~24
         47        CONCAT                                           ~26     ~25, '%3C%2Ftd%3E'
         48        ECHO                                                     ~26
   26    49        INIT_FCALL_BY_NAME                                       'mysql_fetch_array'
         50        INIT_FCALL_BY_NAME                                       'mysql_query'
         51        FETCH_DIM_R                                      ~27     !2, 'classroom'
         52        CONCAT                                           ~28     'SELECT+classroom_number+FROM+classroom+WHERE+ID%3D', ~27
         53        CONCAT                                           ~29     ~28, ''
         54        SEND_VAL_EX                                              ~29
         55        DO_FCALL                                      0  $30     
         56        SEND_VAR_NO_REF_EX                                       $30
         57        DO_FCALL                                      0  $31     
         58        FETCH_DIM_R                                      ~32     $31, 0
         59        CONCAT                                           ~33     '%3Ctd%3E', ~32
         60        CONCAT                                           ~34     ~33, '%3C%2Ftd%3E'
         61        ECHO                                                     ~34
   28    62        FETCH_DIM_R                                      ~35     !2, 'date'
         63        CONCAT                                           ~36     '%3Ctd%3E', ~35
         64        CONCAT                                           ~37     ~36, '%3C%2Ftd%3E'
         65        ECHO                                                     ~37
   29    66        FETCH_DIM_R                                      ~38     !2, 'ID'
         67        CONCAT                                           ~39     '%3Ctd%3E+%3Ca+href%3D%22edit.php%3Fid%3D', ~38
         68        CONCAT                                           ~40     ~39, '%22%3E+Edit+%3C%2Fa%3E+%3C%2Ftd%3E'
         69        ECHO                                                     ~40
   30    70        FETCH_DIM_R                                      ~41     !2, 'ID'
         71        CONCAT                                           ~42     '%3Ctd%3E+%3Ca+href%3D%22delete.php%3Fdel%3D', ~41
         72        CONCAT                                           ~43     ~42, '%22%3E+Delete+%3C%2Fa%3E+%3C%2Ftd%3E'
         73        ECHO                                                     ~43
   31    74        ECHO                                                     '%3C%2Ftr%3E'
   21    75    >   INIT_FCALL_BY_NAME                                       'mysql_fetch_array'
         76        SEND_VAR_EX                                              !1
         77        DO_FCALL                                      0  $44     
         78        ASSIGN                                           ~45     !2, $44
         79      > JMPNZ                                                    ~45, ->22
   34    80    >   ECHO                                                     '%3C%2Ftable%3E'
   36    81        INIT_FCALL_BY_NAME                                       'mysql_close'
         82        SEND_VAR_EX                                              !0
         83        DO_FCALL                                      0          
   37    84      > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
148.32 ms | 1403 KiB | 13 Q