There are 3 main ways to fetch results from a query:
sqlsrv_fetch_array()
sqlsrv_fetch_array() retrieves the next row as an array.
$stmt = sqlsrv_query($conn, $query);
while($row = sqlsrv_fetch_array($stmt)) {
echo $row[0];
$var = $row["name"];
//...
}
sqlsrv_fetch...
When a query goes wrong, it is important to fetch the error message(s) returned by the driver to identify the cause of the problem. The syntax is:
sqlsrv_errors([int $errorsOrWarnings]);
This returns an array with:
KeyDescriptionSQLSTATEThe state that the SQL Server / OBDC Driver is incodeThe S...
You have to create a different strings.xml file for every new language.
Right-click on the res folder
Choose New → Values resource file
Select a locale from the available qualifiers
Click on the Next button (>>)
Select a language
Name the file strings.xml
strings.xml
<resources&...
Intro
An array is a container object that holds a number of values. In the following image you can see an array with size 10, the first element indexed 1 and the last element 10.
Autohotkey offers a few ways of defining and creating arrays.
Array := []
Array := Array()
Creating and initia...
if(A_TimeIdlePhysical > 60000) { ; 60,000 milliseconds
WinClose, ahk_class Chrome_WidgetWin_1
MsgBox, Google Chrome was closed due to user inactivity.
}
This check could be done periodically, e.g. using SetTimer.
myDebt := 9000
index := RegExMatch("You owe me $42", "\$(\d+)", dollars)
if(index > 0) { ; indices are usually 1-based in AHK
myDebt += dollars1
MsgBox, Current debt: %myDebt%
}
Result:
Current debt: 9042
myString := " hello, Trim()! "
trimmed := Trim(myString)
FileAppend, % trimmed "`n", TrimmedStrings.txt
Note that Trim() will not manipulate the original string, but return a new one which should be stored or output somewhere.
Comments in Tcl are best thought of as another command.
A comment consists of a # followed by any number of characters up to the next newline. A comment can appear wherever a command can be placed.
# this is a valid comment
proc hello { } {
# the next comment needs the ; before it to indicat...
Due to the way the Tcl language parser works, braces in the code must be properly matched. This includes the braces in comments.
proc hw {} {
# this { code will fail
puts {hello world}
}
A missing close-brace: possible unbalanced brace in comment error will be thrown.
proc hw {} {
...
Introduction
Binary Search is a Divide and Conquer search algorithm. It uses O(log n) time to find the location of an element in a search space where n is the size of the search space.
Binary Search works by halving the search space at each iteration after comparing the target value to the middle ...
You can use the following code for going back and forward.
if (!function_exists('codepoint_encode')) {
function codepoint_encode($str) {
return substr(json_encode($str), 1, -1);
}
}
if (!function_exists('codepoint_decode')) {
function codepoint_decode($str) {
re...
You can use the following code for going back and forward.
if (!function_exists('mb_internal_encoding')) {
function mb_internal_encoding($encoding = NULL) {
return ($from_encoding === NULL) ? iconv_get_encoding() : iconv_set_encoding($encoding);
}
}
if (!function_exists('mb_c...
C and C++ are well known as high-performance languages - largely due to the heavy amount of code customization, allowing a user to specify performance by choice of structure.
When optimizing it is important to benchmark relevant code and completely understand how the code will be used.
Common opti...
The most straightforward approach to optimizing is by executing less code. This approach usually gives a fixed speed-up without changing the time complexity of the code.
Even though this approach gives you a clear speedup, this will only give noticable improvements when the code is called a lot.
R...
Optimizing by using the right data structures at the right time can change the time-complexity of the code.
// This variant of stableUnique contains a complexity of N log(N)
// N > number of elements in v
// log(N) > insert complexity of std::set
std::vector<std::string> stableUnique...
Save the session variable as a variable.
$session = Yii::$app->session;
$sess = $session['keys'];
Then create or update the array value you want
$sess['first'] = 'abc';
And finally save to the session variable
$session['keys'] = $sess
When storing JSON documents in SQL Server, We need to be able to efficiently filter and sort query results on properties of the JSON documents.
CREATE TABLE JsonTable
(
id int identity primary key,
jsonInfo nvarchar(max),
CONSTRAINT [Content should be formatted as JSON]
CHECK...
Use a mutex to synchronise access to a variable which is accessed from multiple threads:
counter = 0
counter_mutex = Mutex.new
# Start three parallel threads and increment counter
3.times.map do |index|
Thread.new do
counter_mutex.synchronize { counter += 1 }
end
end.each(&:joi...
This worked for me to move from Ubuntu 12.04 (Jenkins ver. 1.628) to Ubuntu 16.04 (Jenkins ver. 1.651.2). I first installed Jenkins from the repositories.
Stop both Jenkins servers
Copy JENKINS_HOME (e.g. /var/lib/jenkins) from the old server to the new one. From a console in the new serve...
