vvvsvsdgdsrytvvf File manager

File manager - Edit - /home3/securxia/testingmg.securecloudserver.in.net/check_data_status.php

Back
<?php // check_data_status.php $db_host = "localhost"; $db_user = "root"; $db_pass = ""; $db_name = "bookmov9_matrimonial2024"; $conn = new mysqli($db_host, $db_user, $db_pass, $db_name); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } echo "Checking marital_status table...\n"; $result = $conn->query("SELECT * FROM marital_status"); $marital_map = []; while ($row = $result->fetch_assoc()) { $marital_map[$row['marital_status_id']] = $row['name']; } echo "Marital status table has " . count($marital_map) . " entries.\n"; echo "\nChecking first 5 members for education...\n"; $result = $conn->query("SELECT member_id, education_and_career FROM member LIMIT 5"); while ($row = $result->fetch_assoc()) { echo "Member ID: " . $row['member_id'] . "\n"; $edu = json_decode($row['education_and_career'], true); if (isset($edu[0]['working_with'])) { echo " Working With (JSON): " . $edu[0]['working_with'] . "\n"; } if (isset($edu[0]['highest_education'])) { echo " Highest Education (JSON): " . $edu[0]['highest_education'] . "\n"; } } $conn->close();