connect_error) { //die("Connection failed: " . $conn->connect_error); } if ($_GET['action'] == "click") { if(isset($_GET['amp;banner_id'])) { $_GET['banner_id']=$_GET['amp;banner_id']; } header("location: https://podiatry.com/sponsors/updateBannerClicks/".$_GET['banner_id']); exit; /** $sql = "INSERT INTO `bannerStats` (`banner_id`, `stat_type`, `banner_location`, `display_page`, `user_id`, `display_date`, `user_ip`, `site_domain`) VALUES('" . addslashes($_GET['banner_id']) . "', 'click', '1', '" . addslashes($_SERVER['REQUEST_URI']) . "', '" . $sessions->userdata['user_id'] . "', '" . time() . "', '" . $_SERVER['REMOTE_ADDR'] . "', '" . addslashes($site_name) . "')"; if( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not get ads', '', __LINE__, __FILE__, $sql); } */ $sql2 = "UPDATE bannerSites SET banner_clicks=banner_clicks+1 WHERE banner_id='" . addslashes($_GET['banner_id']) . "'"; $result = $conn->query($sql2); $sql = "SELECT `banner_url`,`banner_id` FROM `bannerAds` WHERE `banner_id` = '" . addslashes($_GET['banner_id']) . "' LIMIT 1"; $result = $conn->query($sql); while($ads = $result->fetch_assoc()) { $row=$ads; } $template->set_filenames(array( 'body' => 'ads/tpl/redirect_with_splash.tpl' )); $template->assign_vars(array( 'REDIRECT_URL' => $row['banner_url'], 'BANNER_ID' => $row['banner_id'], )); $template->pparse('body'); exit(); } $sql = "SELECT id, firstname, lastname FROM MyGuests"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "
"; } } else { echo "0 results"; } $conn->close();