php - Set mysql values from radio buttons in html form -

-

i want 2 radio buttons on webpage (written in php) representing "yes" , "no". when load page want fetch value mysql db , set corresponding radio button. , when click on other button, want update database , reload page.

i'm trying simple html form, no luck. code have far (that not working @ :( is: 

if (!isset($_post['submit'])) {     $sql = "select challenge_me contestants id=$id";     $res = (mysql_fetch_assoc(mysql_query($sql, $db)));     $challenge_me = $res["challenge_me"];  }else{     $sql = "update contestants set challenge_me='" . $_post['yesno'] . "' id='$id'";     if(!mysql_query($sql, $db))         echo mysql_error(), "<br/>query '$sql'";     $challenge_me = $_post['yesno']; }      echo'<form method="post" action="' . $php_self . '">';     echo '<input type="hidden" name="submit" value="submit">';           if($challenge_me == 1){     echo'<input type="radio" name="yesno" value="1" onclick="this.form.submit();" checked>yes ';     echo'<input type="radio" name="yesno" value="0" onclick="this.form.submit();">no '; }else{     echo'<input type="radio" name="yesno" value="1" onclick="this.form.submit();">yes ';     echo'<input type="radio" name="yesno" value="0" onclick="this.form.submit();" checked>no '; } echo'</form>';

your script doesnt seem define $id, $id value from? source of problem. script might not passing value in $id


Comments

Post a Comment

Popular posts from this blog

c# - how to write client side events functions for the combobox items -

-
<dx:aspxcombobox id="aspxcombobox2" runat="server" clientidmode="autoid" selectedindex="-1" onselectedindexchanged="aspxcombobox1_selectedindexchanged1" > <clientsideevents selectedindexchanged="function(s, e) { grid.selectrows();}" /> <items> <dx:listedititem text="selecte rows" /> <dx:listedititem text="unselectall" /> </items> </dx:aspxcombobox> i want write event "unselect all" item in combobox. how can this? you'll need write javascript function iterates thru combo-box , marks selected items false. see select/unselect checkbox fields using pure javascript , html sample code msdn:
Read more

exception - Python, pyPdf OCR error: pyPdf.utils.PdfReadError: EOF marker not found -

-
pypdf throws exception: pypdf.utils.pdfreaderror: eof marker not found i don't need fix pypdf, need eof error cause "except" block execute , skip on file, doesn't work. still causes program stop running. background: batch ocr program pdfs python, pypdf, adobe pdf ocr error: unsupported filter /lzwdecode ... saga continues. i got 10,000 pdfs in folder. ocrd, not. can't tell 'em apart. step 1 figure out ones not ocrd , ocr (see other threads details). so i'm using pypdf. exceptions related unrecognized characters , unsupported filters when try read text. guestimated if throws exception, it's got text in , doens't go in list. problem solved, right? so: pypdf import pdffilewriter, pdffilereader import sys, os, pypdf, re path = 'c:\users\homer\documents\my pdfs' filelist = os.listdir(path) has_text_list = [] does_not_have_text_list = [] pdf_name in filelist: pdf_file
Read more