【php开源代码栏目提醒】:网学会员鉴于大家对php开源代码十分关注,论文会员在此为大家搜集整理了“EditorialsRecord.php”一文,供大家参考学习
<?php
/*********************************************************************************
* Filename: EditorialsRecord.php
* Generated with CodeCharge 1.1.19
*
PHP & Templates build 03/28/2001
*********************************************************************************/
include ("./common.php");
include ("./Header.php");
include ("./Footer.php");
session_start();
$filename = "EditorialsRecord.php";
check_security(2);
$tpl = new Template($app_path);
$tpl->load_file("EditorialsRecord.html", "main");
$tpl->load_file($header_filename, "Header");
$tpl->load_file($footer_filename, "Footer");
$tpl->set_var("FileName", $filename);
$seditorialsErr = "";
$sAction = get_param("FormAction");
$sForm = get_param("FormName");
switch ($sForm) {
case "editorials":
editorials_action($sAction);
break;
}Menu_show();
Footer_show();
editorials_show();
$tpl->parse("Header", false);
$tpl->parse("Footer", false);
$tpl->pparse("main", false);
//********************************************************************************
function editorials_action($sAction)
{
global $db;
global $tpl;
global $sForm;
global $seditorialsErr;
$sParams = "";
$sActionFileName = "EditorialsGrid.php";
$sWhere = "";
$bErr = false;
if($sAction == "cancel")
header("Location: " . $sActionFileName);
// Create WHERE statement
if($sAction == "update" || $sAction == "delete")
{
$pPKarticle_id = get_param("PK_article_id");
if( !strlen($pPKarticle_id)) return;
$sWhere = "article_id=" . tosql($pPKarticle_id, "Number");
}
// Load all form fields into variables
$fldarticle_desc = get_param("article_desc");
$fldarticle_title = get_param("article_title");
$fldeditorial_cat_id = get_param("editorial_cat_id");
$flditem_id = get_param("item_id");
// Validate fields
if($sAction == "insert" || $sAction == "update")
{
if(!strlen($fldeditorial_cat_id))
$seditorialsErr .= "The value in field Editorial Category is required.<br>";
if(!is_number($fldeditorial_cat_id))
$seditorialsErr .= "The value in field Editorial Category is incorrect.<br>";
if(!is_number($flditem_id))
$seditorialsErr .= "The value in field Item is incorrect.<br>";
if(strlen($seditorialsErr)) return;
}
$sSQL = "";
// Create SQL statement
switch(strtolower($sAction))
{
case "insert":
$sSQL = "insert into editorials (" .
"article_desc," .
"article_title," .
"editorial_cat_id," .
"item_id)" .
" values (" .
tosql($fldarticle_desc, "Text") . "," .
tosql($fldarticle_title, "Text") . "," .
tosql($fldeditorial_cat_id, "Number") . "," .
tosql($flditem_id, "Number") . ")";
break;
case "update":
$sSQL = "update editorials set " .
"article_desc=" . to
sql($fldarticle_desc, "Text") .
",article_title=" . tosql($fldarticle_title, "Text") .
",editorial_cat_id=" . tosql($fldeditorial_cat_id, "Number") .
",item_id=" . tosql($flditem_id, "Number");
$sSQL .= " where " . $sWhere;
break;
case "delete":
$sSQL = "delete from editorials where " . $sWhere;
break;
}
// Execute SQL statement
if(strlen($seditorialsErr)) return;
$db->query($sSQL);
header("Location: " . $sActionFileName);
}
function editorials_show()
{
global $db;
global $tpl;
global $sAction;
global $sForm;
global $seditorialsErr;
$sWhere = "";
$bPK = true;
$fldarticle_id = "";
$fldarticle_desc = "";
$fldarticle_title = "";
$fldeditorial_cat_id = "";
$flditem_id = "";
if($seditorialsErr == "")
{
// Load primary key and form parameters
$fldarticle_id = get_param("article_id");
$particle_id = get_param("article_id");
$tpl->set_var("editorialsError", "");
}
else
{
// Load primary key, form parameters and form fields
$fldarticle_id = strip(get_param("article_id"));
$fldarticle_desc = strip(get_param("article_desc"));
$fldarticle_title = strip(get_param("article_title"));
$fldeditorial_cat_id = strip(get_param("editorial_cat_id"));
$flditem_id = strip(get_param("item_id"));
$particle_id = get_param("PK_article_id");
$tpl->set_var("seditorialsErr", $seditorialsErr);
$tpl->parse("editorialsError", false);
}
if( !strlen($particle_id)) $bPK = false;
$sWhere .= "article_id=" . tosql($particle_id, "Number");
$tpl->set_var("PK_article_id", $particle_id);
$sSQL = "select * from editorials where " . $sWhere;
if($bPK && !($sAction == "insert" && $sForm == "editorials"