On Tue, Jul 28, 2009 at 4:02 PM, Miller,
Terion<tmiller@xxxxxxxxxxxxxxxxxxxx> wrote:
> Ok so I got the
> $inDate = strtotime($results[3][$i]);
>
> Giving me the unix date now I am trying all the different date functions that will put it in the 0000-00-00 like sql stores it because I ran it with the unix stamp and it just stored 000000 in the db
>
> Hoping something like this works?
> $formatDate = date('ymd', $inDate);
>
>
> On 7/28/09 2:41 PM, "Miller, Terion" <tmiller@xxxxxxxxxxxxxxxxxxxx> wrote:
>
> Well I was going along smoothly from this morning....but it came down to
> having to change the field type to date in the mySQL..so now I have this
> which returns a scraped value formatted like this 0/00/00 m/d/y
>
> $inDate = $results[3][$i];
>
> Which date function can I use to format for the db so that I will be able to
> use range references...there are so many get_date, date_modify....I'm
> lost...
>
> My full code is this:
>
> preg_match_all('/<p><font size="2" face="Arial, Helvetica,
> sans-serif">(.+)<br>(.+)<br>.+(\d+\/\d+\/\d+)\s(.+)<br>(.+)<br>.+Critical
> Violations Found:.+(\d+)(.+)Noncritical Violations Found:.+(\d+)/imsSU',
> utf8_encode($url), $results);
>
>
>
> for ($i=0; $i < count($results[0]); $i++)
> {
> $name1 = strtolower($results[1][$i]);
>
> $name =
> ltrim($name1);
>
> $address = strtolower($results[2][$i]);
>
> $inDate
> = $results[3][$i];
>
> $inType = $results[4][$i];
>
> $notes =
> trim($results[5][$i]);
>
> $critical = trim($results[6][$i]);
>
>
> $cviolations = $results[7][$i];
>
> $noncritical = $results[8][$i];
>
> //trying to manipulate different field data
>
> $cleanViolations =
> str_replace('*', '', $cviolations);
> $ucName = ucwords($name);
>
> $ucAddress = ucwords($address);
>
>
> $mysql_name =
> mysql_escape_string($ucName);
> $mysql_address =
> mysql_escape_string($ucAddress);
> $mysql_inDate =
> mysql_escape_string($inDate);
> $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);
>
> echo "$ucName <br>";
>
> echo "$ucAddress <br>";
> echo "$inDate <br>";
> echo "$inType
> <br>";
> echo "$notes <br>";
> echo "$critical <br>";
>
> //echo "$cviolations <br>";
> echo "$cleanViolations <br>";
>
> echo "$noncritical <br><hr>";
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Can't you just explode the string and put it back together in the
YYYY/MM/DD format that you need?
--
Bastien
Cat, the other other white meat
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
