V_Contact_SQL Class Reference

Inheritance diagram for V_Contact_SQL:

Collaboration diagram for V_Contact_SQL:

Public Member Functions
	__construct ($p_cn, $p_id=-1)
	count ($p_where="", $p_array=null)
	delete ()
	exist ()
	Count the number of record with the id ,.
	insert ()
	load ()
	Load the current row return false if not found.
	seek ($cond='', $p_array=null)
	retrieve array of object thanks a condition
	update ()
Public Member Functions inherited from Data_SQL
	__construct (DatabaseCore $p_cn, $p_id=-1)
	__toString ()
	collect_objects ($cond='', $p_array=null)
	return an array of objects.
	from_array ($p_array)
	Transform an array into object.
	get ($p_string)
	get the value thanks the colum name and not the alias (name).
	get_cn ()
	get_info ()
	get_name ()
	get_object ($p_ret, $idx)
	get_pk_value ()
	get_primary_key ()
	get_type ()
	getp ($p_string)
	set the value thanks the alias name instead of the colum name
	next ($ret, $i)
	get_seek return the next object, the return of the query must have all the column of the object
	save ()
	Insert or update : if the row already exists, update otherwise insert.
	set ($p_string, $p_value)
	set the value thanks the colum name and not the alias (name)
	set_cn ($cn)
	set_name ($name)
	set_pk_value ($p_value)
	set_primary_key ($primary_key)
	set_type ($type)
	setp ($p_string, $p_value)
	set the value thanks the alias name instead of the colum name
	to_array ($prefix="")
	Turn an object (row) into an array, and the key could be prefixed with $prefix.
	to_row ($p_array)
	turns a row fetched from the DB into a SQL object in updating all his attribute
	verify ()

Additional Inherited Members
Data Fields inherited from Data_SQL
	$cn
	$date_format
	Type of the data.
	$default
	defaullt date format
	$name
	Database connection.
	$primary_key
	Array of logical and real name.
	$table
	$type
	Column name of the primary key.

Detailed Description

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

Constructor & Destructor Documentation

__construct()

V_Contact_SQL::__construct	(		$p_cn,
			$p_id = -1 )

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

    {
        $this->table="public.v_contact";
        $this->primary_key="f_id";
        $a_name=explode(",","f_id,contact_fname,contact_name,contact_qcode,contact_company,contact_mobile,contact_phone,contact_email,contact_fax,card_category");
        $this->type=[];
        foreach ($a_name as $key) {
            $this->type[trim($key)]="text";
            $this->name[trim($key)]=$key;
        }
        $this->type['f_id']="number";
        $this->type['card_category']="number";
 
        parent::__construct($p_cn, $p_id);
    }

References $p_id, name, table, and type.

Member Function Documentation

count()

V_Contact_SQL::count	(		$p_where = "",
			$p_array = null )

Reimplemented from Data_SQL.

Definition at line 79 of file v_contact_sql.class.php.

    {
        throw new Exception("not implemented");
    }

References $p_array.

delete()

V_Contact_SQL::delete

(

)

Reimplemented from Data_SQL.

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

    {
        throw new Exception("not implemented");
    }

exist()

V_Contact_SQL::exist

(

)

Count the number of record with the id ,.

Returns

integer 0 doesn't exist , 1 exists

Reimplemented from Data_SQL.

Definition at line 84 of file v_contact_sql.class.php.

    {
        throw new Exception("not implemented");
    }

insert()

V_Contact_SQL::insert

(

)

Reimplemented from Data_SQL.

Definition at line 51 of file v_contact_sql.class.php.

    {
      throw new Exception("not implemented");
    }

load()

V_Contact_SQL::load

(

)

Load the current row return false if not found.

$pk=$this->primary_key;
if ( $this->get_limit_fiche_qcode() != 0 )
{
    $sql=sprintf($this->sql," limit ".$this->get_limit_fiche_qcode());
} else
{
    $sql=sprintf($this->sql,"  ");
}
$result=$this->cn->get_array($sql. " where id=$1",array ($this->$pk));
if ($this->cn->count()==0)
{
    $this->$pk=-1;
    return false;
}
 
foreach ($result[0] as $key=> $value)
{
    $this->$key=$value;
}
return true;

Returns

bool

Reimplemented from Data_SQL.

Definition at line 66 of file v_contact_sql.class.php.

                   :bool
    {
       $array=$this->cn->get_row("select * from ".$this->table." where f_id=$1",array($this->f_id));
       if (empty ($array) ) { $this->f_id=-1;return false;}
        $this->to_row($array);
       return true;
    }

References $array, cn, table, and Data_SQL\to_row().

Here is the call graph for this function:

seek()

V_Contact_SQL::seek	(		$cond = '',
			$p_array = null )

retrieve array of object thanks a condition

Parameters

$cond	condition (where clause) (optional by default all the rows are fetched) you can use this parameter for the order or subselect
$p_array	array for the SQL stmt

See also

Database\exec_sql get_object Database\num_row

Returns

the return value of exec_sql

Reimplemented from Data_SQL.

Definition at line 74 of file v_contact_sql.class.php.

    {
        throw new Exception("not implemented");
    }

References $p_array.

update()

V_Contact_SQL::update

(

)

Reimplemented from Data_SQL.

Definition at line 61 of file v_contact_sql.class.php.

    {
        throw new Exception("not implemented");
    }

---

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

• include/database/v_contact_sql.class.php