set_charset("utf8"); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } return $conn; return 2; } public function readFieldDB($tbl, $id){ $conn = $this->connectDBBDD(); $res = mysqli_query($conn,"SELECT nombre FROM ".$tbl." WHERE id = ".$id.""); $conn->close(); return mysqli_fetch_array($res)[0]; } public function readtableDB($tbl){ $conn = $this->connectDBBDD(); $res = mysqli_query($conn,"SELECT * FROM ".$tbl.";"); while($cRow = mysqli_fetch_array($res)){ $info[] = $cRow[0]; } $conn->close(); //echo "
";print_r($info);echo "
"; return $info; } public function createDB($tbl, $clmn, $long){ /*$conn = $this->connectDBBDD(); $sql = 'CREATE TABLE IF NOT EXISTS '.$tbl.'('.$clmn.' VARCHAR('.$long.') NOT NULL);'; if ($conn->query($sql) !== TRUE) { echo "Error creating database: " . $conn->error; //echo "Database created successfully"; } $conn->close(); return true;*/ } public function insertDB($tbl, $clmn, $value){ /*$conn = $this->connectDBBDD(); $sql = 'INSERT INTO '.$tbl.'('.$clmn.') values("'.$value.'")'; if ($conn->query($sql) !== TRUE) { echo "Error: " . $sql . "
" . $conn->error; //echo "New record created successfully"; } $conn->close(); return true;*/ } } $baseDeDatos = new baseDeDatos(); ?>
getAttributeLabel('nombre_completo') ?>
Tipo Colaborador
Activo
Opciones
nombre_completo?> readFieldDB("tbl_tipo_colaboladores",$item->tipo); ?>
activo == 1)? 'checked': '';?>>