ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace: • Syntax
v5:dictionary:setactualtype

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
v5:dictionary:setactualtype [2017/05/14 00:18] – created mnewnhamv5:dictionary:setactualtype [2017/07/22 18:39] (current) – mnewnham
Line 4: Line 4:
 From ABOdb V5.21 From ABOdb V5.21
 == See Also == == See Also ==
-[[v5:dictionary:metatype|getActualType()]]\\+[[v5:dictionary:getactualtype|getActualType()]]\\
 [[v5:dictionary:metatype|metaType()]] [[v5:dictionary:metatype|metaType()]]
  
Line 16: Line 16:
 </WRAP> </WRAP>
 ===== Description ===== ===== Description =====
-The method ''setActualType()'' either modifies the database specific data type for a given [[v5:dictionary:metatype]], or provides the ability to create a new one. The returned values indicates the success of the operation. +The method ''setActualType()'' either modifies the database specific data type for a given [[v5:dictionary:metatype]], or provides the ability to create a new one. The returned value indicates the success of the operation. 
  
 If the method is used to create a new ''actualType'', then the optional bool $newType must be set. If the method is used to create a new ''actualType'', then the optional bool $newType must be set.
Line 22: Line 22:
 A connection to a data dictionary object is required, but a database connection is not. A connection to a data dictionary object is required, but a database connection is not.
 ===== Usage ==== ===== Usage ====
-In this example we want to change the behavior of the mssqlnative driver, so that instead of the default ''datetime'' type associated with the 'D' metatype, we want to use data dictionary functions to create a more portable 'date' type (available since SQL Server 2008).+In this example we want to change the behavior of the mssqlnative driver, so that instead of the default ''datetime'' type associated with the ''D'' metatype, we want to use data dictionary functions to create a more portable ''date'' type (available since SQL Server 2008).
 <code php> <code php>
 $db = newAdoConnection('mssqlnative'); $db = newAdoConnection('mssqlnative');
Line 29: Line 29:
 $dict->setActualType('D','DATE'); $dict->setActualType('D','DATE');
 </code> </code>
-In the second example, we will create a new actual types so that we can use the adodb dictionary function to create tables containing geospatial information.+In the second example, we will create a new **actual type** so that we can use the ADOdb dictionary function to create tables containing geospatial information. 
 <code php> <code php>
-$db = newAdoConnection('mysql');+$db = newAdoConnection('mysqli');
 $dict = NewDataDictionary($db); $dict = NewDataDictionary($db);
  
Line 37: Line 38:
 $dict->setActualType('P','POINT',true); $dict->setActualType('P','POINT',true);
  
-?>+/* 
 + * Add 2 new columns to table 
 +*/ 
 +$columns = 'GEODATA_COL G, POINTDATA_COL P'; 
 +$sqlarray = $dict->addColumnSql('POSITION_TABLE',$columns); 
 +  
 +print_r($sqlarray); 
 +  
 +/* 
 + * Prints 
 +Array 
 +( 
 + [0] => ALTER TABLE POSITION_TABLE ADD GEODATA_COL GEOMETRY 
 + [1] => ALTER TABLE POSITION_TABLE ADD POINTDATA_COL POINT 
 +) 
 +*/ 
 + 
 +</code>
  
v5/dictionary/setactualtype.1494713892.txt.gz · Last modified: 2017/05/14 00:18 by mnewnham