/** 	Wysiwyg gratuits :		**/
http://nicedit.com/
http://www.openwebware.com/

<?php
/* 1-generer une liste */
$listName="appli";
$AppliArray=array(0=>"BOL", 1=>"DL", 2=>"ICD", 3=>"PAC", 4=>"Other");
$listArray=$AppliArray;
$listHtml="<select name=\"".$listName."\">\n";
$the_keys = array_keys($listArray);
foreach($the_keys as $key_value) {
	$listHtml.="<option value=\"".$key_value."\">".$listArray[$key_value]."</option>\n";
}
$listHtml.="</select>\n";
echo $listHtml;
/* 1-fin */
?>

<?php
/* 2-MySQL insert */
$db_host="localhost";
$db_user="root";
$db_password="";
$db_name="mywork";
$link=mysql_connect($db_host, $db_user, $db_password);
mysql_select_db($db_name);
$query="select * from users";
$result=mysql_query($query);
/* 2-Fin */
?>

<?php
/* 2-MySQL fetch */
$db_host="localhost";
$db_user="root";
$db_password="";
$db_name="mywork";
$link=mysql_connect($db_host, $db_user, $db_password);
mysql_select_db($db_name);
$query="select * from tasks";
if($result=mysql_query($query)) {
	$flow="";
	while ($row=mysql_fetch_array($result)) {
		$flow.="<td>".$row['appli']."</td>\n";
		$flow.="<td>".$row['category']."</td>\n";
		$flow.="<td>".$row['description']."</td>\n";
		$flow.="<td>".$row['time_spent']."</td>\n";
	}
}
$dispHtml="<tr>\n";
$dispHtml.=$flow;
$dispHtml.="</tr>\n";
echo $dispHtml;
/* 2-Fin */
?>

<?php
/* 1-Week management */
$today=getdate();
$sunday_array=array(1=>-1, 2=>-2, 3=>-3, 4=>-4, 5=>-5);
$saturday_array=array(1=>5, 2=>4, 3=>3, 4=>2, 5=>1);

// calcul jour
if($week=="last") {
	$xday=$today['mday']-7;
	$yday=$today['mday']-7;
} else {
	$xday=$today['mday'];
	$yday=$today['mday'];
}

$sundayst=mktime(0, 0, 0, $today['mon'], $xday+$sunday_array[$today['wday']], $today['year']);
$saturdayst=mktime(0, 0, 0, $today['mon'], $yday+$saturday_array[$today['wday']], $today['year']);

$sunday=date("Y-m-d", $sundayst);
$saturday=date("Y-m-d", $saturdayst);
/* 1-end */
?>

<?php
/* 1-MySQL select simple */
$db_host="localhost";
$db_user="root";
$db_password="";
$db_name="mywork";
$link=mysql_connect($db_host, $db_user, $db_password);
mysql_select_db($db_name);
$query="SELECT * FROM todo WHERE id=1";
if($result = mysql_query($query)) $row=mysql_fetch_array($result);
$tasks = $row['tasks'];
mysql_close($link);
//print_r($row);
/* 1-End */
?>

<?php
/* 1-File upload */
$uploaddir = "files/";
//$file_extension = substr(strrchr($_FILES['filetoupload']['type'], "/"), 1 );
$file_extension= substr($_FILES['filetoupload']['name'],(strrpos($_FILES['filetoupload']['name'], "."))+1);
$newfilename = $newfilename.".".$file_extension;
if (move_uploaded_file($_FILES['filetoupload']['tmp_name'], $uploaddir.$newfilename)){
	$message .= "<br />The file had been uploaded successfully.";
} else {
	$message .= "<br />Upload failed : \n".$uploaddir.$new_file_name;
}
/* 1-E */
<input name="filetoupload" type="file" id="filetoupload">
?>