How to install MySQL on Windows

Step by step guide

1)  Download MySQL from http://dev.mysql.com/downloads/mysql/5.1.html and get the Windows Essentials (x86) MSI Installer version.

2) Now run the MSI file and use the following settings

• Typical Setup
• Skip Sign-Up
• make sure “Configure the MySQL Server now” is checked
• “Detailed Configuration”
• “Developer Machine”
• “Multifunctional Database”
• “InnoDB Tablespace Settings” – leave everything default
• “Decision Support (DSS)/OLAP”
• make sure “Enable TCP/IP Networking” is checked and leave the port number at 3306 (at this point, if you have a firewall, it will usually try to access itself on the localhost)
  Leave “Enable Strict Mode” checked
• “Standard Character Set”
• check “Install As Windows Service” and I would recommend leaving “Launch the MySQL Server automatically” checked.
• enter a root password (and remember/write it down) and I would recommend leaving “Enable root access from remote machines” unchecked
• then hit “execute” and it’ll install and set it up.

3) Change the php extension.

open up your php.ini in a text editor and search for ;extension=php_mysql.dll and remove the ; infont of that line.

4) Testing mysql

Please create a php file and copy following codes and save as php file.

<? $host = ‘localhost’; $user = ‘root’; $password = ”; $database = “affiliatemarketers”; // connect to the server $con = mysql_connect(“$host”,”$user”,”$password”); if($con) { $databaseCon = mysql_select_db(“$database”); if(!$databaseCon) { echo “Unable to connect to the database. please try again”; die(); } else { echo “Database cconnected successfully”; } } else { echo “Unable to connect to the host”; die(); } ?>

Thanks

Step by step installation guide of php in window.

1) Download and install PHP from http://windows.php.net/download/

2) Unzip php. In my case, I unzipped to C:\php\

3) Rename C:\php\php.ini-development to php.ini

4) Edit your php.ini

Open php.ini in a text editor.

find doc_rootthen change it to point to whatever your Apache DocumentRoot is set to.

like: doc_root = “C:\public_html”

Find  extension_dir

and change like  extension_dir = “C:\php\ext”(remove the ; from in front of it also)

5) Editing Apache Conf File

Open httpd.conf in text editor

Location: should be start-menu shortcut “Apache HTTP Server 2.2 > Configure Apache Server > Edit the Apache httpd.conf Configuration File”.

Either at the very beginning or end of the file add the following lines:

         LoadModule php5_module "C:/php/php5apache2_2.dll"
	AddType application/x-httpd-php .php
	PHPIniDir "C:/php"

6) That's it now Testing

To test u jsut create a php file like phpinfo.php with the following codes

<?

phpinfo();

?>

Save it and put http://localhost/test.php in url...chk the output.

Thanks

Please follow following points:

Download & Unpack
Go to http://www.apache.org/dist/httpd/binaries/win32/ and choose a mirror. You want the latest win32-x86-no_ssl.msi “MSI Installer Package” release.

Install

When you install Apache, you’ll get a prompt for “Server Information.” Here is the settings I used:
Network Domain: localhost
Server Name: localhost
Admin Email: (any email. real or fake)

You can easily start/stop/restart Apache and Apache2 via that icon in your System Tray. If you get “The requested operation has failed!” error while starting apache use the “Test Configuration” shortcut in the Start Menu to find the error (if the text window pops up then closes before you can read it, your config file is fine).

Testing

Now the ultimate test. To see if it’s serving. Open your browser and head to: http://127.0.0.1/ or http://localhost/

see the video……..

wordrap php

Today we will see how to break a sentance after some characters using php.

Sometime we need to break a long line into small peaces of sentence to meet the designing   requirement. PHP has very good function wordwrap() to meet the req.

Basic sentance of the wordwrap() php function

string wordwrap ( string $str [, int $width = 75 [, string $break = "\n" [, bool $cut = false ]]] )

So u can see by default, wordwrap() uses a column width of 75 characters. This means that no line will be more than 75 characters long.

Wrapping very long words

For example suppose we have a sentance:

$sentance = ‘JohnCleese: Have you signed up to my monthly email yet? Youre missing outif you havent http://aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa.co.uk/‘;

echo "<pre>" . wordwrap( $sentance, 10 ) . "</pre>";

output will be: 

JohnCleese:
Have you
signed up
to my
monthly
email yet?
Youre
missing
outif you
havent!

http://aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa.co.uk/

So you can see the problem at last sentence.

To make this work perfectly use the sentence like this

<?
$sentance = 'JohnCleese: Have you signed up to my monthly email yet? Youre missing outif you havent! http://aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa.co.uk/';
echo "<pre>" . wordwrap( $sentance, 10, "\n", true ) . "</pre>";
?>

Output will be like:

JohnCleese
: Have you
signed up
to my
monthly
email yet?
Youre
missing
outif you
havent!

http://aaa

aaaaaaaaaa
aaaaaaaaaa
aaaaaaaa.c
o.uk/


So clear now.
Thanks
mrphpguru
http://www.mrphpguru.com

How to install php

What i prefer.

Please download wamp or zamp….

and click on the exe file and follow the instruction and ready to use php

after installation of wamp just click on the wamp and  you will see the icon on start menu..left click on the icon >> click on the localhost..it will open the localhost…the first page of the php

for any further project create folder under www which is situated in

installed folder of wamp>>www..

For those who are experienced enough to do this yourself, simply head over to PHP.net – Downloads and download the most recent version of PHP.

However, if you are like most of us, you will most likely want to follow a guide to installing PHP onto your computer. These guides are kindly provided by PHP.net based on the operating system that you are using.

• PHP – Windows – Windows Installation Guide
• PHP – Mac – Mac Installation Guide
• PHP – Linux – Linux Installation Guide

Thanks

mrphpguru  a freelance programmer

PHP Tutorial – Learn PHP and discuss php function,php classes.

If you want to know php and learn php than OneAnAll.com php is the right place.Here we will discuss all the php basics and php advance.Here we will also discuss Php function and php classes.

We will also share our expertise and code to all the php programmer if you want to summit any code u can mail me.

PHP stands for PHP Hypertext Preprocessor.

PHP – What is it ?

From PHP’s home, PHP.net, “PHP is an HTML-embedded scripting language.
The goal of php language is to allow web developers to write dynamically generated pages quickly.”

Another way to think of PHP is a powerful, behind the scenes scripting language that your visitors won’t see!

PHP – What’s it do?

PHP will allow you to:

• Reduce the time .
• Allow to create dynamic web pages.
• Reusability of functions.
• Create a customized user experience for visitors based on information that you have gathered from them.
• Check out PHP -Scripts for examples of the great things that are possible with PHP.
• You Can download a lot of free php script from onenall.com
• You can also upload the php free script on onenall.com
• Allow creation of shopping carts for e-commerce websites.

What You Should Know before start php

Before starting this tutorial it is important that you have a basic understanding and experience
in the following:

• HTML – Know the syntax and especially
• CSS
• Basic programming knowledge

Start php learning .. how to install php

Thanks

mrphpguru