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 …
Category: Ubuntu
Permanent link to this article: https://blog.openshell.in/2014/08/best-way-to-order-the-best-matching-records-in-mysql/
Aug 15
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 …
Permanent link to this article: https://blog.openshell.in/2014/08/how-to-save-an-image-of-the-highcharts-on-the-server/
Aug 09
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 …
Permanent link to this article: https://blog.openshell.in/2014/08/how-to-create-the-jar-file/
Aug 02
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 …
Permanent link to this article: https://blog.openshell.in/2014/08/how-to-install-maven-on-ubuntu/
Aug 02
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 …
Permanent link to this article: https://blog.openshell.in/2014/08/how-to-install-apache-tomcat-8-on-ubuntu/
Aug 01
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 …
Permanent link to this article: https://blog.openshell.in/2014/08/how-to-uninstall-software-packages-from-eclipse-editor/
Jul 30
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 …
Permanent link to this article: https://blog.openshell.in/2014/07/how-to-use-nusoap-toolkit-for-php/
Jul 18
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 …
Permanent link to this article: https://blog.openshell.in/2014/07/how-to-use-mysql-for-case-sensitive-string-comparison/
Jun 21
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 …
Permanent link to this article: https://blog.openshell.in/2014/06/phpmyadmin-cannot-start-session-without-errors-please-check-errors/
Jun 20
How to use SOAP client in PHP
This tutorial will helps you to understand the way of invoking SOAP Web Service from PHP SOAP Client. Before Start using PHP Soap client, You need to verify that Whether SOAP Client is enabled in your PHP Web Server. To verify that create new php file with the following code. [php] <?php phpinfo(); ?> [/php] …
Permanent link to this article: https://blog.openshell.in/2014/06/how-to-use-soap-client-in-php/