Additions:
class phpmysqlform
var $tablename ;
var $keys ;
var $keyvalues ;
function phpmysqlform( $tablenames)
// mydebug ( $_REQUEST) ;
// mydebug ( $_SESSION) ;
$this -> tablename = $tablenames[0] ;
$this -> fields = $fields ;
$this -> keys = fieldkeys( $this -> tablename ) ;
// first update if requested
if (isset($_REQUEST['update'])) $this -> formdataupdate() ;
foreach ($this -> keys as $name => $val)
{
if ($_REQUEST[$name]) $_SESSION[$name] = substr( $_REQUEST[$name], 0, 3 ) ;
if (!$_SESSION[$name]) $_SESSION[$name] = 1 ;
$this -> keyvalues[$name] = $_SESSION[$name] ;
}
// tables
function formactiontables()
return $_SERVER[PHP_SELF] ;
function formfieldstables()
return '<input type="submit" value="table" />';
// keys
function formactionkeys()
return $_SERVER[PHP_SELF] . "?search";
function formfieldskeys()
$s = table2form( $this -> tablename , $this -> keys , $this -> keyvalues ) ;
$s .= '<input type="submit" value="search" />' ;
return $s ;
// data
function formactiondata()
return $_SERVER[PHP_SELF] . "?update" ;
function formfieldsdata()
$s = table2form( $this -> tablename , $this -> keys , $this -> keyvalues , true ) ;
$s .= '<input type="submit" value="update" />' ;
return $s ;
// destroy
function formactiondestroy()
return $_SERVER[PHP_SELF] . "?destroy" ;
function formfieldsdestroy()
return '<input type="submit" value="destroy" />' ;
// update
function formdataupdate()
return post2update( $this -> tablename , $_POST ) ;
----
REFERRERS
{{backlinks}}
var $tablename ;
var $keys ;
var $keyvalues ;
function phpmysqlform( $tablenames)
// mydebug ( $_REQUEST) ;
// mydebug ( $_SESSION) ;
$this -> tablename = $tablenames[0] ;
$this -> fields = $fields ;
$this -> keys = fieldkeys( $this -> tablename ) ;
// first update if requested
if (isset($_REQUEST['update'])) $this -> formdataupdate() ;
foreach ($this -> keys as $name => $val)
{
if ($_REQUEST[$name]) $_SESSION[$name] = substr( $_REQUEST[$name], 0, 3 ) ;
if (!$_SESSION[$name]) $_SESSION[$name] = 1 ;
$this -> keyvalues[$name] = $_SESSION[$name] ;
}
// tables
function formactiontables()
return $_SERVER[PHP_SELF] ;
function formfieldstables()
return '<input type="submit" value="table" />';
// keys
function formactionkeys()
return $_SERVER[PHP_SELF] . "?search";
function formfieldskeys()
$s = table2form( $this -> tablename , $this -> keys , $this -> keyvalues ) ;
$s .= '<input type="submit" value="search" />' ;
return $s ;
// data
function formactiondata()
return $_SERVER[PHP_SELF] . "?update" ;
function formfieldsdata()
$s = table2form( $this -> tablename , $this -> keys , $this -> keyvalues , true ) ;
$s .= '<input type="submit" value="update" />' ;
return $s ;
// destroy
function formactiondestroy()
return $_SERVER[PHP_SELF] . "?destroy" ;
function formfieldsdestroy()
return '<input type="submit" value="destroy" />' ;
// update
function formdataupdate()
return post2update( $this -> tablename , $_POST ) ;
----
REFERRERS
{{backlinks}}
Deletions:
var $lang ;
var $ctry ;
var $actionsearch ;
var $actionupdate ;
function hub()
if (isset($_REQUEST[update])) $this->dataupdate() ;
if ($_REQUEST[lang]) $_SESSION[lang] = substr($_REQUEST[lang],0,3) ;
if (!$_SESSION[lang]) $_SESSION[lang] = 1 ;
$this->lang = $_SESSION[lang] ;
if ($_REQUEST[ctry]) $_SESSION[ctry] = substr($_REQUEST[ctry],0,3) ;
if (!$_SESSION[ctry]) $_SESSION[ctry] = 1 ;
$this->ctry = $_SESSION[ctry] ;
$this->actionsearch = $_SERVER[PHP_SELF] ;
$this->actionupdate = $_SERVER[PHP_SELF] . "?update" ;
function dataentry()
$sql = "
select country_id, language_id, tcountry_name, tcountry_desc
from translation_country
where language_id={$this->lang} and country_id={$this->ctry}
" ;
return sql2form( $sql ) ;
function dataupdate()
$sql = "
select country_id, language_id, tcountry_name, tcountry_desc
from translation_country
where 0 <> 0
" ;
post2update( 'translation_country', $sql, $_POST ) ;