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>"; echo "<br><br>"; echo "<strong>TEST dateToSqlDM</strong> <br>"; $dateFromWebDM = "25/11"; echo "dateFromWebDM: 25/11 <br>"; echo "dateToSqlDM(25/11) : " . dateToSqlDM($dateFromWebDM) . "<br>"; echo "<br>"; $dateFromWebDM = "30/1"; echo "dateFromWebDM: 30/1 <br>"; echo "dateToSqlDM(30/1) : " . dateToSqlDM($dateFromWebDM) . "<br>"; echo "must be 2015-1-30";
/** * Return JSON object with all of user's plantes, with * - id * - nom_comu * - nom_cientific * - grup * - familia * - marc_ample * - marc_llarg * - sembra * - tasques * - plagues * * @param int $user user id whose plantes will be returned * * @return JSON array with plantes parameters, or error detail if fail. */ function getPlantes($user) { global $log; if ($user == 0) { $conexion = dbCon(2); } else { $conexion = dbCon(1); } $res = array(); $plantes = query_escaped($conexion, "SELECT id, nom_comu, nom_cientific, grup, familia, sembra_ini, sembra_fi, duracio, marc_ample, marc_llarg, sembra, cultiu, collita FROM planta WHERE user = {$user};"); if (mysqli_num_rows($plantes) > 0) { while ($planta = mysqli_fetch_assoc($plantes)) { $res[$planta['id']] = array('id' => $planta['id'], 'nom_comu' => $planta['nom_comu'], 'nom_cientific' => $planta['nom_cientific'], 'grup' => $planta['grup'], 'familia' => $planta['familia'], 'marc_ample' => $planta['marc_ample'], 'marc_llarg' => $planta['marc_llarg'], 'sembra' => str_replace(array("\r", "\n"), array("\\r", "\\n"), $planta['sembra']), 'sembra_ini' => dateToWebDM($planta['sembra_ini']), 'sembra_fi' => dateToWebDM($planta['sembra_fi']), 'duracio' => $planta['duracio'], 'cultiu' => $planta['cultiu'], 'collita' => str_replace(array("\r", "\n"), array("\\r", "\\n"), $planta['collita']), 'tasques' => getTasquesPlanta($planta['id'], $conexion), 'plagues' => getPlaguesPlanta($planta['id'], $conexion)); } } else { $res["error"] = "No hi ha plantes de l'usuari {$user} a la BBDD"; } mysqli_close($conexion); return $res; }