4 replies to this topic

[Cerenza]

On my dear website that we all know and love...
I bought my domain/name, from domeneshop.no
The funny thing or rather not so funny thing is that they did`nt have installed the MyAQL thingie Admin place, I don`t really know how to explain it. lol.
And they are using something that my hubby have`nt installed before.
phpmyadmin...
Could enyone help me with maby a good site that has a tutt or something on something like that? It does`nt have to be explained like a noob, since it`s not really I who`s going to work with it, but Grizzmo.

More:

I want my blog to automaticly show date and day when I write updates.
How do I do this? Is it alot of work?
Again it`s not for me, but I wanna know. This way the hubby does`nt have eny excuses for slacking

[Jaymz]

What program are you used to using?

Phpmyadmin is the standard in server MYSQL management, and it might look daunting but once you get the basics its a breeze

[Cerenza]

I`ll have him post. He just registere. grizzmo.

[Wybe]

Oh dear, PHPMyAdmin is the best you can get. Whenever you want to start workig with MySQL databases, make sure you know how to work with PHPMyAdmin, even though it is not difficult.

When you want to display date with posts (of which I assume you store in your database), make sure that the date is stored in the MySQL together with the post. MySQL has a nice field type for this, called "DATETIME", which is in YYYY-MM-DD hh:mm:ss format. Note that hh is from 0-24, instead of 0-12 for AM and PM which i believe is common in america.

Then, when displaying the post, fetch the date and time information from the mysql database, and you can convert it to something very nice using PHP´s date() and mktime() functions. Works like a charm.

[softLearner]

This is sort of related to phpMyAdmin but more to MySQL. I cam across here which has a a few good well written articles on various things and one of them is MySQL which has a MySQL Cheat Sheet

Whcih I think is quite use full. As it explains what the Data Types can hold etc. SO I though that may help alittle as to what phpMyAdmin is askin when creating tables etc.

It helped me out with chossing the right Data Type to use to store data.

ALso I found a small tutorial on using phpMyAdmin here and here. Also check out the secrh I used in google here

phpMyAdmin is a really good tool to easily administer MySQL databases in a web based environment.

The only daunting thing to phpMyAdmin is creating tables to go into a database.