webmaster1

No assist on this one? Its certainly quite here today.

Don't forget to close the door on the way out! (mark thread as solved)

Any takers on this? To recap and to save any of you having to read through the entire thread here's a summary of the post: [*]I asked how combine three forms without the user input being reset as the user interchanges forms. [*]Genericnumber1 advised that I combine the forms. [*]Wildteen88 showed me how to combine two of the calculation forms but not how to combine them with the main form that actually writes to the database. [*]Back to square one. I still have two forms and as a result my original problem persists. I've been trying to digest Wildteen88's code in the meantime: It seems like I could add a third case (this could be what he was suggesting) though I don't have a clue how to manipulate the $actions array.

Ah, sorry about that. I thought the code chunk in my first post broke it down. Synopsis: [*]User inputs data into main form. [*]User will have either a kilometer or mile mileage but the form will prompt them for both. [*]User inputs whatever they have into a subsidiary (separate) form (the one you posted) to calculate the requisite mileage. [*]User copies and pastes the resulting mileage into the main form and continues completing it. My problem is if I create two seperate forms the clicking of a submit button of one wipes out the existing content of another (meaning the user will have to restart their input each time they wish to make a calculation).

Here's my code without the calculations or your suggested code. <?php if (isset($_POST['submit'])) //PROCESS THE FORM WHEN THE SUBMIT BUTTON IS PRESSED { //VALIDATE THE INDIVIDUAL FIELDS AND DEFINE THEM AS TRUE OR FALSE BASED ON THE USER'S INPUT //REGULAR TEXT FIELDS if (strlen($_POST['make']) > 0) {$make=TRUE;} else {$make=FALSE; $message_make=" *You forgot to enter the make!";} if (strlen($_POST['model']) > 0) {$model=TRUE;} else {$model=FALSE; $message_model=" *You forgot to enter the model!"; } if (strlen($_POST['price']) > 0) {$price=TRUE; if (is_numeric($_POST['price'])) {$pricenumericcheck=TRUE;} else {$pricenumericcheck=FALSE; $message_pricenumericcheck=" *Please enter numeric values only! (e.g. Do not input commas or the euro symbol!)"; //echo "$message_pricenumericcheck"; } } else {$price=FALSE; $message_price=" *You forgot to enter the price!";} if (strlen($_POST['engine']) > 0) {$engine=TRUE;} else {$engine=FALSE; $message_engine=" *You forgot to enter the engine!";} if (strlen($_POST['body']) > 0) {$body=TRUE;} else {$body=FALSE; $message_body=" *You forgot to enter the body!";} if (strlen($_POST['transmission']) > 0) {$transmission=TRUE;} else {$transmission=FALSE; $message_transmission=" *You forgot to enter the transmission!";} if (strlen($_POST['year']) > 0) {$year=TRUE; if (is_numeric($_POST['year'])) {$yearnumericcheck=TRUE; if((strlen($_POST['year']) > 4) || (strlen($_POST['year']) < 4)) { $yearnumericcheck=FALSE; $message_yearnumericcheck=" *Please enter a four digit numeric value only! (e.g. 1983, 1999, 2010.)"; //echo "$message_yearnumericcheck"; } } else {$yearnumericcheck=FALSE; $message_yearnumericcheck=" *Please enter a four digit numeric value only! (e.g. 1983, 1999, 2010.)"; //echo "$message_yearnumericcheck"; } } else {$year=FALSE; $message_year=" *You forgot to enter the year!";} if (strlen($_POST['colour']) > 0) {$colour=TRUE;} else {$colour=FALSE; $message_colour=" *You forgot to enter the colour!";} if (strlen($_POST['mileagem']) > 0) {$mileagem=TRUE; if (is_numeric($_POST['mileagem'])) {$mileagemnumericcheck=TRUE;} else {$mileagemnumericcheck=FALSE; $message_mileagemnumericcheck=" *Please enter numeric values only! (e.g. Do not input commas or the mile symbol!)"; //echo "$message_mileagemnumericcheck"; } } else {$mileagem=FALSE; $message_mileagem=" *You forgot to enter the mileage in miles!";} if (strlen($_POST['mileagekm']) > 0) {$mileagekm=TRUE; if (is_numeric($_POST['mileagekm'])) {$mileagekmnumericcheck=TRUE;} else {$mileagekmnumericcheck=FALSE; $message_mileagekmnumericcheck=" *Please enter numeric values only! (e.g. Do not input commas or the kilometre symbol!)"; //echo "$message_mileagekmnumericcheck"; } } else {$mileagekm=FALSE; $message_mileagekm=" *You forgot to enter the mileage in kilometres!";} if (strlen($_POST['owners']) > 0) {$owners=TRUE; if (is_numeric($_POST['owners'])) {$ownersnumericcheck=TRUE;} else {$ownersnumericcheck=FALSE; $message_ownersnumericcheck=" *Please enter numeric values onlyfor owners! (e.g. 1, 2, 3.!)"; //echo "$message_ownersnumericcheck"; } } else {$owners=FALSE; $message_owners=" *You forgot to enter the owners in miles!";} if (strlen($_POST['doors']) > 0) {$doors=TRUE; if (is_numeric($_POST['doors'])) {$doorsnumericcheck=TRUE;} else {$doorsnumericcheck=FALSE; $message_doorsnumericcheck=" *Please enter numeric values only for doors! (e.g. 2, 4, 6.!)"; //echo "$message_doorsnumericcheck"; } } else {$doors=FALSE; $message_doors=" *You forgot to enter the owners in doors!";} if (strlen($_POST['location']) > 0) {$location=TRUE;} else {$location=FALSE; $message_location=" *You forgot to enter the location!";} //TEXT AREA FIELD if (isset($_POST['info'])) { $info = trim($_POST['info']); if ($info == "" || empty($info)) { $message_info = "Please enter data for info!"; } } //UPLOAD FILE FIELDS //CHECK IF UPLOAD FILE FIELD 1 IS EMPTY $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if($filesize1==0) { $filesize1=FALSE; $message_filesize1="You forgot to enter this image file!"; //echo "$message_filesize1"; } else { $filesize1=TRUE; } //CHECK IF UPLOAD FILE FIELD 1 IS EMPTY $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if($filesize2==0) { $filesize2=FALSE; $message_filesize2="You forgot to enter this image file!"; //echo "$message_filesize2"; } else { $filesize2=TRUE; } //CHECK IF UPLOAD FILE FIELD 3 IS EMPTY $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if($filesize3==0) { $filesize3=FALSE; $message_filesize3="You forgot to enter this image file!"; //echo "$message_filesize3"; } else { $filesize3=TRUE; } //CHECK IF ANY THE FILES ARE THE SAME: $filenamecheck1= $HTTP_POST_FILES['ufile']['name'][0]; $filenamecheck2= $HTTP_POST_FILES['ufile']['name'][1]; $filenamecheck3= $HTTP_POST_FILES['ufile']['name'][2]; $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( (($filenamecheck1 == $filenamecheck2) || ($filenamecheck2 == $filenamecheck3) || ($filenamecheck1 == $filenamecheck3)) && ((!$filesize1==0 && isset($_POST['submit'])) && (!$filesize2==0 && isset($_POST['submit'])) && (!$filesize3==0 && isset($_POST['submit']))) ) { $filenamecheck_message = "one ore more of the files are the same"; //echo "$message_filenamecheck"; $message_filenamecheck = TRUE; $filenamecheck1= FALSE; $filenamecheck2= FALSE; $filenamecheck3= FALSE; } else { $message_filenamecheck = FALSE; $filenamecheck1= TRUE; $filenamecheck2= TRUE; $filenamecheck3= TRUE; } //CHECK IF FILE 1 IS NOT A *.JPEG OR *.GIF $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if ( ( ($HTTP_POST_FILES['ufile']["type"][0] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][0] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][0] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][0] < 50000) ) { $filetypecheck1=TRUE; } else { if (!($filesize1 == 0)) { $filetypecheck1=FALSE; $message_filetypecheck1="The first of the sumbitted files is not of a *.JPG ! *.GIF file type!"; //echo "$message_filetypecheck1"; } } //CHECK IF FILE 2 IS NOT A *.JPEG OR *.GIF $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if ( ( ($HTTP_POST_FILES['ufile']["type"][1] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][1] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][1] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][1] < 50000) ) { $filetypecheck2=TRUE; } else { if (!($filesize2 == 0)) { $filetypecheck2=FALSE; $message_filetypecheck2="The second of the sumbitted files is not of a *.JPG ! *.GIF file type!"; //echo "$message_filetypecheck2"; } } //CHECK IF FILE 3 IS NOT *.JPEG OR *.GIF $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( ( ($HTTP_POST_FILES['ufile']["type"][2] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][2] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][2] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][2] < 50000) ) { $filetypecheck3=TRUE; } else { if (!($filesize3 == 0)) { $filetypecheck3=FALSE; $message_filetypecheck3="The third of the sumbitted files is not of a *.JPG ! *.GIF file type!"; //echo "$message_filetypecheck3"; } } //CHECK IF FILE 1 EXISTS ALREADY $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if ( (file_exists($path1)) && (!($filesize1 == 0)) ) { $fileexistcheck1=FALSE; $message_fileexistcheck1="The first file already exist on the server!"; //echo "$message_fileexistcheck1"; } else { $fileexistcheck1=TRUE; } //CHECK IF FILE 2 EXISTS ALREADY $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if ( (file_exists($path2)) && (!($filesize2 == 0)) ) { $fileexistcheck2=FALSE; $message_fileexistcheck2="The second file already exist on the server!"; //echo "$message_fileexistcheck2"; } else { $fileexistcheck2=TRUE; } //CHECK IF FILE 3 EXISTS ALREADY $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( (file_exists($path3)) && (!($filesize3 == 0)) ) { $fileexistcheck3=FALSE; $message_fileexistcheck3="The third file already exist on the server!"; //echo "$message_fileexistcheck3"; } else { $fileexistcheck3=TRUE; } //IF ALL INPUT FIELDS ARE DEFINED AS TRUE / VALIDATED if ($make && $model && $price && $pricenumericcheck && $engine && $body && $transmission && $year && $yearnumericcheck && $colour && $mileagem && $mileagemnumericcheck && $mileagekm && $mileagekmnumericcheck && $owners && $ownersnumericcheck && $doors && $doorsnumericcheck && $location && $info && $filesize1 && $filesize2 && $filesize3 && $filenamecheck1 && filenamecheck2 && filenamecheck3 && $filetypecheck1 && $filetypecheck2 && $filetypecheck3 && $fileexistcheck1 && $fileexistcheck2 && $fileexistcheck3) { //FIRST DEFINE PATHS AS VARIABLES $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; //NEXT POST THE IMAGES TO THE DESIGNATED FOLDER ON THE SERVER copy($HTTP_POST_FILES['ufile']['tmp_name'][0], $path1); copy($HTTP_POST_FILES['ufile']['tmp_name'][1], $path2); copy($HTTP_POST_FILES['ufile']['tmp_name'][2], $path3); //PICK UP AND DEFINE INPUT AS INDIVIDUAL VARIABLES //CONNECT TO RELEVANT DATABASE //THE CONNECTION MUST PRECEDE THE mysql_real_escape_string FUNCTION. include("dbinfo.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to establish a connection to the relevant database."); $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; $make = mysql_real_escape_string($_POST['make']); $model = mysql_real_escape_string($_POST['model']); $price = mysql_real_escape_string($_POST['price']); $engine = mysql_real_escape_string($_POST['engine']); $body = mysql_real_escape_string($_POST['body']); $transmission = mysql_real_escape_string($_POST['transmission']); $year =mysql_real_escape_string($_POST['year']); $colour =mysql_real_escape_string($_POST['colour']); $mileagem = mysql_real_escape_string($_POST['mileagem']); $mileagekm = mysql_real_escape_string($_POST['mileagekm']); $owners = mysql_real_escape_string($_POST['owners']); $doors = mysql_real_escape_string($_POST['doors']); $location = mysql_real_escape_string($_POST['location']); $info = mysql_real_escape_string($_POST['info']); //DEFINE ADDITIONAL VARIABLES /* PHP uses unix timestamps for all its date functionality. It has methods to convert these timestamps into pretty much any text format you could want but internally it uses the timestamp format. A timestamp is simply an unsigned integer. Specifically, it&#8217;s the number of seconds that have elapsed since midnight on January 1st 1970 (greenwich mean time). MySQL has three date types for use in columns. These are DATETIME, DATE, and TIMESTAMP. DATETIME EXAMPLE: YYYY-MM-DD HH:MM:SS (e.g. 2006-12-25 13:43:15) DATE EXAMPLE: YYYY-MM-DD (e.g. 2006-12-25) */ //$now_datetime = date('Y-m-d h:i:s'); $ipaddress = getenv('REMOTE_ADDR'); //CONNECTION WAS 'ERE //INSERT THE INPUT INTO DATABASE $query = "INSERT INTO test VALUES ('','$make','$model','$price','$engine','$body','$transmission','$year','$colour','$mileagem','$mileagekm','$owners','$doors','$location','$info',NOW(),'$ipaddress','$path1','$path2','$path1')"; mysql_query($query); //NEXT DISPLAY A SUMMARY OF WHAT HAS BEEN UPLOADED echo "This item has been successfully submitted to the server.</br></br> The following image file have been appended to your uploaded:</br></br> "; echo "File Name :".$HTTP_POST_FILES['ufile']['name'][0]."<BR/>"; //echo "File Size :".$HTTP_POST_FILES['ufile']['size'][0]." KB<BR/>"; echo "File Type :".$HTTP_POST_FILES['ufile']['type'][0]."<BR/>"; //echo "<img src=\"$path1\" height=\"150\">"; echo "<P>"; echo "File Name :".$HTTP_POST_FILES['ufile']['name'][1]."<BR/>"; //echo "File Size :".$HTTP_POST_FILES['ufile']['size'][1]."<BR/>"; echo "File Type :".$HTTP_POST_FILES['ufile']['type'][1]."<BR/>"; //echo "<img src=\"$path2\" height=\"150\">"; echo "<P>"; echo "File Name :".$HTTP_POST_FILES['ufile']['name'][2]."<BR/>"; //echo "File Size :".$HTTP_POST_FILES['ufile']['size'][2]."<BR/>"; echo "File Type :".$HTTP_POST_FILES['ufile']['type'][2]."<BR/>"; //echo "<img src=\"$path3\" height=\"150\">"; echo "</br>It's best practice to confirm that your item has been submitted as desired</br></br> [place button here to link to view relevant section]</br></br> If you notice an error as a result of human input please find and delete the item indefinitely and reattempt its submission. Items should also be deleted as soon as they become redundant (e.g. vehichle sold)</br></br> Should you experience further technical difficulty please contact the web master:</br></br> [place button here to link to web master cms error log form] "; //VERY IMPORTANT! EXIT(); WILL NO LONGER DISPLAY THE FORM exit(); //CLOSE: IF ALL INPUT FIELDS TRUE: } //CLOSE: OVERALL VALIDATION: } ?> <HTML> <HEAD> </HEAD> <BODY> <!--BEGIN FORM AND SET IT TO PROCESS SELF AND HANDLE MULTIPART/FORM-DATA--> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data"> <fieldset> <?php // IF ANY INDIVIDUAL INPUT FIELD IS DEFINED AS FALSE THEN DISPLAY ERROR MESSAGE if ($message_make || $message_model || $message_price || $message_pricenumericcheck || $message_engine || $message_body || $message_transmission || $message_year || $message_colour || $message_mileagem || $message_mileagekm || $message_owners || $message_doors || $message_location || $message_info || $message_filesize2 || $message_filesize1 || $message_filesize2 || $message_filesize3 || $message_filesize1 || $message_filesize2 || $message_filesize3 || $message_filenamecheck || $message_filetypecheck1 || $message_filetypecheck2 || $message_filetypecheck3 || $message_fileexistcheck1 || $message_fileexistcheck2 || $message_fileexistcheck3 || $message_yearnumericcheck || $message_mileagemnumericcheck || $message_mileagekmnumericcheck || $message_ownersnumericcheck || $message_doorsnumericcheck) // echo '*Your request could not be sent because some of the information is missing.</br></br>'; ?> <ol> <!--BEGIN REGULAR TEXT FIELDS--> <php? /* THE PHP BLOCK OF CODE IN THE VALUE OF EACH TEXT FIELD IS SIMPLY GIVING THE ELEMENT THE VALUE OF WHATEVER IS INPUTTED INTO IT BY THE USER. CLEVER BUT NOT SURE IF ITS ACTUALLY DOING A WHOLE LOT. */ ?> <li> <label for="make">Make:</label> <input type="text" name="make" id="make" class="text" value="<?php if (isset($_POST['make'])) echo $_POST['make']; ?>"/> <?php if ($message_make) echo ''.$message_make.''; ?> </br> </li> <li> <label for="model">Model:</label> <input type="text" name="model" id="model" class="text" value="<?php if (isset($_POST['model'])) echo $_POST['model']; ?>"/> <?php if ($message_model) echo ''.$message_model.''; ?> </br> </li> <li> <label for="price">Price:</label> <input type="text" name="price" id="price" class="text" value="<?php if (isset($_POST['price'])) echo $_POST['price']; ?>"/> <?php if ($message_price) echo ''.$message_price.''; ?> <?php if ($message_pricenumericcheck) echo ''.$message_pricenumericcheck.''; ?> </br> </li> <li> <label for="engine">Engine:</label> <input type="text" name="engine" id="engine" class="text" value="<?php if (isset($_POST['engine'])) echo $_POST['engine']; ?>"/> <?php if ($message_engine) echo ''.$message_engine.''; ?></br> </li> <li> <label for="body">Body Type:</label> <input type="text" name="body" id="body" class="text" value="<?php if (isset($_POST['body'])) echo $_POST['body']; ?>"/> <?php if ($message_body) echo ''.$message_body.''; ?></br> </li> <li> <label for="transmission">Transmission:</label> <input type="text" name="transmission" id="transmission" class="text" value="<?php if (isset($_POST['transmission'])) echo $_POST['transmission']; ?>"/> <?php if ($message_transmission) echo ''.$message_transmission.''; ?></br> </li> <li> <label for="year">Year:</label> <input type="text" name="year" id="year" class="text" value="<?php if (isset($_POST['year'])) echo $_POST['year']; ?>"/> <?php if ($message_year) echo ''.$message_year.''; ?> <?php if ($message_yearnumericcheck) echo ''.$message_yearnumericcheck.''; ?> </br> </li> <li> <label for="colour">Colour:</label> <input type="text" name="colour" id="colour" class="text" value="<?php if (isset($_POST['colour'])) echo $_POST['colour']; ?>"/> <?php if ($message_colour) echo ''.$message_colour.''; ?></br> </li> <li> <label for="mileagem">Mileage M:</label> <input type="text" name="mileagem" id="mileagem" class="text" value="<?php if (isset($_POST['mileagem'])) echo $_POST['mileagem']; ?>"/> <?php if ($message_mileagem) echo ''.$message_mileagem.''; ?> <?php if ($message_mileagemnumericcheck) echo ''.$message_mileagemnumericcheck.''; ?> </br> </li> <li> <label for="mileagekm">Mileage KM:</label> <input type="text" name="mileagekm" id="mileagekm" class="text" value="<?php if (isset($_POST['mileagekm'])) echo $_POST['mileagekm']; ?>"/> <?php if ($message_mileagekm) echo ''.$message_mileagekm.''; ?> <?php if ($message_mileagemnumericcheck) echo ''.$message_mileagemnumericcheck.''; ?> </br> </li> <li> <label for="owners">Owners:</label> <input type="text" name="owners" id="owners" class="text" value="<?php if (isset($_POST['owners'])) echo $_POST['owners']; ?>"/> <?php if ($message_owners) echo ''.$message_owners.''; ?> <?php if ($message_ownersnumericcheck) echo ''.$message_ownersnumericcheck.''; ?> </br> </li> <li> <label for="doors">Doors:</label> <input type="text" name="doors" id="doors" class="text" value="<?php if (isset($_POST['doors'])) echo $_POST['doors']; ?>"/> <?php if ($message_doors) echo ''.$message_doors.''; ?> <?php if ($message_doorsnumericcheck) echo ''.$message_doorsnumericcheck.''; ?> </br> </li> <li> <label for="location">Location:</label> <input type="text" name="location" id="location" class="text" value="<?php if (isset($_POST['location'])) echo $_POST['location']; ?>"/> <?php if ($message_location) echo ''.$message_location.''; ?></br> </li> <!--BEGIN TEXT AREA--> <li> <label for="info">Additional Information:</label></br> <textarea name="info" rows="5" cols="50"/><?php if (isset($_POST['info'])) echo stripslashes($_POST['info']); ?></textarea> <?php if ($message_info) echo ''.$message_info.''; ?> </br> </li> <!--BEGIN FILE UPLOADS--> <li> <label for "ufile[]">Image File 1:</label> <input type="file" name="ufile[]" id="ufile[]"/> <?php if ($message_filesize1) echo ''.$message_filesize1.''; ?> <?php if ($message_filetypecheck1) echo ''.$message_filetypecheck1.''; ?> <?php if ($message_fileexistcheck1) echo ''.$message_fileexistcheck1.''; ?> </li> <li> <label for "ufile[]">Image File 2:</label> <input type="file" name="ufile[]" id="ufile[]"/> <?php if ($message_filesize2) echo ''.$message_filesize2.''; ?> <?php if ($message_filetypecheck2) echo ''.$message_filetypecheck2.''; ?> <?php if ($message_fileexistcheck2) echo ''.$message_fileexistcheck2.''; ?> </li> <li> <label for "ufile[]">Image File 3:</label> <input type="file" name="ufile[]" id="ufile[]"/> <?php if ($message_filesize3) echo ''.$message_filesize3.''; ?> <?php if ($message_filetypecheck3) echo ''.$message_filetypecheck3.''; ?> <?php if ($message_fileexistcheck3) echo ''.$message_fileexistcheck3.''; ?> </br> <?php if ($filenamecheck_message) echo ''.$filenamecheck_message.''; ?> </li> <li> <input name="submit" type="submit"> </li> </ol> </fieldset> </form> </BODY> </HTML>

