Serialization which help us to store or transport PHP data structure such as an array or object. All the storage meduim or database can store String type. It will generates a storable representation of a value. This is useful for storing or passing PHP values around without losing their type and structure. Essentially, it takes a …
Category: Windows
Microsoft Windows operating system.
Permanent link to this article: https://blog.openshell.in/2014/01/serailization-unserialization-in-php/
Nov 14
How to use serialized object in Active Record using Rails?
Serializing Object Will help us to store multiple column values in single Database column and even making processing using that column simple. It helps to extended the table without adding new column in table. Because we can store multiple column values in single column as Hash value. So, It reduce the difficulty of retriving and …
Permanent link to this article: https://blog.openshell.in/2013/11/how-to-use-serialized-object-in-active-record-using-rails/
Oct 18
How to retrieve the last record in each group using mysql
In single SQL query itself we can retrieve the last record in each group. It will help us to perform action better, faster and simpler. In this post I will explain about you how to do it. Here is my table structure for your reference. [sql] desc post_status; +—————-+————-+——+—–+———+—————-+ | Field | Type | Null …
Permanent link to this article: https://blog.openshell.in/2013/10/how-to-retrieve-the-last-record-in-each-group-using-mysql/
Sep 06
How to reset a Magento password using Mysql Server
If you are unable to log in to your magento application? Follow the below steps to reset your magento store password from Mysql server. Step1: Select your database from the Mysqlserver. Step2: Find admin_user table from the selected database. Step3: In that table, edit the user which you want to reset their admin password. Step4: For security …
Permanent link to this article: https://blog.openshell.in/2013/09/how-to-reset-a-magento-password-using-mysql-server/
Sep 03
How to Reset a WordPress Password from Mysql Server
Its essential thing to knowing, how to reset the wordpress password from Mysql server without following traditional method. Because your site may hacked, you may forgot your admin password and its email id to reset the password, you are no longer able to login into wordpress using login credentials. This method will very useful to …
Permanent link to this article: https://blog.openshell.in/2013/09/how-to-reset-a-wordpress-password-from-mysql-server/
Aug 28
Find number of working days between two dates in Mysql
This which helps to find number of working days between two dates in Mysql. There is no specific or inbuilt function in mysql, For that we need to use the SQL query as below. [sql] SELECT 5 * ((DATEDIFF(@end_date, @start_date) ) DIV 7) + MID(‘0123455501234445012333450122234501101234000123450’, 7 * WEEKDAY(@start_date) + WEEKDAY(@end_date) + 1, 1) [/sql] For …
Permanent link to this article: https://blog.openshell.in/2013/08/find-number-of-working-days-between-two-dates-in-mysql/
Jun 25
How to Compare Two Versions of the Same Word Document in Office 2010
1) Open the word document in Office 2010, Click the Review tab and choose Compare -> Compare. The Compare Documents dialog box shows up. 2) Select the original document from the Original Document drop-down list. If you can’t find the original document, click the wee folder icon to browse for it. 3) Select the edited …
Permanent link to this article: https://blog.openshell.in/2013/06/how-to-compare-two-versions-of-the-same-word-document-in-office-2010/
May 04
How to remove dead node out of the Cassandra cluster?
This tutorial will helps you to remove unused / dead node from the cassandra cluster ring. Run the following command in console to list the cluster node ring formation. [code] nodetool -h <cluster-ip1> ring [/code] Results of the command it list details as like below: [code] Note: Ownership information does not include topology, please specify …
Permanent link to this article: https://blog.openshell.in/2013/05/how-to-remove-dead-node-out-of-the-cassandra-cluster/
May 02
Mysql GROUP_CONCAT
MySQL has useful extention to the GROUP BY operation – function GROUP_CONCAT: GROUP_CONCAT(expr) – This function returns a string result with the concatenated non-NULL values from a group. Returns NULL when there are no non-NULL values. Where it can be useful? For example to get array without looping inside the code, In single SQL query …
Permanent link to this article: https://blog.openshell.in/2013/05/mysql-group_concat/
Apr 10
Connect MS SQL Server with Rails
To connect MS SQL Server with Ruby on Rails follow the below steps: SQL Server (2005 or higher recommended) Install the adapters and driver [code] gem install tiny_tds gem install activerecord-sqlserver-adapter [/code] Ensure the activerecord adapter and db driver gems are defined in your Gemfile [code] gem ‘tiny_tds’ gem ‘activerecord-sqlserver-adapter’ [/code]
Permanent link to this article: https://blog.openshell.in/2013/04/connect-ms-sql-server-with-rails/