How to mix html and database data inside php?

gepner

I am enclosing the html for a form inside a block of php, and need to intersperse data from a table.

The second line of this piece of php generates errors that I cant fix.

echo "<form action = 'slide.php' method='post'>";
echo "<div align=\"left\">$row_Recordset1['Title']<br>";
etc
etc
echo "</form>"

The last time I tried this I got a parse error
unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

Is this a quoting problem or something else?
Any help appreciated.

Ivan Gepner
gepner@monmouth.edu

prinzcy

what do you really want to do anyway? i'm sorry, it just that i don't understand your question😕

travelbuff

I didn't seem anything obvious in the code you posted. When I get those errors it is almost always some simple syntax error - forgetting the ;, not closing an if or else statement } or trailing whitespace after some heredoc text. The line number given by the error is not necessarily where the error is - it is where the bad syntax finally causes the parser to trip up. Please post the code starting with the major control structure above to 3 lines after the line number referenced in the error and we can take a look.

dianaqt

I believe your missing a ;

it should be:

echo "</form>";

not:

echo "</form>"

gepner

Here is the entire document - some of it like the session stuff at the top is there for experimenting.

<?php require_once('Connections/connect.php'); ?>
<?php
// FELIXONE - 2002 SB by Felice Di Stefano - www.felixone.it
if (!session_id()) session_start();
if (isset($HTTP_POST_VARS['questionnum'])) {$questionnumber = $HTTP_POST_VARS['questionnum'];
session_register("questionnumber");
}

// FELIXONE - 2002 SB by Felice Di Stefano - www.felixone.it
if (!session_id()) session_start();
if (isset($HTTP_POST_VARS['question'])) {$thequestion = $HTTP_POST_VARS['question'];
session_register("thequestion");
}

<?php
$colname_Recordset1 = "1";
if (isset($GET['ID'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $GET['ID'] : addslashes($_GET['ID']);
}
mysql_select_db($database_connect, $connect);
$query_Recordset1 = sprintf("SELECT * FROM question WHERE ID = %s", $colname_Recordset1);
$Recordset1 = mysql_query($query_Recordset1, $connect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>slide page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript" type="text/JavaScript">
<!--

function placeAnswer(question_number,ans) {
if (ans == 't')
eval("document.forms[0].question" + question_number).value = <?php echo $row_Recordset1['ID']; ?>+' = correct';

else
 eval("document.forms[0].question" + question_number).value = <?php echo $row_Recordset1['ID']; ?>+' = incorrect';

};

function MM_popupMsg(msg) { //v1.0
alert(msg);
}
//-->
</script>
<style type="text/css">

</style>
</head>

<body>
<?php
if(isset($POST['submit'])){

$question = $POST['question'];
$questionnum = $POST['questionnum'];
print "$questionnum";

print 'Answer for question' . $questionnum . 'has been recorded - Click on another structure to continue';

} else {
echo "<form action = 'slide.php' method='post'>";
echo "<div align=\'left\'> {$row_Recordset1['Title']} <br>";
echo "<img src={$row_Recordset1['ImageLink']} border='0' usemap='#thirdcleavage'>";
echo "<map name='thirdcleavage' id='thirdcleavage'>";
echo "<area shape='poly' coords= {$row_Recordset1['Map']} href='javascript:placeAnswer('1','t');'>";
echo "<area shape='rectangle' coords='0,-1,1000,999' href='javascript:placeAnswer('1','f');'>";
echo "</map>";
print "{$row_Recordset1['Text']} <br />";
print "<input name='question' type='text' id='question1'>";

echo "<input name='questionnum' type='hidden' id='questionnum' value={$row_Recordset1['ID']}> </div>";
echo "<input name='Submit' type='submit' value='Submit your answer'>";
echo "</form>";
?>
<p>
<?php
print_r($SESSION['thequestion']);
mysql_free_result($Recordset1);
?>
</p>
</body>
</html>

Thanks for looking at this.

Ivan Gepner
gepner@monmouth.edu

travelbuff

looks like your missing the closing } from your final }else{ structure 😉

gepner

I stared for hours and did not see the missing }

travelbuff

Been there, done that 😉

since I am still learning, one thing I do is comment the hell out of my code. It can really help when you are troubleshooting or when you have 500 or 600 lines of code to sort out.

For example, when I open and If - Else, I start by completing the whole structure and commenting it:

If ($foo=$bar) { // if-else 1 - variable match to start record insertion

} else {  //else for if-else 1

} //close if-else 1

Then I go back and fill in the code between structures. I have some scripts that have 4 or 5 nested conditionals, and let me tell you, doing it this way may seem cheesy but it beats the hell out of spending 3hrs looking for a missing }!

HTH,