Calender Help

[zero_skill]

I am a newbie and I am creating a PHP calendar from when I can click a specific date and save the date in the database together with the user who click the the date in the calendar.

I there someone who can help me on this... Thanks in advice!!!

ZERO_SKILL 🙂

[bretticus]

So you have the calendar worked out and you just need to save something in the database that says, "such user clicked on this date?"

[Sangre]

Make every date a link like

<a href='writetodatabase.php?date=$date&user=$user'>$date</a>

off course you have to look how to exactly make this link depending on how you make the datelist, this is just an example.

then, writetodatabase.php should look something like

<?php

$date = $_GET['date'];
$user = $_GET['user'];

$connection = mysql_connect("localhost", "user", "pass") or die(mysql_error());
mysql_select_db("database", $connection) or die(mysql_error());

$sql = "insert into table values ('', '$date', '$user')";
mysql_query($sql, $connection) or die(mysql_error()); 

?>

the empty entry ' ' is a auto_increment in your MySQL table
so you have to create 3 fields there

[zero_skill]

Thanks bro... it helps a lot

[dougal85]

and make sure you check the 'GET' values! 🙂