小小小菜鸟 发表于 2014-9-17 17:10:43

CI 中的日期分格

例:
      开始时间:2014-10-01 15:13:35      结束时间:2014-10-03 15:13:35

要求:添加时,根据天来分段。
          在数据库中显示的字段为3段,   1号的一条数据,2号的一条数据,3号的一条数据。

怎么编写?
求解答,谢谢。

Closer 发表于 2014-9-17 17:36:14

不太懂你的需求
能用表格或圖片解釋一下嗎?

小小小菜鸟 发表于 2014-9-17 18:05:00

Closer 发表于 2014-9-17 17:36
不太懂你的需求
能用表格或圖片解釋一下嗎?


data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdoAAABtCAIAAACJPjeBAAAABmJLR0QA/wD/AP+gvaeTAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAMMElEQVR4nO3du47iVhzH8b938yCRsgoFFjh1qihdRoqRaCKQeQxcjqa0HwME2WYku2Cr7CtkYeRTsBopK6XJWziFL/gKHoYNZybfTwXm3MYjfj7n2DtrxHEseLpPn79cewgAdPHD998+vxGDOAYAHby59gAAACLEMQBogjgGAC0QxwCgBeIYALRAHAOAFohjANACcQwAWiCOAUALxDEAaIE4BgAtEMcAoIVvrj2Al+r9h4/XHgIAXfz2y8/Pb4Q4Pt+vP/147SEAuL793/9cpB3i+Hxv3rDVA+BiiOPzvX1LHAO4GOL4fMyOAVwQcXy+N4Zx7SEAeD2I4/MZxDGAy2G5DQBaII4BQAvEMQBogTgGAC0QxwCghefEsfItazazjFTpta9ERMKZMQsleWX5SkT5eRHDmIUi4cw4qly91HXpwNFB5iXzN6VxVPoCgGt4RhyrzVomY1OcII7jyBuK6W7jOH0tIsq3RktZjgzDMIzRcuealv8oSfE4DhwREbEXcfp26EVx5vBuYYuIqP1DqevQW09W837xyKxLrPbn25VMLV/159u4LB0PAFzJ+XGsNmuZ3LxrL9CfbwPnkL5DL9rOjxQ/YdDL0zec3Zqreb8y800DPHBE7gvZbLq7nWsahuUr5VuzMEnk4qS44zT7DIc5eH6FSC8blT5DvzYG5VunZuvlWs0tV2p07f1oX8WlxfExllrOrpjHRlgr070v4MU7O45Dz90lr5ajQuqlCXgol8+OWw+c6mhmGKa7S6pZvsrDWKQ/X03W0/q3e7w4zHojbzj0ojjelibT6UXiq86KlT+N7tIxPNz6SkTC2ejBi+I4vovMfBvGMIzRul63eBJrarUaWm6o1LH3E31J7y5fyCSrlw61lH8rQRzHcdT4K2st06Uv4HU4M46Vf5vHabZZke82pJsVhU+LqVc8cJj7jJZ5mpffWXs3jryhEyTtrqelkqa727leKCKSHk1ivrrXfCUPeyUi0r+ZDEREwvulczfvi4g9dtLP7EX9kqD8qSvDobSr1mpquapr76f6aqZ8qzTvrdbqz7dJnGYno6FWcxng/+LMOH6USVAMXenPt/n8s/j6+GT4sIXbtnccb+d9tVkPxrbIYySTVXXPNw6c5a2vSpsVIvbiLmqbgxVG9ZRZ+pMdTkPoReN5X9T+YWim2zXvTIkem+uFMzO6i1eT/G3pfmPjZabecr1Wx947eNzfe1Z1MP35trICaaE2kXmTlWupdSjT2BfwOp0Zx/b8sA2cRlvxwYrCd6c8O36Mdo35XL1XV/IYDca2iNo/DHr92jMRIwmaYsB2J2uvdbPxv9isSCjfMu7H3dfZyt+PS8tye1G6+nSKvHNrdWP3THN1Yt+hWTgzDHN9SOPTZc7vC3hxLvDccRpt28V4kMxQI2846PUlnBm1Jyv22SS2EoOP0a5wr67CHkuyPT0Y2yL5PLi+MVKSr3yvSPnWVFZZuvZ7g102KX2MxGy6r6k2a3eUbsMsR12nhF1a7lKmI3ue7t0/dU/BXsRxnDzb0rXM2X0BL84F4jhb+M/EnaxNy7LM9cS10+9V5A2dIPKG4gRxvO1Fy6bUVf7t0hm3Z6e9SNK7ZVM0Udo77jrmr7lZIeFsKqtkXqrCUInYY2d5H4qIhPeNJ6KwfZPsl3ed1XZouVOZLg4Pk6vN+siipq3WU8qc1xfwQlW3YjtLbt6ld9lKK//8QOH+XuCIExQ3iPNn4CJvWJrvJh+WjgSOiBPEkTcUx6tNh52gWOPwbF1tDNlYy2Nu7vKk3zd/nChRmv9nHaYHS+chVeg/P9g2poZatZbbq53o/VRfhxVJoVL113hWrXqZxlqAXv7c/3WRdi4Vx8nXJgmdwBGRoedVgjELvOwblj0s0fA9K2Zj8ZmNxrf1aI3jxu9xSwxXE7Ob03EM4P/hUnFsxHHcPnVGq/cfPl7kv/IG8NJ9+vzlh++/fX47/AkhANACcQwAWiCOAUALxDEAaIE4BgAtEMcAoAXiGAC0QBwDgBaIYwDQwjfXHsBL1Xv33afPX649CgCvB/9IGgC0wGYFAGiBOAYALRDHAKAF4hgAtEAcA4AWiGMA0AJxDABaII4BQAvEMQBogTgGAC0QxwCgBeIYALTAX3Q70/sPH689BAC6+O2Xn5/fCHF8vl9/+vHaQwBwffu//7lIO8Tx+d68YasHwMUQx+d7+5Y4BnAxxPH5mB0DuCDi+HxvDOPaQwDwehDH5zOIYwCXw3IbALRAHAOAFohjANACcQwAWiCOAUALz4lj5VvWbGYZqdJrX4mIhDNjFkryyvKViPLzIkb2UaFU3m7pfUXa1BMGmRfP35TGUR0PAFzBM+JYbdYyGZviBHEcR95QTHcbx+lrEVG+NVrKcmQYhmGMljvXtPxHSYrHceBkzfi3D55rt/cTzsqpOVruXLOao8VC7bHan29XMrV81Z8nQz3IxwMAV3F+HKvNWiY379oL9OfbwDmk79CLtvN68dBzB3fzfnHCarq7NMQNw7D8d4tqcA69qHRkYYtIejBwRO4L2Wy6u51rGoblK+VbszBJ5GKYP2Wu/cRTlP9I+RUivWxU+gz92hhOLBHqtZpbrtSolClexI6fhmJfxaXF8TGWRph1dqyjepl8iKxd8OqdHceh5+6SV8tRIfXSBDyUy2fHjQeUfyvBwhblW1NZpekaecM0xOM43pajujY7bvpyjwsBHnnDoRel7eQO7X+9WbHyp9FdOoaHW1+JSDgbPXhRHMd3kZnv4hiGMVrX6xZPYk2tVkPLDZUqZdTeDLKz5N2VTtCxvqR3l18OF23Lmmot5d9KEMdxHE3W05ZArpcJZ7dm0lcgIwIZr9yZcaz82zxfs82KfM6ablYUPi2mXvFA6KUT4amstjcbqz47zr+CxQA9zI4LYZpmdBLzT9tf/moe9kpEpH8zGYiIhPdLJ0k9e+ykn9mL+iVB+VNXhkNpV63V1HJVvUx/Pk/SNNzITet2UdMI65RvlS6N1Vr9+TaJ7uxkNNSqlVH7h0EvuUrYrifNPxfwWpwZx48yCYqhK/35Np9/Fl/XZ8dF9iKOI88L4u28L/X93GOzr5rCZoWIvbiL2uZghVG1DuwSDqch9KLxvC9q/zA00+2ad6ZEj831wpkZ3cWrSf62uLPSvNSvt1yvdaT3UHptU+Mmj/t7z6oOpj/fVlYgLdQmMm+yci21sjL93iC9tih/6i7bzhjwOpwZx/b8sA2cRlvxwYrC97Q8O36MdsV8Vr5lmK47SubBDY87HNanxQA9bFa0h6ntTtZe6+r2v9isSCjfMu7H3a8qyt+PSxchu7x13inynlRL+XvpPDwREbtnmqsT+w7NwplhmOtDGp8sY7uTtWkYhjGVCfda8dpd4LnjNNq2i/EgmaFG3nDQ60s4M2pPVuyzSWwSg8UJ8cKWYkyWNj3ycpE3TOQlW4MmX/leUbolno6j3xvssgneYyRm021QtVknV6dkx6bjlkuXltvKqE0kR27INrHnyUkv7Tt0qriI4zh5tqVjmew3v72RB2d87d8n8FVdII6zeetM3MnatCzLXE9cO/1eRd7QCSIvic9tL1pme4EH2aR4tjnWS7L6nspqezeQySoe31dW7qW9465j/pqbFRLOprJKLhcqDJWIPXaW96GISHjfcCJEyhceJ+g6F+7ScksZtVk/PPXHyhYtT6lbfbi8Y5nsUOi5A9IYr119u7aj5OZd6SmIdOWfHyjc3wsccYLKTTgnCBzJN30rtwATTlBrtHgrL63hBIeDh2framPIxloec73VTn7f/HGiRGkbJOswPdh0M7LQf36wbUwNtWott1crlinegz31c6QFD7+nQs3IG5baPatWvUx25Gm/HOA/9ef+r4u0c6k4Tr42SeikIetVgjELvOwbVovEakw2xmbX4Gz49rfEcDUxuzkdxwD+Hy4Vx0Ycx8cmz2jx/sPHi/xX3gBeuk+fv/zw/bfPb4c/IQQAWiCOAUALxDEAaIE4BgAtEMcAoAXiGAC0QBwDgBaIYwDQAnEMAFr45toDeKl677779PnLtUcB4PXgH0kDgBbYrAAALRDHAKAF4hgAtEAcA4AWiGMA0AJxDABaII4BQAvEMQBogTgGAC0QxwCgBeIYALRAHAOAFviLbmd6/+HjtYcAQBe//fLz8xv5F+djPfySGoAHAAAAAElFTkSuQmCC

在添加的时候,添加入数据库后显示的数据,第一条: 2014-10-01 15:13:35 到2014-10-01 23:59:59 ,第二条2014-10-02 00:00:00 到2014-10-02 23:59:59 ,第三条2014-10-03 00:00:00 到2014-10-03 23:59:59   以此类推,这样的形式来添加数据

Closer 发表于 2014-9-19 09:12:35

老實說還是不太懂你的需求 (你的圖片跑不出來)
只知道你大概是想要:

編號  資料  日期範圍
1   X   2014-10-01 15:13:35~2014-10-01 23:59:59
2   Y   2014-10-02 00:00:00~2014-10-02 23:59:59
3   Z   2014-10-03 00:00:00~2014-10-03 23:59:59

而具體的 XYZ 資料卻不知道是甚麼樣的型態與儲存方式
如果你只是要取某段時間範圍的資料
可以用 SQL 語法去規範搜尋
不用那麼麻煩,特地去合併它

页: [1]
查看完整版本: CI 中的日期分格