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 http://www.microsoft.com/en-us/download/details.aspx?id=20098 and extract it in the “ext” folder of WAMP PHP. In my PC that is (C:\wamp\bin\php\php5.4.3\ext) 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
to add them. It differs with the PHP version. Then we need to restart all services in WAMP.
Now you can see ‘sqlsrv’ extension and ‘pdo_sqlsrv’ extension in your WAMP homepage. This means, you are ready to use PHP sqlsrv function to connect SQL Server DB in PHP.
Lets move to the coding part. Since SQL Server uses Windows Authentication and SQL Server Authentication to connect, we have two separate syntaxtes for connecting
Connection using Windows Authentication
Connection using SQL Server Authentication
In here, SQL Server authentication way, the user ID and password (UID and PWD connection attributes in the SQLSRV driver) must be set when you try to establish a connection. The user ID and password must map to a valid SQL Server user and password.
Okie, lets see the code to retrieve all Table names in our SQL Server DB. The code goes as
Here I am using
to make query. Please note that there are several possible ways to list the Table names, one good example is like
is the best possible solution to retrieve the table names later through
Thats all folks 🙂 happy coding
This year also my team is going through Microsoft Imagine-cup local finals Sri Lanka. Its all set to do our presentation at Microsoft Sri Lanka office in sha allah on 22nd April and The final function will held in Peradeniya University of Sri Lanka.This year our team has three members, I, Rohana K Amarakoon and Prabath M Peiris. Rohana K Amarakoon took his responsibility as the business analyst of our project and Prabath M Peiris is the main developer of ours, he has developed almost all core features of our project. I was given an excuse from my team, because I had to develop my Mini Project for this semester, I had to write a research paper and I had to consult a Neural Physician for my Momma in Colombo. Finally I took my responsibility as a Front end web site developer for our project.
For my work I had to retrieve a JSON file from a service, obviously its a Windows Server 2012 service, parse it, traverse through it and override some HTML DIV things from the result. I used jQ 1.9 to make my work done.
First my HTML was like this, where I had <li> tag.
Then the JSON was
Now I have added the below JS to my html to append the results
For more clarification, you can see this demo here..
🙂 happy coding folks..
Enterprise resource planning (ERP) is business process management software that allows an organization to use a system of integrated applications to manage the business and automate back office functions. ERP software integrates all facets of an operation, including product planning, development, manufacturing processes, sales and marketing. ERP software typically consists of multiple enterprise software modules that are individually purchased, based on what best meets the specific needs and technical capabilities of the organization.
Most of the ERP systems cost much money but there is a solution from FOSS community for FOSS people, and that is OpenERP
OpenERP is a free business management application, for me has been a pleasant surprise to discover that this application is packaged for Fedora so its installation is very easy and even OpenERP can be managed as a service by systemd (systemctl).
Installing OpenERP Server in Fedora
1) Install OpenERP and Postgres
2) Start Postgres database
3) Start Services
4) Enable service autostart
5) Stop firewall
You really have to add an exception to the firewall but for now it’s easier and faster to temporarily stop the firewall, then it is not necessary.
6) Start with user postgres
7) Create user and database
Installing the OpenERP Client on Fedora
Install OpenERP client by just executing this in terminal
Thats all 🙂
if you are no longer worked OpenERP service and a client to access the system. You just have to start the OpenERP client and connect to localhost.
Ready to update your Windows 8.1 to the latest version? and feeling sick of online update? The direct download links are now live for x86, x64 and ARM based versions of Windows 8.1.
First get known your Windows architecture by
wmic OS get OSArchitecture in cmd.exe
Be sure you grab the versions for your system.
- Download links for Windows 8.1 Update x86:
- Download links for Windows 8.1 Update x64:
- Download links for Windows 8.1 Update ARM:
Also be sure you install these updates in the following order as recommended by Microsoft:
Hi friends, on Build 2014, Microsoft has released Visual Studio 2013 Update 2 Release Candidate and Windows Phone 8.1 emulators, which are available in http://dev.windowsphone.com/en-us/downloadsdk. I tried it in the first day, I tried to download them using my university internet connection but it took biiiiiiiiiiiiiiiiiiiiggggg ammount of time, its about 6 hours. Still my computer left without Windows Phone 8.1 VHDs.
After some big efforts I have found a way, that is downloading VS 2013 Update2 RC & WP 8.1 VHD Offline With IDM. You also can try this, on your machine where, IDM is installed
Just copy past the below code and make a .bat file and run it. The download files should be added to the IDM download queue then you can download them all.
the .bat file code is