Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/rotary2982.org/public_html/conf2026

Free Space:

4.09 TB

🔧 Quick Actions

✏️ Editing: update_query_use_code.php

// function updateMember(){
	// 	global $con;

// 	$regIds = [914,916,,924,925,931,933,940,942,975,989,992];
	// 	$memIds = [1822,1817,1767,1916,1928,1950,1802,1893,3468,2422,2401];

// 	foreach ($regIds as $key => $regId){
	// 		echo $regSql = "UPDATE `registration` SET `member_id` = '".$memIds[$key]."' WHERE `registration`.`registration_id` = '".$regId."'; ";
	// 		$query = mysqli_query($con, "SELECT registration_details_id FROM registration_details WHERE ref_registration_id = $regId");

// 		$detId = mysqli_fetch_assoc($query);

// 		echo $memSql = "UPDATE `registration_details` SET `member_id` = '".$memIds[$key]."' WHERE `registration_details`.`registration_details_id` = '".$detId['registration_details_id']."'; ";
	// 		echo $refmemSql = "UPDATE `registration_details` SET `ref_member_id` = '".$memIds[$key]."' WHERE `registration_details`.`registration_details_id` = ".$detId['registration_details_id'];
	// 		echo "; ";
	// 	}

// 	exit;
	// }

// updateMember();
	function updateMember(){
		global $con;

$regIds = [1007,1046,1058,1078,1085,1086,1087,1092,1098,1120,1124,1133,1134,1135,1144,1148,1149,1151,1152,1165,1169,1182,1184,1198,1206,1209,1224,1226,1229,1238,1241,1245,1247,1275,1281,1289,1293,1294,1296,1310,1335,1368,1390,1397,1398,1411,1443,1445,1446,1447,1450,1453,1456,1458,1459,1460,1461,1470,1472,1476,1478,1483,1485,1486,1492,1545,1548,1556,1571,1583,1596,1602,];
		$memIds = [656, 1926, 2856, 3576, 4071,3439,3582,3428,3429,2389,2996,1455,3233,1472,1459,3200,648,641,2421,3215,3208,3198,3207,4038,3953,3075,3486,3530,3456,3499,3543,3549,3544,1741,639,1731,3477,2641,1812,2637,2953,3352,2181,4098,4072,1679,1541,1523,1515,1535,1555,1553,1529,1558,1542,1507,1551,1668,1667,1548,1490,3587,3520,3539,1519,2238,760,1950,480,2281,2060,2682];

foreach ($regIds as $key => $regId){
			echo $regSql = "UPDATE `registration` SET `member_id` = '".$memIds[$key]."' WHERE `registration`.`registration_id` = '".$regId."'; ";
			$query = mysqli_query($con, "SELECT registration_details_id FROM registration_details WHERE ref_registration_id = $regId");

$detId = mysqli_fetch_assoc($query);

echo $memSql = "UPDATE `registration_details` SET `member_id` = '".$memIds[$key]."' WHERE `registration_details`.`registration_details_id` = '".$detId['registration_details_id']."'; ";
			echo $refmemSql = "UPDATE `registration_details` SET `ref_member_id` = '".$memIds[$key]."' WHERE `registration_details`.`registration_details_id` = ".$detId['registration_details_id'];
			echo "; ";
		}

exit;
	}

updateMember();

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: update_query_use_code.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation