VinceGledhill Posted July 20, 2011 Share Posted July 20, 2011 Hi people. I have some \r\n characters in my database, but there by user input of the enter key to go to the next line. However, in my output form I get the \r\n character instead of the desired effect. Please could you tell me what I need to add, and to where in my output box to get it to show correctly. I don't want it to be removed from the DB obviously because the line breaks won't be there. <?php $host = 'localhost'; $usr = "DatabaseUsername"; $password = 'thepassword'; $db_name = 'DataBaseName'; $id = 19; mysql_connect ("$host","$usr","$password") or die ('Error During Connect:<br>'.mysql_error()); mysql_select_db ("$db_name") or die ('Error Selecting DB:<br>'.mysql_error()); $read_query = "select * from users where user_id = '$id'"; $results = mysql_query($read_query); $rs = mysql_fetch_array($results); ?> <!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> </head> <body> Airfield Name: <? echo $rs["username"]; ?> <table width="720" border="1" bordercolor = "#2c2cf6" textcolor = "#2c2cf6"cellspacing="1" cellpadding="5"> <tr> <td width="120" bgcolor = #E6F8EB>Height Above MSL</td> <td width="120" bgcolor = #E6F8EB>Mb Difference</td> <td width="120" bgcolor = #E6F8EB>Alternative</td> <td width="120" bgcolor = #E6F8EB>PPR?</td> <td width="120" bgcolor = #E6F8EB>Location General</td> <td width="120" bgcolor = #E6F8EB>Location Grid Ref:</td> </tr> <tr> <td bgcolor = #E6F8EB textcolor = #AC1636><strong><? echo $rs["height_above"]; ?></strong></td> <td bgcolor = #E6F8EB><strong><? echo $rs["mb_diff"]; ?></strong></td> <td bgcolor = #E6F8EB><strong><? echo $rs["alternative"]; ?></strong></td> <td bgcolor = #E6F8EB><strong><? echo $rs["ppr"]; ?></strong></td> <td bgcolor = #E6F8EB><strong><? echo $rs["general_location"]; ?></strong></td> <td bgcolor = #E6F8EB><strong><? echo $rs["location_grid"]; ?></strong></td> </tr> <tr> <td bgcolor = #dbeff8>Runway Numbers</td> <td bgcolor = #dbeff8>Circuit Direction</td> <td bgcolor = #dbeff8>Circuit Height</td> <td bgcolor = #dbeff8>Runway Length</td> <td bgcolor = #dbeff8>Runway Surface</td> <td bgcolor = #dbeff8>Food? </td> </tr> <tr> <td bgcolor = #dbeff8><strong><? echo $rs["runway_numbers"]; ?></strong></td> <td bgcolor = #dbeff8><strong><? echo $rs["circuit_direction"]; ?></strong></td> <td bgcolor = #dbeff8><strong><? echo $rs["circuit_height"]; ?></strong></td> <td bgcolor = #dbeff8><strong><? echo $rs["runway_length"]; ?></strong></td> <td bgcolor = #dbeff8><strong><? echo $rs["surface"]; ?></strong></td> <td bgcolor = #dbeff8><strong><? echo $rs["food"]; ?></strong></td> </tr> <tr> <td bgcolor = #E6F8EB>Radio Frequency</td> <td bgcolor = #E6F8EB>Radio Callsign</td> <td bgcolor = #E6F8EB>Radio Type</td> <td bgcolor = #E6F8EB>Other Radio</td> <td bgcolor = #E6F8EB>Fuel?</td> <td bgcolor = #E6F8EB>Landing Fee £</td> </tr> <tr> <td bgcolor = #E6F8EB><strong><? echo $rs["radio_frequency"]; ?></strong></td> <td bgcolor = #E6F8EB><strong><? echo $rs["radio_callsign"]; ?></strong></td> <td bgcolor = #E6F8EB><strong><? echo $rs["radio_type"]; ?></strong></td> <td bgcolor = #E6F8EB><strong><? echo $rs["other_radio"]; ?></strong></td> <td bgcolor = #E6F8EB><strong><? echo $rs["fuel"]; ?></strong></td> <td bgcolor = #E6F8EB><strong><? echo $rs["landing_fee"]; ?></strong></td> </tr> <tr> <td bgcolor = #dbeff8>Opperating Hrs</td> <td bgcolor = #dbeff8>Maintenance</td> <td bgcolor = #dbeff8>Hangarage</td> <td bgcolor = #dbeff8>Parking</td> <td bgcolor = #dbeff8>Accommodation</td> <td bgcolor = #dbeff8>School ?</td> </tr> <tr> <td bgcolor = #dbeff8><strong><? echo $rs["operating_hours"]; ?></strong></td> <td bgcolor = #dbeff8><strong><? echo $rs["maintenance"]; ?></strong></td> <td bgcolor = #dbeff8><strong><? echo $rs["hangarage"]; ?></strong></td> <td bgcolor = #dbeff8><strong><? echo $rs["parking"]; ?></strong></td> <td bgcolor = #dbeff8><strong><? echo $rs["accommodation"]; ?></strong></td> <td bgcolor = #dbeff8><strong><? echo $rs["school"]; ?></strong></td> </tr> <tr> <td colspan="6"><p>Remarks<p><strong><? echo $rs["remarks"]; ?></strong></td> </tr> <tr> <td colspan="6"><p>Warnings:</p> <p><strong><? echo $rs["warnings"]; ?></strong></p> <p> </p></td> </tr> <tr> <td colspan="3"><p>Website: </p> <p><strong><? echo $rs["weblinks"]; ?></strong></p></td> <td colspan="3"><p>Operator:</p> <p><strong><? echo $rs["operator"]; ?></strong></p></td> </tr> <tr> <td colspan="6">Google Ifram Image<br /><strong><? echo $rs["google_image"]; ?></strong></td> </tr> </table> </body> </html> </html> Quote Link to comment https://forums.phpfreaks.com/topic/242461-please-help-with-output-from-db/ Share on other sites More sharing options...
QuickOldCar Posted July 20, 2011 Share Posted July 20, 2011 Use the nl2br function http://php.net/manual/en/function.nl2br.php Quote Link to comment https://forums.phpfreaks.com/topic/242461-please-help-with-output-from-db/#findComment-1245303 Share on other sites More sharing options...
VinceGledhill Posted July 21, 2011 Author Share Posted July 21, 2011 Hi Mate, thanks for your input. I've tried and better tried to get it to work but failed. Please could you tell me exactly what to put into the following output I have on my site. <p><strong><? echo $rs ["operator"]; ?></strong></p></td> The output on the site http://microlight.co/index.php/huddersfield currently looks like this Operator: J Whitham\r\nHuddersfield Aviation Ltd\r\nThe Airfield\r\nCrossland Moor\r\nHD4 7AG\r\n01484 645784 When it should look like this... Operator: J Whitham Huddersfield Aviation Ltd The Airfield Crossland Moor HD4 7AG 01484 645784 Quote Link to comment https://forums.phpfreaks.com/topic/242461-please-help-with-output-from-db/#findComment-1245777 Share on other sites More sharing options...
TeNDoLLA Posted July 21, 2011 Share Posted July 21, 2011 <p><strong><?php echo nl2br($rs["operator"]); ?></strong></p></td> Quote Link to comment https://forums.phpfreaks.com/topic/242461-please-help-with-output-from-db/#findComment-1245782 Share on other sites More sharing options...
VinceGledhill Posted July 21, 2011 Author Share Posted July 21, 2011 Hi TeNDoLLA. Thanks for your input. I have changed it as you have said but nothing has changed on the site. See http://microlight.co/index.php/huddersfield Any ideas? Quote Link to comment https://forums.phpfreaks.com/topic/242461-please-help-with-output-from-db/#findComment-1245788 Share on other sites More sharing options...
wildteen88 Posted July 21, 2011 Share Posted July 21, 2011 PHP should not be outputting newlines as literal text \r\n. For some reason newlines are stored like that within your database. You must be doing something with the data when adding the data to the database to cause this. You do not need to doing anything special to have PHP output newlines within text, expect when displaying new lines within the browser you need to use the nl2br function as TeNDoLLA mentioned. For now you will have manually replace each instead of \r\n with a <br /> tag $content = 'hello \r\n world!'; $content = str_replace('\r\n', "\r\n<br />", $content); echo $content; What code are you using to add the data to the database? Quote Link to comment https://forums.phpfreaks.com/topic/242461-please-help-with-output-from-db/#findComment-1245810 Share on other sites More sharing options...
VinceGledhill Posted July 22, 2011 Author Share Posted July 22, 2011 Hi wildteen88. Thanks for your message. Here is my input form <!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> </head> <body> <?php $host = 'localhost'; $usr = "TheUserName"; $password = 'thepassword'; $db_name = 'DBname'; //connect to database mysql_connect ("$host","$usr","$password") or die ('Error During Connect:<br>'.mysql_error()); mysql_select_db ("$db_name") or die ('Error Selecting DB:<br>'.mysql_error()); $username = mysql_real_escape_string($_POST['username']); $height_above = mysql_real_escape_string($_POST['height_above']); $mb_diff = mysql_real_escape_string($_POST['mb_diff']); $alternative = mysql_real_escape_string($_POST['alternative']); $ppr = mysql_real_escape_string($_POST['ppr']); $general_location = mysql_real_escape_string($_POST['general_location']); $location_grid = mysql_real_escape_string($_POST['location_grid']); $runway_numbers = mysql_real_escape_string($_POST['runway_numbers']); $circuit_direction = mysql_real_escape_string($_POST['circuit_direction']); $circuit_height = mysql_real_escape_string($_POST['circuit_height']); $runway_length = mysql_real_escape_string($_POST['runway_length']); $surface = mysql_real_escape_string($_POST['surface']); $food = mysql_real_escape_string($_POST['food']); $radio_frequency = mysql_real_escape_string($_POST['radio_frequency']); $radio_callsign = mysql_real_escape_string($_POST['radio_callsign']); $radio_type = mysql_real_escape_string($_POST['radio_type']); $other_radio = mysql_real_escape_string($_POST['other_radio']); $fuel = mysql_real_escape_string($_POST['fuel']); $landing_fee = mysql_real_escape_string($_POST['landing_fee']); $operating_hours = mysql_real_escape_string($_POST['operating_hours']); $maintenance = mysql_real_escape_string($_POST['maintenance']); $hangarage = mysql_real_escape_string($_POST['hangarage']); $parking = mysql_real_escape_string($_POST['parking']); $accommodation = mysql_real_escape_string($_POST['accommodation']); $school = mysql_real_escape_string($_POST['school']); $remarks = mysql_real_escape_string($_POST['remarks']); $warnings = mysql_real_escape_string($_POST['warnings']); $weblinks = mysql_real_escape_string($_POST['weblinks']); $operator = mysql_real_escape_string($_POST['operator']); $google_image = mysql_real_escape_string($_POST['google_image']); $errorstring = ""; // default value of errorstring if(isset($_POST['submit'])) { // Validate all the code inputs // Captcha Validation require_once('recaptchalib.php'); $privatekey = "myprivatekey"; $resp = recaptcha_check_answer ($privatekey, $_SERVER["REMOTE_ADDR"], $_POST["recaptcha_challenge_field"], $_POST["recaptcha_response_field"]); if (!$resp->is_valid) { // What happens when the CAPTCHA was entered incorrectly $errorstring = $errorstring. "Invalid CAPTCHA, please try again"; } else { if ($username =="") $errorstring = $errorstring. "Airfield Name<br>"; if ($height_above =="") $errorstring = $errorstring. "Height Above Mean Sea Level<br>"; if ($mb_diff =="") $errorstring = $errorstring. "mb Difference<br>"; if ($alternative =="") $errorstring = $errorstring. "Alternative Airfield<br>"; if ($general_location =="") $errorstring = $errorstring. "General Location<br>"; if ($location_grid =="") $errorstring = $errorstring. "Grid Reference<br>"; if ($runway_numbers =="") $errorstring = $errorstring. "Runway Numbers<br>"; if ($circuit_direction =="") $errorstring = $errorstring. "Circuit Direction<br>"; if ($circuit_height =="") $errorstring = $errorstring. "Circuit Height<br>"; if ($runway_length =="") $errorstring = $errorstring. "Runway Length<br>"; if ($radio_frequency =="") $errorstring = $errorstring. "Radio Frequency<br>"; if ($radio_callsign =="") $errorstring = $errorstring. "Radio Callsign<br>"; if ($other_radio =="") $errorstring = $errorstring. "Other Radio<br>"; if ($landing_fee =="") $errorstring = $errorstring. "Landing Fee<br>"; if ($remarks =="") $errorstring = $errorstring. "Remarks<br>"; if ($warnings =="") $errorstring = $errorstring. "Warnings<br>"; if ($weblinks =="") $errorstring = $errorstring. "Web Links<br>"; if ($operator =="") $errorstring = $errorstring. "Operator<br>"; if ($google_image =="") $errorstring = $errorstring. "Google Image<br>"; // does the errorstring = "nothing"? } // Figure out which error message to show i.e. field validation or CAPTCHA if ($errorstring !="") if (strstr($errorstring,"CAPTCHA")) echo $errorstring; else echo "You have not put anything in the following fields: <br><br> $errorstring"; //echo "If you have nothing to put in the box please type the word \"None\" or \"N\/A\""; //die ("Please try again, ensuring that you fill out all the fields!"); else { //echo "Your data has been saved"; $insert_query = "INSERT INTO users (username, height_above, mb_diff, alternative, ppr, general_location, location_grid, runway_numbers, circuit_direction, circuit_height, runway_length, surface, food, radio_frequency, radio_callsign, radio_type, other_radio, fuel, landing_fee, operating_hours, maintenance, hangarage, parking, accommodation, school, remarks, warnings, weblinks, operator, google_image) VALUES ('$username', '$height_above', '$mb_diff', '$alternative', '$ppr', '$general_location', '$location_grid', '$runway_numbers', '$circuit_direction', '$circuit_height', '$runway_length', '$surface', '$food', '$radio_frequency', '$radio_callsign', '$radio_type', '$other_radio', '$fuel', '$landing_fee', '$operating_hours', '$maintenance', '$hangarage', '$parking', '$accommodation' , '$school', '$remarks', '$warnings', '$weblinks', '$operator', '$google_image')"; $insert_action = mysql_query($insert_query) or die ('Error During Insert :<br>'.mysql_error().'<br><br>Error occured running the following code :<br>'.$insert_query); $id = mysql_insert_id(); echo "Thank you, Your airfield has been submitted."; include "resultcard.php"; // Output what the form looks like // End of how the form looks } } if(!isset($_POST['submit']) || (isset($_POST['submit']) && !empty($errorstring))) { ?> <form name = "form1" method ="post" action=""> <table width="700" border="0" cellspacing="5" cellpadding="5" bgcolor = "#c9e1d0"> <caption> Submit Your Airfield Details </caption> <tr> <td width = "50"> </td> <td width = "240"> </td> <td width = "250"> </td> <td width = "160"><b>Example Input</b></td> </tr> <tr> <td> </td> <td>Airfield Name</td> <td><input type='text' name='username' size = '40' maxlength='30' value = '<?php echo $username; ?>'></td> <td>Ince Blundell</td> </tr> <tr> <td> </td> <td>Height Above MSL</td> <td><input type='text' name='height_above' size = '40' maxlength= '30'value = '<?php echo $height_above; ?>'></td> <td>65 Ft</td> </tr> <tr> <td> </td> <td>Mb Difference</td> <td><input type='text' name='mb_diff' size = '40' maxlength='40'value = '<?php echo $mb_diff; ?>'></td> <td>2 Mb</td> </tr> <tr> <td> </td> <td>Alternative Airfield</td> <td><input type='text' name='alternative' size = '40' maxlength='30' value = '<?php echo $alternative; ?>'></td> <td>Sherburn</td> </tr> <tr> <td> </td> <td>PPR?</td> <td> <select name = "ppr"> <option value = "Yes" <?php if ($_POST['ppr'] == 'Yes') { echo 'selected="selected"'; } ?>>Yes</option> <option value="No" <?php if ($_POST['ppr'] == 'No') { echo 'selected="selected"'; } ?>>No</option> </select> </td> <td>Yes</td> </tr> <tr> <td> </td> <td>General Location</td> <td><input type='text' name='general_location' size = '40' maxlength='50' value = '<?php echo $general_location; ?>' /></td> <td>3 Nm North Luton</td> </tr> <tr> <td> </td> <td>Location Grid Reference</td> <td><textarea name= "location_grid" input type = 'text' rows = "2" cols = "29" /><?php echo $location_grid; ?></textarea></td> <td> 53°57'7.68"N<br /> 1°10'30.33"W</td> </tr> <tr> <td> </td> <td>Runway Numbers</td> <td><textarea name= "runway_numbers" input type = 'text' rows = "5" cols = "29" /><?php echo $runway_numbers; ?></textarea></td> <td><p>This format please<br /> 05-23<br /> 18-36<br /> 14-22 </p></td> </tr> <tr> <td> </td> <td>Circuit Direction</td> <td><textarea name= "circuit_direction" input type = "text" rows = "5" cols = "29" /><?php echo $circuit_direction; ?></textarea></td> <td><p>05-LH<br /> 23-RH<br /> 14-LH </p></td> </tr> <tr> <td> </td> <td>Circuit Height</td> <td><input type='text' name='circuit_height' size = '40' maxlength='50' value = '<?php echo $circuit_height; ?>' /></td> <td>1000 Ft</td> </tr> <tr> <td> </td> <td>Runway Length</td> <td><input type='text' name='runway_length' size = '40'maxlength='50' value = '<?php echo $runway_length; ?>' /></td> <td>500m</td> </tr> <tr> <td> </td> <td>Runway Surface</td> <td> <select name = "surface"> <option value = "Grass" <?php if ($_POST['surface'] == 'Grass') { echo 'selected="selected"'; } ?>>Grass</option> <option value = "Tarmac" <?php if ($_POST['surface'] == 'Tarmac') { echo 'selected="selected"'; } ?>>Tarmac</option> <option value = "Concrete" <?php if ($_POST['surface'] == 'Concrete') { echo 'selected="selected"'; } ?>>Concrete</option> <option value = "Dirt" <?php if ($_POST['surface'] == 'Dirt') { echo 'selected="selected"'; } ?>>Dirt</option> </select> <!-- <select name = "surface"> <option value = "Grass">Grass</option> <option value="Tarmac">Tarmac</option> <option value ="Concrete">Concrete</option> <option value = "Dirt">Dirt</option> </select> --> </td> <td> </td> </tr> <tr> <td> </td> <td>Food?</td> <td> <select name = "food"> <option value = "Cafe" <?php if ($_POST['food'] == 'Cafe') { echo 'selected="selected"'; } ?>>Cafe</option> <option value = "None" <?php if ($_POST['food'] == 'None') { echo 'selected="selected"'; } ?>>None</option> <option value = "Tea and Coffee" <?php if ($_POST['food'] == 'Tea and Coffee') { echo 'selected="selected"'; } ?>>Tea and Coffee</option> <option value = "Make Your Own" <?php if ($_POST['food'] == 'Make Your Own') { echo 'selected="selected"'; } ?>>Make Your Own</option> </select> <!-- <select name = "food"> <option value = "Cafe">Cafe</option> <option value="None">None</option> <option value ="Tea and Coffee">Tea and Coffee</option> <option value = "Make Your Own">Make Your Own</option> </select> --> </td> <td> </td> </tr> <tr> <td> </td> <td>Radio Frequency</td> <td><input type='text' name='radio_frequency' size = '40'maxlength='50' value = '<?php echo $radio_frequency; ?>' /></td> <td>135.475</td> </tr> <tr> <td> </td> <td>Radio Callsign</td> <td><input type='text' name='radio_callsign' size = '40'maxlength='50' value = '<?php echo $radio_callsign; ?>' /></td> <td>Rufforth Traffic</td> </tr> <tr> <td> </td> <td>Radio Type</td> <td> <select name = "radio_type"> <option value = "Safety Com" <?php if ($_POST['radio_type'] == 'Safety Com') { echo 'selected="selected"'; } ?>>Safety Com</option> <option value = "Air Ground" <?php if ($_POST['radio_type'] == 'Air Ground') { echo 'selected="selected"'; } ?>>Air Ground</option> <option value = "Approach" <?php if ($_POST['radio_type'] == 'Approach') { echo 'selected="selected"'; } ?>>Approach</option> <option value = "Tower" <?php if ($_POST['radio_type'] == 'Tower') { echo 'selected="selected"'; } ?>>Tower</option> </select> <!-- <select name = "radio_type"> <option value = "Sefety Com">Safety Com</option> <option value="Air Ground">Air Ground</option> <option value ="Approach">Approach</option> <option value = "Tower">Tower</option> </select> --> </td> <td> </td> </tr> <tr> <td> </td> <td>Other Radio</td> <td><input type='text' name='other_radio' size = '40' maxlength='50' value = '<?php echo $other_radio; ?>' /></td> <td>E.G. if close to MATZ etc</td> </tr> <tr> <td> </td> <td>Fuel</td> <td> <select name = "fuel"> <option value = "AvGas" <?php if ($_POST['fuel'] == 'AvGas') { echo 'selected="selected"'; } ?>>AvGas</option> <option value = "MoGas" <?php if ($_POST['fuel'] == 'MoGas') { echo 'selected="selected"'; } ?>>MoGas</option> <option value = "AvGas and MoGas" <?php if ($_POST['fuel'] == 'AvGas and MoGas') { echo 'selected="selected"'; } ?>>AvGas and MoGas</option> <option value = "We will sort you some" <?php if ($_POST['fuel'] == 'We will sort you some') { echo 'selected="selected"'; } ?>>We will sort you some</option> <option value = "None" <?php if ($_POST['fuel'] == 'None') { echo 'selected="selected"'; } ?>>None</option> </select> <!-- <select name = "fuel"> <option value = "AvGas">AvGas</option> <option value="MoGas">MoGas</option> <option value ="AvGas and MoGas">AvGas and MoGas</option> <option value = "We will sort you some">We will sort you some</option> <option value = "None">None</option> </select> --> </td> <td> </td> </tr> <tr> <td> </td> <td>Landing Fee</td> <td><input type='text' name='landing_fee' size = '40' maxlength='50' value = '<?php echo $landing_fee; ?>' /></td> <td>£ or Nill </td> </tr> <tr> <td> </td> <td>Operating Hours</td> <td> <select name = "operating_hours"> <option value = "SR - SS" <?php if ($_POST['operating_hours'] == 'SR - SS') { echo 'selected="selected"'; } ?>>SR - SS</option> <option value="Other - See Remarks" <?php if ($_POST['operating_hours'] == 'Other - See Remarks') { echo 'selected="selected"'; } ?>>Other - See Remarks</option> </select> <!-- <select name = "operating_hours"> <option value = "SR - SS">Sunrise - Sunset</option> <option value="See Remarks">Other - See Remarks</option> </select> --> </td> <td> </td> </tr> <tr> <td> </td> <td>Maintenance?</td> <td> <select name = "maintenance"> <option value = "Yes" <?php if ($_POST['maintenance'] == 'Yes') { echo 'selected="selected"'; } ?>>Yes</option> <option value="No" <?php if ($_POST['maintenance'] == 'No') { echo 'selected="selected"'; } ?>>No</option> </select> <!-- <select name = "maintenance"> <option value = "Yes">Yes </option> <option value="No">No </option> </select> --> </td> <td> </td> </tr> <tr> <td> </td> <td>Hangarage?</td> <td> <select name = "hangarage"> <option value = "Yes" <?php if ($_POST['hangarage'] == 'Yes') { echo 'selected="selected"'; } ?>>Yes</option> <option value="No" <?php if ($_POST['hangarage'] == 'No') { echo 'selected="selected"'; } ?>>No</option> </select> <!-- <select name = "hangarage"> <option value = "Yes">Yes </option> <option value="No">No </option> </select> --> </td> <td> </td> </tr> <tr> <td> </td> <td>Parking?</td> <td> <select name = "parking"> <option value = "Yes" <?php if ($_POST['parking'] == 'Yes') { echo 'selected="selected"'; } ?>>Yes</option> <option value="No" <?php if ($_POST['parking'] == 'No') { echo 'selected="selected"'; } ?>>No</option> </select> <!-- <select name = "parking"> <option value = "Yes">Yes </option> <option value="No">No </option> </select> --> </td> <td> </td> </tr> <tr> <td> </td> <td>Accommodation?</td> <td> <select name = "accommodation"> <option value = "Yes" <?php if ($_POST['accommodation'] == 'Yes') { echo 'selected="selected"'; } ?>>Yes</option> <option value="No" <?php if ($_POST['accommodation'] == 'No') { echo 'selected="selected"'; } ?>>No</option> </select> <!-- <select name = "accommodation"> <option value = "Yes">Yes </option> <option value="No">No </option> </select> --> </td> <td> </td> </tr> <tr> <td> </td> <td>School?</td> <td> <select name = "school"> <option value = "Flexwing" <?php if ($_POST['school'] == 'Flexwing') { echo 'selected="selected"'; } ?>>Flexwing</option> <option value="3 Axis" <?php if ($_POST['school'] == '3 Axis') { echo 'selected="selected"'; } ?>>3 Axis</option> <option value = "All Microlight" <?php if ($_POST['school'] == 'All Microlight') { echo 'selected="selected"'; } ?>>All Microlight</option> <option value="GA" <?php if ($_POST['school'] == 'GA') { echo 'selected="selected"'; } ?>>GA</option> <option value="Gyro" <?php if ($_POST['school'] == 'Gyro') { echo 'selected="selected"'; } ?>>Gyro</option> <option value="Microlight and Gyro" <?php if ($_POST['school'] == 'Microlight and Gyro') { echo 'selected="selected"'; } ?>>Microlight and Gyro</option> <option value="Other See Comments" <?php if ($_POST['school'] == 'Other See Comments') { echo 'selected="selected"'; } ?>>Other See Comments</option> </select> <!--<select name = "school"> <option value = "Flexwing">Flexwing </option> <option value="3 Axis">3 Axis</option> <option value="All Microlight">All Mircolight</option> <option value="GA">GA</option> <option value="Gyro">Gyro</option> <option value="Other See Remarks">Other, See Remarks</option> </select> --> </td> <td> </td> </tr> <tr> <td> </td> <td>Remarks:</td> <td><textarea name= "remarks" input type = 'text' rows = "5" cols = "29" /><?php echo $remarks; ?></textarea></td> <td>As much info as possible 500 characters max</td> </tr> <tr> <td> </td> <td>Warnings:</td> <td><textarea name= "warnings" input="input" type = 'text' rows = "5" cols = "29" /><?php echo $warnings; ?></textarea></td> <td>As much info as possible 500 characters max</td> </tr> <tr> <td> </td> <td>Web Links</td> <td><textarea name= "weblinks" input="input" type = 'text' rows = "3" cols = "29" /><?php echo $weblinks; ?></textarea></td> <td>Link to airfield website</td> </tr> <tr> <td> </td> <td>Operator Details</td> <td><textarea name= "operator" input="input" type = 'text' rows = "3" cols = "29" /><?php echo $operator; ?></textarea></td> <td>As much info as possible</td> </tr> <tr> <td> </td> <td>Google Iframe Image</td> <td><textarea name= "google_image" input="input" type = 'text' rows = "5" cols = "29" /><?php echo $google_image; ?></textarea></td> <td>700 x 700 pixels please. <a href="http://www.youtube.com/watch?v=gVRWhLEvt-I" target = "_blank">Watch Video here for How to Get the Image from Google</a></td> </tr> <tr> <td> </td> <td><input type='submit' name='submit' value='Submit Airfield' /></td> <td colspan="2"> <? require_once('recaptchalib.php'); $publickey = "mypublickey"; // you got this from the signup page echo recaptcha_get_html($publickey);?></td> </tr> </table> </form> </body> </html> <?php } ?> Quote Link to comment https://forums.phpfreaks.com/topic/242461-please-help-with-output-from-db/#findComment-1246074 Share on other sites More sharing options...
wildteen88 Posted July 22, 2011 Share Posted July 22, 2011 I've got a feeling you may have magic quotes enabled which could be causing this. Change each instance of mysql_real_escape_string($_POST to makeSafe($_POST Now add the following function to your code function makeSafe($value) { if (get_magic_quotes_gpc()) { $value = stripslashes($value); } $value = mysql_real_escape_string($value); return $value; } This will not affect the data that is already within your database. You'll need to loop through the data within your database and apply stripslashes to undo the affects of magic quotes. Quote Link to comment https://forums.phpfreaks.com/topic/242461-please-help-with-output-from-db/#findComment-1246220 Share on other sites More sharing options...
VinceGledhill Posted August 3, 2011 Author Share Posted August 3, 2011 Thanks for that, it's sorted it, cheers. Quote Link to comment https://forums.phpfreaks.com/topic/242461-please-help-with-output-from-db/#findComment-1251200 Share on other sites More sharing options...
VinceGledhill Posted August 10, 2011 Author Share Posted August 10, 2011 I have been adding cards to my site and found that after taking the above advice it actually now has no "carriage returns" in the output. The part of my form where the airfield owner is shown shows up like this HERTS MICROLIGHT CLUB Donal O'Keeffe - Club Secretary. Home 0208 445 9081, Mobile 07786 850416. Frank Kay - Events Organiser. Home 01923 282802, Mobile 07771 921765. frankk@cabino.net It should show up like this HERTS MICROLIGHT CLUB Donal O'Keeffe - Club Secretary. Home 0208 445 9081, Mobile 07786 850416. Frank Kay - Events Organiser. Home 01923 282802, Mobile 07771 921765. frankk@cabino.net When I look in the database it is shown correctly but doesn't show correctly on the input form. Please someone help, this is driving me mad. Quote Link to comment https://forums.phpfreaks.com/topic/242461-please-help-with-output-from-db/#findComment-1255166 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.