Creating Survey Using Radio Buttons That Calculate Average

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
Eluway
Forum Newbie
Posts: 3
Joined: Fri May 25, 2012 6:42 am

Creating Survey Using Radio Buttons That Calculate Average

Post by Eluway »

So I'm trying to code a form input for a book review. I want to have a star rating out of 5 for each review and I'm using radio buttons for the questions from one to five. I've hit a few problems. I'm not sure my code is adequately removing unanswered questions (the questions are in different categories so not all all applicable) and I can't seem to get the answer to store in my sql database. I'm also having a problem getting the categories (done with check boxes) to store in the database as well. I was trying to work with some code I found from a previous topic so I'm hoping someone here can help me out.

Working with two files

add_book.php

Code: Select all



<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<meta http-equiv="Content-type" content="text/html; charset=UTF-8" />
	<title>Kinky - Add Book Review</title>
	<meta http-equiv="Content-Language" content="en-us" />
	
	<meta http-equiv="imagetoolbar" content="no" />
	<meta name="MSSmartTagsPreventParsing" content="true" />
	
	<meta name="description" content="Add a Book Review" />
	<meta name="keywords" content="kink, BDSM, safety, information, references" />
	
	<meta name="author" content="Fallen People Entertainment" />
	
	<style type="text/css" media="all">@import "../css/style.css";</style>  <style type="text/css" media="all">@import "../css/style.css";</style>
	<script src="http://js.nicedit.com/nicEdit-latest.js" type="text/javascript"></script>
<script type="text/javascript">bkLib.onDomLoaded(nicEditors.allTextAreas);</script>
<?php
session_start();
	//Include database connection details
	include('config.php');

	//Connect to mysql server
	$mysql = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
	if(!$mysql) {
		die('Failed to connect to server: ' . mysql_error());
	}
	mysql_select_db("mydatabasename", $mysql) or die( "Unable to select database" .  mysql_error());
	?>
</head>

<body>
<div id="head-image">
<div id="container">
	<center><div id="header">
	<img src="../images/kinkylogo.png" height=150 width=150 style=float:left>
	</div></center>
	<div id="main-nav">
	<?php include "../home/nav.php";?></div>
	<div id="content">
<center><p><p>
<center><h1>Add a Book Review</h1></center>
<?php	
	// Show form for adding the listing:

echo "
<form method=\"post\" action=\"verify_book.php\">
<center><table><tr><td>

<table><tr><td>
<h3>Kink</h3></td></tr>
<tr><td>How arousing was the BDSM/kink portion of particular book?</td><td>
1
<input type=\"radio\" name=\"question[1]\" value=\"1\">
<input type=\"radio\" name=\"question[1]\" value=\"2\">
<input type=\"radio\" name=\"question[1]\" value=\"3\">
<input type=\"radio\" name=\"question[1]\" value=\"4\">
<input type=\"radio\" name=\"question[1]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[1]\" value=\"0\" checked></td></tr>

<tr><td>
Was the play described in a risk aware format?</td><td>
1
<input type=\"radio\" name=\"question[2]\" value=\"1\">
<input type=\"radio\" name=\"question[2]\" value=\"2\">
<input type=\"radio\" name=\"question[2]\" value=\"3\">
<input type=\"radio\" name=\"question[2]\" value=\"4\">
<input type=\"radio\" name=\"question[2]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[2]\" value=\"0\" checked></td></tr>

<tr><td>
Did it portray BDSM/kink is a positive light?</td><td>
1
<input type=\"radio\" name=\"question[3]\" value=\"1\">
<input type=\"radio\" name=\"question[3]\" value=\"2\">
<input type=\"radio\" name=\"question[3]\" value=\"3\">
<input type=\"radio\" name=\"question[3]\" value=\"4\">
<input type=\"radio\" name=\"question[3]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[3]\" value=\"0\" checked></td></tr>

<tr><td>
Was it a realistic portrayal of the relationship?</td><td>
1
<input type=\"radio\" name=\"question[4]\" value=\"1\">
<input type=\"radio\" name=\"question[4]\" value=\"2\">
<input type=\"radio\" name=\"question[4]\" value=\"3\">
<input type=\"radio\" name=\"question[4]\" value=\"4\">
<input type=\"radio\" name=\"question[4]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[4]\" value=\"0\" checked></td></tr>

