{"id":600,"date":"2012-03-21T17:15:14","date_gmt":"2012-03-21T16:15:14","guid":{"rendered":"http:\/\/sppadbase.ipp.cnr.it\/?p=600"},"modified":"2012-03-21T17:17:18","modified_gmt":"2012-03-21T16:17:18","slug":"work-in-progress-21-march-2012-2","status":"publish","type":"post","link":"https:\/\/sppadbase.ipsp.cnr.it\/?p=600","title":{"rendered":"work in progress [21 march 2012]"},"content":{"rendered":"<p><?php\n$db_host = \"dell.area.fi.cnr.it\";\n$db_user = \"sppadbase_c26399\";\n$db_pass = \"sppadbase139922\";\n$db_name= \"sppadbase_c26399\";\n$wpdb = new wpdb($db_user, $db_pass, $db_name, $db_host);\n\n$sql_gen = \"SELECT DISTINCT data_genus FROM p4pf_data\";\n$rows = $wpdb->get_results($sql_gen, ARRAY_A) or die(mysql_error());<br \/>\n$gen_no = $wpdb->num_rows;<\/p>\n<p>$sql_spe = &#8220;SELECT DISTINCT data_specie FROM p4pf_data&#8221;;<br \/>\n$rows = $wpdb->get_results($sql_spe, ARRAY_A) or die(mysql_error());<br \/>\n$spe_no = $wpdb->num_rows;<\/p>\n<p>$sql_set = &#8220;SELECT * FROM p4pf_data&#8221;;<br \/>\n$rows = $wpdb->get_results($sql_set, ARRAY_A) or die(mysql_error());<br \/>\n$set_no = $wpdb->num_rows;<\/p>\n<p>$sql_ref = &#8220;SELECT * FROM p4pf_references&#8221;;<br \/>\n$rows = $wpdb->get_results($sql_ref, ARRAY_A) or die(mysql_error());<br \/>\n$ref_no = $wpdb->num_rows;<br \/>\n?><br \/>\nHello everybody!<br \/>\nBig work on database update in these days!<br \/>\nI am trying to upload asap all the primer set suggested by users of the old site. I am just one article far from completion!<\/p>\n<p>At the moment the database counts:<\/p>\n<blockquote><p><strong>Genera<\/strong>: <?php echo $gen_no; ?> <br \/>\n<strong>Species<\/strong>: <?php echo $spe_no; ?> <br \/>\n<strong>Primer sets<\/strong>: <?php echo $set_no; ?> <br \/>\n<strong>References<\/strong>: <?php echo $ref_no; ?><br \/>\n(<em>live update<\/em>)<\/p><\/blockquote>\n<p>Cheers,<br \/>\nStefano<\/p>\n","protected":false},"excerpt":{"rendered":"<p> Hello everybody! Big work on database update in these days! I am trying to upload asap all the primer set suggested by users of the old site. I am just one article far from completion!<\/p>\n<p>At the moment the database counts:<\/p>\n<p>Genera: Species: Primer sets: References: (live update)<\/p>\n<p>Cheers, Stefano<\/p>\n<p> <span style=\"color:#777\"> . . . &rarr; Read More: <a href=\"https:\/\/sppadbase.ipsp.cnr.it\/?p=600\">work in progress [21 march 2012]<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/sppadbase.ipsp.cnr.it\/index.php?rest_route=\/wp\/v2\/posts\/600"}],"collection":[{"href":"https:\/\/sppadbase.ipsp.cnr.it\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sppadbase.ipsp.cnr.it\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sppadbase.ipsp.cnr.it\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sppadbase.ipsp.cnr.it\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=600"}],"version-history":[{"count":20,"href":"https:\/\/sppadbase.ipsp.cnr.it\/index.php?rest_route=\/wp\/v2\/posts\/600\/revisions"}],"predecessor-version":[{"id":620,"href":"https:\/\/sppadbase.ipsp.cnr.it\/index.php?rest_route=\/wp\/v2\/posts\/600\/revisions\/620"}],"wp:attachment":[{"href":"https:\/\/sppadbase.ipsp.cnr.it\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sppadbase.ipsp.cnr.it\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sppadbase.ipsp.cnr.it\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}