Ask a Question related to Dreamweaver AppDev, Design and Development.
-
jafra #1
PHP/MySQl Parse Error
I've can seem to get Dreamweaver's Live Data View to work with my PHP/MySQL
page. As I attempt to learn PHP/MySQL via MMDW Tutorial the TrioMotors Customer
Comment page will not preview due to a parse error on line 8 (see provided
code). I've made sure my local OS X web serve is set to parse PHP and PHPS file
extensions via the Panther Server Admin Tool. PHP and MySQL services have also
been turned on.
<?php require_once('Connections/connTrio.php'); ?>
<?php
$maxRows_rs_Comments = 10;
$pageNum_rs_Comments = 0;
if (isset($_GET['pageNum_rs_Comments'])) {
$pageNum_rs_Comments = $_GET['pageNum_rs_Comments'];
}
$startRow_rs_Comments = $pageNum_rs_Comments * $maxRows_rs_Comments;
mysql_select_db($database_connTrio, $connTrio);
$query_rs_Comments = "SELECT * FROM comments ORDER BY LAST_NAME ASC";
$query_limit_rs_Comments = sprintf("%s LIMIT %d, %d", $query_rs_Comments,
$startRow_rs_Comments, $maxRows_rs_Comments);
$rs_Comments = mysql_query($query_limit_rs_Comments, $connTrio) or
die(mysql_error());
$row_rs_Comments = mysql_fetch_assoc($rs_Comments);
if (isset($_GET['totalRows_rs_Comments'])) {
$totalRows_rs_Comments = $_GET['totalRows_rs_Comments'];
} else {
$all_rs_Comments = mysql_query($query_rs_Comments);
$totalRows_rs_Comments = mysql_num_rows($all_rs_Comments);
}
$totalPages_rs_Comments = ceil($totalRows_rs_Comments/$maxRows_rs_Comments)-1;
?>
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Trio Motors Home Page</title>
<link rel="stylesheet" href="Assets/CSS/divs.css" type="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<style type="text/css">
<!--
p.sidebar-text {
font-size:80%;
font-family:Verdana;
}
#SplashImage {
float: left;
}
.navbar {
white-space: nowrap;
}
-->
</style>
<link href="Assets/CSS/Level1_Verdana.css" rel="stylesheet" type="text/css" />
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length;
i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
var p,i,x; if(!d) d=document;
if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++)
x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++)
x=MM_findObj(n,d.layers[i].document);
if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_nbGroup(event, grpName) { //v6.0
var i,img,nbArr,args=MM_nbGroup.arguments;
if (event == "init" && args.length > 2) {
if ((img = MM_findObj(args[2])) != null && !img.MM_init) {
img.MM_init = true; img.MM_up = args[3]; img.MM_dn = img.src;
if ((nbArr = document[grpName]) == null) nbArr = document[grpName] = new
Array();
nbArr[nbArr.length] = img;
for (i=4; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) !=
null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = img.MM_dn = args[i+1];
nbArr[nbArr.length] = img;
} }
} else if (event == "over") {
document.MM_nbOver = nbArr = new Array();
for (i=1; i < args.length-1; i+=3) if ((img = MM_findObj(args[i])) !=
null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = (img.MM_dn && args[i+2]) ? args[i+2] : ((args[i+1])? args[i+1]
: img.MM_up);
nbArr[nbArr.length] = img;
}
} else if (event == "out" ) {
for (i=0; i < document.MM_nbOver.length; i++) {
img = document.MM_nbOver[i]; img.src = (img.MM_dn) ? img.MM_dn :
img.MM_up; }
} else if (event == "down") {
nbArr = document[grpName];
if (nbArr)
for (i=0; i < nbArr.length; i++) { img=nbArr[i]; img.src = img.MM_up;
img.MM_dn = 0; }
document[grpName] = nbArr = new Array();
for (i=2; i < args.length-1; i+=2) if ((img = MM_findObj(args[i])) !=
null) {
if (!img.MM_up) img.MM_up = img.src;
img.src = img.MM_dn = (args[i+1])? args[i+1] : img.MM_up;
nbArr[nbArr.length] = img;
} }
}
//-->
</script>
</head>
<body
onload="MM_preloadImages('Assets/images/btnShowroom_on.jpg','Assets/images/btnNe
ws_on.jpg','Assets/images/btnOwners_on.jpg','Assets/images/btnServices_on.jpg')"<div id="row1">>
<div class="logo"><img src="Assets/images/trio_logo.jpg" alt="Trio Motors"
name="Banner" width="600" height="41" id="Banner" /></div>
<div class="navbar"><a href="showroom.html" target="_top"
onclick="MM_nbGroup('down','group1','showroom_butt on','',1)"
onmouseover="MM_nbGroup('over','showroom_button',' Assets/images/btnShowroom_on.j
pg','',1)" onmouseout="MM_nbGroup('out')"><img
src="Assets/images/btnShowroom.jpg" alt="" name="showroom_button" width="151"
height="40" border="0" id="showroom_button" onload="" /></a><a href="news.html"
target="_top" onclick="MM_nbGroup('down','group1','news_button', '',1)"
onmouseover="MM_nbGroup('over','news_button','Asse ts/images/btnNews_on.jpg','',1
)" onmouseout="MM_nbGroup('out')"><img src="Assets/images/btnNews.jpg" alt=""
name="news_button" width="150" height="40" border="0" id="news_button"
onload="" /></a><a href="owners.html" target="_top"
onclick="MM_nbGroup('down','group1','owners_button ','',1)"
onmouseover="MM_nbGroup('over','owners_button','As sets/images/btnOwners_on.jpg',
'',1)" onmouseout="MM_nbGroup('out')"><img src="Assets/images/btnOwners.jpg"
alt="" name="owners_button" width="150" height="40" border="0"
id="owners_button" onload="" /></a><a href="services.html" target="_top"
onclick="MM_nbGroup('down','group1','services_butt on','',1)"
onmouseover="MM_nbGroup('over','services_button',' Assets/images/btnServices_on.j
pg','',1)" onmouseout="MM_nbGroup('out')"><img
src="Assets/images/btnServices.jpg" alt="" name="services_button" width="149"
height="40" border="0" id="services_button" onload="" /></a></div>
</div>
<div id="main">
<div id="col2">
<div id="feature">
<h1>Customer Comments</h1>
<table width="60%" border="1" cellspacing="2" cellpadding="2"
summary="This table lists all the comments that visitors to this site have
entered into the database.">
<tr>
<th scope="col">First Name</th>
<th scope="col">Last Name </th>
<th scope="col">E-Mail Address </th>
<th scope="col">Comments</th>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_rs_Comments['FIRST_NAME']; ?></td>
<td><?php echo $row_rs_Comments['LAST_NAME']; ?></td>
<td><?php echo $row_rs_Comments['EMAIL']; ?></td>
<td><?php echo $row_rs_Comments['COMMENTS']; ?></td>
</tr>
<?php } while ($row_rs_Comments = mysql_fetch_assoc($rs_Comments)); ?>
</table>
<p> </p>
</div>
</div>
<div id="col1">
<h2>Previews & More</h2>
<p><img src="Assets/images/preview.jpg" alt="" /></p>
<p class="sidebar-text">We are excited to offer you a glimpse of next
year's
TRIO models. We're applying our technology not just to compact cars, but
also to sedans and SUVs. These prototypes are evidence of our commitment
to giving drivers what they want while being environmentally conscious.
</p>
<p> </p>
</div>
</div>
</body>
</html>
<?php
mysql_free_result($rs_Comments);
?>
jafra Guest
-
PHP Parse error: parse error, unexpected t_string
Thanks for your advice. It was a painstaking exercise and highly frustrating not being able to start Live data. Peter Kamstra -
#25256 [Opn->Bgs]: Parse error: parse error, unexpected $ in ... on line 642
ID: 25256 Updated by: iliaa@php.net Reported By: a dot schat at streamedge dot com -Status: Open +Status: ... -
#25256 [Bgs->Opn]: Parse error: parse error, unexpected $ in ... on line 642
ID: 25256 User updated by: a dot schat at streamedge dot com Reported By: a dot schat at streamedge dot com -Status: ... -
#25256 [NEW]: Parse error: parse error, unexpected $ in ... on line 642
From: a dot schat at streamedge dot com Operating system: Linux PHP version: 4.3.1 PHP Bug Type: Compile Failure Bug... -
Parse error: parse error, expecting `','' or `';''
I'm getting the following error Parse error: parse error, expecting `','' or `';'' in /home/notarywe/public_html/php/update2.php on line 108 Here... -
Michael Fesser #2 Re: PHP/MySQl Parse Error
.oO(jafra)
What was the exact error message?>I've can seem to get Dreamweaver's Live Data View to work with my PHP/MySQL
>page. As I attempt to learn PHP/MySQL via MMDW Tutorial the TrioMotors Customer
>Comment page will not preview due to a parse error on line 8 (see provided
>code).
Micha
Michael Fesser Guest
-
jafra #3 Re: PHP/MySQl Parse Error
"Live Data Error
An error occured while requesting the document from the testing server:
Parse error: parse error in
/Users/williamr/Sites/MySampleApp/comments-view_noyv6d1nmq.php on line 8"
Line 8 code reads: $startRow_rs_Comments = $pageNum_rs_Comments *
$maxRows_rs_Comments;
jafra Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
