{"id":45,"date":"2009-07-01T18:30:12","date_gmt":"2009-07-01T18:30:12","guid":{"rendered":"http:\/\/dev001.dl\/yan\/wdp\/?p=45"},"modified":"2026-01-20T05:06:49","modified_gmt":"2026-01-20T05:06:49","slug":"mysql-interface-php","status":"publish","type":"post","link":"http:\/\/www.lalife.net\/?p=45","title":{"rendered":"MySQL interface — PHP"},"content":{"rendered":"

Connect and Close connection to DB<\/strong><\/p>\n

$DB_HOST = “localhost”;<\/p>\n

$DB_NAME = “mysql”;<\/p>\n

$DB_USER = “mysql”;<\/p>\n

$DB_PASS = “password”;<\/p>\n

function conn_db(){<\/p>\n

global $DB_HOST;<\/p>\n

global $DB_USER;<\/p>\n

global $DB_PASS;<\/p>\n

global $DB_NAME;<\/p>\n

if(!($conn = mysql_connect($DB_HOST, $DB_USER, $DB_PASS))) {<\/p>\n

echo “Failed to connect DB”;<\/p>\n

echo mysql_error($conn);<\/p>\n

die;<\/p>\n

}<\/p>\n

if(!(mysql_select_db($DB_NAME))) {<\/p>\n

echo “Failed to select DB”;<\/p>\n

echo mysql_error($conn);<\/p>\n

die;<\/p>\n

}<\/p>\n

return $conn;<\/p>\n

}<\/p>\n

function close_db($conn){<\/p>\n

mysql_close($conn);<\/p>\n

}<\/p>\n

$conn = conn_db();<\/p>\n

$sql = “select * from users where date>’20081001′ order by id”;<\/p>\n

if (!($rs=mysql_query($sql))) {<\/p>\n

echo mysql_error($conn);<\/span><\/p>\n

die;<\/p>\n

}<\/p>\n

while ($row = mysql_fetch_array($rs)) {<\/p>\n

echo “$row[0] $row[1]\\n”;<\/p>\n

}<\/p>\n","protected":false},"excerpt":{"rendered":"

Connect and Close connection to DB $DB_HOST = “localhost”; $DB_NAME = “mysql”; $DB_USER = “mysql”; $DB_PASS = “password”; function conn_db(){ global $DB_HOST; global $DB_USER; global $DB_PASS; global $DB_NAME; if(!($conn = mysql_connect($DB_HOST, $DB_USER, $DB_PASS))) { echo “Failed to connect DB”; echo … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19,24],"tags":[],"class_list":["post-45","post","type-post","status-publish","format-standard","hentry","category-mysql","category-php"],"_links":{"self":[{"href":"http:\/\/www.lalife.net\/index.php?rest_route=\/wp\/v2\/posts\/45","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.lalife.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.lalife.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.lalife.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.lalife.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=45"}],"version-history":[{"count":1,"href":"http:\/\/www.lalife.net\/index.php?rest_route=\/wp\/v2\/posts\/45\/revisions"}],"predecessor-version":[{"id":1957,"href":"http:\/\/www.lalife.net\/index.php?rest_route=\/wp\/v2\/posts\/45\/revisions\/1957"}],"wp:attachment":[{"href":"http:\/\/www.lalife.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=45"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.lalife.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=45"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.lalife.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=45"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}