function create_table($majorcode, $semester, $year)
{
$dbc = dbconnect('local');
$req_database = $majorcode . "_" . $semester . "_" . $year . "_req_courses";
$prereq_database = $majorcode . "_" . $semester . "_" . $year . "_prereq_courses";
$foundation_database = $majorcode . "_" . $semester . "_" . $year . "_foundation_courses";
$query1 = "CREATE TABLE `{$foundation_database}` (\r\n `course_id` int(11) NOT NULL AUTO_INCREMENT,\r\n `course_code` varchar(45) NOT NULL,\r\n `credit` int(11) NOT NULL,\r\n `course_name` varchar(45) NOT NULL,\r\n `course_ava` int(11) NOT NULL DEFAULT '0',\r\n `course_set` int(11) DEFAULT NULL,\r\n `is_deleted` tinyint(1) NOT NULL DEFAULT '0',\r\n `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n PRIMARY KEY (`course_id`)\r\n) ";
$query2 = "CREATE TABLE `{$prereq_database}` (\r\n `course_id` int(11) NOT NULL AUTO_INCREMENT,\r\n `req_course_code` varchar(45) NOT NULL,\r\n `course_code` varchar(45) NOT NULL,\r\n `course_name` varchar(45) NOT NULL,\r\n `credit` int(11) NOT NULL,\r\n `course_set` int(11) NOT NULL,\r\n `course_ava` int(11) NOT NULL DEFAULT '0',\r\n `is_deleted` tinyint(1) NOT NULL DEFAULT '0',\r\n `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n PRIMARY KEY (`course_id`)\r\n) ";
$query3 = "CREATE TABLE `{$req_database}` (\r\n `course_id` int(11) NOT NULL AUTO_INCREMENT,\r\n `course_code` varchar(45) NOT NULL,\r\n `credit` int(11) NOT NULL,\r\n `course_name` varchar(45) NOT NULL,\r\n `course_set` int(11) DEFAULT '0',\r\n `course_ava` int(11) NOT NULL DEFAULT '0',\r\n `is_deleted` tinyint(1) NOT NULL DEFAULT '0',\r\n `date_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,\r\n `last_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\r\n PRIMARY KEY (`course_id`)\r\n) ";
$query4 = "INSERT INTO `{$foundation_database}` (`course_id`, `course_code`, `credit`, `course_name`, `course_ava`, `course_set`) VALUES\r\n(1, 'GCIS 500', 3, 'GCIS 500', 0, 0),\r\n(2, 'GCIS 501', 3, 'GCIS 501', 0, 0),\r\n(3, 'GCIS 502', 3, 'GCIS 502', 0, 0),\r\n(4, 'GCIS 503', 3, 'GCIS 503', 0, 0),\r\n(5, 'GCIS 504', 3, 'GCIS 504', 0, 0),\r\n(6, 'GCIS 505', 3, 'GCIS 505', 0, 2),\r\n(7, 'GCIS 506', 3, 'GCIS 506', 1, 2),\r\n(9, 'GCIS 508', 3, 'GCIS 508', 2, 0),\r\n(10, 'GCIS 509', 3, 'GCIS 509', 0, 1),\r\n(11, 'GCIS 510', 3, 'GCIS 510', 1, 1);";
/*echo $query1."<br>";
echo $query2."<br>";
echo $query3."<br>";*/
echo $query4 . "<br>";
if ($dbc->query($query1) === TRUE) {
echo "1";
if ($dbc->query($query2) === TRUE) {
echo "2";
if ($dbc->query($query3) === TRUE) {
echo "3";
if ($dbc->query($query4) === TRUE) {
echo "4";
return 1;
}
}
}
} else {
echo "Error: " . $query1 . "<br>" . $dbc->error;
}
}
function NoOfMaps($fbid)
{
$con = dbconnect();
$query = "select count(*) as count from maped m,users u where u.Fuid={$fbid} and u.UID=m.userid";
$result = mysqli_query($con, $query);
return $result;
}
function dbquery()
{
global $kLastQuery, $kDBConnection;
// connect now, if haven't before
if (!$kDBConnection) {
$kDBConnection = dbconnect();
}
$args = func_get_args();
$query = call_user_func_array('dbprep', $args);
$kLastQuery = $query;
$query = preg_replace('/([^,\\(\\)\\s~]*)~[^,\\(\\)\\s]*/', '$1', $query);
// if it was a INSERT, UPDATE, or DELETE, see how many rows were affected
if (preg_match('/^INSERT|^UPDATE|^DELETE/i', $query)) {
$result = mysql_query($query) or trigger_error(dberror() . "\n\nThe query was: " . $query);
$count = mysql_affected_rows();
if ($count > 1) {
$fixquery = str_replace('%', '%%', $query);
//EWarning(EC_REALS_DATABASE, "Query affected multiple rows: $fixquery => $count",
// "Query affected " . $count . " rows");
}
} else {
// Replace ^NINSERT, ^NUPDATE, ^NDELETE with INSERT, UPDATE, DELETE
$query = preg_replace('/^N(INSERT|UPDATE|DELETE)/i', '$1', $query);
$result = mysql_query($query) or trigger_error(dberror() . "\n\nThe query was: " . $query);
}
if (preg_match('/^INSERT/i', $query)) {
return mysql_insert_id();
} elseif (preg_match('/^(UPDATE|DELETE)/i', $query)) {
return mysql_affected_rows();
} else {
return $result;
}
}
function query($query)
{
// Queries the films database with $query and returns the response
// In most cases a connection should already be initialised by the time
// any queries are run.
return dbconnect()->query($query);
}
function submitquery($sql)
{
$link = dbconnect();
$result = mysql_query($sql) or die("Error with Query: " . mysql_error() . "<br>{$sql}</br>");
mysql_close($link);
return $result;
}
function AddToDB()
{
session_start();
//start a session
$db = dbconnect();
$user_id = $_SESSION['user_id'];
//pull variables
$fullName = filter_input(INPUT_POST, 'fullName');
$email = filter_input(INPUT_POST, 'Email');
$address = filter_input(INPUT_POST, 'address');
$phone = filter_input(INPUT_POST, 'phone');
$website = filter_input(INPUT_POST, 'website');
$birthday = filter_input(INPUT_POST, 'Email');
$address_group_id = filter_input(INPUT_POST, 'addressGroup');
//prepare a query
$stmt = $db->prepare("INSERT INTO address SET user_id= :user_id, address_group_id = :address_group_id, fullname = :fullname,\r\n email = :email, address = :address, phone = :phone, website = :website, birthday = :birthday");
$binds = array(":user_id" => $user_id, ":address_group_id" => $address_group_id, ":fullname" => $fullName, ":email" => $email, ":address" => $address, ":phone" => $phone, ":website" => $website, ":birthday" => $birthday);
/*
* empty()
* isset()
*/
if ($stmt->execute($binds) && $stmt->rowCount() > 0) {
//execute query
$results = 'Data Added';
}
return $results;
//return results
}
function update_txp_lang()
{
global $txp_lang_updated, $txpcfg;
if ($re = mysql_connect('textpattern.otherwords.net', 'textpattern_user', 'textpattern')) {
if (mysql_select_db('textpattern_master', $re)) {
if ($q = mysql_query("select unix_timestamp(updated) from \n\t\t\t\t\t\ttextpattern_master.update where\n\t\t\t\t\t\t`table`='txp_lang'", $re)) {
$updated = mysql_num_rows($q) != 0 ? mysql_result($q, 0) : false;
if ($updated > $txp_lang_updated) {
if ($get = mysql_query("select * from \n\t\t\t\t\t\t\t\ttextpattern_master.txp_lang order by var")) {
if (mysql_num_rows($get) > 0) {
while ($a = mysql_fetch_assoc($get)) {
$incoming[] = $a;
}
mysql_close($re);
}
if (!empty($incoming)) {
dbconnect($txpcfg['db'], $txpcfg['user'], $txpcfg['pass'], $txpcfg['host']);
safe_query("truncate txp_lang");
foreach ($incoming as $b) {
extract(doSlash($b));
safe_query("\n\t\t\t\t\t\t\t\t\t\tinsert into txp_lang set \n\t\t\t\t\t\t\t\t\t\tvar='{$var}',english='{$english}'");
}
safe_query("update txp_prefs set val= \t\n\t\t\t\t\t\t\t\t\t" . time() . "\n\t\t\t\t\t\t\t\t\twhere `name`='txp_lang_updated'", 1);
echo mysql_error();
}
}
}
}
}
}
}
function isItemInDB($itemToCheck, $keyToCheck, $dbSheetToCheck)
{
$db = dbconnect();
//get list of sites to compare with site entered
$stmt = $db->prepare("SELECT * FROM {$dbSheetToCheck}");
$contentsOfDB = array();
$newArrayToCheck = array();
if ($stmt->execute() && $stmt->rowCount() > 0) {
$contentsOfDB = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
// //print entire array with keys for testing purposes
// $keys = array_keys($contentsOfDB);
// for($i = 0; $i < count($contentsOfDB); $i++)
// {
// echo $keys[$i] . "{<br>";
// foreach($contentsOfDB[$keys[$i]] as $key => $value)
// {
// echo $key . " : " . $value . "<br>";
// }
// echo "}<br>";
// }
for ($i = 0; $i < count($contentsOfDB); $i++) {
$newArrayToCheck[$i] = $contentsOfDB[$i][$keyToCheck];
}
if (in_array($itemToCheck, $newArrayToCheck) == false) {
return false;
} else {
return true;
}
}
function set_start($idx)
{
global $URL, $pn;
$dbh = dbconnect();
$query = "select poll_idx,status from poll_data where poll_idx={$idx}";
$sth = dbquery($dbh, $query);
list($poll_idx, $edate) = dbselect($sth);
if (!$poll_idx) {
print_alert("존재하지 않는 데이터입니다. ", 'back');
exit;
} elseif ($status == 1) {
print_alert("현재 설문중입니다. ", 'back');
exit;
}
/* 설문 재개 */
$query = "update poll_data set status='1' where poll_idx={$idx}";
$sth = dbquery($dbh, $query);
if (!$sth) {
$msg = "에러가 발생하였습니다.<br><br>\n" . mysql_error();
print_message($msg);
} else {
header("Location: {$URL['list']}?pn={$pn}");
exit;
}
dbclose($dbh);
exit;
}
function productInWinkelwagen($product_id, $aantal)
{
include 'connector.php';
$db = dbconnect();
$query = "INSERT INTO WinkelwagenInhoud(product_id, aantal) VALUES({$product_id}, {$aantal});";
$result = mysql_query($query);
return $result;
}
function Elimina($idoc)
{
$db = dbconnect();
$sqldel = "delete from productos where idoc=:id";
$querydel = $db->prepare($sqldel);
$querydel->bindParam(':id', $idoc);
$valaux = $querydel->execute();
return $valaux;
}
function cargaMenuPorPerfil()
{
$db = dbconnect();
$query = "SELECT nombre_menu, destino_menu FROM " . $this->tabla . " WHERE id_perfil =:perfil";
$stmt = $db->prepare($query);
$stmt->bindParam(':perfil', $this->nid_perfil);
$stmt->execute();
return $stmt;
}
function dbcheck($config)
{
try {
dbconnect($config);
return true;
} catch (PDOException $e) {
return false;
}
}
function fetchGroups()
{
$db = dbconnect();
$stmt = $db->prepare("SELECT * from address_groups");
if ($stmt->execute() && $stmt->rowCount() > 0) {
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
return $results;
}
function updateMessage()
{
$id = $_GET['id'];
$title = $_POST['title'];
$content = $_POST['content'];
$query = "UPDATE `message` SET `title`='{$title}',`content`='{$content}' WHERE `id` = {$id}";
mysqli_query(dbconnect(), $query);
header('location:index.php');
}
function updateUser()
{
$id = $_GET['id'];
$name = $_POST['name'];
$email = $_POST['email'];
$query = "UPDATE `users` SET `name`='{$name}',`email`='{$email}' WHERE `id` = {$id}";
mysqli_query(dbconnect(), $query);
header('location:index.php');
}
function createProduct($category_id, $product, $price, $image)
{
$db = dbconnect();
$stmt = $db->prepare("INSERT INTO products SET category_id = :category_id, product = :product, price = :price, image = :image ");
$binds = array(":category_id" => $category_id, ":product" => $product, ":price" => $price, ":image" => $image);
if ($stmt->execute($binds) && $stmt->rowCount() > 0) {
return true;
}
return false;
}
function sortDatabase($column, $order)
{
$db = dbconnect();
$stmt = $db->prepare("SELECT * FROM corps ORDER BY {$column} {$order}");
$results = array();
if ($stmt->execute() && $stmt->rowCount() > 0) {
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
return $results;
}
function createContact($newData)
{
$db = dbconnect();
$stmt = $db->prepare("INSERT INTO address SET user_id = :user_id, address_group_id = :address_group_id, fullname = :fullname, email = :email, address = :address, phone = :phone, website = :website, birthday = :birthday, image = :image ");
$binds = array(":user_id" => $newData[0], ":address_group_id" => $newData[1], ":fullname" => $newData[2], ":email" => $newData[3], ":address" => $newData[4], ":phone" => $newData[5], ":website" => $newData[6], ":birthday" => $newData[7], ":image" => $newData[8]);
if ($stmt->execute($binds) && $stmt->rowCount() > 0) {
return true;
}
return false;
}
function getAllContacts()
{
$db = dbconnect();
$stmt = $db->prepare("SELECT * FROM address JOIN address_groups WHERE address_groups.address_group_id = address.address_group_id");
$results = array();
if ($stmt->execute() && $stmt->rowCount() > 0) {
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
return $results;
}
function getAllCategories()
{
$db = dbconnect();
$stmt = $db->prepare("SELECT * FROM categories ORDER BY category_id");
$results = array();
if ($stmt->execute() && $stmt->rowCount() > 0) {
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
return $results;
}
function getAllPhone()
{
$db = dbconnect();
$stmt = $db->prepare("SELECT * FROM phone");
$results = array();
if ($stmt->execute() && $stmt->rowCount() > 0) {
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
return $results;
}
function getGroups()
{
//get all of the address groups
$db = dbconnect();
$stmt = $db->prepare("SELECT * FROM address_groups");
if ($stmt->execute() && $stmt->rowCount() > 0) {
$results = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
return $results;
}
function Elimina($id)
{
$db = dbconnect();
/*Definición del query que permitira eliminar un registro*/
$sqldel = "delete from productos where idproducto=:id";
/*Preparación SQL*/
$querydel = $db->prepare($sqldel);
$querydel->bindParam(':id', $id);
$valaux = $querydel->execute();
return $valaux;
}
function updateRow($id, $address_group_id, $fullname, $email, $address, $phone, $website, $birthday, $image)
{
$db = dbconnect();
$stmt = $db->prepare("UPDATE address SET address_group_id = :address_group_id, fullname = :fullname, email = :email, address = :address, phone = :phone, website = :website, birthday = :birthday, image = :image WHERE address_id = :address_id");
$binds = array(":address_id" => $id, ":address_group_id" => $address_group_id, ":fullname" => $fullname, ":email" => $email, ":address" => $address, ":phone" => $phone, ":website" => $website, ":birthday" => $birthday, ":image" => $image);
if ($stmt->execute($binds) && $stmt->rowcount() > 0) {
return true;
} else {
return false;
}
}
function deleteAddress($existingAddressID)
{
$db = dbconnect();
$stmt = $db->prepare("DELETE FROM address where address_id = :dropAddress");
$binds = array(":dropAddress" => $existingAddressID);
if ($stmt->execute($binds) && $stmt->rowCount() > 0) {
return true;
} else {
return false;
}
}
function deleteRow($id)
{
$db = dbconnect();
$stmt = $db->prepare("DELETE FROM address WHERE address_id = :address_id");
$binds = array(":address_id" => $id);
if ($stmt->execute($binds) && $stmt->rowcount() > 0) {
return true;
} else {
return false;
}
}
function getPrice($id)
{
$db = dbconnect();
$stmt = $db->prepare("SELECT price FROM products WHERE product_id = :product_id");
$binds = array(":product_id" => $id);
$results = array();
if ($stmt->execute($binds) && $stmt->rowCount() > 0) {
$results = $stmt->fetch(PDO::FETCH_ASSOC);
}
return $results;
}
function createNewAcct($emailNew, $passNew)
{
$db = dbconnect();
$stmt = $db->prepare("INSERT INTO users SET :user_id = user_id");
$passNew = sha1($passNew);
$binds = array(":email" => $emailNew, ":password" => $passNew);
if ($stmt->execute($binds) && $stmt->rowCount() > 0) {
return true;
}
return false;
}
function getProduct($id)
{
$db = dbconnect();
$stmt = $db->prepare("SELECT * FROM products JOIN categories WHERE categories.category_id = products.category_id AND product_id = :product_id");
$binds = array(":product_id" => $id);
$results = array();
if ($stmt->execute($binds) && $stmt->rowCount() > 0) {
$results = $stmt->fetch(PDO::FETCH_ASSOC);
}
return $results;
}
