Another Parse/T_String Error

Inklink · January 30, 2007

Hi guys :) .

First, I'd like to let you know that I'm pretty new to PHP, so I don't really have an understanding of the language as of yet. I'm still learning :) .

Anyway, I was wondering if you could help me with the following:

I have a database with nearly 1 million businesses from the province of Ontario. Now I've uploaded this database to this site which hosts large databases.

Now the site I'm currently testing my stuff on is:
[url=http://www.ovechkin.info/ontario/]http://www.ovechkin.info/ontario/[/url]

You'll see a search thing on the page. When I enter nothing at all and press search, it takes me to the results page. That's fine.

But when I enter something into it, it says:

[code]Parse error: syntax error, unexpected T_STRING in /home/snake/public_html/ontario/db.php on line 3[/code]

Now I for the life of me can't figure out what on earth that means :D .

I have 3 files for this thing:

[b](1)[/b]index.php (whose code I copied to the aforementioned link so that it can be in my template)

[b](2)[/b]db.php Below is it's contents
[code]<?php
$db = mysql_connect("free-mysql.BizHostNet.com:3306", "1167951294", "MYPASSWORD"
mysql_select_db("1167951294", $this->conn)
?>[/code]

[b](3)[/b] results.php
[code]
<?php

$MATCHES_OVERRIDE = -1; //set to -1 to disable override

function ReturnMatches($q, $city, $name, $matches, $first)
{

global $MATCHES_OVERRIDE;

if ($q) {
if (!$first) {
$first = 0;
}
if (!$matches) {
//default
$matches = 30;
if (!$ads) {
$ads = 0;
}
}

if ($MATCHES_OVERRIDE > 0) {
$matches = $MATCHES_OVERRIDE;
}

include 'db.php';

$db = @mysql_connect($DATABASE_SERVER, $DATABASE_USER, $DATABASE_PASSWORD)
or die(" Error connecting to database or server too busy: Try again later.");// . mysql_error());
mysql_select_db($DATABASE_NAME, $db);

$query = "SELECT List.* ";
$query .= ",MATCH(keywords1, keywords2, city, name) AGAINST (' . $q . ' IN BOOLEAN MODE) AS Relevance ";
$query .= "FROM List ";
$query .= "WHERE MATCH(keywords1, keywords2, city, name) AGAINST (' . $q . ' IN BOOLEAN MODE) HAVING Relevance > 0.03 ";

$query .= "ORDER BY Relevance DESC ";
$query .= "LIMIT " . $first . "," . $matches;

$result = mysql_query($query, $db)

or die(" Error executing query: " . mysql_error() . "\n");

$row = mysql_fetch_array($result);

mysql_close($db);

echo "<html> \n";
echo "<head> \n";
echo "<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\n";
echo "<title>$q</title> \n";
?>

<script language="JavaScript">
function blockError(){return true;}
window.onerror = blockError;
</script>

</head>
<body link="#000000" vlink="#808080" topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" text="#30305A" bgcolor="#FFFFFF">

<?PHP

echo "<table width=\"100%\" background=\"background.gif\" cellspacing=\"0\" style=\"border-top:1px groove #C0C0C0; border-bottom-style:groove\"><tr><td width=\"33%\">\n";
echo "   $q\n";

echo " Listings " . ($first+1) . " to " . ($first+$matches) . " \n";
echo " </td>\n";

echo "<td width=\"64%\">\n";

if ($first == 0) {
echo "";
} else {
echo "<a style=\"text-decoration: none\" href=\"q.php?q=" . $q . "&matches=" . $matches . "&first=" . ($first-$matches) . "\" >Prev</a> | ";
}
echo " ";
if ($no_results == 1) {
echo "Next";
} else {
echo "<a style=\"text-decoration: none\" href=\"q.php?q=" . $q . "&matches=" . $matches . "&first=" . ($first+$matches) . "\" >Next</a>  \n";
}
echo "</td></tr></table>  \n";

if ($first == 0) {
echo "";
} else {
echo "";
}

if ($no_results == 1) {

echo "No More Results";

} else {

}

$no_results = 0;
if ($row) {
do {

echo "\n";
printf("<img src=\"clip.gif\"> <a href=\"businesspage.php?telephone=%s&geo=%s %s %s %s\" >%s</a> \n", $row["telephone"], $row["address"], $row["city"], $row["state"], $row["zip"], $row["name"]);
printf("     %s \n", $row["address"]);
printf(" %s, %s %s \n", $row["city"], $row["state"], $row["zip"]);
printf("     Tel: %s   Fax: %s \n", $row["telephone"], $row["fax"]);
printf("     Category: %s // %s \n", $row["keywords1"], $row["keywords2"]);

} while ($row = mysql_fetch_array($result));
} else {
$no_results = 1;
echo "\n";
if ($first == 0) {

} else {
echo "No more results found. \n";

}
}

}
}

ReturnMatches($q, $city, $name, $matches, $first);

if ($first == 0) {
echo "";
} else {
echo "";
}

if ($no_results == 1) {

echo "No More Results";

} else {

}

?>

</blockquote>

Copyright 
(c) All Rights Reserved - YOUR BUSINESS NAME 

</body></html>

[/code]

What am I doing wrong?

Thanks and take care :)
Inklink

wildteen88 · January 30, 2007

The problem is with db.php:
[code=db.php]<?php
$db = mysql_connect("free-mysql.BizHostNet.com:3306", "1167951294", "MYPASSWORD"
mysql_select_db("1167951294", $this->conn)
?>[/code]
Your code has a few majour issues. Which are you havn't closed the mysql_connect function and the secound you are not ending your lines with semi-colons. This is how you code should be:
[code]<?php
$db = mysql_connect("free-mysql.BizHostNet.com:3306", "1167951294", "MYPASSWORD");
mysql_select_db("1167951294", $this->conn);
?>[/code]

Also this is not an installation issue either. Moving to PHP Hep forum.

Inklink · January 30, 2007

Hey, thanks for helping me out :) .

And sorry for putting it in the wrong forum.

I've updated the file, and now I get:

[quote]
Fatal error: Using $this when not in object context in /home/snake/public_html/ontario/db.php on line 3[/quote]

Your help is greatly appreciated.

Thanks,
Inklink

wildteen88 · January 31, 2007

Chnage:
[code=php:0]mysql_select_db("1167951294", $this->conn);[/code]
to this:
[code=php:0]mysql_select_db("1167951294", $conn);[/code]

you should only use $this-> when in a class.

Sign In

Another Parse/T_String Error

Recommended Posts

Inklink

Link to comment

Share on other sites

wildteen88

Link to comment

Share on other sites

Inklink

Link to comment

Share on other sites

wildteen88

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information