Retrieve all table names of SQL Server DB with PHP on WAMP

21/08/2019 by

via Retrieve all table names of SQL Server DB with PHP on WAMP


Retrieve all table names of SQL Server DB with PHP on WAMP

21/08/2019 by


WAMP stands for Windows – Apache – MySQL – PHP but for me, today, I need to say WASP which is Windows – Apache – SQL Server – PHP. Yes its bit painful and for second day, working hard on finishing my part of our project for Microsoft Imagine Cup. Our server guy, Prabath M Peiris have done the backend in MS SQL Server and I needed to connect the DB with PHP as we could not find a free ASP host.


WAMP does not come with SQL Server connectivity drivers so we have to download it from and extract it in the “ext” folder of WAMP PHP. In my PC that is (C:wampbinphpphp5.4.3ext) then we need to add the extensions to PHP.ini file. I advise you to read the readme.html file comes with SQL Server drivers we have downloaded. Since I am using PHP 5.4, I used


View original post 472 more words

Output MySQL in JSON Format

10/08/2019 by

Open Source DBA's Blog

I was recently asked if there is anyway to select non-JSON data from a MySQL database and output that data in JSON format. There are two very easy ways to to this.

JSON Array

If you need a JSON array, it is very easy to use the JSON_ARRAY() function. Simply select the columns you want as the argument to JSON_ARRAY()

SQL> select
json_array(continent,Population, Code)
from country
limit 5;
| json_array(continent,Population, Code) |
| ["North America", 103000, "ABW"] |
| ["Asia", 22720000, "AFG"] |
| ["Africa", 12878000, "AGO"] |
| ["North America", 8000, "AIA"] |
| ["Europe", 3401200, "ALB"] |
5 rows in set (0.0006 sec)


However to get a JSON object you need to do a little more work. JSON objects require pairs – key/value pairs — so you need to pass a key, even a fictitious one for each value you desire. In the example…

View original post 105 more words

TVa 2019 legislative report

05/08/2019 by

via TVa 2019 legislative report

TVa 2019 legislative report

05/08/2019 by

Transparency Virginia

Transparency Virginia’s 2019 annual report on legislative transparency. Click the image or the link below.


Transparency Virginia2019 report

View original post

CHALLENGE: Accessibility know-how needs to go mainstream with developers. NOW.

20/07/2019 by

This is the internationally recognized symbol ...

Relatively, there isn’t a lot of great information about accessibility out there. You really have to seek it out. How many of you know what JAWS is? After popping up IE6/IE7/IE8 et. al. to ensure website compatibility, do you also check your content in a screen reader?

I would argue that it’s more important to make a site accessible than pretty for older browsers. For some people, an accessible Internet literally makes a world of difference. Although I’m a backend programmer, I’m still ashamed at how little I know. How about you?

Much effort is going into the semantics of HTML5 for the purpose of accessibility. I’ve been toying with this idea for a couple years, but now the time has come to ask for your help. Let’s work together and fix this oversight in our knowledge. As a community, we can work together to change the world.


View original post 214 more words

Tour A Secret Island on VA’s Eastern Shore

17/07/2019 by

Visit Virginia's Eastern Shore

About the Guest Blogger

Max Lonzanida, visitor services park ranger, Eastern Shore of Virginia National Wildlife Refuge.

me teaching Credit: U.S. Fish and Wildlife Service

Max manages everything that has to do with wildlife-dependent recreation on the refuge. He commutes to the Shore daily from Norfolk, where he lives with his wife Amy, his two energetic kids Noah and Stella and their two dogs.

The Secret Fisherman’s Island

Get a rare glimpse of Fisherman’s Island, which is typically closed to the public except during winter weekends. It’s part of a 2,000-acre refuge on the very tip of Virginia’s Eastern Shore.

If you’ve traveled over the Chesapeake Bay Bridge-Tunnel to and from Virginia’s Eastern Shore, you’ve visited Fisherman Island. Route 13 takes you across the island in the blink of an eye and you’re either in Northampton County or over open water on the Chesapeake Bay Bridge-Tunnel. What a lot of people don’t…

View original post 750 more words

Tour A Secret Island on VA’s Eastern Shore

17/07/2019 by

via Tour A Secret Island on VA’s Eastern Shore

Glamping on Virginia’s Eastern Shore

17/07/2019 by

via Glamping on Virginia’s Eastern Shore

Glamping on Virginia’s Eastern Shore

17/07/2019 by

Visit Virginia's Eastern Shore

Stay in a yurt on the Chesapeake Bay, a historic watch house at offshore oyster grounds or an off-the-grid guest house on a private Atlantic island. The Virginia Eastern Shore’s nine campgrounds hug the Atlantic Ocean on one coast, and the Chesapeake Bay on the other, and have amenities ranging from free shuttle services to waterside restaurants.


These are not your grandfather’s campgrounds. Resort camping is a different animal, with swimming pools, playgrounds, restaurants, camp stores, coffee shops, organized games, movie nights, rental and tackle shops, places to juice up your devices and concierges to help you find interesting day trips. Most campgrounds have places to park your RV or put up a tent and also rent cabins.
Here’s a complete list of campgrounds on VA’s Eastern Shore

Upper Shore Campgrounds

ChincoteagueIslandKOA2CreditThem KOA Chincoteague Island, Chincoteague

Pine Cove Campground and Waterfowl Park, Chincoteague

Tall Pines Harbor Campground, Temperanceville

Tom’s Cove…

View original post 485 more words