<<<<<<< HEAD
<?php
include 'template/header.php';
include 'template/menu.php';
include 'inc/functions.php';
$link = get_database_connection();
$db_connect = get_database_connection();
mysqli_select_db($db_connect, $DBNAME) or die("cannot select DB");
$sql = mysqli_query($db_connect, "SELECT * FROM tbl_admin_user WHERE id = '1' ");
while ($row = mysqli_fetch_assoc($sql)) {
var_dump($row);
}
echo "####>>" . mysqli_insert_id($db_connect);
/*$bundle = mysqli_fetch_assoc($sql);
var_dump($bundle);*/
/*$all_fish_bundle = all_bundle();
if(!empty($_GET['confirm'])){
if($_GET['confirm']=='confirm')
$message = "Your order has been confirmed.We will contact soon..";
if($_GET['confirm']=='error')
$errormessage = "Something wrong.Please Try again!!";
}*/
?>
function update_employe($employe_id, $name, $designation, $department, $sex, $phone, $address, $join_date)
{
global $DBNAME;
$db_connect = get_database_connection();
mysqli_select_db($db_connect, $DBNAME) or die("cannot slect DB");
$address = input_text_validation($address);
$now = date('Y-m-d H:i:s');
$sql = mysqli_query($db_connect, "UPDATE " . EMPLOYE . " SET name='{$name}', designation='{$designation}', department= '{$department}', sex= '{$sex}', phone = '{$phone}', address = '{$address}', join_date= '{$join_date}', updated_at = '{$now}' WHERE id = '{$employe_id}' ");
if ($sql) {
return 1;
} else {
return 0;
}
}
function custom_bundle_create($element, $item_counter)
{
global $DBNAME;
$db_connect = get_database_connection();
mysql_select_db($DBNAME) or die("cannot slect DB");
$sql = mysql_query("SELECT id,fish_code, fish_name FROM tbl_fishes");
$bundle_weight = 0;
$bundle_price = 0;
for ($i = 1; $i <= $item_counter; $i++) {
$bundle_element[] = array('fish_id' => $element[$i][1], 'weight' => $element[$i][2]);
$fish_id = $element[$i][1];
$weight = $element[$i][2];
$sql = mysql_query("SELECT unit_price FROM tbl_fishes WHERE id= '{$fish_id}'");
$row = mysql_fetch_assoc($sql);
$bundle_weight = $bundle_weight + $weight;
$bundle_price = $bundle_price + $weight * $row['unit_price'];
}
$bundle_name = "Custom Order";
$bundle_image_url = "";
$bundle_element = serialize($bundle_element);
$quantity = $item_counter;
$sql = mysql_query("INSERT INTO tbl_fish_bundles (bundle_name, bundle_element, bundle_price , bundle_weight,quantity,bundle_image_url ) VALUES ('{$bundle_name}', '{$bundle_element}', '{$bundle_price}', '{$bundle_weight}','{$quantity}','{$bundle_image_url}')");
if ($sql) {
return mysql_insert_id();
} else {
return false;
}
}
<?php
if (!defined("allow_inc")) {
die("You can't access this file directly.");
}
session_start();
$dbc = get_database_connection();
$user = false;
$profile = true;
$page = "page_home.php";
if (isset($_SESSION["user"])) {
if ($query = $dbc->query("SELECT * FROM `users` LEFT JOIN `profiles` ON `users`.`uid` = `profiles`.`uid` WHERE `users`.`uid` = '{$_SESSION["user"]}'")) {
if ($row = $query->fetch_assoc()) {
$user = $row;
if ($user["uid"] === NULL) {
// this means the user profile is not set up
$user["uid"] = $_SESSION["user"];
$profile = false;
}
}
}
}
if (isset($_GET["page"])) {
$page = "page_" . $_GET["page"] . ".php";
}
if (!file_exists($page)) {
$page = "page_notfound.php";
}
// US States
$us_states = array("AL" => "Alabama", "AK" => "Alaska", "AZ" => "Arizona", "AR" => "Arkansas", "CA" => "California", "CO" => "Colorado", "CT" => "Connecticut", "DE" => "Delaware", "DC" => "District of Columbia", "FL" => "Florida", "GA" => "Georgia", "HI" => "Hawaii", "ID" => "Idaho", "IL" => "Illinois", "IN" => "Indiana", "IA" => "Iowa", "KS" => "Kansas", "KY" => "Kentucky", "LA" => "Louisiana", "ME" => "Maine", "MD" => "Maryland", "MA" => "Massachusetts", "MI" => "Michigan", "MN" => "Minnesota", "MS" => "Mississippi", "MO" => "Missouri", "MT" => "Montana", "NE" => "Nebraska", "NV" => "Nevada", "NH" => "New Hampshire", "NJ" => "New Jersey", "NM" => "New Mexico", "NY" => "New York", "NC" => "North Carolina", "ND" => "North Dakota", "OH" => "Ohio", "OK" => "Oklahoma", "OR" => "Oregon", "PA" => "Pennsylvania", "RI" => "Rhode Island", "SC" => "South Carolina", "SD" => "South Dakota", "TN" => "Tennessee", "TX" => "Texas", "UT" => "Utah", "VT" => "Vermont", "VA" => "Virginia", "WA" => "Washington", "WV" => "West Virginia", "WI" => "Wisconsin", "WY" => "Wyoming");
function isPosted()
/**
* Sets the supplied module_id completed/open based on $flag.
* Must be validated.
*
* @param $module_id
* @param $flag
*/
function set_completed_flag_on_module($module_id, $flag)
{
$db = get_database_connection();
$sth = $db->prepare('UPDATE user_module SET completed = ? WHERE module_id = ? AND user_id = ?');
$sth->execute([$flag, $module_id, CURRENT_USER_ID]);
if (!$sth->rowCount()) {
$sth = $db->prepare('INSERT INTO user_module SET completed = ?, module_id = ?, user_id = ?');
$sth->execute([$flag, $module_id, CURRENT_USER_ID]);
}
}
function delete_category($category_id)
{
global $DBNAME;
$db_connect = get_database_connection();
mysqli_select_db($db_connect, $DBNAME) or die("Cannot select DB");
$sql = mysqli_query($db_connect, "DELETE FROM tbl_categories WHERE category_id = {$category_id}");
if ($sql) {
return 1;
} else {
return 0;
}
}