public dropForeignKey (mixed $tableName, mixed $schemaName, mixed $referenceName) Generates SQL to delete a foreign key from a table

abstract public get (mixed $keyName, [mixed $lifetime]) ...

public getDefaultValue () Returns the default value to make the RBDM use the default value declared in the table definition //Inserting a new robot with a valid default value for the column 'year' $success = $connection->insert( "robots", array("Astro Boy", $connection->getDefaultValue()), array("name", "year") );

integer TYPE_INTEGER

public static string colorField (array $parameters) Builds a HTML input[type=”color”] tag

public useExplicitIdValue () Check whether the database system requires an explicit value for identity columns

public fetchOne (mixed $sqlQuery, [mixed $fetchMode], [mixed $bindParams], [mixed $bindTypes]) Returns the first row in a SQL query result //Getting first robot $robot = $connection->fetchOne("SELECT * FROM robots"); print_r($robot); //Getting first robot with associative indexes only $robot = $connection->fetchOne("SELECT * FROM robots", Phalcon\Db::FETCH_ASSOC); print_r($robot);

public getTempName () Returns the temporary name of the uploaded file

public registerDirs (array $directories, [mixed $merge]) Register directories in which “not found” classes could be found

public escapeString (mixed $str) Escapes a value to avoid SQL injections according to the active charset in the connection $escapedStr = $connection->escapeString('some dangerous value');