Re: Argh Date problems
| From: | Miller, Terion | Date: | Tue, 28 Jul 2009 20:02:15 +0000 |
| Subject: | Re: Argh Date problems | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-295978@lists.php.net to get a copy of this message | ||
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@springfi.gannett.com> 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