Пример #1
0
function dbConnection()
{
    $rConnection = mysqli_connect(gServerName, gUserName, gPassword);
    if (!$rConnection) {
        $msg = "Error :- Couldn't connected mysqli";
        comment_message_log($msg . " in Function :" . __FUNCTION__ . " File: " . __FILE__ . " on line: " . __LINE__);
        return E00010;
    }
    if (!mysqli_select_db($rConnection, gDatabase)) {
        $msg = "Error :- Couldn't Select The Database " . gDatabase;
        comment_message_log($msg . " in Function :" . __FUNCTION__ . " File: " . __FILE__ . " on line: " . __LINE__);
        return E00010;
    }
    return $rConnection;
}
function getAlldetails($id, $lat, $lng)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "SELECT * FROM `servicesubcatrelation` a,`ownerservice` b,`servicebranch` c WHERE a.sub_category_id={$id} and a.service_id=b.service_id and b.service_id=c.service_id ";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        $data = array();
        //! retrieve the result from the result set
        while ($aRow = mysqli_fetch_assoc($res)) {
            if (distance($lat, $aRow['branch_lat'], $lng, $aRow['branch_lng']) < 300) {
                $data[] = $aRow;
            }
        }
        //! Closing the connections
        dbConnectionClose($rConnection);
        //! Message Login
        comment_message_log('Query Executed Successfully.::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
        return $data;
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}
Пример #3
0
function aGetUserbyPass($user, $pass)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "SELECT * FROM `admin` where `email` = '{$user}' AND `password` = '{$pass}';";
    //! Executing the query
    $rResultSet = mysqli_query($rConnection, $sQuery);
    //! Closing the connections
    dbConnectionClose($rConnection);
    /*!
     *  Check If the Query executed properly
     */
    if ($rResultSet != '') {
        //! Message Login
        comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
        $aData = array();
        //! retrieve the result from the result set
        while ($aRow = mysqli_fetch_assoc($rResultSet)) {
            $aData = $aRow;
        }
        comment_message_log('End of Function : ' . __FUNCTION__);
        return $aData;
    } else {
        //! Message Loggin
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00100;
    }
}
function insertintofreeservicedb($owner_id, $branch_id, $frees_name, $free_description, $counter, $created_at, $validity)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "INSERT INTO `freeservicedb` (`id`,`owner_id`, `branch_id`,`free_name` ,`free_description`,`counter`,`timestamp`,`validity`) VALUES (NULL, '{$owner_id}', '{$branch_id}','{$free_name}','{$free_description}','{$counter}', '{$created_at}','{$validity}');";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        $id = mysqli_insert_id($rConnection);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return $id;
        //! Message Login
        comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}
function insertintosingleent($owner_id, $category_id, $ent_name, $ent_details, $ent_website, $isActive, $listingType, $ProvidesFreeSrvc, $premiumStartDate, $premiumEndDate, $amount_paid, $created_at)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "INSERT INTO `servicebranch` (`ent_id`,`owner_id`,`category_id`,`ent_name`,`ent_details`,`ent_website`,`isActive` ,`listingType` ,`ProvidesFreeSrvc` ,`premiumStartDate` ,`premiumEndDate`,`amt_paid`,`timeStamp`) VALUES (NULL, '{$owner_id}', '{$category_id}','{$ent_name} ','{$ent_details}','{$ent_website}','{$isActive}' ,'{$listingType}' ,'{$ProvidesFreeSrvc}' ,'{$premiumStartDate}' ,'{$premiumEndDate}','{$amount_paid} ','{$created_at}');";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        $ent_id = mysqli_insert_id($rConnection);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return $ent_id;
        //! Message Login
        comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}
function insertintoservicesused($user_id, $service_id, $single_id, $freeserivce_id, $created_at)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "INSERT INTO `services_used` (`id`,`user_id`,`service_id`, `singleent_id`,`freeservice_id` `timeStamp`) VALUES (NULL, '{$user_id}','{$service_id}','{$single_id}','{$freeservice_id}' ,'{$created_at}');";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        $user_id = mysqli_insert_id($rConnection);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return $user_id;
        //! Message Login
        comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}
function insertintoownerapp($owner_name, $owner_email, $service_mobile_num, $password, $created_at, $isActive, $type)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "INSERT INTO `ownerapp` (`owner_id`,`owner_name`, `owner_email`, `service_mobile_number`, `password`, `timeStamp`,`isActive`,`type`) VALUES (NULL, '{$owner_name}','{$owner_email}','{$service_mobile_num}','{$password}','{$created_at}','{$isActive}','{$type}');";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        $owner_id = mysqli_insert_id($rConnection);
        //! Closing the connections
        dbConnectionClose($rConnection);
        //! Message Login
        comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
        return $owner_id;
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}
function insertintoservicesubcatrelation($service_id, $ent_id, $free_id, $subcategory_id)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "INSERT INTO `servicesubcatrelation` (`service_id`,`ent_id`,`free_id`,`sub_category_id`) VALUES ('{$service_id}','{$ent_id}','{$free_id}','{$subcategory_id}');";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        mysqli_insert_id($rConnection);
        //! Closing the connections
        dbConnectionClose($rConnection);
        //! Message Login
        comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}
