sql - PHP Populate Dropdown From Database and then Update on Button Click -

-

i'm having trouble populating dropdown list database , updating selected item on button click. i'm trying have when pick option b in dropdown, it'll update option on click of submit button.

i can dropdown box populate fine, when clicking button won't update correctly. i'm learning go, pointers appreciated.

<form id='filter' name='filter' method='post' action=''>                  <?php                  $getissuedvouchers2 = "select * vouchercodes status = 'active'";                 $issuedvouchersresult2 = mysql_query($getissuedvouchers);                  ?>                  <select>                      <?php                          while ($ivselectrow = mysql_fetch_array($issuedvouchersresult2)) {                             echo "<option name='updatestatus'>" . $ivselectrow['vouchid'] . "</option>";                         }                      ?>                  </select>                  <input type="submit" value="update record" name="submit" />                  <?php                     if(isset($_post['submit'])) { //if submit button clicked                      $updatingquery = "update vouchercodes set status='expired' vouchid = '".$ivselectrow['vouchid']."' ";                     mysql_query($updatingquery) or die("cannot update");//update or error                     }                 ?>              </form>

php server side language. runs once when request page, , after done serves page you. not run until page request, php can't because that's client side action.

what looking javascript , ajax. client side languages. i'd recommend using jquery this, it's pretty easy use once hang of it. makes lot less awful standard javascript.

if aren't wanting avoid page reload (submit -> handler -> page reload), can cook answer that. maybe.

update comment: want set "selected" attribute, makes option selected on page load, correct? e.g. pick second item in dropdown instead of first.

you need use selected attribute on option tag. makes selected. here's example use on 1 of sites.

<select data-wavenum='<?=$i;?>' id="enemy<?=$i;?>" name="enemy<?=$i;?>" class="enemylist">    <option value="assaulttrooper" <?=($enemy == 'assaulttrooper') ? "selected" : ""?>>assault trooper</option>

this prints out like:

   <option value="assaulttrooper" selected>assault trooper</option>

in case, $enemy item makes me print selected out makes option selected.

in case, be. it's kind of ugly. think fixed of code, without db backend can't test.

while ($ivselectrow = mysql_fetch_array($issuedvouchersresult2)) {    $selected = false;    if (isset($_post['submit'])) {     $selected = ($_post['vouchid'] == $ivselectrow['vouchid']);    }    echo "<option name=".$ivselectrow['vouchid']." ".($selected) ? "selected" : "".">" . $ivselectrow['vouchid'] . "</option>"; }

please aware change option name or send post cause expire value, or delete entire table data not sanitized.


Comments

Post a Comment

Popular posts from this blog

python - mat is not a numerical tuple : openCV error -

-
i have write down code showing error ma not getting it: please help: showing mat not numerical tuple: import cv import cv2 capture = cv2.videocapture("j.3gp") while(1): _, frame1 = capture.read() grayimage1 = cv2.cvtcolor(frame1, cv2.color_bgr2gray) _, frame2 = capture.read() grayimage2 = cv2.cvtcolor(frame2, cv2.color_bgr2gray) differenceimage = cv2.absdiff(grayimage1,grayimage2) thresholdimage = cv2.threshold(differenceimage,25,255,cv2.thresh_binary) cv2.imshow("difference image", differenceimage) cv2.imshow("threshold image", thresholdimage) cv2.imshow("image", frame1) k = cv2.waitkey(30) & 0xff error arising : ----------------------------------------------------------------------------------------- traceback (most recent call last): file "desk.py", line 15, in <module> cv2.imshow("threshold image", thresholdimage) typeerror: mat not numerical tuple
Read more

c# - MSAA finds controls UI Automation doesn't -

-
i'm working on automating windows application. i'm using teststack white framework. i've hit problem. program has 'window' object cannot see inside of. white shows no controls inside of it. inspect.exe shows no controls inside of either when running in ui automation mode. if switch inspect msaa see controls inside fine. there anyway me use msaa c# handle on these controls? if can identify msaa functions need, can use p/invoke call them c#. here's example article doing msaa: http://www.codeproject.com/articles/38906/ui-automation-using-microsoft-active-accessibility also, pinvoke.net can used identify iaccessible (msaa) functions: http://www.pinvoke.net/search.aspx?search=iaccessible&namespace=[all] here's answer along lines: msaa com-based? finally, alternative p/invoke, might able use tlbimp.exe create wrapper assembly oleacc.dll, , access msaa functions through it. i'm not sure if works msaa, it's worth try. as e
Read more

wordpress - .htaccess: RewriteRule: bad flag delimiters -

-
pulling hair out on one. have following .htaccess file custom redirects in addition wordpress's default settings. when tested on local wamp server worked fine after moving production i'm not getting rewriterule: bad flag delimiters error in server log , after while site goes down internal server error any appreciated. in advance! <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^rockford_weddings___welcome\.html$ /wedding/ [r=301,l] rewriterule ^blog/?$ /journal/ [r=301,l] rewriterule ^blog/(.*)$ /$1 [r=301,l] rewriterule ^portraitinvestment/?$ /portraitinvestment\.pdf [r=301,l] rewriterule ^weddinginvestment/?$ /weddinginvestment\.pdf [r=301,l] rewriterule ^holidaycards2014/?$ /holidaycards2014\.pdf [r=301,l] </ifmodule> # begin wordpress <ifmodule mod_rewrite.c> rewriteengine on rewritebase / rewriterule ^index\.php$ - [l] rewritecond %{request_filename} !-f rewritecond %{request_filename} !-d rewriterule . /index.php [l] </
Read more