|
PHP - Issues With Displaying If Else Echo Statement In Contact Page..
Here's the code, this is the PHP in my html contacts page (that IS in fact saved with a PHP extension):
<div class = "centercontainer"> Similar TutorialsMy Contact form subscripltion works put does not echo to subscriber that message has been sent..I am not sure how to get the response message to display on page after subscribing. Here is my my html code
<?php
if (isset($_POST['submit'])) {
$name = $_POST['name'];
$email = $_POST['email'];
$message = $_POST['msg'];
$mailto = "support@playkenyamusic.com";
$headers = "From: ".$email;
$headers .= "Cc: djboziah@gmail.com \r\n";
$txt = "You have a message From ".$name.".\n\n".$message;
mail($mailto, $email, $txt, $headers);
echo $_POST["msg"];
if(!$email->send())
{
echo "Mailer Error: " . $email->ErrorInfo;
}
else
{
echo "Message has been sent successfully";
}
header("Location: form-to-email.php?emailsent");
}
?>
Ok guys first off I am a amateur porn star and having coding issues. I am on a web-server and personally have not issues when I test my contact page. However if anyone else test the site it never comes through? The code is broken into two php pages and I have just posted the second page for review. If anyone can shed light on this I would be greatly appreciated!! I do know there are some missing stuff in the verified section but that will not affect it going through the mail.....lol <h3 align="center"><?php if(isset($_POST['email'])) { // EDIT THE 2 LINES BELOW AS REQUIRED $email_to = "info@elaysmith.com"; $email_subject = "Pick 3 Special"; function died($error) { // your error code can go here echo "We are very sorry, but there were error(s) found with the form you submitted. "; echo "These errors appear below.<br /><br />"; echo $error."<br /><br />"; echo "Please go back and fix these errors.<br /><br />"; die(); } // validation expected data exists if(!isset($_POST['email']) || !isset($_POST['vid1']) || !isset($_POST['vid2']) || !isset($_POST['vid3'])) { died('We are sorry, but there appears to be a problem with the form you submitted.'); } $email_from = $_POST['email']; // required $vid1 = $_POST['vid1']; // required $vid2 = $_POST['vid2']; // required $vid3 = $_POST['vid3']; // required $error_message = ""; $email_exp = "^[A-Z0-9._%-]+@[A-Z0-9.-]+\.[A-Z]{2,4}$"; if(!eregi($email_exp,$email_from)) { $error_message .= 'The Email Address you entered does not appear to be valid.<br />'; } if(strlen($error_message) > 0) { died($error_message); } $email_message = "Form details below.\n\n"; function clean_string($string) { $bad = array("content-type","bcc:","to:","cc:","href"); return str_replace($bad,"",$string); } $email_message .= "First Name: ".clean_string($first_name)."\n"; $email_message .= "Email: ".clean_string($email_from)."\n"; $email_message .= "Video 1: $vid1 \n"; $email_message .= "Video 2: $vid2 \n"; $email_message .= "Video 3: $vid3 \n"; // create email headers $headers = 'From: '.$email_from."\r\n". 'Reply-To: '.$email_from."\r\n" . 'X-Mailer: PHP/' . phpversion(); @mail($email_to, $email_subject, $email_message, $headers); ?> <!-- include your own success html here --> Thank you for using my pick 3 Special <?php Welcome member. I am able to get data added to my db and when it gets to the welcome page I want it to welcome $firstname but it comes up blank. How can I fix my echo statement. <?php session_id(); session_start(); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Welcome</title> </head> <body> <?php /* Program: New_member.php * Desc: Displays the new member welcome page. Greets * member by name and gives a choice to enter * restricted section or go back to main page. */ if (@$_SESSION['auth'] != "yes") @include('Connections/connect_to_mysql.php'); $result = mysql_query("SELECT firstname FROM `Members` WHERE id='{$_SESSION['id']}'"); $row = mysql_fetch_array($result); echo "<html> <head><title>New Member Welcome</title></head> <body> <h2 style='margin-top: .7in; text-align: center'> Welcome, $firstName </h2>\n"; ?> <p>Your new Member accounts lets you enter the members only section of our web site. You'll find special discounts, a profile of matches, live advise for experts, and much more.</p> <p>Your new Member ID and password were emailed to you. Store them carefully for future use.</p> <div style="text-align: center"> <p style="margin-top: .5in; font-weight: bold"> Glad you could join us!</p> <form action="profile.php" method="post"> <input type="submit" value="Enter the Members Only Section"> </form> <form action="index.php" method="post"> <input type="submit" value="Go to Main Page"> </form> </div> </body> </html> I am having a problem echoing a line of code. I am doing this on my local machine. Anyway, here are the to files involved... home.php <?php include $_SERVER['DOCUMENT_ROOT'] . '/includes/helpers.inc.php'; include $_SERVER['DOCUMENT_ROOT'] . '/includes/doctype.inc.php'; include $_SERVER['DOCUMENT_ROOT'] . '/includes/head.inc.php'; ?> </head> <body> <div id="wrapper"> <!-- start horizontal navigation --> <?php include $_SERVER['DOCUMENT_ROOT'] . '/includes/topnav.inc.php'; ?> <!-- end horizontal navigation --> <div id="content"> <h1><?php echo htmlout($cattitle); ?></h1> <span class="desc"><?php echo ($catdesc); ?></span> <?php include $_SERVER['DOCUMENT_ROOT'] . '/info.php'; ?> </div> <!-- start footer --> <?php include $_SERVER['DOCUMENT_ROOT'] . '/includes/footer.inc.php'; ?> <!-- end footer --> </div> </body> </html> and info.php <?php $result = mysqli_query($link, 'SELECT * From includes where catid ='.$_GET['id']); if (!$result) { $error = 'Error getting categories: ' . mysqli_error($link); include 'error.php'; exit(); } while ($row = mysqli_fetch_array($result)) { $inc[] = array('id' => $row['id'], 'include' => $row['include'], 'inc_orderby' => $row['inc_orderby'], 'inc_avail' => $row['inc_avail']); } foreach ($inc as $include): { echo "include $_SERVER['DOCUMENT_ROOT'] . '/includes/' . $row['include'];"; } endforeach; ?> I can't get the echo statement at the bottom of info.php echo "include $_SERVER['DOCUMENT_ROOT'] . '/includes/' . $row['include'];"; to show up correctly on the home.php page in this spot. include $_SERVER['DOCUMENT_ROOT'] . '/info.php'; what i am attempting to do is loop through some additional information relevant to the page a user selects on the site and display it. (I still have to set up some qualifying statements but this was just the first step to see if anything would show up) This is the parse error I get. Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\info.php on line 18 I've tried messing with the quotes in the echo statement cause I'm sure they aren't right but I never came up with a quote combination that worked. I'm assuming that is the problem. Anyway thanks for taking a look. Ok, this is the situation, I have a form to email script installed on my website, (im not the best with PHP but im learning) I managed to adapt the main contact form to meet my needs however i am now having a few probs, basically the script i am using is IBDhost Contact Form. The basic code consits of 4 fields, name field, email field, subject dropdown box and message text box. On my site i need to adapt the form to incorporate additional fields, which are for the first form..... name field (compulsory), COMPANY name field (non compulsory), valid email (compulsory), contact number (compulsory), Department dropdown box ( i want this to determin what mailbox the message gets sent to, so rather than just 1 email address for all messages to go to, i want the user to determine where the email goes through a variety of email address options) and the main message text box. The second difference i need is for a different page, using the same form, but with different fields, Name field (compulsory), Contact Number (compulsory) email address (compulsory) message text box area(non compulsory) and an attachment upload field. I need the attachment upload to be able to do 1 of 2 things, either send the attachment along with the email, OR upload the email to a directory on my server BUT have the form details include a link to the form when i receive it. basically it will be used for C.V uploads for jobs. The code i am using is shown below ... FORM CODE: Code: [Select] <form method="post" action="sendeail.php"> <!-- DO NOT change ANY of the php sections --> <?php $ipi = getenv("REMOTE_ADDR"); $httprefi = getenv ("HTTP_REFERER"); $httpagenti = getenv ("HTTP_USER_AGENT"); ?> <input type="hidden" name="ip" value="<?php echo $ipi ?>" /> <input type="hidden" name="httpref" value="<?php echo $httprefi ?>" /> <input type="hidden" name="httpagent" value="<?php echo $httpagenti ?>" /> Full Name: <br /> <input type="text" name="visitor" size="35" /> <br /> Valid Email:<br /> <input type="text" name="visitormail" size="35" /> <br /> Contact Number:<br /> <input type="text" name="visitorcontactnumber" size="35" /> <br /> <!-- BELOW IS WHERE I WANT THE USER TO BE ABLE TO PICK A DEPARTMENT BUT INSTEAD OF THAT BEING THE ATTENTION TO SUBJECT, I WANT IT TO SEND IT TO THE RELEVENT EMAIL ADDRESS --> Attention:<br /> <select name="attn" size="1"> <option value=" Administration ">Administration </option> <option value=" Existing Clients ">Clients (existing) </option> <option value=" New Client Enquiry ">Clients (new) </option> <option value=" Director Of Sales And Marketing ">Sales Director </option> <option value=" General Enquiries ">General Enquiries </option> <option value=" Site Support ">Site Support </option> <option value=" Recruitment ">Recruitment </option> <option value=" Web Master ">Webmaster </option> </select> <br /><br /> Message (please include company details if a client): <br /> <textarea name="notes" rows="6" cols="60"></textarea> <br /> <input type="submit" value="Send Mail" /> <br /> </form> SENDEAIL.php code Code: [Select] <?php $ip = $_POST['ip']; $httpref = $_POST['httpref']; $httpagent = $_POST['httpagent']; $visitor = $_POST['visitor']; $visitormail = $_POST['visitormail']; $visitorcontactnumber = $_POST['visitorcontactnumber']; $attn = $_POST['attn']; $notes = $_POST['notes']; if (eregi('http:', $notes)) { die ("Do NOT try that! ! "); } if(!$visitormail == "" && (!strstr($visitormail,"@") || !strstr($visitormail,"."))) { echo "<h2>Use Back - Enter valid e-mail</h2>\n"; $badinput = "<h2>Your message was NOT submitted</h2>\n"; echo $badinput; die ("Go back! ! "); } if(empty($visitor) || empty($visitormail) || empty($visitorcontactnumber) || empty($notes )) { echo "<h2>Use Back - fill in all fields</h2>\n"; die ("Use back! ! "); } $todayis = date("l, F j, Y, g:i a") ; $attn = $attn ; $subject = $attn; $notes = stripcslashes($notes); $message = " $todayis [EST] \n Attention: $attn \n Message: $notes \n From: $visitor ($visitormail)\n Additional Info : IP = $ip \n Browser Info: $httpagent \n Referral : $httpref \n "; $from = "From: $visitormail\r\n"; mail("me@myemail.net", $subject, $message, $from, $visitorcontactnumber); ?> <p align="center"> Date: <?php echo $todayis ?> <br /> Thank You : <?php echo $visitor ?> ( <?php echo $visitormail ?> ) <br /> Attention: <?php echo $attn ?> <br /> Message:<br /> <?php $notesout = str_replace("\r", "<br/>", $notes); echo $notesout; ?> <br /> <?php echo $ip ?> <br /><br /> <a href="contact.php"> Back </a> </p> the only problem i have with the form i have adapted so far is that all the details are coming through on the message to my email apart from the additional field (contact number) so im obviously missing something there as well. I would really appreciate any help. And i hope in the future i can assist someone on here too. Good evening, I'm having some issues with a PHP "contact us" script. I'm hoping there may be someone on the board that can shed some light on what is going on. The only recent change to the script is that the server was upgraded from PHP4 to PHP5. I'm not even sure if that is related, as I can't specifically identify that this issue started at the same time as that upgrade. The form is emailing, however the area where the fields should be displaying in the email message are all blank. Without further ado...here's the HTML page containing the form: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> <meta name="description" content="Request additional information about Civil Air Patrol services offered, membership opportunities, or general questions."> <meta name="keywords" content="Civil Air Patrol. United States Air Force, Cadet Program, Aerospace Education, Cadet Programs" /> <meta name="author" content="http://www.squadron282.com" /> <link rel="stylesheet" type="text/css" media="screen,projection" href="./css/style_screen.css" /> <link rel="stylesheet" type="text/css" media="print" href="./css/style_print.css" /> <title>CIVIL AIR PATROL SQUADRON 282 - Contact Us</title> <style type="text/css"> <!-- .style1 { font-size: 14 } .style2 {font-size: 10px} .style12 {font-size: 12px} --> </style> </head> <body> <div class="page-container-1"> <!-- HEADER --> <!-- Flag navigations --> <!-- Navigation Level 1 --> <!-- Sitename --> <!-- Site slogan --> <!-- Header banner --> <div><img class="img-header" src="files/header6.jpg" alt="Wright Brothers 282nd Aero Composite Squadron - Civil Air Patrol"/></div> <!-- Navigation Level 2 --> <div class="nav2"> <ul> <li style="border-left: solid 1px rgb(54,83,151)"><a href="index.html" class="multi_line">GLR-OH-282 HOMEPAGE</a></li> <li><a href="missions.html" class="multi_line">SQUADRON MISSIONS</a></li> <li><a href="sqinfo.html" class="multi_line">SQUADRON INFO</a></li> <li><a href="sqmeetings.html" class="multi_line">SQUADRON MEETINGS</a></li> <li><a href="sqcalendar.html" class="multi_line">SQUADRON CALENDAR</a></li> <li><a href="membership.html" class="multi_line">SQUADRON MEMBERSHIP</a></li> <li><a href="commanderscorner.html" class="multi_line">SQUADRON COMMAND</a></li> <li><a href="gallery/main.php" class="multi_line">PHOTO GALLERY</a></li> <li><a href="contactus.html" class="selected multi_line">REQUEST MORE INFO</a></li> <li><a href="sitemappublic.html" class="multi_line"> WEBSITE MAP</a></li> </ul> </div> <!-- Buffer after header --> <div class="buffer"></div> <!-- NAVIGATION --> <!-- Navigation Level 3 --> <div class="nav3"> <ul> <li class="title">CONTACT US</li> <li class="group"><a href="contactus.html" class="selected">Contact Us</a></li> <li class="group"><a href="faqs.html">FAQ's</a></li> </ul> <!-- Print, Email, Bookmark Section --> <!-- ADDTHIS BUTTON BEGIN --> <div class="nav3"> <ul> <li class="title">SITE UTILITES</li> <center> <script type="text/javascript"> var addthis_config = { username: "CAPOH282" ui_cobrand: "CAP OH282" } </script> <div class="addthis_toolbox"> <div class="vertical"> <a class="addthis_button_email">Email</a> <a class="addthis_button_print">Print</a> <a class="addthis_button_favorites">Bookmark</a> <a class="addthis_button_twitter">Twitter</a> <a class="addthis_button_facebook">Facebook</a> <a class="addthis_button_myspace">MySpace</a> <a class="addthis_button_digg">Digg</a> <a class="addthis_button_expanded">More...</a> </div> </div> <script type="text/javascript" src="http://s7.addthis.com/js/250/addthis_widget.js"></script> </center> </ul> </div> </div> <!-- ADDTHIS BUTTON END --> <!-- CONTENT --> <div class="content1"> <!-- Page title --> <div class="content1-pagetitle"> <p class="content-subtitle-noshade-size1 style1">CONTACT US<br /> </div> <div class="content1-container"> <table width="90%" border="0" align="center" cellpadding="0"> <tr> <td><form method="post" action="contactmailer.php"> <h2 align="justify">We would love to hear from you! If you are interested in what Civil Air Patrol has to offer, want to leave feedback on the website, or have questions, we are interested! Please feel free to call us at (937) 985-2820 or complete the form below and we will be glad to assist you in any way possible. For immediate answers to some of the most commonly asked questions, please check out our <a href="faqs.html">Frequently Asked Questions</a> page.</h2> <p align="justify">Please fill out as much of the following information as you care to share with us:</p> <table width="600" border="0" align="center" cellpadding="0"> <tr> <td width="250"><div align="left"> <h6>Name:</h6> </div></td> <td width="350"><div align="left"> <input type="text" name="name" size="40" /> </div></td> </tr> <tr> <td width="250"><div align="left"> <h6>Email:</h6> </div></td> <td width="350"><div align="left"> <input type="text" name="email" size="40" /> </div></td> </tr> <tr> <td width="250"><div align="left"> <h6>Address:</h6> </div></td> <td width="350"><div align="left"> <input type="text" name="address" size="40" /> </div></td> </tr> <tr> <td width="250"><div align="left"> <h6>City:</h6> </div></td> <td width="350"><div align="left"> <input type="text" name="city" size="40" /> </div></td> </tr> <tr> <td width="250"><div align="left"> <h6>State:</h6> </div></td> <td width="350"><div align="left"> <input name="state" type="text" size="4" maxlength="2" /> </div></td> </tr> <tr> <td width="250"><div align="left"> <h6>Zip:</h6> </div></td> <td width="350"><div align="left"> <input name="zip" type="text" size="7" maxlength="5" /> </div></td> </tr> <tr> <td width="250"><h6>Phone:</h6></td> <td width="350"><input name="phone" type="text" size="14" maxlength="12" /></td> </tr> <tr> <td width="250"><div align="left"> <h6>Time To Contact:</h6> </div></td> <td width="350"><div align="left"> <input type="text" name="timetocontact" size="40" /> </div></td> </tr> <tr align="left" valign="top"> <td width="250"><div align="left"> <h6> Program of Interest:</h6> </div></td> <td width="350"><p> <input type="checkbox" name="check[]" value="cadetprogram" /> Cadet Programs (Youth)<br /> <input type="checkbox" name="check[]" value="seniorprogram" /> Senior Programs (Adult)<br /> <input type="checkbox" name="check[]" value="patronprogram" /> Patron Membership<br /> <input type="checkbox" name="check[]" value="unsureonprogram" /> Unsure<br /> </p></td> </tr> <tr align="left" valign="top"> <td width="250"><div align="left"> <h6>Areas of Interest:<br /> (check all that apply)</h6> </div></td> <td width="350"><div align="left"> <p> <input type="checkbox" name="check[]" value="areaadmin" /> Administration<br /> <input type="checkbox" name="check[]" value="areaaerospace" /> <a href="missionsaerospace.html">Aerospace Education</a><br /> <input type="checkbox" name="check[]" value="areacadetprograms" /> <a href="missionscadet.html">Cadet Programs</a><br /> <input type="checkbox" name="check[]" value="areachaplain" /> Chaplain / Moral Leadership<br /> <input type="checkbox" name="check[]" value="areacommunications" /> <a href="missionses.html">Communications and Radios</a> <br /> <input type="checkbox" name="check[]" value="areadrillteam" /> Drill Team / Colorguard Activities<br /> <input type="checkbox" name="check[]" value="areaemergencyservices" /> <a href="missionses.html">Emergency Services / Search and Rescue</a><br /> <input type="checkbox" name="check[]" value="areaflightoperations" /> Flight Operations<br /> <input type="checkbox" name="check[]" value="areaphysicalfitness" /> Physical Fitness Training<br /> <input type="checkbox" name="check[]" value="arearecruiting" /> Public Affairs<br /> <input type="checkbox" name="check[]" value="areasafety" /> Safety<br /> <input type="checkbox" name="check[]" value="areaunsure" /> Unsure <br /> </p> </div></td> </tr> <tr> <td width="250" height="82" valign="middle"><h6>Comments:</h6></td> <td width="350"><p> <textarea name="comments" cols="50" rows="6"></textarea> </p></td> </tr> <tr> <td width="250"> <h6> <input type="submit" value="Submit Your Request" name="submit" /> </h6></td> <td width="350"> </td> </tr> </table> </form></td> </tr> </table> <p> </p> <p> </p> <!-- Nav Foorter --> <td height="55" valign="top"> <div align="center"> <p align="center"> <em><strong>PUBLIC INFORMATION</strong></em><br /> <a href="index.html">GLR-OH-282 HOMEPAGE</a> | <a href="missions.html">SQUADRON MISSIONS</a> | <a href="sqinfo.html">SQUADRON INFO</a> |<br /> <a href="sqmeetings.html">SQUADRON MEETINGS</a> | <a href="sqcalendar.html">SQUADRON CALENDAR</a> | <a href="membership.html">SQUADRON MEMBERSHIP</a> | <br /> <a href="commanderscorner.html">SQUADRON COMMAND</a> | <a href="/gallery/main.php">PHOTO GALLERY</a> | <a href="contactus.html">REQUEST MORE INFO</a> | <a href="sitemappublic.html">WEBSITE MAP</a><br /><br /> <em><strong>MEMBER RESOURCES</strong></em><br /> <a href="members.php">MEMBER RESOURCES</a> | <a href="resourcesaeroed.html">AEROSPACE EDUCATION</a> | <a href="resourceses.html">EMERGENCY SERVICES</a> | <br /> <a href="resourcescadet.html">CADET PROGRAMS</a> | <a href="resourcesofficer.html">OFFICER PROGRAM</a> | <a href="trainingnewmember.html">NEW MEMBERS</a> | <a href="resourcesuniforms.html">UNIFORM RESOURCES</a> |<br /> <a href="resourcesstaff.html">ADDITIONAL RESOURCES</a> | <a href="resourcesevents.html">ACTIVITY REGISTRATION</a> | <a href="sitemapmembers.html">WEBSITE MAP</a> </p> </div></td> </div> </div> <!-- SIDEBAR --> <!-- Empty sidebar: By adding "hide" to the class statement the sidebar becomes hidden --> <div class="sidebar hide"> </div> <!-- FOOTER --> <div class="footer"> <p><b>Copyright © 2010 Wright Brothers 282nd Aero Composite Squadron | All Rights Reserved</b></p> <p><span class="style12">LINKS OR REFERENCES TO INDIVIDUALS OR COMPANIES DOES NOT CONSTITUTE AN ENDORSEMENT OF ANY INFORMATION, <br />PRODUCT, OR SERVICE YOUR MAY RECEIVE FROM SUCH SOURCES. SITE MANAGED BY MAJ VECCHI. </span></p> </div> </div> </body> </html> And here is the PHP script that is driving the output: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><br> <html> <head> <title>CIVIL AIR PATROL - WRIGHT BROS 282ND AERO COMPOSITE SQUADRON</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <?php if(isset($_POST['submit'])) { $to = "cvecchi@squadron282.com"; $headers = 'From: CONTACT@SQUADRON282.COM' . "\r\n"; $subject = "Squadron282.com Contact Form"; $name_field = "$name"; $email_field = "$email"; $message = $_POST['message']; foreach($_POST['check'] as $value) { $check_msg .= "Checked: $value\n"; } $body = "Name: $name_field\n Email: $email_field\n Street: $address\n City: $city\n State: $state\n Zip: $zip\n Phone: $phone\n Time To Contact: $timetocontact\n $check_msg\n Comments: $comments\n"; echo "Your Information has been submitted to Squadron 282!"; mail($to, $subject, $body, $headers); } else { echo "There was an error in your submission, please resubmit."; } ?> <script language=javascript> setTimeout("location.href='contactthanks.html'", 0000); </script> </body> </html> If anyone could shed some light on this issue, I'd appreciate it! Thanks, Chris I have been reading all day on this, and yet I still am not getting it correct. I have read a handful of posts on here and other places and i'm about to pull my hair out, I finally made everything and it's working I just need the IP address to display when they submit their contact information. <p style: align="center"><form action="mail.php" method="POST"> <?php $ipi = getenv("REMOTE_ADDR"); $httprefi = getenv ("HTTP_REFERER"); $httpagenti = getenv ("HTTP_USER_AGENT"); ?> <input type="hidden" name="ip" value="<?php echo $ipi ?>" /> <input type="hidden" name="httpref" value="<?php echo $httprefi ?>" /> <input type="hidden" name="httpagent" value="<?php echo $httpagenti ?>" /> <div align="center"> <p class="style1">Name</p> <input type="text" name="name"> <p class="style1">Email</p> <input type="text" name="email"> <p class="style1">Phone</p> <input type="text" name="phone"> <p class="style1">Debtor</p> <input type="text" name="debtor"> <br /> <br /> <p class="style1">I hear by agree that the information I have provided is true, accurate and the information I am submitting is <br /> not fraudulent. Please click the agree button that you adhere to Commercial Recovery Authority Inc.'s terms:</p> <select name="agree" size="1"> <option value="Agree">Agree</option> <option value="Disagree">Disagree</option> </select> <br /> <br /> <p class="style1">Employee ID:</p> <input type="text" name="employee"> <br /> <input type="submit" value="Send"><input type="reset" value="Clear"> </div> </form> and then the mail.php form is <?php $ip = $_POST['ip']; $httpref = $_POST['httpref']; $httpagent = $_POST['httpagent']; $name = $_POST['name']; $email = $_POST['email']; $phone = $_POST['phone']; $debtor = $_POST['debtor']; $agree = $_POST['agree']; $employee = $_POST['employee']; $formcontent=" From: $name \n Email: $email \n Phone: $phone \n Debtor: $debtor \n I hear by agree that the information I have provided is true, accurate and the information I am submitting is not fraudulent. Please click the agree button that you adhere to Commercial Recovery Authority Inc.'s terms: $agree \n Employee ID: $employee \n IP: $ip"; $recipient = "mail@crapower.com"; $subject = "Online Authorization Form"; $mailheader = "From: $email \r\n"; mail($recipient, $subject, $formcontent, $mailheader) or die("Error!"); echo "Thank You!" . " -" . "<a href='index.php' style='text-decoration:none;color:#ffcb00;'> Return Home</a>"; $ip = $_POST['visitoraddress'] ?> I need help Hello,
I am working on this function that echo's out images from my database restricted to 10 images with 4 default images if the database is empty.
<?php
$query = mysql_query('SELECT image_id, image_expiry FROM images ORDER BY RAND() LIMIT 10');
$i = 0;
class myCounter3 implements Countable {
public function count() {
static $count = 0;
return ++$count;
}
}
$counter = new myCounter3;
while ($row = mysql_fetch_array($query))
{
if($i % 10 === 0)
{
}
echo '<img src="http://www.mysite.com/'.$row['image_id'].'.jpg" width="300" height="auto"/>';
$i++;
}
for (; $i <= 4; $i++) {
echo '<img src="http://www.mysite.com/default.jpg" width="300" height="auto"/>'
}
?>
I need to include an image expiry function with the function above, but I am not sure how to properly include it.
Here is my planned expiry function (each image as an expiry date).
$today = date("Y-m-d", time());
$expiry = $row['image_expiry']
if( $today > $expiry)
{
## ignore expired image
}
else
{
## display image
}
Bottom line I need to exclude expired images from being echoed out in the first function.
Thanks in advance. Everything I have tried hasn't worked.
Hello guys im new to php i been coding for like a week now, i need some help here i have been stuck for like 6 hours XD,is it possible to write an IF Statement inside an echo? //this is what i want to do // echo a table and a delete button // and if you click on the delete button it echoes out "DELETED" echo " <table width='528px'> <tr> <td> </td> <td> <center><font size='5'>$tittle</font></center><br> </td> </tr> <tr> <td> </td> <td> $message </td> </tr> <tr> <td> </td> <td> <font size='1'>Posted By:<font color='green'>$author</font> on <font color='gray'>$date</font> at <font color='gray'>$time</font></font> <input id='delete' name='delete' type='submit' value='Delete' > if ($_POST['delete']) { echo "DELETED"; } <td> </td> </tr><br><br> </table> "; Hey, I posted a thread before about a news cms I've been developing. And right now I'm trying to flesh out the css of the articles I post on the home page. Now the problem I having is everytime I place a <span class=""></span> or <p class=""></p> or even <div class=""></div>, my web page does NOT load, and instead gives me an error. Code: [Select] Parse error: syntax error, unexpected T_STRING in /home/content/d/j/s/djsmiley/html/index.php on line 405 Now, I know it's possible to add css to a PHP echo statement, but I'm clearly doing something wrong. Here's the code for the php echo statement with the css included: Code: [Select] <? include("dbconnect.php"); //include the file to connect to the database $getnews = mysql_query("SELECT * FROM mynews ORDER BY id DESC"); //query the database for all of the news while($r=mysql_fetch_array($getnews)){ //while there are rows in the table extract($r); //remove the $r so its just $variable echo("<br><span class="NewsID">$type</span> <span class=h2>$title</span><br><br> <em>posted by <strong>$user</strong> | added on $time</em><br><br> $message<br><br> <label class="fltlft2"><img src="../../Websites/DJSmiley.Net/images/Icons/Arrows/Right.png" width="20" height="20"/></label><a href=$url>Read more - $url</a> <div class="newsLikeShareRate"> <table width="100%" border="0"> <tr> <td width="3%" height="21"><script src="http://connect.facebook.net/en_US/all.js#xfbml=1"></script> <fb:like href="$url" show_faces="true" width="450" font="arial"></fb:like> </td> <td width="65%"><a name="fb_share" id="fb_share4" type="icon_link" share_url="$url">Share</a> <script src="http://static.ak.fbcdn.net/connect.php/js/FB.Share" type="text/javascript"></script></td> <td width="32%">Rate this article: </td> </tr> </table> </div>"); } ?> If you're wondering why there's a facebook script in there, I made it to where everytime a new post is added, a facebook like and share button are added, and are assigned the url I specify when the article is posted. Well, I think that's it for the code. Can anyone tell me what I'm doing wrong? I am using the Twitch API to tell if a user is live. I'm new to the Twitch API and PhP so please forgive me if I make any mistakes. Expand the Spoiler tags below to see the code. The code below SHOULD be telling me if a channel is not live or not. It tells me if they are live, but not if they are not live. I don't understand.
Spoiler
<?php
if (!empty($_GET['channel']))
{
$channel = $_GET['channel'];
$dataArray = json_decode(@file_get_contents('https://api.twitch.tv/kraken/streams?channel='.$channel), true);
foreach ((array) $dataArray['streams'] as $mydata)
{
if (!empty($mydata['_id']))
{
echo "Channel is live<br><br>";
$uptime = $mydata['created_at'];
$uptime = str_replace("Z", "UTC", $uptime);
$uptime = preg_replace("/T/", "", $uptime, 1);
echo "Twitch Uptime: ".$uptime."<br />";
date_default_timezone_set('UTC');
$localUptime = date('Y-m-dh:i:sT', time());
echo "UTC Local Time: ".$localUptime;
}
else
{
echo "Channel is not live";
}
}
} else {
echo "No channel";
}
?>
I want to add a space after $item in the below statement so that there is more space between the output of Item and Qty. Code: [Select] echo("<p class=\"commentboxContainer\"><table width=100% border=0> <tr> <td bgcolor=\"#EEE\"><strong><p class=fltlft>$name </strong>says:</p></td> </tr> </table> <table width=100% border=0 bgcolor=\"#EEE\"> <tr> <td width=40%><img src=../images/Icons/People/Anonymous.png width=64 height=64 border=1 /></td> <td width=60%>$comment',0,6</td> </tr> </table> <table width=100% border=0> <tr> <td bgcolor=\"#EEE\" ><p class=fltlft><em>$email</em></p></td> </tr> <tr> <td bgcolor=\"#EEE\" ><p class=fltlft>added on $time</p></td> </tr> </table></p><br>"); Here's my echo statement for displaying comments by users. I want to add a substr (); function to limit the amount of characters of the $comment field. That way if a user makes a long comment it doesn't push the page down. I tried putting it after the echo (); but that didn't work. I also tried putting it before $comment and that didn't even work. I know that if I make two separate echo statements, this can be done, but the field "$comment" is displayed within a table that is part of the original echo statement, so what do I do? I have to put a link that can be clicked around the first name and last name variables in the echo statement below. I also need to add a variable from the Select query to the link such as: 'www.phpfreaks.com/admin/customers.php?page=1&cID="VARIABLE HERE" &action=edit' I've tried a bunch of things and none seem to work. while($row = mysql_fetch_array($result)){ echo '<tr><td>' . $row['customers_firstname'] . " " . $row['customers_lastname'] . '</td><td>' . date("M. d, Y", strtotime($row['date'])) . '</td><td>' . $row['plan_id'] . '</td></tr>'; David // Other code //echo "<table border='10' cellpadding='3' cellspacing='2'>"; This works echo "<table class="my-table">"; //This does not work echo "<tr><th>First Name</th><th>Last Name</th><th>Home Phone</th><th>Cell Phone</th><th>email</th></tr>"; // keeps getting the next row until there are no more to get ================ while($row = mysql_fetch_array( $result )) { // Print out the contents of each row into a table ========================== echo "<tr><td>"; echo $row['first']; echo "</td><td>"; echo $row['last']; echo "</td><td>"; echo $row['phone']; echo "</td><td>"; echo $row['cell']; echo "</td><td>"; echo $row['email']; echo "</td></tr>"; } echo "</table>"; ?> Error message: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/bayare27/public_html/content/pages/display_all_members1.php on line 29 Line 29 is: echo "<table class="my-table">"; <table class="my-table">" is a valid statement because It works in another program, but html not php Hi: I have few small issues with a Contact Us form I am putting together. 1 - When quotes or apostrophes are added to the input fields, they get turned into '\ (slashes). The "myCodeLib.php" file has a function to remove the slashes. I use it in the same way in the admin area and it works fine, so I don't see what I am missing: Code: [Select] <?php //STRIP SLASHES if(get_magic_quotes_gpc()) { $_POST = array_map('stripslashes',$_POST); $_GET = array_map('stripslashes',$_GET); $_COOKIE = array_map('stripslashes',$_COOKIE); } ?> 2 - A small issuse, but the Email validation doesn't seem to work entirely. It will accept a single character (like an "a") as valid, but it looks like it's suppose to check for a format like "a@a.com" 3 - How can I properly SPAN this code that write out the error: Code: [Select] echo $error; I want to do Code: [Select] <span class="textError">echo $error;</span> to make it red but I keep getting a snytax error This is the full code: Code: [Select] include('include/myConn.php'); include('include/myCodeLib.php'); <?php $error = NULL; $myDate = NULL; $FullName = NULL; $Address = NULL; $City = NULL; $State = NULL; $Zip = NULL; $Phone = NULL; $Email = NULL; $Website = NULL; $Comments = NULL; if(isset($_POST['submit'])) { $myDate = $_POST['myDate']; $FullName = $_POST['FullName']; $Address = $_POST['Address']; $City = $_POST['City']; $State = $_POST['State']; $Zip = $_POST['Zip']; $Phone = $_POST['Phone']; $Email = $_POST['Email']; $Website = $_POST['Website']; $Comments = $_POST['Comments']; if(empty($FullName)) { $error .= '-- Enter your Full Name. <br />'; } if(empty($Email) || preg_match('~^([0-9a-zA-Z]([-.\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\w]*[0-9a-zA-Z]\.)+[a-zA-Z]{2,9})$~',$Email)) { //<- if email is empty, or doesn't follow the expression. $error .= '-- Enter your Email. <br />'; //<- this is the error message. } if($error == NULL) { $sql = sprintf("INSERT INTO myContactData(myDate,FullName,Address,City,State,Zip,Phone,Email,Website,Comments) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s','%s')", //<-database structure must be right. mysql_real_escape_string($myDate), mysql_real_escape_string($FullName), mysql_real_escape_string($Address), mysql_real_escape_string($City), mysql_real_escape_string($State), mysql_real_escape_string($Zip), mysql_real_escape_string($Phone), mysql_real_escape_string($Email), mysql_real_escape_string($Website), mysql_real_escape_string($Comments)); if(mysql_query($sql)) { $error .= 'Thank you for your comment!'; } else { $error .= 'There was an error in our Database, please Try again!'; } } } echo $error; $myDate = $_REQUEST['myDate'] ; $FullName = $_REQUEST['FullName'] ; $Address = $_REQUEST['Address'] ; $City = $_REQUEST['City'] ; $State = $_REQUEST['State'] ; $Zip = $_REQUEST['Zip'] ; $Phone = $_REQUEST['Phone'] ; $Email = $_REQUEST['Email'] ; $Website = $_REQUEST['Website'] ; $Comments = $_REQUEST['Comments'] ; mail( "email@website.com", "Contact Request", "Date Sent: $myDate\nFull Name: $FullName\nAddress: $Address\n City: $City\n State: $State\n Zip: $Zip\n Phone: $Phone\n Email: $Email\n Website: $Website\n Comments: $Comments\n", "From: $Email" ); ?> <form name="myform" action="" method="post"> <input type="hidden" name="myDate" size="45" maxlength="50" value="<?php echo date("F j, Y"); ?>" /> <div id="tableFormDiv"> <fieldset><span class="floatLeftFormWidth"><span class="textErrorItalic">* - Required</span></span> <span class="floatFormLeft"> </span></fieldset> <fieldset><span class="floatLeftFormWidth"><span class="textErrorItalic">*</span> Full Name:</span> <span class="floatFormLeft"><input type="text" name="FullName" size="45" maxlength="50" value="<?php echo $FullName; ?>" /></span></fieldset> <fieldset><span class="floatLeftFormWidth">Address:</span> <span class="floatFormLeft"><input type="text" name="Address" size="45" maxlength="50" value="<?php echo $Address; ?>" /></span></fieldset> <fieldset><span class="floatLeftFormWidth">City:</span> <span class="floatFormLeft"><input type="text" name="City" size="45" maxlength="50" value="<?php echo $City; ?>" /></span></fieldset> <fieldset><span class="floatLeftFormWidth">State:</span> <span class="floatFormLeft"><input type="text" name="State" size="45" maxlength="50" value="<?php echo $State; ?>" /></span></fieldset> <fieldset><span class="floatLeftFormWidth">Zip:</span> <span class="floatFormLeft"><input type="text" name="Zip" size="45" maxlength="50" value="<?php echo $Zip; ?>" /></span></fieldset> <fieldset><span class="floatLeftFormWidth">Phone:</span> <span class="floatFormLeft"><input type="text" name="Phone" size="45" maxlength="50" value="<?php echo $Phone; ?>" /></span></fieldset> <fieldset><span class="floatLeftFormWidth"><span class="textErrorItalic">*</span> Email:</span> <span class="floatFormLeft"><input type="text" name="Email" size="45" maxlength="50" value="<?php echo $Email; ?>" /></span></fieldset> <fieldset><span class="floatLeftFormWidth">Website:</span> <span class="floatFormLeft"><input type="text" name="Website" size="45" maxlength="50" value="<?php echo $Website; ?>" /></span></fieldset> <fieldset><span class="floatLeftFormWidth">Comments:</span> <span class="floatFormLeft"><textarea name="Comments" cols="40" rows="10"><?php echo $Comments; ?></textarea></span></fieldset> </div> <input type="submit" name="submit" value="Submit" class="submitButton" /><br /> </form> </div> Can someone please help me with this... Hi I am new to PHP and this is my first post one here so appologies is this questions seems a bit dumb! I have an if clause such that if a button is pressed on my web page then i want to reload the page and include a new form on it. I am having a problem getting the $_SERVER['PHP_SELF'] command to work from iside a echo command. I must not be escaping the code correctly with back slashes: I currently have the line : echo"<form method=\"POST\" action=\"\<?$_SERVER['PHP_SELF']?\>\">"; However this doesnt seem to work as my page just doesnt display in the browser. Any advice is much appreciated. Thanks for taking the time to read. I've been working on my email screen, adding a video to it, and some Css. Which seems to work quite fine. However when the page returns to the original screen (represented by the code 1.) It collapses the video image. Makes it really long horizontally and thin vertically.
If I remove this first piece, showing that the email was sent successfully.
if(isset($_GET['Message'])){
echo $_GET['Message'];
}
It returns to the screen fine and the video looks as it should. Code1:-
<?php
if(isset($_GET['Message'])){
echo $_GET['Message'];
}
$uri = $_SERVER['REQUEST_URI'];
$uri_dir = getcwd();
?>
<!DOCTYPE html>
<html>
<head>
<link href="/LifeSaverHTML/Details/Database/stylevid2.css" rel="stylesheet" type="text/css">
<h1 class = "titler">
LifeTube
</h1>
<p></p>
</head>
<body>
<video class = "tube" controls src="examplevid.mp4">
Your browser does not support the video tag.
</video>
<p></p>
<div style="margin: 0 auto; text-align: center">
<a href='/PHPMailer/index.php?id=<?=$uri?>&dire=<?=$uri_dir?>' class="linker">Email Security</a>
</div>
</body>
</html>
I'm using this piece of CSS = Code2. I've set all the defaults padding etc to default for testing.
* {
margin: 0;
padding: 0;
}
As I say it looks great. Apart from when it returns with the email successful message. The whole thing just deflates.
Code2:-
* {
margin: 0;
padding: 0;
}
body {
background: url('/LifeSaverHTML/Details/Database/backround.jpg') no-repeat center center fixed;
height: 100%;
background-position: center;
background-repeat: no-repeat;
background-size: cover;
}
.tube {
display: block;
margin: auto;
width: 50%;
height: 20%;
border: 10px solid green;
}
.button {
margin: 0 auto;
display:block;
text-align: center;
}
.linker {
background-color: #23b83c;
border: 2px solid #020353;
color: whitesmoke;
padding: 1em 1.5em;
text-align: center;
text-decoration: none;
font-size: 1em;
display: inline-block;
width: 12%;
border-radius: 5px;
box-shadow: 3px 3px 8px 0 #000; /* h-offset v-offset blur spread color */
}
.linker:hover {
color: red;
}
.titler {
width: 20%;
text-align: center;
margin: 0 auto;
color: #FFFFFF;
border: 5px ridge rgba(124,252,0);
border-radius: 36px;
background: #232323;
text-shadow: 0 0 5px #FFF, 0 0 10px #FFF, 0 0 15px #FFF, 0 0 20px #49ff18, 0 0 30px #49FF18, 0 0 40px #49FF18, 0 0 55px #49FF18, 0 0 75px #49ff18;
}
nav {
width: 80%;
margin: 0 auto; }
nav ul {
list-style: none;
overflow: hidden; }
nav ul li {
float: left;
width: 20%; }
nav ul li a {
text-align: center;
padding: 8px 0;
display: block;
width: 100%;
background: #cdeb8e; /* Old browsers */
background: -moz-linear-gradient(top,
#cdeb8e 0%, #b0ca34 100%); /* FF3.6+ */
background: -webkit-gradient(linear, left top, left bottom,
color-stop(0%,#cdeb8e),
color-stop(100%,#b0ca34)); /* Chrome,Safari4+ */
background: -webkit-linear-gradient(top,
#cdeb8e 0%,#b0ca34 100%); /* Chrome10+,Safari5.1+ */
background: -o-linear-gradient(top,
#cdeb8e 0%,#b0ca34 100%); /* Opera 11.10+ */
background: linear-gradient(to bottom,
#cdeb8e 0%,#b0ca34 100%); /* W3C, IE10+ */
filter: progid:DXImageTransform.Microsoft.gradient(
startColorstr=’#cdeb8e’,
endColorstr=’#b0ca34′,GradientType=0 ); /* IE6-9 */
}
nav ul li a,
nav ul li a:focus,
nav ul li a:visited,
nav ul li a:hover,
nav ul li a:active {
color: #000;
text-decoration: none; }
nav ul li a:hover,
nav ul li a:active {
background: #b0ca34; /* Old browsers */
background: -moz-linear-gradient(top,
#b0ca34 0%, #96c40d 100%); /* FF3.6+ */
background: -webkit-gradient(linear, left top, left bottom,
color-stop(0%,#b0ca34),
color-stop(100%,#96c40d)); /* Chrome,Safari4+ */
background: -webkit-linear-gradient(top,
#b0ca34 0%,#96c40d 100%); /* Chrome10+,Safari5.1+ */
background: -o-linear-gradient(top,
#b0ca34 0%,#96c40d 100%); /* Opera 11.10+ */
background: linear-gradient(to bottom,
#b0ca34 0%,#96c40d 100%); /* W3C, IE10+ */
filter: progid:DXImageTransform.Microsoft.gradient(
startColorstr=’#b0ca34′,
endColorstr=’#96c40d’,GradientType=0 ); /* IE6-9 */
}
nav ul li:first-child a {
border-top-left-radius: 8px;
border-bottom-left-radius: 8px; }
nav ul li:last-child a {
border-top-right-radius: 8px;
border-bottom-right-radius: 8px; }
Edited February 17, 2020 by JonnyDriller I want the login script to echo out a statement, and then after 5 seconds (if the user hasn't clicked the link manually) I want it to redirect with the header redirect. I'm using the sleep function for the delay of the redirect. Here's the concerned portion of the login script: // check to see if the INPUT DATA matches the DATABASE COLUMNS! if ($nickname == $dbuser_name && sha1($password) == $dbuser_password) { // set a session after login $_SESSION['user_name'] = $dbuser_name; $_SESSION['user_id'] = $dbuser_id; echo "<center>You're logged in! <a href='01.php'>Click here</a> to go to the main page.</center>"; sleep(5); // seconds to wait header ('Location: 01.php'); // password incorrect error message } else { echo "<center>Incorrect password!</center>"; } But the echo statement never gets printed out, any idea why it gets swallowed by the sleep function? for some reason it will not render to the row... ive added the php echo to the row in question and it runs with the top row... can someone take a look and let me know what i am doing wrong... thanks trey here is the code... the php echo in bold red should show up on the next row; but, it doesnt... <?php /** * @version $Id: mod_gridiron_game_results.php, v1.5.0 March 2011 01:32:15 * @author Fastball Productions * @package Gridiron * @copyright Copyright (C) 2011 Fastball Productions * @license http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL */ // no direct access defined('_JEXEC') or die('Restricted access'); $db =& JFactory::getDBO(); // get the module parameters $heading = $params->get( 'heading', '' ); $showpast = $params->get( 'showpast', '1' ); $numberpast = $params->get( 'numberpast', '1' ); $linkboxscore = $params->get( 'linkboxscore', '1' ); $shownextgame = $params->get( 'nextgame', '1' ); $numbernext = $params->get( 'numbernext', '1' ); $linknext = $params->get( 'linknext', '1' ); $seasonid = $params->get( 'seasonid', '1' ); $gametypes = $params->get( 'gametypes', '1' ); $teamids = $params->get( 'teamids', '' ); $leagueids = $params->get( 'leagueids', '' ); $divisionids = $params->get( 'divisionids', '' ); if (is_array($gametypes)) { $gametypes = implode(',', $gametypes); } if (is_array($teamids)) { $teamids = implode(',', $teamids); } if (is_array($leagueids)) { $leagueids = implode(',', $leagueids); } if (is_array($divisionids)) { $divisionids = implode(',', $divisionids); } // if there is a league configured, get the teams within the league/division; if ($teamids == '' && ($divisionids || $leagueids)) { if ($divisionids) { // get a listing of all team ID's that belong in the league and division; $sql = "SELECT id FROM #__gridiron_team WHERE (FIND_IN_SET(divisionid, '$divisionids'))"; } else { // get a listing of all team ID's that belong in the league; $sql = "SELECT id FROM #__gridiron_team WHERE (FIND_IN_SET(leagueid, '$leagueids'))"; } $db->setQuery($sql); $rows = $db->loadResultArray(); $teamids = implode(',', $rows); } else if ($teamids == '') { // get the default team (single team component only); $db->setQuery("SELECT id FROM #__gridiron_team WHERE (defaultteam = 1)"); $teamids = $db->loadResult(); } // get the last x number of games played and the results; $db->setQuery("SELECT a.*, a.hometeam AS hometeamid, a.visitingteam AS visitingteamid, DATE_FORMAT(a.gamedatetime, '%a, %M %D') AS gamedate, DATE_FORMAT(a.gamedatetime, '%l:%i %p') As gametime, h.name AS hometeam, v.name AS visitingteam, b.finalv, b.finalh FROM #__gridiron_schedule AS a LEFT JOIN #__gridiron_team AS h ON a.hometeam = h.id LEFT JOIN #__gridiron_team AS v ON a.visitingteam = v.id LEFT JOIN #__gridiron_boxscore AS b ON a.id = b.gameid WHERE (a.scored = 1 AND a.season = {$seasonid} AND (FIND_IN_SET(a.gametype, '$gametypes')) AND (FIND_IN_SET(a.hometeam, '$teamids') OR FIND_IN_SET(a.visitingteam, '$teamids')) AND a.gamedatetime < now()) GROUP BY a.id ORDER BY a.gamedatetime DESC LIMIT 0, {$numberpast}"); $pastgames = $db->loadObjectList(); // get the next x number of games scheduled; $db->setQuery("SELECT a.*, a.hometeam AS hometeamid, a.visitingteam AS visitingteamid, DATE_FORMAT(a.gamedatetime, '%a, %M %D') AS gamedate, DATE_FORMAT(a.gamedatetime, '%l:%i %p') As gametime, h.name AS hometeam, v.name AS visitingteam, t.description AS gametype FROM #__gridiron_schedule AS a LEFT JOIN #__gridiron_team AS h ON a.hometeam = h.id LEFT JOIN #__gridiron_team AS v ON a.visitingteam = v.id LEFT JOIN #__gridiron_gametype AS t ON a.gametype = t.id LEFT JOIN #__gridiron_location AS l ON a.location = l.id WHERE (a.scored = 0 AND a.season = {$seasonid} AND (FIND_IN_SET(a.gametype, '$gametypes')) AND (FIND_IN_SET(a.hometeam, '$teamids') OR FIND_IN_SET(a.visitingteam, '$teamids')) AND DATE_ADD(a.gamedatetime, INTERVAL 3 HOUR) > now()) GROUP BY a.id ORDER BY a.gamedatetime ASC LIMIT 0, {$numbernext}"); $nextgames = $db->loadObjectList(); ?> <table width="100%" border="0" align="center"> <?php if ($showpast && $numberpast > 0) { ?> <tr> <td colspan="2" style="text-align:center;"><b><?php echo $heading;?></b></td> </tr> <tr> <td width="43%"><b><u>Matchup</u></b></td> <td width="57%" style="text-align:center;"><b><u>Result</u></b></td> </tr> <?php foreach ($pastgames as $past) { ?> <tr> <td> <?php echo $past->visitingteam;?> vs.<br /><?php echo $past->hometeam;?> </td> <td style="text-align:center;"> <?php if ($linkboxscore) { ?> <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=boxscore&id=$past->id");?>"><?php echo $past->finalv;?><br /><?php echo $past->finalh;?></a> <?php } else { ?> <?php echo $past->finalv;?><br /><?php echo $past->finalh;?> </td> <?php } ?> </tr> <tr> <td colspan="2"></td> </tr> <?php } ?> <?php } ?> <?php if ($shownextgame && $numbernext > 0 && $nextgames) { ?> <tr> <td colspan="2"><b><u>Next Game</u></b></td> </tr> <?php foreach ($nextgames as $next) { ?> <?php $next->visitingteam == '' ? $next->visitingteam = 'TBA':$next->visitingteam = $next->visitingteam;?> <?php $next->hometeam == '' ? $next->hometeam = 'TBA':$next->hometeam = $next->hometeam;?> <tr> <td colspan="2"> <?php if ($linknext) { ?> <?php if ($next->visitingteam == 'TBA') { ?> <?php echo $next->visitingteam;?> <?php } else { ?> <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=schedule&id=$next->visitingteamid");?>"><?php echo $next->visitingteam;?></a> <?php } ?> vs. <?php if ($next->hometeam == 'TBA') { ?> <?php echo $next->hometeam;?> <?php } else { ?> <a href="<?php echo JRoute::_("index.php?option=com_gridiron&view=schedule&id=$next->hometeamid");?>"><?php echo $next->hometeam;?></a> <?php } ?> <?php } else { ?> <?php echo $next->visitingteam;?> vs. <?php echo $next->hometeam;?> </td> </tr> <tr> <td colspan="2"><?php } ?><?php echo $next->gamedate . ' ' . $next->gametime;?> </td> </tr> <?php } ?> <?php } ?> </table> |
|||||||