{"id":1687,"date":"2024-06-18T12:40:50","date_gmt":"2024-06-18T16:40:50","guid":{"rendered":"https:\/\/www.survivorlibrary.com\/?page_id=1687"},"modified":"2024-06-26T08:45:34","modified_gmt":"2024-06-26T12:45:34","slug":"checkforbooks","status":"publish","type":"page","link":"https:\/\/www.survivorlibrary.com\/index.php\/checkforbooks\/","title":{"rendered":"Check for Books"},"content":{"rendered":"

\/\/ Simulated form input for the example $year = 2023; $month = ’05’; \/\/ Concatenate into yyyy-mm-01 $date = $year . ‘-‘ . $month . ‘-01’; \/\/ Example database query $mysqli = new mysqli(“localhost”, “username”, “password”, “database”); if ($mysqli->connect_error) { die(“Connection failed: ” . $mysqli->connect_error); } $sql = “SELECT * FROM example WHERE date_column = ‘$date'”; $result = $mysqli->query($sql); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { echo “id: ” . $row[“id”] . ” – Data: ” . $row[“data”] . “”; } } else { echo “0 results”; } $mysqli->close(); \/\/ Example URL $url = “http:\/\/example.com\/do_thing_with_date.php?date=” . urlencode($date); echo $url;<\/p>\n","protected":false},"excerpt":{"rendered":"

\/\/ Simulated form input for the example $year = 2023; $month = ’05’; \/\/ Concatenate into yyyy-mm-01 $date = $year . ‘-‘ . $month . ‘-01’; \/\/ Example database query $mysqli = new mysqli(“localhost”, “username”, “password”, “database”); if ($mysqli->connect_error) { … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"categories":[42],"tags":[],"class_list":["post-1687","page","type-page","status-publish","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/www.survivorlibrary.com\/index.php\/wp-json\/wp\/v2\/pages\/1687","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.survivorlibrary.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.survivorlibrary.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.survivorlibrary.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.survivorlibrary.com\/index.php\/wp-json\/wp\/v2\/comments?post=1687"}],"version-history":[{"count":20,"href":"https:\/\/www.survivorlibrary.com\/index.php\/wp-json\/wp\/v2\/pages\/1687\/revisions"}],"predecessor-version":[{"id":1714,"href":"https:\/\/www.survivorlibrary.com\/index.php\/wp-json\/wp\/v2\/pages\/1687\/revisions\/1714"}],"wp:attachment":[{"href":"https:\/\/www.survivorlibrary.com\/index.php\/wp-json\/wp\/v2\/media?parent=1687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.survivorlibrary.com\/index.php\/wp-json\/wp\/v2\/categories?post=1687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.survivorlibrary.com\/index.php\/wp-json\/wp\/v2\/tags?post=1687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}