mssql_fetch_object

Fetch row as object (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
object mssql_fetch_object ( resource result )

Examples ( Source code ) » mssql_fetch_object


<?php


$conn = mssql_connect("myServer","myUser","myPass");

mssql_select_db("myDB",$conn);

$query = mssql_query("SELECT Name FROM employe ORDER BY Name ");

while ($retorno = mssql_fetch_object($query))

  echo "Empresa:" . $retorno->Name ;

?>

Code Examples / Notes » mssql_fetch_object

rubin

It is important to point out that the result of both SELECT ' ' and SELECT '' is the string ' '. That is, the php mssql functions will return a phantom space for any empty strings. See http://bugs.php.net/bug.php?id=26996 and http://bugs.php.net/bug.php?id=25777 PHP does not classify this as a "bug" because the MS DBLib cannot tell the difference betwene the two cases. Earlier versions of php trim'd strings automatically. It may be a good idea to ltrim and rtrim your results in some cases.

klystofer

<?php /* A simple example using mssql_fetch_object */ $conexao = mssql_connect("myServer","myUser","myPass"); mssql_select_db("myDB",$conexao); $query = mssql_query("SELECT EMPRESA FROM IDENTIFICACAO ORDER BY EMPRESA;"); while ($retorno = mssql_fetch_object($query)) echo "Empresa:" . $retorno->EMPRESA; ?>

Change Language

mssql_bind
mssql_close
mssql_connect
mssql_data_seek
mssql_execute
mssql_fetch_array
mssql_fetch_assoc
mssql_fetch_batch
mssql_fetch_field
mssql_fetch_object
mssql_fetch_row
mssql_field_length
mssql_field_name
mssql_field_seek
mssql_field_type
mssql_free_result
mssql_free_statement
mssql_get_last_message
mssql_guid_string
mssql_init
mssql_min_error_severity
mssql_min_message_severity
mssql_next_result
mssql_num_fields
mssql_num_rows
mssql_pconnect
mssql_query
mssql_result
mssql_rows_affected
mssql_select_db

mssql_fetch_object

Fetch row as object (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4) object mssql_fetch_object ( resource result )

Code Examples / Notes » mssql_fetch_object

Change Language

Fetch row as object (PHP 4, PHP 5, PECL odbtp:1.1.1-1.1.4)
object mssql_fetch_object ( resource result )