18 Jun 2015

Adding links to the Top menu in Magento

Magento V 1.9.1

>rwd/template/page/html/topmenu.phtml

>add the following code

<?php
     $routeName = Mage::app()->getRequest()->getRouteName();
     $identifier = Mage::getSingleton('cms/page')->getIdentifier(); 
?>
<ul id="nav">

  <li class="level0 home level-top <?php if($routeName == 'cms' && $identifier == 'home') {echo " active";}?>">
  <a href="<?php echo $this->getBaseUrl(); ?>" class="level-top"><span><?php echo $this->__('Home'); ?></span></a>
</li> 

26 Mar 2015

How to update Auto increment value in single column field using a single query

Go to your database ->SQL
and add the following query like your table field


SET @ordering = 0; UPDATE table SET increment = (@ordering := @ordering + 1) WHERE field = 'value' ORDER BY order_field;


29 Nov 2014

Enable WordPress Permalinks on Windows IIS

WordPress is written in PHP, and generally php runs better under apache on Linux, but you can run it on IIS on Windows machines. In fact this blog is running under Windows.*

If you find you have changed the permalinks options in your wordpress installation, but you find they don’t work,  first check if you are running on a Windows machine. On a shared hosting account, it should have said whether it was windows or linux, but at the least, if you have the option for asp.net, then you are on windows.

If you are on a Linux machine under apache, there are loads of resources for making sure permalink rewrites work. Running WordPress on windows however is much less common, so I thought I would post a quick fix for getting it to run under IIS7.

The trick involves adding a web.config file to your base installation. A web.config file is a configuration file used by Windows specifically for .net, but in this case if you are running wordpress you can trick IIS into passing the buck on files it can’t find to WordPress, that then handles it.

Simply ensure the URL Rewrite module is enabled on the IIS server (lots of hosts, including GoDaddy, have this enabled, but talk to your hosting company if it doesn’t), then add the following web.config file to the base of your WordPress installation.

Solution

Step: 01
>Open up a text editor and create a new file
>Copy/paste in the code that follows(code 1 or code 2) into your new text file.
>Save the file as web.config
>Upload the file to the root of your WordPress installation

Step: 02
>Log into your WordPress install  Dashboard –> Settings –> Permalinks and set it to Post name and click Save Changes.

You should now have Pretty Permalinks on a Windows server!

Code 1

<rewrite>
 <rules>
 <rule name="Main Rule" stopProcessing="true">
 <match url=".*" />
 <conditions logicalGrouping="MatchAll">
 <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
 <add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />
 </conditions>
 <action type="Rewrite" url="index.php" />
 </rule>
 </rules>

</rewrite>


Code 2

<?xml version="1.0"?>

<configuration>

  <system.webServer>

    <rewrite>

      <rules>

        <rule name="Main Rule" stopProcessing="true">

          <match url=".*" />

          <conditions logicalGrouping="MatchAll">

            <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />

            <add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />

          </conditions>

          <action type="Rewrite" url="index.php" />

        </rule>

      </rules>

    </rewrite>

  </system.webServer>


</configuration>

29 Oct 2014

What is short open tag in php

<?= is not equal with <?php.

<?= is the short open tag for <?php echo

<? is the short open Tag for <?php

You can use short open tags by activate short_open_tag in the php.ini.


How to Enable "short open Tag":


Method 01
Go to php.ini and set short_open_tag = On

and then finally restart your server


Method 02

You should be able to change it in your .htaccess file if it wasn't locked down

<IfModule mod_php5.c>
   php_value short_open_tag 1
 </IfModule>

25 Oct 2014

How to change PrestaShop admin Password using Database

Step :01
Go to the PrestaShop root folder and find the config folder. This will take you to a list of all files within that folder.select-config-folder

Step :02

Look for the settings.inc.php file.

Step :03
Once inside the settings.inc.php file, locate the setting named _COOKIE_KEY and copy the string value. You may want to save it temporarily to a word processing document such as notepad.

Step :04
Go to the database and select the one named ps_employee.
Note that your PrestaShop database prefix might not begin with ps_

Step :05

This opens the table data information. Find your admin user from the list of data rows.

Step :06
Find the password row, it is named passwd. There are two columns you will need to edit. The first is the Function column. Use the dropdown and select the MD5 option. The second column is the Value column. For this column, paste the _COOKIE_KEY value you saved earlier and attach your new password directly to the end of the key with no spaces. Be sure to use a real password and not anything easy like NEWPASS1234 that we used in the example.


Step :07

Then click the GO button to save the new information.

Now login the admin panel.