我正在使用codeigniter从数据库中获取字符串,我想将数据库Postgres中的对象转换为String我该怎么办?
public function gettable($username, $password){
$cek_user = $this->db->query("SELECT hak_akses FROM tablelogin WHERE username = '$username' AND password = md5('$password')"); // Cek User Sudah Terdaftar
if($cek_user->num_rows()>0){
static $cek;
foreach($cek_user->result() as $cek){
$cek->hak_akses;
}
if($cek=='admin'){
$ambil = $this->db->query("SELECT table_name FROM information_schema.tables WHERE table_schema='public' and table_name != 'tablelogin'");
return $ambil->result();
}
if($cek=='semi_admin'){
$ambil = $this->db->query("SELECT table_name FROM information_schema.tables WHERE table_schema='public' and table_name != 'tablelogin' and table_name != 'Film' and table_name != 'Hewan'");
return $ambil->result();
}
if($cek == 'user'){
$ambil = $this->db->query("SELECT table_name FROM information_schema.tables WHERE table_schema='public' and table_name != 'tablelogin' and table_name != 'Gudang' and table_name != 'inventaris' and table_name != 'Pegawai'");
return $ambil->result();
}
}
else {
$hasil = null;
}
}
谢谢你的帮助。
我认为您想$cek->hak_akses;
与admin
or等进行比较。semi_admin
不需要转换为string.userow()
结果集。并使用else if
诸如此类的语句..
if($cek_user->num_rows()>0){
$row = $cek_user->row();
$cek = $row ->hak_akses;
if($cek=='admin'){
$ambil = $this->db->query("SELECT table_name FROM information_schema.tables WHERE table_schema='public' and table_name != 'tablelogin'");
return $ambil->result();
}
else if($cek=='semi_admin'){
$ambil = $this->db->query("SELECT table_name FROM information_schema.tables WHERE table_schema='public' and table_name != 'tablelogin' and table_name != 'Film' and table_name != 'Hewan'");
return $ambil->result();
}
else if($cek == 'user'){
$ambil = $this->db->query("SELECT table_name FROM information_schema.tables WHERE table_schema='public' and table_name != 'tablelogin' and table_name != 'Gudang' and table_name != 'inventaris' and table_name != 'Pegawai'");
return $ambil->result();
}
}
else {
$hasil = null;
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句