MYISAM MYISAM supports Table-level Locking MyISAM designed for need of speed MyISAM does not support foreign keys hence we call MySQL with MYISAM is DBMS MyISAM stores its tables, data and indexes in diskspace using separate three different files. (tablename.FRM, tablename.MYD, tablename.MYI) InnoDB InnoDB supports… Read More »What is the difference between MyISAM and InnoDB?
FacebookTwitterLinkedinPinterest
FacebookTwitterLinkedinPinterest
The logic of the below methods will help you to reverse the integer in any language, here I am doing it in PHP. So let’s create a function with the name of reverse_integer:- it will reverse the interger. Reverse string in PHP without strrev() function:-… Read More »How to reverse value of integer or string in php?
Lets take an example that we have two table one have record of students and other have id which have to delete in table 1, so we write query like this:- DELETE FROM table_1 WHERE id IN (SELECT id FROM table_2); Above query will delete… Read More »How to delete record data from another table id – MySQL
No input file specified – Codeigniter issues:- this issue sometimes caused by the .htaccess file, so change your .htaccess file to the below code RewriteEngine onRewriteBase /RewriteCond %{REQUEST_FILENAME} !-fRewriteCond %{REQUEST_FILENAME} !-dRewriteRule ^(.*)$ index.php?/$1 [L] Also some time this will work in CodeIgniter After adding the… Read More »No input file specified – Codeigniter
In this tutorial, you will know how to export a query result in excel CSV from MySQL PHPMyAdmin. Sometime we need to just export the query result in excel or csv for reports purpose or for any purposes, so this will help you out to… Read More »How to export a query result in excel CSV from MySQL PHPMyAdmin
Sometime while working with function in php, we want to know that how many argument is passing in a function or a variable parameter. For solving this situation we need to count the variable parameter by this function func_num_args() – it will return the number… Read More »How to count number of variable parameter in a function – PHP
Sometimes we need to convert an array into a string with some separator parameter, and also convert a set of comma-separated string into an array, to make this possible PHP has two functions:- Explode Function Implode Function Explode Function:– The explode function split the string… Read More »What is explode and implode in PHP?
In this tutorial, we are going to know how to send emails using Sendgrid in PHP. SendGrid is a customer communication platform marketing email. For PHP, SendGrid also provides its library that can be used for calling the SendGrid API. Here is the Step you… Read More »How to send Emails using Sendgrid in PHP?