{"id":208,"date":"2017-09-02T14:40:46","date_gmt":"2017-09-02T14:40:46","guid":{"rendered":"http:\/\/fraserburghbaptist.co.uk\/wordpress\/?page_id=208"},"modified":"2019-12-28T20:42:02","modified_gmt":"2019-12-28T20:42:02","slug":"rotas","status":"publish","type":"page","link":"https:\/\/fraserburghbaptist.co.uk\/?page_id=208","title":{"rendered":"Rotas"},"content":{"rendered":"

[insert_php]
\n echo “<\/p>\n\n\n
\n

<\/h3>\n<\/td>\n<\/tr>\n<\/table>\n

“;<\/p>\n

echo “<\/p>\n“;
\n\techo “<\/p>\n“;
\n\techo “<\/p>\n\n\n\n
Date<\/b><\/td>\nTable (Prep in UPPERcase)<\/b><\/td>\nDoor<\/b><\/td>\nHymn Books<\/b><\/td>\nMusic<\/b><\/td>\nPowerpoint<\/b><\/td>\nOffering<\/b>“;
\n echo”<\/td>\n

“;
\n\techo “<\/tr>\n

“;<\/p>\n

$servername = “185.136.235.126”;
\n $username = “johnbaptist”;
\n $password = “baptist”;
\n $dbname = “baptist”;<\/p>\n

\/\/ Make connection and then select the database
\n \/\/ Create connection
\n $conn = new mysqli($servername, $username, $password, $dbname);<\/p>\n

if ($conn->connect_error) {
\n die(“Connection failed: ” . $conn->connect_error);
\n } <\/p>\n

\t$str_NextSundayDate = date(‘Y-m-d’, strtotime(‘now’));
\n\t$sql = “SELECT * FROM rotas WHERE sundaydate >= ‘$str_NextSundayDate’ order by sundaydate”;
\n $result = $conn->query($sql);<\/p>\n

\t$gbdate = date(‘d-m-Y\t‘, strtotime(‘next Sunday’));
\n\t$formatteddate = strftime(“%A %d %b %Y”, strtotime($gbdate));
\n\t$i = 1;<\/p>\n

\t$oldMonth = “”;
\n\t$month = “”;<\/p>\n

\tif($result->num_rows > 0){
\n \t\twhile($row = $result->fetch_assoc()) {
\n\t\t\tforeach( $row AS $key => $val ){
\n\t\t\t\t$$key = stripslashes( $val );
\n\t\t\t}
\n\t\t\t$formatteddate = strftime(“%d %b %Y”, strtotime($sundaydate));<\/p>\n

\t\t\t$oldMonth = $month;<\/p>\n

\t\t\t$month = substr($formatteddate, 4, 3);<\/p>\n

\t\t\tif ($oldMonth != $month && ($oldMonth != “”))
\n\t\t\t{
\n\t\t\t\techo “<\/p>\n

 <\/td>\n<\/tr>\n

“;
\n\t\t\t}<\/p>\n

\t\t\t$i++;
\n\t\t\t$mod = $i % 2;<\/p>\n

\t\t\tif ($mod == 1)
\n\t\t\t{
\n\t\t\t\techo “<\/p>\n

$formatteddate<\/td>\n

“;
\n\t\t\t\techo “<\/p>\n

$table1<\/td>\n

“;
\n\t\t\t\techo “<\/p>\n

$door<\/td>\n

“;
\n\t\t\t\techo “<\/p>\n

$books<\/td>\n

“;<\/p>\n

\t\t\t\techo “<\/p>\n

$music<\/td>\n

“;
\n\t\t\t\techo “<\/p>\n

$powerpoint<\/td>\n

“;
\n echo “<\/p>\n

$offering<\/td>\n<\/tr>\n

“;
\n\t\t\t}
\n\t\t\telse
\n\t\t\t{
\n\t\t\t echo “<\/p>\n

$formatteddate<\/td>\n

“;
\n\t\t\t\techo “<\/p>\n

$table1<\/td>\n

“;
\n\t\t\t\techo “<\/p>\n

$door<\/td>\n

“;
\n\t\t\t\techo “<\/p>\n

$books<\/td>\n

“;<\/p>\n

\t\t\t\techo “<\/p>\n

$music<\/td>\n

“;
\n\t\t\t\techo “<\/p>\n

$powerpoint<\/td>\n

“;
\n echo “<\/p>\n

$offering<\/td>\n<\/tr>\n

“;
\n\t\t\t}<\/p>\n

\t\t}
\n\t}
\necho “<\/table>\n

“;
\n[\/insert_php]<\/p>\n","protected":false},"excerpt":{"rendered":"

[insert_php] echo “ “; echo “ “; echo “ “; echo “ Date Table (Prep in UPPERcase) Door Hymn Books Music Powerpoint Offering“; echo” “; echo “ “; $servername = “185.136.235.126”; $username = “johnbaptist”; $password = “baptist”; $dbname = “baptist”; \/\/ Make connection and then select the database \/\/ Create[…]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"template-fullwidth.php","meta":{"footnotes":""},"_links":{"self":[{"href":"https:\/\/fraserburghbaptist.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/208"}],"collection":[{"href":"https:\/\/fraserburghbaptist.co.uk\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/fraserburghbaptist.co.uk\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/fraserburghbaptist.co.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/fraserburghbaptist.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=208"}],"version-history":[{"count":90,"href":"https:\/\/fraserburghbaptist.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/208\/revisions"}],"predecessor-version":[{"id":1125,"href":"https:\/\/fraserburghbaptist.co.uk\/index.php?rest_route=\/wp\/v2\/pages\/208\/revisions\/1125"}],"wp:attachment":[{"href":"https:\/\/fraserburghbaptist.co.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}