pdf page to image c# itextsharp: Change font on pdf form application control tool html web page wpf online apis-php-en27-part1418

257

PDO::MYSQL_ATTR_MAX_BUFFER_SIZE

(integer)

Maximum buffer size. Defaults to 1 MiB. This constant is not supported

when compiled against mysqlnd.

PDO::MYSQL_ATTR_DIRECT_QUERY

(integer)

Perform direct queries, don't use prepared statements.

PDO::MYSQL_ATTR_FOUND_ROWS

(integer)

Return the number of found (matched) rows, not the number of changed

rows.

PDO::MYSQL_ATTR_IGNORE_SPACE

(integer)

Permit spaces after function names. Makes all functions names

reserved words.

PDO::MYSQL_ATTR_COMPRESS

(integer)

Enable network communication compression. This is also supported

when compiled against mysqlnd as of PHP 5.3.11.

PDO::MYSQL_ATTR_SSL_CA

(integer)

The file path to the SSL certificate authority.

This exists as of PHP 5.3.7.

PDO::MYSQL_ATTR_SSL_CAPATH

(integer)

The file path to the directory that contains the trusted SSL CA

certificates, which are stored in PEM format.

This exists as of PHP 5.3.7.

PDO::MYSQL_ATTR_SSL_CERT

(integer)

The file path to the SSL certificate.

This exists as of PHP 5.3.7.

PDO::MYSQL_ATTR_SSL_CIPHER

(integer)

A list of one or more permissible ciphers to use for SSL encryption, in

a format understood by OpenSSL. For example: DHE-RSA-AES256-

SHA:AES128-SHA

This exists as of PHP 5.3.7.

PDO::MYSQL_ATTR_SSL_KEY

(integer)

The file path to the SSL key.

This exists as of PHP 5.3.7.

PDO::MYSQL_ATTR_MULTI_STATEMENTS

(integer)

Disables multi query execution in both PDO::prepare and

PDO::query when set to FALSE.

Note, this constant can only be used in the driver_options array

when constructing a new database handle.

This exists as of PHP 5.5.21 and PHP 5.6.5.

The behaviour of these functions is affected by settings in php.ini.

Table 4.2 PDO_MYSQL Configuration Options

Name

Default

Changeable

pdo_mysql.default_socket

"/tmp/mysql.sock"

PHP_INI_SYSTEM

pdo_mysql.debug

NULL

PHP_INI_SYSTEM

For further details and definitions of the PHP_INI_* modes, see the http://www.php.net/manual/en/

configuration.changes.modes.

Change font on 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

convert word to editable pdf form; add jpg to pdf form

Change font on 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

add fields to pdf form; allow saving of pdf form

PDO_MYSQL DSN

258

Here's a short explanation of the configuration directives.

pdo_mysql.default_socket

string

Sets a Unix domain socket. This value can either be set at compile time

if a domain socket is found at configure. This ini setting is Unix only.

pdo_mysql.debug boolean

Enables debugging for PDO_MYSQL. This setting is only available

when PDO_MYSQL is compiled against mysqlnd and in PDO debug

mode.

4.1 PDO_MYSQL DSN

• PDO_MYSQL DSN

Connecting to MySQL databases

Description

The PDO_MYSQL Data Source Name (DSN) is composed of the following elements:

DSN prefix

The DSN prefix is mysql:.

host

The hostname on which the database server resides.

port

The port number where the database server is listening.

dbname

The name of the database.

unix_socket

