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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

From ASP to PHP

Status
Not open for further replies.
shop73

shop73

IS-IT--Management
Joined
May 13, 2007
Messages
48
Location
BA
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
%>
 
Sort by date Sort by votes
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!
 
Upvote 0 Downvote
Parse error: parse error, unexpected ')', expecting ';' on line 12.

line 12

for ($i = 1, $i <= 4, $i++)
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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!
 
Upvote 0 Downvote
Fatal error: Call to undefined method stdClass::MoveNext()
 
Upvote 0 Downvote
Line 21: $rs_poll->MoveNext();
 
Upvote 0 Downvote
How to translate this asp code in php?

<%=FormatNumber((arrCount(1)/rs_poll_total*100), 2, -2, -2, -2)%>
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Do You know to make poll in PHP like this example above?
 
Upvote 0 Downvote
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());
}
?>
 
Upvote 0 Downvote
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"?



 
Upvote 0 Downvote
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;}
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

cdlvj
  • Locked
  • Question Question
PHP Debugging
Replies
1
Views
750
cdlvj
cdlvj
W
  • Locked
  • Question Question
how to send checked row data in php
Replies
0
Views
615
wiltang2004
W
P
  • Locked
  • Question Question
JPgraph - How to stop a line graph from dropping to zero?
Replies
2
Views
962
Chris Miller
Chris Miller
R
  • Locked
  • Question Question
How Can I Use MySQL To Send Data To An Email
Replies
1
Views
877
Chris Miller
Chris Miller
Mandy_crw
  • Locked
  • Question Question
How to send sms in PHP using usb gsm modem?
Replies
1
Views
868
vishvajit
vishvajit

Part and Inventory Search

Sponsor

Back
Top