A simple if statement

philweb

I need a bit of help with this script, because of the addresses of people are different legnths it is difficult to get everyone's address the same. EG 123 High Road London W1 4EX Could be one persons address but 123 High Street Totteridge High Wycombe, Bucks SL8 9UT could be anothers.

So, in calling those addresses from the database to be displayed in a excel file there needs some tinkering. Is it possible to check if entry_suburb has a value if not is it possible for it to filled with entry_city so that the address in the excel file has no empty boxes?

Thanks, I would appreciate any help.

Phil

$link = mysql_connect($host, $user, $pass) or die("Can not connect." . mysql_error());
mysql_select_db($db) or die("Can not connect.");

$replace = array(
'address_book_id' => '',
'customers_name' => 'Customer Job',
'entry_firstname' => 'First Name',
'entry_lastname' => 'Last Name',
'entry_street_address' => 'Billing Address1',
'entry_suburb' => 'Billing Address2',
'entry_city' => 'Billing Address3',
'entry_state' => 'Billing Address4',
'entry_postcode' => 'Billing Address5',
'customers_email_address' => 'Email',
'customers_telephone' => 'Phone'

);
function split_num($num){ 
    $num = substr($num, 0, 5) . ' ' . substr($num, 5); 
    return $num; 
} 



$values = mysql_query("SELECT zen_orders.customers_name, zen_address_book.entry_firstname, zen_address_book.entry_lastname, zen_address_book.entry_street_address, zen_address_book.entry_suburb, zen_address_book.entry_city, zen_address_book.entry_state, zen_address_book.entry_postcode, zen_orders.customers_telephone, zen_orders.customers_email_address
FROM (zen_address_book INNER JOIN zen_orders ON zen_address_book.customers_id = zen_orders.customers_id) INNER JOIN zen_customers ON (zen_address_book.address_book_id = zen_customers.customers_default_address_id) AND (zen_address_book.customers_id = zen_customers.customers_id)


 ");

$i=0;
while ($rowr = mysql_fetch_assoc($values)) { 
    if(!preg_match('#\x20#', $rowr['customers_telephone'], $match)){ // does not find a space... 
       $rowr['customers_telephone'] = split_num($rowr['customers_telephone']); 
    } 
    if($i==0) { 
        foreach(array_keys($rowr) as $title) 
        $csv_output .= '"'.str_replace(array_keys($replace), $replace, $title).'",'; 
        $csv_output .= "\n"; 
    } 

foreach ($rowr as $key => $value) { 
    $csv_output .= '"'.$value.'",'; 

} 
$csv_output .= "\n"; 
$i++; 
} 


$filename = $file."_".date("Y-m-d_H-i",time());
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header( "Content-disposition: filename=".$filename.".csv");
print $csv_output;
exit;

Kudose

if(empty($value)) $value = 'Something';

philweb

I have included the line

if(empty($entry_suburb)) $value = 'entry_city';

but this has not solved the problem.

Is there something else you can add to this to make the entry_suburb field be filled with the field entry_city if it was empty?

Thanks,

Phil

Piranha

You don't assign the value to the right variable. Please check that line of code again.

philweb

When talking about the two values in question, what values would you assign to them? I have tried swapping the two values around

if(empty($entry_suburb)) $value = 'entry_city';

and that doesn't work, I have tried removing the value from the right

if(empty($entry_city)) $value = '';

and that doesn't work either. Could you give me some pointers to work with, I am really trying to learn this.
Thanks,

Phil

Weedpacket

When you were adapting Kudose's code, why did you change $value to $entry_suburb in one place and not the other?

philweb

Please forgive my ignorance but, I am trying to replace "something" with the field entry_city,

if(empty($entry_suburb)) $value = 'entry_city';

So if the entry_suburb is empty then it will be replaced by entry_city. That's why I changed something to entry_city.

But reading you post, are you suggesting that $value is replaced by $entry _suburb and $value = entry_suburb?

Thanks

Phil

igorlopez

if (this is TRUE)  do this;
// or if many rows of actions
if (this is TRUE)
{
   do this;
   and this;
}

So it comes down on knowing what you want to do.

if(empty($entry_suburb)) $value = 'entry_city';

Assigns the variable $value the value 'entry_city' every time $entry_suburb is empty.....
Maybe not what you wanted.

philweb

This is exactly what I would like to do. When the column entry_suburb has an empty field I need entry_city to filled in that field so that the address would read 123 high street, Norwich, Norwich NR1 4EX

So, should this statement work?

if(empty($entry_suburb)) $value = 'entry_city';

because it doesn't seem to work for me at the moment, is there something else I should be adding to the script?

I understand the basic uses for if statements, but what I am finding difficult is using it when referring to database fields in columns.

Hope you can help please,

Phil

Piranha

Why do you assign 'entry_city' to the variable $value? You don't use that variable in the code. Would it not be better to assign it to another variable?

philweb

I hold my hands up! I am a complete newbie when it comes to php, I understand sql queries and I can understand small stand alone scripts, but when I have a largish script like this one (which I have modified with the help of other php experts) I don't really have a clue how to intergrate additional statements.

I can understand things if they are explained to me, but if you ask me why did you do this on this variable I am afraid I can't tell you, because I don't know.

Hence, can I appeal to your generosity to perhaps let me have the code that I need to make this script complete please.

Thanks,

Phil

igorlopez

if(empty($entry_suburb)) $entry_suburb = 'entry_city';

I understand the basic uses for if statements, but what I am finding difficult is using it when referring to database fields in columns.

$entry_suburb is still just a plain php variable which may be used in conjunction with a field in a database record.

philweb

Thanks for the reply, I understand what people were saying now!

I have uploaded the if statement in the script but the results don't seem to have changed.

Is there anything else I should have put?

Thanks,

Phil

igorlopez

    foreach ($rowr as $key => $value) {
        // Test for empty entry_suburb key
        if ('entry_suburb' == $key  && empty($value)) {
            $data = $rowr['entry_city'];
        }
        else
        {
            $data = $value;
        }
        $csv_output .= '"'.$data.'",';

}

!! Note, Not tested since it was too much work building the framework but it gives you an idea at least.

philweb

Thanks for that reply, it doesn't work, but as you said it gives me something to work on.

Thanks,

Phil