{"id":947,"date":"2014-04-23T20:10:29","date_gmt":"2014-04-23T20:10:29","guid":{"rendered":"http:\/\/corbdesign.com\/blog\/?p=947"},"modified":"2014-04-23T20:10:29","modified_gmt":"2014-04-23T20:10:29","slug":"common-php","status":"publish","type":"post","link":"https:\/\/corbinrose.com\/blog\/technology\/common-php\/","title":{"rendered":"common php"},"content":{"rendered":"\n

Here are some of the common php things I use, and always have to look up:<\/p>\n\n\n\n

Mysql:
<\/p>\n\n\n\n

[php]\n$result = mysqli_query($con,"SELECT * FROM Persons");<\/code>\n\n<code>while($row = mysqli_fetch_array($result)) {\necho $row['FirstName'] . " " . $row['LastName'];\necho "\n";\n}\n[\/php]<\/code><\/pre><\/div>\n\n\n\n
Date:
<\/p>\n\n\n\n
[php]\n$today = date("F j, Y, g:i a"); \/\/ March 10, 2001, 5:16 pm\n$today = date("m.d.y"); \/\/ 03.10.01\n$today = date("j, n, Y"); \/\/ 10, 3, 2001\n$today = date("Ymd"); \/\/ 20010310\n$today = date('h-i-s, j-m-y, it is w Day'); \/\/ 05-16-18, 10-03-01, 1631 1618 6 Satpm01\n$today = date('it is the jS day.'); \/\/ it is the 10th day.\n$today = date("D M j G:i:s T Y"); \/\/ Sat Mar 10 17:16:18 MST 2001\n$today = date('H:m:s m is month'); \/\/ 17:03:18 m is month\n$today = date("H:i:s"); \/\/ 17:16:18\n$today = date("Y-m-d H:i:s"); \/\/ 2001-03-10 17:16:18 (the MySQL DATETIME format)\n[\/php]<\/code><\/pre><\/div>\n\n\n\n
Scan directory:
<\/p>\n\n\n\n
[php]\n$myDirectory = opendir($where);\n\n\/\/ get each entry\nwhile($entryName = readdir($myDirectory)) {\nif ($entryName != "." && $entryName != "..") {\n$dirArray[] = $entryName;\n}\n}\n\/\/ close directory\nclosedir($myDirectory);\n[\/php]<\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"
Here are some of the common php things I use, and always have to look up: Mysql: Date: Scan directory:<\/p>\n","protected":false},"author":2,"featured_media":5538,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[28,17],"tags":[],"class_list":["post-947","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-coding","category-technology","clearfix","post-index"],"acf":[],"jetpack_featured_media_url":"https:\/\/corbinrose.com\/blog\/wp-content\/uploads\/2014\/04\/php-leader-2.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/corbinrose.com\/blog\/wp-json\/wp\/v2\/posts\/947","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/corbinrose.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/corbinrose.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/corbinrose.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/corbinrose.com\/blog\/wp-json\/wp\/v2\/comments?post=947"}],"version-history":[{"count":0,"href":"https:\/\/corbinrose.com\/blog\/wp-json\/wp\/v2\/posts\/947\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/corbinrose.com\/blog\/wp-json\/wp\/v2\/media\/5538"}],"wp:attachment":[{"href":"https:\/\/corbinrose.com\/blog\/wp-json\/wp\/v2\/media?parent=947"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/corbinrose.com\/blog\/wp-json\/wp\/v2\/categories?post=947"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/corbinrose.com\/blog\/wp-json\/wp\/v2\/tags?post=947"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}