{"id":7004,"date":"2014-12-16T15:13:17","date_gmt":"2014-12-16T07:13:17","guid":{"rendered":"http:\/\/jpuyy.com\/?p=7004"},"modified":"2014-12-16T15:13:35","modified_gmt":"2014-12-16T07:13:35","slug":"php%e5%af%bc%e5%87%bamysql%e5%88%b0csv","status":"publish","type":"post","link":"https:\/\/jpuyy.com\/?p=7004","title":{"rendered":"php\u5bfc\u51famysql\u5230csv"},"content":{"rendered":"<pre>\r\n\r\n    \/\/ connect to database\r\n    include(\"conectar.php\");\r\n\r\n    $fp = fopen('exporterrors.csv', 'w');\r\n\r\n    $queryString = \"SELECT * FROM url_monitor where monitor='off' order by object_id\";\r\n    $rows = mysql_query($queryString);\r\n\r\n    while ($row = mysql_fetch_assoc($rows)) {\r\n        fputcsv($fp, $row);\r\n    }\r\n\r\n    fclose($fp);\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\/\/ connect to database include(&#8220;conectar.php&#8221;); $fp = fopen(&#8216;exporterrors.csv&#8217;, &#8216;w&#8217;); $queryString = &#8220;SELECT * FROM url_monitor where monitor=&#8217;off&#8217; order by object_id&#8221;; $rows = mysql_query($queryString); while ($row = mysql_fetch_assoc($rows)) { fputcsv($fp, $row); } fclose($fp);<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-7004","post","type-post","status-publish","format-standard","hentry","category-life"],"_links":{"self":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/7004","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=7004"}],"version-history":[{"count":2,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/7004\/revisions"}],"predecessor-version":[{"id":7006,"href":"https:\/\/jpuyy.com\/index.php?rest_route=\/wp\/v2\/posts\/7004\/revisions\/7006"}],"wp:attachment":[{"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=7004"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=7004"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jpuyy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=7004"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}