The MySQL Unix socket (shouldn't be used with host or port).

charset

The character set. See the character set concepts documentation for

more information.

Prior to PHP 5.3.6, this element was silently ignored.

The same behaviour can be partly replicated with the

PDO::MYSQL_ATTR_INIT_COMMAND driver option, as the following

example shows.

Warning

The method in the below example can only be

used with character sets that share the same

lower 7 bit representation as ASCII, such as

ISO-8859-1 and UTF-8. Users using character

sets that have different representations (such as

UTF-16 or Big5) must use the charset option

provided in PHP 5.3.6 and later versions.

Example 4.2 Setting the connection character set to UTF-8 prior to

PHP 5.3.6

<?php

$dsn = 'mysql:host=localhost;dbname=testdb';

$username = 'username';

$password = 'password';

C# PDF File Compress Library: Compress reduce PDF size in C#.net

RasterEdge.Imaging.Font.dll. Program.RootPath + "\\" 3_optimized.pdf"; // create optimizing options TargetResolution = 150F; // to change image compression

pdf form creator; best program to create pdf forms

VB.NET PDF File Compress Library: Compress reduce PDF size in vb.

Reduce font resources: Font resources will also take up too Program.RootPath + "\\" 3_optimized.pdf"; 'create optimizing 150.0F 'to change image compression

change font on pdf form; changing font size in pdf form

PDO_MYSQL DSN

259

$options = array(

PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8',

);

$dbh = new PDO($dsn, $username, $password, $options);

Changelog

Version

Description

5.3.6

Prior to version 5.3.6, charset was ignored.

Examples

Example 4.3 PDO_MYSQL DSN examples

The following example shows a PDO_MYSQL DSN for connecting to MySQL databases:

mysql:host=localhost;dbname=testdb

More complete examples:

mysql:host=localhost;port=3307;dbname=testdb

mysql:unix_socket=/tmp/mysql.sock;dbname=testdb

Notes

Unix only:

When the host name is set to "localhost", then the connection to the server

is made thru a domain socket. If PDO_MYSQL is compiled against libmysqlclient

then the location of the socket file is at libmysqlclient's compiled in location. If

PDO_MYSQL is compiled against mysqlnd a default socket can be set thru the

pdo_mysql.default_socket setting.

C# PDF insert text Library: insert text into PDF content in C#.net

Powerful .NET PDF edit control allows modify existing scanned PDF text. Ability to change text font, color, size and location and output a new PDF document.

change font size in fillable pdf form; pdf form creation

C# PDF Sticky Note Library: add, delete, update PDF note in C#.net

Allow users to add comments online in ASPX webpage. Able to change font size in PDF comment box. Able to save and print sticky notes in PDF file.

android edit pdf forms; add text field pdf

260

VB.NET PDF Password Library: add, remove, edit PDF file password

RasterEdge.Imaging.Font.dll. passwordSetting.IsHighReso = True ' Allow to change document. passwordSetting.IsAssemble = True ' Add password to PDF file.

create a pdf form online; change font pdf fillable form

C# PDF Password Library: add, remove, edit PDF file password in C#

RasterEdge.Imaging.Font.dll. passwordSetting.IsHighReso = true; // Allow to change document. passwordSetting.IsAssemble = true; // Add password to PDF file.

add fillable fields to pdf; adding text fields to pdf acrobat

261

Chapter 5 Original MySQL API

Table of Contents

5.1 Installing/Configuring................................................................................................................. 262

5.1.1 Requirements ................................................................................................................ 262

5.1.2 Installation ..................................................................................................................... 262

5.1.3 Runtime Configuration .................................................................................................... 264

5.1.4 Resource Types............................................................................................................. 265

5.2 Changelog................................................................................................................................ 265

5.3 Predefined Constants................................................................................................................ 266

5.4 Examples................................................................................................................................. 267

5.4.1 MySQL extension overview example............................................................................... 267

5.5 MySQL Functions ..................................................................................................................... 267

5.5.1 mysql_affected_rows ............................................................................................... 268

5.5.2 mysql_client_encoding ........................................................................................... 270

5.5.3 mysql_close ............................................................................................................... 271

5.5.4 mysql_connect ........................................................................................................... 272

5.5.5 mysql_create_db ....................................................................................................... 275

5.5.6 mysql_data_seek ....................................................................................................... 277

5.5.7 mysql_db_name ........................................................................................................... 278

5.5.8 mysql_db_query ......................................................................................................... 279

5.5.9 mysql_drop_db ........................................................................................................... 281

5.5.10 mysql_errno ............................................................................................................. 283

5.5.11 mysql_error ............................................................................................................. 284

5.5.12 mysql_escape_string ............................................................................................. 285

5.5.13 mysql_fetch_array ................................................................................................. 286

5.5.14 mysql_fetch_assoc ................................................................................................. 289

5.5.15 mysql_fetch_field ................................................................................................. 291

5.5.16 mysql_fetch_lengths ............................................................................................. 293

5.5.17 mysql_fetch_object ............................................................................................... 294

5.5.18 mysql_fetch_row ..................................................................................................... 296

5.5.19 mysql_field_flags ................................................................................................. 297

5.5.20 mysql_field_len ..................................................................................................... 298

5.5.21 mysql_field_name ................................................................................................... 300

5.5.22 mysql_field_seek ................................................................................................... 301

5.5.23 mysql_field_table ................................................................................................. 302

5.5.24 mysql_field_type ................................................................................................... 303

5.5.25 mysql_free_result ................................................................................................. 305

5.5.26 mysql_get_client_info ......................................................................................... 306

5.5.27 mysql_get_host_info ............................................................................................. 307

5.5.28 mysql_get_proto_info ........................................................................................... 308

5.5.29 mysql_get_server_info ......................................................................................... 309

5.5.30 mysql_info ............................................................................................................... 310

5.5.31 mysql_insert_id ..................................................................................................... 311

5.5.32 mysql_list_dbs ....................................................................................................... 313

5.5.33 mysql_list_fields ................................................................................................. 314

5.5.34 mysql_list_processes ........................................................................................... 316

5.5.35 mysql_list_tables ................................................................................................. 317

5.5.36 mysql_num_fields ................................................................................................... 319

5.5.37 mysql_num_rows ....................................................................................................... 320

Annotate, Redact Image in .NET Winforms| Online Tutorials

Click "Font" to change annotations font color, size We are dedicated to provide powerful & profession imaging controls, PDF document, image to pdf

add image to pdf form; change tab order in pdf form

C# PDF Text Box Edit Library: add, delete, update PDF text box in

Support to change font color in PDF text box. Ability to change text size in PDF text box. Adding text box is another way to add text to PDF page.

add form fields to pdf online; add photo to pdf form

Installing/Configuring

262

5.5.38 mysql_pconnect ....................................................................................................... 321

5.5.39 mysql_ping ............................................................................................................... 323

5.5.40 mysql_query ............................................................................................................. 324

5.5.41 mysql_real_escape_string ................................................................................... 326

5.5.42 mysql_result ........................................................................................................... 329

5.5.43 mysql_select_db ..................................................................................................... 330

5.5.44 mysql_set_charset ................................................................................................. 332

5.5.45 mysql_stat ............................................................................................................... 333

5.5.46 mysql_tablename ..................................................................................................... 334

5.5.47 mysql_thread_id ..................................................................................................... 336

5.5.48 mysql_unbuffered_query ....................................................................................... 337

This extension is deprecated as of PHP 5.5.0, and has been removed as of PHP 7.0.0. Instead, either the

mysqli or PDO_MySQL extension should be used. See also the MySQL API Overview for further help while

choosing a MySQL API.

These functions allow you to access MySQL database servers. More information about MySQL can be

found at http://www.mysql.com/.

Documentation for MySQL can be found at http://dev.mysql.com/doc/.

5.1 Installing/Configuring

5.1.1 Requirements

In order to have these functions available, you must compile PHP with MySQL support.

5.1.2 Installation

For compiling, simply use the --with-mysql[=DIR] configuration option where the optional [DIR]

points to the MySQL installation directory.

Although this MySQL extension is compatible with MySQL 4.1.0 and greater, it doesn't support the extra

functionality that these versions provide. For that, use the MySQLi extension.

If you would like to install the mysql extension along with the mysqli extension you have to use the same

client library to avoid any conflicts.

5.1.2.1 Installation on Linux Systems

Note: [DIR] is the path to the MySQL client library files (headers and libraries), which can be downloaded

from MySQL.

C# PDF Annotate Library: Draw, edit PDF annotation, markups in C#.

Able to edit and change PDF annotation properties such as font size or color. Abilities to draw markups on PDF document or stamp on PDF file.

change font size pdf form; changing font size in a pdf form

Installation

263

Table 5.1 ext/mysql compile time support matrix

PHP Version

Default

Configure

Options: mysqlnd

Configure

Options:

libmysqlclient

Changelog

4.x.x

libmysqlclient

Not Available

--without-mysql

to disable

MySQL enabled

by default, MySQL

client libraries are

bundled

5.0.x, 5.1.x, 5.2.x

libmysqlclient

Not Available

--with-

mysql=[DIR]

MySQL is no longer

enabled by default,

and the MySQL

client libraries are

no longer bundled

5.3.x

libmysqlclient

--with-

mysql=mysqlnd

--with-

mysql=[DIR]

mysqlnd is now

available

5.4.x

mysqlnd

--with-mysql

--with-

mysql=[DIR]

mysqlnd is now the

default

5.1.2.2 Installation on Windows Systems

PHP 4

The PHP MySQL extension is compiled into PHP.

PHP 5.0.x, 5.1.x, 5.2.x

MySQL is no longer enabled by default, so the php_mysql.dll DLL must be enabled inside of php.ini.

Also, PHP needs access to the MySQL client library. A file named libmysql.dll is included in the

Windows PHP distribution and in order for PHP to talk to MySQL this file needs to be available to the

Windows systems PATH. See the FAQ titled "How do I add my PHP directory to the PATH on Windows"

for information on how to do this. Although copying libmysql.dll to the Windows system directory also

works (because the system directory is by default in the system's PATH), it's not recommended.

As with enabling any PHP extension (such as php_mysql.dll), the PHP directive extension_dir should

be set to the directory where the PHP extensions are located. See also the Manual Windows Installation

Instructions. An example extension_dir value for PHP 5 is c:\php\ext

Note

If when starting the web server an error similar to the following occurs: "Unable

to load dynamic library './php_mysql.dll'", this is because

php_mysql.dll and/or libmysql.dll cannot be found by the system.

PHP 5.3.0+

The MySQL Native Driver is enabled by default. Include php_mysql.dll, but libmysql.dll is no

longer required or used.

Runtime Configuration

264

5.1.2.3 MySQL Installation Notes

Warning

Crashes and startup problems of PHP may be encountered when loading this

extension in conjunction with the recode extension. See the recode extension for

more information.

Note

If you need charsets other than latin (default), you have to install external (not

bundled) libmysqlclient with compiled charset support.

5.1.3 Runtime Configuration

The behaviour of these functions is affected by settings in php.ini.

Table 5.2 MySQL Configuration Options

Name

Default

Changeable

Changelog

mysql.allow_local_infile

"1"

PHP_INI_SYSTEM

mysql.allow_persistent

"1"

PHP_INI_SYSTEM

mysql.max_persistent

"-1"

PHP_INI_SYSTEM

mysql.max_links

"-1"

PHP_INI_SYSTEM

mysql.trace_mode

"0"

PHP_INI_ALL

Available since PHP

4.3.0.

mysql.default_port

NULL

PHP_INI_ALL

mysql.default_socket

NULL

PHP_INI_ALL

Available since PHP

4.0.1.

mysql.default_host

NULL

PHP_INI_ALL

mysql.default_user

NULL

PHP_INI_ALL

mysql.default_password

NULL

PHP_INI_ALL

mysql.connect_timeout

"60"

PHP_INI_ALL

PHP_INI_SYSTEM in

PHP <= 4.3.2. Available

since PHP 4.3.0.

For further details and definitions of the PHP_INI_* modes, see the http://www.php.net/manual/en/

configuration.changes.modes.

Here's a short explanation of the configuration directives.

mysql.allow_local_infile

integer

Allow accessing, from PHP's perspective, local files with LOAD DATA

statements

mysql.allow_persistent

boolean

Whether to allow persistent connections to MySQL.

mysql.max_persistent

integer

The maximum number of persistent MySQL connections per process.

Resource Types

265

mysql.max_links integer

The maximum number of MySQL connections per process, including

persistent connections.

mysql.trace_mode boolean

Trace mode. When mysql.trace_mode is enabled, warnings for table/

index scans, non free result sets, and SQL-Errors will be displayed.

(Introduced in PHP 4.3.0)

mysql.default_port string

The default TCP port number to use when connecting to the database

server if no other port is specified. If no default is specified, the

port will be obtained from the MYSQL_TCP_PORT environment

variable, the mysql-tcp entry in /etc/services or the compile-

time MYSQL_PORT constant, in that order. Win32 will only use the

MYSQL_PORT constant.

mysql.default_socket

string

The default socket name to use when connecting to a local database

server if no other socket name is specified.

mysql.default_host string

The default server host to use when connecting to the database server

if no other host is specified. Doesn't apply in SQL safe mode.

mysql.default_user string

The default user name to use when connecting to the database server if

no other name is specified. Doesn't apply in SQL safe mode.

mysql.default_password

string

The default password to use when connecting to the database server if

no other password is specified. Doesn't apply in SQL safe mode.

mysql.connect_timeout

integer

Connect timeout in seconds. On Linux this timeout is also used for

waiting for the first answer from the server.

5.1.4 Resource Types

There are two resource types used in the MySQL module. The first one is the link identifier for a database

connection, the second a resource which holds the result of a query.

5.2 Changelog

The following changes have been made to classes/functions/methods of this extension.

General Changelog for the ext/mysql extension

This changelog references the ext/mysql extension.

Global ext/mysql changes

The following is a list of changes to the entire ext/mysql extension.

Version

Description

7.0.0

This extension was removed from PHP. For details,

see Section 2.3, “Choosing an API” ” .

5.5.0

This extension has been deprecated. Connecting

to a MySQL database via mysql_connect,

Changes to existing functions

266

Version

Description

mysql_pconnect or an implicit connection via

any other mysql_* function will generate an

E_DEPRECATED error.

5.5.0

All of the old deprecated functions and aliases now

emit E_DEPRECATED errors. These functions are:

mysql(), mysql_fieldname(), mysql_fieldtable(),

mysql_fieldlen(), mysql_fieldtype(),

mysql_fieldflags(), mysql_selectdb(),

mysql_createdb(), mysql_dropdb(),

mysql_freeresult(), mysql_numfields(),

mysql_numrows(), mysql_listdbs(),

mysql_listtables(), mysql_listfields(),

mysql_db_name(), mysql_dbname(),

mysql_tablename(), and mysql_table_name().

Changes to existing functions

The following list is a compilation of changelog entries from the ext/mysql functions.

5.3 Predefined Constants

The constants below are defined by this extension, and will only be available when the extension has either

been compiled into PHP or dynamically loaded at runtime.

Since PHP 4.3.0 it is possible to specify additional client flags for the mysql_connect and

mysql_pconnect functions. The following constants are defined:

Table 5.3 MySQL client constants

Constant

Description

MYSQL_CLIENT_COMPRESS

Use compression protocol

MYSQL_CLIENT_IGNORE_SPACE

Allow space after function names

MYSQL_CLIENT_INTERACTIVE

Allow interactive_timeout seconds (instead of

wait_timeout) of inactivity before closing the

connection.

MYSQL_CLIENT_SSL

Use SSL encryption. This flag is only available with

version 4.x of the MySQL client library or newer.

Version 3.23.x is bundled both with PHP 4 and

Windows binaries of PHP 5.

The function mysql_fetch_array uses a constant for the different types of result arrays. The following

constants are defined:

Table 5.4 MySQL fetch constants

Constant

Description

MYSQL_ASSOC

Columns are returned into the array having the

fieldname as the array index.

Documents you may be interested

pdf page to image c# itextsharp : Change font on pdf form application control tool html web page wpf online apis-php-en27-part1418