MrTV
asked on
time in php and my sql
The code below it insert 2000-01-01 00:00:00 to DateGen colum but I put date('d-m-Y H:i:s') inline 304 how can i correct it I want to get current date time The colum type DateGen is date('d-m-Y H:i:s');
<?php
define("EW_PAGE_ID", "add", TRUE); // Page ID
define("EW_TABLE_NAME", 'deposit', TRUE);
?>
<?php
session_start(); // Initialize session data
ob_start(); // Turn on output buffering
?>
<?php include "ewcfg50.php" ?>
<?php include "ewmysql50.php" ?>
<?php include "phpfn50.php" ?>
<?php include "depositinfo.php" ?>
<?php include "userfn50.php" ?>
<?php include "staffinfo.php" ?>
<?php
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // Always modified
header("Cache-Control: private, no-store, no-cache, must-revalidate"); // HTTP/1.1
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache"); // HTTP/1.0
?>
<?php
// Open connection to the database
$conn = ew_Connect();
?>
<?php
$Security = new cAdvancedSecurity();
?>
<?php
if (!$Security->IsLoggedIn()) $Security->AutoLogin();
if (!$Security->IsLoggedIn()) {
$Security->SaveLastUrl();
Page_Terminate("login.php" );
}
?>
<?php
// Common page loading event (in userfn*.php)
Page_Loading();
?>
<?php
// Page load event, used in current page
Page_Load();
?>
<?php
$deposit->Export = @$_GET["export"]; // Get export parameter
$sExport = $deposit->Export; // Get export parameter, used in header
$sExportFile = $deposit->TableVar; // Get export file, used in header
?>
<?php
// Load key values from QueryString
$bCopy = TRUE;
if (@$_GET["id"] != "") {
$deposit->id->setQueryStri ngValue($_ GET["id"]) ;
} else {
$bCopy = FALSE;
}
// Create form object
$objForm = new cFormObj();
// Process form if post back
if (@$_POST["a_add"] <> "") {
$deposit->CurrentAction = $_POST["a_add"]; // Get form action
LoadFormValues(); // Load form values
} else { // Not post back
if ($bCopy) {
$deposit->CurrentAction = "C"; // Copy Record
} else {
$deposit->CurrentAction = "I"; // Display Blank Record
LoadDefaultValues(); // Load default values
}
}
// Perform action based on action code
switch ($deposit->CurrentAction) {
case "I": // Blank record, no action required
break;
case "C": // Copy an existing record
if (!LoadRow()) { // Load record based on key
$_SESSION[EW_SESSION_MESSA GE] = "No records found"; // No record found
Page_Terminate($deposit->g etReturnUr l()); // Clean up and return
}
break;
case "A": // ' Add new record
$deposit->SendEmail = TRUE; // Send email on add success
if (AddRow()) { // Add successful
$_SESSION[EW_SESSION_MESSA GE] = "Add New Record Successful"; // Set up success message
Page_Terminate($deposit->K eyUrl($dep osit->getR eturnUrl() )); // Clean up and return
} else {
RestoreFormValues(); // Add failed, restore form values
}
}
// Render row based on row type
$deposit->RowType = EW_ROWTYPE_ADD; // Render add type
RenderRow();
?>
<?php include "header.php" ?>
<script type="text/javascript">
<!--
var EW_PAGE_ID = "add"; // Page id
//-->
</script>
<script type="text/javascript">
<!--
function ew_ValidateForm(fobj) {
if (fobj.a_confirm && fobj.a_confirm.value == "F")
return true;
var i, elm, aelm, infix;
var rowcnt = (fobj.key_count) ? Number(fobj.key_count.valu e) : 1;
for (i=0; i<rowcnt; i++) {
infix = (fobj.key_count) ? String(i+1) : "";
elm = fobj.elements["x" + infix + "_Damout"];
if (elm && !ew_CheckNumber(elm.value) ) {
if (!ew_OnError(elm, "Incorrect floating point number - Damout"))
return false;
}
}
return true;
}
//-->
</script>
<script type="text/javascript">
<!--
// js for DHtml Editor
//-->
</script>
<script type="text/javascript">
<!--
// js for Popup Calendar
//-->
</script>
<script type="text/javascript">
<!--
var ew_MultiPagePage = "Page"; // multi-page Page Text
var ew_MultiPageOf = "of"; // multi-page Of Text
var ew_MultiPagePrev = "Prev"; // multi-page Prev Text
var ew_MultiPageNext = "Next"; // multi-page Next Text
//-->
</script>
<script language="JavaScript" type="text/javascript">
<!--
// Write your client script here, no need to add script tags.
// To include another .js script, use:
// ew_ClientScriptInclude("my _javascrip t.js");
//-->
</script>
<p><span class="phpmaker">Add to TABLE: deposit<br><br><a href="<?php echo $deposit->getReturnUrl() ?>">Go Back</a></span></p>
<?php
if (@$_SESSION[EW_SESSION_MES SAGE] <> "") { // Mesasge in Session, display
?>
<p><span class="ewmsg"><?php echo $_SESSION[EW_SESSION_MESSA GE] ?></span></p>
<?php
$_SESSION[EW_SESSION_MESSA GE] = ""; // Clear message in Session
}
?>
<form name="fdepositadd" id="fdepositadd" action="depositadd.php" method="post" onSubmit="return ew_ValidateForm(this);">
<p>
<input type="hidden" name="a_add" id="a_add" value="A">
<table class="ewTable">
<tr class="ewTableRow">
<td class="ewTableHeader">Memb erid</td>
<td<?php echo $deposit->Memberid->CellAt tributes() ?>><span id="cb_x_Memberid">
<select id="x_Memberid" name="x_Memberid" onChange="ew_UpdateOpt(thi s.form.x_N ame, ar_x_Name, this);"<?php echo $deposit->Memberid->EditAt tributes() ?>>
<!--option value="">Please Select</option-->
<?php
if (is_array($deposit->Member id->EditVa lue)) {
$arwrk = $deposit->Memberid->EditVa lue;
$rowswrk = count($arwrk);
for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) {
$selwrk = (strval($deposit->Memberid ->CurrentV alue) == strval($arwrk[$rowcntwrk][ 0])) ? " selected" : "";
?>
<option value="<?php echo ew_HtmlEncode($arwrk[$rowc ntwrk][0]) ?>"<?php echo $selwrk ?>>
<?php echo $arwrk[$rowcntwrk][1] ?>
</option>
<?php
}
}
?>
</select>
</span></td>
</tr>
<input type="hidden" name="x_Dtype" id="x_Dtype" value="<?php echo ew_HtmlEncode($deposit->Dt ype->Curre ntValue) ?>">
<tr class="ewTableAltRow">
<td class="ewTableHeader">Name </td>
<td<?php echo $deposit->Name->CellAttrib utes() ?>><span id="cb_x_Name">
<select id="x_Name" name="x_Name"<?php echo $deposit->Name->EditAttrib utes() ?>>
<!--option value="">Please Select</option-->
<?php
if (is_array($deposit->Name-> EditValue) ) {
$arwrk = $deposit->Name->EditValue;
$rowswrk = count($arwrk);
for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) {
$selwrk = (strval($deposit->Name->Cu rrentValue ) == strval($arwrk[$rowcntwrk][ 0])) ? " selected" : "";
?>
<option value="<?php echo ew_HtmlEncode($arwrk[$rowc ntwrk][0]) ?>"<?php echo $selwrk ?>>
<?php echo $arwrk[$rowcntwrk][1] ?>
</option>
<?php
}
}
?>
</select>
<?php
$jswrk = "";
if (is_array($deposit->Name-> EditValue) ) {
$arwrk = $deposit->Name->EditValue;
$arwrkcnt = count($arwrk);
for ($rowcntwrk = 1; $rowcntwrk < $arwrkcnt; $rowcntwrk++) {
$jswrk .= "ar_x_Name[" . (($rowcntwrk-1)*4) . "] = '" . str_replace("'", "\'", strval($arwrk[$rowcntwrk][ 0])) . "';"; // Value
$jswrk .= "ar_x_Name[" . (($rowcntwrk-1)*4+1) . "] = '" . str_replace("'", "\'", strval($arwrk[$rowcntwrk][ 1])) . "';"; // Display field 1
$jswrk .= "ar_x_Name[" . (($rowcntwrk-1)*4+2) . "] = '';";
$jswrk .= "ar_x_Name[" . (($rowcntwrk-1)*4+3) . "] = '" . str_replace("'", "\'", strval($arwrk[$rowcntwrk][ 2])) . "';"; // Filter field
}
}
?>
<script type="text/javascript">
<!--
var ar_x_Name = new Array();
<?php echo $jswrk ?>
//-->
</script>
</span></td>
</tr>
<tr class="ewTableRow">
<td class="ewTableHeader">Damo ut</td>
<td<?php echo $deposit->Damout->CellAttr ibutes() ?>><span id="cb_x_Damout">
<input type="text" name="x_Damout" id="x_Damout" title="" size="30" value="<?php echo $deposit->Damout->EditValu e ?>"<?php echo $deposit->Damout->EditAttr ibutes() ?>>
</span></td>
</tr>
<input type="hidden" name="x_DateGen" id="x_DateGen" value="<?php echo ew_HtmlEncode($deposit->Da teGen->Cur rentValue) ?>">
<input type="hidden" name="x_staff" id="x_staff" value="<?php echo ew_HtmlEncode($deposit->st aff->Curre ntValue) ?>">
</table>
<p>
<input type="submit" name="btnAction" id="btnAction" value=" Add ">
</form>
<script language="JavaScript">
<!--
var f = document.fdepositadd;
ew_UpdateOpt(f.x_Name, ar_x_Name, f.x_Memberid);
//-->
</script>
<script language="JavaScript" type="text/javascript">
<!--
// Write your table-specific startup script here
// document.write("page loaded");
//-->
</script>
<?php include "footer.php" ?>
<?php
// If control is passed here, simply terminate the page without redirect
Page_Terminate();
// -------------------------- ---------- ---------- ---------- ---------
// Subroutine Page_Terminate
// - called when exit page
// - clean up connection and objects
// - if url specified, redirect to url, otherwise end response
function Page_Terminate($url = "") {
global $conn;
// Page unload event, used in current page
Page_Unload();
// Global page unloaded event (in userfn*.php)
Page_Unloaded();
// Close Connection
$conn->Close();
// Go to url if specified
if ($url <> "") {
ob_end_clean();
header("Location: $url");
}
exit();
}
?>
<?php
// Load default values
function LoadDefaultValues() {
global $deposit;
$deposit->Dtype->CurrentVa lue = pic;
$deposit->DateGen->Current Value = date('d-m-Y H:i:s');
$deposit->staff->CurrentVa lue = CurrentUserName();
}
?>
<?php
// Load form values
function LoadFormValues() {
// Load from form
global $objForm, $deposit;
$deposit->Memberid->setFor mValue($ob jForm->Get Value("x_M emberid")) ;
$deposit->Dtype->setFormVa lue($objFo rm->GetVal ue("x_Dtyp e"));
$deposit->Name->setFormVal ue($objFor m->GetValu e("x_Name" ));
$deposit->Damout->setFormV alue($objF orm->GetVa lue("x_Dam out"));
$deposit->DateGen->setForm Value($obj Form->GetV alue("x_Da teGen"));
$deposit->DateGen->Current Value = ew_UnFormatDateTime($depos it->DateGe n->Current Value, 7);
$deposit->staff->setFormVa lue($objFo rm->GetVal ue("x_staf f"));
}
// Restore form values
function RestoreFormValues() {
global $deposit;
$deposit->Memberid->Curren tValue = $deposit->Memberid->FormVa lue;
$deposit->Dtype->CurrentVa lue = $deposit->Dtype->FormValue ;
$deposit->Name->CurrentVal ue = $deposit->Name->FormValue;
$deposit->Damout->CurrentV alue = $deposit->Damout->FormValu e;
$deposit->DateGen->Current Value = $deposit->DateGen->FormVal ue;
$deposit->DateGen->Current Value = ew_UnFormatDateTime($depos it->DateGe n->Current Value, 7);
$deposit->staff->CurrentVa lue = $deposit->staff->FormValue ;
}
?>
<?php
// Load row based on key values
function LoadRow() {
global $conn, $Security, $deposit;
$sFilter = $deposit->SqlKeyFilter();
if (!is_numeric($deposit->id- >CurrentVa lue)) {
return FALSE; // Invalid key, exit
}
$sFilter = str_replace("@id@", ew_AdjustSql($deposit->id- >CurrentVa lue), $sFilter); // Replace key value
// Call Row Selecting event
$deposit->Row_Selecting($s Filter);
// Load sql based on filter
$deposit->CurrentFilter = $sFilter;
$sSql = $deposit->SQL();
if ($rs = $conn->Execute($sSql)) {
if ($rs->EOF) {
$LoadRow = FALSE;
} else {
$LoadRow = TRUE;
$rs->MoveFirst();
LoadRowValues($rs); // Load row values
// Call Row Selected event
$deposit->Row_Selected($rs );
}
$rs->Close();
} else {
$LoadRow = FALSE;
}
return $LoadRow;
}
// Load row values from recordset
function LoadRowValues(&$rs) {
global $deposit;
$deposit->id->setDbValue($ rs->fields ('id'));
$deposit->Memberid->setDbV alue($rs-> fields('Me mberid'));
$deposit->Dtype->setDbValu e($rs->fie lds('Dtype '));
$deposit->Name->setDbValue ($rs->fiel ds('Name') );
$deposit->Damout->setDbVal ue($rs->fi elds('Damo ut'));
$deposit->DateGen->setDbVa lue($rs->f ields('Dat eGen'));
$deposit->Timestamp->setDb Value($rs- >fields('T imestamp') );
$deposit->staff->setDbValu e($rs->fie lds('staff '));
}
?>
<?php
// Render row values based on field settings
function RenderRow() {
global $conn, $Security, $deposit;
// Call Row Rendering event
$deposit->Row_Rendering();
// Common render codes for all row types
// Memberid
$deposit->Memberid->CellCs sStyle = "";
$deposit->Memberid->CellCs sClass = "";
// Dtype
$deposit->Dtype->CellCssSt yle = "";
$deposit->Dtype->CellCssCl ass = "";
// Name
$deposit->Name->CellCssSty le = "";
$deposit->Name->CellCssCla ss = "";
// Damout
$deposit->Damout->CellCssS tyle = "";
$deposit->Damout->CellCssC lass = "";
// DateGen
$deposit->DateGen->CellCss Style = "";
$deposit->DateGen->CellCss Class = "";
// staff
$deposit->staff->CellCssSt yle = "";
$deposit->staff->CellCssCl ass = "";
if ($deposit->RowType == EW_ROWTYPE_VIEW) { // View row
} elseif ($deposit->RowType == EW_ROWTYPE_ADD) { // Add row
// Memberid
$deposit->Memberid->EditCu stomAttrib utes = "";
$sSqlWrk = "SELECT `ID`, `ID` FROM `listname`";
$rswrk = $conn->Execute($sSqlWrk);
$arwrk = ($rswrk) ? $rswrk->GetRows() : array();
if ($rswrk) $rswrk->Close();
array_unshift($arwrk, array("", "Please Select"));
$deposit->Memberid->EditVa lue = $arwrk;
// Dtype
$deposit->Dtype->EditCusto mAttribute s = "";
$deposit->Dtype->CurrentVa lue = pic;
// Name
$deposit->Name->EditCustom Attributes = "";
$sSqlWrk = "SELECT `Name`, `Name`, `ID` FROM `listname`";
$rswrk = $conn->Execute($sSqlWrk);
$arwrk = ($rswrk) ? $rswrk->GetRows() : array();
if ($rswrk) $rswrk->Close();
array_unshift($arwrk, array("", "Please Select", ""));
$deposit->Name->EditValue = $arwrk;
// Damout
$deposit->Damout->EditCust omAttribut es = "";
$deposit->Damout->EditValu e = $deposit->Damout->CurrentV alue;
// DateGen
$deposit->DateGen->EditCus tomAttribu tes = "";
$deposit->DateGen->Current Value = ew_FormatDateTime(date('d- m-Y H:i:s'), 7);
// staff
$deposit->staff->EditCusto mAttribute s = "";
$deposit->staff->CurrentVa lue = CurrentUserName();
} elseif ($deposit->RowType == EW_ROWTYPE_EDIT) { // Edit row
} elseif ($deposit->RowType == EW_ROWTYPE_SEARCH) { // Search row
}
// Call Row Rendered event
$deposit->Row_Rendered();
}
?>
<?php
// Add record
function AddRow() {
global $conn, $Security, $deposit;
// Check for duplicate key
$bCheckKey = TRUE;
$sFilter = $deposit->SqlKeyFilter();
if (trim(strval($deposit->id- >CurrentVa lue)) == "") {
$bCheckKey = FALSE;
} else {
$sFilter = str_replace("@id@", ew_AdjustSql($deposit->id- >CurrentVa lue), $sFilter); // Replace key value
}
if (!is_numeric($deposit->id- >CurrentVa lue)) {
$bCheckKey = FALSE;
}
if ($bCheckKey) {
$rsChk = $deposit->LoadRs($sFilter) ;
if ($rsChk && !$rsChk->EOF) {
$_SESSION[EW_SESSION_MESSA GE] = "Duplicate value for primary key";
$rsChk->Close();
return FALSE;
}
}
$rsnew = array();
// Field Memberid
$deposit->Memberid->SetDbV alueDef($d eposit->Me mberid->Cu rrentValue , NULL);
$rsnew['Memberid'] =& $deposit->Memberid->DbValu e;
// Field Dtype
$deposit->Dtype->SetDbValu eDef($depo sit->Dtype ->CurrentV alue, NULL);
$rsnew['Dtype'] =& $deposit->Dtype->DbValue;
// Field Name
$deposit->Name->SetDbValue Def($depos it->Name-> CurrentVal ue, NULL);
$rsnew['Name'] =& $deposit->Name->DbValue;
// Field Damout
$deposit->Damout->SetDbVal ueDef($dep osit->Damo ut->Curren tValue, NULL);
$rsnew['Damout'] =& $deposit->Damout->DbValue;
// Field DateGen
$deposit->DateGen->SetDbVa lueDef(ew_ UnFormatDa teTime($de posit->Dat eGen->Curr entValue, 7), NULL);
$rsnew['DateGen'] =& $deposit->DateGen->DbValue ;
// Field staff
$deposit->staff->SetDbValu eDef($depo sit->staff ->CurrentV alue, NULL);
$rsnew['staff'] =& $deposit->staff->DbValue;
// Call Row Inserting event
$bInsertRow = $deposit->Row_Inserting($r snew);
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $conn->Execute($deposit->I nsertSQL($ rsnew));
$conn->raiseErrorFn = '';
} else {
if ($deposit->CancelMessage <> "") {
$_SESSION[EW_SESSION_MESSA GE] = $deposit->CancelMessage;
$deposit->CancelMessage = "";
} else {
$_SESSION[EW_SESSION_MESSA GE] = "Insert cancelled";
}
$AddRow = FALSE;
}
if ($AddRow) {
$deposit->id->setDbValue($ conn->Inse rt_ID());
$rsnew['id'] =& $deposit->id->DbValue;
// Call Row Inserted event
$deposit->Row_Inserted($rs new);
}
return $AddRow;
}
?>
<?php
// Page Load event
function Page_Load() {
//echo "Page Load";
}
// Page Unload event
function Page_Unload() {
//echo "Page Unload";
}
?>
<?php
define("EW_PAGE_ID", "add", TRUE); // Page ID
define("EW_TABLE_NAME", 'deposit', TRUE);
?>
<?php
session_start(); // Initialize session data
ob_start(); // Turn on output buffering
?>
<?php include "ewcfg50.php" ?>
<?php include "ewmysql50.php" ?>
<?php include "phpfn50.php" ?>
<?php include "depositinfo.php" ?>
<?php include "userfn50.php" ?>
<?php include "staffinfo.php" ?>
<?php
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // Always modified
header("Cache-Control: private, no-store, no-cache, must-revalidate"); // HTTP/1.1
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache"); // HTTP/1.0
?>
<?php
// Open connection to the database
$conn = ew_Connect();
?>
<?php
$Security = new cAdvancedSecurity();
?>
<?php
if (!$Security->IsLoggedIn())
if (!$Security->IsLoggedIn())
$Security->SaveLastUrl();
Page_Terminate("login.php"
}
?>
<?php
// Common page loading event (in userfn*.php)
Page_Loading();
?>
<?php
// Page load event, used in current page
Page_Load();
?>
<?php
$deposit->Export = @$_GET["export"]; // Get export parameter
$sExport = $deposit->Export; // Get export parameter, used in header
$sExportFile = $deposit->TableVar; // Get export file, used in header
?>
<?php
// Load key values from QueryString
$bCopy = TRUE;
if (@$_GET["id"] != "") {
$deposit->id->setQueryStri
} else {
$bCopy = FALSE;
}
// Create form object
$objForm = new cFormObj();
// Process form if post back
if (@$_POST["a_add"] <> "") {
$deposit->CurrentAction = $_POST["a_add"]; // Get form action
LoadFormValues(); // Load form values
} else { // Not post back
if ($bCopy) {
$deposit->CurrentAction = "C"; // Copy Record
} else {
$deposit->CurrentAction = "I"; // Display Blank Record
LoadDefaultValues(); // Load default values
}
}
// Perform action based on action code
switch ($deposit->CurrentAction) {
case "I": // Blank record, no action required
break;
case "C": // Copy an existing record
if (!LoadRow()) { // Load record based on key
$_SESSION[EW_SESSION_MESSA
Page_Terminate($deposit->g
}
break;
case "A": // ' Add new record
$deposit->SendEmail = TRUE; // Send email on add success
if (AddRow()) { // Add successful
$_SESSION[EW_SESSION_MESSA
Page_Terminate($deposit->K
} else {
RestoreFormValues(); // Add failed, restore form values
}
}
// Render row based on row type
$deposit->RowType = EW_ROWTYPE_ADD; // Render add type
RenderRow();
?>
<?php include "header.php" ?>
<script type="text/javascript">
<!--
var EW_PAGE_ID = "add"; // Page id
//-->
</script>
<script type="text/javascript">
<!--
function ew_ValidateForm(fobj) {
if (fobj.a_confirm && fobj.a_confirm.value == "F")
return true;
var i, elm, aelm, infix;
var rowcnt = (fobj.key_count) ? Number(fobj.key_count.valu
for (i=0; i<rowcnt; i++) {
infix = (fobj.key_count) ? String(i+1) : "";
elm = fobj.elements["x" + infix + "_Damout"];
if (elm && !ew_CheckNumber(elm.value)
if (!ew_OnError(elm, "Incorrect floating point number - Damout"))
return false;
}
}
return true;
}
//-->
</script>
<script type="text/javascript">
<!--
// js for DHtml Editor
//-->
</script>
<script type="text/javascript">
<!--
// js for Popup Calendar
//-->
</script>
<script type="text/javascript">
<!--
var ew_MultiPagePage = "Page"; // multi-page Page Text
var ew_MultiPageOf = "of"; // multi-page Of Text
var ew_MultiPagePrev = "Prev"; // multi-page Prev Text
var ew_MultiPageNext = "Next"; // multi-page Next Text
//-->
</script>
<script language="JavaScript" type="text/javascript">
<!--
// Write your client script here, no need to add script tags.
// To include another .js script, use:
// ew_ClientScriptInclude("my
//-->
</script>
<p><span class="phpmaker">Add to TABLE: deposit<br><br><a href="<?php echo $deposit->getReturnUrl() ?>">Go Back</a></span></p>
<?php
if (@$_SESSION[EW_SESSION_MES
?>
<p><span class="ewmsg"><?php echo $_SESSION[EW_SESSION_MESSA
<?php
$_SESSION[EW_SESSION_MESSA
}
?>
<form name="fdepositadd" id="fdepositadd" action="depositadd.php" method="post" onSubmit="return ew_ValidateForm(this);">
<p>
<input type="hidden" name="a_add" id="a_add" value="A">
<table class="ewTable">
<tr class="ewTableRow">
<td class="ewTableHeader">Memb
<td<?php echo $deposit->Memberid->CellAt
<select id="x_Memberid" name="x_Memberid" onChange="ew_UpdateOpt(thi
<!--option value="">Please Select</option-->
<?php
if (is_array($deposit->Member
$arwrk = $deposit->Memberid->EditVa
$rowswrk = count($arwrk);
for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) {
$selwrk = (strval($deposit->Memberid
?>
<option value="<?php echo ew_HtmlEncode($arwrk[$rowc
<?php echo $arwrk[$rowcntwrk][1] ?>
</option>
<?php
}
}
?>
</select>
</span></td>
</tr>
<input type="hidden" name="x_Dtype" id="x_Dtype" value="<?php echo ew_HtmlEncode($deposit->Dt
<tr class="ewTableAltRow">
<td class="ewTableHeader">Name
<td<?php echo $deposit->Name->CellAttrib
<select id="x_Name" name="x_Name"<?php echo $deposit->Name->EditAttrib
<!--option value="">Please Select</option-->
<?php
if (is_array($deposit->Name->
$arwrk = $deposit->Name->EditValue;
$rowswrk = count($arwrk);
for ($rowcntwrk = 0; $rowcntwrk < $rowswrk; $rowcntwrk++) {
$selwrk = (strval($deposit->Name->Cu
?>
<option value="<?php echo ew_HtmlEncode($arwrk[$rowc
<?php echo $arwrk[$rowcntwrk][1] ?>
</option>
<?php
}
}
?>
</select>
<?php
$jswrk = "";
if (is_array($deposit->Name->
$arwrk = $deposit->Name->EditValue;
$arwrkcnt = count($arwrk);
for ($rowcntwrk = 1; $rowcntwrk < $arwrkcnt; $rowcntwrk++) {
$jswrk .= "ar_x_Name[" . (($rowcntwrk-1)*4) . "] = '" . str_replace("'", "\'", strval($arwrk[$rowcntwrk][
$jswrk .= "ar_x_Name[" . (($rowcntwrk-1)*4+1) . "] = '" . str_replace("'", "\'", strval($arwrk[$rowcntwrk][
$jswrk .= "ar_x_Name[" . (($rowcntwrk-1)*4+2) . "] = '';";
$jswrk .= "ar_x_Name[" . (($rowcntwrk-1)*4+3) . "] = '" . str_replace("'", "\'", strval($arwrk[$rowcntwrk][
}
}
?>
<script type="text/javascript">
<!--
var ar_x_Name = new Array();
<?php echo $jswrk ?>
//-->
</script>
</span></td>
</tr>
<tr class="ewTableRow">
<td class="ewTableHeader">Damo
<td<?php echo $deposit->Damout->CellAttr
<input type="text" name="x_Damout" id="x_Damout" title="" size="30" value="<?php echo $deposit->Damout->EditValu
</span></td>
</tr>
<input type="hidden" name="x_DateGen" id="x_DateGen" value="<?php echo ew_HtmlEncode($deposit->Da
<input type="hidden" name="x_staff" id="x_staff" value="<?php echo ew_HtmlEncode($deposit->st
</table>
<p>
<input type="submit" name="btnAction" id="btnAction" value=" Add ">
</form>
<script language="JavaScript">
<!--
var f = document.fdepositadd;
ew_UpdateOpt(f.x_Name, ar_x_Name, f.x_Memberid);
//-->
</script>
<script language="JavaScript" type="text/javascript">
<!--
// Write your table-specific startup script here
// document.write("page loaded");
//-->
</script>
<?php include "footer.php" ?>
<?php
// If control is passed here, simply terminate the page without redirect
Page_Terminate();
// --------------------------
// Subroutine Page_Terminate
// - called when exit page
// - clean up connection and objects
// - if url specified, redirect to url, otherwise end response
function Page_Terminate($url = "") {
global $conn;
// Page unload event, used in current page
Page_Unload();
// Global page unloaded event (in userfn*.php)
Page_Unloaded();
// Close Connection
$conn->Close();
// Go to url if specified
if ($url <> "") {
ob_end_clean();
header("Location: $url");
}
exit();
}
?>
<?php
// Load default values
function LoadDefaultValues() {
global $deposit;
$deposit->Dtype->CurrentVa
$deposit->DateGen->Current
$deposit->staff->CurrentVa
}
?>
<?php
// Load form values
function LoadFormValues() {
// Load from form
global $objForm, $deposit;
$deposit->Memberid->setFor
$deposit->Dtype->setFormVa
$deposit->Name->setFormVal
$deposit->Damout->setFormV
$deposit->DateGen->setForm
$deposit->DateGen->Current
$deposit->staff->setFormVa
}
// Restore form values
function RestoreFormValues() {
global $deposit;
$deposit->Memberid->Curren
$deposit->Dtype->CurrentVa
$deposit->Name->CurrentVal
$deposit->Damout->CurrentV
$deposit->DateGen->Current
$deposit->DateGen->Current
$deposit->staff->CurrentVa
}
?>
<?php
// Load row based on key values
function LoadRow() {
global $conn, $Security, $deposit;
$sFilter = $deposit->SqlKeyFilter();
if (!is_numeric($deposit->id-
return FALSE; // Invalid key, exit
}
$sFilter = str_replace("@id@", ew_AdjustSql($deposit->id-
// Call Row Selecting event
$deposit->Row_Selecting($s
// Load sql based on filter
$deposit->CurrentFilter = $sFilter;
$sSql = $deposit->SQL();
if ($rs = $conn->Execute($sSql)) {
if ($rs->EOF) {
$LoadRow = FALSE;
} else {
$LoadRow = TRUE;
$rs->MoveFirst();
LoadRowValues($rs); // Load row values
// Call Row Selected event
$deposit->Row_Selected($rs
}
$rs->Close();
} else {
$LoadRow = FALSE;
}
return $LoadRow;
}
// Load row values from recordset
function LoadRowValues(&$rs) {
global $deposit;
$deposit->id->setDbValue($
$deposit->Memberid->setDbV
$deposit->Dtype->setDbValu
$deposit->Name->setDbValue
$deposit->Damout->setDbVal
$deposit->DateGen->setDbVa
$deposit->Timestamp->setDb
$deposit->staff->setDbValu
}
?>
<?php
// Render row values based on field settings
function RenderRow() {
global $conn, $Security, $deposit;
// Call Row Rendering event
$deposit->Row_Rendering();
// Common render codes for all row types
// Memberid
$deposit->Memberid->CellCs
$deposit->Memberid->CellCs
// Dtype
$deposit->Dtype->CellCssSt
$deposit->Dtype->CellCssCl
// Name
$deposit->Name->CellCssSty
$deposit->Name->CellCssCla
// Damout
$deposit->Damout->CellCssS
$deposit->Damout->CellCssC
// DateGen
$deposit->DateGen->CellCss
$deposit->DateGen->CellCss
// staff
$deposit->staff->CellCssSt
$deposit->staff->CellCssCl
if ($deposit->RowType == EW_ROWTYPE_VIEW) { // View row
} elseif ($deposit->RowType == EW_ROWTYPE_ADD) { // Add row
// Memberid
$deposit->Memberid->EditCu
$sSqlWrk = "SELECT `ID`, `ID` FROM `listname`";
$rswrk = $conn->Execute($sSqlWrk);
$arwrk = ($rswrk) ? $rswrk->GetRows() : array();
if ($rswrk) $rswrk->Close();
array_unshift($arwrk, array("", "Please Select"));
$deposit->Memberid->EditVa
// Dtype
$deposit->Dtype->EditCusto
$deposit->Dtype->CurrentVa
// Name
$deposit->Name->EditCustom
$sSqlWrk = "SELECT `Name`, `Name`, `ID` FROM `listname`";
$rswrk = $conn->Execute($sSqlWrk);
$arwrk = ($rswrk) ? $rswrk->GetRows() : array();
if ($rswrk) $rswrk->Close();
array_unshift($arwrk, array("", "Please Select", ""));
$deposit->Name->EditValue = $arwrk;
// Damout
$deposit->Damout->EditCust
$deposit->Damout->EditValu
// DateGen
$deposit->DateGen->EditCus
$deposit->DateGen->Current
// staff
$deposit->staff->EditCusto
$deposit->staff->CurrentVa
} elseif ($deposit->RowType == EW_ROWTYPE_EDIT) { // Edit row
} elseif ($deposit->RowType == EW_ROWTYPE_SEARCH) { // Search row
}
// Call Row Rendered event
$deposit->Row_Rendered();
}
?>
<?php
// Add record
function AddRow() {
global $conn, $Security, $deposit;
// Check for duplicate key
$bCheckKey = TRUE;
$sFilter = $deposit->SqlKeyFilter();
if (trim(strval($deposit->id-
$bCheckKey = FALSE;
} else {
$sFilter = str_replace("@id@", ew_AdjustSql($deposit->id-
}
if (!is_numeric($deposit->id-
$bCheckKey = FALSE;
}
if ($bCheckKey) {
$rsChk = $deposit->LoadRs($sFilter)
if ($rsChk && !$rsChk->EOF) {
$_SESSION[EW_SESSION_MESSA
$rsChk->Close();
return FALSE;
}
}
$rsnew = array();
// Field Memberid
$deposit->Memberid->SetDbV
$rsnew['Memberid'] =& $deposit->Memberid->DbValu
// Field Dtype
$deposit->Dtype->SetDbValu
$rsnew['Dtype'] =& $deposit->Dtype->DbValue;
// Field Name
$deposit->Name->SetDbValue
$rsnew['Name'] =& $deposit->Name->DbValue;
// Field Damout
$deposit->Damout->SetDbVal
$rsnew['Damout'] =& $deposit->Damout->DbValue;
// Field DateGen
$deposit->DateGen->SetDbVa
$rsnew['DateGen'] =& $deposit->DateGen->DbValue
// Field staff
$deposit->staff->SetDbValu
$rsnew['staff'] =& $deposit->staff->DbValue;
// Call Row Inserting event
$bInsertRow = $deposit->Row_Inserting($r
if ($bInsertRow) {
$conn->raiseErrorFn = 'ew_ErrorFn';
$AddRow = $conn->Execute($deposit->I
$conn->raiseErrorFn = '';
} else {
if ($deposit->CancelMessage <> "") {
$_SESSION[EW_SESSION_MESSA
$deposit->CancelMessage = "";
} else {
$_SESSION[EW_SESSION_MESSA
}
$AddRow = FALSE;
}
if ($AddRow) {
$deposit->id->setDbValue($
$rsnew['id'] =& $deposit->id->DbValue;
// Call Row Inserted event
$deposit->Row_Inserted($rs
}
return $AddRow;
}
?>
<?php
// Page Load event
function Page_Load() {
//echo "Page Load";
}
// Page Unload event
function Page_Unload() {
//echo "Page Unload";
}
?>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
it insert work 50 percent it insert 2007-12-03 00:00:00 but the time is still not in sert please help
ASKER
$deposit->DateGen->Current Value = ew_FormatDateTime(date('Y- m-d H:i:s'), 7);
may be this line cause problem inline 449 what is 7 ido ineed to change it
may be this line cause problem inline 449 what is 7 ido ineed to change it
echo date('Y-m-d H:i:s');
what do you see? Now try and copy and paste this into your one of your entries in phpmyadmin, does it insert properly?
what do you see? Now try and copy and paste this into your one of your entries in phpmyadmin, does it insert properly?
just as a test try without the function:
$deposit->DateGen->Current Value = date('Y-m-d H:i:s');
$deposit->DateGen->Current
ASKER
2007-12-03 02:11:49 i can add with phpmyadmin
did this work?
$deposit->DateGen->Current Value = date('Y-m-d H:i:s');
$deposit->DateGen->Current
ASKER
it work 100 percent but when the pro gram list it show black but when i look with php admin it work
ASKER
Thank you very much for help
glad to help :)
try:
date('Y-m-Y H:i:s');