<tr><td>
Did it dispel negative stereotypes of kink?</td><td>
1
<input type=\"radio\" name=\"question[5]\" value=\"1\">
<input type=\"radio\" name=\"question[5]\" value=\"2\">
<input type=\"radio\" name=\"question[5]\" value=\"3\">
<input type=\"radio\" name=\"question[5]\" value=\"4\">
<input type=\"radio\" name=\"question[5]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[5]\" value=\"0\" checked></td></tr>

<tr><td>
Does it portray clear consent?</td><td>
1
<input type=\"radio\" name=\"question[6]\" value=\"1\">
<input type=\"radio\" name=\"question[6]\" value=\"2\">
<input type=\"radio\" name=\"question[6]\" value=\"3\">
<input type=\"radio\" name=\"question[6]\" value=\"4\">
<input type=\"radio\" name=\"question[6]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[6]\" value=\"0\" checked></td></tr>

<tr><td>
Does it use mind altering substances responsibly?</td><td>
1
<input type=\"radio\" name=\"question[7]\" value=\"1\">
<input type=\"radio\" name=\"question[7]\" value=\"2\">
<input type=\"radio\" name=\"question[7]\" value=\"3\">
<input type=\"radio\" name=\"question[7]\" value=\"4\">
<input type=\"radio\" name=\"question[7]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[7]\" value=\"0\" checked></td></tr>

<tr><td><h3>Queer</h3></td></tr>
<tr><td>
Did it portray queer lifestyle in a positive light?</td><td>
1
<input type=\"radio\" name=\"question[8]\" value=\"1\">
<input type=\"radio\" name=\"question[8]\" value=\"2\">
<input type=\"radio\" name=\"question[8]\" value=\"3\">
<input type=\"radio\" name=\"question[8]\" value=\"4\">
<input type=\"radio\" name=\"question[8]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[8]\" value=\"0\" checked></td></tr>

<tr><td>
Was it a realistic portrayal of a queer lifestyle?</td><td>
1
<input type=\"radio\" name=\"question[9]\" value=\"1\">
<input type=\"radio\" name=\"question[9]\" value=\"2\">
<input type=\"radio\" name=\"question[9]\" value=\"3\">
<input type=\"radio\" name=\"question[9]\" value=\"4\">
<input type=\"radio\" name=\"question[9]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[9]\" value=\"0\" checked></td></tr>

<tr><td>
Did it dispel negative queer stereotypes?</td><td>
1
<input type=\"radio\" name=\"question[10]\" value=\"1\">
<input type=\"radio\" name=\"question[10]\" value=\"2\">
<input type=\"radio\" name=\"question[10]\" value=\"3\">
<input type=\"radio\" name=\"question[10]\" value=\"4\">
<input type=\"radio\" name=\"question[10]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[10]\" value=\"0\" checked></td></tr>

<tr><td><h3>Porn</h3></td></tr>
<tr><td>
How arousing was the particular book?</td><td>
1
<input type=\"radio\" name=\"question[11]\" value=\"1\">
<input type=\"radio\" name=\"question[11]\" value=\"2\">
<input type=\"radio\" name=\"question[11]\" value=\"3\">
<input type=\"radio\" name=\"question[11]\" value=\"4\">
<input type=\"radio\" name=\"question[11]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[11]\" value=\"0\" checked></td></tr>

<tr><td>
Was there a plot beyond porn?</td><td>
1
<input type=\"radio\" name=\"question[12]\" value=\"1\">
<input type=\"radio\" name=\"question[12]\" value=\"2\">
<input type=\"radio\" name=\"question[12]\" value=\"3\">
<input type=\"radio\" name=\"question[12]\" value=\"4\">
<input type=\"radio\" name=\"question[12]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[12]\" value=\"0\" checked></td></tr>

<tr><td>
Overall, how would you rate the characters?</td><td>
1
<input type=\"radio\" name=\"question[13]\" value=\"1\">
<input type=\"radio\" name=\"question[13]\" value=\"2\">
<input type=\"radio\" name=\"question[13]\" value=\"3\">
<input type=\"radio\" name=\"question[13]\" value=\"4\">
<input type=\"radio\" name=\"question[13]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[13]\" value=\"0\" checked></td></tr>

