Tagged Questions

7
votes
5answers
7k views

Database class using PDO

The point of this question What about this piece of code? I'm actually using it while developing a simple application and it seems to cover all my needs. Also it uses PDO so that we don't really have ...
0
votes
1answer
56 views

What are the ways of updating a database automatically? [closed]

I have an RSS reader project and I need to update my database automatically. I have used cron but I have to set new crons every time I have new links and it also get me stuck because of too many cron ...
2
votes
2answers
745 views

Need advice for my simple shopping cart's database structure

I’m trying to make a simple shopping cart application in PHP and am unsure of how to structure the database. I believe there are three tables that I need (but I could be wrong!): 1. products table ...
2
votes
1answer
380 views

OOP MySQL connection class

Under sage from another CR post I'm crafting an OOP MySQL connection/query class. Nothing new, but a place to start plying OOP PHP. Here is the current design,what would aid speed and portability? ...
1
vote
1answer
69 views

is there a better and short way to getting that array from joined sql query and converting it to superfish dropdown menu?

I'm trying to build a superfish dropdown menu from a sql query. Working example is can be seen from here check the "emlak bul" category: ...
0
votes
1answer
363 views

How can I display the results of mysql_fetch_assoc in a dynamic table?

I have a MySQL database with several columns and two rows of data, so far. I'm using mysql_fetch_assoc to return the data in database, but I don't know how to put it all together in a table so that I ...
2
votes
2answers
246 views

Gathering data from database

The following code has one of the most confusing lines I've ever wrote. I can imagine ten other way to write it but I do not know which else could be any better. So I'm here to ask you fellows how ...
5
votes
2answers
312 views

Database method to query

I have a database class that in __construct() initialize a PDO connection and insert the instance into a $db private var. Now i'm working on a method that can be used to query in this way: $db = new ...