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.
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
