<?php
    $servername = "mysql365int.srv-hostalia.com";
    $username = "u4790831_yery";
    $password = "2468Yeray1993";
    $basededades = "db4790831_practiques";
    $nom = $_POST['name'];
    $cognom = $_POST['surname'];
    $correu =  $_POST['email'];
    $direccio = $_POST['direcction'];
    $poblacio = $_POST['poblacio'];
    $telefon = $_POST['phone'];

    $con=mysql_connect($servername,$username,$password);
    if(!$con)
    {
        die("Connection failed: ");
    }
    else{
            mysql_select_db($basededades);
            "INSERT INTO table_name(column_name1, column_name2)VALUES('value1, 'value2')" ;
            $sql="INSERT INTO usuaris(id, nom, cognom, correu, direccio, poblacio, telefon)VALUES (NULL, '$nom', '$cognom', '$correu', '$direccio', '$poblacio', '$telefon')";
            echo("<br>Registre efectuat amb exit");
    }
    mysql_close($con);
?>