close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

My foreach in an array login wrong to send emails with items in array

Thread began 8/24/2021 8:37 am by lr_leal239405 | Last modified 8/24/2021 11:38 am by Ray Borduin | 34 views | 4 replies |

lr_leal239405

My foreach logic in an array wrong to send emails with items in array

If you have some time to help me with this:

I am trying to get emails to be sent with items in an array that pertain to that email address only. In Line 226 you'll see my attempted code. If it works, then I change line 290 to $itemNames (notice the plural), to list those items. But I need help with Logic. I would like, instead of emails sent each time per one item (in the iteration), to send all items in one email per client email only.

I've attached the file.

Sign in to reply to this post

Ray BorduinWebAssist

lines 233-247 should probably be something like:

php:
<?php

$itemNames 
"";
$wa_startindex 0;
while(!
$WADAecart_items_placed_in_cart5->atEnd()) {
  
$wa_startindex $WADAecart_items_placed_in_cart5->Index;
?>        
      <?php  
    $itemNames 
.=  "<p> - " $WADAecart_items_placed_in_cart5->getColumnVal("DetailItemName") . "</p>";       
    
?>
         <?php
  $WADAecart_items_placed_in_cart5
->moveNext();
}
$WADAecart_items_placed_in_cart5->moveFirst(); //return RS to first record
unset($wa_startindex);
unset(
$wa_repeatcount);
?>
Sign in to reply to this post
Did this help? Tips are appreciated...

lr_leal239405

I have that happening already on line 265. What I want is the email sent to have all the items that client placed in the cart instead of one item in several emails. Here's what I get


Hello,

Thank you for your interest in DDD. We wanted to remind you about some products you placed in your cart on 8/20/2021.

- 3" COR-LOKĀ®-B2-PTV Air Chuck with 1.25" Diameter bore

If you need assistance or have questions regarding this product, please contact us . You may also go to your cart to finish checking out by clicking here.

Have a wonderful day!

Sincerely,


and in a separate email, I get the other item.


But I want both items in one email. So I am trying to get:

Hello,

Thank you for your interest in DDD. We wanted to remind you about some products you placed in your cart on 8/20/2021.

- 3" COR-LOKĀ®-B2-PTV Air Chuck with 1.25" Diameter bore
- 9" Adjusta-Pull Rubber Roller

If you need assistance or have questions regarding this product, please contact us . You may also go to your cart to finish checking out by clicking here.

Have a wonderful day!

Sincerely,


Thanks

Sign in to reply to this post

Ray BorduinWebAssist

Update line 259 from:
$OrderEmail = $WADAecart_items_placed_in_cart4->getColumnVal("OrderEmail");
to:
$OrderEmail = $itemsplacedincartemail3xx3;

Then remove the loop around the email (code currently on lines: 252-256 and lines: 318-323

Then replace your code above (lines 233-247) with mine from above.

Delete these other lines:
<?php
echo "<h3>" . "Email Address: " . $OrderEmail . "</h3>";
echo $WADAecart_items_placed_in_cart4->getColumnVal("DetailItemName") . "<br>";
$itemNamex = $WADAecart_items_placed_in_cart4->getColumnVal("DetailItemName");
$itemName = str_replace(chr(194),"",$itemNamex); //USE IF USING UTF-8 FOR PAGE ENCODING
?>

Update your message to use $itemNames

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

Once you have done all of that, if it still doesn't work, attach the updated file so I can look at it with a description of the result in a reply to this thread.

Sign in to reply to this post
Did this help? Tips are appreciated...

lr_leal239405

Yeah, that works now.

I appreciate your help. Thank you!

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...