PAB3::DB::Driver::Mysql 1.0.6

PAB3::DB::Driver::Mysql is a Perl5 wrapper to the mysql5 client libary and driver for the PAB3::DB class.

SYNOPSIS

use PAB3::DB::Driver::Mysql;
# functions and constants are exported by default

$linkid = mysql_connect();
$linkid = mysql_connect( $server );
$linkid = mysql_connect( $server, $user );
$linkid = mysql_connect( $server, $user, $pass );
$linkid = mysql_connect( $server, $user, $pass, $db );
$linkid = mysql_connect( $server, $user, $pass, $db, $client_flag );

$resid = mysql_query( $statement );
$resid = mysql_query( $linkid, $statement );

$stmtid = mysql_prepare( $statement );
$stmtid = mysql_prepare( $linkid, $statement );

$rv = mysql_bind_param( $stmtid, $p_num );
$rv = mysql_bind_param( $stmtid, $p_num, $value );
$rv = mysql_bind_param( $stmtid, $p_num, $value, $type );

$stmtid = $resid = mysql_execute( $stmtid );
$stmtid = $resid = mysql_execute( $stmtid, @bind_values );

@row = mysql_fetch_row( $resid );
@row = mysql_fetch_row( $stmtid );
@row = mysql_fetch_array( $resid );
@row = mysql_fetch_array( $stmtid );

@col = mysql_fetch_col( $resid );
@col = mysql_fetch_col( $stmtid );

%row = mysql_fetch_hash( $resid );
%row = mysql_fetch_hash( $stmtid );

@names = mysql_fetch_names( $resid );
@names = mysql_fetch_names( $stmtid );

@lengths = mysql_fetch_lengths( $resid );
@lengths = mysql_fetch_lengths( $stmtid );

$num_rows = mysql_num_rows( $resid );
$num_rows = mysql_num_rows( $stmtid );

$row_index = mysql_row_tell( $resid );
$row_index = mysql_row_tell( $stmtid );

mysql_row_seek( $resid, $row_index );
mysql_row_seek( $stmtid, $row_index );

$num_fields = mysql_num_fields( $resid );
$num_fields = mysql_num_fields( $stmtid );

%field = mysql_fetch_field( $resid );
%field = mysql_fetch_field( $resid, $offset );
%field = mysql_fetch_field( $stmtid );
%field = mysql_fetch_field( $stmtid, $offset );

$field_index = mysql_field_tell( $resid );
$field_index = mysql_field_tell( $stmtid );

$hr = mysql_field_seek( $resid );
$hr = mysql_field_seek( $resid, $offset );
$hr = mysql_field_seek( $stmtid );
$hr = mysql_field_seek( $stmtid, $offset );

mysql_free_result( $resid );
mysql_free_result( $stmtid );

$affected_rows = mysql_affected_rows();
$affected_rows = mysql_affected_rows( $linkid );
$affected_rows = mysql_affected_rows( $stmtid );

$id = mysql_insert_id();
$id = mysql_insert_id( $linkid );
$id = mysql_insert_id( $stmtid );

$hr = mysql_set_charset( $charset );
$hr = mysql_set_charset( $linkid, $charset );

$charset = mysql_get_charset();
$charset = mysql_get_charset( $linkid );

$quoted = mysql_quote( $str );
$quoted = mysql_quote_id( ... );
$str = mysql_escape( $str );
$str = mysql_escape( $linkid, $str );

mysql_auto_commit( $mode );
mysql_auto_commit( $linkid, $mode );
mysql_begin_work();
mysql_begin_work( $linkid );
mysql_commit();
mysql_commit( $linkid );
mysql_rollback();
mysql_rollback( $linkid );

$str = mysql_error();
$str = mysql_error( $linkid );
$errno = mysql_errno();
$errno = mysql_errno( $linkid );

mysql_close();
mysql_close( $linkid );
mysql_close( $stmtid );
mysql_close( $resid );

PAB3::DB::Driver::Mysql provides an interface to the mysql client library.

This module should be threadsafe, BUT:

If you plan using threads, you should use own connections in each thread. It is never safe to use the same connection in two or more threads.

Under ModPerl or PerlEx environment several scripts may take access to the same instance of the perl interpreter. All functions are thread local but global to the interpreter! If you plan using different connections in your scripts which may access to the same interpreter you should explicitly set $linkid in all expected functions. You can alternatively use the PAB3::DB class. It takes care of it by itself.

Product's homepage

Requirements:

· Perl