Set "created" by creating a page via API

[Nico Knoll]

Hi,

is there a way to set the "created" date while creating a page via API?

I tried this:

$page->created = $data['crdate'];           // $data['crdate'] is an timestamp like 1321279318

But it won't work...

Greets,

Nico

[Nico Knoll]

Well, I think I try to solve this with SQL...

[Soma]

It works for me...

<?php
$page->created = time();
$page->save();

// outputs current timestamp
echo $page->created;

---

ops but after removing it outputs the old again, so it's not saved.

[Nico Knoll]

I solved this with SQL:

First save normally and after this:

$sql = "UPDATE `pages` SET `created` = '".date('Y-m-d H:i:s', $data['crdate'])."', `modified` = '".date('Y-m-d H:i:s', $data['tstamp'])."' WHERE `name` = '".$page->name."';";

$update = wire('db')->query($sql);

[ryan]

The $page->created and $page->modified properties are meant to be internal and consistent with actual page creation and modification dates in PW, so they aren't things that can be modified by the API. While you can go directly in and modify it with SQL, it's better to create your own properties using PW date fields. There's nothing that you can't do with your own fields that you can do with those internal created/modified fields. However, at present, I don't think it does any harm to modify them in SQL, but just saying that it's not a best practice.