pdf to image converter using c# : Adding a signature to a pdf form SDK application API wpf windows asp.net sharepoint 201212-ug-php-oracle-188476034-part401

APPENDIX C
OCI8 F
UNCTION
N
AMES
IN
PHP 4 
AND
PHP 5
In PHP 5 several extensions including OCI8 underwent function name standardization. PHP 4 
functions like OCILogin() became oci_connect(), the function OCIParse() became 
oci_parse(), and so on. Although deprecated, the old OCI8 names still exist as aliases. PHP 4 
scripts do not necessarily need to be changed when migrating. PECL OCI8 releases from 1.1 
onwards have the new function names.
Note: The OCI8 1.4 extension builds and runs with PHP 4 and PHP 5. If you are still using PHP 
4 and cannot upgrade to PHP 5, you should replace the OCI8 code with the new version to get 
improved stability and performance optimizations. Steps to install from PECL are given in this 
book.
Function names in PHP are case insensitive. There seems to be a common acceptance for PHP 
4 names to be written with a capitalized prefix but the PHP 5 names to be all lowercase.
Table 21 shows the PHP 4 OCI8 functions and gives their PHP 5 replacements. Note several 
functions such as ocifreedesc() and ocilobclose() were only usable as methods in PHP 4.
Table 21: Relationship between OCI8's PHP 4 and PHP 5 function names.
Operation
Action
PHP 4 Name
PHP 5 Name
Connection
Open 
connection
ocilogon()
oci_connect()
Open new 
connection
ocinlogon()
oci_new_connect()
Persistent 
connection
ociplogon()
oci_pconnect() 
(and new php.ini parameters)
Close 
connection
ocilogoff()
oci_close()
Cursor
Open cursor
ocinewcursor()
oci_new_cursor()
Close 
cursor
ocifreecursor()
ocifreestatement()
oci_free_statement()
Parsing
Parse 
statement
ociparse()
oci_parse()
Binding
Bind 
variable
ocibindbyname()
oci_bind_by_name()
327
Adding a signature to a pdf form - C# PDF Field Edit Library: insert, delete, update pdf form field in C#.net, ASP.NET, MVC, Ajax, WPF
Online C# Tutorial to Insert, Delete and Update Fields in PDF Document
pdf add signature field; add forms to pdf
Adding a signature to a pdf form - VB.NET PDF Field Edit library: insert, delete, update pdf form field in vb.net, ASP.NET, MVC, Ajax, WPF
How to Insert, Delete and Update Fields in PDF Document with VB.NET Demo Code
pdf form save; change font size in pdf fillable form
OCI8 Function Names in PHP 4 and PHP 5
Operation
Action
PHP 4 Name
PHP 5 Name
Bind array
Not available
oci_bind_array_by_name()
Defining
Define 
output 
variables
ocidefinebyname()
oci_define_by_name()
Execution
Execute 
statement
ociexecute()
oci_execute()
Fetching
Fetch row
ocifetch()
oci_fetch()
Fetch row
ocifetchinto()
oci_fetch_array()
oci_fetch_row()
oci_fetch_assoc()
oci_fetch_object()
Fetch all 
rows
ocifetchstatement()
oci_fetch_all()
Fetch 
column
ociresult()
oci_result()
Is the 
column 
NULL?
ocicolumnisnull()
oci_field_is_null()
Cancel 
Fetch
ocicancel()
oci_cancel()
Transaction 
Management
Commit
ocicommit()
oci_commit()
Rollback
ocirollback()
oci_rollback()
Descriptors
ocinewdescriptor()
oci_new_descriptor()
ocifreedesc()
oci_free_descriptor()
Error 
Handling
ocierror()
oci_error()
Long Objects 
(LOBs)
ocisavelob()
OCI-Lob::save()
ocisavelobfile()
OCI-LOB::import()
ociwritelobtofile()
OCI-LOB::export()
ociwritetemporarylob() OCI-Lob::writeTemporary()
ociloadlob()
OCI-Lob::load()
ocicloselob()
OCI-Lob::close()
Collections
ocinewcollection()
oci_new_collection()
ocifreecollection()
OCI-Collection::free()
C# PDF Digital Signature Library: add, remove, update PDF digital
Help to Improve the Security of Your PDF File by Adding Digital Signatures. Overview. XDoc.PDF also allows PDF security setting via digital signature.
best way to create pdf forms; acrobat create pdf form
C# Create PDF Library SDK to convert PDF from other file formats
PDF file. What's more, you can also protect created PDF file by adding digital signature (watermark) on PDF using C# code. Create
change font size in pdf form; pdf form maker
OCI8 Function Names in PHP 4 and PHP 5
Operation
Action
PHP 4 Name
PHP 5 Name
ocicollappend()
OCI-Collection::append()
ocicollgetelem()
OCI-Collection::getElem()
ocicollassign()
OCI-Collection::assign()
ocicollassignelem()
OCI-Collection::assignElem()
ocicollsize()
OCI-Collection::size()
ocicollmax()
OCI-Collection::max()
ocicolltrim()
OCI-Collection::trim()
Metadata
Statement 
type
ocistatementtype()
oci_statement_type()
Name of 
result 
column
ocicolumnname()
oci_field_name()
Size of 
result 
column
ocicolumnsize()
oci_field_size()
Data type 
of result 
column
ocicolumntype()
oci_field_type()
Data type 
of result 
column
ocicolumntyperaw()
oci_field_type_raw()
Precision of 
result 
column
ocicolumnprecision()
oci_field_precision()
Scale of 
result 
column
ocicolumnscale()
oci_field_scale()
Number of 
rows 
affected
ocirowcount()
oci_num_rows()
Number of 
columns 
returned
ocinumcols()
oci_num_fields()
Changing 
Password
ocipasswordchange()
oci_password_change()
329
C# PDF insert image Library: insert images into PDF in C#.net, ASP
to insert and add image, picture, digital photo, scanned signature or logo this technical problem, we provide this C#.NET PDF image adding control, XDoc
adding text to a pdf form; add fillable fields to pdf
C# HTML5 Viewer: Load, View, Convert, Annotate and Edit PowerPoint
for C# .NET, users can convert PowerPoint to PDF (.pdf) online, convert Users can perform text signature adding, freehand signature creation and date signature
pdf create fillable form; allow users to save pdf form
OCI8 Function Names in PHP 4 and PHP 5
Operation
Action
PHP 4 Name
PHP 5 Name
Monitoring, 
Tuning and 
Auditing
Not available
oci_set_module_name()
oci_set_action()
oci_set_client_info()
oci_set_client_identifier()
Tracing
ociinternaldebug()
oci_internal_debug()
Upgrading
Allow 
multiple 
versions of 
PL/SQL 
objects to 
be used 
Not available
oci_set_edition()
Oracle Client 
Version
Not available
oci_client_version()
Server 
Version
ociserverversion()
oci_server_version()
Tuning
ocisetprefetch()
oci_set_prefetch() 
(and new php.ini parameter)
330
C# HTML5 Viewer: Load, View, Convert, Annotate and Edit PDF
Viewer for C# .NET provides permanent annotations adding feature, all enables you to create signatures to PDF, including freehand signature, text and
adding images to pdf forms; changing font in pdf form
VB.NET PDF Digital Signature Library: add, remove, update PDF
the Security of Your PDF File by Adding Digital Signatures in VB to be respected, XDoc.PDF also allows PDF such security setting via digital signature.
change font size in fillable pdf form; change tab order in pdf form
APPENDIX D
T
HE
O
BSOLETE
O
RACLE
E
XTENSION
This appendix compares the long obsolete Oracle PHP extension to the current OCI8 
extension. Very rarely you might come across PHP scripts that use this early Oracle API. It is 
no longer included with PHP. The functionality it offered was limited. Upgrading to the new 
OCI8 extension might be as simple as enabling the newer OCI8 extension in the PHP binary 
and renaming the old function calls in your scripts. Pay some attention to transaction 
management and connection handling changes. It is wise to test your application and make 
sure it behaves as you expect it to.
Oracle and OCI8 Comparison
The following table shows the general relationship between the obsolete and current 
extensions:
Table 22: Relationship between the OCI8 and the obsolete Oracle extensions.
Operation
Action
ORA function (obsolete)
OCI8 function
Connection
Open 
connection
ora_logon()
oci_connect()
Open new 
connection
Not available
oci_new_connect()
Persistent 
connection
ora_plogon()
oci_pconnect() 
(and new php.ini parameters)
Close 
connection
ora_logoff()
oci_close()
Used for 
monitoring, 
auditing and 
VPD
Not available
oci_set_client_identifier()
Cursor
Open cursor
ora_open()
oci_new_cursor()
Close cursor
ora_close()
oci_free_statement()
Parsing
Parse 
statement
ora_parse()
oci_parse()
Binding
Bind variable
ora_bind()
oci_bind_by_name()
Bind array
Not available
oci_bind_array_by_name()
Execution
Execute 
statement
ora_exec()
oci_execute()
331
VB.NET PDF Library SDK to view, edit, convert, process PDF file
Capable of adding PDF file navigation features to your VB.NET program. How To Tutorials. Password, digital signature and PDF text, image and page redaction
change font pdf form; add form fields to pdf online
.NET PDF SDK - Description of All PDF Processing Control Feastures
Add signature image to PDF file. PDF Hyperlink Edit. Support adding and inserting hyperlink (link) to PDF document; Allow to create, edit, and remove PDF bookmark
change font on pdf form; add photo to pdf form
The Obsolete Oracle Extension
Operation
Action
ORA function (obsolete)
OCI8 function
Prepare, 
execute and 
fetch
ora_do()
oci_parse()
Followed by
oci_execute()
and one of:
oci_fetch_all()
oci_fetch_array()
oci_fetch_assoc()
oci_fetch_object()
oci_fetch_row()
oci_fetch()
Fetching
Fetch row
ora_fetch()
oci_fetch()
Fetch row
ora_fetch_into
oci_fetch_array()
oci_fetch_row()
oci_fetch_assoc()
oci_fetch_object()
Fetch all rows Not available
oci_fetch_all()
Fetch column
ora_getcolumn()
oci_result()
Is the column 
NULL?
Not available
oci_field_is_null()
Cancel Fetch
Not available
oci_cancel()
Transaction 
Management
Commit
ora_commit()
oci_commit()
Commit mode
ora_commiton()
ora_commitoff()
Pass OCI_NO_AUTO_COMMIT flag 
to oci_execute()
Rollback
ora_rollback()
oci_rollback()
Error 
Handling
ora_error()
ora_errorcode()
oci_error()
332
XDoc.HTML5 Viewer for .NET, All Mature Features Introductions
to search text-based documents, like PDF, Microsoft Office typing new signature, deleting added signature from the After adding such a control button, with a
add submit button to pdf form; changing font size in a pdf form
VB.NET PDF insert image library: insert images into PDF in vb.net
Import graphic picture, digital photo, signature and logo into PDF document. This smart and mature PDF image adding component of RasterEdge VB.NET PDF
adding an image to a pdf form; change font in pdf form
Oracle and OCI8 Comparison
Operation
Action
ORA function (obsolete)
OCI8 function
Long Objects 
(LOBS)
Not available
OCI-Lob->append 
OCI-Lob->close 
OCI-Lob->eof 
OCI-Lob->erase 
OCI-Lob->export 
OCI-Lob->flush 
OCI-Lob->free 
OCI-Lob->getBuffering 
OCI-Lob->import 
OCI-Lob->load 
OCI-Lob->read 
OCI-Lob->rewind 
OCI-Lob->save 
OCI-Lob->saveFile 
OCI-Lob->seek 
OCI-Lob->setBuffering 
OCI-Lob->size 
OCI-Lob->tell 
OCI-Lob->truncate 
OCI-Lob->write 
OCI-Lob->writeTemporary 
OCI-Lob->writeToFile
Collections
Not available
OCI-Collection->append 
OCI-Collection->assign 
OCI-Collection->assignElem
OCI-Collection->free 
OCI-Collection->getElem 
OCI-Collection->max 
OCI-Collection->size 
OCI-Collection->trim
Metadata
Statement 
type
Not available
oci_statement_type()
Name of 
result column
ora_columnname()
oci_field_name()
333
The Obsolete Oracle Extension
Operation
Action
ORA function (obsolete)
OCI8 function
Size of result 
column
ora_columnsize()
oci_field_size()
Data type of 
result column
ora_columntype()
oci_field_type()
oci_field_type_raw()
Precision of 
result column
Not available
oci_field_precision()
Scale of result 
column
Not available
oci_field_scale()
Number of 
rows effected
ora_numrows()
oci_num_rows()
Number of 
columns 
returned
ora_numcols()
oci_num_fields()
SQL 
Monitoring
Send 
metadata to 
Oracle for 
tracing and 
monitoring
Not available
oci_set_module_name()
oci_set_action()
oci_set_client_info()
Changing 
Password
Not available
oci_password_change()
Tracing
Not available
oci_internal_debug()
Oracle Client 
and Server 
Versions
Not available
oci_client_version()
oci_server_version()
Tuning
Not available
oci_set_prefetch() 
(and new php.ini parameter)
Upgrading
Allow multiple 
versions of 
PL/SQL 
objects to be 
used 
Not available
oci_set_edition()
334
APPENDIX E
R
ESOURCES
This appendix gives links to documentation, resources and articles discussed in this book, and 
to other web sites of interest. This book itself can be found free online at:
http://www.oracle.com/technetwork/topics/php/underground-php-oracle-manual-
098250.html
General Information and Forums
PHP Developer Center on Oracle Technology Network (OTN)
http://www.oracle.com/technetwork/topics/php/whatsnew/
OTN PHP Discussion Forum
http://www.oracle.com/technetwork/forums/php/
Blog: Christopher Jones on OPAL
http://blogs.oracle.com/opal/
AskTom
General Oracle language and application design help
http://asktom.oracle.com/
Oracle Linux
https://linux.oracle.com/
Oracle Support
http://support.oracle.com/
Oracle’s Free and Open Source Software
http://oss.oracle.com/
Oracle Documentation and Whitepapers
Oracle 11g Release 2 Documentation Library
http://www.oracle.com/pls/db112/homepage
335
Resources
Oracle TimesTen In-Memory Database Documentation
http://www.oracle.com/technetwork/products/timesten/documentation/
Oracle Database Express Edition Documentation
http://www.oracle.com/technetwork/products/express-edition/documentation/
Oracle Call Interface Programmer's Guide 11g Release 2 (11.2)
http://docs.oracle.com/cd/E11882_01/appdev.112/e10646/toc.htm
Oracle Database Express Edition 2 Day + PHP Developer's Guide 11g Release 2 (11.2)
http://docs.oracle.com/cd/E17781_01/appdev.112/e18555/toc.htm
Oracle Database Net Services Administrator's Guide 11g Release 2 (11.2)
http://docs.oracle.com/cd/E11882_01/network.112/e10836/toc.htm
Oracle Database PL/SQL Language Reference 11g Release 2 (11.2)
http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/toc.htm
Oracle Database SQL Language Reference 11g Release 2 (11.2)
http://docs.oracle.com/cd/E11882_01/server.112/e26088/toc.htm
Oracle Tuxedo Documentation
http://www.oracle.com/technetwork/middleware/tuxedo/documentation/index.html
Whitepaper: Oracle Tuxedo: An Enterprise Platform for Dynamic Languages
http://www.oracle.com/technetwork/middleware/tuxedo/tuxedo-dynamic-langs-
twp-401471.pdf
Selected PHP and Oracle Books
Oracle Database 11g PL/SQL Programming
Michael McLaughlin, Oracle Press, 2008.
Oracle Database AJAX & PHP Web Application Development
Lee Barney and Michael McLaughlin, Oracle Press, 2008
PHP Oracle Web Development
Yuli Vasiliev, Packt Publishing, 2007
Beginning PHP and Oracle: From Novice to Professional
W. Jason Gilmore and Bob Bryla, Apress, 2007
336
Documents you may be interested
Documents you may be interested