Array to string conversion with SQL 2008 and PHP

Question

I have searched around here and other sources for a solution to this issue but so far no luck finding the answer that solves the issue.

When trying to query and fetch the result from a MS SQL 2008 database I get an Array to string conversion error in the sqlsrv_query line.

This is the php code for accessing and querying.

 <?php
/* Specify the server and connection string attributes. */
$serverName = "DATABASE";
$connInfo = array( "Database"=>"Suggestion");
$conn = sqlsrv_connect( $serverName, $connInfo);

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}

$query = "SELECT * FROM dbo.Suggestions";

$result = sqlsrv_query($conn, $query) OR die(sqlsrv_errors());

$val=sqlsrv_fetch_array($result,SQLSRV_FETCH_ASSOC);

echo $val;

?>

EDIT: As requested the actual error code below:

Notice: Array to string conversion in C:\wamp\www\DBTest\index.php on line 24

When taken into context of the entire file index.php line 24 is:

$result = sqlsrv_query($conn, $query) OR die(sqlsrv_errors());

Thanks in advance for any help!

Are you sure it's that line? echo $val; will cause a notice as $val is an array. Use print_r($val); — AlexP
– AlexP, Commented Jul 24, 2013 at 12:13
@JasonMcCreary The error is now posted as an edit to the original post. Thank you. — Tom Gorski
– Tom Gorski, Commented Jul 24, 2013 at 12:26
I see too many questions like this. Take the time to learn how to interpret errors and fix your code. — Jason McCreary
– Jason McCreary, Commented Jul 24, 2013 at 12:35

Ideal Bakija · Accepted Answer · 2013-07-24 12:29:03Z

1

You can not print an array with 'echo' you have to use either 'print_r()' or var_dump()

answered Jul 24, 2013 at 12:29

Ideal Bakija

6395 silver badges15 bronze badges

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

1 Comment

Tom Gorski Over a year ago

Thank you, I realized that after posting the code and fixed that however the code wont execute to that point with the standing error. Thank you though.

Collectives™ on Stack Overflow

Array to string conversion with SQL 2008 and PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related