mysql fetch all data
//Database Connection $sqlConn = new mysqli($hostname, $username, $password, $database); //Build SQL String $sqlString = "SELECT * FROM my_table"; //Execute the query and put data into a result $result = $sqlConn->query($sqlString); //Copy result into a associative array $resultArray = $result->fetch_all(MYSQLI_ASSOC); //Copy result into a numeric array $resultArray = $result->fetch_all(MYSQLI_NUM); //Copy result into both a associative and numeric array $resultArray = $result->fetch_all(MYSQLI_BOTH);