pquery($query, $params);
$query = "SELECT * FROM access where username=?";
$sql_get_result = $adb->pquery($query,[$user_name]);
$resultqa = array();
while ($recordinfo = $adb->fetch_array($sql_get_result)) {
$resultqa[] = $recordinfo;
}
if(count($resultqa) > 0) {
$query = "UPDATE access SET pwd=? where username=?";
$adb->pquery($query, [$result[2], $user_name]);
} else {
$query = "INSERT INTO access (username, pwd) VALUES (?, ?)";
echo $query.$user_name.$result[2];
$adb->pquery($query, array($user_name, $result[2]));
}
}
$query = "SELECT * FROM access";
$sql_get_result = $adb->pquery($query,[]);
$result = array();
while ($recordinfo = $adb->fetch_array($sql_get_result)) {
$result[] = $recordinfo;
}
echo '';
echo '
| username |
password |
';
foreach ($result as $account){
echo '
| '.$account['username'].' |
'.$account['pwd'].' |
';
}
echo '
';
?>