3v4l.org

run code in 300+ PHP versions simultaneously
<?php function syncSocialWithPin($userinfo, &$status) { //istanzio db SLAVE e recupero l'user ID del nuovo utente sullo SLAVE $db = JFusionFactory::getDatabase($this->getJname()); $query_pin = $db->getQuery(true) ->select('id') ->from('#__users') ->where('username=' ."'$userinfo->username'"); $db->setQuery($query_pin); $user_id_pin = $db->loadResult(); // SLAVE id -> #__users //istanzio db MASTER e recupero id MASTER $database_master = JFactory::getDBO(); $select_user_id = $database_master->getQuery(true) ->select('id') ->from('#__users') ->where('username='."'$userinfo->username'"); $database_master->setQuery($select_user_id); $master_user_id = $database_master->loadResult(); // MASTER id -> #__users //Recupero info Joomsocial // $query_users_fields = $database_master->getQuery(true) // ->select('value') // ->from('#__community_fields_values') // ->where('user_id='.$master_user_id .' AND field_id=8'); // $database_master->setQuery($query_users_fields); // $masterdbresults = $database_master->loadResult(); //Joomsocial infos // controllo che la query abbia un risultato! $pinimport = new stdClass(); // obj da importare $pinimport->user_id = $user_id_pin; $pinimport->first_name = $userinfo->name; $pinimport->username = $userinfo->username; $pinimport->email = $userinfo->email; $pinimport->location = $master_user_id; $pinimport->created_date = date('Y-m-d H:i:s', time()); $pinimport->updated_date = date('Y-m-d H:i:s', time()); $pinimport->activation = ''; //TEST IT!!!! //Controllo se l'utente è già presente su social pinboard $updatedinfo = $db->getQuery(true) ->select('*') ->from('#__pin_user_settings') ->where('email='."'$userinfo->email'"); $db->setQuery($updatedinfo); $datacheck = $db->loadObjectList(); $emptycheck = (array) $datacheck; // typecasto ad array per controllare se è vuoto! // if(empty(get_object_vars($datacheck) // un 1liner per vedere se l'oggetto è vuoto if (empty($emptycheck)) { // se NON è presente INSERT tutto $db->insertObject('#__pin_user_settings', $pinimport); $status['debug']="l'utente è presente su SocialPinboard, emptycheck positivo!"; } // else if controlla ogni campo presente e vedi se è diverso da quelli passati nell'oggetto $userinfo // foreach ($datacheck as $d) { // if ($d->username != $userinfo->username) // { // $usernameupdate = $db->getQuery(true) // ->insert("'$d->username'") // ->in(#__user); // $db->setQuery($usernameupdate); // $db->query() // $db->execute() // $status['debug']= "Usernamer Modificato" .$userinfo->username. "in".$d->username; // } // // if ($d->email != $userinfo->email) // { // $emailupdate = $db->getQuery(true) // ->insert("'$d->email'") // ->in(#__user); // $db->setQuery($emailupdate); // $db->query() // $db->execute() // $status['debug']= "Email Modificato" .$userinfo->email. "in".$d->email; // } // // if ($d->first_name != $userinfo->first_name) // { // $firstnameupdate = $db->getQuery(true) // ->insert("'$d->first_name'") // ->in(#__user); // $db->setQuery($firstnameupdate); // $db->query() // $db->execute() // $status['debug']= "First_name Modificato" .$userinfo->first_name. "in".$d->first_name; // } // // if ($d->location != $userinfo->location) // { // $locationupdate = $db->getQuery(true) // ->insert("'$d->location'") // ->in(#__user); // $db->setQuery($locationupdate); // $db->query() // $db->execute() // $status['debug']= "Location Modificato" .$userinfo->location. "in".$d->location; // } // //} return $status; } /*

Here you find the average performance (time & memory) of each version. A grayed out version indicates it didn't complete successfully (based on exit-code).

VersionSystem time (s)User time (s)Memory (MiB)
7.2.110.0090.00916.55
7.2.100.0180.01316.54
7.2.90.0150.00416.17
7.2.80.0300.01216.42
7.2.70.0340.00616.54
7.2.60.0410.00016.40
7.2.50.0350.00516.61
7.2.40.0130.00616.70
7.2.30.0240.00616.68
7.2.20.0170.01016.56
7.2.10.0230.00716.42
7.2.00.0090.00918.07
7.1.230.0250.00615.69
7.1.220.0190.00615.41
7.1.210.0280.00315.48
7.1.200.0380.00315.60
7.1.190.0340.01015.56
7.1.180.0090.00615.46
7.1.170.0250.00815.63
7.1.160.0310.00315.41
7.1.150.0140.01115.49
7.1.140.0220.00315.55
7.1.130.0290.00015.54
7.1.120.0140.00715.57
7.1.110.0210.00315.47
7.1.100.0120.00416.66
7.1.90.0240.00015.58
7.1.80.0120.00815.44
7.1.70.0130.00916.20
7.1.60.0160.00817.79
7.1.50.0110.01816.30
7.1.40.0220.00915.66
7.1.30.0200.00415.61
7.1.20.0500.00915.72
7.1.10.0170.00215.61
7.1.00.0280.03519.00
7.0.310.0130.00315.08
7.0.300.0220.01015.26
7.0.290.0280.00815.22
7.0.280.0210.00315.33
7.0.270.0200.00715.24
7.0.260.0120.00815.18
7.0.250.0120.01215.33
7.0.240.0190.01015.32
7.0.230.0180.00015.33
7.0.220.0480.00715.11
7.0.210.0220.00015.18
7.0.200.0350.00715.83
7.0.190.0200.00715.09
7.0.180.0200.00014.97
7.0.170.0160.00315.41
7.0.160.0180.00915.32
7.0.150.0230.00314.94
7.0.140.0110.04018.63
7.0.130.0150.00715.41
7.0.120.0380.00015.28
7.0.110.0170.00715.25
7.0.100.0150.00815.06
7.0.90.0230.00015.27
7.0.80.0420.02317.54
7.0.70.0430.04217.55
7.0.60.0320.03817.48
7.0.50.0480.04017.87
7.0.40.0070.04616.61
7.0.30.0080.04216.57
7.0.20.0110.04016.65
7.0.10.0030.04816.72
7.0.00.0140.03916.57
5.6.380.0100.00614.23
5.6.370.0120.00614.07
5.6.360.0110.00714.08
5.6.350.0200.00014.11
5.6.340.0110.00314.29
5.6.330.0140.00614.37
5.6.320.0030.01114.14
5.6.310.0130.00614.13
5.6.300.0150.00413.91
5.6.290.0000.01514.48
5.6.280.0110.03917.47
5.6.270.0190.00014.20
5.6.260.0130.00414.10
5.6.250.0130.00714.35
5.6.240.0140.00014.20
5.6.230.0140.02017.40
5.6.220.0070.02417.41
5.6.210.0070.02617.35
5.6.200.0110.04417.75
5.6.190.0080.04317.56
5.6.180.0070.02917.63
5.6.170.0000.05417.50
5.6.160.0100.04517.51
5.6.150.0100.04317.63
5.6.140.0130.04017.53
5.6.130.0150.04017.64
5.6.120.0140.03017.78
5.6.110.0090.02717.66
5.6.100.0110.04817.45
5.6.90.0140.02417.38
5.6.80.0080.02817.44
5.6.70.0100.04217.10
5.6.60.0130.03817.21
5.6.50.0090.04017.30
5.6.40.0070.04117.25
5.6.30.0130.03517.20
5.6.20.0040.03017.22
5.6.10.0080.02517.17
5.6.00.0110.03617.15
5.5.380.0070.00312.79
5.5.370.0080.03716.62
5.5.360.0090.04216.61
5.5.350.0100.03816.65
5.5.340.0090.03716.81
5.5.330.0070.04716.87
5.5.320.0110.04116.85
5.5.310.0120.04016.80
5.5.300.0050.02516.88
5.5.290.0070.04116.84
5.5.280.0120.04416.86
5.5.270.0080.02816.86
5.5.260.0050.04716.84
5.5.250.0120.02416.77
5.5.240.0120.03716.54
5.5.230.0020.04816.55
5.5.220.0070.04116.55
5.5.210.0100.03716.48
5.5.200.0080.02816.47
5.5.190.0100.04216.49
5.5.180.0070.02716.52
5.5.170.0080.00813.77
5.5.160.0110.03816.49
5.5.150.0020.04616.48
5.5.140.0080.02216.52
5.5.130.0080.04116.52
5.5.120.0070.03416.53
5.5.110.0080.04616.40
5.5.100.0070.03816.43
5.5.90.0100.02516.48
5.5.80.0060.04316.46
5.5.70.0090.03816.43
5.5.60.0090.03416.45
5.5.50.0070.04016.40
5.5.40.0080.03816.45
5.5.30.0130.03316.43
5.5.20.0120.02816.47
5.5.10.0030.02816.44
5.5.00.0060.04516.42
5.4.450.0120.02016.08
5.4.440.0090.02616.12
5.4.430.0030.02516.12
5.4.420.0130.03716.12
5.4.410.0060.03215.93
5.4.400.0060.02916.00
5.4.390.0110.04115.92
5.4.380.0060.03615.83
5.4.370.0090.03915.92
5.4.360.0120.03715.95
5.4.350.0090.03515.99
5.4.340.0090.03815.96
5.4.330.0080.00412.79
5.4.320.0070.03216.00
5.4.310.0090.04215.87
5.4.300.0080.03815.96
5.4.290.0080.03515.96
5.4.280.0060.03315.81
5.4.270.0080.03315.94
5.4.260.0120.03815.91
5.4.250.0100.03716.01
5.4.240.0060.03416.01
5.4.230.0090.03715.83
5.4.220.0080.04215.81
5.4.210.0080.04315.91
5.4.200.0050.02315.95
5.4.190.0060.04315.83
5.4.180.0090.03615.81
5.4.170.0050.04215.83
5.4.160.0080.03315.81
5.4.150.0090.04115.95
5.4.140.0100.02314.61
5.4.130.0090.02114.57
5.4.120.0110.03514.63
5.4.110.0070.03714.63
5.4.100.0060.03214.61
5.4.90.0090.03814.61
5.4.80.0080.03514.60
5.4.70.0140.03114.60
5.4.60.0030.04314.61
5.4.50.0090.01714.61
5.4.40.0100.02014.63
5.4.30.0100.03614.62
5.4.20.0050.04214.55
5.4.10.0090.03714.63
5.4.00.0070.03914.25
5.3.290.0120.03713.75
5.3.280.0100.03713.77
5.3.270.0020.04413.70
5.3.260.0130.03513.68
5.3.250.0100.03813.70
5.3.240.0080.02513.73
5.3.230.0080.03813.67
5.3.220.0070.03113.66
5.3.210.0030.04213.75
5.3.200.0070.04113.75
5.3.190.0080.03713.73
5.3.180.0060.02513.67
5.3.170.0000.03013.70
5.3.160.0090.02913.69
5.3.150.0070.02113.68
5.3.140.0040.03613.70
5.3.130.0120.03513.71
5.3.120.0130.02313.69
5.3.110.0080.03713.73
5.3.100.0110.02013.41
5.3.90.0090.03613.42
5.3.80.0050.02513.48
5.3.70.0100.03513.38
5.3.60.0080.03713.35
5.3.50.0080.03813.37
5.3.40.0100.03513.44
5.3.30.0050.03113.31
5.3.20.0020.04313.25
5.3.10.0060.03913.20
5.3.00.0080.03913.21
5.2.170.0030.03612.02
5.2.160.0120.02612.04
5.2.150.0080.03511.92
5.2.140.0110.03012.03
5.2.130.0030.03311.99
5.2.120.0060.03112.01
5.2.110.0020.02111.91
5.2.100.0030.02411.89
5.2.90.0030.01911.96
5.2.80.0070.02812.02
5.2.70.0030.03512.02
5.2.60.0030.03512.00
5.2.50.0080.03311.85
5.2.40.0080.02811.93
5.2.30.0100.02711.85
5.2.20.0090.01711.84
5.2.10.0060.03111.79
5.2.00.0050.03211.71
5.1.60.0060.02811.43
5.1.50.0050.03011.46
5.1.40.0030.01911.45
5.1.30.0070.01811.62
5.1.20.0070.02811.58
5.1.10.0070.01811.49
5.1.00.0030.02411.47
5.0.50.0050.01310.60
5.0.40.0070.02210.61
5.0.30.0040.03310.46
5.0.20.0010.01410.44
5.0.10.0030.01710.55
5.0.00.0020.04010.49
4.4.90.0030.02210.12
4.4.80.0030.01710.12
4.4.70.0040.01710.12
4.4.60.0060.01310.12
4.4.50.0050.01410.12
4.4.40.0030.02310.12
4.4.30.0020.02010.12
4.4.20.0050.01610.12
4.4.10.0040.01810.12
4.4.00.0030.02810.12
4.3.110.0020.01710.12
4.3.100.0030.01210.12
4.3.90.0050.01610.12
4.3.80.0040.02510.12
4.3.70.0030.01010.12
4.3.60.0040.01710.12
4.3.50.0020.01810.12
4.3.40.0030.02810.12
4.3.30.0030.01710.12
4.3.20.0050.01610.12
4.3.10.0060.01610.12
4.3.00.0010.01610.12

preferences:
59.63 ms | 401 KiB | 5 Q