douxia1988 2016-11-30 13:56
浏览 182
已采纳

将MySQL查询字段作为数组处理是否有意义?

I have a php object method that load object "A" with the following MySQL query:

SELECT A.foo, A.bar...

I have another php object named B that uses MySQL fields from object A:

SELECT A.foo, A.bar...
       B.abc, B.xyz

To prevent code repetition, would it be considered a good practice to create an array (or an object) that stores the MySQL fields names of Object A so that this array can be used in object A and object B, like this:

Object A MySQL loading:

SELECT '.implode(',', $mysql_a_fields).' '...

Object B MySQL loading:

SELECT '.implode(',', $mysql_a_fields).', 
        B.abc, B.xyz

Or would it be code smell?

The goal is to to prevent repeating some SQL fields along queries that use those SQL fields. For example, if there is a mysql date field for object A that I want to get formatted the same way in all the requests I use this date field, is there any design pattern to prevent repeating DATE_FORMAT(date_field) in all the request?

Thank you

  • 写回答

1条回答 默认 最新

  • doupeng6890 2016-11-30 16:19
    关注

    About that array of field names. I would not do it. If you need to write all your selects this way, than write them. I do not know enough about your class/project structure to say if this makes sense.

    To help you with your date formatting problem (well, it's not really a problem, isn't it), I think you have two options: 1. Get the date field from the database as is and convert it in PHP. (Use a helper class that is accessible from everywhere to do this.) 2. Create a stored procedure that converts the format for you and use this in your SELECT queries.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 爬取网页信息并保存需要完整代码
  • ¥15 一分十不等功分器阻设计问题,请问这个56Ω怎么得到的
  • ¥15 (标签-matlab)
  • ¥100 求看看这个数学建模,有偿
  • ¥15 深度学习目标检测现在框架加注意力的创新可以投几区?
  • ¥15 PdfiumViewer pdf转图片
  • ¥15 利用Java连接API接口总是出问题
  • ¥15 请教一个关于镜头标定,棋盘格格子大小的问题(畸变测试)
  • ¥15 安装GroudingDINO RuntimeError: Error compiling objects for extension
  • ¥15 急!C++指针编写相关的问题