PHP format_date_sql示例

示例#1

文件： award_view.php 项目： Rhenan/intranet-1

<?php

include "../../include.php";
url_query_require();
if (isset($_GET["delActivity"])) {
    //delete activity note
    db_query("DELETE FROM funders_activity WHERE activityID = " . $_GET["delActivity"]);
    url_change("award_view.php?id=" . $_GET["id"]);
}
if (!empty($_POST)) {
    //add activity
    $date = format_date_sql($_POST["cboDateMonth"], $_POST["cboDateDay"], $_POST["cboDateYear"]);
    $isActionItem = isset($_POST["chkActionItem"]) ? 1 : 0;
    $isReport = isset($_POST["chkReport"]) ? 1 : 0;
    $isInternal = $_POST["isInternal"] == "true" ? 1 : 0;
    $isComplete = !$isActionItem ? 1 : 0;
    db_query('INSERT INTO funders_activity (
		awardID,
		activityTitle,
		activityText,
		activityDate,
		activityAssignedTo,
		isActionItem,
		isComplete,
		isReport,
		isInternalDeadline,
		activityPostedOn,
		activityPostedBy
	) VALUES (
		' . $_GET["id"] . ',
		"' . $_POST["txtTitle"] . '",

示例#2

文件： activity_edit.php 项目： Rhenan/intranet-1

<?php

include "../../include.php";
if (!isset($_GET["id"])) {
    url_change("/funders/");
}
if (!empty($_POST)) {
    $isActionItem = isset($_POST["chkActionItem"]) ? 1 : 0;
    $isReport = isset($_POST["chkReport"]) ? 1 : 0;
    $isInternal = $_POST["isInternal"] == "true" ? 1 : 0;
    db_query('UPDATE funders_activity SET 
		activityTitle      = "' . $_POST["activityTitle"] . '",
		activityDate       = ' . format_date_sql($_POST["activityDateMonth"], $_POST["activityDateDay"], $_POST["activityDateYear"]) . ',
		activityAssignedTo = ' . $_POST["activityAssignedTo"] . ',
		isComplete         = "' . $_POST["isComplete"] . '",
		isActionItem       = ' . $isActionItem . ',
		isReport           = ' . $isReport . ',
		isInternalDeadline = ' . $isInternal . ',
		activityText       = "' . $_POST["activityText"] . '"
		WHERE activityID   = ' . $_GET["id"]);
    url_change('activity_view.php?id=' . $_GET['id']);
}
echo drawTop();
$r = db_grab("SELECT \n\t\t\t\ta.activityID, \n\t\t\t\ta.funderID, \n\t\t\t\tf.name,\n\t\t\t\tw.awardTitle,\n\t\t\t\ta.awardID, \n\t\t\t\ta.activityTitle, \n\t\t\t\ta.activityText, \n\t\t\t\ta.activityDate, \n\t\t\t\ta.activityAssignedTo, \n\t\t\t\ta.isActionItem, \n\t\t\t\ta.isComplete, \n\t\t\t\ta.isReport, \n\t\t\t\ta.isInternalDeadline, \n\t\t\t\ta.activityPostedOn\n\t\t\tFROM funders_activity a\n\t\t\tINNER JOIN funders_awards w  ON a.awardID = w.awardID\n\t\t\tINNER JOIN funders f ON w.funderID = f.funderID\n\t\t\tWHERE activityID = " . $_GET["id"]);
?>

	<script language="javascript">
	<!--
	function checkInternal() {
		if (document.frmActivity.chkActionItem.checked) {
			document.all["internal"].style.visibility = "visible";

示例#3

文件： format.php 项目： joshreisner/hcfa-cc

function format_post_date($str)
{
    global $_POST;
    $month = $_POST[$str . "Month"];
    $day = $_POST[$str . "Day"];
    $year = $_POST[$str . "Year"];
    $hour = isset($_POST[$str . "Hour"]) ? $_POST[$str . "Hour"] : 0;
    $minute = isset($_POST[$str . "Minute"]) ? $_POST[$str . "Minute"] : 0;
    $second = isset($_POST[$str . "Second"]) ? $_POST[$str . "Second"] : 0;
    if (isset($_POST[$str . "AMPM"])) {
        if ($_POST[$str . "AMPM"] == "AM") {
            if ($hour == 12) {
                $hour = 0;
            }
        } else {
            if ($hour != 12) {
                $hour += 12;
            }
        }
    }
    error_debug("<b>format_post_date</b> for {$str} into mdyhms: {$month}, {$day}, {$year}, {$hour}, {$minute}, {$second}");
    return format_date_sql($month, $day, $year, $hour, $minute, $second);
}