From ASP to PHP

shop73 · Jun 14, 2007

How to translate this ASP code in PHP code?
<%
'Get Poll Results using Filter
Dim arrCount(1000)
For i = 1 to 4
FilterParam = i
rs_poll.Filter = "Choice = " & FilterParam
'Count results
While NOT rs_poll.EOF
arrCount(i) = arrCount(i) + 1
rs_poll.MoveNext()
Wend
Next
%>

sleipnir214 · Jun 14, 2007

What type of object is rs_poll? Without knowing what it does, it's difficult to do more than:

Code:

<?php
//Get Poll Results using Filter
$arrCount = array();
for ($i = 1, $i <= 4, $i++)
{
	$FilterParam = i;
	$rs_poll->Filter = "Choice = " . $FilterParam;

	//Count results
	while (! $rs_poll->EOF)
	{
		$arrCount[$i]++;;
		$rs_poll->MoveNext();
	}
}
?>

Want the best answers? Ask the best questions! TANSTAAFL!

shop73 · Jun 14, 2007

Parse error: parse error, unexpected ')', expecting ';' on line 12.

line 12

for ($i = 1, $i <= 4, $i++)

jpadie · Jun 14, 2007

replace the commas with semicolons.

as rs.poll looks to be an ado db connection you might want to rework that section to use an odbc driver or similar.

sleipnir214 · Jun 15, 2007

Oops. Sorry, I didn't try to run the code as I did not have a definition for the class of which rs_poll was an object.

jpadie's right. The line:

[tt]for ($i = 1, $i <= 4, $i++)[/tt]

should read:

[tt]for ($i = 1; $i <= 4; $i++)[/tt]

Want the best answers? Ask the best questions! TANSTAAFL!

shop73 · Jun 15, 2007

Fatal error: Call to undefined method stdClass::MoveNext()

shop73 · Jun 15, 2007

Line 21: $rs_poll->MoveNext();

shop73 · Jun 15, 2007

How to translate this asp code in php?

<%=FormatNumber((arrCount(1)/rs_poll_total*100), 2, -2, -2, -2)%>

jet042 · Jun 15, 2007

That would be because we don't have a definition for $rs_poll. As sleipnir asked, what does it do?

Looking up the methods we do know, it looks like (as jpadie pointed out) an ADO Recordset object, so there is probably a set of PHP functions that will handle connecting to the database and retrieving the information. Try looking here to get the specifics, but here is a quick and dirty mock-up.

Code:

$dsn = "hostname";
$user = "username";
$pass = "password";

$conn = odbc_connect($dsn,$user,$pass) or die("Could not connect to database");

$sql = "SELECT Choice FROM [i]table_name[/i]";
$result = odbc_exec($conn,$sql);

$arrCount = array(1 => 0, 2 => 0, 3 => 0, 4 => 0);
while (odbc_fetch_row($result))
{
  $vote = odbc_result($result,"Choice");
  $arrCount[$vote]++;
}

odbc_free_result($result);
odbc_close();

Like I said, I just threw that together, so I'm sure there are errors in it. I've also never worked with ODBC in PHP, so I may have missed an important step or two. In other words, it would be a very good idea to look at the manual for ODBC connections before trying to use that code.

shop73 · Jun 15, 2007

http://www.webthang.co.uk/Tuts/tuts_dmx/dmx_poll/dmx_poll1.asp

jpadie · Jun 15, 2007

equivalent to formatstring is printf. for this specific query you might want to look at number_format

http://www.php.net/manual/en/function.number-format.php

please acclimatise yourself with the php manual at

http://www.php.net.

some might say your interaction has been a little "brusque

shop73 · Jun 15, 2007

Do You know to make poll in PHP like this example above?

jpadie · Jun 15, 2007

yes. it is straightforward.

something like this (written for mysql) should be what you are looking for. it needs a lot of bullet proofing and more input validation than I am willing to code.

the table definition is in comment tags at the top of the script.
the connection parameters for your database are in the connectToDatabase() function at the bottom of the script.

Code:

<head>
<script language="javascript">
function addQuestion(){

	var baseElem = document.getElementById("b");
	var p = baseElem.parentNode; 
	var c = p.getElementsByTagName("input");
	if (c[c.length - 1].value != ""){
		var newElem = baseElem.cloneNode(true);
		newElem.Id = '';
		var i = newElem.getElementsByTagName("input");
		i[0].value="";
		p.appendChild(newElem);
	}
}
</script>
<style type="text/css">
body, input, textarea {font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px;}
fieldset {width:60%;}
.radio {width: 30px; float: left; text-align:center;}
.label {float:left; text-align:left;}
.question {width: 90%; text-align:center;}
.spacer {visibility:hidden; line-height:1px;}
a, a:visited{text-decoration:none;}
</style>
</head>
<?php
/*
assume a database structure as
create table tablePolls
(pollID int(10) auto_increment primary key,
poll_question longtext);

create table tableResponses
(responseID int(10) auto_increment primary key,
pollID int(10),
responseText varchar(255),
responseVote int(10))
*/
error_reporting (E_ALL);
switchboard();

