链接MySQL命令。 原始查询

Question

I have been building a lot of website in the past using my own cms/framework and I have developed a simple way of executing queries. Recently I have started playing with other frameworks such as code igniter. They offer raw query imputs such as…

$this->db->query(“SELECT * FROM news WHERE newsId=1;”);

But they also offer chaining of MySQL command via PHP methods.

$this->db->select("*")->from("news")->where("newsId=?");

The question is; what is the main difference and of benefits of each option.

I know the latter options prevents MySQL injection but to be honest you can do exactly the same from using $this->db->escape().

So in the end from what I can see the latter option only serves to make you use more letters on your keyboard, this you would think would slow you down.

Answer 1

Most recent php framework developers are uses AR(active record)/DAO(database access object) Pattern. Because it's really faster then raw query. Nowadays AR technique originally built from PDO(php data object).

why active record is really faseter?

its true query writing is the best habit for a developer. But some problem make it tough

1. When we write insert and update large query, sometime it's hard to match every row value.. but AR make it easy. you just add array first and then execute easily.
2. Doesn't matter what DB you use.
3. Sometimes it's really hard read or write query if it has many condition. But in AR you can cascade many object for 1 query.
4. AR save your time to repeating statement