Nuts. There is a problem: It doesn't tie in with my main form. Here's what my full code looks like when I added your suggested code: <?php //WT88 CODE $dist = null; if (isset($_POST['submit'])) //PROCESS THE FORM WHEN THE SUBMIT BUTTON IS PRESSED { //WT88 CODE $dist = $_POST['distance']; switch($_POST['action']) { // Miles to Kilometers case 0: $unit = ' Kilometers'; $result = $dist*1.609; break; // Kilometers to Miles case 1: $unit = ' Miles'; $result = $dist/1.609; break; //VALIDATE THE INDIVIDUAL FIELDS AND DEFINE THEM AS TRUE OR FALSE BASED ON THE USER'S INPUT //REGULAR TEXT FIELDS if (strlen($_POST['make']) > 0) {$make=TRUE;} else {$make=FALSE; $message_make=" *You forgot to enter the make!";} if (strlen($_POST['model']) > 0) {$model=TRUE;} else {$model=FALSE; $message_model=" *You forgot to enter the model!"; } if (strlen($_POST['price']) > 0) {$price=TRUE; if (is_numeric($_POST['price'])) {$pricenumericcheck=TRUE;} else {$pricenumericcheck=FALSE; $message_pricenumericcheck=" *Please enter numeric values only! (e.g. Do not input commas or the euro symbol!)"; //echo "$message_pricenumericcheck"; } } else {$price=FALSE; $message_price=" *You forgot to enter the price!";} if (strlen($_POST['engine']) > 0) {$engine=TRUE;} else {$engine=FALSE; $message_engine=" *You forgot to enter the engine!";} if (strlen($_POST['body']) > 0) {$body=TRUE;} else {$body=FALSE; $message_body=" *You forgot to enter the body!";} if (strlen($_POST['transmission']) > 0) {$transmission=TRUE;} else {$transmission=FALSE; $message_transmission=" *You forgot to enter the transmission!";} if (strlen($_POST['year']) > 0) {$year=TRUE; if (is_numeric($_POST['year'])) {$yearnumericcheck=TRUE; if((strlen($_POST['year']) > 4) || (strlen($_POST['year']) < 4)) { $yearnumericcheck=FALSE; $message_yearnumericcheck=" *Please enter a four digit numeric value only! (e.g. 1983, 1999, 2010.)"; //echo "$message_yearnumericcheck"; } } else {$yearnumericcheck=FALSE; $message_yearnumericcheck=" *Please enter a four digit numeric value only! (e.g. 1983, 1999, 2010.)"; //echo "$message_yearnumericcheck"; } } else {$year=FALSE; $message_year=" *You forgot to enter the year!";} if (strlen($_POST['colour']) > 0) {$colour=TRUE;} else {$colour=FALSE; $message_colour=" *You forgot to enter the colour!";} if (strlen($_POST['mileagem']) > 0) {$mileagem=TRUE; if (is_numeric($_POST['mileagem'])) {$mileagemnumericcheck=TRUE;} else {$mileagemnumericcheck=FALSE; $message_mileagemnumericcheck=" *Please enter numeric values only! (e.g. Do not input commas or the mile symbol!)"; //echo "$message_mileagemnumericcheck"; } } else {$mileagem=FALSE; $message_mileagem=" *You forgot to enter the mileage in miles!";} if (strlen($_POST['mileagekm']) > 0) {$mileagekm=TRUE; if (is_numeric($_POST['mileagekm'])) {$mileagekmnumericcheck=TRUE;} else {$mileagekmnumericcheck=FALSE; $message_mileagekmnumericcheck=" *Please enter numeric values only! (e.g. Do not input commas or the kilometre symbol!)"; //echo "$message_mileagekmnumericcheck"; } } else {$mileagekm=FALSE; $message_mileagekm=" *You forgot to enter the mileage in kilometres!";} if (strlen($_POST['owners']) > 0) {$owners=TRUE; if (is_numeric($_POST['owners'])) {$ownersnumericcheck=TRUE;} else {$ownersnumericcheck=FALSE; $message_ownersnumericcheck=" *Please enter numeric values onlyfor owners! (e.g. 1, 2, 3.!)"; //echo "$message_ownersnumericcheck"; } } else {$owners=FALSE; $message_owners=" *You forgot to enter the owners in miles!";} if (strlen($_POST['doors']) > 0) {$doors=TRUE; if (is_numeric($_POST['doors'])) {$doorsnumericcheck=TRUE;} else {$doorsnumericcheck=FALSE; $message_doorsnumericcheck=" *Please enter numeric values only for doors! (e.g. 2, 4, 6.!)"; //echo "$message_doorsnumericcheck"; } } else {$doors=FALSE; $message_doors=" *You forgot to enter the owners in doors!";} if (strlen($_POST['location']) > 0) {$location=TRUE;} else {$location=FALSE; $message_location=" *You forgot to enter the location!";} //TEXT AREA FIELD if (isset($_POST['info'])) { $info = trim($_POST['info']); if ($info == "" || empty($info)) { $message_info = "Please enter data for info!"; } } //UPLOAD FILE FIELDS //CHECK IF UPLOAD FILE FIELD 1 IS EMPTY $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if($filesize1==0) { $filesize1=FALSE; $message_filesize1="You forgot to enter this image file!"; //echo "$message_filesize1"; } else { $filesize1=TRUE; } //CHECK IF UPLOAD FILE FIELD 1 IS EMPTY $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if($filesize2==0) { $filesize2=FALSE; $message_filesize2="You forgot to enter this image file!"; //echo "$message_filesize2"; } else { $filesize2=TRUE; } //CHECK IF UPLOAD FILE FIELD 3 IS EMPTY $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if($filesize3==0) { $filesize3=FALSE; $message_filesize3="You forgot to enter this image file!"; //echo "$message_filesize3"; } else { $filesize3=TRUE; } //CHECK IF ANY THE FILES ARE THE SAME: $filenamecheck1= $HTTP_POST_FILES['ufile']['name'][0]; $filenamecheck2= $HTTP_POST_FILES['ufile']['name'][1]; $filenamecheck3= $HTTP_POST_FILES['ufile']['name'][2]; $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( (($filenamecheck1 == $filenamecheck2) || ($filenamecheck2 == $filenamecheck3) || ($filenamecheck1 == $filenamecheck3)) && ((!$filesize1==0 && isset($_POST['submit'])) && (!$filesize2==0 && isset($_POST['submit'])) && (!$filesize3==0 && isset($_POST['submit']))) ) { $filenamecheck_message = "one ore more of the files are the same"; //echo "$message_filenamecheck"; $message_filenamecheck = TRUE; $filenamecheck1= FALSE; $filenamecheck2= FALSE; $filenamecheck3= FALSE; } else { $message_filenamecheck = FALSE; $filenamecheck1= TRUE; $filenamecheck2= TRUE; $filenamecheck3= TRUE; } //CHECK IF FILE 1 IS NOT A *.JPEG OR *.GIF $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if ( ( ($HTTP_POST_FILES['ufile']["type"][0] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][0] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][0] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][0] < 50000) ) { $filetypecheck1=TRUE; } else { if (!($filesize1 == 0)) { $filetypecheck1=FALSE; $message_filetypecheck1="The first of the sumbitted files is not of a *.JPG ! *.GIF file type!"; //echo "$message_filetypecheck1"; } } //CHECK IF FILE 2 IS NOT A *.JPEG OR *.GIF $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if ( ( ($HTTP_POST_FILES['ufile']["type"][1] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][1] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][1] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][1] < 50000) ) { $filetypecheck2=TRUE; } else { if (!($filesize2 == 0)) { $filetypecheck2=FALSE; $message_filetypecheck2="The second of the sumbitted files is not of a *.JPG ! *.GIF file type!"; //echo "$message_filetypecheck2"; } } //CHECK IF FILE 3 IS NOT *.JPEG OR *.GIF $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( ( ($HTTP_POST_FILES['ufile']["type"][2] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][2] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][2] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][2] < 50000) ) { $filetypecheck3=TRUE; } else { if (!($filesize3 == 0)) { $filetypecheck3=FALSE; $message_filetypecheck3="The third of the sumbitted files is not of a *.JPG ! *.GIF file type!"; //echo "$message_filetypecheck3"; } } //CHECK IF FILE 1 EXISTS ALREADY $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if ( (file_exists($path1)) && (!($filesize1 == 0)) ) { $fileexistcheck1=FALSE; $message_fileexistcheck1="The first file already exist on the server!"; //echo "$message_fileexistcheck1"; } else { $fileexistcheck1=TRUE; } //CHECK IF FILE 2 EXISTS ALREADY $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if ( (file_exists($path2)) && (!($filesize2 == 0)) ) { $fileexistcheck2=FALSE; $message_fileexistcheck2="The second file already exist on the server!"; //echo "$message_fileexistcheck2"; } else { $fileexistcheck2=TRUE; } //CHECK IF FILE 3 EXISTS ALREADY $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( (file_exists($path3)) && (!($filesize3 == 0)) ) { $fileexistcheck3=FALSE; $message_fileexistcheck3="The third file already exist on the server!"; //echo "$message_fileexistcheck3"; } else { $fileexistcheck3=TRUE; } //IF ALL INPUT FIELDS ARE DEFINED AS TRUE / VALIDATED if ($make && $model && $price && $pricenumericcheck && $engine && $body && $transmission && $year && $yearnumericcheck && $colour && $mileagem && $mileagemnumericcheck && $mileagekm && $mileagekmnumericcheck && $owners && $ownersnumericcheck && $doors && $doorsnumericcheck && $location && $info && $filesize1 && $filesize2 && $filesize3 && $filenamecheck1 && filenamecheck2 && filenamecheck3 && $filetypecheck1 && $filetypecheck2 && $filetypecheck3 && $fileexistcheck1 && $fileexistcheck2 && $fileexistcheck3) { //FIRST DEFINE PATHS AS VARIABLES $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; //NEXT POST THE IMAGES TO THE DESIGNATED FOLDER ON THE SERVER copy($HTTP_POST_FILES['ufile']['tmp_name'][0], $path1); copy($HTTP_POST_FILES['ufile']['tmp_name'][1], $path2); copy($HTTP_POST_FILES['ufile']['tmp_name'][2], $path3); //PICK UP AND DEFINE INPUT AS INDIVIDUAL VARIABLES //CONNECT TO RELEVANT DATABASE //THE CONNECTION MUST PRECEDE THE mysql_real_escape_string FUNCTION. include("dbinfo.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to establish a connection to the relevant database."); $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; $make = mysql_real_escape_string($_POST['make']); $model = mysql_real_escape_string($_POST['model']); $price = mysql_real_escape_string($_POST['price']); $engine = mysql_real_escape_string($_POST['engine']); $body = mysql_real_escape_string($_POST['body']); $transmission = mysql_real_escape_string($_POST['transmission']); $year =mysql_real_escape_string($_POST['year']); $colour =mysql_real_escape_string($_POST['colour']); $mileagem = mysql_real_escape_string($_POST['mileagem']); $mileagekm = mysql_real_escape_string($_POST['mileagekm']); $owners = mysql_real_escape_string($_POST['owners']); $doors = mysql_real_escape_string($_POST['doors']); $location = mysql_real_escape_string($_POST['location']); $info = mysql_real_escape_string($_POST['info']); //DEFINE ADDITIONAL VARIABLES /* PHP uses unix timestamps for all its date functionality. It has methods to convert these timestamps into pretty much any text format you could want but internally it uses the timestamp format. A timestamp is simply an unsigned integer. Specifically, it&#8217;s the number of seconds that have elapsed since midnight on January 1st 1970 (greenwich mean time). MySQL has three date types for use in columns. These are DATETIME, DATE, and TIMESTAMP. DATETIME EXAMPLE: YYYY-MM-DD HH:MM:SS (e.g. 2006-12-25 13:43:15) DATE EXAMPLE: YYYY-MM-DD (e.g. 2006-12-25) */ //$now_datetime = date('Y-m-d h:i:s'); $ipaddress = getenv('REMOTE_ADDR'); //CONNECTION WAS 'ERE //INSERT THE INPUT INTO DATABASE $query = "INSERT INTO test VALUES ('','$make','$model','$price','$engine','$body','$transmission','$year','$colour','$mileagem','$mileagekm','$owners','$doors','$location','$info',NOW(),'$ipaddress','$path1','$path2','$path1')"; mysql_query($query); //NEXT DISPLAY A SUMMARY OF WHAT HAS BEEN UPLOADED echo "This item has been successfully submitted to the server.</br></br> The following image file have been appended to your uploaded:</br></br> "; echo "File Name :".$HTTP_POST_FILES['ufile']['name'][0]."<BR/>"; //echo "File Size :".$HTTP_POST_FILES['ufile']['size'][0]." KB<BR/>"; echo "File Type :".$HTTP_POST_FILES['ufile']['type'][0]."<BR/>"; //echo "<img src=\"$path1\" height=\"150\">"; echo "<P>"; echo "File Name :".$HTTP_POST_FILES['ufile']['name'][1]."<BR/>"; //echo "File Size :".$HTTP_POST_FILES['ufile']['size'][1]."<BR/>"; echo "File Type :".$HTTP_POST_FILES['ufile']['type'][1]."<BR/>"; //echo "<img src=\"$path2\" height=\"150\">"; echo "<P>"; echo "File Name :".$HTTP_POST_FILES['ufile']['name'][2]."<BR/>"; //echo "File Size :".$HTTP_POST_FILES['ufile']['size'][2]."<BR/>"; echo "File Type :".$HTTP_POST_FILES['ufile']['type'][2]."<BR/>"; //echo "<img src=\"$path3\" height=\"150\">"; echo "</br>It's best practice to confirm that your item has been submitted as desired</br></br> [place button here to link to view relevant section]</br></br> If you notice an error as a result of human input please find and delete the item indefinitely and reattempt its submission. Items should also be deleted as soon as they become redundant (e.g. vehichle sold)</br></br> Should you experience further technical difficulty please contact the web master:</br></br> [place button here to link to web master cms error log form] "; //VERY IMPORTANT! EXIT(); WILL NO LONGER DISPLAY THE FORM exit(); //CLOSE: IF ALL INPUT FIELDS TRUE: } //CLOSE: OVERALL VALIDATION: } ?> <HTML> <HEAD> </HEAD> <BODY> <!--BEGIN FORM AND SET IT TO PROCESS SELF AND HANDLE MULTIPART/FORM-DATA--> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data"> <fieldset> <?php // IF ANY INDIVIDUAL INPUT FIELD IS DEFINED AS FALSE THEN DISPLAY ERROR MESSAGE if ($message_make || $message_model || $message_price || $message_pricenumericcheck || $message_engine || $message_body || $message_transmission || $message_year || $message_colour || $message_mileagem || $message_mileagekm || $message_owners || $message_doors || $message_location || $message_info || $message_filesize2 || $message_filesize1 || $message_filesize2 || $message_filesize3 || $message_filesize1 || $message_filesize2 || $message_filesize3 || $message_filenamecheck || $message_filetypecheck1 || $message_filetypecheck2 || $message_filetypecheck3 || $message_fileexistcheck1 || $message_fileexistcheck2 || $message_fileexistcheck3 || $message_yearnumericcheck || $message_mileagemnumericcheck || $message_mileagekmnumericcheck || $message_ownersnumericcheck || $message_doorsnumericcheck) // echo '*Your request could not be sent because some of the information is missing.</br></br>'; ?> <ol> <!--BEGIN REGULAR TEXT FIELDS--> <php? /* THE PHP BLOCK OF CODE IN THE VALUE OF EACH TEXT FIELD IS SIMPLY GIVING THE ELEMENT THE VALUE OF WHATEVER IS INPUTTED INTO IT BY THE USER. CLEVER BUT NOT SURE IF ITS ACTUALLY DOING A WHOLE LOT. */ ?> <li> <label for="make">Make:</label> <input type="text" name="make" id="make" class="text" value="<?php if (isset($_POST['make'])) echo $_POST['make']; ?>"/> <?php if ($message_make) echo ''.$message_make.''; ?> </br> </li> <li> <label for="model">Model:</label> <input type="text" name="model" id="model" class="text" value="<?php if (isset($_POST['model'])) echo $_POST['model']; ?>"/> <?php if ($message_model) echo ''.$message_model.''; ?> </br> </li> <li> <label for="price">Price:</label> <input type="text" name="price" id="price" class="text" value="<?php if (isset($_POST['price'])) echo $_POST['price']; ?>"/> <?php if ($message_price) echo ''.$message_price.''; ?> <?php if ($message_pricenumericcheck) echo ''.$message_pricenumericcheck.''; ?> </br> </li> <li> <label for="engine">Engine:</label> <input type="text" name="engine" id="engine" class="text" value="<?php if (isset($_POST['engine'])) echo $_POST['engine']; ?>"/> <?php if ($message_engine) echo ''.$message_engine.''; ?></br> </li> <li> <label for="body">Body Type:</label> <input type="text" name="body" id="body" class="text" value="<?php if (isset($_POST['body'])) echo $_POST['body']; ?>"/> <?php if ($message_body) echo ''.$message_body.''; ?></br> </li> <li> <label for="transmission">Transmission:</label> <input type="text" name="transmission" id="transmission" class="text" value="<?php if (isset($_POST['transmission'])) echo $_POST['transmission']; ?>"/> <?php if ($message_transmission) echo ''.$message_transmission.''; ?></br> </li> <li> <label for="year">Year:</label> <input type="text" name="year" id="year" class="text" value="<?php if (isset($_POST['year'])) echo $_POST['year']; ?>"/> <?php if ($message_year) echo ''.$message_year.''; ?> <?php if ($message_yearnumericcheck) echo ''.$message_yearnumericcheck.''; ?> </br> </li> <li> <label for="colour">Colour:</label> <input type="text" name="colour" id="colour" class="text" value="<?php if (isset($_POST['colour'])) echo $_POST['colour']; ?>"/> <?php if ($message_colour) echo ''.$message_colour.''; ?></br> </li> <li> <label for="mileagem">Mileage M:</label> <input type="text" name="mileagem" id="mileagem" class="text" value="<?php if (isset($_POST['mileagem'])) echo $_POST['mileagem']; ?>"/> <?php if ($message_mileagem) echo ''.$message_mileagem.''; ?> <?php if ($message_mileagemnumericcheck) echo ''.$message_mileagemnumericcheck.''; ?> </br> </li> <li> <label for="mileagekm">Mileage KM:</label> <input type="text" name="mileagekm" id="mileagekm" class="text" value="<?php if (isset($_POST['mileagekm'])) echo $_POST['mileagekm']; ?>"/> <?php if ($message_mileagekm) echo ''.$message_mileagekm.''; ?> <?php if ($message_mileagemnumericcheck) echo ''.$message_mileagemnumericcheck.''; ?> </br> </li> <li> <label for="owners">Owners:</label> <input type="text" name="owners" id="owners" class="text" value="<?php if (isset($_POST['owners'])) echo $_POST['owners']; ?>"/> <?php if ($message_owners) echo ''.$message_owners.''; ?> <?php if ($message_ownersnumericcheck) echo ''.$message_ownersnumericcheck.''; ?> </br> </li> <li> <label for="doors">Doors:</label> <input type="text" name="doors" id="doors" class="text" value="<?php if (isset($_POST['doors'])) echo $_POST['doors']; ?>"/> <?php if ($message_doors) echo ''.$message_doors.''; ?> <?php if ($message_doorsnumericcheck) echo ''.$message_doorsnumericcheck.''; ?> </br> </li> <li> <label for="location">Location:</label> <input type="text" name="location" id="location" class="text" value="<?php if (isset($_POST['location'])) echo $_POST['location']; ?>"/> <?php if ($message_location) echo ''.$message_location.''; ?></br> </li> <!--BEGIN TEXT AREA--> <li> <label for="info">Additional Information:</label></br> <textarea name="info" rows="5" cols="50"/><?php if (isset($_POST['info'])) echo stripslashes($_POST['info']); ?></textarea> <?php if ($message_info) echo ''.$message_info.''; ?> </br> </li> <!--BEGIN FILE UPLOADS--> <li> <label for "ufile[]">Image File 1:</label> <input type="file" name="ufile[]" id="ufile[]"/> <?php if ($message_filesize1) echo ''.$message_filesize1.''; ?> <?php if ($message_filetypecheck1) echo ''.$message_filetypecheck1.''; ?> <?php if ($message_fileexistcheck1) echo ''.$message_fileexistcheck1.''; ?> </li> <li> <label for "ufile[]">Image File 2:</label> <input type="file" name="ufile[]" id="ufile[]"/> <?php if ($message_filesize2) echo ''.$message_filesize2.''; ?> <?php if ($message_filetypecheck2) echo ''.$message_filetypecheck2.''; ?> <?php if ($message_fileexistcheck2) echo ''.$message_fileexistcheck2.''; ?> </li> <li> <label for "ufile[]">Image File 3:</label> <input type="file" name="ufile[]" id="ufile[]"/> <?php if ($message_filesize3) echo ''.$message_filesize3.''; ?> <?php if ($message_filetypecheck3) echo ''.$message_filetypecheck3.''; ?> <?php if ($message_fileexistcheck3) echo ''.$message_fileexistcheck3.''; ?> </br> <?php if ($filenamecheck_message) echo ''.$filenamecheck_message.''; ?> </li> <li> <input name="submit" type="submit"> </li> </ol> </fieldset> </form> <!-- WT88 CODE --> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <input type="text" name="distance" value="<?php echo $dist; ?>" /> <select name="action"> <?php $actions = array('Miles to Kilometers', 'Kilometers to Miles'); foreach($actions as $key => $action) { $selected = (isset($_POST['action']) && $_POST['action'] == $key) ? ' selected="selected"' : null; echo ' <option value="'.$key.'"'.$selected.'>'.$action."</option>\n"; } ?> </select> <?php // display the result. echo number_format($result, 2, '.', ',') . $unit; ?> </br><input type="submit" name="submit" value="Convert"> </form> </BODY> </HTML> I've prefixed Wildteens bits with WT88 if you want to use CTRL + F to jump to them. I know each (your code and my code) function fine by themselves but when combined I get the following error:

