What is .frm, .myi, .myd. txt file in PhpMyadmin and MySQl?

What is .frm, .myi, .myd. txt file in PhpMyadmin and MySQl? When creating the table in database,that time 3 text file is generated in local.That files are   .FRM  =>  It has the table structure of your table or table definition  .MYI  =>   It has the indexes of your table  .MYD =>   It contains your data Generally you can find the data directory of your file with your .my.cnf file. The physical structure of db is some thing like a directory structure, where each database is a subdirectory...

Read More

Import CSV Files using php and mysql

  To import csv files into the mysql table,for this removing the header of the csv files and then run the below script.It will be insert into our mysql table. //Import csv files into mysql table LOAD DATA LOCAL INFILE 'd:\\Site.csv' INTO TABLE `siteurl` FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'; //ends Character Escape Sequence \0 An ASCII NUL (0x00) character \b A backspace character \n A newline (linefeed) character \r A carriage return character \t A tab character \Z ASCII 26 (Control+Z) \N NULL Note...

Read More

How to remove the array values in php

    By using array_diff() function , we can remove the array values in php     <?php <?php $arr_remove = array('Codingslover', 'webslessons', 'meetcity',        'eshopoffers','google'); $arr = array_diff($arr_remove, array('webslessons', 'google')); echo "<pre>";print_r($arr_remove); echo "<pre>";print_r($arr); ?> ...

Read More