function BuildDBandTables($db) { $con = OpenServerConnection(); // create the database if (!mysql_query("CREATE DATABASE IF NOT EXISTS {$db}", $con)) { echo "Error creating database: " . mysql_error(); } // create each table $result = mysql_select_db($db, $con); if (!$result) { die('Cannot connect to DB: ' . mysql_error()); } $emp = "CREATE TABLE IF NOT EXISTS employees\n (\n id int(11) NOT NULL AUTO_INCREMENT,\n first_name varchar(100),\n last_name varchar(100),\n time_added date,\n time_deleted date,\n PRIMARY KEY(id)\n )"; $proj = "CREATE TABLE IF NOT EXISTS projects\n (\n id int(11) NOT NULL AUTO_INCREMENT,\n project_name varchar(100),\n client_id int(11),\n current_status varchar(100),\n time_added date,\n time_deleted date,\n PRIMARY KEY(id)\n )"; $hours = "CREATE TABLE IF NOT EXISTS hours\n (\n id int(11) NOT NULL AUTO_INCREMENT,\n employee_id int(11),\n project_id int(11),\n task_date date,\n num_hours float(11,2),\n task_description varchar(255),\n time_added date,\n time_deleted date,\n PRIMARY KEY(id)\n )"; $cust = "CREATE TABLE IF NOT EXISTS clients\n (\n id int(11) NOT NULL AUTO_INCREMENT,\n client_name varchar(255),\n contact_name varchar(255),\n phone varchar(100),\n street varchar(255),\n city varchar(255),\n state varchar(2),\n zip char(10),\n time_added date,\n time_deleted date,\n PRIMARY KEY(id)\n )"; // execute each query mysql_query($emp, $con); mysql_query($proj, $con); mysql_query($hours, $con); mysql_query($cust, $con); // close the connection to the server mysql_close($con); }
<?php /* ****************************************************** addClient.php Tracks clients and their contact information Part of the Super Basic Small Business Tracker Created by Raquel Vélez ****************************************************** */ include "globals.php"; $con = OpenServerConnection(); date_default_timezone_set('America/New_York'); $timeAdded = date('Y-m-d H:i:s'); $client = mysql_real_escape_string($_GET['client']); $contact = mysql_real_escape_string($_GET['contact']); $phone = mysql_real_escape_string($_GET['phone']); $street = mysql_real_escape_string($_GET['street']); $city = mysql_real_escape_string($_GET['city']); $state = mysql_real_escape_string($_GET['state']); $zip = mysql_real_escape_string($_GET['zip']); mysql_select_db($db_name, $con); mysql_query("INSERT INTO clients(client_name, contact_name, phone, street, city, state, zip, time_added)\n VALUES('{$client}', '{$contact}', '{$phone}', '{$street}', '{$city}', '{$state}', '{$zip}', '{$timeAdded}')"); echo '<META HTTP-EQUIV="Refresh" Content="0; URL=start.php">'; mysql_close($con);