Tag Archives: xampp

How to install Composer in Windows

I wanted to install PHP Composer in Windows. And to begin, I already have a copy of XAMPP 1.8.1, I think if you have a different way to get your PHP that should not matter. I tested this to work for Windows 7 but it should work for all versions of Windows.

0. Download and install XAMPP

You can download XAMPP here. I got the 7zip version rather than the installer itself. The ZIP version is similar, just with a larger file size. I extract the xampp folder into my C: drive, i.e. to C:\xampp. Then install it by opening the file C:\xampp\setup_xampp.bat. That will set the paths in XAMPP’s configurations.

1. Setting up environment variables

Continue reading “How to install Composer in Windows” »

How to fix missing MSVCR71.dll problem in Windows

I am using Windows 7, and I’m lacking MSVCR71.dll which is Microsoft Visual C Runtime library when using sendmail, the PostgreSQL PHP connector and curl. The MSVCR71.dll is probably bundled with .NET Framework 1.1 or something, but I couldn’t get those to install successfuly.
The program can't start because MSVCR71.dll is missing from your computer. Try reinstalling the program to fix this program.

The program can’t start because MSVCR71.dll is missing from your computer. Try reinstalling the program to fix this program.

So how do I solve it:

  1. Download MSVCR71.dll from dll-files.com. (It is free.)
  2. Unzip…
  3. Place MSVCR71.dll into C:\Windows\System32 or C:\Windows\SysWOW64 if you using a 64-bit Windows.

And sendmail now works for me already in Windows 7.

By the way, I only tested this in Windows 7 64-bit. I assumed it would work for other versions of Windows. I would appreciate it if you could feedback to me if it works on your version of Windows. :)

Additions

It is reported working for Windows 7 32-bit as well.

How to use sendmail in XAMPP for Windows using AOL Mail

The easiest way to start developing in PHP is to get XAMPP, the whole package can even be placed in a flash drive. Using the free AOL Mail account also allows you to sign in to the SMTP server without TLS which allows XAMPP sendmail to work.

0. Objective

To get your PHP scripts to send an email out. This guide assumes you have XAMPP or XAMPP Lite. My environment is Windows Vista. (I use XAMPP Lite by the way.)

My XAMPP is placed in C:\xampplite\, so your configuration may be a little different. The files to be modified are sendmail.ini and php.ini. Continue reading “How to use sendmail in XAMPP for Windows using AOL Mail” »

How to import and export MySQL database into an SQL file

Or Gzip for the matter. Here’s the command to run in your UNIX-based server to import or export via an SQL file, this is useful for performing backup and restoring of a MySQL database. (I wrote a similar import and export guide for PostgreSQL.) The mysqldump utility performs just that:

Exporting using mysqldump:

mysqldump -u[Username] -p[Password] [Database] > output.sql

For example, my username is ‘kahwee’, my password being ‘secret’ and database being ‘justrealized_db’, I would run the following to export my database to a SQL file:

mysqldump -ukahwee -psecret justrealized_db > output.sql

And to Gzip:

mysqldump -u[Username] -p[Password] [Database] | gzip > output.sql.gz

Importing using mysql:

To import back, we can use the mysql utility in a similar fashion, note that the > (greater than) has change to a < (lesser than).

mysql -u[Username] -p[Password] [Database] < output.sql

For example, my username is 'kahwee', my password being 'secret' and database being 'justrealized_db', I would run the following to import my database:

mysql -ukahwee -psecret justrealized_db < output.sql

And to Ungzip:

gunzip < output.sql.gz | mysql -u[Username] -p[Password] [Database]

Backing up and restoring MySQL databases in Windows

Unfortunately, you can't use gzip here. So all those commands above with gzip can't work. The rest, however, still works. However, mysqldump and mysql may not be set in your system environment variables. These are instructions on how to add them for Windows Vista:

Editing system environment variables in Windows Vista.

Click on 'Edit the system environment variables', a dialog box will pop up. Click on 'Environment Variables...', you should be greeted with the following dialog box:

Editing the path for environment variables

My path looks like this before I add anything:

%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem

Append your MySQL bin directory at the back of what is already there. I use XAMPP (XAMPP lite to be specific) which has its MySQL bin folder located here ';C:\xampplite\mysql\bin\', so I would be appending this:

;C:\xampplite\mysql\bin\

That's all I guess, hope it is helpful for you.

6,081 visits last month, thanks!

Search engines sent 67.95% of the visitors. Asides search engines, most of the visitors come from Twitter, Ping.sg, Facebook and Stackoverflow.

Firefox is a favorite browser with 60%. Chrome visits constitutes 5% which I am responsible for at least half of Chrome visits I presume.

The top searches are XAMPP, jQuery, Django and PostgreSQL related. I code using CakePHP but no one reads my CakePHP stuff. My top tags are NetBeans, XAMPP and Sex, the combination upsets me.

Top countries visiting are US, UK, Singapore, India and Canada. I had a visitor from Zimbabwe, I didn’t know they can afford computers. Zimbabwe, a victim of hyper inflation, announced last February the removal of 12 zeroes from the currency, i.e. 1,000,000,000,000 Zimbabwe dollars being exchanged for 1 new dollar.

Alright, before I go offtrack, kthxbai.

Some problems with XAMPP 1.7.0 and Windows 7

For some reason, I couldn’t get XAMPP 1.7.0 working in Windows 7. There appears to be some sort of issues. I tried the zip package or the 7z package and both have the same result. Instead I found XAMPP 1.6.8 to be working fine for Windows 7 and is using that for web development using PHP and MySQL. I can confirm that cURL and sendmail is working fine in the Windows 7 environment with XAMPP 1.6.8.