<tr><td>
How appealing were the characters?</td><td>
1
<input type=\"radio\" name=\"question[14]\" value=\"1\">
<input type=\"radio\" name=\"question[14]\" value=\"2\">
<input type=\"radio\" name=\"question[14]\" value=\"3\">
<input type=\"radio\" name=\"question[14]\" value=\"4\">
<input type=\"radio\" name=\"question[14]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[14]\" value=\"0\" checked></td></tr>

<tr><td>
Could you identify with the character/character scenario?</td><td>
1
<input type=\"radio\" name=\"question[15]\" value=\"1\">
<input type=\"radio\" name=\"question[15]\" value=\"2\">
<input type=\"radio\" name=\"question[15]\" value=\"3\">
<input type=\"radio\" name=\"question[15]\" value=\"4\">
<input type=\"radio\" name=\"question[15]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[15]\" value=\"0\" checked></td></tr>

<tr><td>
Was there a variety of scenes/scenarios?</td><td>
1
<input type=\"radio\" name=\"question[16]\" value=\"1\">
<input type=\"radio\" name=\"question[16]\" value=\"2\">
<input type=\"radio\" name=\"question[16]\" value=\"3\">
<input type=\"radio\" name=\"question[16]\" value=\"4\">
<input type=\"radio\" name=\"question[16]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[16]\" value=\"0\" checked></td></tr>

<tr><td>
Could you make it part of your daily rhythm (routine)?</td><td>
1
<input type=\"radio\" name=\"question[17]\" value=\"1\">
<input type=\"radio\" name=\"question[17]\" value=\"2\">
<input type=\"radio\" name=\"question[17]\" value=\"3\">
<input type=\"radio\" name=\"question[17]\" value=\"4\">
<input type=\"radio\" name=\"question[17]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[17]\" value=\"0\" checked></td></tr>

<tr><td>
Would this book make the \"spank bank\"?</td><td>
1
<input type=\"radio\" name=\"question[18]\" value=\"1\">
<input type=\"radio\" name=\"question[18]\" value=\"2\">
<input type=\"radio\" name=\"question[18]\" value=\"3\">
<input type=\"radio\" name=\"question[18]\" value=\"4\">
<input type=\"radio\" name=\"question[18]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[18]\" value=\"0\" checked></td></tr>

<tr><td>
Was the book unique?</td><td>
1
<input type=\"radio\" name=\"question[19]\" value=\"1\">
<input type=\"radio\" name=\"question[19]\" value=\"2\">
<input type=\"radio\" name=\"question[19]\" value=\"3\">
<input type=\"radio\" name=\"question[19]\" value=\"4\">
<input type=\"radio\" name=\"question[19]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[19]\" value=\"0\" checked></td></tr>

<tr><td><h3>General</h3></td></tr>
<tr><td>
Depth of plot? (option)</td><td>
1
<input type=\"radio\" name=\"question[20]\" value=\"1\">
<input type=\"radio\" name=\"question[20]\" value=\"2\">
<input type=\"radio\" name=\"question[20]\" value=\"3\">
<input type=\"radio\" name=\"question[20]\" value=\"4\">
<input type=\"radio\" name=\"question[20]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[20]\" value=\"0\" checked></td></tr>

<tr><td>
Character Development (option)</td><td>
1
<input type=\"radio\" name=\"question[21]\" value=\"1\">
<input type=\"radio\" name=\"question[21]\" value=\"2\">
<input type=\"radio\" name=\"question[21]\" value=\"3\">
<input type=\"radio\" name=\"question[21]\" value=\"4\">
<input type=\"radio\" name=\"question[21]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[21]\" value=\"0\" checked></td></tr>

<tr><td>
How was the writing style?</td><td>
1
<input type=\"radio\" name=\"question[22]\" value=\"1\">
<input type=\"radio\" name=\"question[22]\" value=\"2\">
<input type=\"radio\" name=\"question[22]\" value=\"3\">
<input type=\"radio\" name=\"question[22]\" value=\"4\">
<input type=\"radio\" name=\"question[22]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[22]\" value=\"0\" checked></td></tr>

