Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

PHP

Pontus Bolmér
Pontus Bolmér
12,471 Points

Adding date to a new post

Im having trouble with something that should be easy enough!

Im working with two textareas, one that shows the result from the database, and you cant edit it, and another box that you write the new messages and it will show up in textbox1.

After every message i want a date to appear!

any ideas? Im stuck!

<form id="NewNotes" name="NewNotes" method="post" action=""> <textarea rows="4" cols="89" name="saveNewNotes" id="saveNewNotes"></textarea> <input type="submit" name="submitnewMessage" value="Spara anteckning"/> <input type="hidden" id="getId" name="getId" value="<?=$_GET['id']?>"> </form> <?php

if(isset($_POST['submitnewMessage'])) {

    $message = utf8_decode($_POST['saveNewNotes']);
    $customerId = $_GET['id'];
    $addDate = date("Y-m-d");
    // Sql fråga nästa 

    $newUpdateNotes = "UPDATE sf_customers SET anteckning = CONCAT(anteckning, :newMessage ) WHERE id=:getId";

    $params = [
        "newMessage" => $message,
        "getId" => $customerId
    ];
Cris Pijper
Cris Pijper
11,743 Points

You could (a) use your $addDate to update your db date column for this new message when you submit your new message, and you could then (b) retrieve this date from the db date column for the corresponding message and (c) echo it with your message

1 Answer

Pontus Bolmér
Pontus Bolmér
12,471 Points

What do you think about adding my addDate in a concatenated variable?

Im not really sure what you mean tho!

Cris Pijper
Cris Pijper
11,743 Points

Well, you can do something like this:

$newMessage = "Some new message";
$addDate = date("Y-m-d");
$message = $newMessage . " " . $addDate;

This way you just simply concatenate the date to your new message :)