[prev in list] [next in list] [prev in thread] [next in thread]
List: php-db
Subject: Re: [PHP-DB] Parse error: syntax error, unexpected '>' in C:\wamp\www\new.php
From: Sashikanth Gurram <sashi34u () vt ! edu>
Date: 2009-02-14 5:59:17
Message-ID: 49965DB5.8000703 () vt ! edu
[Download RAW message or body]
WOW,
Both of your suggestions worked like magic. Thanks a lot Patrick
-Sashi
Patrick Price wrote:
> I believe your problem is that on line 33 you forgot your closing double
> quote in the echo statement.
>
> Thanks
>
> patrick
> Sent from: Decatur Ga United States.
>
>
> On Fri, Feb 13, 2009 at 10:02 PM, Sashikanth Gurram <sashi34u@vt.edu> wrote:
>
>
>> Hi all,
>>
>> I have pasted the PHP code I wrote below. I do not know why, but I am
>> getting the parse error: unexpected '>'. It says the error is on line 38.
>> The exact line on line 38 is
>> * echo"<tr>\n*
>>
>> Basically, I am trying to execute an sql query through PHP which tries to
>> extract data from the mysql database and display the data in the browser.
>> The query is running fine but I am getting the problems when I try to
>> display the data in the browser.
>>
>> Can anyone help me with it?
>>
>> Thanks,
>> Sashi
>>
>> <?php
>> /* CONNECTS TO THE DATABASE*/
>> $host="******";
>> $user="******";
>> $password="*******";
>> $dbname="*********";
>> $cxn=mysqli_connect($host, $user, $password, $dbname);
>> if (!$cxn=mysqli_connect($host, $user, $password, $dbname))
>> {
>> $error=mysqli_error($cxn);
>> echo "$error";
>> die();
>> }
>> else
>> {
>> echo "Connection established successfully";
>> }
>> $sql="select * FROM OCCUPANCY";
>> $data=mysqli_query($cxn,$sql);
>> if (!$data=mysqli_query($cxn,$sql))
>> {
>> $error=mysqli_error($cxn);
>> echo "$error";
>> die();
>> }
>> else
>> {
>> echo "Query sent successfully";
>> }
>> echo "<br>";
>> echo "<h1>OCCUPANCY<h1>";
>> echo "<table cellspacing='5'>";
>> echo "<tr><td colspan='7'><hr /></td></tr>;
>> while ($row=mysqli_fetch_array($data))
>> {
>> extract($row);
>> echo"<tr>\n
>> <td>$building</td>\n
>> <td>$parking_lot</td>\n
>> <td>$month</td>\n
>> <td>$day</td>\n
>> <td>$occupancy</td>\n
>> <td>$empty_spaces</td>\n
>> <td>$special_days</td>\n
>> </tr>\n";
>> echo "<tr><td colspan='7'><hr /></td></tr>\n";
>> }
>> echo"</table>\n";
>> ?>
>>
>> --
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> Sashikanth Gurram
>> Graduate Research Assistant
>> Department of Civil and Environmental Engineering
>> Virginia Tech
>> Blacksburg, VA 24060, USA
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>>
>
>
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sashikanth Gurram
Graduate Research Assistant
Department of Civil and Environmental Engineering
Virginia Tech
Blacksburg, VA 24060, USA
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic