WDH

Type of the PHP Variable

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
Here we will understand, How we can know the type of the variable.</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
As PHP automatic set the type to the variable as we defined it, But sometime it is neccessary to check the type of the variable.</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
 </div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
Suppose you have a condition, that it there is more then 10 Items in store,  you will add them all for calculation of the total payment, but when  the item is only one, there is no need to adding them, as the total cost will be cost of the item.</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
 </div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
So you can do by checking the variable type of the variable m If it is array then we will add them all, if this is only a string or Integer, and it is the final cost.</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
 </div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
Example you have an Variable $value.</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
 </div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
if it is array, we will use array function to check as follow: </div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
<?php                                $totalcost = 0;</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
   if( is_array ($value) )</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
              {</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
                   foreach ( $value as $single )</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
                      {</div>
                             $totalcost = $totalcost + $value; 
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
                      }</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
              } else {</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
                           $totalcost  =  $value;</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
              }</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
?></div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
 </div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
Let find out some more in below Program.</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
 </div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
 </div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; text-align: center;">
##################################</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; text-align: center;">
PHP CODE</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; text-align: center;">
##################################</div>
<?php $var1 = "The 2 Sentances 4"; $var2 = 5; // type will be string $var2 = "5"; // type will be integer echo $var1; echo " "; echo $var2; echo " "; settype($var2,'integer'); echo $total = $var1 + $var2; echo " "; echo gettype($var1); echo " "; echo gettype($var2); echo " "; settype($var2,'integer'); echo gettype($var2); echo " "; $var1 = "The first Sentances"; $var2 = "The second Sentances"; echo $var1; echo " "; echo $var2; echo " "; echo $total = $var1 + $var2; echo " "; echo gettype($var1); echo " "; echo gettype($var2); echo " "; // Check the variable type // check the variable is array or not if(is_array($var1)) { echo "Its an Array."; } else { echo "Its not an Array."; } // check the variable is array or not echo " "; // check the variable is float or not if(is_float($var1)) { echo "Its an Float."; } else { echo "Its not an Float."; } // check the variable is float or not echo " "; // check the variable is bool or not if(is_bool($var1)) { echo "Its an bool."; } else { echo "Its not an bool."; } // check the variable is bool or not echo " "; // check the variable is integer or not if(is_int($var1)) { echo "Its an integer."; } else { echo "Its not an integer."; } // check the variable is integer or not echo " "; // check the variable is NULL or not if(is_null($var1)) { echo "Its an NULL."; } else { echo "Its not an NULL."; } // check the variable is NULL or not echo " "; // check the variable is numeric or not if(is_numeric($var1)) { echo "Its an numeric."; } else { echo "Its not an numeric."; } // check the variable is numeric or not echo " "; // check the variable is string or not if(is_string($var1)) { echo "Its an string."; } else { echo "Its not an string."; } // check the variable is string or not echo " "; ?> 
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; text-align: center;">
##################################</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; text-align: center;">
OUTPUT OF CODE</div>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; text-align: center;">
################################## <div style="text-align: left;">
The 2 Sentances 4 5 5 string integer integer The first Sentances The second Sentances 0 string string Its not an Array. Its not an Float. Its not an bool. Its not an integer. Its not an NULL. Its not an numeric. Its an string.</div>
</div>
</div>

Type of the PHP Variable

Here we will understand, How we can know the type of the variable. As PHP automatic set the type to the variable as we defined it, But s...

Basic for Function on PHP

<div dir="ltr" style="text-align: left;" trbidi="on">
 
<div class="post-footer" style="-webkit-text-stroke-width: 0px; background-color: white; color: #999999; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.6; margin: 0.5em 0px 0px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<div class="post-footer-line post-footer-line-1">
</div>
</div>
 
<div class="post-body entry-content" id="post-body-7495224839725897554" itemprop="description articleBody" style="-webkit-text-stroke-width: 0px; background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.4; orphans: auto; position: relative; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; width: 528px; word-spacing: 0px;">
<div dir="ltr" style="text-align: left;" trbidi="on">
Function:        Function are a set of bloch, which are defined for calling a set of code again and again. There are two way to calling a function in PHP: <ul style="line-height: 1.4; list-style: disc; margin: 0.5em 0px; padding: 0px 2.5em; text-align: left;">
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px; text-indent: 0px;">Directly calling a Function.</li>
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px; text-indent: 0px;">Function called by a object of a class and defined within a class. </li>
</ul>
They are Important as some of the code, we have to use different location on a site. So a good way is to define in a File i.e. "functions.php" and include it to top of the position. <div style="text-align: center;">
############################</div>
<div style="text-align: center;">
PHP Code</div>
<div style="text-align: center;">
############################</div>
<div style="text-align: left;">
Program 01:      Normal Function just running the code within it</div>
<?php //  Normal Function just running the code within it //  function definition function callme($a,$b) { // echo " Sum of the ".$a." and ".$b. "is = ".$a+$b; echo " Sum of the ".$a." and ".$b. "is = ".($a+$b); echo " Multi of the ".$a." and ".$b. "is = ".$a*$b; echo " Min of the ".$a." and ".$b. "is = ".$a-$b; echo " Divide of the ".$a." and ".$b. "is = ".$a/$b; echo " Modulus of the ".$a." and ".$b. "is = ".$a%$b; } // function defination // function call callme(2,5); // function call ?> Program 02:  Function definition with returning some value <?php // function definition with returning some value function sum($a,$b) {     $sum = $a + $b; return $sum; } function minus($a,$b) {     $minus = $a - $b; return $minus; } // function defination with returning some value // use of return function as a variable echo "Sum of 2 and 3 is : ".sum(2,3); // use of return function as a variable // function definition with returning some value ?> Program 03: Function definition with returning array value <?php function callmeforarray($a,$b) { $addition  = $a + $b; $minus  = $a - $b; $multiplication = $a * $b; $division  = $a / $b; $modulus  = $a % $b; $returnvalue['sum'] = $addition." "; $returnvalue['min'] = $minus." "; $returnvalue['mul'] = $multiplication." "; $returnvalue['div'] = $division." "; $returnvalue['mod'] = $modulus." "; return $returnvalue; } echo "<hr/>"; $result = callmeforarray(30,5);  echo "Sum is : ". $result['sum'];  echo "Min is : ". $result['min'];  echo "mul is : ". $result['mul'];  echo "div is : ". $result['div'];  echo "mod is : ". $result['mod'];  $result = callmeforarray(34,2);  echo "Sum is : ". $result['sum'];  echo "Min is : ". $result['min'];  echo "mul is : ". $result['mul'];  echo "div is : ". $result['div'];  echo "mod is : ". $result['mod'];  echo "<hr/>"; ?> Program 04: Function definition within in a class <?php // function definition within in a class class common { function addition($a,$b) { echo " Sum of the " . $a . " and  " . $b . " is : " . ( $a + $b ) ; } function multiplication($a,$b) { echo " Multiplication of the " . $a . " and  " . $b . " is : " . ( $a * $b ) ; } } // function defination within in a class // object creation for class $com1 = new common(); // object creation for class // function call via class's object $com1->addition(2,3); $com1->multiplication(2,3); // function call via class's object ?> Program 05:  Function call of a another class <?php // function call of a another class class class1 { function function1() { return 123; } function function2() { return 259; } } class class2 { function function1() { $object = new class1();  echo $object->function1()+$object->function2(); } } $obj = new class2(); $obj->function1(); // function call of a another class echo "<hr/>"; echo "Above Exapmle Basic : " . (123+259); echo "<hr/>"; ?> <div>
<div style="text-align: center;">
############################</div>
<div style="text-align: center;">
Output of the Code</div>
<div style="text-align: center;">
############################</div>
</div>
<div>
Program 01:</div>
<div>
Sum of the 2 and 5is = 7 Multi of the 2 and 5is = 10-5 Divide of the 2 and 5is = 0.4 Modulus of the 2 and 5is = 2</div>
<div>
 </div>
<div>
Program 02:</div>
<div>
Sum of 2 and 3 is : 5</div>
<div>
 </div>
<div>
Program 03:</div>
<div>
Sum is : 35 Min is : 25 mul is : 150 div is : 6 mod is : 0 Sum is : 36 Min is : 32 mul is : 68 div is : 17 mod is : 0</div>
<div>
 </div>
<div>
Program 04: </div>
<div>
Sum of the 2 and 3 is : 5 Multiplication of the 2 and 3 is : 6</div>
<div>
 </div>
<div>
Program 05:  </div>
<div>
382<hr />
Above Example Basic : 382</div>
</div>
<div style="clear: both;">
</div>
</div>
</div>

Basic for Function on PHP

Function: Function are a set of bloch, which are defined for calling a set of code again and again. There are two way to cal...

How to Connect Facebook to Twitter

How to Connect Facebook to Twitter

To Connect to Facebook to Twitter, Just open the Following Facebook link: https://www.facebook.com/twitter/ Follow the step...

How to Connect Twitter to Facebook

<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEheI8X6EAocWcwCCOL63xLX4dhvS82ujc4P73Xos7pDi1gLcrVZSkkqqeKYuXPXL7S9RcbyhCDN9HNe_w98o9CpK6jcqMBUN6fnXnRVpqJWw2g6ApEy5_PFvOBfRtjqNK1ZD9oMREIKkJyK/s1600/ttof.jpg" imageanchor="1" style="clear: right; color: #cc4411; float: right; margin-bottom: 1em; margin-left: 1em;"><img border="0" height="124" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEheI8X6EAocWcwCCOL63xLX4dhvS82ujc4P73Xos7pDi1gLcrVZSkkqqeKYuXPXL7S9RcbyhCDN9HNe_w98o9CpK6jcqMBUN6fnXnRVpqJWw2g6ApEy5_PFvOBfRtjqNK1ZD9oMREIKkJyK/s1600/ttof.jpg" style="border: none; position: relative;" width="320" /></a></div>
 To Connect to Twitter to Facebook. Just open the Following Twitter link: 
<ul style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; list-style-image: initial; list-style-position: initial; margin: 0.5em 0px; padding: 0px 2.5em;">
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">https://twitter.com/settings/profile/</li>
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">https://facebook.twitter.com/ </li>
</ul>
 Follow the step given there, Just a Easy step, you have to just Click Connect to Facebook. 
 
<div class="post-footer" style="-webkit-text-stroke-width: 0px; background-color: white; color: #999999; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.6; margin: 0.5em 0px 0px; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px;">
<div class="post-footer-line post-footer-line-1">
</div>
</div>
 
<div class="post-body entry-content" id="post-body-1777898427562538240" itemprop="description articleBody" style="-webkit-text-stroke-width: 0px; background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.4; orphans: auto; position: relative; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; width: 528px; word-spacing: 0px;">
<div dir="ltr" style="text-align: left;" trbidi="on">
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGogqWLP7EqGZslq9alYKK_7Z1r49QrRsHezaS9TVtUQ-uHY45Yu3um7YEuDopbW6VAWAXfq4q1BJ85YnuCRYWH06Xy_XhcEH2FcBwaQcAwFKZyIdiacF4Wc_Z4cdK8ftnoJPEBDoXkGW9/s1600/connector.jpg" imageanchor="1" style="clear: right; color: #771100; float: right; margin-bottom: 1em; margin-left: 1em; text-decoration: none;"><img border="0" height="138" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGogqWLP7EqGZslq9alYKK_7Z1r49QrRsHezaS9TVtUQ-uHY45Yu3um7YEuDopbW6VAWAXfq4q1BJ85YnuCRYWH06Xy_XhcEH2FcBwaQcAwFKZyIdiacF4Wc_Z4cdK8ftnoJPEBDoXkGW9/s1600/connector.jpg" style="border: none; position: relative;" width="320" /></a></div>
</div>
<div style="clear: both;">
</div>
</div>
</div>

How to Connect Twitter to Facebook

To Connect to Twitter to Facebook. Just open the Following Twitter link: https://twitter.com/settings/profile/ https://facebook.twitte...

Sending HTML mail using PHP

