Parse error: syntax error, unexpected ')', expecting '(' in C:\xampp\htdocs\res\connection.php on line 12

Question

I need some help here. I have some code below, and my question is, I'm not getting where the error is, which is showing by the error message.

try
{
    $db = new PDO('mysql:host=localhost; db_name=softdemo','root', '');
}   
catch(PDOException $e)
{
    echo $e->getMessage();
}

try{
    foreach ( $db->query("SELECT * FROM users") as row )
    {
        echo $row['username'].$row['password']."<br/>";
    }
    $db = null;
}
catch(Exception $e)
{
    echo $e->getMessage();      
}

These kinds of errors should be solved with speicalized IDEs like PHPStorm, Eclipse or NetBeans. These are very common and should not be asked here. Solving these errors on the own improves debugging capability. — Pupil, Apr 07 '16 at 06:35

score 1 · Answer 1 · edited Apr 07 '16 at 07:04

1

Error comes from this line you missed $ before $row variable

  foreach ( $db->query("SELECT * FROM users") as row )

Change this to

$res = $db->query("SELECT * FROM users");
if(!empty($res))
{
  foreach( $res as $row )
  { //code here..
  }
}

edited Apr 07 '16 at 07:04

Vishnu Sharma

612
4
17

answered Apr 07 '16 at 06:31

Maninderpreet Singh

2,450
2
15
29

Fixed it. but now its showing this warning message Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\res\connection.php on line 12 – sharif Apr 07 '16 at 06:58
may be your query not giving any result. – Vishnu Sharma Apr 07 '16 at 07:00
store in variable then $var = $db->query("SELECT * FROM users");pass in foreach – Maninderpreet Singh Apr 07 '16 at 07:00
i have updated the answer please check. – Vishnu Sharma Apr 07 '16 at 07:03
thnx @VishnuSharma :) – Maninderpreet Singh Apr 07 '16 at 07:04

Vishnu Sharma · Answer 2 · 2016-04-07T07:04:41.403

1

You've missed $ sign, this is required as $row is a variable.

So, Change

foreach ( $db->query("SELECT * FROM users") as row )

To

$res = $db->query("SELECT * FROM users");
if(!empty($res))
{
  foreach( $res as $row )
  { //code here..
  }
}

edited Apr 07 '16 at 07:04

answered Apr 07 '16 at 06:32

Vishnu Sharma

612
4
17

Fixed it. but now its showing this warning message Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\res\connection.php on line 12 – sharif Apr 07 '16 at 06:58
i have updated the code please check. – Vishnu Sharma Apr 07 '16 at 07:05
If this answer works for you, mark this as answer. It might help other users in future. – Vishnu Sharma Apr 07 '16 at 07:14

score 1 · Answer 3 · answered Apr 07 '16 at 06:32

1

You've missed out a $, this is required as $row is a variable.

foreach ( $db->query("SELECT * FROM users") as $row )

answered Apr 07 '16 at 06:32

Panda

6,824
6
34
49

Parse error: syntax error, unexpected ')', expecting '(' in C:\xampp\htdocs\res\connection.php on line 12

3 Answers3