<tr><td>
How was the editing? </td><td>
1
<input type=\"radio\" name=\"question[23]\" value=\"1\">
<input type=\"radio\" name=\"question[23]\" value=\"2\">
<input type=\"radio\" name=\"question[23]\" value=\"3\">
<input type=\"radio\" name=\"question[23]\" value=\"4\">
<input type=\"radio\" name=\"question[23]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[23]\" value=\"0\" checked></td></tr>

<tr><td>
Was the language diverse but accessible? </td><td>
1
<input type=\"radio\" name=\"question[24]\" value=\"1\">
<input type=\"radio\" name=\"question[24]\" value=\"2\">
<input type=\"radio\" name=\"question[24]\" value=\"3\">
<input type=\"radio\" name=\"question[24]\" value=\"4\">
<input type=\"radio\" name=\"question[24]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[24]\" value=\"0\" checked></td></tr>

<tr><td>
Was there good tension/chemistry?</td><td>
1
<input type=\"radio\" name=\"question[25]\" value=\"1\">
<input type=\"radio\" name=\"question[25]\" value=\"2\">
<input type=\"radio\" name=\"question[25]\" value=\"3\">
<input type=\"radio\" name=\"question[25]\" value=\"4\">
<input type=\"radio\" name=\"question[25]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[25]\" value=\"0\" checked></td></tr>

<tr><td>
Would you recommend this book?</td><td>
1
<input type=\"radio\" name=\"question[26]\" value=\"1\">
<input type=\"radio\" name=\"question[26]\" value=\"2\">
<input type=\"radio\" name=\"question[26]\" value=\"3\">
<input type=\"radio\" name=\"question[26]\" value=\"4\">
<input type=\"radio\" name=\"question[26]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[26]\" value=\"0\" checked></td></tr>

<tr><td>
How entertaining was this particular book? </td><td>
1
<input type=\"radio\" name=\"question[27]\" value=\"1\">
<input type=\"radio\" name=\"question[27]\" value=\"2\">
<input type=\"radio\" name=\"question[27]\" value=\"3\">
<input type=\"radio\" name=\"question[27]\" value=\"4\">
<input type=\"radio\" name=\"question[27]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[27]\" value=\"0\" checked></td></tr>

<tr><td>
Were the characters diverse in:<br>
<center><table width=90%><tr><td>
Body type</td><td>
1
<input type=\"radio\" name=\"question[28]\" value=\"1\">
<input type=\"radio\" name=\"question[28]\" value=\"2\">
<input type=\"radio\" name=\"question[28]\" value=\"3\">
<input type=\"radio\" name=\"question[28]\" value=\"4\">
<input type=\"radio\" name=\"question[28]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[28]\" value=\"0\" checked></td></tr>
<tr><td>
Ethnicity</td><td>
1
<input type=\"radio\" name=\"question[29]\" value=\"1\">
<input type=\"radio\" name=\"question[29]\" value=\"2\">
<input type=\"radio\" name=\"question[29]\" value=\"3\">
<input type=\"radio\" name=\"question[29]\" value=\"4\">
<input type=\"radio\" name=\"question[29]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[29]\" value=\"0\" checked></td></tr>
<tr><td>
Sexual orientation</td><td>
1
<input type=\"radio\" name=\"question[30]\" value=\"1\">
<input type=\"radio\" name=\"question[30]\" value=\"2\">
<input type=\"radio\" name=\"question[30]\" value=\"3\">
<input type=\"radio\" name=\"question[30]\" value=\"4\">
<input type=\"radio\" name=\"question[30]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[30]\" value=\"0\" checked></td></tr>
<tr><td>
Sexual Identity</td><td>
1
<input type=\"radio\" name=\"question[31]\" value=\"1\">
<input type=\"radio\" name=\"question[31]\" value=\"2\">
<input type=\"radio\" name=\"question[31]\" value=\"3\">
<input type=\"radio\" name=\"question[31]\" value=\"4\">
<input type=\"radio\" name=\"question[31]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[31]\" value=\"0\" checked></td></tr>
<tr><td>
Gender exp<b></b>ression</td><td>
1
<input type=\"radio\" name=\"question[32]\" value=\"1\">
<input type=\"radio\" name=\"question[32]\" value=\"2\">
<input type=\"radio\" name=\"question[32]\" value=\"3\">
<input type=\"radio\" name=\"question[32]\" value=\"4\">
<input type=\"radio\" name=\"question[32]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[32]\" value=\"0\" checked></td></tr>
<tr><td>
Disability</td><td>
1
<input type=\"radio\" name=\"question[33]\" value=\"1\">
<input type=\"radio\" name=\"question[33]\" value=\"2\">
<input type=\"radio\" name=\"question[33]\" value=\"3\">
<input type=\"radio\" name=\"question[33]\" value=\"4\">
<input type=\"radio\" name=\"question[33]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[33]\" value=\"0\" checked></td></tr></table></center>
</td></tr>

