how to remove no selected file in javascript

<div><input type='file' title="Choose a video please" id="aa" onchange="pressed()"><label id="fileLabel">Select New file</label></div>

<style>
input[type=file]{
    width:80px;
    color:transparent;
}

</style>


<script>
window.pressed = function(){
    var a = document.getElementById('aa');
    if(a.value == "")
    {
        fileLabel.innerHTML = "Select New file";
    }
    else
    {
        var theSplit = a.value.split('\\');
        fileLabel.innerHTML = theSplit[theSplit.length-1];
    }
};
</script>

get last 30 days data in php

select * from `tablename` where `yourdatefield` >= 

 DATE_SUB(CURDATE(), INTERVAL 30 DAY)

set timezone and get timezone in php

 1.) Set timezone :-
<?php echo date_default_timezone_set("Asia/Kolkata"); ?>

 2.) Get timezone :-
<?php echo date_default_timezone_get(); ?>

export sql table to csv format in php

<?php 
//First create db connection.
$output = "";
$sql = mysql_query("select col1,col2,col3 from table_name where 1");
$columns_total = mysql_num_fields($sql);
for ($i = 0; $i < $columns_total; $i++) {
$heading = mysql_field_name($sql, $i);
$output .= '"'.$heading.'",';
}
$output .="\r\n";
while ($row = mysql_fetch_array($sql)) {
for ($i = 0; $i < $columns_total; $i++) {
$output .='"'.$row["$i"].'",';
}
$output .="\n";
}
$filename = "Vendor-data-export.csv";
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename='.$filename);

echo $output;
?>

Create custom home page layout in magento

1.)  First go to app/design/frontend/rwd/default/layout/page.xml and following  code after one_page colamn structure

<page_home translate="label">
        <label>All home Layout Pages</label>
        <reference name="root">
            <action method="setTemplate"><template>page/home.phtml</template></action>
            <!-- Mark root page block that template is applied -->
            <action method="setIsHandle"><applied>1</applied></action>
            <action method="setLayoutCode"><name>home</name></action>
        </reference>
    </page_home>

2.) second open app/code/core/Mage/Page/etc/config.xml file and set following code after one_page colamn

<home module="page" translate="label">
                    <label>Home page</label>
                    <template>page/home.phtml</template>
                    <layout_handle>page_home</layout_handle>
                    <is_default>1</is_default>
                </home>

3.) And last go to admin->cms->pages in content tab select your home page.