Suzanne — Thu, 14 Aug 2003 05:47:00 +0000

Perhaps a different situation would be better served with different coding. I'm interested in figuring out OOP for this, but not right this second, lol. My brain hurts enough.

The unset information actually sparked an idea to check for blanks AND an existingkey, and delete the record.

I feel good, though. This database has 25 tables and I'm working through them nicely and not actually breaking my brain, just bending it a tad.

Mark Hensler — Thu, 14 Aug 2003 05:41:21 +0000

Yours may be more efficient. It doesn't have the extra loop and query that mine does.

Suzanne — Thu, 14 Aug 2003 03:19:12 +0000

Which way is better? (I'm trying to be proactive and solve my own problems, but sometimes I just have to talk it out to get my head around it).

Mark Hensler — Thu, 14 Aug 2003 03:15:05 +0000

Argh. Guess I spent too long in notepad, eh?

<?php
if (is_array($address)) {

    // loop through addresses, and remove any that are missing information
    foreach ($address AS $key=>$aval) {
        if (($aval['street'] == '' ) && ($aval['city'] == '') && ($avail['state'] == '')) {
            unset($address[$key]);
        }
    }
    
    $address_query = mysql_query(\"SELECT address_id, address_label_id
                    FROM zc_address
                    WHERE address_label_id IN (\".array_keys($address).\")
                        AND user_id = '$this_user_id'\");

    // update existing records
    while ($tmp=mysql_fetch_array($address_query)) {
        $this_address_id = $tmp['address_id'];
        $aval = $address[$tmp[address_label_id]];

        $address_qry = mysql_query(\"UPDATE zc_address SET
                        street='\".$aval['street'].\"',
                        city='\".$aval['city'].\"',
                        state='\".$aval['state'].\"',
                        zipcode='\".$aval['zipcode'].\"',
                        address_primary='\".($address_primary==$alabel ? 'y' : '').\"',
                        address_public='\".$aval['public'].\"' 
                        WHERE address_id = '$this_address_id'\");

        // remove this address from the array
        unset($address[$tmp[address_label_id]]);
    }

    // insert new records
    foreach ($address AS $key=>$aval) {

        $address_qry = mysql_query(\"INSERT INTO zc_address SET
                        user_id='$this_user_id',
                        street='\".$aval['street'].\"',
                        city='\".$aval['city'].\"',
                        state='\".$aval['state'].\"',
                        zipcode='\".$aval['zipcode'].\"',
                        address_label_id='$alabel',
                        address_primary='\".($address_primary==$alabel ? 'y' : '').\"',
                        address_public='\".$aval['public'].\"'\");
    }

} //END if (is_array($address))
?>

Suzanne — Thu, 14 Aug 2003 02:53:17 +0000

Success!

<?php
// added to the output for those that exist already in the initial form
<input type=\"hidden\" name=\"address[$aid][existingkey]\" value=\"$form_address_id\" />
?>

<?php
    if (is_array($address)) {

        // loop through the form array
        foreach ($address as $alabel=>$aval) { 

            // if these values are blank, skip this label
            if (($aval['street'] == '' ) && 
                ($aval['city'] == '') && 
                ($avail['state'] == '')) {
                continue;
            }

            // see if the label already exists (so much easier!)
            if (isset($aval[existingkey])) {
                $this_address_id = $aval['existingkey'];

                // update this address id
                $address_qry = mysql_query(\"UPDATE zc_address SET
                street='\".$aval['street'].\"',
                city='\".$aval['city'].\"',
                state='\".$aval['state'].\"',
                zipcode='\".$aval['zipcode'].\"',
                address_primary='\".($address_primary==$alabel ? 'y' : '').\"',
                address_public='\".$aval['public'].\"' 
                WHERE 
                address_id = '$this_address_id'\");
            }

            // otherwise insert this into the db
            else {
                $address_qry = mysql_query(\"INSERT INTO zc_address SET
                user_id='$this_user_id',
                street='\".$aval['street'].\"',
                city='\".$aval['city'].\"',
                state='\".$aval['state'].\"',
                zipcode='\".$aval['zipcode'].\"',
                address_label_id='$alabel',
                address_primary='\".($address_primary==$alabel ? 'y' : '').\"',
                address_public='\".$aval['public'].\"'\");
            }
        }
    }
?>

Suzanne — Thu, 14 Aug 2003 02:47:32 +0000

Okay, that's working for updating, now trying to add a new one at the same time.

Suzanne — Thu, 14 Aug 2003 02:15:00 +0000

Would it work to set the existing address_id as a hidden input and if it's set, do this, if not, do the other? Instead of pulling an array and such?

Testing (but if you know in the meantime, please do post).