{ 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; }