|
System | : | Linux MiraNet 3.0.0-14-generic-pae #23-Ubuntu SMP Mon Nov 21 22:07:10 UTC 2011 i686 |
Software | : | Apache. PHP/5.3.6-13ubuntu3.10 |
ID | : | uid=65534(nobody) gid=65534(nogroup) groups=65534(nogroup)
|
|
Safe Mode | : | OFF |
Open_Basedir | : | OFF |
Freespace | : | 26.09 GB of 70.42 GB (37.05%) |
|
MySQL: ON MSSQL: OFF Oracle: OFF PostgreSQL: OFF Curl: OFF Sockets: ON Fetch: OFF Wget: ON Perl: ON |
Disabled Functions: pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
|
[ System Info ]
[ Processes ]
[ SQL Manager ]
[ Eval ]
[ Encoder ]
[ Mailer ]
[ Back Connection ]
[ Backdoor Server ]
[ Kernel Exploit Search ]
[ MD5 Decrypter ]
[ Reverse IP ]
[ Kill Shell ]
[ FTP Brute-Force ]
|
|
/
usr/
share/
doc/
libdbd-mysql-perl/
examples/
- drwxr-xr-x
|
Viewing file: proc_example4.pl (1.36 KB) -rwxr-xr-xSelect action/file-type:  ( +) |  ( +) |  ( +) | Code ( +) | Session ( +) |  ( +) | SDB ( +) |  ( +) |  ( +) |  ( +) |  ( +) |  ( +) |
#!/usr/bin/perl
use DBI; use strict; use Data::Dumper; use warnings; my $connect_string = 'DBI:mysql:database=test'; my $username = 'root'; my $password = ''; my $attributes = {}; my $dbh = DBI->connect($connect_string, $username, $password, $attributes) || die $DBI::errstr;
# Execute this AT LEAST once so the stored procedure someproc() exists # at least $dbh->do("drop procedure if exists someproc") or print $DBI::errstr;
# Comment this out to reproduce the bug $dbh->do("create procedure someproc() deterministic begin ". "declare a,b,c,d int; set a=1; set b=2; set c=3; set d=4; ". "select a, b, c, d; select d, c, b, a; select b, a, c, d; ". "select c, b, d, a; end") or print $DBI::errstr; my $sth=$dbh->prepare('call someproc()') || die $DBI::errstr; $sth->execute || die $DBI::errstr; my @row= $sth->fetchrow_array(); print Dumper \@row; my $more_results = $sth->more_results(); print $more_results . "\n"; @row= $sth->fetchrow_array(); print Dumper \@row; $more_results = $sth->more_results(); print $more_results . "\n"; @row= $sth->fetchrow_array(); print Dumper \@row; $more_results = $sth->more_results(); print $more_results . "\n"; @row= $sth->fetchrow_array(); print Dumper \@row; $more_results = $sth->more_results(); print $more_results . "\n"; @row= $sth->fetchrow_array(); print Dumper \@row; $more_results = $sth->more_results(); print $more_results . "\n";
|