Limit a variable by number of characters

DanielPT

Hi
I am wondering if its possible to limit the output of a variable to say the first25 characters?
I have some code that looks like this

<?php
    for ($i = 0, $n = sizeof($order->totals); $i < $n; $i++) {
      echo '              <tr>' . "\n" .
           '                <td align="right" class="smallText">' . $order->totals[$i]['title'] . '</td>' . "\n" .
           '              </tr>' . "\n";
    }
?>

And it outputs this

Registered Courier - Road Express (Postcode Based Rates): Sub-Total: GST of 10% included in price: Total:

Now I dont really want to show the rest of the info other than the first "Registered Courier - Road"

But Its in the database and I cant figure out how to just get the first bit to display as thats all I need.

Thanks Heaps

Roger_Ramjet

You can use substr() to return part of a string.

You can also do this in the query itself with LEFT()

eg 'select LEFT(col1, 25) FROM table' will return just the first 25 characters from col1

DanielPT

Perfect, many thanks!

DanielPT

I am wondering if you can help me with a small issue with the mail() function.
I want to email the html page this outputs.
I dont want it emailing automatically (like when the page executes) but want to have a link so as to "click here to email this to such and such".

So at the bottom of the page I have this (similar script) - The subject I am going to use is basically the whole page that is output. But everytime I open the page it sends the email automatically where as I want it to just have a html link to execute the mail function should I want to send the email.

Thanks

<?php
// multiple recipients
$to  = 'aidan@example.com' . ', '; // note the comma
$to .= 'wez@example.com';

// subject
$subject = 'Birthday Reminders for August';

// message
$message = '
<html>
<head>
  <title>Birthday Reminders for August</title>
</head>
<body>
  <p>Here are the birthdays upcoming in August!</p>
  <table>
   <tr>
     <th>Person</th><th>Day</th><th>Month</th><th>Year</th>
   </tr>
   <tr>
     <td>Joe</td><td>3rd</td><td>August</td><td>1970</td>
   </tr>
   <tr>
     <td>Sally</td><td>17th</td><td>August</td><td>1973</td>
   </tr>
  </table>
</body>
</html>
';

// To send HTML mail, the Content-type header must be set
$headers  = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

// Additional headers
$headers .= 'To: Mary <mary@example.com>, Kelly <kelly@example.com>' . "\r\n";
$headers .= 'From: Birthday Reminder <birthday@example.com>' . "\r\n";
$headers .= 'Cc: birthdayarchive@example.com' . "\r\n";
$headers .= 'Bcc: birthdaycheck@example.com' . "\r\n";

// Mail it
mail($to, $subject, $message, $headers);
?>

msk_1980

You can try something like:

The mail doesnt get send until the link is clicked.

<?php 

if ( isset( $_GET['send'] )  )
     {
        mail($to, $subject, $message, $headers); 
      }
else
    {
// multiple recipients 
$to  = 'aidan@example.com' . ', '; // note the comma 
$to .= 'wez@example.com'; 

// subject 
$subject = 'Birthday Reminders for August'; 

// message 
$message = ' 
<html> 
<head> 
  <title>Birthday Reminders for August</title> 
</head> 
<body> 
  <p>Here are the birthdays upcoming in August!</p> 
  <table> 
   <tr> 
     <th>Person</th><th>Day</th><th>Month</th><th>Year</th> 
   </tr> 
   <tr> 
     <td>Joe</td><td>3rd</td><td>August</td><td>1970</td> 
   </tr> 
   <tr> 
     <td>Sally</td><td>17th</td><td>August</td><td>1973</td> 
   </tr> 
  </table> 
</body> 
</html> 
'; 

// To send HTML mail, the Content-type header must be set 
$headers  = 'MIME-Version: 1.0' . "\r\n"; 
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; 

// Additional headers 
$headers .= 'To: Mary <mary@example.com>, Kelly <kelly@example.com>' . "\r\n"; 
$headers .= 'From: Birthday Reminder <birthday@example.com>' . "\r\n"; 
$headers .= 'Cc: birthdayarchive@example.com' . "\r\n"; 
$headers .= 'Bcc: birthdaycheck@example.com' . "\r\n"; 

 echo '<a href="?send=Y">  Click here to send </a>';
} 

?>

DanielPT

Hi,
I am having issues with this. No mail is being sent at all.
Is there anything else it could be? Something I am not looking at right?
When I had the original code and opened the page an email was sent automatically, now it doesnt at all, no matter what I try.

It is an ssl page would that matter?
(thats all I can think of - sorry)
Thanks

DanielPT

Hi,
I just about have what I want to do figured out, and am after a pointer on how to create a variable properly from a function.
The function.

  for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {
        // Added 5/2004 Get Image from Data Base CED
        $products_query_raw = "select p.products_image, p.products_cost from " . TABLE_PRODUCTS . " p where products_model =" . "'" . $order->products[$i]['model'] . "'";
        $products_query = tep_db_query($products_query_raw);
        $products = tep_db_fetch_array($products_query);
        // Added 5/2004 Get Image from Data Base CED
        echo  $order->products[$i]['qty'] . '&nbsp;' . "\n" . $order->products[$i]['name'] . '&nbsp;' . "\n" . substr($order->products[$i]['model'],3,7) . '' . "\n" . '$ ' .  $products['products_cost'] . '&nbsp;' . "\n\n" . "\n\n";

}

I want it to look something like

 $ordertotal =  for ($i = 0, $n = sizeof($order->products); $i < $n; $i++) {
        // Added 5/2004 Get Image from Data Base CED
        $products_query_raw = "select p.products_image, p.products_cost from " . TABLE_PRODUCTS . " p where products_model =" . "'" . $order->products[$i]['model'] . "'";
        $products_query = tep_db_query($products_query_raw);
        $products = tep_db_fetch_array($products_query);
        // Added 5/2004 Get Image from Data Base CED
        echo  $order->products[$i]['qty'] . '&nbsp;' . "\n" . $order->products[$i]['name'] . '&nbsp;' . "\n" . substr($order->products[$i]['model'],3,7) . '' . "\n" . '$ ' .  $products['products_cost'] . '&nbsp;' . "\n\n" . "\n\n";

}

And then use this variable in an email.

Any pointers would be apprecaited, when I tried the above I get unexpected T_FOR errors.