Single_Record Class Reference

Objec to check a double insert into the database, this duplicate occurs after a refresh of the web page. More...

Collaboration diagram for Single_Record:

Public Member Functions
	__construct ($p_name, $dbconx=-1)
	Constructor $p_name will be set to $this->name, it is also the name of the tag hidden in a form.
	__toString ()
	check ($p_array=null)
	get_count ($p_array=null)
	Count how many time we have this->id into the table tool_uos.
	hidden ()
	return a string with a tag hidden and a uniq value
	save ($p_array=null)
	Try to insert into the table Single_Record.

Data Fields
	$id
	$name

Private Attributes
	$dbconx
	database connexion

Detailed Description

Objec to check a double insert into the database, this duplicate occurs after a refresh of the web page.

Definition at line 32 of file single_record.class.php.

Constructor & Destructor Documentation

__construct()

Single_Record::__construct	(		$p_name,
			$dbconx = -1 )

Constructor $p_name will be set to $this->name, it is also the name of the tag hidden in a form.

Remarks

$cn Db connexion

Parameters

$p_name	(string) name of the HIDDEN INPUT
$dbconx	Database connx , if not given; use global $cn;

Definition at line 44 of file single_record.class.php.

    {
        $this->name=$p_name;
        $this->id=0;
        if ( is_numeric($dbconx )  ) {
            global $cn;
            $this->dbconx=$cn;
        }else {
            $this->dbconx=$dbconx;
        }
        
    }

References $cn, $dbconx, and name.

Member Function Documentation

__toString()

Single_Record::__toString

(

)

Definition at line 56 of file single_record.class.php.

                         : string {
        return "Single_Record[name=" . $this->name
                . ", id=" . $this->id
                . ", dbconx=" . $this->dbconx
                . "]";
    }

References id, name, and return.

check()

Single_Record::check

(

$p_array = null

)

Definition at line 105 of file single_record.class.php.

    {
        global $cn;
        if ( $p_array == null ) $p_array=$_POST;
        $this->id=$p_array[$this->name];
        try
        {
            $count=$this->dbconx->get_value('select count(*) from tool_uos where uos_value=$1',
                    array($this->id));
            if ($count != 0 ) throw new Exception ('DUPLICATE',CODE_EXCP_DUPLICATE);
        }catch (Exception $e)
        {
            throw $e;
        }
    }

References $_POST, $cn, $count, $e, $name, $p_array, and CODE_EXCP_DUPLICATE.

get_count()

Single_Record::get_count

(

$p_array = null

)

Count how many time we have this->id into the table tool_uos.

Remarks

global $cn Database connexion

Parameters

$p_array

is the array where to find the key name, usually it is $_POST. The default value is $_POST

Returns

integer : 0 or 1

Definition at line 96 of file single_record.class.php.

    {
        global $cn;
        if ( $p_array == null ) $p_array=$_POST;
        $this->id=$p_array[$this->name];
        $count=$this->dbconx->get_value('select count(*) from tool_uos where uos_value=$1',
                array($this->id));
        return $count;
    }

References $_POST, $cn, $count, $name, and $p_array.

hidden()

Single_Record::hidden

(

)

return a string with a tag hidden and a uniq value

Parameters

$hHidden

is the name of the tag hidden

Returns

string : tag hidden

Definition at line 67 of file single_record.class.php.

    {
        $this->id=$this->dbconx->get_next_seq('uos_pk_seq');
        return HtmlInput::hidden($this->name,$this->id);
    }

References name.

save()

Single_Record::save

(

$p_array = null

)

Try to insert into the table Single_Record.

Remarks

global $cn Database connexion

Exceptions

Exception

if the value $p_id is not unique

Definition at line 77 of file single_record.class.php.

    {
        if ( $p_array == null ) $p_array=$_POST;
        $this->id=$p_array[$this->name];
        $sql="insert into tool_uos(uos_value) values ($1)";
        try {
            $this->dbconx->exec_sql($sql,array($this->id));
        } catch (Exception $e)
        {
            throw new Exception('Duplicate value');
        }
    }

References $_POST, $e, $name, $p_array, and $sql.

Field Documentation

$dbconx

Single_Record::$dbconx

private

database connexion

Definition at line 36 of file single_record.class.php.

Referenced by __construct().

$id

Single_Record::$id

Definition at line 35 of file single_record.class.php.

$name

Single_Record::$name

Definition at line 34 of file single_record.class.php.

---

The documentation for this class was generated from the following file:

• include/lib/single_record.class.php