public function load(Connection $connection)
{
if (!$connection->isConnected) {
$connection->Connect();
}
if (!$connection->query($this->medicationQuery)) {
return false;
} else {
$result = null;
$medication = null;
while ($result = $connection->getObject()) {
$medication = new Medication();
$medication->setCommonDose($result->commonDose);
$medication->setGenericName($result->genericName);
$medication->setRoute($result->route);
$medication->setUnit($result->unit);
$medication->setMedicationID($result->medicationId);
$medication->setActive($result->active);
$medication->setConfirmed($result->confirmed);
$medication->setConfirmedBy($result->confirmedBy);
array_push($this->medicationList, $medication);
}
}
return true;
}
public function create( Connection $connection ) {
$query = "select patientId, firstName, lastName, roomNumber, unitName from Patient where unitName = '{$this->unitName}';";
if( !$connection->Connect() ){
echo "error: " . $connection->getError();
return false;
}
if( !$connection->query( $query ) ){
echo "error: " . $connection->getError();
return false;
}
$this->patientList = array();
while( $result = $connection->getObject() ) {
$patient = new Patient( $result->firstName, $result->lastName );
$patient->setPatientID( $result->patientId );
$patient->setRoomNumber( $result->roomNumber );
$patient->setUnitName( $result->unitName );
array_push( $this->patientList, $patient );
}
}
<?php
//Importación de las clases de acceso a datos
include_once 'config/config.inc.php';
include_once 'modules/data/connection.class.php';
include_once 'modules/data/query.class.php';
//Instanciación de clases
$Data = new Connection();
$Link = $Data->Connect(SERVER, USER, PASSWORD);
$Link = $Data->SelectDataBase(DB, $Link);
$Querys = new Querys();
$IdUser = $_SESSION['id'];
if (isset($_GET['id'])) {
$Asignatura = $Querys->Select('*', 'asignaturas', "WHERE id_asig='" . $_GET['id'] . "'");
}
$Areas = $Querys->Select('*', 'areas', "");
$numoc = $_SESSION['oc'];
//FOLIO MAYOR
if ($idobra == 0) {
$rowstock = $stock->Select($arr[$i][0]);
if (mysql_fetch_array($rowstock) == null) {
// echo "insert";
$stock->Add($arr[$i][0], 0, '0', $_POST["{$n}"], 0);
} else {
// echo "update";
$stock->UpdateC($arr[$i][0], $_POST["{$n}"]);
}
}
$cont->Add($arr[$i][0], $_SESSION['oc'], $iddoc, $rut, $idobra, $folio, $arr[$i][2], $arr[$i][3], $_POST["{$n}"], 0, $fechaactual);
$sql = "update CONTIENE set CANTIDADBODEGA_CONTIENE=" . $bod . " where ID_MATERIAL=" . $arr[$i][0] . " and NUMERO_OC=" . "'{$numoc}'" . " and ID_DOCUMENTO='0' AND RUT_PROVEEDOR=" . "'{$rut}'" . " AND ID_OBRA=0" . " AND FOLIO_CONTIENE=0";
//echo $sql;
$con->Connect();
$accion = mysql_query($sql);
$con->DisConnect();
}
//}
$au = $_SESSION["autentificado"];
$name = $_SESSION["nombre_usuario"];
$ap = $_SESSION["apellidos_usuario"];
$num = $_SESSION["numoc"];
$tipo = $_SESSION["tipo"];
session_unset();
$_SESSION["autentificado"] = $au;
$_SESSION["nombre_usuario"] = $name;
$_SESSION["apellidos_usuario"] = $ap;
$_SESSION["tipo"] = $tipo;
$_SESSION["size"] = count($arr);
<?php
require_once '../classes/config.php';
$connection = new Connection();
$pdo = $connection->Connect();
$registry->set('pdo', $pdo);
startSession();
if (isset($_GET['login'])) {
if (isset($_POST['username']) && isset($_POST['password'])) {
$username = trim($_POST['username']);
$password = trim($_POST['password']);
$stmt = $pdo->prepare("SELECT * FROM users where username = ? AND password = ? LIMIT 1;");
$stmt->execute([$username, $password]);
$row_cnt = $stmt->rowCount();
if ($row_cnt == 1) {
if (startSession()) {
$_SESSION['login_user'] = $username;
$row = $stmt->fetch(PDO::FETCH_LAZY);
$_SESSION['role'] = $row['role'];
}
}
}
}
if (isset($_POST['logout'])) {
destroySession();
exit(header('Location: index.php'));
}
if (isset($_POST['cancel'])) {
exit(header('Location: index.php'));
}
if (!isset($_SESSION['login_user'])) {
