Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number

New twist for DBD::mysql

by gmax (Abbot)
on Sep 14, 2004 at 10:06 UTC ( #390778=perlmeditation: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download

  1. or download this
    # either
    my $dbh = DBI->connect("dbi:mysql:dbname;mysql_server_prepare=1",
    # or 
    $dbh->{ mysql_server_prepare } = 1;
  2. or download this
  3. or download this
    my $query = qq{SELECT col1, col2, col3 FROM mytable LIMIT ? , ?};
    my $sth = $dbh->prepare($query);
        $sth->execute($page_no, $lines);
        # do something with the page.
  4. or download this
    $dbh1->{ mysql_server_prepare } = 0;  # emulated prepared statement
    $dbh2->{ mysql_server_prepare } = 1;  # real prepared statement
    print "prepared\n", $dbh2->{Profile}->format;
    $dbh1->{Profile} =0;
    $dbh2->{Profile} =0;

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlmeditation [id://390778]
Approved by castaway
Front-paged by broquaint
[LanX]: it's easier to patch then to migrate to a PHP board, there are many semantics like linking , authorisation, templates ,...
[LanX]: I've only seen 30% of the semi professional documentation
[holli]: i was just thinking of the bare content.
[LanX]: Plenty of "templates" realised with CGI-HTML-function
[LanX]: well if you want you can fetch all XML and translate it to another board markup
[moritz]: at this time, a migration could consist of only migrating the rendered HTML of nodes
[moritz]: to a forum software that supports raw HTML input for legacy threads, and uses sane markup for everything else
[holli]: yeah, then vroom will personally stab me in the back at night
[holli]: exactly, moritz
[moritz]: with a big table of redirects to support the old links

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (10)
As of 2017-11-20 19:31 GMT
Find Nodes?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:

    Results (292 votes). Check out past polls.