html - Getting Values / Answers from radio button and storing it in SQL Database using PHP -


i doing online aptitude test company pick 20 random questions database , display on webpage answering.

but have problem in storing answered values in sql database, please 1 can me issue,

<?php     $connect = mysql_connect("localhost","root","")   or die(mysql_error());   $sel=mysql_select_db("aptitude");   $query = mysql_query("select * `questions`  order rand() limit 20 ");  while($rows = mysql_fetch_array($query)){      $q = $rows['qno'];     $qus = $rows['question'];     $a = $rows['opt1'];     $b = $rows['opt2'];     $c = $rows['opt3'];     $d = $rows['opt4'];     $ans = $rows['ans'];       echo "<b>question:-<br></b>$qus <br>";     echo " <input type=radio name = 'answer[$q]' value = '$a'></input>$a &nbsp &nbsp";      echo " <input type=radio name = 'answer[$q]' value = '$b'></input>$b &nbsp &nbsp";      echo " <input type=radio name = 'answer[$q]' value = '$c'></input>$c &nbsp &nbsp ";      echo " <input type=radio name = 'answer[$q]' value = '$d'></input>$d <br><br> ";   }  ?>

but trying store values after user clicking on submit button:

if (isset($_post['submit']))  {  $username=$_get['username'];  $opt1=$_post["answer1"]; $opt2=$_post["answer2"];  mysql_query("insert $username values('q1','$answer1')") or die(mysql_error()); mysql_query("insert $username values('q2','$answer2')") or die(mysql_error());  }

first of should create form , print question , answer related data in form , after submission of form should required data that's have set in form.

in case there no need to store answer value in variable @ form. have create 1 submit handler in selected option , question id. store data in database. , if want create result sheet create function compare user submitted answer database answer.

submit handler goes this

if (isset($_post['submit'])) { if (isset($_post['username']) && $_post['username']){     $username = $_post['username']; } if (isset($_post['qno']) && $_post['qno']){     $qno = $_post['qno']; } if (isset($_post['answer']) && $_post['answer']){     $answer = $_post['answer']; } mysql_query("insert 'your_table_name' values('values1','value2')")or die(mysql_error());}

if need more provide email id ill give full module.


Comments

Post a Comment

Popular posts from this blog

php - Submit Form Data without Reloading page -

i know question has been asked , answered bunch of times life of me can not solution work on code. believe if redo code, work properly, , in retrospect time i've spent on issue should have redone code...but beyond deadline , have working prototype up... can advise how update multiple forms on single page without reloading page? horrible @ php , complete noob js/jquery/ajax @ best. html/php in single file , believe causing me problems/is largest obstacle @ getting ajax form processing work. basically, want users to: select teams multiple dropdowns in form group 1 (league champs) , on update update db newly selected team without reloadding page. edit team scores per match , on score submit/update, update db new scores. for each requirement there multiple forms (1 each leagues, 1 each per match) have set class on each form id. everything works via php, form submission reloads page each time submitted , not ideal. i have tried ajax code here http://scotch.io/tutoria
Read more

linux - Rails running on virtual machine in Windows -

the reason why want switch ubuntu people said gems works better on linux on windows. i don't want macbook pro rails development since love windows , cannot stand lack of apps mac. moreover, people saying ubuntu "better" mac: http://www.reddit.com/r/ubuntu/comments/1bgj1s/are_there_advantages_of_ubuntu_over_os_x_for/ does virtual box work enough doesn't have lag @ all? using i7-3517u cpu 8gb memory. need program in environment lag-free , not sluggish. or there alternatives recommend? i unsure permission settings or complicated stuffs regarding terminal. i'll using terminal develop. i'm still quite new here development in linux. please kind me >< thanks. @holyxiaoxin pretty sure should asking on superuser instead. nevertheless, suggest install ubuntu in partition instead of running virtual machine. here's guide https://help.ubuntu.com/community/windowsdualboot also, yes. developing in virtual machine accurate, @ end experiment w
Read more

php - $params->set Array between square bracket -

i'm using k2 in joomla 3.3. i'm trying set params (items ids ) module k2_content item.php file. result must between brackets, like: ["96","68"] my code is: $query = "select * #__k2_items extra_fields_search = '$myautor' , catid !=1 " ; $db->setquery($query); $losautores = $db->loadobjectlist(); $result = array(); foreach ($losautores $key => $value) { $result[] = '" '.$value->id.' "'; } $string_version = implode(',', $result); $autoresfinal = '['.$string_version.']'; if test using print, looks ok. passing var pramas, 1064 error. $params->set('items', $autoresfinal); to test tried $autoresfinal = ["96","68"]; and works fine. idea why doesn't work? thank you. if assign ["x","y"] assigning an array . here transforming array in st
Read more