PHP mysql_2_php_date Examples

Example #1

File: programdetails.php Project: shanhaiying/OES

function isallowed($progid, $studid)
{
    $sql = "select prog_start_date, prog_expire_date from es_prog where prog_id={$progid}";
    $res = mysql_query($sql);
    $prog_start_date = 0;
    $prog_exp_date = 0;
    if ($row = mysql_fetch_array($res)) {
        $prog_start_date = mysql_2_php_date($row[0]);
        $prog_exp_date = mysql_2_php_date($row[1]);
        if ($prog_start_date > time() || $prog_exp_date < time()) {
            return false;
        }
    } else {
        return false;
    }
    $sql = "select max(sp_test_start_time) from es_std_prog where sp_std_id={$studid} and sp_prog_id={$progid}";
    // and sp_status='over'";
    $res = mysql_query($sql);
    if ($row = mysql_fetch_array($res)) {
        if ($row[0] == NULL || $row[0] == "") {
            return true;
        }
        $lasttime = mysql_2_php_date($row[0]);
        if ($prog_start_date > $lasttime) {
            return true;
        }
        return false;
    }
    return true;
}

Example #2

File: programs.php Project: shanhaiying/OES

function isallowed($progid, $studid)
{
    //echo $progid.",".$studid;
    $sql = "select prog_start_date, prog_expire_date from es_prog where prog_id={$progid}";
    $res = mysql_query($sql);
    $prog_start_date = 0;
    $prog_exp_date = 0;
    if ($row = mysql_fetch_array($res)) {
        $prog_start_date = mysql_2_php_date($row[0]);
        $prog_exp_date = mysql_2_php_date($row[1]);
        if ($prog_start_date > time() || $prog_exp_date < time()) {
            //echo "gdfc";
            return false;
        }
    } else {
        //echo "gdf";
        return false;
    }
    $sql = "select max(sp_test_start_time) from es_std_prog where sp_std_id={$studid} and sp_prog_id={$progid}";
    // and sp_status='over'";
    $res = mysql_query($sql);
    if ($row = mysql_fetch_array($res)) {
        //var_dump($row);
        if ($row[0] == NULL || $row[0] == "") {
            //echo "da";
            return true;
        }
        $lasttime = mysql_2_php_date($row[0]);
        //echo $lasttime." \n<br\>";
        if ($prog_start_date > $lasttime) {
            //echo "asd";
            return true;
        }
        return false;
    }
    return true;
}