<?php
function GetDbConnection(){
$servername = "localhost";
$username = "user";
$password = "password";
$dbname = "myDB";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
return $conn;
}
function ListAllFromQuery($conn,$sql){
$mArr = array();
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
array_push($mArr, $row);
}
}
return $mArr;
}
$conn = GetDbConnection();
$list =ListAllFromQuery($conn,"SELECT * FROM tblUser ORDER BY id;");
$output="";
for($i = 0; $i < count($list); $i++) {
$currentUser= $list[$i];
foreach($currentUser as $key => $key_value) {
$output.= $key . " = " . $key_value;
$output.= "<br>";
}
$output.= "<hr>";
}
$conn->close();
echo $output;
?>
Tag: Arrays
Swift – Randomly reorder an Array
This code sample demonstrates how you can reorder an array.
A possible scenario is when you have multiple-choise questions that you want to present in a different order every time they are shown.
var arrUniqueNumbers = [1,2,3,4]
print("Array before shuffle: \(arrUniqueNumbers)")
let count = arrUniqueNumbers.count
for i in 0..<count{
let n = Int(arc4random_uniform(UInt32(count-i)))+i
(arrUniqueNumbers[i], arrUniqueNumbers[n]) =
(arrUniqueNumbers[n], arrUniqueNumbers[i])
}
print("Array after shuffle: \(arrUniqueNumbers)")