Strtotime in MySQL query [basic PHP page]

Question

I've been giving myself a basic refresher course in PHP without using template engines (although I've learnt some Smarty and Twig recently I felt I should keep practising basic PHP), and this is my basic page displaying a list of vehicles and when they were registered:

 <?php 
 // Connects to your Database 
 mysql_connect("localhost", "testing", "testingpass") or die(mysql_error()); 
 mysql_select_db("cars1") or die(mysql_error()); 
 $data = mysql_query("SELECT * FROM autos") 
 or die(mysql_error()); 
 echo "<table border cellpadding=3>"; 
 while($info = mysql_fetch_array( $data )) 
 { 
 "<tr>"; 
 //echo "<td>"date("d M Y",strtotime($info['registered']));"</td> "; 
 echo "<td><tr>".$info['make'] ." ".$info['model'] ."</td><tr> "; 
 } 
 echo "</table>"; 
 ?>

It works if the datetime is commented out, but if it's uncommented the page appears blank - I'm using MAMP as my webserver, latest PHP.

For a simple page this works well, but how should I format this date? (I used the tutorial at http://erikastokes.com/mysql-help/display-mysql-dates-in-other-formats.php to try this).

What changes should I make to fix this problem with the date and time, as otherwise it works well as a basic MySQL php query.

add error_reporting(E_ALL) to the top. your errors are off by default. — castis
– castis, Commented Mar 18, 2013 at 17:29
DOTS: echo "<td>".date("d M Y",strtotime($info['registered']))."</td>"; — Waygood
– Waygood, Commented Mar 18, 2013 at 17:31

Nauphal · Accepted Answer · 2013-03-18 17:30:31Z

2

it should be like this

echo "<td>".date("d M Y",strtotime($info['registered']))."</td> ";

You have to use . for concantinate string.

answered Mar 18, 2013 at 17:30

Nauphal

6,1824 gold badges30 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Marko D Over a year ago

he also has "<tr>"; without echo, you might want to point that too

Marko D · Accepted Answer · 2013-03-18 17:37:00Z

0

First off, the reason your screen is blank, is because most default PHP installs have error reporting turned off. You'll need to edit your php.ini file to fix that. Open and search for display_errors and change it.

Second, the first error you're missing is you just have "<tr>" with no echo before it.

The second error you're most likely not seeing is that you're missing a concatenating operator .

echo "<td>"date("d M Y",strtotime($info['registered']));"</td> "

should be

echo "<td>" . date("d M Y",strtotime($info['registered'])) . "</td> "

edited Mar 18, 2013 at 17:37

Marko D

7,5762 gold badges29 silver badges39 bronze badges

answered Mar 18, 2013 at 17:30

castis

8,2144 gold badges45 silver badges66 bronze badges

2 Comments

user1936123 Over a year ago

error_reporting() would not work here, as he would need to have display_errors enabled. Also, you could not set it at runtime, as this was a parse error.

castis Over a year ago

Good call, changed to have OP look for that in his php.ini

Collectives™ on Stack Overflow

Strtotime in MySQL query [basic PHP page]

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related