DBI-tip: Private State Variables : D-7 <altijd in beweging>主ã«è‡ªåˆ†ç”¨ãƒ¡ãƒ¢ã€‚例ãˆã°ä»¥ä¸‹ã®ã‚ˆã†ãªã‚³ãƒ¼ãƒ‰ã‹ã‚‰DBIãƒãƒ³ãƒ‰ãƒ«ã‚’å–å¾—ã—ã¦ã‚‹ã¨ã™ã‚‹ use strict; use DBI; sub get_dbh { DBI->connect_cached(....); } sub foo { my $dbh = get_dbh(); $dbh->do(...); } sub bar { my $dbh = get_dbh(); $dbh->do(...); } foo(); bar(); .... ã§ã€ã¾ãSET NAMES utf8を自動的ã«ç™ºè¡Œã—ãŸã„ãªãƒ¼ã¨æ€ã£ãŸã®ã§ã€get_dbhã«æ‰‹ã‚’入れる sub get_dbh { my $dbh = DBI->connect_cached(...); $dbh->do("SET NAMES 'utf8'"); return $dbh; } ãã†ã™ã‚‹ã¨get_dbh()内㧠DBIãƒãƒ³ãƒ‰ãƒ«è‡ªä½“ã¯connect_c
{{#tags}}- {{label}}
{{/tags}}