Author's posts

Create URL Slug from Post Title using PHP

The following functions will helps to create search engine optimization url for the website. This will strip all the special characters and punctuation away from the URL and place hyphen in between each words. For acheving the required results, used regular expression function that replaces spaces between words with hyphens and its remove the special …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/08/create-url-slug-from-post-title-using-php/

Best way to order the best matching records in MySQL

If we are searching a word (string) in the mysql table, usually we will use the below method: [sql] SELECT * FROM user WHERE name LIKE ‘%searchstring%’ ORDER BY name ASC; [/sql] If you search like this, It will order the result set based on the ASC of name. It will not order the result …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/08/best-way-to-order-the-best-matching-records-in-mysql/

How to save an image of the highcharts on the server?

Highcharts have a built-in option to export the current chart, it have the option to save the chart as PNG, JPEG, PDF or SVG. It doesn’t have option to save the image on the server, instead of downloading in browser (clinet). To save an image of the highcharts on the server, follow the steps: Step …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/08/how-to-save-an-image-of-the-highcharts-on-the-server/

How to create the JAR file

The JAR file format is a compressed format used primarily to distribute Java applications and libraries. It is built on the ZIP file format, and functions in a similar way; many files are compressed and packaged together in a single file, making it easy to distribute the files over a network. If you need to …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/08/how-to-create-the-jar-file/

How to install maven on Ubuntu

Apache Maven is a software project management and comprehension tool. Based on the concept of a project object model (POM), Maven can manage a project’s build, reporting and documentation from a central piece of information. This will helps you to install Apache Maven 3 on ubuntu. Follow the steps to install: Step1: Before you can …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/08/how-to-install-maven-on-ubuntu/

How To Install Apache Tomcat 8 on Ubuntu

Apache Tomcat is an open source web server used to deploy and serve JavaServer Pages (JSP) and Java Servlets. This will helps you to install Apache Tomcat 8, Apache Tomcat 8 now has its first stable release: 8.0.9. Follow the steps to install Apache Tomcat 8 on Ubuntu: Step 1: Install Java 7 Before you …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/08/how-to-install-apache-tomcat-8-on-ubuntu/

How to uninstall Software packages from Eclipse editor

The Uninstall wizard allows you to review and uninstall software package in your eclipse editor. This wizard is shown when you selected software package and press Uninstall from the Installed Software page. To uninstall software from your system: 1) Click Help > About Eclipse and then click command link Installation Details button in opened dialogue …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/08/how-to-uninstall-software-packages-from-eclipse-editor/

How to use NuSOAP Toolkit for PHP

NuSOAP is a rewrite of SOAPx4, provided by NuSphere and Dietrich Ayala. It is a set of PHP classes – no PHP extensions required – that allow developers to create and consume web services based on SOAP 1.1, WSDL 1.1 and HTTP 1.0/1.1. Clik here to can download NuSOAP Toolkit for PHP. Steps to use …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/07/how-to-use-nusoap-toolkit-for-php/

How to use MySQL for case sensitive string comparison

By default MYSQL character set and collation are latin1 and latin1_swedish_ci, so non-binary string comparisons are case insensitive. This means that if you search with col_name LIKE ‘a%’, you get all column values that start with A or a. To make this search as case sensitive, make sure that one of the operands has a …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/07/how-to-use-mysql-for-case-sensitive-string-comparison/

phpmyadmin – Cannot start session without errors, please check errors

Unfortunately sometimes we get the problem with phpMyAdmin, here is the error from phpMyAdmin on ubuntu machine. phpMyAdmin – Error [code] Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly. [/code] To find out where the session.save path http://wiki.phpmyadmin.net/pma/session.save_path run this script …

Continue reading

Permanent link to this article: https://blog.openshell.in/2014/06/phpmyadmin-cannot-start-session-without-errors-please-check-errors/