Code: Select all
<?php
$GLOBALS['text']=array (
'foo1' => 'ValueOne',
'foo2' => 'ValueTwo',
'foo3' => 'ValueThree'
);
?>Code: Select all
$serverName = "MYSERVER";
$connectionInfo = array( "Database"=>"MYDB", "CharacterSet" => "UTF-8","UID" => "MYUID", "PWD" =>"MYPWD");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if ( $conn === false ) {
echo "Could not connect.<br>";
die( print_r( sqlsrv_errors(), true));
}
$tsql1 = "SELECT term, native_term FROM [pwf].[dbo].[terms_data]
WHERE
(id_language='$id_language');";
$params1 = array();
$options1 = array( "Scrollable" => SQLSRV_CURSOR_KEYSET );
/* Execute the query. */
$stmt1 = sqlsrv_query($conn, $tsql1, $params1, $options1);
if( $stmt1 === false ) { die( print_r( sqlsrv_errors(), true )); }
$row_count = sqlsrv_num_rows( $stmt1 );
if ($row_count === false) {
echo "Error in retrieveing row count."; }
elseif ($row_count > 0) {
$GLOBALS['text']=array (
while( $row = sqlsrv_fetch_array( $stmt1, SQLSRV_FETCH_ASSOC) ) {
$term=$row["term"];
$native_term=$row["native_term"];
$term => $native_term,
}
);
}