Code: Select all
$db = mysqli_connect('server', 'user', 'password');
mysqli_select_db($db, "database");
$query = "UPDATE student SET id='$id', name_last='$name_last', name_first='$name_first', email='$email', class='$class', major='$major', living='$living WHERE id='$id'";
$result = mysqli_query($db, $query);
if ($result)
{
echo "student updated in database.</h2>";
}
else
{
echo "<h2> Error in placing data in database </h2>";
}
mysqli_close($db);