Tagged Questions
1
vote
1answer
76 views
Inconsistent results from phpmyadmin and Codeigniter's $this->db->query() function
User table
id stamp_created email_address
1 2013-03-06 22:00:01 [email protected]
2 2013-03-20 22:00:08 [email protected]
3 2013-03-27 22:00:17 [email protected]
4 2013-04-01 ...
0
votes
0answers
9 views
Join on non standard field with wanwizard datamapper
I have a table that defines modules in the system modules.
There are two columns that are important.
id:
This column is the autoincrement field, this increments every time a new module is installed
...
1
vote
1answer
122 views
Cannot restart mysql after setting bind-address
I have set up mysql on my server. I am trying to remotely access mysql from my mac via Codeigniter. I have set the bind-address to my server IP. However, I cannot restart mysql after setting the ...
2
votes
1answer
176 views
Forcing CodeIgniter to show 404 page instead of any other error like 1064
How can replace error pages like
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...
0
votes
2answers
21 views
Codeignitor mysql join didn't work
I've a db that have 2 tables, and a search keyword, how can i join the tables, to do the select's in all the tables?
$this->db->select('*');
$this->db->from('tracks', 'genres');
...
0
votes
1answer
31 views
Codeigniter Insert multiple rows in db with a table form
I've found similar questions but, I'm failing to find any answers that works for my situation.
Using Codeigniter:
I have a db table for products and a db table for inventory. I want to display an ...
6
votes
8answers
27k views
CodeIgniter: Unable to connect to your database server using the provided settings Error Message
I have been using CI just fine using the MySQL driver. I want to use the mysqli driver instead, but as soon as I change it (just add the ‘i’ at the end of mysql, and added the port number) I get the ...
1
vote
2answers
51 views
get the number of factories that are in a category
In this question, I asked about how to show the number of factories which are located in a specific category (using count).
I just want to do something like this:
Sidebar
------
Category1 (3)
...
-3
votes
2answers
22 views
A Database Error Occurred in codeigniter [closed]
my website is working on localhost BUT when I uploaded it to the web, there's an error that occured..
Error Number: 1146
Table 'db_puptaguig.alumni_tblAlumni' doesn't exist
select alumniID from ...
0
votes
2answers
48 views
Recursive table which child parent relationship
I have a problem with a recursive function that takes too many resources to display a child-parent relation in a dropdown list. For example:
home
-menu 1
-menu 2
home 1
-menu 3
-menu 4
I've ...
0
votes
1answer
29 views
How to upload image path and name to database - Codeigniter
I know that this question has been asked several times, but all the other question I found are different from what I want.
I want to upload the filename and filepath to a table called ...
2
votes
4answers
91 views
Replace each ’ with ' in php
I have following textarea field in question form where user can post their questions:
<tr>
<th><label><?php echo $this->lang->line('question'); ?>: ...
2
votes
2answers
141 views
INSERT…ON DUPLICATE KEY UPDATE versus client-side flow control: pros and cons
I have a SQL table in which I have to insert or update data depending on the existence of the primary key. The context is a CodeIgniter-based PHP web application running on MySQL. I discovered the ...
1
vote
1answer
31 views
How to show userdata from tank_auth in codeigniter?
What is the right way to get all the data from the 'users' table in my database, using Tank Auth?
I tried it with just with $this->db->get('users');
But how do i get the data for the specific ...
0
votes
0answers
25 views
how to call a model from rabbitmq php consumer's callback in codeigniter?
I developed an android app where it subscribes to a queue and also publishes to other queues. At a time it publishes the same message to two different queues, one of them is a queue named "Queue" and ...