Yes sir! Working on it now.

Do you mean I should inserts forms within a form? I think I'll run into the same problem with the input being cleared. If you meant I should insert the code and the fields I'm not sure how to implement an onclick event (on a regular button rather than a submit button) that will trigger my php calculation. Should I just consider using javascript to make this a standalone calculation?

Hi All, I have three forms on the one page. Form 1 writes the user input to a mySQL database. Form 2 converts Miles to Kilometres (does not need to write to database). Form 3 converts Kilometres to Miles (does not need to write to database). Problem: When I click the submit button of either it clears the user input of the rest. The user should be able to calculate the conversion via Form 2/Form 3 half way through Form 1 without loosing their existing input. Here's my code: <form> <!--FORM ONE--> </form> <!--FORM TWO--> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <input type="text" name="mileage_m" id="mileage_m"> <input type="submit" name="submit_m" id="submit_m"> <?php if (isset($_POST['submit_m'])) //1 Mile : 1.609 Kilometre $mileage_m = $_POST['mileage_m']; $mileage_m_result = 1.609*($mileage_m); echo "$mileage_m_result"; echo "Kilometres"; ?> </form> <!--FORM THREE--> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <input type="text" name="mileage_km" id="mileage_km"> <input type="submit" name="submit_km" id="submit_km"> <?php if (isset($_POST['submit_km'])) //1.609 Kilometre : 1 Mile $mileage_km = $_POST['mileage_km']; $mileage_km_result =($mileage_km)/1.609; echo "$mileage_km_result"; echo "Miles"; ?> </form> Any ideas on how to prevent this?