<div dir="ltr" style="text-align: left;" trbidi="on">
<?php // multiple recipients $emailto  = 'emailto@example.com'; // note: For Multi emailto user comm // subject $subject = 'Email Subject For the mail'; <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJWlTZJDe02hEg5PeelVKzcZuhi9saB-3irHIYdxG40FmusU6w1yQz5HzixoJwQXIzEpoKx_kun7RUFdCYH0IAV3flL8YTHnAqHAcOrSOAU4UxUYKOIjJa2N0XuEX3rj7CHlXu4YfYGcs-/s1600/images.jpg" imageanchor="1" style="background-color: white; clear: right; color: #771100; float: right; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; margin-bottom: 1em; margin-left: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJWlTZJDe02hEg5PeelVKzcZuhi9saB-3irHIYdxG40FmusU6w1yQz5HzixoJwQXIzEpoKx_kun7RUFdCYH0IAV3flL8YTHnAqHAcOrSOAU4UxUYKOIjJa2N0XuEX3rj7CHlXu4YfYGcs-/s1600/images.jpg" style="border: none; position: relative;" /></a>// message $message = ' <html> <head>   <title>Title of th email</title> </head> <body>   Folling is the Details   <table>     <tr>       <th>Some Name 1</th><th>Some Name 2</th>     </tr>     <tr>       <td>Some Value 1</td><td>Some Value 1</td>     </tr>     <tr>       <td>Some Value 1</td><td>Some Value 1</td>     </tr>     <tr>       <td>Some Value 1</td><td>Some Value 1</td>     </tr>   </table> </body> </html> '; // To send HTML mail, the Content-type header must be set $headers  = 'MIME-Version: 1.0' . "\r\n"; $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; // Additional headers if required $headers .= 'To: name 1 <name1@example.com> ' . "\r\n"; $headers .= 'From: Name of the sender <sender@example.com>' . "\r\n"; $headers .= 'Cc: cctothisemail@cctothisemail.com' . "\r\n"; $headers .= 'Bcc: bcctothisemail@cctothisemail.com' . "\r\n"; // Additional headers if required // Mail it mail($to, $subject, $message, $headers); // Mail it ?></div>

Sending HTML mail using PHP

<?php // multiple recipients $emailto = 'emailto@example.com'; // note: For Multi emailto user comm // subject $subject = '...

Move your Magento site from one hosting account to another

<div dir="ltr" style="text-align: left;" trbidi="on">
Follow these steps to transfer Magento from one account to another: 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjE3Kh6PvRJLYpLIVeOdUeUrRdGsEux7nuBT9bDuBj6oXXSiorXir-Qd__UK9c2ZA360nIa_hzAEZb-XIVjnl9AXTsovzLrGybjvJzakb_FsxDDVlPth5rf9eWY20HFwoWrJPHC6ApV12E/s1600/magentologo.jpg" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img alt="magento" border="0" height="173" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjE3Kh6PvRJLYpLIVeOdUeUrRdGsEux7nuBT9bDuBj6oXXSiorXir-Qd__UK9c2ZA360nIa_hzAEZb-XIVjnl9AXTsovzLrGybjvJzakb_FsxDDVlPth5rf9eWY20HFwoWrJPHC6ApV12E/s1600/magentologo.jpg" title="magento" width="320" /></a></div>
 
<ul style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px; list-style-image: initial; list-style-position: initial; margin: 0.5em 0px; padding: 0px 2.5em;">
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">Step 1: Backup the Magento MySQL Database</li>
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">Step 2: Transfer all Magento Files</li>
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">Step 3: Adjust the Magento Configuration</li>
<li style="border: none; margin: 0px 0px 0.25em; padding: 0px;">Step 4: Restore the Magento Database</li>
</ul>
<div style="background-color: white; color: #333333; font-family: Arial, Tahoma, Helvetica, FreeSans, sans-serif; font-size: 15px; line-height: 20.7900009155273px;">
STEP 1 Backup the Magento MySQL Database 
 
On SiteGround servers you have phpMyAdmin included by default in cPanel for your account. In other cases you will have to use the same tool or a similar one that is capable of exporting your MySQL database. Detailed information on how to perform a MySQL backup can be found in our MySQL Tutorial. 
 
Alternatively, if you don’t have phpMyAdmin installed but you have shell access you can use the mysqldump tool. The syntax is as follows: 
 
mysqldump -h HOST -u USER -p DATABASENAME > FILENAME.sql 
where: 
 
HOST is the database server hostname or it can be omitted if you are running the MySQL server locally 
USER - a user with full privileges to the Magento database 
DATABASENAME - is the full name of the database which Magento is running 
FILENAME - can be anything you find suitable for the backup file 
Also, if you have Plesk, DirectAdmin or any other web hosting management tool, you can look at the available options. Many panels allow you to dump the database with just a few clicks. For example cPanel does have an option for this. 
 
STEP 2 Transfer all Magento Files 
 
