All Questions
Tagged with codeigniter mysql
9 questions
2
votes
2
answers
309
views
Newsletter subscribers management system in CodeIgniter 3
I am working on a online newspaper/blogging application with CodeIgniter 3.1.8 and Twig.
The application is meant to offer developers and designers the possibility to very easily turn their HTML ...
- 643
0
votes
1
answer
987
views
1
vote
1
answer
326
views
Round fractional seconds of MySQL Time
I've written a method to round a MySQL Time to two decimal places. Here's some examples:
...
- 113
8
votes
4
answers
1k
views
Checking 160,000 records in a database for changes
I am checking over 160,000 records in my database every 24 hours to see if there were changes in the incoming data coming from API and my existing data in the database. If there were I am updating ...
- 91
1
vote
1
answer
8k
views
User model with user roles in Codeigniter PHP/MySQL
I am building an app that currently allows the users to have 3 different roles:
Consumer
Merchant
Admin
I have three tables:
user (Name, email, password etc with a status=0/1)
user_role (The list of ...
- 141
3
votes
3
answers
1k
views
CodeIgniter AJAX messages submission security issue
I have a small social networking site built in CodeIgniter. Any registered user can send messages to others by visiting their profile.
Today I noticed that one user sent bulk messages to 200 users. ...
- 33
3
votes
2
answers
5k
views
Mutlilevel page list in CodeIgniter
I'm newly working with CodeIgniter and PHP. I wrote a category structured 'pages' code with listing pages as multilevel list or indented select box.
...
- 133
3
votes
2
answers
644
views
Database design for an online learning application
It is an online learning application with different types of learnable items, that different users learn.
The users learn by spaced repetition (once right, wait a couple days, ask again), success is ...
- 131
29
votes
2
answers
38k
views
CodeIgniter Active Record Subqueries
I use CodeIgniter at work, and one of our model files had a lot of subqueries in it. I originally had to manually write each subquery, and wondered if I could use active records instead.
So, to make ...
- 730