<?php require "settings.php"; if (isset($_POST["key"])) { $OUTPUT = write_details($_POST); } else { $OUTPUT = get_details($_POST); } $OUTPUT .= "\n\t\t\t\t<p>\n\t\t\t\t<table border=0 cellpadding='2' cellspacing='1'>\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t<th>Quick Links</th>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td><a href='branches-add.php'>Add Branch</a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td><a href='branches-view.php'>View Branches</a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t\t<tr class='" . bg_class() . "'>\n\t\t\t\t\t\t<td><a href='main.php'>Main Menu</a></td>\n\t\t\t\t\t</tr>\n\t\t\t\t</table>"; require "template.php"; function get_details($_POST, $err = "") { extract($_POST); if (!isset($branch_name)) { $branch_name = ""; } if (!isset($branch_desc)) { $branch_desc = ""; } if (!isset($branch_contact)) { $branch_contact = ""; } if (!isset($branch_ip)) { $branch_ip = ""; } if (!isset($branch_username)) { $branch_username = ""; } if (!isset($branch_password)) { $branch_password = ""; }
$no_2 = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['no_2']))); $no_2_source = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['no_2_source']))); $no_2_url = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['no_2_url']))); $no_3 = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['no_3']))); $no_3_source = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['no_3_source']))); $no_3_url = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['no_3_url']))); $song_2 = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['song_2']))); $sm_1 = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['sm_1']))); $sm_2 = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['sm_2']))); $sm_3 = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['sm_3']))); $song_3 = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['song_3']))); $ptws_song_1 = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['ptws_song_1']))); $ptws_song_2 = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['ptws_song_2']))); $wt_study = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['wt_study']))); $ptws_song_3 = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['ptws_song_3']))); $details_msg =& write_details($monday, $song_1, $cbs, $cbs_url, $bible_read, $no_1, $no_2, $no_2_source, $no_2_url, $no_3, $no_3_source, $no_3_url, $song_2, $sm_1, $sm_2, $sm_3, $song_3, $ptws_song_1, $ptws_song_2, $wt_study, $ptws_song_3); } $ptws_query = "SELECT *\n\tFROM ptws_detail\n\tWHERE week_of = '{$monday}'"; $ptws_r = mysqli_query($dbc, $ptws_query) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nptws_query: {$ptws_query}"); while ($ptws_row = mysqli_fetch_array($ptws_r)) { $ptws_song_1 = $ptws_row['ptws_song_1']; $ptws_song_2 = $ptws_row['ptws_song_2']; $wt_study = $ptws_row['wt_study']; $ptws_song_3 = $ptws_row['ptws_song_3']; } $cts_detail_query = "SELECT * FROM cts_detail WHERE week_of = '{$monday}'"; $cts_r = mysqli_query($dbc, $cts_detail_query) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\ncts_query: {$cts_detail_query}"); while ($cts_row = mysqli_fetch_array($cts_r)) { $song_1 = $cts_row['song_1']; $cbs = $cts_row['cbs']; $cbs_url = $cts_row['cbs_url'];