perrij3
-
Posts
58 -
Joined
-
Last visited
Everything posted by perrij3
-
I would agree that the site looks a little strange being aligned to the left. I have a 21" monitor, so that leaves a lot of space to the right. I also would add/change the hover coding in your CSS so that when someone moves their mouse over a link on your page, the background, font color, etc.. changes to show that it's a link. The other think I think is missing is there is no footer on your page. This is a great place for a legal information link, copyright notification, etc.. I think the design is nice and with a few tweaks, the site will look great.
-
I am still new to PHP, but I am having this issue. I created a simple contact form that just emails the owner of the site the name, email address, and comments a visitor enters. I tested the form and it work on my website host sever, witch is using PHP version 4.4.9. When he loaded onto his website host sever, witch is running PHP Version 5.2.4-2ubuntu5.6, he receives an email, but the information entered by the visitor doesn't show up. When I run it on my website server, I get all the information I enter into the form. I do know that the data is being collected by the form. I used the following code to determine that. echo "<pre>"; echo "POST:"; print_r($_POST); echo "</pre>"; I have been learning to program using PHP 5 from a book and that is where I got most of this code from. <?php include('includes/title.inc.php'); include('includes/header.php'); // Process the email if (array_key_exists('send', $_POST)) { $to = '[email protected]'; //email address data is sent too $subject = 'Feedback'; // List expected fields $expected = array('name', 'email', 'comments'); // Set required fields $required = array('name', 'email', 'comments'); // Create empty array for any missing fields $missing = array(); echo "<pre>"; echo "POST:"; print_r($_POST); echo "</pre>"; // assume that there is nothing suspect $suspect = false; // create a pattern to locate suspect phrases $pattern = '/Content-Type:|Bcc:|Cc:/i'; // function to check for suspect phrases function isSuspect($val, $pattern, &$suspect) { //if the variable is an array, loop through each element //and pass it recursively back to the same function if (is_array($val)) { foreach ($val as $item) { isSuspect($item, $pattern, $suspect); } } else { //if one of the suspect phrases is found, set Boolean to true if (preg_match($pattern, $val)) { $suspect = true; } } } // check the $_POST array and any subarrays for suspect content isSuspect($_POST, $pattern, $suspect); if ($suspect) { $mailSent = false; unset($missing); } else { // Process the $_POST variables foreach ($_POST as $key => $value) { // assign to temprary variable and strip whitespace if not an array $temp = is_array($value) ? $value : trim($value); // if empty and required, add to $missing array if (empty($temp) && in_array($key, $required)) { array_push($missing, $key); } // otherwise, assign to a variable of the same name as $key elseif (in_array($key, $expected)) { ${key} = $temp; } } } // validate the email address if (!empty($email)) { //regex to ensure no illegal charaters in emial address $checkEmail = '/^[^@]+@[^\s\r\n\'";,@%]+$/'; //reject the email address if it doesn't match if (!preg_match($checkEmail, $email)) { array_push($missing, 'email'); } } // Go ahead only not suspect if all required fields OK if (!$suspect && empty($missing)) { // Build the message $message = "Name: $name\n\n"; $message .= "Email: $email\n\n"; $message .= "Comments: $comments\n\n"; // limit line lenght to 70 characters $message = wordwrap($message, 70); // create additional headers $additionalHeaders = 'From: AA <[email protected]>'; if (!empty($email)) { $additionalHeaders .= "\r\nReply-To: $email"; } //sent it $mailSent = mail($to, $subject, $message, $additionalHeaders); if ($mailSent) { // $missing is no longer needed if the email is sent, so unset it unset($missing); } } } ?> <!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" /> </head> <body> <div id="outer"> <!-- The outer contenter --> <div id="header"> <!-- The header section of the page --> </div> <div id="container"> <h2>Contact</h2> <?php if ($_POST && isset($missing) && !empty($missing)) { ?> <p class="warning">Please complete the missing item(s) indicated.</p> <?php } elseif ($_POST && !$mailSent) { ?> <p class="warning">Sorry, there was a problem sending your message. Please try later</p> <?php } elseif ($_POST && $mailSent) { ?> <p class="message_sent"><strong>Your message has been sent. Thank you for your feedback</strong></p> <?php } ?> <form id="feedback" method="post" action=""> <p> <label for="name">Name: <?php if (isset($missing) && in_array('name', $missing)) { ?> <span class="warning">Please enter your name</span><?php } ?></label><br /> <input name="name" id="name" type="text" class="formbox" <?php if (isset($missing)) { echo 'value="' .htmlentities($_POST['name']).'"'; } ?> /> </p> <p> <label for="email">Email:</label><br /> <input name="email" id="email" type="text" class="formbox" <?php if (isset($missing)) { echo 'value="' .htmlentities($_POST['email']).'"'; } ?> /> </p> <p> <label for="comments">Comments:<?php if (isset($missing) && in_array('comments', $missing)) { ?> <span class="warning">Please enter your comments</span><?php } ?></label><br /> <textarea name="comments" id="comments" cols="40" rows="8"><?php if (isset($missing)) { echo htmlentities($_POST['comments']); } ?></textarea> </p> <p>*All fields are required.</p> <p> <input name="send" id="send" type="submit" value="Send message" /> </p> </form> </div> </div> </body> </html> Any help would be greatly appreciated.
-
Maybe this posting will help http://www.phpfreaks.com/forums/index.php/topic,248098.0.html.
-
I am new to PHP and the only work I have done so far with PHP & MySQL is to create a program to keep track of maintenance slips at work so please forgive me if my coding isn't the best. Recently the GM wanted a field added for a target date for a project to be done. I have that field added, but though it would make life much easier if I could color code the output. What I mean by that is, say a project is passed due, I want the font for the project to be red. If it is within 2 weeks of the project target date, I want it to be green. If the project doesn't have a target date or isn't close to it, then I want the font to be black. Not all projects have target dates. Here is what I have tried so far. I am just not sure if the best way to go about this is trying to add days to the current date to get to the 2 weeks out using PHP or if I should do the date addition using MySQL and maybe a join statement. Any help or suggestions would be greatly appreciated. Thanks $query = "SELECT * FROM `workorder` WHERE `Completed`='0' ORDER BY `Location` ASC, `Date_Filed` ASC"; $result = mysql_query($query) or die (mysql_error()); while($row = mysql_fetch_array($result)) // Loop thru recordset and get values { $todays_date = date("Y-m-d"); $add_date = 14; //Number of days I want to add $today = strtotime($todays_date); //Getting Today's Date $compare_date = strtotime($row["Date_Completed"]); //Getting date to compare from database $future_date = strtotime("$today + $add_date days"); //Setting date to 14 days into the future if ($compare_date == '') //Setting text to black if there is no target date { $bg ="table_text_bg1"; } elseif //Setting text to black if the date is more then 2 weeks out ($compare_date <= (strtotime("$today + $add_date days"))) { $bg ="table_text_bg1"; } elseif //Setting text to green if the date is 2 weeks or less away ($compare_date <= (strtotime("$today + $add_date days"))) { $bg = "table_text_bg2"; } else //Setting text to red if the target date is past due { $bg = "table_text_bg3"; } //Display output echo "<tr class=\""; echo $bg; echo "\">"; echo "<td width=\"70\" align=\"center\">"; echo $row["Location"]; echo "</td>"; echo "<td width=\"50\">"; echo $row["WorkOrder_ID"]; echo "</td>"; echo "<td width=\"80\">"; echo $row["By"]; echo "</td>"; echo "<td width=\"40\">"; echo $row["Date_Filed"]; echo "</td>"; echo "<td width=\"260\">"; echo $row["Comments"]; echo "</td>"; echo "<td width=\"260\">"; echo $row["Solution"]; echo "</td>"; echo "<td width=\"40\">"; echo $row["Target_Date"]; echo "</td></tr>"; }
-
Thanks again for the advice on separating the html code from the php code. I have learned a lot just from you. The drop down box is still not being populated though. When I use this code, it will show me the list of employees so I know that the database is being accessed and the data is being read correctly. while ($row = mysql_fetch_assoc($result)) { echo $row["Name"]; }
-
Thanks for the help CroNix. As I said I am very new to PHP and really just trying to figure it out. I do appreciate the help you provided me.
-
I am able to connect to the database and display my data when display it outside of my drop down menu. I will post my entire code so everyone can view it with the changes mentioned by CroNiX. When I changed my form tag to what CroNix suggested, I got this error message: Parse error: syntax error, unexpected '/' in C:\wamp\www\hi\findEmp.php on line 41 Here is all my code: <?php echo "<html> <head> <title>View All Work Orders Completed by One Employee</title> <link href='css/gobal.css' rel='stylesheet' type='text/css' /> </head> <body>"; $host="localhost"; $user="root"; $password=""; $cxn = mysql_connect($host,$user,$password) or die ("Couldn't connect to database."); $dbname = 'holidayinn'; mysql_select_db($dbname); $query = "SELECT DISTINCT `Name` FROM `employee` ORDER BY `Name`"; $result = mysql_query($query) or die (mysql_error()); echo "<div id='header1'><img src='images/hi_logo.gif' alt='Holiday Inn Logo' width='200' height='83' id='logo'/><p align='right'><a href='home.html' target='_self' class='headlink'>Home</a> </p><h1 align='center'>Maintenance Request Tracking</h1></div> <div>"; while ($row = mysql_fetch_assoc($result)) { echo $row["Name"]; } /*This is the form used to display the drop down box to select an employee. */ echo "<form action=\"viewEmp.php\" method=\"POST\"> <select name='EmployeeName'>"; while($row = mysql_fetch_array($result)) // Loop thru recordset and get values { echo"<option value='".$row["Name"]."'>".$row["Name"]; echo"</option> } echo"</select>"; echo"<input type='submit' Value='Submit'> </form>"; ?> </div> </body> </html>
-
I am new to PHP and I'm having trouble getting my drop down box to work. I just want a simple drop down box that displays a list of employees from a table. Here is the code that I have been working with, I just don't know where my error is. ??? $query = "SELECT DISTINCT `Name` FROM `employee` ORDER BY `Name`"; $result = mysql_query($query) or die (mysql_error()); echo "<form action='viewEmp.php' method='POST'> <select name='EmployeeName'>"; while($row = mysql_fetch_array($result)) // Loop thru recordset and get values { echo"<option value='".$row["Name"]."'>".$row["Name"]; } echo"</select>"; echo"<input type='submit' Value='Submit'> </form>"; ?> I appreciate any help anyone can provide. Thanks Joe