You will need to <span class="IL_AD" id="IL_AD1" style="background-attachment: scroll !important; background-clip: initial !important; background-color: transparent !important; background-image: none !important; background-origin: initial !important; background-position: 0% 50%; background-repeat: repeat !important; background-size: initial !important; border-bottom-color: rgb(103, 176, 69) !important; border-bottom-style: dotted !important; border-bottom-width: 1px !important; color: rgb(103, 176, 69) !important; cursor: pointer !important; display: inline !important; float: none !important; padding: 0px 0px 1px !important; position: static;">download all files from your current store and upload them to the new location. This can be a time consuming task considering that a standard Magento installation consists of many files. A good alternative is to archive the files prior to downloading/uploading them if possible. 
 
If you have SSH access you can log on your server -> magento installation directory and archive all the files using the following command: 
 
tar -czif ARCHIVENAME.tar.gz 
This will create a tarball archive of all the files in the directory. 
 
You can then download the archive and easily upload it to the new location. To extract it at the new location use the following command in the desired destination folder for the Magento installation: 
 
tar -xzif ARCHIVENAME.tar.gz 
STEP 3 Adjust the Magento Configuration 
 
After the files are restored you should alter the configuration file in order to match the new settings. All you need to change here is the database details at the new location. Those are stored in the app/etc/local.xml file. The lines you need to alter are: 
 
<host><![CDATA[HOSTNAME]]></host><username><![CDATA[USER]]></username><password><![CDATA[PASSWORD]]></password><dbname><![CDATA[DATABASENAME]]></dbname> 
where: 
 
HOSTNAME should be the database hostname, most commonly - localhost 
USER is a user that has full privileges to the database 
PASSWORD is the password for the database user 
DATABASENAME is the complete database name for the database you are going to use with the transferred Magento 
STEP 4 Restore the Magento Database 
 
Once you have adjusted the options above you should restore the database at the new location. 
 
A good practice is to add several options in the MySQL backup file prior to uploading it. The following should be added at the beginning of the SQL file: 
 
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT;SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS;SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION;SET NAMES utf8;SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO';SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0; 
The next option should be added at the end of the file after all other queries: 
 
SET SQL_MODE=@OLD_SQL_MODE;SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT;SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS;SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION;SET SQL_NOTES=@OLD_SQL_NOTES; 
You can now import the database using phpMyadmin -> Import or another MySQL tool depending on what kind of access you have to the website. 
 
In case you would like to restore the database via a shell command you can use the following: 
 
mysql -h HOST -u USER -p DATABASENAME < FILENAME.sql 
and enter the password for the database user when asked. 
 
Note that if the Magento online store is supposed to work with a different domain name at the new location you should alter the entries for it in the MySQL database. 
 
The table you should edit is core_config_data and the values you need to change are in the path column. Change the web/unsecure/base_url and web/secure/base_url to match the new domain name by altering the value column for both records. 
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH0ymbqn3NuYv_1iwjUhGXqPInsBY8-InCs3MGhMXejrdfKFun8MQW1L1QmK5B7jFufjps5CAKa9UlpHNWAAEskdmbUIGJ379UMFv30qeYoEtQcVdvemcPpqJEf0XtjzuSYdWUfIVchfci/s1600/magentomove01.jpg" imageanchor="1" style="color: #771100; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" height="171" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhH0ymbqn3NuYv_1iwjUhGXqPInsBY8-InCs3MGhMXejrdfKFun8MQW1L1QmK5B7jFufjps5CAKa9UlpHNWAAEskdmbUIGJ379UMFv30qeYoEtQcVdvemcPpqJEf0XtjzuSYdWUfIVchfci/s1600/magentomove01.jpg" style="border: none; position: relative;" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
 </div>
<div class="separator" style="clear: both; text-align: center;">
 </div>
<div class="separator" style="clear: both; text-align: center;">
The last step is to clear the Magento cache. You can do this either via the Magento admin panel > System > Cache management or by deleting the contents of the var/cache and var/session folders inside your Magento installation directory.</div>
<div class="separator" style="clear: both; text-align: center;">
 </div>
<div class="separator" style="clear: both; text-align: center;">
That is all. Your Magento should now be properly functioning at the new location.</div>
</div>
</div>

Move your Magento site from one hosting account to another

Follow these steps to transfer Magento from one account to another: Step 1: Backup the Magento MySQL Database Step 2: Transfer all Ma...