On 7/29/09 1:34 PM, "Ashley Sheridan" <a...@ashleysheridan.co.uk> 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 whitespaces....right?
> 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 <pre> tag or CSS.


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

Reply via email to