How can the provided PHP login script be improved to allow users to add and edit additional information, such as an ICQ number, to their profiles?

To allow users to add and edit additional information like an ICQ number to their profiles, we can modify the existing login script to include a form for users to input and update this information. We can then store this information in a database table associated with each user's profile. By adding input fields for ICQ number and implementing database queries to save and retrieve this data, users will be able to manage this additional information on their profiles. 

// Add input fields for ICQ number in the profile update form
echo '<label for="icq">ICQ Number:</label>';
echo '<input type="text" id="icq" name="icq" value="' . $user['icq'] . '">';

// Update the database table to include a column for ICQ number
$sql = "ALTER TABLE users ADD icq VARCHAR(20) DEFAULT NULL";
mysqli_query($conn, $sql);

// Save and update the ICQ number in the database
$icq = $_POST['icq'];
$sql = "UPDATE users SET icq = '$icq' WHERE id = $user_id";
mysqli_query($conn, $sql);

// Retrieve and display the ICQ number on the user's profile
$sql = "SELECT icq FROM users WHERE id = $user_id";
$result = mysqli_query($conn, $sql);
$user = mysqli_fetch_assoc($result);
echo 'ICQ Number: ' . $user['icq'];

Keywords

PHP login script user profiles ICQ number editing profiles

Related Questions