Use of dbORM

Recommend this page to a friend!

Use of dbORM

Subject:	Use of dbORM
Summary:	Use of Functions
Messages:	3
Author:	Ron Bigus
Date:	2012-02-27 21:33:53
Update:	2012-03-22 08:47:39

1. Use of dbORM

Report abuse

Ron Bigus - 2012-02-27 21:33:53

Besimir
Could you Please supply a working example of an interface to the generated classes.

A simple display, edit, add update of a table would be greatly appreciated.

Thank you

2. Re: Use of dbORM

Report abuse

Besmir Alia - 2012-03-08 16:12:41 - In reply to message 1 from Ron Bigus

Sorry for the delay, didn't have internet for almost 2 weeks.
You can find a working example below.

file: sto_itemcategory_op.php
---------------------------------------------------------------------
<?php
require_once("start.php");
require_once("config.php");
require_once("db.php");
require_once("check.php");
include_once("cls_sto_itemcategory.php");

$cat = new cls_sto_itemcategory();
if(isset($_REQUEST["action"]))
{
$action=addslashes($_REQUEST["action"]);
$msg="";
switch($action)
{
case "new":
{
$action="insert";
break;
}
case "edit":
{
$action="update";
if(isset($_REQUEST["id"]))$id=addslashes($_REQUEST["id"]);
$cat=$cat->GetByIdItemCategory($id);

break;
}
case "insert":
{
if(isset($_REQUEST["txt_Name"]))$cat->CategoryName=addslashes($_REQUEST["txt_Name"]);
if(isset($_REQUEST["chk_IsActive"]))$cat->Is_Active=(addslashes($_REQUEST["chk_IsActive"])=="on");
if(isset($_REQUEST["chk_fp"]))$cat->fp=(addslashes($_REQUEST["chk_fp"])=="on");
if(isset($_REQUEST["txt_nr"]))$cat->nr=addslashes($_REQUEST["txt_nr"]);

$cat=$cat->Insert($cat);
$msg='<div class="ui-widget">
<div class="ui-state-highlight ui-corner-all" style="padding: 0pt 0.7em; margin-top: 20px;">
<p><strong>Success!</strong>Te dhenat u regjistruan</p></div></div>';
$action="update";
break;
}
case "update":
{
if(isset($_REQUEST["txt_ID"]))$cat->ID_Category=addslashes($_REQUEST["txt_ID"]);
if(isset($_REQUEST["txt_Name"]))$cat->CategoryName=addslashes($_REQUEST["txt_Name"]);
if(isset($_REQUEST["chk_IsActive"]))$cat->Is_Active=(addslashes($_REQUEST["chk_IsActive"])=="on");
if(isset($_REQUEST["chk_fp"]))$cat->fp=(addslashes($_REQUEST["chk_fp"])=="on");
if(isset($_REQUEST["txt_nr"]))$cat->nr=addslashes($_REQUEST["txt_nr"]);
$cat=$cat->Update($cat);
$msg='<div class="ui-widget">
<div class="ui-state-highlight ui-corner-all" style="padding: 0pt 0.7em; margin-top: 20px;">
<p><strong>Success!</strong>Te dhenat u regjistruan</p></div></div>';
$action="update";
break;
}
case "delete":
{
if(isset($_REQUEST["id"]))$id=addslashes($_REQUEST["id"]);
$cat=$cat->GetByIdItemCategory($id);
$cat->Is_Active=0;
$cat=$cat->Update($cat);
header("Location:".$_SERVER['HTTP_REFERER']);
break;
}
case "search":{
$name=addslashes($_REQUEST["txt_Name"]);
$item = new cls_sto_itemcategory();
$items=$item->Find($name);
echo "<table width='100%' border='0'>
<tr class='ui-widget-header'><th >ID</th><th >Category</th><th >Order</th><th >FrontPage</th><th >Actions</th></tr>";
foreach($items as $item)
{
echo "<tr>";
echo "<td class='ui-widget-content pad5' >";
echo $item->ID_Category;
echo "</td>";
echo "<td class='ui-widget-content pad5' >";
echo $item->CategoryName;
echo "</td>";
echo "<td class='ui-widget-content pad5' >";
echo $item->nr;
echo "</td>";
echo "<td class='ui-widget-content pad5' >";
echo $item->fp;
echo "</td>";
echo "<td class='ui-widget-content pad5' >";
echo "<a href='sto_itemcategory_op.php?action=edit&id=".$item->ID_Category."' class='ui-state-default ui-corner-all' style='padding:3px' title='Modifiko'>Edit</a>";
if($item->Is_Active){
echo "<a href='sto_itemcategory_op.php?action=delete&id=".$item->ID_Category."' class='ui-state-default ui-corner-all' style='padding:3px' title='Modifiko'>Delete</a>";
}else
{
echo "<a href='sto_itemcategory_op.php?action=activate&id=".$item->ID_Category."' class='ui-state-default ui-corner-all' style='padding:3px' title='Modifiko'>Aktivizo</a>";
}
echo "<a target='_blank' href='sto_itemcategory_op.php?action=artikujt&id=".$item->ID_Category."' class='ui-state-default ui-corner-all' style='padding:3px' title='Modifiko'>Artikujt</a>";
echo "</td>";
echo "</tr>";
}
echo "</table>";//"</table>";
die();
break;}
}
}
else
{
$action="insert";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>

<link type="text/css" href="js/start/ui.all.css" rel="Stylesheet" />

<script type="text/javascript" src="js/jquery.min.js"></script>
<script type="text/javascript" src="js/jquery.ui.all.js"></script>

<script language="javascript" type="text/javascript" >
var searchTimer = setTimeout('javascript:;',100);;
function StartSearch(f)
{
clearTimeout(searchTimer);
$.ajax().abort();
searchTimer=setTimeout(f,500);
}

function SearchCategory()
{
if($("#txt_search").val().length>=3 || $("#txt_search").val().length==0){
$("#txt_search").addClass("loading1");
$.get("sto_itemcategory_op.php",
{
txt_Name:$("#txt_search").val(),action:"search"
},
function (data){
$("#category_search_result").html(data);
$("#txt_search").removeClass("loading1");
$("#txt_search").focus();
}
);
}
return false;
}
function validateInput()
{
var is_ok=true;
if(!$("#txt_Name").val()>0){
$("#txt_Name").css({"background-color":"#EE2222","color":"white"});is_ok = false;}
return is_ok;
}
</script>
</head>

<body onLoad='SearchCategory();'>
<table width='930px'>
<tr><td><?php include_once("header.php");?></td></tr>
<tr><td>
<form action="sto_itemcategory_op.php" method="post" name="frm_supplier" id="frm_supplier" onsubmit="return validateInput();">
<input type="hidden" name="action" id="action" value="<?php echo $action;?>" />
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="right">ID:</div></td>
<td><input type="text" name="txt_ID" id="txt_ID" readonly="readonly" value="<?php echo $cat->ID_Category;?>"/></td>
</tr>
<tr>
<td><div align="right">Category Name:</div></td>
<td><input type="text" name="txt_Name" id="txt_Name" value="<?php echo $cat->CategoryName;?>" /></td>
</tr>
<tr>
<td><div align="right">Is Active:</div></td>
<td><input type="checkbox" name="chk_IsActive" id="chk_IsActive" <?php echo $cat->Is_Active?"checked":"";?> /></td>
</tr>
<tr>
<td><div align="right">Frontpage</div></td>
<td><input type="checkbox" name="chk_fp" id="chk_fp" <?php echo $cat->fp?"checked":"";?> /></td>
</tr>
<tr>
<td><div align="right">Order</div></td>
<td><input type="text" name="txt_nr" id="txt_nr" value="<?php echo $cat->nr;?>" /></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="btn_Submit" id="btn_Submit" value="Save" class="button ui-state-active ui-corner-all " />
<a href='sto_itemcategory_op.php?action=new' class="ui-state-default ui-corner-all " >Create New</a>
</td>
</tr>
</table>
</form>
<?php echo $msg;?>
</td>
</tr>
<tr>
<td>
<table width="100%">
<tr>
<td align="right">Search</td>
<td align="left">
<input type="text" name="txt_search" id="txt_search" onkeyup="StartSearch('SearchCategory()');return false;"/>
</td>
<td align="left">
<a href="#" title="Search" onClick="SearchCategory();">Search</a>
</td>
</tr>
<tr>
<td colspan="3">
<div id="category_search_result">
Results
</div>
</td>
</tr>
</table>
</td>
</tr>
<tr><td><?php include_once("footer.php");?></td></tr>
</table>
</body>
</html>

--------------------------------------------------

generated file : cls_sto_itemcategory.php
---------------------------------------------------
<?php
require_once("start.php");
require_once("config.php");
require_once("db.php");

class cls_sto_itemcategory
{
var $ID_Category;
var $CategoryName;
var $Is_Active ;
var $nr ;
var $fp ;

function cls_sto_itemcategory()
{

}
function GetByIdItemCategory($ID)
{
$itemcategory = new cls_sto_itemcategory();
$res=mysql_query("select * from sto_itemcategory where ID_Category='".$ID."'") or die (mysql_error());
if($r=mysql_fetch_array($res))
{
$itemcategory->ID_Category=$r["ID_Category"];
$itemcategory->CategoryName=$r["CategoryName"];
$itemcategory->Is_Active=$r["Is_Active"];
$itemcategory->nr=$r["nr"];
$itemcategory->fp=$r["fp"];
}
return $itemcategory;
}
function Find($name)
{
$items=array();
$res=mysql_query("select * from sto_itemcategory where CategoryName like '%".$name."%'") or die (mysql_error());
while($r=mysql_fetch_array($res))
{
$itemcategory = new cls_sto_itemcategory();
$itemcategory->ID_Category=$r["ID_Category"];
$itemcategory->CategoryName=$r["CategoryName"];
$itemcategory->Is_Active=$r["Is_Active"];
$itemcategory->nr=$r["nr"];
$itemcategory->fp=$r["fp"];
$items[$itemcategory->ID_Category]=$itemcategory;
}
return $items;
}
function GetAll()
{
$res=mysql_query("select * from sto_itemcategory where Is_Active=1 order by CategoryName") or die (mysql_error());
while($r=mysql_fetch_array($res))
{
$itemcategory = new cls_sto_itemcategory();
$itemcategory->ID_Category=$r["ID_Category"];
$itemcategory->CategoryName=$r["CategoryName"];
$itemcategory->Is_Active=$r["Is_Active"];
$itemcategory->nr=$r["nr"];
$itemcategory->fp=$r["fp"];
$items[$itemcategory->ID_Category]=$itemcategory;
}
return $items;
}

function Insert($itemcategory)
{
$res=mysql_query("INSERT INTO sto_itemcategory(CategoryName,Is_Active,nr,fp)
values(
'".$itemcategory->CategoryName."',
'".$itemcategory->Is_Active."',
'".$itemcategory->nr."',
'".$itemcategory->fp."'
)") or die(mysql_error());
$itemcategory->ID_Category=mysql_insert_id();
return $itemcategory;
}
function Update($itemcategory)
{
$res=mysql_query("UPDATE sto_itemcategory SET
CategoryName='".$itemcategory->CategoryName."',
Is_Active='".$itemcategory->Is_Active."',
nr='".$itemcategory->nr."',
fp='".$itemcategory->fp."'
WHERE ID_Category='".$itemcategory->ID_Category."'") or die(mysql_error());
return $itemcategory;
}
function Delete($ID)
{
$res=mysql_query("Update sto_itemcategory set Is_Active='0' where ID_Category='".$ID."'") or die(mysql_error());
}
}

?>

3. Re: Use of dbORM

Report abuse

Besmir Alia - 2012-03-22 08:47:39 - In reply to message 1 from Ron Bigus

HI Ron, did you find the example useful? If you have any misunderstanding, don't hesitate to contact me.
Have a nice day.