Author: naveenos
-
MySQL: How to delete X day old entries
In some cases we need to remove old entries from the database or remove entries before specific days. So mysql provides the syntax to delete records: DELETE FROM $table_name WHERE $date_field < date_sub(CURDATE(), $numberOfDays day) If above query does not work for you then its version issue. So you can do same thing like this:…
-
Javascipt: how to use nl2br function
In php we have a function to replace nl2br means new line to break format. but when we need this functionality in our javascript code then what we do? We can do by simply manner: function nl2br(value) { return value.replace(/\n, “”); } Above function will return the converted ‘\n’ to ‘‘. But above function has…
-
Joomla: $this->baseurl is not working in custom template module
Joomla provides some basic themes which are already installed in the templates folder. When any developer develop the CMS in the joomla , he use his own template with new design. On the index page $this->baseurl works well but when he want to own module then he create a folder in custom template folder. But…
-
Javascript: How to check is valid number or not
Numeric validation require in mostly cases when we want that user enter only numeric value in any text field. For example ‘Age’ field. Obviously, age can not be in string format. Above, I have mentioned javascript function to check that entered value is numeric or not. Please enter only numeric value : Tweet This Post
-
PHP: Regular expression to make linkable url in string
Are you looking for a regular expression to make clickable url in the string? Yes!, you will get your solutions here: echo preg_replace(“/http\:\/\/[a-zA-Z0-9\-\.]+\.[a-zA-Z]{2,3}(\/\S*)?/”, “$0”, $string); If you want to open url in new tab then : echo preg_replace(“/http\:\/\/[a-zA-Z0-9\-\.]+\.[a-zA-Z]{2,3}(\/\S*)?/”, “$0”, $string); Tweet This Post
-
MySQL: Remove duplicate entry from the databse keeping one record
Sometimes we written a code to enter some dynamic entry in the table but did not want to enter duplicate records for same id ( not primary field). and we found that we have entered many records in the table and not it is not possible to delete record manually. For this we can run…
-
WordPress: Add or remove ‘www’ from your url
In most cases we see that when we try to open any site then it add ‘www’ in the url or remove from the url. This can be manage by Htaccess in general sites on the server. Wordpres provides a good facility to manage this url setting. 1. Go Settings > General 2. Set WordPress…
-
Magento: How to get increment id of an Order by order id in magento
In most cases, an user (A developer) need to write own code to generate an order, generate invoice for an order or generate shipment for an order then he need both order id and its increment id. You can get this increment value by following code: $order = Mage::getModel(‘sales/order’); $order->load(Mage::getSingleton(‘sales/order’)->getLastOrderId()); $orderIncrementId = $order->getIncrementId(); Tweet This…
-
Magento: Fatal error: Call to undefined method Mage_Adminhtml_Block_Abstract::getexceptions()
When I tried to export or import any profile, then I got a fatal error: Fatal error: Call to undefined method Mage_Adminhtml_Block_Abstract::getexceptions() in …….\app\code\core\Mage\Adminhtml\Block\System\Convert\Profile\Run.php on line 167 To remove this problem follow below process: 1. Go to file which showing in fatal error. 2. Comment line 167 and 168, then it will show like: //…
-
Ajax: Upload a file through ajax ( without page refresh)
In most cases we need to upload something on server without refreshing the page. for example we want to upload an image from popup window. But it will refresh the page and we will lost our popup and its content… so for this type of problems we providing an attractive code for upload a files…
-
Write the text on image using GD Library
What is the GD library? GD is an open source code library for the dynamic creation of images by programmers. GD is written in C, and “wrappers” are available for Perl, PHP and other languages. GD creates PNG, JPEG and GIF images, among other formats. GD is commonly used to generate charts, graphics, thumbnails, and…
-
How to find Server time in magento
Many times developer gets the time problem during project development. Because he works on date function which provides by PHP but site works on different server which time is different from developer country. So for this case you can use magento time which priovides by Magento self. It Manage the server time. This line will…
-
Translate english to hindi by google api
Sometimes we need to develop a website with Hindi font. But main problem is how to insert content in Hindi in admin panel. so here is a solution by this admin can enter content in Hindi font. It will work like: When admin type any word like ‘welcm‘ and then type space it will automatically…