[SOLVED] Display date created of a filename

[kochier]

This is the code I am using to display date last modified

 

<?php

$file = $_SERVER["SCRIPT_NAME"];

$break = Explode('/', $file);

$pfile = $break[count($break) - 1];

//echo $pfile;

echo " Last Modified: " .date("m d Y",filemtime($pfile));

?>

 

And I was wondering if there was any simple way of displaying the date the file was created, I assumed it would be filectime for creation date, but after trying it I found the c stands for changed.

[kochier]

Alright well after some research into this I am beginning to wonder if it stores the info for created pages? I have also simplified my code somewhat, as I found the other code needlessly long, though I may be wrong.

 

<?php

echo " - " .date("m d Y", filemtime($_SERVER["SCRIPT_FILENAME"]));

?>

 

Is now what I am using to display last modified date, though I still can't figure out the creation date

[Bauer418]

Most *nix based systems don't store the created date, which is why PHP doesn't have a simple way of accessing it.

[kochier]

Well is there any simple way of doing it? I was thinking of somehow using a MySQL database, but I haven't touched it yet, and I've had problems getting it to work for me (ie. I have no clue how to use it).

[kochier]

Alright well how would I store the date created in a MySQL database, is there anyway to do it through php, or do I need to enter all of the dates manually?

[DarkWater]

Yeah, connect to the DB, and use an INSERT query and use the MySQL NOW() function as the data for a DATETIME column.

[kochier]

Can I run a .asp script in a .php file, through using the include function? I know I can do this in .asp (run a php file) but does it work the other way around?

[DarkWater]

I'm not sure.  What does the ASP script do?  Maybe you could rewrite it in PHP.

[kochier]

Never mind, figured out about the script, I can include it, but wasn't configured to run .asp on the apache server. So this is what I have so far

 

<?php

include 'opendb.php';

mysql_select_db('sitemap') or die('Cannot select database');

include 'closedb.php';

?>

 

and this is what I want the db to look like:

 

name         pathname         created (m d Y) map

Main         index.php         10/24/2007         1

Absurdity absurdity.php 07/02/2008           2

 

or possibly combine the name and pathname into an href statement if possible (href=index.php Main).

 

[kochier]

Ok I've tried to insert code and my problem is nothing will show up now:

 

<?php

include 'opendb.php';

mysql_select_db('sitemap') or die('Cannot select database');

$sql = "CREATE TABLE map

(

Created date,

Name varchar,

Pathname varchar,

Map int

)";

mysql_query($sql);

mysql_query("INSERT INTO map (Created, Name, Pathname, Map)

VALUES ('2007-10-24', 'Main', 'index.php', '1')");

 

$result = mysql_query("SELECT * FROM map");

 

echo $result['Map'];

 

include 'closedb.php';

?>

 

I think it should echo "1" but nothing shows up when I run it.

[vicodin]

Google how to insert data into using php. Its pretty simple and you dont need the closedb include, it will do it automatically.

[kochier]

I've googled it, and as far as I can tell I'm doing everything right, but it won't display.

[kochier]

<?php

include 'opendb.php';

mysql_select_db('sitemap') or die('Cannot select database');

$sql = "CREATE TABLE map

(

Created date,

Name varchar,

Pathname varchar,

Map int

)" or die ('Cannot create table');

 

mysql_query($sql) or die('Failure?');

mysql_query("INSERT INTO map (Created, Name, Pathname, Map)

VALUES ('2007-10-24', 'Main', 'index.php', '1')") or die('Failure to Insert data');

 

$result = mysql_query("SELECT * FROM map");

while($map=mysql_fetch_array($rsql))

{

echo $map['Map'];

} 

 

 

include 'closedb.php';

?>

 

Is as far as I've gotten now. "Failure?" appears as my error, I can't figure out what's wrong with mysql_query though.