<tr><td><h3>Instructional</h3></td></tr>
<tr><td>
How engaging was the tutorial?</td><td>
1
<input type=\"radio\" name=\"question[34]\" value=\"1\">
<input type=\"radio\" name=\"question[34]\" value=\"2\">
<input type=\"radio\" name=\"question[34]\" value=\"3\">
<input type=\"radio\" name=\"question[34]\" value=\"4\">
<input type=\"radio\" name=\"question[34]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[34]\" value=\"0\" checked></td></tr>

<tr><td>
Was this applicable to beginners?</td><td>
1
<input type=\"radio\" name=\"question[35]\" value=\"1\">
<input type=\"radio\" name=\"question[35]\" value=\"2\">
<input type=\"radio\" name=\"question[35]\" value=\"3\">
<input type=\"radio\" name=\"question[35]\" value=\"4\">
<input type=\"radio\" name=\"question[35]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[35]\" value=\"0\" checked></td></tr>

<tr><td>
Was this applicable to moderate-advanced?</td><td>
1
<input type=\"radio\" name=\"question[36]\" value=\"1\">
<input type=\"radio\" name=\"question[36]\" value=\"2\">
<input type=\"radio\" name=\"question[36]\" value=\"3\">
<input type=\"radio\" name=\"question[36]\" value=\"4\">
<input type=\"radio\" name=\"question[36]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[36]\" value=\"0\" checked></td></tr>

<tr><td>
How informative?</td><td>
1
<input type=\"radio\" name=\"question[37]\" value=\"1\">
<input type=\"radio\" name=\"question[37]\" value=\"2\">
<input type=\"radio\" name=\"question[37]\" value=\"3\">
<input type=\"radio\" name=\"question[37]\" value=\"4\">
<input type=\"radio\" name=\"question[37]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[37]\" value=\"0\" checked></td></tr>

<tr><td>
Was it an appropriate use of the written word?</td><td>
1
<input type=\"radio\" name=\"question[38]\" value=\"1\">
<input type=\"radio\" name=\"question[38]\" value=\"2\">
<input type=\"radio\" name=\"question[38]\" value=\"3\">
<input type=\"radio\" name=\"question[38]\" value=\"4\">
<input type=\"radio\" name=\"question[38]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[38]\" value=\"0\" checked></td></tr>

<tr><td>
How accurate?</td><td>
1
<input type=\"radio\" name=\"question[39]\" value=\"1\">
<input type=\"radio\" name=\"question[39]\" value=\"2\">
<input type=\"radio\" name=\"question[39]\" value=\"3\">
<input type=\"radio\" name=\"question[39]\" value=\"4\">
<input type=\"radio\" name=\"question[39]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[39]\" value=\"0\" checked></td></tr>

<tr><td>
Did it inspire your creativity?</td><td>
1
<input type=\"radio\" name=\"question[40]\" value=\"1\">
<input type=\"radio\" name=\"question[40]\" value=\"2\">
<input type=\"radio\" name=\"question[40]\" value=\"3\">
<input type=\"radio\" name=\"question[40]\" value=\"4\">
<input type=\"radio\" name=\"question[40]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[40]\" value=\"0\" checked></td></tr>

