<?php

DEFINE ('DBUSER', '******');
DEFINE ('DBPW', '*****');
DEFINE ('DBHOST', 's******');
DEFINE ('DBNAME', '*******');

$dbc = mysqli_connect(DBHOST,DBUSER,DBPW);
if (!$dbc) {
    die("Database connection failed: " . mysqli_error($dbc));
    exit();
}

$dbs = mysqli_select_db($dbc, DBNAME);
if (!$dbs) {
    die("Database selection failed: " . mysqli_error($dbc));
    exit();
}

$clientusername = mysqli_real_escape_string($dbc, $_GET['clientusername']);
$clientemail = mysqli_real_escape_string($dbc,$_GET['clientemail']);
$clientlocation = mysqli_real_escape_string($dbc,$_GET['clientlocation']);
$clientpno = mysqli_real_escape_string($dbc,$_GET['clientpno']);
$clienttype = mysqli_real_escape_string($dbc,$_GET['clienttype']);
$clientpass = mysqli_real_escape_string($dbc,$_GET['clientpass']);


$query = "INSERT INTO ssudb(clientusername, clientemail, clientlocation, clientpno, clienttype, clientpass) VALUES ('$clientusername', '$clientemail', '$clientpno', '$clienttype', '$clientpass')";

$result = mysqli_query($dbc, $query) or trigger_error("Query MySQL Error: " . mysqli_error($dbc));

mysqli_close($dbc);

?>