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