<tr><td>
Was it accessible?</td><td>
1
<input type=\"radio\" name=\"question[41]\" value=\"1\">
<input type=\"radio\" name=\"question[41]\" value=\"2\">
<input type=\"radio\" name=\"question[41]\" value=\"3\">
<input type=\"radio\" name=\"question[41]\" value=\"4\">
<input type=\"radio\" name=\"question[41]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[41]\" value=\"0\" checked></td></tr>

<tr><td>
Did it give information on:<br>
<center><table width=90%><tr><td>
History (optional)</td><td>
1
<input type=\"radio\" name=\"question[42]\" value=\"1\">
<input type=\"radio\" name=\"question[42]\" value=\"2\">
<input type=\"radio\" name=\"question[42]\" value=\"3\">
<input type=\"radio\" name=\"question[42]\" value=\"4\">
<input type=\"radio\" name=\"question[42]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[42]\" value=\"0\" checked></td></tr>
<tr><td>
Common practices</td><td>
1
<input type=\"radio\" name=\"question[43]\" value=\"1\">
<input type=\"radio\" name=\"question[43]\" value=\"2\">
<input type=\"radio\" name=\"question[43]\" value=\"3\">
<input type=\"radio\" name=\"question[43]\" value=\"4\">
<input type=\"radio\" name=\"question[43]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[43]\" value=\"0\" checked></td></tr>
<tr><td>
Aftercare</td><td>
1
<input type=\"radio\" name=\"question[44]\" value=\"1\">
<input type=\"radio\" name=\"question[44]\" value=\"2\">
<input type=\"radio\" name=\"question[44]\" value=\"3\">
<input type=\"radio\" name=\"question[44]\" value=\"4\">
<input type=\"radio\" name=\"question[44]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[44]\" value=\"0\" checked></td></tr>
<tr><td>
Safety</td><td>
1
<input type=\"radio\" name=\"question[45]\" value=\"1\">
<input type=\"radio\" name=\"question[45]\" value=\"2\">
<input type=\"radio\" name=\"question[45]\" value=\"3\">
<input type=\"radio\" name=\"question[45]\" value=\"4\">
<input type=\"radio\" name=\"question[45]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[45]\" value=\"0\" checked></td></tr></table></center>
</td></tr>

<tr><td>
Was a demonstration depicted?</td><td>
1
<input type=\"radio\" name=\"question[46]\" value=\"1\">
<input type=\"radio\" name=\"question[46]\" value=\"2\">
<input type=\"radio\" name=\"question[46]\" value=\"3\">
<input type=\"radio\" name=\"question[46]\" value=\"4\">
<input type=\"radio\" name=\"question[46]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[46]\" value=\"0\" checked></td></tr>

<tr><td>
Was demonstration useful? (optional)</td><td>
1
<input type=\"radio\" name=\"question[47]\" value=\"1\">
<input type=\"radio\" name=\"question[47]\" value=\"2\">
<input type=\"radio\" name=\"question[47]\" value=\"3\">
<input type=\"radio\" name=\"question[47]\" value=\"4\">
<input type=\"radio\" name=\"question[47]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[47]\" value=\"0\" checked></td></tr>

<tr><td>
How did you find the Instructor?</td><td>
1
<input type=\"radio\" name=\"question[48]\" value=\"1\">
<input type=\"radio\" name=\"question[48]\" value=\"2\">
<input type=\"radio\" name=\"question[48]\" value=\"3\">
<input type=\"radio\" name=\"question[48]\" value=\"4\">
<input type=\"radio\" name=\"question[48]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[48]\" value=\"0\" checked></td></tr>

