lbh2011

Does anyone else find that in Windows 8 / IE10 it is impossible to add a new line when writing a new post?

What sort of website are you looking to adapt? You could use CSS to format the existing pages differently for mobile devices or find the user agent (browser type) using PHP and redirect the user to a separate mobile optimised page.

DROP TABLE IF EXISTS `flights`; CREATE TABLE `flights` ( `flight_id` int(11) NOT NULL AUTO_INCREMENT, `flight_icon` int(11) NOT NULL, `flight_path` int(11) NOT NULL, `flight_from` int(11) NOT NULL, `flight_to` int(11) NOT NULL, PRIMARY KEY (`flight_id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

Does this work for you? <?php $error_msg = ""; if ($_POST['username']) { $username = $_POST['username']; $password = $_POST['password']; // Simple hard coded values for the correct username and password $admin = "admin"; $adminpass = "admin"; // connect to mysql here if you store admin username and password in your database // This would be the prefered method of storing the values instead of hard coding them here into the script if (($username != $admin) || ($password != $adminpass)) { echo '<font color="#FF0000">Your login information is incorrect</font>'; echo '<h3>Only the administrator can view this page</h3><br /> <table width="340" border="0"> <form action="" method="post"> <tr> <td colspan="2">Please Log In Here</td> </tr> <tr> <td width="96">Username:</td> <td width="234"><input type="text" name="username" id="username" style="width:98%" /></td> </tr> <tr> <td>Password:</td> <td><input type="password" name="password" id="password" style="width:98%" /></td> </tr> <tr> <td colspan="2" align="center"><input type="submit" name="button" id="button" value="Log In Now" /></td> </tr> </form> </table> <br /> <br /> <br /> <a href="../">Or click here to head back to the homepage</a>'; exit; } else { session_register('admin'); $_SESSION['admin'] = $username; require_once "index.php"; }} else { echo '<h3>Only the administrator can view this page</h3><br /> <table width="340" border="0"> <form action="" method="post"> <tr> <td colspan="2">Please Log In Here</td> </tr> <tr> <td width="96">Username:</td> <td width="234"><input type="text" name="username" id="username" style="width:98%" /></td> </tr> <tr> <td>Password:</td> <td><input type="password" name="password" id="password" style="width:98%" /></td> </tr> <tr> <td colspan="2" align="center"><input type="submit" name="button" id="button" value="Log In Now" /></td> </tr> </form> </table> <br /> <br /> <br /> <a href="../">Or click here to head back to the homepage</a>'; } ?>

Have you connected to the database?

Does anyone have a preferred or recommended method of restricting access to a website depending on which country the visitor originates from? I would like to prevent users from accessing (or registering to access) the website from anywhere outside of the United Kingdom. I am aware of various .htaccess and php methods but am also aware that .htaccess methods for example can prevent Google from indexing the site correctly.

Thanks Backslider. How about within $row though? <td><a href="update.php?id='.$id.'">Update</a></td> How would I apply this code to that? (So only display the update link when the user is logged in) <?php if($c->is_admin == 'Yes') { // do stuff } else { // do something else } ?>

Hi, I've purchased a login script which uses this line to check if the user is an administrator and if so displays a link... <?=($c->is_admin == 'Yes')?'<a href="add.php">Add entry</a>':'<br>'?> My question is, how do I apply this to the following (which is on the same page), where I want to prevent the update and delete links from being visible? I have tried to do it like the example above but receive an error which states that the $row variable is undefined when I do... $row = '<tr> <td>'.$date_added.'</a></td> <td>'.$title.'</a></td> <td><a href="view.php?id='.$id.'">View Details</a></td> <td><a href="update.php?id='.$id.'">Update</a></td> <td><a href="delete.php?id='.$id.'">Delete</a></td> </tr>'; Also, how do I change the admin line to an IF statement e.g. if $c = is_admin {...} else {...} Thanks!

@DavidAM I've tried the following but this doesn't appear to work either... $file_upload = trim(mysql_real_escape_string($_POST["file_upload"])); if(empty($_POST["file_upload"])) { include ('contract_upload.php'); $rsUpdate = mysql_query("UPDATE contract SET date_added = '$date_added', file_upload = '$upload_path' WHERE id = '$id' ");} else { $rsUpdate = mysql_query("UPDATE contract SET date_added = '$date_added' WHERE id = '$id' ");} if($rsUpdate) { echo "Successfully Update";} else { die('Invalid query: '.mysql_error());; }

OK In that case how to I work out if it contains a value or not?

Does anyone know why this won't work. Even when nothing is entered into the file upload field, it is processed as if something was... $file_upload = trim(mysql_real_escape_string($_POST["file_upload"])); if(isset($file_upload)) { include ('contract_upload.php'); $rsUpdate = mysql_query("UPDATE contract SET date_added = '$date_added', file_upload = '$upload_path' WHERE id = '$id' ");} else { $rsUpdate = mysql_query("UPDATE contract SET date_added = '$date_added' WHERE id = '$id' ");} if($rsUpdate) { echo "Successfully Update";} else { die('Invalid query: '.mysql_error());; } [EDIT] This is for an update form by the way, hence why I don't want to overwrite the $upload_path record in the database if a new file is not uploaded...

OK! Thanks for your help.

Is that the correct code to use then if I want to include upload.php if a value is submitted?

Hello! Please could someone have a look at the following code and suggest why upload.php is not being included. I basically want to test whether the form field (upload) contains a value (local file path). If it does contain a value I want to include a file upload script but if it doesn't I want to continue to the next section which processes the form. Due to the way the rest of the code is structured I can't check for a blank field first before continuing to the next step. $upload = trim(mysql_real_escape_string($_POST["upload"])); if(!isset($upload)) { include 'upload.php'; } else {

Sounds simple! Perhaps that's the way to go!

Hi everyone, Does anyone know of a third-party php job board script which allows people to apply for jobs for a single company. There are hundreds of scripts which allow multiple employers in multiple locations to add multiple jobs for multiple people to view and apply for. I am looking for a script which one company with one office can use to upload multiple job descriptions and specifications (text and word/pdf uploads) which users (or employees) can apply for after registering. I know this is probably a case where it would be simpler to create the script myself, but it's worth asking if anyone has found one that does something similar. Thanks

Thanks trk

Hi, Yes I do know some PHP but how do I convert eof to php for example? Thanks

Hi everyone! I’ve been given a website coded in ASP which I would prefer to be coded in PHP so that I can make more sense of it! I can’t work out how to convert this section of site which I believe is placed at the top of each file to login the admin user and set the user session. Would someone be able to provide me with a rough translation!? Thanks! <!--#include virtual="connections/conn.asp" --> <% if request.form("send") = "yes" then varuser = request.form("user") varpass = request.form("pass") set rslogin = conn.execute("select * from security where sec_user = '" & varuser & "' and sec_pass = '" & varpass & "'") if rslogin.eof then varmsg = "There was a problem with your login details, please try again." elseif not rslogin.eof then session.timeout = 120 session("logged") = "admin" response.redirect("home.asp") end if rslogin.close() set rslogin = nothing end if %>

Hello, Could anyone point me in the right direction with regards to URL Rewriting. I have a site e.g. www.domain.com This site has a subdirectory which runs a membership script e.g. www.domain.com/membership Almost all of the functions of the membership script are handled by one file e.g. www.domain.com/membership/process.php Functions occur when different variables are passed to the script e.g. www.domain.com/membership/process.php?update will show a form where users can update their details. What I would like to do is to rewite the URL so that users can access process.php and it's functions via www.domain.com/process.php instead of www.domain.com/membership/process.php Is this possible using .htaccess? I did try to do the above by adding <?php include'membership/process.php?update'; ?> to www.domain.com/process.php but this doesn't work as variables are not passed! Thanks!

Hey, Does anyone have any solutions to the following problem? The following code is the CSS menu I'm currently working on. The default state of the menu is black text on a white background. When hovering over a link, the background becomes black and the text white. *The problem* Now, I want to highlight the menu link of the current page using the rule .currentpage This *should* change the background to black and the text to white However when I do this, the text appears black (on a black background) My current thinking is that the rule #navigation li a:visited is taking priority over the .currentpage rule If I remove #navigation li a:visited then the menu works correctly - with the exception of the visited links, which appear in the browser's default colours, instead of black. How do I resolve this issue? <!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>Untitled Document</title> <style type="text/css"> .currentpage { text-decoration: none; font-weight: normal; background-color: #000000; color: #FFF; } #navigation-primary { background-color: #FFFFFF; float: left; width: 100%; height: 26px; margin: 0px; } #navigation { width: 100%; float: left; margin: 0; padding: 0; list-style: none; border-top-width: 0px; border-bottom-width: 0px; border-top-style: none; border-bottom-style: none; border-style:none; height: 25px; } #navigation li { float: left; font-family: Tahoma, Geneva, sans-serif; font-size: 14px; text-decoration: none; background-color: #FFF; color: #000000; } #navigation li a:link { display: block; text-decoration: none; padding-top: 5px; padding-right: 5px; padding-bottom: 5px; padding-left: 5px; color: #000000; background-color: #FFF; } #navigation li a:visited { text-decoration: none; font-weight: normal; color: #000; } #navigation li a:hover { text-decoration: none; background-color: #000000; color: #FFF; } #navigation li a:active{ text-decoration: none; font-weight: normal; color: #000000; background-color: #FFF; } </style> </head> <body> <div id="navigation-primary"> <ul id="navigation"> <li><a href="index.php" class="currentpage">Home</a></li> <li><a href="index2.php">Page 2</a></li> </ul> </div> </body> </html>

My code currently looks something like this: if(!isset($_POST['Name']) || !isset($_POST['Email']) ||) { died('Your message could not be sent'); } $Name = $_POST['Name']; $Email = $_POST['Email']; $string_exp = "/^[A-Za-z .'-]+$/"; $string_exp_number = "/^[0-9]+$/"; if(!preg_match($string_exp,$Name)) { $errors[] = 'Name'; } if(!preg_match($email_exp,$Email)) { $errors[] = 'Email'; } if(is_array($errors)) { echo 'Your message could not be sent due to the following errors:'; while (list($key,$value) = each($errors)) { echo '<span class="error">'.$value.'</span><br />'; } } //Continues with email function How would I integrate your suggestions to a) ensure the field is not empty and b) return an error message which can be displayed under the form field. I believe I already have an array for listing the errors, but what would I need to change or add to my form client side in order to display the error message. At present, my form look something like this: The Javascript (which currently displays the list of error messages in the <div id="log_res"> section of the form: <script type="text/javascript" src="js/mootools.js"></script> <script type="text/javascript"> /* <![CDATA[ */ window.addEvent('domready', function(){ $('contact').addEvent('submit', function(e) { new Event(e).stop(); var log = $('log_res').empty().addClass('ajax-loading'); this.send({ update: log, onComplete: function() { log.removeClass('ajax-loading'); } }); }); }); /* ]]> */ </script> The HTML of the form: <div id="log"> <div id="log_res"> (The error messages are currently displayed here) </div> </div> <form id="contact" name="contact" method="post" action="process.php"> <label>Name</label> <input type="text" name="Name" id="Name" tabindex="1" /> <label>Email</label> <input type="text" name="Email" id="Email" tabindex="2" /> <input name="Submit" type="submit" value="Send Message" /> </form> Thanks

Thanks for the advice everyone! Problem solved.

Any ideas?

Hello! Quick question which I hope someone will be able to answer! How do I apply this style <style type="text/css"> .text { font-family: Arial, Helvetica, sans-serif; color: #666; font-size: 12px; font-weight: normal; text-decoration: none; margin-right: 15px; } </style> to the code below, which will become text in an PHP generated HTML email $message .= "Dear ".clean_string($Name).",\n\n"; $message .= "Thank you for your message.\n\n"; I beleive I need to use a css span class but can't get it to work! Thanks!