CodeIgniter Forums

Full Version: MySQL Database Structure
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[eluser]codedoode[/eluser]
I am planning to create a user drive application where a user signs up on on my website and a url gets created www.my-url-.com/username. The user's data will eventually be displayed using the layout on www.my-url-.com/username.

My question is how do I setup my date structure. What will be the best solution for me. All help is welcome.

El Forum

[eluser]geshan[/eluser]
use a timestamp like.

$table['created_field'] = strtotime("now");

Make the created_field int(11) and later when you show it pass it to the php date function to format it in the way you want to.

El Forum

[eluser]saidai jagan[/eluser]
In mysql create the check the current timestamp under the timestamp filed.