SQL BETWEEN Operator

Sql Between operator find the database in between two database values. this operator used between and not between data filtering database.

SELECT * FROM tablename WHERE cost BETWEEN 200 AND 300

Rename file directory in php

 PHP rename() function changed old directory to new directory If new name exists, it will be overwritten. Sometime wrongly uploaded file images or folder that time use this function easy to rename the new directory or image name. 

rename('oldname','newname');

HTML input file accept Attribute

 We upload PDF filein database, that time we use Html input type file attribute. but it's accept all type of files. After submitting form only we know wrong upload file format. So avoid that method just give the file accept type to ignore other file types.

Live Demo

Delete image from folder in php

Some programmer using image upload coding that image file move on particular folder. after delete  that database record data only deleteed but image stay on same folder only it's not delete. So add below code remove deleted record folder image.  

unlink('foldername/'.$imagename); 

Import CSV File Data Into Database Using PHP

Import CSV File Data Into Database Using PHP sometime large amount Database data not possibe to insert into at a time. Ex; E-commerce site add all product list.  that's why use to  CSV file import code . just create  Excel document enter your data save CSV format after that import to database.

Facebook style photo comment system

 Facebook style photo comment. Here i have use normal light box pop window. inside the box i have design similar like facebook design. follow this code you can learn facebook style photo comments system.