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

PAB3::DB::Driver::Mysql Ranking & Summary

PAB3::DB::Driver::Mysql Tags

database Perl module MySQL MySQL driver PAB3 Perl5 wrapper

PAB3::DB::Driver::Mysql Description

PAB3::DB::Driver::Mysql is a Perl5 wrapper to the mysql5 client libary and driver for the PAB3::DB class. 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. Requirements: · Perl

PAB3::DB::Driver::Mysql Related Software