Tagged Questions
0
votes
1answer
15 views
codeigniter active record db query
I need a query that looks like:
select * from table where id=5 and (eid = 1 or eid = 2 or eid = 10)
and I have tried
$this->db->select()->from(MEMB_EVENTS);
...
0
votes
1answer
30 views
Twitter Bootstrap change input value [closed]
i want to change input value from button group using twitter bootsrap
here's my code
<div class="btn-group alignment" data-toggle="buttons-radio">
<button type="button" ...
1
vote
2answers
29 views
How to add form_dropdown id value to database? - codeigniter
I have a form with a dropdown for categories.
it looks like this:
<tr>
<td><?= form_label('Categorieen'); ?></td>
<td><?= form_dropdown('categorieen', $opties); ...
0
votes
1answer
35 views
How to automatically insert factoryid and categoryid into a table when submitting form - codeigniter
I am using 3 tables for joining.
I have a form where i can add a factory. I also can choose a category for that specific factory.
i use the following tables:
factorycategories
-----------------
...
1
vote
2answers
33 views
Codeigniter LIKE with wildcard(%)
I have simple database query in codeigniter, however I cannot get search to work with wildcard. This is my code:
$this->db->like('film.title',"%$query%");
...
0
votes
1answer
43 views
CodeIgniter search results are unexpected; where() with or_like() broken?
Today's date is April 25, 2013. Yes, the time on the server is correct and a var_dump of mdate('%Y-%m-%d', strtotime(now())) is returning 2013-04-25.
The MySQL table column for date is the date ...
1
vote
3answers
40 views
How can I query this in CodeIgniter
This is what I want:
SELECT DISTINCT first_name,last_name
FROM employees e
INNER JOIN salaries s ON e.emp_no = s.emp_no
WHERE e.birth_date > '1963-01-01'
AND s.salary>150000
I've tried ...
0
votes
1answer
31 views
How to show Factories for when specific User has logged in
How do I add an factory to any of my logged in users? I'm using Tank_auth and I made an account 'admin'
I also made a table called 'factoryusers'.
I want to add a factory to a specific user using ...
-2
votes
2answers
43 views
Retrieving the last two days record
how to get last two days record here is my query but getting errors.
function getbdologHistoryByRefManuals($obj)
{
$this->db->select('bdo_logs.*,transaction_statuses.status');
...
-4
votes
2answers
50 views
SQL Query join with a count and avg from another table
Actually the math doesn't seem to be adding up.
Here is the query I'm using and the 2 table's i'm trying to access (with all real data).
This query in SQL is pulling Steve Smith to have 27 sum and ...
0
votes
0answers
16 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
...
0
votes
3answers
31 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
69 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 ...
-3
votes
2answers
26 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
1answer
43 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 ...