Пример #9
0
function insertintofriend($name, $data)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "INSERT INTO `friend_list` (`user_id`,`friend_name`) VALUES ('{$data}', '{$name}');";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        mysqli_insert_id($rConnection);
        //! Closing the connections
        dbConnectionClose($rConnection);
        //! Message Login
        comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}
Пример #10
0
function getAllfriendservices($id)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "SELECT * FROM `friend_list` a,`user` b,`services_used` c WHERE a.user_id={$id} and b.full_name=a.friend_name and c.user_id=b.user_id";
    //! Executing the query
    $rResultSet = mysqli_query($rConnection, $sQuery);
    //! Closing the connections
    dbConnectionClose($rConnection);
    /*!
     *  Check If the Query executed properly
     */
    if ($rResultSet != '') {
        //! Message Login
        comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
        $aData = array();
        //! retrieve the result from the result set
        while ($aRow = mysqli_fetch_assoc($rResultSet)) {
            $aData[] = $aRow;
        }
        comment_message_log('End of Function : ' . __FUNCTION__);
        return $aData;
    } else {
        //! Message Loggin
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00100;
    }
}
Пример #11
0
function aGetAllTags()
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "SELECT * FROM `interests` ORDER BY `id` DESC;";
    //! Executing the query
    $rResultSet = mysqli_query($rConnection, $sQuery);
    //! Closing the connections
    dbConnectionClose($rConnection);
    /*!
     *  Check If the Query executed properly
     */
    if ($rResultSet != '') {
        //! Message Login
        comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
        $aData = array();
        //! retrieve the result from the result set
        while ($aRow = mysqli_fetch_assoc($rResultSet)) {
            $aData[] = $aRow;
        }
        comment_message_log('End of Function : ' . __FUNCTION__);
        return $aData;
    } else {
        //! Message Loggin
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00100;
    }
}
Пример #12
0
function updatefreeservice_id($freeservice_id, $rating)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "UPDATE `freeservicedb` SET `avg_rating`='{$rating}' WHERE `id`='{$freeservice_id}'";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        //! Closing the connections
        dbConnectionClose($rConnection);
        return $rating_id;
        //! Message Login
        comment_message_log('Query Executed Successfully.::: owner_id = $owner_id ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}
function searchinservice($string)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "SELECT `service_id`,`service_name` FROM `ownerservice` WHERE `service_name` OR `service_details` LIKE '%{$string}%'";
    //! Executing the query
    $rResultSet = mysqli_query($rConnection, $sQuery);
    //! Closing the connections
    dbConnectionClose($rConnection);
    /*!
     *  Check If the Query executed properly
     */
    if ($rResultSet != '') {
        //! Message Login
        comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
        $aData = array();
        //! retrieve the result from the result set
        while ($aRow = mysqli_fetch_assoc($rResultSet)) {
            $aData[] = $aRow;
        }
        comment_message_log('End of Function : ' . __FUNCTION__);
        return $aData;
    } else {
        //! Message Loggin
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00100;
    }
}
Пример #14
0
function addintofriendlist($user_id, $friend)
{
    //! Message Loggin
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "INSERT INTO `friend_list` (`user_id`,`friend_name`) VALUES ('{$user_id}','{$friend_name}');";
    //! Executing the query
    $rResultSet = mysqli_query($rConnection, $sQuery);
    //! Closing the connections
    dbConnectionClose($rConnection);
    /*!
     *  Check If the Query executed properly
     */
    if ($rResultSet != '') {
        //! Message Login
        comment_message_log('Query Executed Successfully. ::: ' . $sQuery);
        //! retrieve the result from the result set
        comment_message_log('End of Function : ' . __FUNCTION__);
        return 1;
    } else {
        //! Message Loggin
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00100;
    }
}
function iUpdatesubCats($sub_category_id, $category_id, $subcategoryname, $showinapp)
{
    comment_message_log('Start of Function : ' . __FUNCTION__);
    //! Data base connection
    $rConnection = dbConnection();
    /*!
     * Check if the database Connection is failed
     */
    if (!$rConnection) {
        //! Message Loggin
        comment_message_log('End of Function : ' . __FUNCTION__);
        return E00010;
    }
    //! Query
    $sQuery = "UPDATE sub_category SET `category_id` = '{$category_id}' , `sub_category_name` = '{$subcategoryname}',`show_in_app` = '{$showinapp}' WHERE `sub_category_id` = '{$sub_category_id}' ";
    //! Executing the query
    $res = mysqli_query($rConnection, $sQuery);
    /*!
     * Check If the Query executed properly
     */
    if ($res) {
        //! Closing the connections
        dbConnectionClose($rConnection);
        //! Message Login
        comment_message_log('Query Executed Successfully.::: id = $iId ::: ' . $sQuery);
        comment_message_log('End of Function : ' . __FUNCTION__);
    } else {
        comment_message_log('Query Execution failed. ::: ' . $sQuery . ' ::: ' . @mysqli_error($rConnection));
        comment_message_log('End of Function : ' . __FUNCTION__);
        //! Closing the connections
        dbConnectionClose($rConnection);
        return E00100;
    }
}