Reply to thread

Message

<blockquote data-quote="Detox" data-source="post: 460836" data-attributes="member: 596">Hello!I need some professionals help on this and Im puzzled.So I'm trying to re-create HoloCMS housekeeping Theme with BrainCMS and I know Brain is poorly coded but this is just for educational purpose. Once I get the assistance I'm looking for from this community. I am planing on releasing all my work to community as there is lot of new beginners.Anyways with that being said let's begin.So what matter what code I use, its not updating into the database and I'm puzzled. It's all here to look at.Modified Code:All of this is currently in my class.admin.php[CODE=php]function checkMaintenance()&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; global $dbh;&nbsp; &nbsp; &nbsp; &nbsp; if (isset($_POST['checkMaintenance']))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $siteMode = $_POST['site_closed'];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $checkMaintenance = $dbh-&gt;prepare(&quot;UPDATE cms_site SET siteMode=:site_closed&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $checkMaintenance-&gt;bindParam();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $checkMaintenance-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($checkMaintenance) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Admin::succeed(&quot;Maintenance Mode Enabled&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }[/CODE][CODE=php]public static function siteMode()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $dbh;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (isset($_POST['siteMode']))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!empty($_POST['siteMode']))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!empty($_POST['siteMode']))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $closedSite = $dbh-&gt;prepare(&quot;UPDATE cms_site(site_closed)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; VALUES&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; :site_closed&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $closedSite-&gt;bindParam(':site_closed', $_POST['site_closed']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $closedSite-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Admin::succeed(&quot;Site Closed?&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Admin::error(&quot;Fuc*ing Messed Up&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }[/CODE][CODE=php]public static function UpdateSite()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; global $dbh;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (isset($_POST['update']))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $updateSite = $dbh-&gt;prepare(&quot;UPDATE cms_site SET&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; site_closed=:site_closed,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHERE site_closed = :site_closed&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $updateSite-&gt;bindParam(':site_closed', $_POST['site_closed']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $updateSite-&gt;execute();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Admin::succeed(&quot;I highly doubt this updated the database&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]Here is my sitesettings.php[CODE=php]&lt;?php&nbsp; &nbsp; include_once &quot;includes/head.php&quot;;&nbsp; &nbsp; include_once &quot;includes/header.php&quot;;&nbsp; &nbsp; //include_once &quot;includes/navi.php&quot;;?&gt;&lt;table cellpadding='0' cellspacing='8' width='100%' id='tablewrap'&gt;&lt;tr&gt; &lt;td width='22%' valign='top' id='leftblock'&gt;&lt;div&gt;&lt;!-- LEFT CONTEXT SENSITIVE MENU --&gt;&lt;?php include_once('includes/sitenavi.php'); ?&gt;&lt;!-- / LEFT CONTEXT SENSITIVE MENU --&gt;&lt;/div&gt;&lt;/td&gt;&lt;td width='78%' valign='top' id='rightblock'&gt;&lt;div&gt;&lt;!-- RIGHT CONTENT BLOCK --&gt;&lt;form action=&quot;&quot; method='POST' name='theAdminForm' id='theAdminForm'&gt;&lt;div class='tableborder'&gt;&lt;div class='tableheaderalt'&gt;Turn your site on/off&lt;/div&gt;&lt;?php admin::updateSite(); ?&gt;&lt;table width='100%' cellspacing='0' cellpadding='5' align='center' border='0'&gt;&lt;tr&gt;&lt;td class='tablerow1'&nbsp; width='40%'&nbsp; valign='middle'&gt;&lt;b&gt;Close Site&lt;/b&gt;&lt;div class='graytext'&gt;If enabled, your site will be closed and show a maintenance page to regular users. Administrators can still login through Housekeeping.&lt;/div&gt;&lt;/td&gt;&lt;td class='tablerow2'&nbsp; width='60%'&nbsp; valign='middle'&gt;&nbsp; &nbsp; &lt;select name=&quot;update&quot;&nbsp; class='dropdown'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option name=&quot;siteMode&quot; value='open'&gt;Site Open&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option name=&quot;siteMode&quot; value='closed'&gt;Site Closed&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;tr&gt;&lt;td align='center' class='tablesubheader' colspan='2' &gt;&lt;input type='submit' value='Apply' class='realbutton' accesskey='s'&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/form&gt;&lt;/table&gt;&lt;/div&gt;&lt;br /&gt;&nbsp; &nbsp;&nbsp; &lt;/div&gt;&lt;!-- / RIGHT CONTENT BLOCK --&gt;&nbsp; &nbsp;&nbsp; &lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;&lt;/div&gt;&lt;!-- / OUTERDIV --&gt;&lt;div align='center'&gt;&lt;br /&gt;&lt;?php$mtime = explode(' ', microtime());$totaltime = $mtime[0] + $mtime[1] - $starttime;printf('Time: %.3f', $totaltime);?&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; include_once &quot;includes/footer.php&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; include_once &quot;includes/script.php&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [/CODE]And yes to change the respect name class and in this following section of the code.[CODE=php] &lt;select name=&quot;update&quot;&nbsp; class='dropdown'&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option name=&quot;siteMode&quot; value='open'&gt;Site Open&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;option name=&quot;siteMode&quot; value='closed'&gt;Site Closed&lt;/option&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/select&gt;[/CODE]Here is the MySQL structure Im using.[ATTACH=full]10810[/ATTACH]UPDATE:I almost forgot. I do change the respect code for the function as well. [CODE=php]&lt;?php admin::updateSite(); ?&gt;[/CODE]</blockquote>

[QUOTE="Detox, post: 460836, member: 596"] Hello! I need some professionals help on this and Im puzzled. So I'm trying to re-create HoloCMS housekeeping Theme with BrainCMS and I know Brain is poorly coded but this is just for educational purpose. Once I get the assistance I'm looking for from this community. I am planing on releasing all my work to community as there is lot of new beginners. Anyways with that being said let's begin. So what matter what code I use, its not updating into the database and I'm puzzled. It's all here to look at. Modified Code: All of this is currently in my class.admin.php [CODE=php]function checkMaintenance() { global $dbh; if (isset($_POST['checkMaintenance'])) { $siteMode = $_POST['site_closed']; } $checkMaintenance = $dbh->prepare("UPDATE cms_site SET siteMode=:site_closed"); $checkMaintenance->bindParam(); $checkMaintenance->execute(); if ($checkMaintenance) { Admin::succeed("Maintenance Mode Enabled"); } }[/CODE] [CODE=php]public static function siteMode() { global $dbh; if (isset($_POST['siteMode'])) { if (!empty($_POST['siteMode'])) { if (!empty($_POST['siteMode'])) { $closedSite = $dbh->prepare("UPDATE cms_site(site_closed) VALUES ( :site_closed )"); $closedSite->bindParam(':site_closed', $_POST['site_closed']); $closedSite->execute(); Admin::succeed("Site Closed?"); } else { Admin::error("Fuc*ing Messed Up"); return; } } } }[/CODE] [CODE=php]public static function UpdateSite() { global $dbh; if (isset($_POST['update'])) { $updateSite = $dbh->prepare("UPDATE cms_site SET site_closed=:site_closed, WHERE site_closed = :site_closed"); $updateSite->bindParam(':site_closed', $_POST['site_closed']); $updateSite->execute(); Admin::succeed("I highly doubt this updated the database"); } }[/CODE] Here is my sitesettings.php [CODE=php]<?php include_once "includes/head.php"; include_once "includes/header.php"; //include_once "includes/navi.php"; ?> <table cellpadding='0' cellspacing='8' width='100%' id='tablewrap'> <tr> <td width='22%' valign='top' id='leftblock'> <div>  <?php include_once('includes/sitenavi.php'); ?>  </div> </td> <td width='78%' valign='top' id='rightblock'> <div> <form action="" method='POST' name='theAdminForm' id='theAdminForm'> <div class='tableborder'> <div class='tableheaderalt'>Turn your site on/off</div> <?php admin::updateSite(); ?> <table width='100%' cellspacing='0' cellpadding='5' align='center' border='0'> <tr> <td class='tablerow1' width='40%' valign='middle'>Close Site<div class='graytext'>If enabled, your site will be closed and show a maintenance page to regular users. Administrators can still login through Housekeeping.</div></td> <td class='tablerow2' width='60%' valign='middle'> <select name="update" class='dropdown'> <option name="siteMode" value='open'>Site Open</option> <option name="siteMode" value='closed'>Site Closed</option> </select> </td> </tr> <tr> <tr><td align='center' class='tablesubheader' colspan='2' ><input type='submit' value='Apply' class='realbutton' accesskey='s'></td></tr> </form></table></div> </div> </td></tr> </table> </div> <div align='center'> <?php $mtime = explode(' ', microtime()); $totaltime = $mtime[0] + $mtime[1] - $starttime; printf('Time: %.3f', $totaltime); ?> </div> <?php include_once "includes/footer.php"; include_once "includes/script.php"; ?> [/CODE] And yes to change the respect name class and in this following section of the code. [CODE=php] <select name="update" class='dropdown'> <option name="siteMode" value='open'>Site Open</option> <option name="siteMode" value='closed'>Site Closed</option> </select>[/CODE] Here is the MySQL structure Im using. [ATTACH=full]10810[/ATTACH] UPDATE: I almost forgot. I do change the respect code for the function as well. [CODE=php]<?php admin::updateSite(); ?>[/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members