Changeset 4709 for temp/trunk/html/test/kakinaka/mysql.php

Timestamp:

2006/09/14 10:15:27 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/test/kakinaka/mysql.php (modified) (2 diffs)

temp/trunk/html/test/kakinaka/mysql.php

@@ -5 +5 @@
 
 $dsn = "mysql://eccube_db_user:[email protected]/eccube_db";
-
+/*
 print($dsn."<br>");
 
@@ -15 +15 @@
     print_r($row);
 }
+*/
+
+$sql = "SELECT * FROM dtb_baseinfo WHERE";
+$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];
+}
+
 ?>