Skip to content
Advertisement

SQL Server fetch data php

I want to pull the data in the database by connecting to SQL Server. I can connect to SQL Server but I can’t print the data. I get blank screen output. What is the problem?

<?php
$myServer = "...";
$myUser = "...";
$myPass = "....";
$myDB = "...";

//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer");

//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB");

//declare the SQL statement that will query the database
$query = "SELECT form_adres, form_sehir, form_adsoyad";
$query .= "FROM databasename.omg_user.ie_form";
$query .= "WHERE form_no='15275'";

//execute the SQL query and return records
$result = mssql_query($query);

$numRows = mssql_num_rows($result);
echo "<h1>" . $numRows . " Row" . ($numRows == 1 ? "" : "s") . " Returned </h1>";

while($row = mssql_fetch_array($result))
{
  echo "<li>" . $row["form_adres"] . $row["form_sehir"] . $row["form_adsoyad"] . "</li>";
}
//close the connection
mssql_close($dbhandle);
?>

Advertisement

Answer

You have a syntax error in the generated T-SQL Statment – missing spaces before FROM and WHERE. The generated statement is SELECT form_adres, form_sehir, form_adsoyadFROM databasename.omg_user.ie_formWHERE form_no='15275'. Fix the statement and always check the result from mssql_query() execution:

<?php
...

// declare the SQL statement that will query the database
$query = " SELECT form_adres, form_sehir, form_adsoyad";
$query .= " FROM databasename.omg_user.ie_form";
$query .= " WHERE form_no='15275'";

// execute the SQL query and return records
$result = mssql_query($query, $dbhandle);
if ($result === false) {
    echo "Error (mssql_query): ".mssql_get_last_message();
    exit;
}   

...
?>
User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement