source: temp/trunk/html/test/kakinaka/mysql.php @ 4711

<?php
require_once './DB.php'; // PEAR ¤Î DB ¥¯¥é¥¹¤òÆɤ߹þ¤à

print("start<br>");

$dsn = "mysql://eccube_db_user:[email protected]/eccube_db";
/*
print($dsn."<br>");

if(($db = DB::connect($dsn)) == 0){
  print "¤ª¤ª¤Ã¤È¡ª¥Ç¡¼¥¿¥Ù¡¼¥¹¤ËÀܳ¤Ç¤­¤Þ¤»¤ó¡£";
}
$result = $db->query("select * from dtb_baseinfo");
while($row = $result->fetchRow()){
    print_r($row);
}
*/

$sql = "SELECT * FROMdtb_baseinfoWHERE";
$sql = getMailAddress($sql);
print_r($sql);

print("end");

// ʸ»úÎó¤ÎÃæ¤Ë¸ºß¤¹¤ë¥á¡¼¥ë¥¢¥É¥ì¥¹¤Î¤ß¤ò¼èÆÀ¤·¡¢ÇÛÎó¤È¤·¤ÆÊÖ¤¹
function getMailAddress($str){
    $arrMail = array();
    preg_match_all("/FROM+([a-zA-Z0-9_\.\+\?-]+WHERE)/", $str, $arrMail);
    return $arrMail[0];
}

?>