<tr><td>
Would you recommend this as a resource?</td><td>
1
<input type=\"radio\" name=\"question[49]\" value=\"1\">
<input type=\"radio\" name=\"question[49]\" value=\"2\">
<input type=\"radio\" name=\"question[49]\" value=\"3\">
<input type=\"radio\" name=\"question[49]\" value=\"4\">
<input type=\"radio\" name=\"question[49]\" value=\"5\">
5 
or N/A<input type=\"radio\" name=\"question[49]\" value=\"0\" checked></td></tr>
</table><p>
</td></tr>
<tr><td>
<table><tr><td>
<strong>Image Link: </strong></td><td>
<input type=\"text\" name=\"image\" size=\"30\" maxlength=\"300\"/></td></tr>
<tr><td><strong>Rater Name: </strong></td><td>
<input type=\"text\" name=\"rater_name\" size=\"30\" maxlength=\"50\"/></td></tr>
<tr><td><strong>Rater Date: </strong></td><td>
<input type=\"text\" name=\"rate_date\" size=\"30\" maxlength=\"25\"/></td></tr>
<tr><td><strong>Book Title: </strong></td><td>
<input type=\"text\" name=\"title\" size=\"30\" maxlength=\"300\"/></td></tr>
<tr><td><strong>Author Last Name: </strong></td><td>
<input type=\"text\" name=\"author_last\" size=\"30\" maxlength=\"300\"/></td></tr>
<tr><td><strong>Author First Name: </strong></td><td>
<input type=\"text\" name=\"author_first\" size=\"30\" maxlength=\"300\"/></td></tr>
<tr><td><strong>Publish Date: </strong></td><td>
<input type=\"text\" name=\"publish_date\" size=\"30\" maxlength=\"25\"/></td></tr>
<tr><td><strong>Publisher: </strong></td><td>
<input type=\"text\" name=\"publisher\" size=\"30\" maxlength=\"300\"/></td></tr>
<tr><td><strong>ISBN: </strong></td><td>
<input type=\"text\" name=\"isbn\" size=\"30\" maxlength=\"300\"/><p></td></tr></table>
</td></tr>
<tr><td>
<table><tr><td><strong>Back Summary:</strong><br>
<textarea name=\"back_summary\" rows=\"10\" cols=\"30\" size=\"70\" maxlength=\"1500\"/></textarea></td><td>
<strong>Rater Summary:</strong><br>
<textarea name=\"rater_summary\" rows=\"10\" cols=\"30\" size=\"70\" maxlength=\"1500\"/></textarea></td></tr></table><br><table><tr><td>
<strong>Review:</strong><br>
<textarea name=\"rater_comments\" rows=\"10\" cols=\"70\" size=\"70\" maxlength=\"1500\"/></textarea></td></tr></table>

</td></tr><tr><td>

<table><tr><td>
<strong>Category (check all that apply): </strong><br>
<input type=\"checkbox\" name=\"category[]\" value=\"Instructional\" />Instructional | 
<input type=\"checkbox\" name=\"category[]\" value=\"Fiction\" />Fiction | 
<input type=\"checkbox\" name=\"category[]\" value=\"Entertainment\" />Entertainment |
<input type=\"checkbox\" name=\"category[]\" value=\"Porn\" />Porn | <br> 
<input type=\"checkbox\" name=\"category[]\" value=\"BDSM\" />BDSM | 
<input type=\"checkbox\" name=\"category[]\" value=\"Kink\" />Kink | 
<input type=\"checkbox\" name=\"category[]\" value=\"Queer\" />Queer | 
<input type=\"checkbox\" name=\"category[]\" value=\"Sex\" />Sex | <br>
<input type=\"checkbox\" name=\"category[]\" value=\"Polyamory\" />Polyamory | 
<input type=\"checkbox\" name=\"category[]\" value=\"Relationship\" />Relationship | <br />
<p><strong>Buy Link: </strong>
<input type=\"text\" name=\"buy\" size=\"30\" maxlength=\"300\"/>

<center>";
require_once('recaptchalib.php');
  $publickey = "my-key";
  echo recaptcha_get_html($publickey);
echo "<br>
<input type=\"submit\" name=\"submit\" value=\"Add Review!\">
</form></td></tr></table>
</td></tr></table>";
?>

</body>
</html>
and verify_book.php

Code: Select all


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
	<meta http-equiv="Content-type" content="text/html; charset=UTF-8" />
	<title>Kinky - Add Book Review</title>
	<meta http-equiv="Content-Language" content="en-us" />
	
	<meta http-equiv="imagetoolbar" content="no" />
	<meta name="MSSmartTagsPreventParsing" content="true" />
	
	<meta name="description" content="Adding a book review" />
	<meta name="keywords" content="kink, BDSM, safety, information, references" />
	
	<meta name="author" content="Fallen People Entertainment" />
	
	<style type="text/css" media="all">@import "../css/style.css";</style>  <style type="text/css" media="all">@import "../css/style.css";</style>
