function insertTestData()
{
$db_conn = new mysqli("localhost", "zdliu", "63859", "classicpolish168");
if ($db_conn->connect_error) {
$errString = "Failed to connect to the database";
echo "<br/> {$errString} ";
throw new Exception($errString);
}
tcCustomer::runTest($db_conn);
tcVisits::runTest($db_conn);
$insert1 = "INSERT INTO customers ( fname, lname, phone, email ) VALUES ( " . '"mason",' . '"you",' . '"2125187517",' . '"*****@*****.**")';
$insert2 = "INSERT INTO customers ( fname, lname, phone, email ) VALUES ( " . '"candy",' . '"liu",' . '"2125187518",' . '"*****@*****.**")';
$insert3 = "INSERT INTO customers ( fname, lname, phone, email ) VALUES ( " . '"sheryl",' . '"liu",' . '"2125187519",' . '"*****@*****.**")';
$db_conn->query($insert1);
$db_conn->query($insert2);
$db_conn->query($insert3);
$visit1a = "INSERT INTO visits ( id, points ) VALUES ( 1, " . '10 )';
$visit1b = "INSERT INTO visits ( id, points ) VALUES ( 1, " . '14 )';
$visit2a = "INSERT INTO visits ( id, points ) VALUES ( 2, " . '30 )';
$visit2b = "INSERT INTO visits ( id, points ) VALUES ( 2, " . '24 )';
$visit2c = "INSERT INTO visits ( id, points ) VALUES ( 2, " . '14 )';
$visit3a = "INSERT INTO visits ( id, points ) VALUES ( 3, " . '4 )';
$db_conn->query($visit1a);
$db_conn->query($visit1b);
$db_conn->query($visit2a);
$db_conn->query($visit2b);
$db_conn->query($visit2c);
$db_conn->query($visit3a);
$db_conn->close();
}
