<?php
$servername = "localhost";
$username = "matias";
$password = "L9PbZwGw6Zfw9cwG";
$dbname = "matias";

$facebook = $_GET['facebookUpdate'];
$linkedin = $_GET['linkedinUpdate'];
$google = $_GET['googleUpdate'];
$youtube = $_GET['youtubeUpdate'];
$pinterest = $_GET['pinterestUpdate'];
$instagram = $_GET['instagramUpdate'];
$twitter = $_GET['twitterUpdate'];

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "UPDATE contacts SET facebook = COALESCE('$facebook', facebook), linkedin = COALESCE('$linkedin', linkedin), google = COALESCE('$google', google), youtube = COALESCE('$youtube',youtube), pinterest = COALESCE('$pinterest',pinterest), instagram = COALESCE('$instagram', instagram), twitter = COALESCE('$twitter', twitter)";

if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}

$conn->close();
?>