32 lines
924 B
PHP
32 lines
924 B
PHP
<?php
|
|
|
|
$serverName = "CBM2K12\SQLEXPRESS";
|
|
$uid = "cbmclient";
|
|
$pwd = "ascbm2k";
|
|
$connectionInfo = array( "UID"=>$uid, "PWD"=>$pwd,'ReturnDatesAsStrings'=> true, "CharacterSet" => 'utf-8', "Database"=>"SugarCaneScale" );
|
|
|
|
/* Connect using SQL Server Authentication. */
|
|
$conn = sqlsrv_connect( $serverName, $connectionInfo);
|
|
if( $conn === false )
|
|
{
|
|
echo "Unable to connect.</br>";
|
|
die( print_r( sqlsrv_errors(), true));
|
|
}
|
|
|
|
$sql = "SELECT * FROM LoadData WHERE CropDay = ( SELECT Max(CropDay) FROM LoadData) AND LoadId_Pk NOT LIKE '%[SS]%' AND FarmerId_Fk LIKE 40002";
|
|
|
|
$params = array();
|
|
$options = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
|
|
$stmt = sqlsrv_query( $conn, $sql , $params, $options );
|
|
|
|
$row_count = sqlsrv_num_rows( $stmt );
|
|
|
|
if ($row_count === false)
|
|
echo "Error in retrieveing row count.";
|
|
else
|
|
echo $row_count;
|
|
|
|
sqlsrv_free_stmt( $stmt);
|
|
sqlsrv_close( $conn);
|
|
?>
|