function addPage($page_title, $page_meta_title, $page_meta_description, $page_meta_keywords, $page_content, $show_on_page, $section_type) { $dbobj = new Cdb(SERVER, DBNAME, DBUSER, DBPASS); $dbobj->connectDB(); $maxqry = $dbobj->getCellFromDB("max(sortOrder)", "contentspagetemplate", "1=1"); $sort_order = $maxqry + 1; $dbobj->writeToDB("(SectionID, PageTitle, PageMetaTitle, PageMetaDescription, PageMetaKeywords, PageContents, showOnPage, sortOrder )VALUES('{$section_type}', '{$page_title}', '{$page_meta_title}', '{$page_meta_description}', '{$page_meta_keywords}','" . nl2br($page_content) . "', '{$show_on_page}', '{$sort_order}')", "contentspagetemplate"); $dbobj->disconnectDB(); }
function checkUser() { $dbObj = new Cdb(SERVER, DBNAME, DBUSER, DBPASS); $dbObj->connectDB(); $data = $dbObj->getCellFromDB("UserName", "customers", "UserName='******'txtusrname']}' or UserEmail = '{$_REQUEST['txtusrname']}'"); if ($data) { $msasdg = 'yes'; } else { $msasdg = ''; } return $msasdg; }