<?php 

 require_once('recaptchalib.php');
  $privatekey = "my matching key";
  $resp = recaptcha_check_answer ($privatekey,
                                $_SERVER["REMOTE_ADDR"],
                                $_POST["recaptcha_challenge_field"],
                                $_POST["recaptcha_response_field"]);

  if (!$resp->is_valid) {
    // What happens when the CAPTCHA was entered incorrectly
    die ("The reCAPTCHA wasn't entered correctly. Go back and try it again." .
         "(reCAPTCHA said: " . $resp->error . ")");
  } else {
  
  	//Include database connection details
	include('config.php');

	//Connect to mysql server
	$mysql = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
	if(!$mysql) {
		die('Failed to connect to server: ' . mysql_error());
	} 
	mysql_select_db("mydatabasename", $mysql) or die( "Unable to select database" .  mysql_error());

// Add new book review

$category_array = $_POST['category'];
foreach ($category_array as $one_category) {
$source .= $one_category.", ";
}
$category = substr($source, 0, -2);

if (!empty($_POST['question'])) { //make sure input exists
   $star = array_sum($_POST['question']) / count($_POST['question']); 
} else {
  $star = 0;
}

	$insListing_sql = "INSERT INTO book (id, image, rater_name, rate_date, title, author_last, author_first, star, publish_date, publisher, isbn, back_summary, rater_summary, rater_comments, $category, buy) VALUES( '', 
			'".mysql_real_escape_string($_POST["image"])."',
			'".mysql_real_escape_string($_POST["rater_name"])."',
			'".mysql_real_escape_string($_POST["rate_date"])."',
			'".mysql_real_escape_string($_POST["title"])."',
			'".mysql_real_escape_string($_POST["author_last"])."',
			'".mysql_real_escape_string($_POST["author_first"])."',
			'".mysql_real_escape_string($_POST["star"])."',
			'".mysql_real_escape_string($_POST["publish_date"])."',
			'".mysql_real_escape_string($_POST["publisher"])."',
			'".mysql_real_escape_string($_POST["isbn"])."',
			'".mysql_real_escape_string($_POST["back_summary"])."',
			'".mysql_real_escape_string($_POST["rater_summary"])."',
			'".mysql_real_escape_string($_POST["rater_comments"])."',
			'".mysql_real_escape_string($_POST["$category"])."',
			'".mysql_real_escape_string($_POST["buy"])."'
			)"; 
	$insListing_res = mysql_query($insListing_sql, $mysql)
			or die(mysql_error($mysql));
} 
?>
<table width=70%><tr><td>
<center><h1>Book Review Added!</h1><p>

<a class="ex1" href="book_add.php">Add Another Book Review</a>
Eluway
Forum Newbie
Posts: 3
Joined: Fri May 25, 2012 6:42 am

Re: Creating Survey Using Radio Buttons That Calculate Avera

Post by Eluway »

Okay so I've managed to figure out a bunch of the problems. I now have it posting to mysql with no problems and I think I have figured out how to remove questions with a score of '0'. I am apparently having problems with my logic for getting the score to one that's out of 5.

The current section I'm looking at is:

Code: Select all

if (!empty($_POST['question'])) { //make sure input exists
	$i=0;
	$quest = $i < count($_POST['question']); //removes questions with score of '0'
   $score = array_sum($_POST['question']) / $quest * 5; //generates percentage
   $star = (($score * 100) / 20); //turns percentage into score out of 5
} else {
  $star = 0;
}
}
Right now this isn't giving me a score out of 5. Any thoughts?
Eluway
Forum Newbie
Posts: 3
Joined: Fri May 25, 2012 6:42 am

Re: Creating Survey Using Radio Buttons That Calculate Avera

Post by Eluway »

Oops. sorry. current one

Code: Select all

if (!empty($_POST['question'])) { //make sure input exists
	$i=0;
	$quest = $i < count($_POST['question']); //removes questions with score of '0'
   $score = array_sum($_POST['question']) / ($quest * 5); //generates percentage
   $star = (($score * 100) / 20); //turns percentage into score out of 5
} else {
  $star = 0;
}
}
Post Reply