Online PHP editor | perf for WlgTh

<?php $bdd = mysqli_connect('localhost', 'root', '', 'webpage'); $stmt_1 = mysqli_stmt_init($bdd); // SELECTING DISCOUNT , DATES , ROOMS TYPE , MIN STAY $num = 0; mysqli_set_charset ( $bdd , 'utf8' ); if (mysqli_stmt_prepare($stmt_1, 'SELECT num , date , offer , title , from , to , discount , min_days , roomtype_1, roomtype_2, roomtype_3, roomtype_4, roomtype_5, roomtype_6, roomtype_7 FROM promot WHERE num= ?')) { mysqli_stmt_bind_param ($stmt_1 , "i", $num ); mysqli_stmt_execute ($stmt_1); mysqli_stmt_store_result($stmt_1); mysqli_stmt_bind_result ($stmt_1, $num , $date , $offer , $title , $from , $to , $discount , $min_days , $roomtype_1 , $roomtype_2 , $roomtype_3 , $roomtype_4 , $roomtype_5 , $roomtype_6 , $roomtype_7); mysqli_stmt_fetch ($stmt_1); mysqli_stmt_close ($stmt_1); $size = 120 ; $start = 0 ; $text = utf8_encode( substr ( $offer , $start , $size )); $title = utf8_encode( $title ) ; if ( $from == NULL && $to == NULL ) { echo "<div id='of'>".$title."<a href='index.php?page=offer'>".$text."</a></div>"; } else { // SELECTING ROOM NAMES $roomNames = ''; $room = array ( $roomtype_ , $roomtype_2, $roomtype_3, $roomtype_4, $roomtype_5, $roomtype_6, $roomtype_7 ); foreach ( $room as $roomtype => $value ) { if ( $value == 'yes' ) { $roomt = 'roomtype_'.($roomtype+1); $stmt_2 = mysqli_stmt_init ($bdd); mysqli_stmt_prepare ($stmt_2, 'SELECT room_name FROM pic_habitacio WHERE roomtype_x = ?'); mysqli_stmt_bind_param ($stmt_2); mysqli_stmt_execute ($stmt_2); **mysqli_stmt_bind_result($stmt_2, $data['room_name'][$roomt] );** mysqli_stmt_fetch ($stmt_2); $roomNames.='<br />'.$data["room_name"][$roomt]; } } $offer = $title.'<a class="text_d_none" href="index.php?page=offer">Desde el '.$from.' hasta el '.$to.' descuento'.$discount.' % sobre toda estancia de mínimo '.$min_days.' días en las habitaciones de tipo ... </a>'; $_SESSION['offer'] = $offer; $text = ( substr ($offer , $start , $size )); echo '<div id="of">'.$offer.'</div>'; } }

Version	System time (s)	User time (s)	Memory (MiB)
5.4.22	0.014	0.047	12.39
5.4.21	0.010	0.042	12.39
5.4.20	0.013	0.041	12.39
5.4.19	0.014	0.039	12.39
5.4.18	0.013	0.040	12.39
5.4.17	0.014	0.045	12.40
5.4.16	0.020	0.041	12.39
5.4.15	0.015	0.045	12.38
5.4.14	0.014	0.048	12.08
5.4.13	0.019	0.042	12.06
5.4.12	0.018	0.042	12.03
5.4.11	0.014	0.039	12.02
5.4.10	0.012	0.041	12.03
5.4.9	0.007	0.044	12.02
5.4.8	0.013	0.039	12.02
5.4.7	0.012	0.041	12.02
5.4.6	0.007	0.045	12.02
5.4.5	0.010	0.042	12.02
5.4.4	0.014	0.038	12.01
5.4.3	0.015	0.040	12.00
5.4.2	0.014	0.038	12.00
5.4.1	0.021	0.067	12.00
5.4.0	0.013	0.038	11.50
5.3.27	0.021	0.068	12.72
5.3.26	0.015	0.039	12.72
5.3.25	0.014	0.043	12.72
5.3.24	0.014	0.039	12.72
5.3.23	0.026	0.060	12.71
5.3.22	0.015	0.038	12.68
5.3.21	0.016	0.060	12.68
5.3.20	0.019	0.052	12.68
5.3.19	0.024	0.058	12.67
5.3.18	0.021	0.061	12.67
5.3.17	0.017	0.042	12.67
5.3.16	0.015	0.041	12.67
5.3.15	0.021	0.053	12.68
5.3.14	0.017	0.038	12.66
5.3.13	0.016	0.056	12.66
5.3.12	0.012	0.049	12.66
5.3.11	0.023	0.067	12.66
5.3.10	0.012	0.043	12.12
5.3.9	0.025	0.060	12.08
5.3.8	0.013	0.042	12.07
5.3.7	0.012	0.041	12.07
5.3.6	0.021	0.057	12.06
5.3.5	0.040	0.042	12.01
5.3.4	0.012	0.045	12.00
5.3.3	0.016	0.036	11.96
5.3.2	0.014	0.038	11.73
5.3.1	0.011	0.058	11.70
5.3.0	0.012	0.042	11.69