asked on

array and date format

i want to have

if ship_date is 0000-00-00, then it has to be empty.
if ship_date is 2006-04-21, then it has to be 04/21/2006.

How can i get those results based on the bottom code.

--------------------------------------

$csvquery = 'SELECT * FROM testcsv ';
$result = mysql_query($csvquery) or die("Error encountered ".mysql_error());
$csvData= Array();
$fieldCount=mysql_num_fields($result);

for($j=0;$j<$fieldCount;$j++) {
$csvData[0][$j]=mysql_field_name($result,$j);
}

$i=1;
while($csvrow = mysql_fetch_array($result, MYSQL_NUM)) {
       $csvData[$i++]=$csvrow;
       print_r($csvData);
}

-------------------------------------------------------

Array
(
[0] => Array
(
[0] => order_number
[1] => LNnumber
[2] => order_approval_status
[3] => ship_date
[4] => tracking_number
)

[1] => Array
(
[0] => M0101
[1] => KVTR-6NYLQF
[2] => 1
[3] => 2006-04-21
[4] =>
)

)
Array
(
[0] => Array
(
[0] => order_number
[1] => LNnumber
[2] => order_approval_status
[3] => ship_date
[4] => tracking_number
)

[1] => Array
(
[0] => M0101
[1] => KVTR-6NYLQF
[2] => 1
[3] => 2006-04-21
[4] =>
)

[2] => Array
(
[0] => M0102
[1] => KVTR-6NYLQG
[2] => 1
[3] => 0000-00-00
[4] =>
)

)
Array
(
[0] => Array
(
[0] => order_number
[1] => LNnumber
[2] => order_approval_status
[3] => ship_date
[4] => tracking_number
)

[1] => Array
(
[0] => M0101
[1] => KVTR-6NYLQF
[2] => 1
[3] => 2006-04-21
[4] =>
)

[2] => Array
(
[0] => M0102
[1] => KVTR-6NYLQG
[2] => 1
[3] => 0000-00-00
[4] =>
)

[3] => Array
(
[0] => M0103
[1] => KVTR-6NYLQH
[2] => 4
[3] => 0000-00-00
[4] =>
)

)

Richard Quadling

<?php
if ('0000-00-00' != $date_from_csv)
{
$date_from_csv = date('d/m/Y', strtotime($date_from_csv));
}
else
{
$date_from_csv = '';
}

or

$date_from_csv = ('0000-00-00' != $date_from_csv) ? date('d/m/Y', strtotime($date_from_csv)) : '';

ASKER CERTIFIED SOLUTION

Richard Quadling

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bbvic

ASKER

thanks

tolgaong

a solution with mysql query

$csvquery="SELECT
order_number,
LNnumber,
order_approval_status,
IF(left(ship_date,4)='0000','',date_format(ship_date,'%m/%d/%Y')) as ship_date
FROM `testcsv` ";
$result = mysql_query($csvquery) or die("Error encountered ".mysql_error());
$csvData= Array();
$fieldCount=mysql_num_fields($result);

for($j=0;$j<$fieldCount;$j++) {
$csvData[0][$j]=mysql_field_name($result,$j);
}

$i=1;
while($csvrow = mysql_fetch_array($result, MYSQL_NUM)) {
$csvData[$i++]=$csvrow;
}
echo "<pre>";
print_r($csvData);
echo "</pre>";