<?php

function getTitle(){

global $pageTitle;

if (isset($pageTitle)) {

    echo $pageTitle;
} else{
    echo 'Default';
}
}

/*Count projects Admin*/
function allrow($select, $from, $where, $whereres){

    global $conn;
    $statment = $conn->prepare("SELECT $select FROM $from WHERE $where = $whereres");

    $statment->execute(array());

    $count = $statment->rowcount();

    return $count;

}

function allrow2($select, $from){

    global $conn;
    $statment = $conn->prepare("SELECT $select FROM $from ");

    $statment->execute(array());

    $count = $statment->rowcount();

    return $count;

}

// get city For Calculate  Building Costs
function getcitycalc() {

    global $conn;

    $get = $conn->prepare("SELECT  * FROM citycostscalc  ORDER BY citcalc_ordernum ");

    $get->execute();

    $info = $get->fetchAll();

    return $info;
}

// get city For Calculate  Building Costs
function actgetcitycalc() {

    global $conn;

    $get = $conn->prepare("SELECT  * FROM citycostscalc WHERE citcalc_active = 1  ORDER BY citcalc_ordernum ");

    $get->execute();

    $info = $get->fetchAll();

    return $info;
}