3v4l.org

run code in 300+ PHP versions simultaneously
<?php $con=mysqli_connect("localhost","root","Krishna19942","newhopehospital"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } // escape variables for security $fname = mysqli_real_escape_string($con, $_POST['fname']); $lname = mysqli_real_escape_string($con, $_POST['lname']); $address= mysqli_real_escape_string($con, $post['address']); $pnum= mysqli_real_escape_string($con, $post['pnum']); $emptype= mysqli_real_escape_string($con, $post['emptype']); $wardname= mysqli_real_escape_string($con, $post['wardname']); $speciality= mysqli_real_escape_string($con, $post['speciality']); $sql="INSERT INTO doctordetails values ('','$fname','$lname','$address','$pnum','$emptype','$wardname','$speciality')"; $sql="update warddetails set Ward_Charge='$fname' where WardName='$wardname'"; if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); } echo "1 record added"; echo "<br><br>"; //$sql="select * from kr.personal"; //testing 2.......// //if($_POST["fname"] && $_POST["lname"] && $_POST["address"] && $_POST["pnum"] && $_POST["emptype"] && $_POST["wardname"] && $_POST["speciality"] ) //{ // $servername="localhost"; // $username="root"; // $password="Krishna19942"; // $conn= mysql_connect($servername,$username,$password)or die(mysql_error()); // mysql_select_db("newhopehospital",$conn); // $sql="insert into doctordetails values ('$fname','$lname','$address','$pnum','$emptype','$wardname','$speciality')"; // $result=mysql_query($sql,$conn) or die(mysql_error()); //} //else print"invaild input data"; mysqli_close($con); header("Location: ../new_doctor.php"); exit; ?>
Finding entry points
Branch analysis from position: 0
2 jumps found. (Code = 43) Position 1 = 10, Position 2 = 14
Branch analysis from position: 10
2 jumps found. (Code = 43) Position 1 = 93, Position 2 = 98
Branch analysis from position: 93
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 98
1 jumps found. (Code = 79) Position 1 = -2
Branch analysis from position: 14
filename:       /in/f65IR
function name:  (null)
number of ops:  108
compiled vars:  !0 = $con, !1 = $fname, !2 = $lname, !3 = $address, !4 = $post, !5 = $pnum, !6 = $emptype, !7 = $wardname, !8 = $speciality, !9 = $sql
line      #* E I O op                           fetch          ext  return  operands
-------------------------------------------------------------------------------------
    2     0  E >   INIT_FCALL_BY_NAME                                       'mysqli_connect'
          1        SEND_VAL_EX                                              'localhost'
          2        SEND_VAL_EX                                              'root'
          3        SEND_VAL_EX                                              'Krishna19942'
          4        SEND_VAL_EX                                              'newhopehospital'
          5        DO_FCALL                                      0  $10     
          6        ASSIGN                                                   !0, $10
    4     7        INIT_FCALL_BY_NAME                                       'mysqli_connect_errno'
          8        DO_FCALL                                      0  $12     
          9      > JMPZ                                                     $12, ->14
    5    10    >   INIT_FCALL_BY_NAME                                       'mysqli_connect_error'
         11        DO_FCALL                                      0  $13     
         12        CONCAT                                           ~14     'Failed+to+connect+to+MySQL%3A+', $13
         13        ECHO                                                     ~14
    9    14    >   INIT_FCALL_BY_NAME                                       'mysqli_real_escape_string'
         15        SEND_VAR_EX                                              !0
         16        CHECK_FUNC_ARG                                           
         17        FETCH_FUNC_ARG               global              $15     '_POST'
         18        FETCH_DIM_FUNC_ARG                               $16     $15, 'fname'
         19        SEND_FUNC_ARG                                            $16
         20        DO_FCALL                                      0  $17     
         21        ASSIGN                                                   !1, $17
   10    22        INIT_FCALL_BY_NAME                                       'mysqli_real_escape_string'
         23        SEND_VAR_EX                                              !0
         24        CHECK_FUNC_ARG                                           
         25        FETCH_FUNC_ARG               global              $19     '_POST'
         26        FETCH_DIM_FUNC_ARG                               $20     $19, 'lname'
         27        SEND_FUNC_ARG                                            $20
         28        DO_FCALL                                      0  $21     
         29        ASSIGN                                                   !2, $21
   11    30        INIT_FCALL_BY_NAME                                       'mysqli_real_escape_string'
         31        SEND_VAR_EX                                              !0
         32        CHECK_FUNC_ARG                                           
         33        FETCH_DIM_FUNC_ARG                               $23     !4, 'address'
         34        SEND_FUNC_ARG                                            $23
         35        DO_FCALL                                      0  $24     
         36        ASSIGN                                                   !3, $24
   12    37        INIT_FCALL_BY_NAME                                       'mysqli_real_escape_string'
         38        SEND_VAR_EX                                              !0
         39        CHECK_FUNC_ARG                                           
         40        FETCH_DIM_FUNC_ARG                               $26     !4, 'pnum'
         41        SEND_FUNC_ARG                                            $26
         42        DO_FCALL                                      0  $27     
         43        ASSIGN                                                   !5, $27
   13    44        INIT_FCALL_BY_NAME                                       'mysqli_real_escape_string'
         45        SEND_VAR_EX                                              !0
         46        CHECK_FUNC_ARG                                           
         47        FETCH_DIM_FUNC_ARG                               $29     !4, 'emptype'
         48        SEND_FUNC_ARG                                            $29
         49        DO_FCALL                                      0  $30     
         50        ASSIGN                                                   !6, $30
   14    51        INIT_FCALL_BY_NAME                                       'mysqli_real_escape_string'
         52        SEND_VAR_EX                                              !0
         53        CHECK_FUNC_ARG                                           
         54        FETCH_DIM_FUNC_ARG                               $32     !4, 'wardname'
         55        SEND_FUNC_ARG                                            $32
         56        DO_FCALL                                      0  $33     
         57        ASSIGN                                                   !7, $33
   15    58        INIT_FCALL_BY_NAME                                       'mysqli_real_escape_string'
         59        SEND_VAR_EX                                              !0
         60        CHECK_FUNC_ARG                                           
         61        FETCH_DIM_FUNC_ARG                               $35     !4, 'speciality'
         62        SEND_FUNC_ARG                                            $35
         63        DO_FCALL                                      0  $36     
         64        ASSIGN                                                   !8, $36
   18    65        ROPE_INIT                                    15  ~39     'INSERT+INTO+doctordetails+values+%28%27%27%2C%27'
         66        ROPE_ADD                                      1  ~39     ~39, !1
         67        ROPE_ADD                                      2  ~39     ~39, '%27%2C%27'
         68        ROPE_ADD                                      3  ~39     ~39, !2
         69        ROPE_ADD                                      4  ~39     ~39, '%27%2C%27'
         70        ROPE_ADD                                      5  ~39     ~39, !3
         71        ROPE_ADD                                      6  ~39     ~39, '%27%2C%27'
         72        ROPE_ADD                                      7  ~39     ~39, !5
         73        ROPE_ADD                                      8  ~39     ~39, '%27%2C%27'
         74        ROPE_ADD                                      9  ~39     ~39, !6
         75        ROPE_ADD                                     10  ~39     ~39, '%27%2C%27'
         76        ROPE_ADD                                     11  ~39     ~39, !7
         77        ROPE_ADD                                     12  ~39     ~39, '%27%2C%27'
         78        ROPE_ADD                                     13  ~39     ~39, !8
         79        ROPE_END                                     14  ~38     ~39, '%27%29'
         80        ASSIGN                                                   !9, ~38
   20    81        ROPE_INIT                                     5  ~49     'update+warddetails+set+Ward_Charge%3D%27'
         82        ROPE_ADD                                      1  ~49     ~49, !1
         83        ROPE_ADD                                      2  ~49     ~49, '%27+where+WardName%3D%27'
         84        ROPE_ADD                                      3  ~49     ~49, !7
         85        ROPE_END                                      4  ~48     ~49, '%27'
         86        ASSIGN                                                   !9, ~48
   22    87        INIT_FCALL_BY_NAME                                       'mysqli_query'
         88        SEND_VAR_EX                                              !0
         89        SEND_VAR_EX                                              !9
         90        DO_FCALL                                      0  $53     
         91        BOOL_NOT                                         ~54     $53
         92      > JMPZ                                                     ~54, ->98
   23    93    >   INIT_FCALL_BY_NAME                                       'mysqli_error'
         94        SEND_VAR_EX                                              !0
         95        DO_FCALL                                      0  $55     
         96        CONCAT                                           ~56     'Error%3A+', $55
         97      > EXIT                                                     ~56
   25    98    >   ECHO                                                     '1+record+added'
   27    99        ECHO                                                     '%3Cbr%3E%3Cbr%3E'
   45   100        INIT_FCALL_BY_NAME                                       'mysqli_close'
        101        SEND_VAR_EX                                              !0
        102        DO_FCALL                                      0          
   46   103        INIT_FCALL                                               'header'
        104        SEND_VAL                                                 'Location%3A+..%2Fnew_doctor.php'
        105        DO_ICALL                                                 
   47   106      > EXIT                                                     
   49   107*     > RETURN                                                   1

Generated using Vulcan Logic Dumper, using php 8.0.0


preferences:
152.41 ms | 1404 KiB | 15 Q