PHP - Arrays And Formatting

I'm presently formatting surnames like this:

Code: [Select]
$surname = ucfirst(strtolower($surname)))
.. so that

SMITH, and smith ... both look like:
Smith.

That's all fine, but how do I ensure that...
O'BRIEN o'brien o' brien
... all look like

O'Brien

?

That is, where no spaces are allowed to appear in the surname and where the first letter, as well as the one following the apostrophe are both capitalised.

TIA

Hi all, I have features on my website which require a time limit untill they can do the thing agian, but at the current mintue ive got the time in seconds. How can I make a function which will give the time in minutes instaid of seconds.

Example:

If it was a 2 mintue waiting time instaid of being 120 Seconds it will be 2min(s) 0sec(s).

Example of my Current Code:


$timewaiting = time() + 160; // Waiting time. (2min)


if ($user->lasttime > time()){
$howlongleft = $user->lasttime - time();

echo ("You must wait $howlongleft");


Thanks for any help given.

Hi there,

So I have data which I am fetching from two tables link in a one-to-many relationship using the following code:

sql = "select authcourses.id as id, title, date_format(closingdate, '%d.%m.%y') as date, name from authcourses inner join authorities on authorityid = authorities.id order by authorityid";
$result = mysqli_query($link, $sql);
if(!$result)
{
  $error = 'Unable to get list of authorities';
  include '../../error.html.php';
  exit();
}

while ($row = mysqli_fetch_array($result))
{
  $authcourses[] = array('name' => $row['name'], 'title' => $row ['title'], 'date' => $row['date'], 'id' => $row['id']);
}


I then output the data in a table like this:
Code: [Select]
<table>
      <thead><th>Title</th><th>Closing Date</th><th>Action</th></thead>
      <tbody>
      <?php foreach ($authcourses as $authcourse): ?>
      <tr>
      <form action="?" method="post">
        <tr>
          <td><?php htmlout($authcourse['name']); ?></td> <!-- custom function htmlout($text) see helpers.inc.php -->
          <td><?php htmlout($authcourse['title']); ?></td>
          <td><?php htmlout($authcourse['date']); ?></td>
          <td>
          <input type="hidden" name="id" value="<?php echo $authcourse['id']; ?>" />
          <input type="submit" name="action" value="Edit" />
          <input type="submit" name="action" value="Delete" />
          </td>
        </tr>
      </form>
      <?php endforeach; ?>
      </tbody>
    </table>

The htmlout() is a custom function which is basically "echo htmlspecialchars($str)", and you can ignore the form stuff.

I get an out put like this:
York, Course 1, 2011-02-15
York, Course 2, 2011-03-01
Manchester, Course 3, 2011-06-17
Manchester, Course 4, 2011-08-12
Derby, Course 5, 2011-01-10
Barnet, Course 6, 2011-08-19
Barnet, Course 7, 2011-06-23

etc etc...

What I want is something like this:
York:
Course 1, date
Course 2, date

Manchester:
Course 3, date
Course 4, date

Derby:
Course 5, date

Barnet:
Course 6, date
Course 7, date

etc..

I guess I'd like to load an array for each of the authorities (cities) with the course info, then I can output it in my form like this:
Code: [Select]
<?php foreach ($authcourses as $authcourse): ?>
<h1><?php htmlout($authcourse['name'] ?>: </h1>
  <?php foreach ($courses as $course): ?>
  <p><?php htmlout($course['title'];?><p>
  <p><?php htmlout($course['date'];?></p>
  <?php endforeach; ?>
<?php endforeach; ?>

I hope that makes sense... Any help would be great.

Cheers,
Mike

I've been wracking my brain trying to figure this simple problem out and I can't for the life of me figure out the best way to do it.

I have the following array:

$n = array('81.0', '80.5', '70.5', '67.0', '65.5');

I only want to display the numbers to one decimal place if it's not a whole number, like so.

81
80.5
70.5
67
65.5

I've tried looking for a solution with sprintf(), rtrim() and number_format(), but what's the best way to do it?

Regards
Rich

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=346474.0

I am having a problem with what is probably encoding.

I am pulling strings from a WordPress database.  Below is a sample string:


Code: [Select]
Sed nec neque quis sapien scelerisque aliquet. In in est odio, ac auctor erat. Vestibulum fringilla dapibus sodales. Morbi facilisis egestas arcu, eu semper mi luctus vitae. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Suspendisse sollicitudin, metus sed hendrerit tristique, enim ante venenatis metus, ac consectetur mauris lorem et felis. Phasellus ac purus massa. Aliquam ligula mauris, iaculis et posuere vitae, pellentesque sit amet leo.

Praesent at eros et lacus scelerisque feugiat. Aliquam non facilisis libero. Ut blandit leo ut tortor convallis porttitor. Aliquam erat volutpat. Aliquam rhoncus rutrum metus, tempor sollicitudin ante laoreet in.

Sed tincidunt nibh a augue euismod sagittis. Fusce ullamcorper ultricies nisi, sit amet elementum mi scelerisque eget. Cras sed elit ligula, sit amet aliquam lectus. Nulla vel mollis nibh. Pellentesque ultricies, dui non aliquam eleifend, tortor ligula blandit dolor, quis interdum diam augue non eros. Nullam id molestie nunc. Integer id tempus est.

When WordPress displays this text, it is formatted correctly, with spaces between paragraphs, etc.

When I pull the string from the database, and echo it onto a page, the spaces between paragraphs are replaced by spaces, so in the end the output is as follows:


Code: [Select]
Sed nec neque quis sapien scelerisque aliquet. In in est odio, ac auctor erat. Vestibulum fringilla dapibus sodales. Morbi facilisis egestas arcu, eu semper mi luctus vitae. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Suspendisse sollicitudin, metus sed hendrerit tristique, enim ante venenatis metus, ac consectetur mauris lorem et felis. Phasellus ac purus massa. Aliquam ligula mauris, iaculis et posuere vitae, pellentesque sit amet leo.  Praesent at eros et lacus scelerisque feugiat. Aliquam non facilisis libero. Ut blandit leo ut tortor convallis porttitor. Aliquam erat volutpat. Aliquam rhoncus rutrum metus, tempor sollicitudin ante laoreet in. Sed tincidunt nibh a augue euismod sagittis. Fusce ullamcorper ultricies nisi, sit amet elementum mi scelerisque eget. Cras sed elit ligula, sit amet aliquam lectus. Nulla vel mollis nibh. Pellentesque ultricies, dui non aliquam eleifend, tortor ligula blandit dolor, quis interdum diam augue non eros. Nullam id molestie nunc. Integer id tempus est.

What can I do to follow WordPress' formatting?

Hi all

Been trying to get my head around formatting a string, and struggling.

I have a serious of numbers held in a DB and I need these to display as 5 figure numbers. 

if the DB held the record "48"  I would need this to be displayed as "00048".

Can anyone give me a clue.  I've tried reading the php manual but this just confuses me more.

Hi, I am trying to print my database records into a php page. I am able to succesfully print the values however the values are being duplicated. For example If I have two records in the employee_details, every these two records are being printed twice on my php page. can anyone tell me the reason why?  The output that I see is as follows

7   7   3a7cf5162a9c0a5014c92021e7ca0bf0   3a7cf5162a9c0a5014c92021e7ca0bf0   Bryan   Bryan   4111    4111    Admin   Admin
6   6   6743c3d1519ab4f2cd9a78ab09a511bd   6743c3d1519ab4f2cd9a78ab09a511bd   Raul    Raul    601 W Yandell Dr,    601 W Yandell Dr,    Admin   Admin


<html>
<head>
</head>
<body>
<?php
mysql_connect("localhost","root","");
mysql_select_db("encryption") or die(mysql_error());
$query = mysql_query("select * from employee_details");
?>

<table>
<?php

for($counter = 0;$row=mysql_fetch_array($query); $counter++)
{
print ("<tr>");
foreach($row as $key=> $value)
print ("<td>$value</td>");
print ("</tr>");
}
?>
</table>



</body>
</html>

Hi

Simple question, how do I reFormat a date.

$dateCreated   (2012-01-14)

to become:   14th jan 2012


So far I have this, but it's not working:
Code: [Select]
$expDate = explode('-',$dateCreated);
$date1 = mktime(0, 0, 0, date('m', $expDate[1]), date('d', $expDate[2]), date('Y', $expDate[0]));
$date = date('d m Y', $date1);



Thanks

I want a little online users list at the bottom of my page and the color of the username is to match the color defined in the database. but how do i get them to align side by side? if i add them to a <p> they will all appear under neath each other. Heres my current code:



$sql=mysql_query("SELECT * FROM ".DB_PREFIX."members WHERE online = 1");
while ($row = mysql_fetch_object($sql)) {

echo '<p style="color: #'.$row->username_color.';">'.$row->username.'</p>';

}



also i want a comma at the end of each but how do i stop it adding a comma to the end of the last one?

Hi,

When I do this the result is a date of zeros?

$DateAndTime = date('d-m-y', strtotime($DateAndTime));

All I want is a date in format of DD0MM-YYY and the Time in HH:MM::SS

Any help would be great! I know it is basic, Thanks in advance

Having used unix timestamps in the past formatting the date used to be easy. But since converting to mysql DATETIME im struggling to format it properly. I basically pull the date from the database, convert it using strtotime(), then convert it to a date using date(). The problem is that when i use 'a' to display am/pm the time almost always says am. If the time is 11am then it will display 11am. If it's 12pm then it will display 12pm, but if it comes to 1pm and above it will revert back to 1am.

This is the date string I use:


date('jS M Y g:i a');


is this due to the fact that mysql DATETIME uses 24 hour clock ('H'), if so is there a way around this?

How I can format the number in a string to be displayed as four-digit. I mean transforming 1 to 0001; and 54 to 0054.

Hi everyone,

I am having some odd issues with sending php generated emails.  Essentially, what I'd like to know is how can I ensure they go into the inbox, and not get shunted to the junk mail folder.  I assume this is s formatting issue, and it only happens sometimes.  I am creating html emails.  I have included my headers below:

   $headers = "From: <Real Money Help>\r\n";
   $headers .= 'MIME-Version: 1.0' . "\r\n";
   $headers .= 'Content-type: text/html; charset=utf-8' . "\r\n";

Any help would be appreciated.  Thanks.