unexpected T_STRING for mysql_connect line

james1052

My site yields the following error:

"Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /www/index.php on line 15"

Here is the content of /www/index.php:

<html>
<head>
<title>Testing 123</title>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
</head>
<body>

<p>HTTP is working!</p>
<?php
error_reporting( E_ALL );
ini_set( 'display_errors', 1 );
echo "PHP is working!";
echo "If you see data below, then MySQL is working..."
// Make a MySQL Connection
mysql_connect('127.0.0.1', 'root', 'thepassword');
// Select database
mysql_select_db("test") or die("Unable to select database");
// Retrieve data from the table
$result = mysql_query("select * from awesome_people") or die("Unable to
// store the record of the table into $row
$row = mysql_fetch_array($result);
// Print out the contents of the entry
echo $row
//echo "Awesomeness Level -- 10 is highest".$row['awesomeness_level'];
//echo "Name".$row['name'];
?>
</body>
</html>

Can anyone help? Wore out Google...

bradgrafelman

Couple of things you can do in the future:

Post only the contents of the script, not a formatted output with line numbers.
Use the board's [noparse]
```
..
```
[/noparse] bbcode tags when posting PHP code as they make your code much easier to read and analyze.

Now that I've added these tags, it should become apparent where the problem is. Notice how the color coding (something your editor should be doing, by the way...) goes haywire here:

$result = mysql_query("select * from awesome_people") or die("Unable to
// store the record of the table into $row

? You chopped off the end of the die() statement at the end of that line.

james1052

...there may be a duplicate thread to this one...due to the fact that I tried again after not seeing the thread appear in the forum after creating... 🙁

james1052

thanks....fixing now and will let you know...

bradgrafelman

james1052;10967680 wrote:
...there may be a duplicate thread to this one..

There isn't; both threads got caught in our automatic spam filter, and I approved this one and deleted the duplicate. 🙂

james1052

Okay, it appears that my incorrect use of the bbcode did garble things. So here it is with the correct php tag...It seems that the line you mentioned is actually good?

<html>
<head>
<title>Testing 123</title>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
</head>
<body>

<p>HTTP is working!</p>
<?php
error_reporting( E_ALL );
ini_set( 'display_errors', 1 );
echo "PHP is working!";
echo "If you see data below, then MySQL is working..."
// Make a MySQL Connection
mysql_connect('127.0.0.1', 'user', 'pass');
// Select database
mysql_select_db("test") or die("Unable to select database");
// Retrieve data from the table
$result = mysql_query("select * from awesome_people") or die("Unable to retrieve data from table");
// store the record of the table into $row
$row = mysql_fetch_array($result);
// Print out the contents of the entry
echo $row
//echo "Awesomeness Level -- 10 is highest".$row['awesomeness_level'];
//echo "Name".$row['name'];
?>
</body>
</html>

bradgrafelman

Ah, that looks a bit better.

In that case, you're missing a terminating semicolon after the echo statement on line #13.

EDIT: Also note that there is a thread entitled Parse Error: syntax error that is dedicated to parse errors in the Coding forum. In the future, you might want to scan through that thread as there are only a small number of very common parse errors (missing semicolon, missing closing brace, etc.).

james1052

thanks...fixing now...oops can you please delete that password from my above post? --- i remembered the first time but forgot this last time!

bradgrafelman

james1052;10967690 wrote:
oops can you please delete that password from my above post?

Already did that just after I replied above. :p

james1052

Okay the initial problem has been solved and for this I am very grateful!

It seems that I have messed up something else though which is causing the following output:

"HTTP is working!

PHP is working!

If you see data below, then MySQL is working...
Array"

The word Array is not right...hmmm. Below is the latest version of the code.

<html>
<head>
<title>Testing 123</title>
<meta http-equiv="Content-Type" content="text/html;charset=utf-8" />
</head>
<body>
<p>HTTP is working!</p>
<?php
error_reporting( E_ALL );
ini_set( 'display_errors', 1 );
echo "PHP is working! <br> \n";
echo " <br> \n";
echo "If you see data below, then MySQL is working...<br> \r";
// Make a MySQL Connection
mysql_connect('127.0.0.1', 'root', 'pass');
// Select database
mysql_select_db("test") or die("Unable to select database");
// Retrieve data from the table
$result = mysql_query("select * from awesome_people") or die("Unable to retrieve data from table");
// store the record of the table into $row
$row = mysql_fetch_array($result);
// Print out the contents of the entry
echo $row
//echo "Awesomeness Level -- 10 is highest".$row['awesomeness_level'];
//echo "Name".$row['name'];
?>
</body>
</html>

bradgrafelman

james1052;10967697 wrote:
The word Array is not right

Of course it is; [man]mysql_fetch_array/man returns an [man]array[/man].

james1052

So what would be a good way for me to fetch and then echo the contents of the awesome_people table?

bradgrafelman

That would largely depend on two things:

The structure of the table
How you want to display it

james1052

Below is the table. I would like to display the entire contents of the table. Thanks for your help!

mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from awesome_people;
+--------------------+----------+----------------------+
| awesomeness_rating | codename | email                |
+--------------------+----------+----------------------+
|                 10 | me       | xxxxxxxxx@gmail.com  |
|                  1 | fifi     | notgonnatellyou@gmai |
+--------------------+----------+----------------------+
2 rows in set (0.00 sec)

mysql>

Bonesnap

james1052;10967707 wrote:

Below is the table. I would like to display the entire contents of the table. Thanks for your help!

mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> select * from awesome_people;
+--------------------+----------+----------------------+
| awesomeness_rating | codename | email                |
+--------------------+----------+----------------------+
|                 10 | me       | xxxxxxxxx@gmail.com  |
|                  1 | fifi     | notgonnatellyou@gmai |
+--------------------+----------+----------------------+
2 rows in set (0.00 sec)

mysql>

Remember, $row is just an array; iterate through it like any other array.

<?php
while($row = mysql_fetch_row($result))
{
    //Code to display the contents goes here
    echo $row[0];
    echo $row[1];
    //And so on
}
?>

You can use any type of loop you want. While, for, foreach, etc. Whatever fits your situation best.