function switchboard(){
	connectToDatabase();
	$action = isset($_POST['action']) ? $_POST['action'] : (isset($_GET['action']) ? $_GET['action'] : "listPolls");
	
	switch ($action){
	case "displayPoll":
		displayPoll();
	break;
	
	case "listPolls":
		listPolls();
	break;
	
	case "processVote":
		processVote();
	break;
	
	case "processNewResponse":
		processNewResponse();
	break;
	
	case "createNewPoll":
		createNewPoll();
	break;
	case "processNewPoll":
		processNewPoll();
	break;
	}
	
}
function displayPoll(){
	if( isset($_GET['pollID'])){
		$pollID = mysql_real_escape_string(trim($_GET['pollID']));
	} else {
		listPolls();
		exit();
	}
	$sql = "Select poll_question from tablePolls where pollID='$pollID'";
	$sql2 = "Select responseID, responseText from tableResponses where pollID='$pollID'";
	$result = mysql_query($sql) or die(mysql_error());
	$question = mysql_result($result, 0, 0);
	$result2 = mysql_query($sql2) or die(mysql_error());
	while ($row = mysql_fetch_assoc($result2)){
		$responses[] = $row;
	}
	
	echo <<<HTML
<form method="post" action="{$_SERVER['PHP_SELF']}">
<fieldset>
	<legend>Vote Here</legend>
	<div class="row">
		<span class="question">
			$question
		</span>
	</div>

HTML;
	foreach ($responses as $response){
		echo <<<HTML
	<div class="row">
		<span class="radiobox">
			<input type="radio" name="response" value="{$response['responseID']}" />
		</span>
		<span class="label">
			{$response['responseText']}
		</span>
	</div>

HTML;
	}	//end of the foreach
	
	echo <<<HTML

	<div class="row">
		<span class="radiobox">
			&nbsp;
		</span>
		<span class="label">
			<input type="submit" value="submit" name="submit" />
			<input type="hidden" value="{$pollID}" name="pollID" />
			<input type="hidden" value="processVote" name="action"/>
		</span>
	</div>
	<div class="spacer">&nbsp;</div>
</fieldset>
</form>

HTML;
}
function listPolls(){
	$sql = "select pollID, poll_question from tablepolls";
	$result = mysql_query($sql) or die (mysql_error());
	if (mysql_num_rows($result) > 0 ) {
		while ($row = mysql_fetch_assoc($result)){
		echo <<<HTML
<a href="{$_SERVER['PHP_SELF']}?action=displayPoll&pollID={$row['pollID']}">
	{$row['poll_question']}
</a>
<br/>

HTML;
		}
	} else {
		echo "No polls created yet\r\n";
	}
	echo <<<HTML
<br/><a href="{$_SERVER['PHP_SELF']}?action=createNewPoll">Create New Poll</a>

HTML;
}
function processVote(){
	$e = true;
	if (isset($_POST['pollID'])){
		$pollID = mysql_real_escape_string(trim($_POST['pollID']));
	} else {
		$e = false;
	}
	if (isset($_POST['response'])){
		$responseID = mysql_real_escape_string(trim($_POST['response']));
	} else {
		$e=false;
	}
	if (!$e) {
		listPolls();
		exit();
	}
	
	$sql = "Update tableResponses 
			set 
			responseVote = responseVote + 1
			where
			responseID = '$responseID'";
	
	if (!mysql_query($sql)){
		die ("problem updating record");
	}
	
	displayPollResults($pollID);
	exit();
	
}

function displayPollResults($pollID){
	$sql = "Select poll_question from tablePolls where pollID='$pollID'";
	$sql2 = "Select responseText, responseVote from tableResponses where pollID='$pollID'";
	$result = mysql_query($sql) or die(mysql_error());
	$question = mysql_result($result, 0, 0);
	$result = NULL;
	$result = mysql_query($sql2) or die(mysql_error());
	$sum = 0;
	while ($row = mysql_fetch_assoc($result)){
		$sum = $sum + $row['responseVote'];
		$questions[] = $row;
	}
	$result = NULL;
	
	echo <<<HTML
<fieldset>
	<legend>Poll Results - Thank you for voting!</legend>
	<div class="row">
		<span class="question">
			$question
		</span>
	</div>

HTML;
	foreach ($questions as $question){
		$pc = number_format(($question['responseVote']/$sum) * 100,2);
		echo <<<HTML
	<div class="row">
		<span class="radiobox">
			{$question['responseVote']} ({$pc}%)
		</span>
		<span class="label">
			{$question['responseText']}
		</span>
	</div>

HTML;
	}	//end of the foreach
	
	echo <<<HTML

	<div class="spacer">&nbsp;</div>
</fieldset>
HTML;
}
function createNewPoll(){
echo <<<HTML
<form method="post" action="{$_SERVER['PHP_SELF']}">
<fieldset>
	<legend>New Poll Question</legend>
	<div class="row">
		<span class="question">
			<textarea name="question"></textarea>
		</span>
	</div>
	<div class="row">
		<span class="question">
			<input type="submit" value="submit" name="submit" />
			<input type="hidden" value="processNewPoll" name="action"/>
		</span>
	</div>
	<div class="spacer">&nbsp;</div>
</fieldset>
</form>
HTML;
}
function processNewPoll(){
	if (isset($_POST['question'])){
		$question = mysql_real_escape_string(trim($_POST['question']));
	} else {
		createNewPoll();
		exit();
	}
	
	$sql = "Insert into tablePolls set poll_question = '$question', pollID=NULL";
	mysql_query($sql) or die(mysql_error());
	$pollID = mysql_insert_id();
	createNewResponse($pollID);
}
function createNewResponse($pollID){
	$sql = "Select poll_question from tablePolls where pollID='$pollID'";
	$result = mysql_query($sql) or die(mysql_error());
	$question = mysql_result($result, 0, 0);
	echo <<<HTML
<form method="post" action="{$_SERVER['PHP_SELF']}">
<fieldset>
	<legend>Create a new Answer</legend>
	<div class="row">
		<span class="question">
			$question
		</span>
	</div>
	<div id="holder">
	<div class="row" id="b">
		<span class="response">
			<input type="text" name="response[]" />
		</span>
	</div>
	</div>
	<div class="row">
		<span class="response">
			<input type="button" value="Add New Response" onClick="addQuestion(); return false;">
			<input type="submit" value="Save Questions" name="submit">
			<input type="hidden" value="{$pollID}" name="pollID" />
			<input type="hidden" value="processNewResponse" name="action"/>
		</span>
	</div>
	<div class="spacer">&nbsp;</div>
</fieldset>
</form>

HTML;
}

function processNewResponse(){
	$e= true;
	if(isset($_POST['response'])){
		$response = $_POST['response'];
	} else {
		$e = false;
	}
	if(isset($_POST['pollID'])){
		$pollID = mysql_real_escape_string(trim($_POST['pollID']));
	} else {
		$e = false;
	}
	if (!$e){
		die ("error processing responses");
	}
	foreach ($response as $r){
		$values[] = "('".mysql_real_escape_string(trim($r))."',0, $pollID, null)";
	}
	$sql = "Insert into tableResponses (responseText, responseVote, pollID, responseID) values " . implode(",", $values);
	mysql_query($sql);
	listPolls();
}
function connectToDatabase(){
	mysql_connect("localhost", "root", "root") or die (mysql_error());
	mysql_select_db("polls") or die(mysql_error());
}
?>

shop73 · Jun 17, 2007

This script works but one error (radio button is on the top of question) like:

O
Red O
Blue O
White

How to put radio button in the row where is question "White"?

jpadie · Jun 17, 2007

that's just a css glitch.

change the styles to the following

Code:

body, input, textarea {font-family:Verdana, Arial, Helvetica, sans-serif; font-size:11px;}
fieldset {width:60%;}
.radiobox {width: 30px; float: left; text-align:center;}
.label {float:left; text-align:left; width: 100px;}
.question {width: 90%; text-align:center;}
.spacer {visibility:hidden; line-height:1px; clear:both;}
.row {clear:both;}
a, a:visited{text-decoration:none;}

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

From ASP to PHP

shop73

IS-IT--Management

sleipnir214

Programmer

shop73

IS-IT--Management

jpadie

Technical User

sleipnir214

Programmer

shop73

IS-IT--Management

shop73

IS-IT--Management

shop73

IS-IT--Management

jet042

MIS

shop73

IS-IT--Management

jpadie

Technical User

shop73

IS-IT--Management

jpadie

Technical User

shop73

IS-IT--Management

jpadie

Technical User

Similar threads

Part and Inventory Search

Sponsor