Why PHP fetch mysqli_fetch_array function return T_Variable error?

Question

I am trying to retrive information from the database table but it gives the following error:

Parse error: syntax error, unexpected '$Row' (T_VARIABLE) in

The code is:

require_once('../connect.php');
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
$query = "SELECT * FROM students_name";            
$result = mysqli_query($dbc, $query);

print ("Student Information Table");
print("<table");
print("<tr>");
print("<td><b>No</b></td>");
print("<td><b>First Name</b></td>");
print("<td><b>Last Name</b></td>");
print("<td><b>Adreess</b></td>");
print("<td><b>Course</b></td>");
print("<td><b>Age</b></td>");
print("</tr>");

//result form the data base
while ($Row = mysqli_fetch_array ($result)){
    print("<tr>");
    print("<td>"$Row[id]"</td>");
    print("<td>"$Row[first_name]"</td>");
    print("<td>"$Row[last_name]"</td>");
    print("<td>"$Row[address]"</td>");
    print("<td>"$Row[course]"</td>");
    print("<td>"$Row[age]"</td>");
    print ("</tr>");
}

mysqli_close ($dbc);
print("</table>");

The error line:

print("<td>"$Row[id]"</td>");

I don't see any syntax error but still doesn't work.

You're missing the concatenation operator in all of your print statements — John Conde, Feb 28 '16 at 17:27
you missed quotes `around array indexes.` example `$Row[id]` MUST BE `$Row['id']` AND SO ON............. also lot of `print` while only few `echo` will work for you — Alive to die - Anant, Feb 28 '16 at 17:27
Try this:- `echo "Student Information Table"; echo ""; //result form the data base while ($Row = mysqli_fetch_array ($result)){ echo""; } `
No First Name Last Name Adreess Course Age
".$Row['id']." ".$Row['first_name']." ".$Row['last_name']." ".$Row['address']." ".$Row['course']." ".$Row['age']." — Alive to die - Anant, Feb 28 '16 at 17:36

score 2 · Accepted Answer · edited Feb 28 '16 at 18:22

2

You don't see a syntax error, but it's there...

print("<td>".$Row['id']."</td>");
print("<td>".$Row['first_name']."</td>");
print("<td>".$Row['last_name']."</td>");
print("<td>".$Row['address']."</td>");
print("<td>".$Row['course']."</td>");
print("<td>".$Row['age']."</td>");

Thanks to @Fred-ii- for pointing this out. You misspelled the table tag:

print("<table>"); // was just "<table"

Even though it doesn't cause the error, it will mess your table up.

Which in HTML source or HTML debugger would throw the following:

Stray start tag "td"

in regards to the missing > for print("<table");

edited Feb 28 '16 at 18:22

Funk Forty Niner

74,450
15
68
141

answered Feb 28 '16 at 17:27

Kevin Kopf

13,327
14
49
66

[*You missed this...*](http://stackoverflow.com/questions/35685763/why-php-fetch-mysqli-fetch-array-function-return-t-variable-error#comment59048968_35685763) ;-) – Funk Forty Niner Feb 28 '16 at 17:32
Thanks. It worked. I am going to tick it. – Maihan Nijat Feb 28 '16 at 17:33
@Fred-ii- thanx for pointing this out, but technically this doesn't cause the T_VARIABLE error :)) – Kevin Kopf Feb 28 '16 at 17:35
1

@Nordenheim I never said it would cause the error, I said it would break their table and throw an HTML error in source. *2 different animals altogether* ;-) – Funk Forty Niner Feb 28 '16 at 17:37
I want to say @Fred-ii- is always correct. and great thing he caught very small mistakes too – Alive to die - Anant Feb 28 '16 at 17:37
1

@Anant well... when I recognize obvious errors, yes. I do make mistakes occasionally ;-) nobody is perfect. HTML markup I know quite well though. 20+ years. – Funk Forty Niner Feb 28 '16 at 17:38
1

`I do make mistakes occasionally` :) may be, till now i didn't see anyone from you. I really appreciate your help to me too in my posts ,comments and answers. – Alive to die - Anant Feb 28 '16 at 17:39

No	First Name	Last Name	Adreess	Course	Age
".$Row['id']."	".$Row['first_name']."	".$Row['last_name']."	".$Row['address']."	".$Row['course']."	".$Row['age']."

Why PHP fetch mysqli_fetch_array function return T_Variable error?

1 Answers1