Latest Posts

Different table types in Mysql

MySQL Storage Engines There are lots of tables in Mysql table types MyISAM ISAM InnoDB BDB(Berkeley DB) Merge Heap(Memory) Archieve Blackhole CSV NDB(ndbCluster) Example Federated Here we are discussing all the table types in details below: InnoDB Storage Engine The default storage engine in MySQL 5.7. InnoDB is a transaction-safe (ACID compliant) storage engine for MySQL that has commit, rollback, and crash-recovery capabilities to protect user data. InnoDB row-level locking…
Read more

Hide Layout in Zend Framework

Hello Guys, Today we will discuss on hiding the layout from the Zend Framework action controller. Basically, this code will use where we need to open the popup with hiding the header/footer on the screen. For using this we need to disable layout and set ViewRenderer helper true for particular action.

Post Views: 450

How to create and extract .tar.gz file

Hi Friends, Here we will discuss how to create and compress the folder into the .tar.gz file Compress the file or folder:

I had used the sudo before tar command because it will not have any permission issue. Here are the switches actually mean: -c: Create an archive -v: It is used for display the progress on the screen.It is optional so you can skip it -z: Compress the…
Read more

Full Text searching in MySql

Hi Friends, Today we will discuss on the full-text searching using MySQL. First of all, we need to create columns for text searching. So I have created 2 columns for searching, address1 and address2.

To search for employee addresses  with ALL address1 and address2 in the data.

  Post Views: 439

Storing Session data into MySQL database

Hi Guys, Today we will discuss on store PHP session data into MySQL database. Its most critical part of the application when our application runs on the shared server and session data is hijacked or injected harmed by an attacker. So we need to be careful on this. Everyone knows that my session data is stored by default into the /tmp folder and this is writable by all users. For…
Read more

Factory Design Pattern using PHP

Hi Guys, Today we will discuss on the Factory Design Pattern using PHP. It’s most common design pattern and it’s mostly implemented by most of the frameworks and applications. Basically we will first create an Abstract class that will have functions declared in it.

Now I will create MySQLManager class first and it extends from the above class AbstractDatabase and will implement in the above-declared class functions here.

Read more

Heap Tables in Mysql

Hello Guys, Today we will discuss on the HEAP tables in MySQL. HEAP tables are present in memory and they are used for high-speed storage on the temporary basis.You need to specify the type while at creation. Basically, heap tables are also called memory tables.If the Mysql Database crashed then you will loose all data stored in the heap tables.

BLOB and TEXT type of data storage are not…
Read more

Pass by reference in function

Hi Friends, Today we will discuss the how to passing data by reference using the PHP. When we pass the parameters to the functions as the reference then it manipulates the reference faster. It happens only because when we pass by value then it creates one more copy of the value is getting created. So try to make practice as passed by reference and for that, you only need to…
Read more

Store Zend based Logging into mysql table

Hello Guys, Today we will discuss on how to store zend logging data into the mysql table. First of all we need to create Here is the code given below:

Post Views: 434

Zend Framework Call Different layout

Hello Guys, If I am working on the Zend Framework project and a by default layout is set for all the controllers/action. If I want to set another layout for one of my action then I will call this code in my action.

Suppose I have admin-layout.phtml layout and I want to call in my action then I will use this code.

Post Views: 441

Optimization WordPress Plugins & Solutions by W3 EDGE