{
return date("d/m", strtotime($d));
}
function dateToSqlDM($d)
{
return date_format(date_create_from_format('d/m', $d), 'Y-m-d');
}
echo "<strong>TEST dateToWebDMY</strong> <br>";
$dateFromSqlDMY = "2015-03-30";
echo "dateFromSqlDMY before: {$dateFromSqlDMY} <br>";
echo "dateToWebDMY(dateFromSqlDMY): " . dateToWebDMY($dateFromSqlDMY) . "<br>";
echo "<br>";
echo "UN DIGIT PER A MES<br>";
$dateFromSqlDMY = "2015-3-30";
echo "dateFromSqlDMY before: {$dateFromSqlDMY} <br>";
echo "dateToWebDMY(dateFromSqlDMY): " . dateToWebDMY($dateFromSqlDMY) . "<br>";
echo "<br><br>";
echo "<strong>TEST dateToSqlDMY</strong> <br>";
$dateFromWebDMY = "30/12/2015";
echo "dateFromWebDMY before: {$dateFromWebDMY} <br>";
echo "dateToSqlDMY(dateFromWebDMY): " . dateToSqlDMY($dateFromWebDMY) . "<br>";
echo "must be: 2015-12-30 <br>";
echo "<br><br>";
echo "<strong>TEST dateToWebDM</strong> <br>";
$dateFromSqlDM = "2015-12-30";
echo "dateFromSqlDM: 2015-12-30 <br>";
echo "dateToWebDM(2015-12-30) : " . dateToWebDM($dateFromSqlDM) . "<br>";
echo "<br>";
$dateFromSqlDM = "2015-1-20";
echo "dateFromSqlDM: 2015-1-20 <br>";
echo "dateToWebDM(2015-1-20) : " . dateToWebDM($dateFromSqlDM) . "<br>";
/**
* Return JSON object with all of user's events, with
* - id
* - parcela
* - titol
* - data
* - detalls
* - realitzada
* - user
*
* @param int $user user id whose events will be returned
*
* @return JSON array with events parameters, or error detail if fail.
*/
function getEvents($user)
{
if ($user == 0) {
$conexion = dbCon(2);
} else {
$conexion = dbCon(1);
}
$res = array();
$events = query_escaped($conexion, "SELECT id, parcela, title, start, detalls, realitzada, user FROM events WHERE user = {$user};");
if (mysqli_num_rows($events) > 0) {
while ($event = mysqli_fetch_array($events)) {
$res[$event['id']] = array('id' => $event['id'], 'parcela' => $event['parcela'], 'title' => $event['title'], 'start' => dateToWebDMY($event['start']), 'detalls' => $event['detalls'], 'realitzada' => $event['realitzada'], 'user' => $event['user']);
}
} else {
$res["error"] = "No hi ha events de l'usuari {$user} a la BBDD";
}
mysqli_close($conexion);
return $res;
}
