$dbc = mysqli_connect('localhost', 'root', 'password', 'dataBase')
or die('Error connecting to MySQL server.');

$query = "INSERT INTO table (column_1, column_2, column_3, column_4, " .
    "column_5, column _6, column_7) " .
    "VALUES ('$column_1', '$column_2', '$column_3', '$column_4','$column_5', " .
             "'$column_6, '$column_7')";

$result = mysqli_query($dbc, $query)
or die('Error querying database.');

DRIVER={MySQL ODBC 5.1 Driver}; SERVER=127.0.0.1; DATABASE=DATABASENAME; UID=USERNAME;PASSWORD=PASSWORD;