Tag Archives: Javascript

HOW TO LIST FILES IN A DIRECTORY WITH PHP

Here’s a simple way to execute the windows dir or the linux ls in PHP Windows: <?php $row = exec(‘dir’,$output,$error); while(list(,$row) = each($output)){ echo $row, “<BR>\n”; } if($error){ echo “Error : $error<BR>\n”; exit; } ?> Linux: <?php $row = exec(‘ls -ls’,$output,$error); while(list(,$row) = each($output)){ echo $row, “<BR>\n”; } if($error){ echo “Error : $error<BR>\n”; exit; } 

Continue reading

CALCULATE THE NUMBER OF DAYS BETWEEN TWO DATES

Here’s a simple function that calculates the number of days between two dates. <?php //day’s seconds = 86400 function days_between($day_i,$month_i,$year_i,$day_f,$month_f,$year_f){ $days_in_between = (mktime(0,0,0,$month_f,$day_f,$year_f) – mktime(0,0,0,$month_i,$day_i,$year_i))/86400; return $days_in_between; } ?> //If we want to calculate the days between 21/8/2009 and 1/9/2009 then echo days_between(21,8,2009,1,9,2009); //would give us 11

Continue reading

USING MYSQL TRANSACTIONS WITH PHP

The following is an example of using the transactional support in MySQL. Let’s assume we have two tables, USERTBL and EMAILTBL. Let’s consider the innodb engine, since it’s the most popular transaction storage engine. CREATE TABLE USERTBL( USERKEY int unsigned not null auto_increment, email …   

Continue reading

SOLVING PHP MYSQL UTF-8 ISSUES

Heres a list of actions you should do in order to get PHP + MySQL working with UTF-8: 1. Database: CREATE DATABASE db_name CHARACTER SET utf8 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT COLLATE utf8_general_ci ; or if the database was already created: ALTER DATABASE db_name CHARACTER SET utf8 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci …

Continue reading