Righto I'll stick to mysql_real_escape_string and trimming where necessary. I'll not add a single line of code related to magic quotes since from you're explanation they seem to be off by default. Thanks Mchl!

I've come across this online: <?php $fetch_exist=mysql_query("SELECT email, username FROM register WHERE email = '".varCheck($_POST['email'])."'" OR username = '".varCheck($_POST['username'])."'"); //then check if dupplicate if(mysql_num_rows($fetch_exist)>0) { while ($rst = mysql_fetch_array($fetch_exist, MYSQL)) { //Is it the username or the email? if ( $rst["username"] == $_POST['username'] ) { //its the username $error_message .="Your Username is already taken. "; } elseif ( $rst["email"] == $_POST['email'] ) { //its the email $error_message .="Your EMail is already taken. "; } } } else { //OK, everything is fine //Otherwise we would have gotten any rows (thus $error is not needed) //mysql_query 'INSERT....' here } //Now display $error_message and give the user another chance ?> Search google under the following: php check if email exists already

Post your existing code (your registration form) so we have something to work with.

Hi All, I'm trying to 'correctly' insert input into my mySQL database. If I use mysql_real_escape_string does this negate the requirement of magic_quotes (being on or off?) or the adding/stripping of slashes or the stripping of tags or trimming? I've researched the manual but I don't get the hierachy of what negates what. In my code below you'll notice I've added the mysql_real_escape_string to avoid any failed inserts due to conflicting characters. I have not however added this for uploading the file paths. Is this where adding and removing slashes would come into play? (I have not used magic_quotes because the manual says its identical to add slashes.) Oddly enough I came across this pearl of wisdom online: Is it critical that I trim each variable? Here's my code less the validation: <?php if (isset($_POST['submit'])){ //LOTS OF FORM VALIDATION HERE (OMMITTED) $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; copy($HTTP_POST_FILES['ufile']['tmp_name'][0], $path1); copy($HTTP_POST_FILES['ufile']['tmp_name'][1], $path2); copy($HTTP_POST_FILES['ufile']['tmp_name'][2], $path3); include("dbinfo.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to establish a connection to the relevant database."); $make = mysql_real_escape_string($_POST['make']); $model = mysql_real_escape_string($_POST['model']); $price = mysql_real_escape_string($_POST['price']); $engine = mysql_real_escape_string($_POST['engine']); $body = mysql_real_escape_string($_POST['body']); $transmission = mysql_real_escape_string($_POST['transmission']); $year =mysql_real_escape_string($_POST['year']); $colour =mysql_real_escape_string($_POST['colour']); $mileagem = mysql_real_escape_string($_POST['mileagem']); $mileagekm = mysql_real_escape_string($_POST['mileagekm']); $owners = mysql_real_escape_string($_POST['owners']); $doors = mysql_real_escape_string($_POST['doors']); $location = mysql_real_escape_string($_POST['location']); $info = mysql_real_escape_string($_POST['info']); $ipaddress = getenv('REMOTE_ADDR'); $query = "INSERT INTO test VALUES ('','$make','$model','$price','$engine','$body','$transmission','$year','$colour','$mileagem','$mileagekm','$owners','$doors','$location','$info',NOW(),'$ipaddress','$path1','$path2','$path1')"; mysql_query($query); exit(); } ?> <HTML> <BODY> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data"> <fieldset> <ol> <li> <label for="make">Make:</label> <input type="text" name="make" id="make" class="text" value="<?php if (isset($_POST['make'])) echo $_POST['make']; ?>"/> </br> </li> <li> <label for="model">Model:</label> <input type="text" name="model" id="model" class="text" value="<?php if (isset($_POST['model'])) echo $_POST['model']; ?>"/> </br> </li> <li> <label for="price">Price:</label> <input type="text" name="price" id="price" class="text" value="<?php if (isset($_POST['price'])) echo $_POST['price']; ?>"/> <?php if ($message_price) echo ''.$message_price.''; ?> </br> </li> <li> <label for="engine">Engine:</label> <input type="text" name="engine" id="engine" class="text" value="<?php if (isset($_POST['engine'])) echo $_POST['engine']; ?>"/> </li> <li> <label for="body">Body Type:</label> <input type="text" name="body" id="body" class="text" value="<?php if (isset($_POST['body'])) echo $_POST['body']; ?>"/> </li> <li> <label for="transmission">Transmission:</label> <input type="text" name="transmission" id="transmission" class="text" value="<?php if (isset($_POST['transmission'])) echo $_POST['transmission']; ?>"/> </br> </li> <li> <label for="year">Year:</label> <input type="text" name="year" id="year" class="text" value="<?php if (isset($_POST['year'])) echo $_POST['year']; ?>"/> </br> </li> <li> <label for="colour">Colour:</label> <input type="text" name="colour" id="colour" class="text" value="<?php if (isset($_POST['colour'])) echo $_POST['colour']; ?>"/> </li> <li> <label for="mileagem">Mileage M:</label> <input type="text" name="mileagem" id="mileagem" class="text" value="<?php if (isset($_POST['mileagem'])) echo $_POST['mileagem']; ?>"/> </br> </li> <li> <label for="mileagekm">Mileage KM:</label> <input type="text" name="mileagekm" id="mileagekm" class="text" value="<?php if (isset($_POST['mileagekm'])) echo $_POST['mileagekm']; ?>"/> </br> </li> <li> <label for="owners">Owners:</label> <input type="text" name="owners" id="owners" class="text" value="<?php if (isset($_POST['owners'])) echo $_POST['owners']; ?>"/> </br> </li> <li> <label for="doors">Doors:</label> <input type="text" name="doors" id="doors" class="text" value="<?php if (isset($_POST['doors'])) echo $_POST['doors']; ?>"/> </br> </li> <li> <label for="location">Location:</label> <input type="text" name="location" id="location" class="text" value="<?php if (isset($_POST['location'])) echo $_POST['location']; ?>"/> </li> <li> <label for="info">Additional Information:</label></br> <textarea name="info" rows="5" cols="50"/><?php if (isset($_POST['info'])) echo stripslashes($_POST['info']); ?></textarea> </br> </li> <li> <label for "ufile[]">Image File 1:</label> <input type="file" name="ufile[]" id="ufile[]"/> </li> <li> <label for "ufile[]">Image File 2:</label> <input type="file" name="ufile[]" id="ufile[]"/> </li> <li> <label for "ufile[]">Image File 3:</label> <input type="file" name="ufile[]" id="ufile[]"/> </br> </li> <li> <input name="submit" type="submit"> </li> </ol> </fieldset> </form> </BODY> </HTML>

Your 'under the hood' analogy makes a whole lot of sense too. I have a comfortable amount of time to get this done so loops and arrays it is then.

I suspect that you're eventually going to have some kind of if statement that looks something like this Yep, you're exactly right. I managed to get the two together like so (an if within an if but multiple booleans as you noted nonetheless): <?php if (strlen($_POST['price']) > 0) {$price=TRUE; if (is_numeric($_POST['price'])) {$pricenumericcheck=TRUE;} else {$pricenumericcheck=FALSE; $message_pricenumericcheck=" *Please enter numeric values only!"; echo "$message_pricenumericcheck";} } else {$price=FALSE; $message_price=" *You forgot to enter the price!";} ?> // display the error(s) using a loop, send $error back to form and list it there, or whatever you do in the event of fail Your suggestion is so much neater and shorter. To learn this method what keywords should I google? I tried "display error using loop" but that doesn't seem to pull up the results I need. // the user is not a moron, please proceed here Classic. Here's my full code btw. Not because I want you to examine anything in particular, I just wanted to give you an idea of how longwinded an approach I've taken with the error messages. <?php if (isset($_POST['submit'])) //PROCESS THE FORM WHEN THE SUBMIT BUTTON IS PRESSED { //VALIDATE THE INDIVIDUAL FIELDS AND DEFINE THEM AS TRUE OR FALSE BASED ON THE USER'S INPUT //REGULAR TEXT FIELDS if (strlen($_POST['make']) > 0) {$make=TRUE;} else {$make=FALSE; $message_make=" *You forgot to enter the make!";} if (strlen($_POST['model']) > 0) {$model=TRUE;} else {$model=FALSE; $message_model=" *You forgot to enter the model!"; } if (strlen($_POST['price']) > 0) {$price=TRUE; if (is_numeric($_POST['price'])) {$pricenumericcheck=TRUE;} else {$pricenumericcheck=FALSE; $message_pricenumericcheck=" *Please enter numeric values only!"; echo "$message_pricenumericcheck";} } else {$price=FALSE; $message_price=" *You forgot to enter the price!";} if (strlen($_POST['engine']) > 0) {$engine=TRUE;} else {$engine=FALSE; $message_engine=" *You forgot to enter the engine!";} if (strlen($_POST['body']) > 0) {$body=TRUE;} else {$body=FALSE; $message_body=" *You forgot to enter the body!";} if (strlen($_POST['transmission']) > 0) {$transmission=TRUE;} else {$transmission=FALSE; $message_transmission=" *You forgot to enter the transmission!";} if (strlen($_POST['year']) > 0) {$year=TRUE;} else {$year=FALSE; $message_year=" *You forgot to enter the year!";} if (strlen($_POST['colour']) > 0) {$colour=TRUE;} else {$colour=FALSE; $message_colour=" *You forgot to enter the colour!";} if (strlen($_POST['mileagem']) > 0) {$mileagem=TRUE;} else {$mileagem=FALSE; $message_mileagem=" *You forgot to enter the mileage in miles!";} if (strlen($_POST['mileagekm']) > 0) {$mileagekm=TRUE;} else {$mileagekm=FALSE; $message_mileagekm=" *You forgot to enter the mileage in kilometres!";} if (strlen($_POST['owners']) > 0) {$owners=TRUE;} else {$owners=FALSE; $message_owners=" *You forgot to enter the owner!";} if (strlen($_POST['doors']) > 0) {$doors=TRUE;} else {$doors=FALSE; $message_doors=" *You forgot to enter the doors!";} if (strlen($_POST['location']) > 0) {$location=TRUE;} else {$location=FALSE; $message_location=" *You forgot to enter the location!";} //TEXT AREA FIELD if (isset($_POST['info'])) { $info = trim($_POST['info']); if ($info == "" || empty($info)) { $message_info = "Please enter data for info!"; } } //UPLOAD FILE FIELDS //CHECK IF UPLOAD FILE FIELD 1 IS EMPTY $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if($filesize1==0) { $filesize1=FALSE; $message_filesize1="You forgot to enter this image file!"; //echo "$message_filesize1"; } else { $filesize1=TRUE; } //CHECK IF UPLOAD FILE FIELD 1 IS EMPTY $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if($filesize2==0) { $filesize2=FALSE; $message_filesize2="You forgot to enter this image file!"; //echo "$message_filesize2"; } else { $filesize2=TRUE; } //CHECK IF UPLOAD FILE FIELD 3 IS EMPTY $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if($filesize3==0) { $filesize3=FALSE; $message_filesize3="You forgot to enter this image file!"; //echo "$message_filesize3"; } else { $filesize3=TRUE; } //CHECK IF ANY THE FILES ARE THE SAME: $filenamecheck1= $HTTP_POST_FILES['ufile']['name'][0]; $filenamecheck2= $HTTP_POST_FILES['ufile']['name'][1]; $filenamecheck3= $HTTP_POST_FILES['ufile']['name'][2]; $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( (($filenamecheck1 == $filenamecheck2) || ($filenamecheck2 == $filenamecheck3) || ($filenamecheck1 == $filenamecheck3)) && ((!$filesize1==0 && isset($_POST['submit'])) && (!$filesize2==0 && isset($_POST['submit'])) && (!$filesize3==0 && isset($_POST['submit']))) ) { $filenamecheck_message = "one ore more of the files are the same"; //echo "$message_filenamecheck"; $message_filenamecheck = TRUE; $filenamecheck1= FALSE; $filenamecheck2= FALSE; $filenamecheck3= FALSE; } else { $message_filenamecheck = FALSE; $filenamecheck1= TRUE; $filenamecheck2= TRUE; $filenamecheck3= TRUE; } //CHECK IF FILE 1 IS NOT A *.JPEG OR *.GIF $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if ( ( ($HTTP_POST_FILES['ufile']["type"][0] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][0] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][0] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][0] < 50000) ) { $filetypecheck1=TRUE; } else { if (!($filesize1 == 0)) { $filetypecheck1=FALSE; $message_filetypecheck1="The first of the sumbitted files is not of a *.JPG ! *.GIF file type!"; //echo "$message_filetypecheck1"; } } //CHECK IF FILE 2 IS NOT A *.JPEG OR *.GIF $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if ( ( ($HTTP_POST_FILES['ufile']["type"][1] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][1] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][1] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][1] < 50000) ) { $filetypecheck2=TRUE; } else { if (!($filesize2 == 0)) { $filetypecheck2=FALSE; $message_filetypecheck2="The second of the sumbitted files is not of a *.JPG ! *.GIF file type!"; //echo "$message_filetypecheck2"; } } //CHECK IF FILE 3 IS NOT *.JPEG OR *.GIF $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( ( ($HTTP_POST_FILES['ufile']["type"][2] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][2] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][2] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][2] < 50000) ) { $filetypecheck3=TRUE; } else { if (!($filesize3 == 0)) { $filetypecheck3=FALSE; $message_filetypecheck3="The third of the sumbitted files is not of a *.JPG ! *.GIF file type!"; //echo "$message_filetypecheck3"; } } //CHECK IF FILE 1 EXISTS ALREADY $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if ( (file_exists($path1)) && (!($filesize1 == 0)) ) { $fileexistcheck1=FALSE; $message_fileexistcheck1="The first file already exist on the server!"; //echo "$message_fileexistcheck1"; } else { $fileexistcheck1=TRUE; } //CHECK IF FILE 2 EXISTS ALREADY $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if ( (file_exists($path2)) && (!($filesize2 == 0)) ) { $fileexistcheck2=FALSE; $message_fileexistcheck2="The second file already exist on the server!"; //echo "$message_fileexistcheck2"; } else { $fileexistcheck2=TRUE; } //CHECK IF FILE 3 EXISTS ALREADY $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( (file_exists($path3)) && (!($filesize3 == 0)) ) { $fileexistcheck3=FALSE; $message_fileexistcheck3="The third file already exist on the server!"; //echo "$message_fileexistcheck3"; } else { $fileexistcheck3=TRUE; } //IF ALL INPUT FIELDS ARE DEFINED AS TRUE / VALIDATED if ($make && $model && $price && $pricenumericcheck && $engine && $body && $transmission && $year && $colour && $mileagem && $mileagekm && $owners && $doors && $location && $info && $filesize1 && $filesize2 && $filesize3 && $filenamecheck1 && filenamecheck2 && filenamecheck3 && $filetypecheck1 && $filetypecheck2 && $filetypecheck3 && $fileexistcheck1 && $fileexistcheck2 && $fileexistcheck3) { //FIRST DEFINE PATHS AS VARIABLES $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; //NEXT POST THE IMAGES TO THE DESIGNATED FOLDER ON THE SERVER copy($HTTP_POST_FILES['ufile']['tmp_name'][0], $path1); copy($HTTP_POST_FILES['ufile']['tmp_name'][1], $path2); copy($HTTP_POST_FILES['ufile']['tmp_name'][2], $path3); //PICK UP AND DEFINE INPUT AS INDIVIDUAL VARIABLES //CONNECT TO RELEVANT DATABASE //THE CONNECTION MUST PRECEDE THE mysql_real_escape_string FUNCTION. include("dbinfo.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to establish a connection to the relevant database."); $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; $make = mysql_real_escape_string($_POST['make']); $model = mysql_real_escape_string($_POST['model']); $price = mysql_real_escape_string($_POST['price']); $engine = mysql_real_escape_string($_POST['engine']); $body = mysql_real_escape_string($_POST['body']); $transmission = mysql_real_escape_string($_POST['transmission']); $year =mysql_real_escape_string($_POST['year']); $colour =mysql_real_escape_string($_POST['colour']); $mileagem = mysql_real_escape_string($_POST['mileagem']); $mileagekm = mysql_real_escape_string($_POST['mileagekm']); $owners = mysql_real_escape_string($_POST['owners']); $doors = mysql_real_escape_string($_POST['doors']); $location = mysql_real_escape_string($_POST['location']); $info = mysql_real_escape_string($_POST['info']); //DEFINE ADDITIONAL VARIABLES /* PHP uses unix timestamps for all its date functionality. It has methods to convert these timestamps into pretty much any text format you could want but internally it uses the timestamp format. A timestamp is simply an unsigned integer. Specifically, it&#8217;s the number of seconds that have elapsed since midnight on January 1st 1970 (greenwich mean time). MySQL has three date types for use in columns. These are DATETIME, DATE, and TIMESTAMP. DATETIME EXAMPLE: YYYY-MM-DD HH:MM:SS (e.g. 2006-12-25 13:43:15) DATE EXAMPLE: YYYY-MM-DD (e.g. 2006-12-25) */ $now_datetime = date('Y-m-d h:i:s'); //$now_datetime = now(); $ipaddress = getenv('REMOTE_ADDR'); //CONNECTION WAS 'ERE //INSERT THE INPUT INTO DATABASE $query = "INSERT INTO test VALUES ('','$make','$model','$price','$engine','$body','$transmission','$year','$colour','$mileagem','$mileagekm','$owners','$doors','$location','$info',NOW(),'$ipaddress','$path1','$path2','$path1')"; mysql_query($query); //NEXT DISPLAY A SUMMARY OF WHAT HAS BEEN UPLOADED echo "This item has been successfully submitted to the server.</br></br> The following image file have been appended to your uploaded:</br></br> "; echo "File Name :".$HTTP_POST_FILES['ufile']['name'][0]."<BR/>"; //echo "File Size :".$HTTP_POST_FILES['ufile']['size'][0]." KB<BR/>"; echo "File Type :".$HTTP_POST_FILES['ufile']['type'][0]."<BR/>"; //echo "<img src=\"$path1\" height=\"150\">"; echo "<P>"; echo "File Name :".$HTTP_POST_FILES['ufile']['name'][1]."<BR/>"; //echo "File Size :".$HTTP_POST_FILES['ufile']['size'][1]."<BR/>"; echo "File Type :".$HTTP_POST_FILES['ufile']['type'][1]."<BR/>"; //echo "<img src=\"$path2\" height=\"150\">"; echo "<P>"; echo "File Name :".$HTTP_POST_FILES['ufile']['name'][2]."<BR/>"; //echo "File Size :".$HTTP_POST_FILES['ufile']['size'][2]."<BR/>"; echo "File Type :".$HTTP_POST_FILES['ufile']['type'][2]."<BR/>"; //echo "<img src=\"$path3\" height=\"150\">"; echo "</br>It's best practice to confirm that your item has been submitted as desired</br></br> [place button here to link to view relevant section]</br></br> If you notice an error as a result of human input please find and delete the item indefinitely and reattempt its submission. Items should also be deleted as soon as they become redundant (e.g. vehichle sold)</br></br> Should you experience further technical difficulty please contact the web master:</br></br> [place button here to link to web master cms error log form] "; //VERY IMPORTANT! EXIT(); WILL NO LONGER DISPLAY THE FORM exit(); //CLOSE: IF ALL INPUT FIELDS TRUE: } //CLOSE: OVERALL VALIDATION: } ?> <HTML> <HEAD> </HEAD> <BODY> <!--BEGIN FORM AND SET IT TO PROCESS SELF AND HANDLE MULTIPART/FORM-DATA--> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" enctype="multipart/form-data"> <fieldset> <?php // IF ANY INDIVIDUAL INPUT FIELD IS DEFINED AS FALSE THEN DISPLAY ERROR MESSAGE if ($message_make || $message_model || $message_price || $message_engine || $message_body || $message_transmission || $message_year || $message_colour || $message_mileagem || $message_mileagekm || $message_owners || $message_doors || $message_location || $message_info || $message_filesize2 || $message_filesize1 || $message_filesize2 || $message_filesize3 || $message_filesize1 || $message_filesize2 || $message_filesize3 || $message_filenamecheck || $message_filetypecheck1 || $message_filetypecheck2 || $message_filetypecheck3 || $message_fileexistcheck1 || $message_fileexistcheck2 || $message_fileexistcheck3) // echo '*Your request could not be sent because some of the information is missing.</br></br>'; ?> <ol> <!--BEGIN REGULAR TEXT FIELDS--> <li> <label for="make">Make:</label> <input type="text" name="make" id="make" class="text" value="<?php if (isset($_POST['make'])) echo $_POST['make']; ?>"/> <?php if ($message_make) echo ''.$message_make.''; ?></br> </li> <li> <label for="model">Model:</label> <input type="text" name="model" id="model" class="text" value="<?php if (isset($_POST['model'])) echo $_POST['model']; ?>"/> <?php if ($message_model) echo ''.$message_model.''; ?></br> </li> <li> <label for="price">Price:</label> <input type="text" name="price" id="price" class="text" value="<?php if (isset($_POST['price'])) echo $_POST['price']; ?>"/> <?php if ($message_price) echo ''.$message_price.''; ?></br> </li> <li> <label for="engine">Engine:</label> <input type="text" name="engine" id="engine" class="text" value="<?php if (isset($_POST['engine'])) echo $_POST['engine']; ?>"/> <?php if ($message_engine) echo ''.$message_engine.''; ?></br> </li> <li> <label for="body">Body Type:</label> <input type="text" name="body" id="body" class="text" value="<?php if (isset($_POST['body'])) echo $_POST['body']; ?>"/> <?php if ($message_body) echo ''.$message_body.''; ?></br> </li> <li> <label for="transmission">Transmission:</label> <input type="text" name="transmission" id="transmission" class="text" value="<?php if (isset($_POST['transmission'])) echo $_POST['transmission']; ?>"/> <?php if ($message_transmission) echo ''.$message_transmission.''; ?></br> </li> <li> <label for="year">Year:</label> <input type="text" name="year" id="year" class="text" value="<?php if (isset($_POST['year'])) echo $_POST['year']; ?>"/> <?php if ($message_year) echo ''.$message_year.''; ?></br> </li> <li> <label for="colour">Colour:</label> <input type="text" name="colour" id="colour" class="text" value="<?php if (isset($_POST['colour'])) echo $_POST['colour']; ?>"/> <?php if ($message_colour) echo ''.$message_colour.''; ?></br> </li> <li> <label for="mileagem">Mileage M:</label> <input type="text" name="mileagem" id="mileagem" class="text" value="<?php if (isset($_POST['mileagem'])) echo $_POST['mileagem']; ?>"/> <?php if ($message_mileagem) echo ''.$message_mileagem.''; ?></br> </li> <li> <label for="mileagekm">Mileage KM:</label> <input type="text" name="mileagekm" id="mileagekm" class="text" value="<?php if (isset($_POST['mileagekm'])) echo $_POST['mileagekm']; ?>"/> <?php if ($message_mileagekm) echo ''.$message_mileagekm.''; ?></br> </li> <li> <label for="owners">Owners:</label> <input type="text" name="owners" id="owners" class="text" value="<?php if (isset($_POST['owners'])) echo $_POST['owners']; ?>"/> <?php if ($message_owners) echo ''.$message_owners.''; ?></br> </li> <li> <label for="doors">Doors:</label> <input type="text" name="doors" id="doors" class="text" value="<?php if (isset($_POST['doors'])) echo $_POST['doors']; ?>"/> <?php if ($message_doors) echo ''.$message_doors.''; ?></br> </li> <li> <label for="location">Location:</label> <input type="text" name="location" id="location" class="text" value="<?php if (isset($_POST['location'])) echo $_POST['location']; ?>"/> <?php if ($message_location) echo ''.$message_location.''; ?></br> </li> <!--BEGIN TEXT AREA--> <li> <label for="info">Additional Information:</label></br> <textarea name="info" rows="5" cols="50"/> <?php if (isset($_POST['info'])) echo stripslashes($_POST['info']); ?> </textarea> <?php if ($message_info) echo ''.$message_info.''; ?></br> </li> <!--BEGIN FILE UPLOADS--> <li> <label for "ufile[]">Image File 1:</label> <input type="file" name="ufile[]" id="ufile[]"/> <!--NOTICE THAT THIS ERROR DOES NOT CALL ON A VARIABLE IN THE FORM PROCESS LIKE THE TEXT FIELDS.--> <?php //CHECK IF UPLOAD FILE FIELD 1 IS EMPTY $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if($filesize1==0 && isset($_POST['submit'])) { $filesize1=FALSE; $message_filesize1="You forgot to enter this image file!"; echo "$message_filesize1"; } else { $filesize1=TRUE; } //CHECK IF FILE 1 IS NOT A *.JPEG OR *.GIF $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if ( ( ($HTTP_POST_FILES['ufile']["type"][0] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][0] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][0] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][0] < 50000) ) { $filetypecheck1=TRUE; } else { if (!($filesize1 == 0)) { $filetypecheck1=FALSE; $message_filetypecheck1="The first of the sumbitted files is not of a *.JPG ! *.GIF file type!"; echo "$message_filetypecheck1"; } } //CHECK IF FILE 1 EXISTS ALREADY $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; if ( (file_exists($path1)) && (!($filesize1 == 0)) ) { $fileexistcheck1=FALSE; $message_fileexistcheck1="The first file already exist on the server!"; echo "$message_fileexistcheck1";} else { $fileexistcheck1=TRUE; } ?> </li> <li> <label for "ufile[]">Image File 2:</label> <input type="file" name="ufile[]" id="ufile[]"/> <!--NOTICE THAT THIS ERROR DOES NOT CALL ON A VARIABLE IN THE FORM PROCESS LIKE THE TEXT FIELDS.--> <?php $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if($filesize2==0 && isset($_POST['submit'])) { $filesize2=FALSE; $message_filesize2="You forgot to enter this image file!"; echo "$message_filesize2"; } else { $filesize2=TRUE; } //CHECK IF FILE 2 IS NOT A *.JPEG OR *.GIF $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if ( ( ($HTTP_POST_FILES['ufile']["type"][1] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][1] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][1] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][1] < 50000) ) { $filetypecheck2=TRUE; } else { if (!($filesize2 == 0)) { $filetypecheck2=FALSE; $message_filetypecheck2="The second of the sumbitted files is not of a *.JPG ! *.GIF file type!"; echo "$message_filetypecheck2"; } } //CHECK IF FILE 2 EXISTS ALREADY $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; if ( (file_exists($path2)) && (!($filesize2 == 0)) ) { $fileexistcheck2=FALSE; $message_fileexistcheck2="The second file already exist on the server!"; echo "$message_fileexistcheck2";} else { $fileexistcheck2=TRUE; } ?> </li> <li> <label for "ufile[]">Image File 3:</label> <input type="file" name="ufile[]" id="ufile[]"/> <!--NOTICE THAT THIS ERROR DOES NOT CALL ON A VARIABLE IN THE FORM PROCESS LIKE THE TEXT FIELDS.--> <?php $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if($filesize3==0 && isset($_POST['submit'])) { $filesize3=FALSE; $message_filesize3="You forgot to enter this image file!"; echo "$message_filesize3"; } else { $filesize3=TRUE; } //CHECK IF FILE 3 IS NOT *.JPEG OR *.GIF $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( ( ($HTTP_POST_FILES['ufile']["type"][2] == "image/gif") || ($HTTP_POST_FILES['ufile']["type"][2] == "image/jpeg") || ($HTTP_POST_FILES['ufile']["type"][2] == "image/pjpeg") ) // &&($HTTP_POST_FILES['ufile']["size"][2] < 50000) ) { $filetypecheck3=TRUE; } else { if (!($filesize3 == 0)) { $filetypecheck3=FALSE; $message_filetypecheck3="The third of the sumbitted files is not of a *.JPG ! *.GIF file type!"; echo "$message_filetypecheck3"; } } //CHECK IF FILE 3 EXISTS ALREADY $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( (file_exists($path3)) && (!($filesize3 == 0)) ) { $fileexistcheck3=FALSE; $message_fileexistcheck3="The third file already exist on the server!"; echo "$message_fileexistcheck3";} else { $fileexistcheck3=TRUE; } ?> <?php //CHECK IF ANY THE FILES ARE THE SAME: $filenamecheck1= $HTTP_POST_FILES['ufile']['name'][0]; $filenamecheck2= $HTTP_POST_FILES['ufile']['name'][1]; $filenamecheck3= $HTTP_POST_FILES['ufile']['name'][2]; $filesize1=$HTTP_POST_FILES['ufile']['size'][0]; $filesize2=$HTTP_POST_FILES['ufile']['size'][1]; $filesize3=$HTTP_POST_FILES['ufile']['size'][2]; if ( (($filenamecheck1 == $filenamecheck2) || ($filenamecheck2 == $filenamecheck3) || ($filenamecheck1 == $filenamecheck3)) && ((!$filesize1==0 && isset($_POST['submit'])) && (!$filesize2==0 && isset($_POST['submit'])) && (!$filesize3==0 && isset($_POST['submit']))) ) { $filenamecheck_message = "one ore more of the files are the same"; echo "$filenamecheck_message"; $filenamecheck_message = TRUE; //$filenamecheck1= FALSE; //$filenamecheck2= FALSE; //$filenamecheck3= FALSE; } else { $filenamecheck_message = FALSE; //$filenamecheck1= TRUE; //$filenamecheck2= TRUE; //$filenamecheck3= TRUE; } ?> </li> <li> <input name="submit" type="submit"> </li> </ol> </fieldset> </form> </BODY> </HTML> I've ended up posting the more or less the exact same php blocks code in the process and form section.

By chance I tried this out and it works: <?php //ERROR 1 if (strlen($_POST['price']) > 0) {$price=TRUE;} else {$price=FALSE; $message_price=" *You forgot to enter the price!";} //ERROR 2 if ($price) { if (is_numeric($_POST['price'])) {$pricenumericcheck=TRUE;} else {$pricenumericcheck=FALSE; $message_pricenumericcheck=" *Please enter numeric values only!"; echo "$message_pricenumericcheck";} } ?> It just seems so long winded.

Nope. I expect a variable that doesn't exist to result in the first error message. If a variable does exist then I expect it to be numeric which will be flagged by the second error message. Or did that just go over my head?

Hi All, I have a minor problem with my error messages. The second error message (checking for non-numeric input) pops up even when the text field is blank. <?php //ERROR 1: FIRST CHECK THAT THE FIELD IS NOT EMPTY if (strlen($_POST['price']) > 0) {$price=TRUE;} else {$price=FALSE; $message_price=" *You forgot to enter the price!"; echo "$message_price";} //ERROR 2: NEXT CHECK THAT THE INPUT IS NUMERIC if (is_numeric($_POST['price'])) {$price=TRUE;} else {$price=FALSE; $message_price2=" *Please enter numeric values only!"; echo "$message_price2";} ?> I tried playing around with isset but to no effect. Any takers?

Overlooked this despite reading it. I'll stick with NOW() based on your reccommendation:

That's it, thanks!

Hi All, I've studied the above suggestions and provided links. Redarrows approach results in inserts like 1227300237 ??? : <?php $now_datetime = time(); //set the database field to a int. ?> I've also tried PFMaBiSmAd approach but I get an error saying the now() function is undefined: <?php if(isset($_POST['submit'])) { $query = "INSERT INTO test VALUES ('','','','','','','','','','','','','','','','now()','$ipaddress','','','')"; mysql_query($query); } ?> I get the same error for: <?php $now_datetime = now(); if(isset($_POST['submit'])) { $query = "INSERT INTO test VALUES ('','','','','','','','','','','','','','','','$now_datetime','$ipaddress','','','')"; mysql_query($query); } ?> If I try the following with the mySQL column set as INT(100) only '2008' is inserted: <?php $now_datetime = date('Y-m-d h:i:s'); if(isset($_POST['submit'])) { $query = "INSERT INTO test VALUES ('','','','','','','','','','','','','','','','$now_datetime','$ipaddress','','','')"; mysql_query($query); } ?> Finally the following (column set as datetime) results in a 12 hour time format so I cannot tell whether I'm dealing with AM or PM: <?php $now_datetime = date('Y-m-d h:i:s'); if(isset($_POST['submit'])) { $query = "INSERT INTO test VALUES ('','','','','','','','','','','','','','','','$now_datetime','$ipaddress','','','')"; mysql_query($query); } ?> Can anybody offer some guidance as to what I should be looking at next?

Thanks for the code redarrow. When you 'format properly' are you refering to my lack of mysql_real_escape_string (I'm checking this out in the manual now) or something else?

Here's my code btw though I'm not too sure how its going to tie in with redarrows method: <?php //PICK UP AND DEFINE INPUT AS INDIVIDUAL VARIABLES $path1= "upload/".$HTTP_POST_FILES['ufile']['name'][0]; $path2= "upload/".$HTTP_POST_FILES['ufile']['name'][1]; $path3= "upload/".$HTTP_POST_FILES['ufile']['name'][2]; $make = $_POST['make']; $model = $_POST['model']; $price = $_POST['price']; $engine = $_POST['engine']; $body = $_POST['body']; $transmission = $_POST['transmission']; $year = $_POST['year']; $colour = $_POST['colour']; $mileagem = $_POST['mileagem']; $mileagekm = $_POST['mileagekm']; $owners = $_POST['owners']; $doors = $_POST['doors']; $location = $_POST['location']; //DEFINE ADDITIONAL VARIABLES $now_datetime = date('Y-m-d h:i:s'); $ipaddress = getenv('REMOTE_ADDR'); //CONNECT TO RELEVANT DATABASE include("dbinfo.php"); mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to establish a connection to the relevant database."); //INSERT THE INPUT INTO DATABASE $query = "INSERT INTO test VALUES ('','$make','$model','$price','$engine','$body','$transmission','$year','$colour','$mileagem','$mileagekm','$owners','$doors','$location','$info','$now_datetime','$ipaddress','$path1','$path2','$path1')"; mysql_query($query); ?>

Just checked that out here: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_now It doesn't seem to include AM, PM or the day of the week. I'd like to know how to do this through PHP (or is this bad practice?).

Hi All, I've attempted to write the following variable into my database: $now_datetime = date('D Y-m-d h:i:s a'); It writes back as 0000-00-00 00:00:00 which obviously indicates something has gone wrong. I've used the following successfully: $now_datetime = date('Y-m-d h:i:s'); Any ideas why the former isn't inserting correctly? I suspect it's to do with my string. I've checked the manual already.