database codeigniter

In database.php I have: $db['default']['username'] = IS_PRODUCTION ? 'prodUsername' : 'localDevBoxUsername'; $db['default']['password'] =…

I've been searching about safety deleting db entries in Codeigniter I and finally created a solution that I think is secure. I would really…

I am trying to add search functionality onto my website, the user can search for jobs using sector names, so for example they may want to search for…

What is the safest way to delete rows in a database table using Codeigniter? I am using the following method. HTML: Retrieves links submitted by…

I am in the process of building a user experience/level system on my site. The effect I am trying to achieve is similar to that of the popular game…

I'm thinking of creating a 'People who viewed this also viewed' list that you see on amazon, yelp and other online sites. Right now I'm thinking of…

I'm creating a TV script which is (very similar to, but not the same as): http://library.digiguide.tv/lib/programme/True+Blo-(663898/Drama/…

Hi, I'd like to use the following class from codeigniter: DB_forge.php (or any other class that can create and edit tables) Now, I know just…

Hello all! I'm working on a radius search with Google Maps API and MYSQL…

So I have a query that should get all posts from a table while linking the posts categories and the user that created the post. What I am getting…

Now I know how to join two tables, I'd like to actually count the number of rows in the second table with active records . Say, I have these two…

Let's say I have these two database tables: blog comments ------- ---------- blog_id comment_id title blog_id content comment Now I'd like to run…

This query: SELECT `p`.`custom_url` AS custom_url, `p`.`product_name` AS name FROM ( `product` AS p ) ORDER BY `p`.`creation_date` DESC LIMIT 5…

I'm currently working on Codeigniter-MySQL. Now i want to learn some 'No SQL' Cloud DataBase. Which one is good to start with. It should be easy to…

I'm using CI and have a PostgeSQL set up with two tables: Posts and Comments, which both have 2 columns: Id and Date. Comments also has a column…

In the CodeIgniter user guide , I came across this suggestion: In many databases it is advisable to protect table and field names - for example with…

I have written a query which returns all records with some many-to-many joins correctly for the entire set or an individual article using WHERE a.id…

Hey In my site I will let users upload product images and each product image will have different versions of varying sizes. How do you suggest I…

Currently, I have my database configuration something like this: $db['default']['hostname'] = "localhost"; $db['default']['username'] =…

So, not having come from a database design background, I've been tasked with designing a web app where the end user will be entering products, and…