Re: [PHP] Getting rid of extra lines (RESOLVED)
On 7/29/09 3:16 PM, "Jim Lucas" wrote: Miller, Terion wrote: > > > On 7/29/09 3:05 PM, "Jonathan Tapicer" wrote: > > On Wed, Jul 29, 2009 at 4:20 PM, Miller, > Terion wrote: >> >> >> On 7/29/09 1:45 PM, "Ashley Sheridan" wrote: >> >> [snip/] >> >> Have you thought of just using a regular str_replace() on your code? You >> can ask it to replace newlines and carriage returns with nothing and see >> if that fixes you problem? >> >> Thanks >> Ash >> www.ashleysheridan.co.uk >> >> >> >> Yep I have tried str_replace to get rid of \n and it didn't work >> Boss mentioned to explode the var that is full of so many blank lines then >> put it back together..seems like there has to be an easier way... >> >> This is what I tried: >> >> $tags = array('\n', '');$sNotes = str_replace($tags,"", $notes); >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > > That didn't work because \n needs to be between " " instead of ' '. > > Jonathan > > > Thanks Guys, ended up using Jim's way before inserting it into the db and it > works like a charm > > Just to be clear. Can you paste which one worked for you. This is what workedon my page that inserts the data to the db I put //stripping white line spaces$cleanNotes = preg_replace('|\s+|', ' ', $notes);$cleanVios = preg_replace('|\s+|', ' ', $cleanViolations); then I mysql_escaped them and put them in the db, checked the csv and presto perfect no extra linespacing -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Getting rid of extra lines (RESOLVED)
Miller, Terion wrote: > > > On 7/29/09 3:05 PM, "Jonathan Tapicer" wrote: > > On Wed, Jul 29, 2009 at 4:20 PM, Miller, > Terion wrote: >> >> >> On 7/29/09 1:45 PM, "Ashley Sheridan" wrote: >> >> [snip/] >> >> Have you thought of just using a regular str_replace() on your code? You >> can ask it to replace newlines and carriage returns with nothing and see >> if that fixes you problem? >> >> Thanks >> Ash >> www.ashleysheridan.co.uk >> >> >> >> Yep I have tried str_replace to get rid of \n and it didn't work >> Boss mentioned to explode the var that is full of so many blank lines then >> put it back together..seems like there has to be an easier way... >> >> This is what I tried: >> >> $tags = array('\n', '');$sNotes = str_replace($tags,"", $notes); >> >> -- >> PHP General Mailing List (http://www.php.net/) >> To unsubscribe, visit: http://www.php.net/unsub.php >> >> > > That didn't work because \n needs to be between " " instead of ' '. > > Jonathan > > > Thanks Guys, ended up using Jim's way before inserting it into the db and it > works like a charm > > Just to be clear. Can you paste which one worked for you. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Getting rid of extra lines (RESOLVED)
On 7/29/09 3:05 PM, "Jonathan Tapicer" wrote: On Wed, Jul 29, 2009 at 4:20 PM, Miller, Terion wrote: > > > > On 7/29/09 1:45 PM, "Ashley Sheridan" wrote: > > [snip/] > > Have you thought of just using a regular str_replace() on your code? You > can ask it to replace newlines and carriage returns with nothing and see > if that fixes you problem? > > Thanks > Ash > www.ashleysheridan.co.uk > > > > Yep I have tried str_replace to get rid of \n and it didn't work > Boss mentioned to explode the var that is full of so many blank lines then > put it back together..seems like there has to be an easier way... > > This is what I tried: > > $tags = array('\n', '');$sNotes = str_replace($tags,"", $notes); > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > That didn't work because \n needs to be between " " instead of ' '. Jonathan Thanks Guys, ended up using Jim's way before inserting it into the db and it works like a charm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Getting rid of extra lines
On Wed, Jul 29, 2009 at 4:20 PM, Miller, Terion wrote: > > > > On 7/29/09 1:45 PM, "Ashley Sheridan" wrote: > > [snip/] > > Have you thought of just using a regular str_replace() on your code? You > can ask it to replace newlines and carriage returns with nothing and see > if that fixes you problem? > > Thanks > Ash > www.ashleysheridan.co.uk > > > > Yep I have tried str_replace to get rid of \n and it didn't work > Boss mentioned to explode the var that is full of so many blank lines then > put it back together..seems like there has to be an easier way... > > This is what I tried: > > $tags = array('\n', ''); $sNotes = str_replace($tags,"", $notes); > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > That didn't work because \n needs to be between " " instead of ' '. Jonathan -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Getting rid of extra lines
Miller, Terion wrote: > > > On 7/29/09 2:19 PM, "Jim Lucas" wrote: > > $clean = preg_replace('|\s+|', ' ', $input); > > Hi Jim, > The extra whitespace lines are in the data store, coming from it I'm going to > try your method but is there a way to not have mySQL store it with so many > lines (this is data being screen scraped and put in the db) > My code was at the beginning of this post of how I was inserting it. > > Thanks > And Chocolate huh > Terion > If the method that I give you works on the out from the db to the browser, the should be no reason you cannot adapt whatever script you are using for scrapping to use this function when it inserts the data into the db. Jim -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Getting rid of extra lines
On 7/29/09 2:19 PM, "Jim Lucas" wrote: $clean = preg_replace('|\s+|', ' ', $input); Hi Jim, The extra whitespace lines are in the data store, coming from it I'm going to try your method but is there a way to not have mySQL store it with so many lines (this is data being screen scraped and put in the db) My code was at the beginning of this post of how I was inserting it. Thanks And Chocolate huh Terion -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Getting rid of extra lines
On 7/29/09 1:45 PM, "Ashley Sheridan" wrote: [snip/] Have you thought of just using a regular str_replace() on your code? You can ask it to replace newlines and carriage returns with nothing and see if that fixes you problem? Thanks Ash www.ashleysheridan.co.uk Yep I have tried str_replace to get rid of \n and it didn't work Boss mentioned to explode the var that is full of so many blank lines then put it back together..seems like there has to be an easier way... This is what I tried: $tags = array('\n', '');$sNotes = str_replace($tags,"", $notes); -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Getting rid of extra lines
Miller, Terion wrote: > I am trying to get rid of empty whitespace lines, I can't us chop() because > as I read it it will remove all whitespacesright? > > Right now my db is outputting with extra lines, I have stripped tags I know > it isn't that causing it to look like this > > Blahlajdlkfjlksdjflkdjsf > ><--how do I get rid of all this extra space? > > alkdfjlsdakjflsakdjflksjdf > > If the white space is included in data coming from the db you could run a simple little regex on the variable to removed any repetitive white space. But it might not be the best way to do it. $clean = preg_replace('|\s+|', ' ', $input); or $clean = preg_replace('|\s{2,}|', ' ', $input); If the white space is being generated in your HTML output, but is not in your data store, then you need to cleanup your PHP code and that might help. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Getting rid of extra lines
From: Miller, Terion /* snip */ Before anyone can tell you how to fix it, you need to find out what is causing that white space. is it empty lines, vertical tabs, thousands of spaces, ...? Once you find that out, it is pretty easy to decide how to get rid of them. Can you save the output to a file and open it with a hex viewer? Bob McConnell -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Getting rid of extra lines
[snip/] Have you thought of just using a regular str_replace() on your code? You can ask it to replace newlines and carriage returns with nothing and see if that fixes you problem? Thanks Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Getting rid of extra lines
On 7/29/09 1:34 PM, "Ashley Sheridan" wrote: On Wed, 2009-07-29 at 11:29 -0700, Miller, Terion wrote: > I am trying to get rid of empty whitespace lines, I can't us chop() because > as I read it it will remove all whitespacesright? > > Right now my db is outputting with extra lines, I have stripped tags I know > it isn't that causing it to look like this > > Blahlajdlkfjlksdjflkdjsf > ><--how do I get rid of all this extra space? > > alkdfjlsdakjflsakdjflksjdf > > Some example of where this is occurring in your code might help. HTML output will ignore whitespace such as this unless it is asked explicitly to preserve it, with a tag or CSS. Thanks Ash www.ashleysheridan.co.uk Well the html displays fine, its when I view the CSV in the db, I see the extra space, and I'm writing an application to reverse publish some of our site materials to the paper (I work for a newspaper) and the Quark output is picking up that extra space that is in the db (does that make sense?) Here is what the CSV looks like (See all that linespacing?) : ";"2009-01-20";"Inspection";"Will re-test dishwashing machine and sanitizer buckets for proper concentration, in addition to reviewing critical items, during time of re-inspection.";"5";" Employee drink found uncovered, sitting next to clean bin of eating utensils. This is a repeat violation. Sanitizer bucket holding wiping cloths was found at 0 ppm chlorine; must maintain concentration of solution at 50-100ppm chlorine to effectively sanitize food contact surfaces. Can opener blade found encrusted with dust and dried-on, black, food debris; must maintain clean food contact surfaces under frequent cleaning regiment, so as to not risk cross-contamination to food. Dishwashing machine found not effectively sanitizing as it measured 0 ppm chlorine; must maintain dishwasher so that it consistently and adequately sanitizes food contact surfaces. Corrected on site. This is a repeat violation. My code for the original insertion to the db is this(shortened up though) or ($i=0; $i < count($results[0]); $i++) {$name1 = strtolower($results[1][$i]);$name = ltrim($name1);$address = strtolower($results[2][$i]);$inDate = strtotime($results[3][$i]); $inType = strip_tags($results[4][$i]);$notes = strip_tags($results[5][$i]); $critical = strip_tags($results[6][$i]); $cviolations = strip_tags($results[7][$i]);$noncritical = $results[8][$i];//trying to manipulate different field data $cleanViolations = str_replace('*', '', $cviolations);$ucName = ucwords($name);$ucAddress = ucwords($address);$formatDate = date('ymd', $inDate); //escaping strings good coder$mysql_name = mysql_escape_string($ucName);$mysql_address = mysql_escape_string($ucAddress);$mysql_inDate = mysql_escape_string($formatDate);$mysql_inType = mysql_escape_string($inType);$mysql_notes = mysql_escape_string($notes); $mysql_critical = mysql_escape_string($critical);$mysql_cviolations = mysql_escape_string($cleanViolations);$mysql_noncritical = mysql_escape_string($noncritical); //insert each to the database //attempt loop for checking restaurants // First check if the name exists $sql ="SELECT * FROM `restaurants` WHERE `name`='{$mysql_name}' AND `address` ='{$mysql_address}'"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_num_rows($result) > 0){ $row = mysql_fetch_array($result); $ID = $row['ID']; // This means the name exists.. UPDATE inspections table $sql = "INSERT INTO `inspections` (ID, inDate, inType, notes, critical, cviolations, noncritical) VALUES (";$sql .= "'$ID', '$mysql_inDate', '$mysql_inType', '$mysql_notes', '$mysql_critical', '$mysql_cviolations', '$mysql_noncritical')";mysql_query($sql); } else{// The name doesn't exists, add all the info $sql = "INSERT INTO `restaurants` (name, address) VALUES ("; $sql .= " '$mysql_name', '$mysql_address')"; mysql_query($sql); $ID = mysql_insert_id(); $sql = "INSERT INTO `inspections` (ID, inDate, inType, notes, critical, cviolations, noncritical) VALUES (";$sql .= " '$ID', '$mysql_inDate', '$mysql_inType', '$mysql_notes', '$mysql_critical', '$mysql_cviolations', '$mysql_noncritical')";mysql_query($sql); } /**/ }; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Getting rid of extra lines
On Wed, 2009-07-29 at 11:29 -0700, Miller, Terion wrote: > I am trying to get rid of empty whitespace lines, I can't us chop() because > as I read it it will remove all whitespacesright? > > Right now my db is outputting with extra lines, I have stripped tags I know > it isn't that causing it to look like this > > Blahlajdlkfjlksdjflkdjsf > ><--how do I get rid of all this extra space? > > alkdfjlsdakjflsakdjflksjdf > > Some example of where this is occurring in your code might help. HTML output will ignore whitespace such as this unless it is asked explicitly to preserve it, with a tag or CSS. Thanks Ash www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Getting rid of extra lines
I am trying to get rid of empty whitespace lines, I can't us chop() because as I read it it will remove all whitespacesright? Right now my db is outputting with extra lines, I have stripped tags I know it isn't that causing it to look like this Blahlajdlkfjlksdjflkdjsf <--how do I get rid of all this extra space? alkdfjlsdakjflsakdjflksjdf -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php