StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POProblem in codeIgniter library does not return a value
primarykey
Id
7213614
data
AcceptedAnswerId
0
AnswerCount
1
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-08-27T09:19:10.003
FavoriteCount
0
LastActivityDate
2011-08-27T09:28:15.963
LastEditDate
LastEditorUserId
0
OwnerUserId
910849
ParentId
0
PostTypeId
1
Score
0
ViewCount
1052
LastEditorDisplayName
text
Body
I have the following library in codeIgniter that has functions <code>getDbs()</code> and <code>getTables()</code> in the <pre><code>return $dbs; </code></pre> and <pre><code>return tables; </code></pre> the problem is they don’t return anything what am i doing wrong. Is it because i am using an array or sth <pre><code>class Db_models { private $host; private $user; private $password; private $link; private $dbname; private $fields; public $dbs; //TODO make this flexible especially connect statement public function __construct($config) { $this->host = $config[0]; $this->user = $config[1]; $this->password = $config[2]; $this->link = mysql_connect($this->host, $this->user, $this->password); print_r($this->link); } //Get Databases function getDbs() { $db_list = mysql_list_dbs($this->link); $row = mysql_fetch_object($db_list); var_dump($row); while ($row = mysql_fetch_object($db_list)) { $dbs[] = $row->Database; } return $dbs; } //Get Tables function getTables($dbname) { $this->dbname = $dbname; $sql = "SHOW TABLES FROM $dbname"; $result = mysql_query($sql); if (!$result) { echo "DB Error, could not list tables\n"; echo 'MySQL Error: ' . mysql_error(); exit; } while ($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } return $tables; } //Get Fields function generateFields($dbname,$table){ mysql_select_db($dbname, $this->link); $result = mysql_query("SHOW COLUMNS FROM $table"); if (!$result) { echo 'Could not run query: ' . mysql_error(); exit; } if (mysql_num_rows($result) > 0) { while ($row = mysql_fetch_assoc($result)) { $this->fields[]=$row; } return $this->fields; } } } ?> </code></pre> Here is my cotroller <pre><code><?php if (!defined('BASEPATH')) exit('No direct script access allowed'); class Welcome extends CI_Controller { /** * Index Page for this controller. * * Maps to the following URL * http://example.com/index.php/welcome * - or - * http://example.com/index.php/welcome/index * - or - * Since this controller is set as the default controller in * config/routes.php, it's displayed at http://example.com/ * * So any other public methods not prefixed with an underscore will * map to /index.php/welcome/<method_name> * @see http://codeigniter.com/user_guide/general/urls.html * */ private $fields=array('s'=>'s'); public function __construct() { parent::__construct(); $this->load->library('db_models', $config = array('localhost', 'madawar_Madawar', '23goodboys')); } public function index() { // $this->load->library('db_models', $config = array('localhost', 'Madawar', '23goodboys')); $data['dbs'] = $this->db_models->getDbs(); $this->load->view('welcome_message', $data); } public function database() { $db_name = $this->input->post('database'); $data['db_name'] = $db_name; // $this->load->library('db_models', $config = array('localhost', 'Madawar', '23goodboys')); $data['tables'] = $this->db_models->getTables($db_name); $this->load->view('database_dash', $data); } public function generate($dbname,$table) { /*$data = decode(TRUE); print_r($data); echo "sd";*/ // $this->load->library('db_models', $config = array('localhost', 'Madawar', '23goodboys')); $data = $this->fields= $this->db_models->generateFields($dbname,$table); //print_r($data); $data=encode($data); echo $data; } public function getFields($some,$data) { echo $some; echo $data; // $this->load->library('db_models', $config = array('localhost', 'Madawar', '23goodboys')); $this->fields= $this->db_models->getFields(); } } </code></pre>
Tags
<php><codeigniter>
Title
Problem in codeIgniter library does not return a value
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USMadawar
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
 singulars
 PostTypePostTypeId
 PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.