-
sheng
Newbie
-
Posts: 6
Threads: 2
Joined: Nov 2015
Reputation:
0
case 1
dbprefix='keweilong_';.
[font=Tahoma, Arial]$this->db->list_tables(true);[/font]
[font=Tahoma, Arial][font=Tahoma, Arial]SHOW TABLES FROM `a2342343` LIKE 'keweilong!_%'[/font][/font]
[font=Tahoma, Arial][font=Tahoma, Arial][font=Tahoma, Arial]no record[/font][/font][/font]
if query = [font=Tahoma, Arial]SHOW TABLES FROM `a[/font] [font=Tahoma, Arial][font=Tahoma, Arial]2342343[/font][/font][font=Tahoma, Arial][font=Tahoma, Arial]` LIKE 'keweilong_%'[/font][/font]
[font=Tahoma, Arial][font=Tahoma, Arial][font=Tahoma, Arial][font=Tahoma, Arial][font=Tahoma, Arial][font=Tahoma, Arial]There are records[/font][/font][/font][/font][/font][/font]
-
sheng
Newbie
-
Posts: 6
Threads: 2
Joined: Nov 2015
Reputation:
0
11-13-2015, 11:27 PM
(This post was last modified: 11-13-2015, 11:37 PM by sheng.)
(11-13-2015, 10:37 PM)wolfgang1983 Wrote: (11-13-2015, 08:25 PM)sheng Wrote: case 1
dbprefix='keweilong_';.
[font=Tahoma, Arial]$this->db->list_tables(true);[/font]
[font=Tahoma, Arial][font=Tahoma, Arial]SHOW TABLES FROM `a2342343` LIKE 'keweilong!_%'[/font][/font]
[font=Tahoma, Arial][font=Tahoma, Arial][font=Tahoma, Arial]no record[/font][/font][/font]
if query =[font=Tahoma, Arial]SHOW TABLES FROM `a[/font][font=Tahoma, Arial][font=Tahoma, Arial]2342343[/font][/font][font=Tahoma, Arial][font=Tahoma, Arial]` LIKE 'keweilong_%'[/font][/font]
[font=Tahoma, Arial][font=Tahoma, Arial][font=Tahoma, Arial][font=Tahoma, Arial][font=Tahoma, Arial][font=Tahoma, Arial]There are records[/font][/font][/font][/font][/font][/font]
Cannot under stand what your after question unclear to me.
[font=Tahoma, Arial]I want to query the database table, prefix is keweilong_[/font]
$this->db->list_tables(true);
but [font=Tahoma, Arial]no record[/font]
PHP Code: $record=$this->db->list_tables(true);
PHP Code: $record=$this->db->query('SHOW TABLES FROM `'.$this->db->database.'` LIKE \''.$this->db->dbprefix.'%\' ');
-
InsiteFX
Super Moderator
-
Posts: 5,343
Threads: 145
Joined: Oct 2014
Reputation:
156
Try this:
PHP Code: $this->db->dbprefix('keweilong');
$record=$this->db->list_tables(true);
What did you Try? What did you Get? What did you Expect?
Joined CodeIgniter Community 2009. ( Skype: insitfx )
-
sheng
Newbie
-
Posts: 6
Threads: 2
Joined: Nov 2015
Reputation:
0
(11-14-2015, 05:24 AM)InsiteFX Wrote: Try this:
PHP Code: $this->db->dbprefix('keweilong');
$record=$this->db->list_tables(true);
if prefix=XXXX_XXX_* ?
|
