Driver specifico per la connessione a un database SQL Server attraverso la libreria PDO. More...

Inheritance diagram for pdo_sqlsrv:

Collaboration diagram for pdo_sqlsrv:

Public Member Functions
	multiActionQuery ($file_content)

	autoIncValue ($table)

	tableexists ($table)

	limit ($range, $offset=0)

	distinct ($fields, $options=array())

	concat ($sequence)

	dumpDatabase ($file)

	changeFieldType ($data_type, $value)

	restore ($table, $filename, $options=array())

	conformFieldType ($meta)

Public Member Functions inherited from pdo
	__construct ($params)
	Costruttore. More...

	getNumberRows ()
	Ritorna il numero di righe risultanti da una select query. More...

	getNumberCols ()
	Ritorna il numero di colonne richiamate in una istruzione SELECT. More...

	getAffectedRows ()
	Ritorna il numero di righe interessate da una istruzione INSERT, UPDATE o DELETE. More...

	getInfoQuery ()

	openConnection ($opt=array())

	closeConnection ()

	begin ()

	rollback ()

	commit ()

	multiActionQuery ($queries)

	freeresult ($result=null)

	getLastId ($table)

	autoIncValue ($table)

	getFieldFromId ($table, $field, $field_id, $id, $options=array())

	tableexists ($table)

	fieldInformations ($table)

	conformFieldType ($meta)

	limit ($range, $offset)

	distinct ($fields, $options=array())

	concat ($sequence)

	dumpDatabase ($file)

	changeFieldType ($data_type, $value)

	getNumRecords ($table, $where=null, $field='id', $options=array())

	query ($fields, $tables, $where=null, $options=array())

	execCustomQuery ($query, $options=array())

	select ($fields, $tables, $where=null, $options=array())

	insert ($fields, $table, $debug=false)

	update ($fields, $table, $where, $debug=false)

	delete ($table, $where, $debug=false)

	drop ($table)

	columnHasValue ($table, $field, $value, $options=array())

	join ($table, $condition, $option)

	union ($queries, $options=array())

	restore ($table, $filename, $options=array())

	dump ($table, $path_to_file, $options=array())

	escapeString ($string)

Public Member Functions inherited from DbManager
	openConnection ()
	Apre una connessione al database. More...

Protected Member Functions
	setDSN ()

	setAttribute ()

	checkRowsFromSelect ($result)

	buildQuery ($options=array())

	setFieldName ($field)

	setFieldValue ($value)

	arrayFieldsToString ($a_fields)

	SQLForFieldInformations ($table)

	SQLForDump ($table, $path_to_file, $delimiter, $enclosed, $where)

Protected Member Functions inherited from pdo
	checkRowsFromSelect ($result)
	Verifica se una istruzione SELECT ha avuto esito postivo. More...

	queryResults ($query, $options=array())
	Esegue la query e ne calcola i tempi di esecuzione. More...

	fetch ($results=null, $options=array())
	Prende e rende fruibili i risultati della query. More...

	setDSN ()
	Imposta la stringa di connessione al database. More...

	setAttribute ()
	Attributi da associare alla connessione. More...

	setCharacterSet ()
	Imposta il character set del database. More...

	buildQuery ($options=array())
	Costruisce la query (personalizzata per ogni driver) More...

	setFieldName ($field)
	Imposta il nome del campo in una query. More...

	setFieldValue ($value)
	Imposta il valore del campo in una query. More...

	arrayFieldsToString ($a_fields)
	Formatta l'elenco dei campi in una istruzione insert. More...

	SQLForFieldInformations ($table)
	SQL code specifico del driver per il metodo fieldInformations() More...

	SQLForDump ($table, $path_to_file, $delimiter, $enclosed, $where)
	SQL code specifico del driver per il metodo dump() More...

Private Member Functions
	listTables ()

	setQueryUsingPaging ($fields, $tables, $where=null, $options=array())
	Imposta una query con paginazione. More...

Additional Inherited Members
Data Fields inherited from pdo
	$_db_host

	$_db_name

	$_db_user

	$_db_password

	$_db_charset

Static Protected Member Functions inherited from pdo
static	getCharset ()
	Elenco dei character set accettati. More...

Protected Attributes inherited from pdo
	$_dbms

	$_numberrows

	$_affected

	$_numbercols

	$_connection

	$_pdo

	$_result

	$_show_stats

	$_info_queries

	$_cnt

	$_time_queries

	$_query_cache

	$_query_cache_time

	$_cache

Detailed Description

Driver specifico per la connessione a un database SQL Server attraverso la libreria PDO.

Copyright: 2015 Otto srl (http://www.opensource.org/licenses/mit-license.php) The MIT License

Author: marco guidotti guido.nosp@m.ttim.nosp@m.@gmai.nosp@m.l.co.nosp@m.m; abidibo abidi.nosp@m.bo@g.nosp@m.mail..nosp@m.com

Member Function Documentation

arrayFieldsToString ( $a_fields )

protected

See also: Gino.Plugin.pdo::arrayFieldsToString()

autoIncValue ( $table )

See also: Gino.Plugin.pdo::autoIncValue()

Implements DbManager.

buildQuery ( $options = array() )

protected

See also: Gino.Plugin.pdo::buildQuery()

changeFieldType	(	$data_type,
		$value
	)

See also: Gino.Plugin.pdo::changeFieldType()

Implements DbManager.

checkRowsFromSelect ( $result )

protected

See also: ::checkRowsFromSelect()

concat ( $sequence )

See also: Gino.Plugin.pdo::concat()

Implements DbManager.

conformFieldType ( $meta )

See also: Gino.Plugin.pdo::conformFieldType()

Implements DbManager.

distinct	(	$fields,
		$options = `array()`
	)

See also: Gino.Plugin.pdo::distinct()

Implements DbManager.

dumpDatabase ( $file )

See also: Gino.Plugin.pdo::dumpDatabase(); listTables()

Implements DbManager.

limit	(	$range,
		$offset = `0`
	)

See also: Gino.Plugin.pdo::limit()

Examples

//Returning the first 100 rows from a table called employee:
select top 100 * from employee
//Returning the top 20% of rows from a table called employee:
select top 20 percent * from employee 

Implements DbManager.

listTables ( )

private

multiActionQuery ( $file_content )