PHP- Parse error: syntax error, unexpected 'readphp' (T_STRING), expecting ',' or ';'

Question

I am trying to get data from mysql using this template but it is not working and I am unable find errors in below code:

<?php
$connection = mysql_connect("localhost", "root", ""); // Establishing Connection with Server
$db = mysql_select_db("company", $connection); // Selecting Database
//MySQL Query to read data
$query = mysql_query("select * from employee", $connection);
while ($row = mysql_fetch_array($query)) {
echo "<b><a href="readphp.php?id={$row['employee_id']}">{$row['employee_name']}</a></b>";
echo "<br />";
}
?>

I am getting below Error:

Parse error: syntax error, unexpected 'readphp' (T_STRING), expecting ',' or ';'

Sorry Errors Indicating on this line echo "<a href="readphp.php?id={$row['employee_id']}">{$row['employee_name']}</a>"; — user9740150
– user9740150, Commented May 4, 2018 at 9:13
Further suggestion: Use mysqli_-functions. mysql_-functions are deprecated. — Bernhard
– Bernhard, Commented May 4, 2018 at 9:14
You are mixing PHP and HTML-Limiters ("). That's why it does not work. You Need to write the Syntax like echo '<a href="#">'; or echo "<a href='#'>"; — Bernhard
– Bernhard, Commented May 4, 2018 at 9:15
Well you see php is giving you error on parts it should not interpret at all. You should find why is so. — Siavoshkc
– Siavoshkc, Commented May 4, 2018 at 9:17

Sébastien S. · Accepted Answer · 2018-05-04 09:17:18Z

1

You have to escape " when inside other quotes ". Change :

echo "<a href="readphp.php?id={$row['employee_id']}">{$row['employee_name']}</a>";

To :

echo "<a href=\"readphp.php?id={$row['employee_id']}\">{$row['employee_name']}</a>";

answered May 4, 2018 at 9:17

Sébastien S.

1,54412 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nirali · Accepted Answer · 2018-05-04 09:17:00Z

0

Change " to ' of href url. it conflicts with open comma.

echo "<b><a href='readphp.php?id={$row['employee_id']}'>{$row['employee_name']}</a></b>";


<?php
$connection = mysql_connect("localhost", "root", ""); // Establishing Connection with Server
$db = mysql_select_db("company", $connection); // Selecting Database
//MySQL Query to read data
$query = mysql_query("select * from employee", $connection);
while ($row = mysql_fetch_array($query)) {
echo "<b><a href='readphp.php?id={$row['employee_id']}'>{$row['employee_name']}</a></b>";
        echo "<br />";
}
?>

answered May 4, 2018 at 9:17

Nirali

1,7863 gold badges14 silver badges23 bronze badges

Collectives™ on Stack Overflow

PHP- Parse error: syntax error, unexpected 'readphp' (T_STRING), expecting ',' or ';'

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related