html - I need a php code to update my database table with only the options that I have checked -


i have student table checkboxes in front of it. if click promote button, want ones check update in database , rest should not.

here html code :

<table class="table toggle-square" data-filter="#table_search" width="792" border="0" align="center">                           <tr>                             <td width="92" height="26" bgcolor="#fba774"><div align="center"><strong>s/n</strong></div></td>                             <td width="131" bgcolor="#fba774"><div align="center"><strong>reg number</strong></div></td>                             <td width="152" bgcolor="#fba774"><div align="center"><strong>full name</strong></div></td>                             <td width="140" bgcolor="#fba774"><div align="center"><strong>class</strong></div></td>                             <td width="255" bgcolor="#fba774"><div align="center"></div></td>                             <?                                 $i=0;       while ($rowgeneral = mysql_fetch_array($sqldisplayresult)){           $i++;                             //$choice = $rowgeneral['stdcurrentclass'];                             //if ($choice == "14"){                             ?>              <tr>                             <td><div align="center">                               <?=$i?>                             </div></td>                             <td><div align="center"><?=$rowgeneral['stdregnumber']?></div></td>                             <td><div align="center">                               <?                    $stdname = $rowgeneral['stdregnumber'];                   $retrivestdnamequery = mysql_query("select * tb_student_reg regnumber = '$stdname'");                 $stdnamerow = mysql_fetch_array($retrivestdnamequery);                 $mystdname = $stdnamerow['firstname'].' '.$stdnamerow['lastname'].' '.$stdnamerow['middlename'];                               echo $mystdname;                               ?>                             </div></td>                             <td><div align="center">                              <?                    $classid = $rowgeneral['stdcurrentclass'];                  $retriveclassnamequery = mysql_query("select * tb_classes id = $classid");                   $classnamerow = mysql_fetch_array($retriveclassnamequery);                   $classname = $classnamerow['classname'];                               echo $classname;                               ?>                              </div></td>                             <td><div align="center">    <!--<input  type="checkbox" onchange="feetotal"  name="subject[]" value="<?=$rowgeneral['currentclass']?>"     checked onclick="return false">-->      <?                              //echo $rowgeneral['avg_score'] . " >=  ".  $averagescore;                             if ($rowgeneral['avg_score'] >= $averagescore){                             ?>             <input type="checkbox" name="checkbox" id="checkbox" checked>                               <? }                             else{                             ?>                              <input type="checkbox" name="checkbox" id="checkbox" >                             <?                             }?>                             </div></td>                      <? }?>               <tr>                <td>&nbsp;</td>                <td>&nbsp;</td>                <td>&nbsp;</td>                <td>&nbsp;</td>                <td>&nbsp;</td>              <tr>                <td>&nbsp;</td>                <td>&nbsp;</td>                <td>&nbsp;</td>                <td>&nbsp;</td>                <td><div align="right">                   <input type="submit" name="promote" id="promote" value="promote">                </div></td>            </table>

here php code update :

<?    $updatepromotionquery = ""; if(isset($_post['promote'])) {     $promotedclass = $_post['promotedclass'];     $currentclass = $_post['currentclass'];     $checkbox = $_post['checkbox'];   $updatepromotionquery = "update tb_student_reg set promotedclass ='$promotedclass'   currentclass = '$currentclass'";  mysql_query($updatepromotionquery);  }  ?>

use multi check box

<input type="checkbox" name="checkbox[]">

Comments

Post a Comment

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

i working on custom magento extension. working around adminhtml part , i've created custom form there. here form code: <?php class vivasindustries_smsnotification_block_adminhtml_sms_sendmass_edit_form extends mage_adminhtml_block_widget_form { public function _preparelayout() { $extensionpath = mage::getmoduledir('js', 'vivasindustries_smsnotification'); $head = $this->getlayout()->getblock('head'); $head->addjs('jquery.js'); $head->addjs('vivas.js'); return parent::_preparelayout(); } protected function _prepareform() { $form = new varien_data_form(array( 'id' => 'edit_form', 'action' => $this->geturl('*/*/save', array('id' => $this->getrequest()->get...
Read more

php - Bypass Geo Redirect for specific directories -

i'm trying bypass redirect specific url within site. wondering if might able help. the code below code use, original urls replaces example.com i'd able access http://example.com/admin without redirect occuring. is there way this, , there way using own ip? function country_geo_redirect() { $country = getenv('http_geoip_country_code'); if ($country == "us" ) { wp_redirect("http://usa.example.com/"); exit; } else if ($country == "gb" ) { wp_redirect("http://uk.example.com/"); exit; } } add_action('init', 'country_geo_redirect'); you can bypass redirection code if server found ip address. if ip address == <my ip address> ' nothing here else country_georedirect() end if
Read more

php - .htaccess mod_rewrite for dynamic url which has domain names -

i want convert url ex:( example.com/link.php?url=facebook.com ) ( example.com/facebook.com.php ) how can using .htaccess. or there other process make job easier ? i tried adding script .htaccess file options +followsymlinks rewriteengine on rewriterule url-(.*)\.htm$ link.php?url=$1 but converting url adding "url-" ( example.com/url-facebook.com.php ) i want remove "url-" , want make ( example.com/facebook.com.php ) rewriteengine on rewritecond %{the_request} ^get.*link\.php\?url\= [nc] rewritecond %{request_uri} !/system/.* [nc] rewriterule (.*?)link\.php\?url\=/*(.*) /$1$2 [r=301,ne,l] not sure how above work edit of used use remove index.php url
Read more