Forgot Password • Register • Login

my php problem

Posted on Sunday 15th June 2008 at 07:14 AM

Matt

i'm having a problem right now, and the reason is because i'm not fully understanding how i'm suppossed to do this.

i have a page where an admin can add a poll, the poll system uses 3 mysql tables, poll, questions, responses. i will show a link to an online demo:
https://dev64.frankychan04.com/cms/?page=polls&a=3
you enter the name for the poll, then you enter the amount of options you want, the amount of options can be unlimited.
the query to create the poll is done after the first step, now i want to know is how to load every option into the table, what would my query look like, and what would the for loop look like, thanks.

Posted on Sunday 15th June 2008 at 06:20 PM

Adam981

it would help if we seen the php codes, use [php*] php code here [/php*] without the stars

Posted on Sunday 15th June 2008 at 06:30 PM

Matt

PHP Code

<?php
	//-----------------------------------------------------------------
	//  Create Poll
	//-----------------------------------------------------------------
 
	case 3:
 
	if ($_POST['question'] && $_POST['options'])
	{
		//-----------------------------------------------------------------
		//  Insert the poll
		//-----------------------------------------------------------------
 
		$db->insertRow("poll",array('name' => ''.$_POST['question'].'','user' => ''.$userinfo['username'].'','date' => ''.time().''));
 
 
		if ($_POST['options'])
		{
 
		//-----------------------------------------------------------------
		//  Add in the options
		//-----------------------------------------------------------------
 
		startbox("Step Two");
		$options = $_POST[options];
		echo "<form action='$PHP_SELF?page=polls&a=3' method='post'><table class='main' cellspacing='1' cellpadding='5'>";
		for ($a = 1; $a <= $options; $a++) 
		{
    			echo '<tr class="con1"><td>Option '.$a.': <input type="text" value="'.$a.'" /></td></tr>';
		}
 
		?>
 
		</table><br/>
		<table class="main" cellspacing="1" cellpadding="3">
		<tr class="con1">
			<td width="50%">Actions:</td>
			<td width="50%" align="right"><input type="submit" value="Next &raquo;" /></td>
		</tr>
		</table></form>
 
	<?php
 
		} else {
 
		//-----------------------------------------------------------------
		//  This is the part i can't figure out
		//-----------------------------------------------------------------
 
 
	} else {
 
	?>
 
	<div class="box">
	<div class="boxtitle"><?=$language['Poll add title']; ?></div>
	<div class="boxcontent">
	<form action="<?=$PHP_SELF;?>?page=polls&a=3" method="post">
	<table class="main" cellspacing="1" cellpadding="5">
		<tr class="head">
			<td width="70%"><?=$language['Poll add desc']; ?></td>
			<td width="10%" align="center"><?=$language['Poll add desc3']; ?></td>
		</tr>
		<tr class='con1'>
			<td>
			   <input type="text" name="question" class="box" style="width:100%;"  size="65" value="" />
			</td>
			<td align="center">
			   <input type="text" class="box" name="options" style="width:30px;" />
			</td>
		</tr>
	</table>
	</div></div><br/>
	<table class="main" cellspacing="1" cellpadding="3">
		<tr class="con1">
			<td width="50%">Actions:</td>
			<td width="50%" align="right"><input type="submit" value="Next &raquo;" /></td>
		</tr>
	</table></form>
 
	<?php
 
	}
 
	break;
?>

for each option there is, i want each option added into my database, that is the query and for loop i can't figure out.

Posted on Sunday 15th June 2008 at 07:09 PM

Adam981

Hmm you have a different kinda poll then im use too, id say msg MOD-Shadow, he might be able to help. unless u wanted to use the poll we hve here.

Posted on Sunday 15th June 2008 at 07:14 PM

Matt

thats when it comes to adding the poll.

PHP Code

for ($a = 1; $a <= $options; $a++) 
        {
                echo '<tr class="con1"><td>Option '.$a.': <input type="text" value="'.$a.'" /></td></tr>';
        }

Say i have 5 options, all 5 options are generated with that code, so for each option i have, i want a row created in the database, how would i do that?