/    Sign up×
Community /Pin to ProfileBookmark

Parse error: syntax error, unexpected $end in

Hi all,

I just started PHP programming a few hours ago. I was using ASP before. When I use the codes written below, I get the following error:
“Parse error: syntax error, unexpected $end in C:WebSpacecontrolledhostspropertysearchturkeyproperty-search.php on line 107”

Does anybody have an idea about the possible reasons?

Thanks
telmessos

<?php
if ( ! isset($location) ) {
$location=”Bodrum”;
}
$baglan=mysql_connect ( “localhost”, “root”, “passwd” );
mysql_select_db (“ceyhun”);
$sorgu=”Select *from locations”;
$sorgu2=”Select *
from sublocations where LocID=’$location'”;
?>
<html>

<head>
<meta http-equiv=”Content-Type” content=”text/html; charset=windows-1254″>
<title>Location</title>
<script>
function changelst_a()
{
var location = document.getElementById(“location”);
if(location.value != “#”) document.location.href = “property-search.htm?location=” + location.value;
}
</script>
</head>

<body topmargin=0 leftmargin=10>
<center><img border=”0″ src=”images/propertysearch.gif” width=”155″ height=”52″></center><div align=”center”>
<table border=”0″ width=”192″ cellspacing=”1″ cellpadding=”0″ id=”table5″>
<form method=”POST” action=”property-search.htm”>
<tr>
<td width=”190″ colspan=”2″>
<font style=”font-family: Verdana; font-size: 8pt” color=”#627CC9″>Location:</font></td>
</tr>
<tr>
<td width=”190″ colspan=”2″>
<select size=”1″ name=”location” id=”location” onchange=changelst_a() style=”font-family: Verdana; font-size: 8pt”>
<?php
while ( $oku = mysql_fetch_assoc ( $sorgu ) ) {
if ( $oku[locationadi] = $location) {
echo “<option selected value=$oku[locationadi]>$oku[locationadi]</option>”;
}
else {
echo “<option value=$oku[locationadi]>$oku[locationadi]</option>”;
?>
</select></td>
</tr>
<tr>
<td width=”190″ colspan=”2″>
<font style=”font-family: Verdana; font-size: 8pt” color=”#627CC9″>Sublocation:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Property Type:</font></td>
</tr>
<tr>
<td width=”97″>
<select size=”1″ name=”MevkiiNo” style=”font-family: Verdana; font-size: 8pt”>
<?php
while ( $oku2 = mysql_fetch_assoc ( $sorgu2 ) ) {
echo “<option value=$oku2[SubLocation]>$oku2[SubLocation]</option>”;
?>

</select>
</td>
<td width=”92″>
<select size=”1″ name=”PropertyType” style=”font-family: Verdana; font-size: 8pt”>
<option value=”1″ selected>All</option>
<option value=”2″>Villa</option>
<option value=”3″>Apart</option>
<option value=”4″>Inv.Project</option>
</select></td>
</tr>
<tr>
<td width=”190″ colspan=”2″>
<font style=”font-family: Verdana; font-size: 8pt” color=”#627CC9″>Price:</font></td>
</tr>
<tr>
<td width=”190″ colspan=”2″>
<select size=”1″ name=”Price” style=”font-family: Verdana; font-size: 8pt”>
<option value=”1″ selected>All</option>
<option value=”2″>20.000 – 40.000</option>
<option value=”3″>40.000 – 60.000</option>
<option value=”4″>60.000 – 80.000</option>
<option value=”5″>80.000 – 100.000</option>
<option value=”6″>100.000 – 150.000</option>
<option value=”7″>150.000 &gt;</option>
</select></td>
</tr>
<tr>
<td width=”190″ colspan=”2″>
<font style=”font-family: Verdana; font-size: 8pt” color=”#627CC9″>Currency:</font></td>
</tr>
<tr>
<td height=”13″ width=”190″ colspan=”2″>
<select size=”1″ name=”cur” style=”font-family: Verdana; font-size: 8pt”>
<option value=”GBP” selected>GBP</option>
<option value=”EURO”>EURO</option>
<option value=”USD”>USD</option>
</select><font size=”1″>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</font>
<input type=”submit” value=”Search” name=”B1″ style=”font-size: 8pt; font-family: Verdana; border-style: outset; border-width: 1px” onClick=”

form . action = ‘propertysearch.asp’
form . target = ‘_top’
form . submit (); “></td>
</tr>
</form>
</table>
</body>

</html>
<?php
mysql_close($baglan);
?>

to post a comment
PHP

4 Comments(s)

Copy linkTweet thisAlerts:
@chesemonkylomaSep 17.2006 — <?php

mysql_close($baglan);}

?>

or

<?php

}mysql_close($baglan);

?>
Copy linkTweet thisAlerts:
@chesemonkylomaSep 17.2006 — you never closed your while loop
Copy linkTweet thisAlerts:
@telmessosauthorSep 17.2006 — Thanks for the help. Do I have to close the connection at the end of every file? I was using ASP and it is a must to close connection in that language. Is it the same in PHP??
Copy linkTweet thisAlerts:
@telmessosauthorSep 17.2006 — Now I closed all brackets and I get the following error + for some reason my loop is not working. I get onyl empty drop down menus ?. I checked the database and all field names are true.

Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in C:WebSpacecontrolledhostspropertysearchturkeyproperty-search.php on line 109


<?php

if ( ! isset($location) ) {

$location="Bodrum";

}

$baglan = mysql_connect ( "localhost", "root", "passwd" ) || die ("MySQL'e baglanamadim");

mysql_select_db ( "ceyhun" ) || die ("Veritaban&#305;n&#305; seçemedim");

$sorgu="Select *from locations";

$sorgu2="Select *
from sublocations where LocID='$location'";

?>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">

<title>Location</title>

<script>

function changelst_a()

{

var location = document.getElementById("location");

if(location.value != "#") document.location.href = "property-search.htm?location=" + location.value;

}

</script>

</head>

<body topmargin=0 leftmargin=10>

<center><img border="0" src="images/propertysearch.gif" width="155" height="52"></center><div align="center">

<table border="0" width="192" cellspacing="1" cellpadding="0" id="table5">

<form method="POST" action="property-search.htm">

<tr>

<td width="190" colspan="2">

<font style="font-family: Verdana; font-size: 8pt" color="#627CC9">Location:</font></td>

</tr>

<tr>

<td width="190" colspan="2">

<select size="1" name="location" id="location" onchange=changelst_a() style="font-family: Verdana; font-size: 8pt">

<?php

while ( $oku = mysql_fetch_assoc ( $sorgu ) ) {

if ( $oku[locationadi] = $location) {

echo "<option selected value=$oku[locationadi]>$oku[locationadi]</option>";

}

else {

echo "<option value=$oku[locationadi]>$oku[locationadi]</option>";

}

}

?>

</select></td>

</tr>

<tr>

<td width="190" colspan="2">

<font style="font-family: Verdana; font-size: 8pt" color="#627CC9">Sublocation:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Property Type:</font></td>

</tr>

<tr>

<td width="97">

<select size="1" name="MevkiiNo" style="font-family: Verdana; font-size: 8pt">

<?php

while ( $oku2 = mysql_fetch_assoc ( $sorgu2 ) ) {

echo "<option value=$oku2[SubLocation]>$oku2[SubLocation]</option>";

}

?>

</select>
</td>
<td width="92">
<select size="1" name="PropertyType" style="font-family: Verdana; font-size: 8pt">
<option value="1" selected>All</option>
<option value="2">Villa</option>
<option value="3">Apart</option>
<option value="4">Inv.Project</option>
</select></td>
</tr>
<tr>
<td width="190" colspan="2">
<font style="font-family: Verdana; font-size: 8pt" color="#627CC9">Price:</font></td>
</tr>
<tr>
<td width="190" colspan="2">
<select size="1" name="Price" style="font-family: Verdana; font-size: 8pt">
<option value="1" selected>All</option>
<option value="2">20.000 - 40.000</option>
<option value="3">40.000 - 60.000</option>
<option value="4">60.000 - 80.000</option>
<option value="5">80.000 - 100.000</option>
<option value="6">100.000 - 150.000</option>
<option value="7">150.000 &gt;</option>
</select></td>
</tr>
<tr>
<td width="190" colspan="2">
<font style="font-family: Verdana; font-size: 8pt" color="#627CC9">Currency:</font></td>
</tr>
<tr>
<td height="13" width="190" colspan="2">
<select size="1" name="cur" style="font-family: Verdana; font-size: 8pt">
<option value="GBP" selected>GBP</option>
<option value="EURO">EURO</option>
<option value="USD">USD</option>
</select><font size="1">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</font>
<input type="submit" value="Search" name="B1" style="font-size: 8pt; font-family: Verdana; border-style: outset; border-width: 1px" onClick="

form . action = 'propertysearch.asp'

form . target = '_top'

form . submit (); "></td>

</tr>

</form>

</table>

</body>

</html>

<?php

mysql_close ( $baglan ) ;

?>
×

Success!

Help @telmessos spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 BETA 5.28,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @AriseFacilitySolutions09,
tipped: article
amount: 1000 SATS,

tipper: @Yussuf4331,
tipped: article
amount: 1000 SATS,

tipper: @darkwebsites540,
tipped: article
amount: 10 SATS,
)...