MYSQL数据库有关问题：其某个表的某个字段自动填值 -PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

MYSQL数据库有关问题：其某个表的某个字段自动填值

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 13, 2016 pm 01:22 PM

inmysqlphpsqltime

MYSQL数据库问题：其某个表的某个字段自动填值
一个表：testtable

其中有N个字段，有个字段名是：in_time

我想当我的PHP程序向这个table插入数据时，该字段：in_time 能自动填入插入数据的时间。

疑问：
1，有没有可能直接让MYSQL自己完成，不用程序控制，这样对服务器负载可能会小些；

2，in_time赋值的时间，可以是客户机时间吗？如果不行，是插入数据时的当前北京时间也行。

谢谢！

------解决方案--------------------
1，有没有可能直接让MYSQL自己完成，不用程序控制，这样对服务器负载可能会小些；
mysql一样要查询系统时间才能确定要插入的值，PHP当然也一样。
用mysql的自带函数来插入或者PHP的函数来生成SQL语句，都是差不多的。
2，in_time赋值的时间，可以是客户机时间吗？如果不行，是插入数据时的当前北京时间也行。
客户机的时间你能知道吗？不能吧。至于说取哪个时区的时间随你选
------解决方案--------------------
竟然都是插入就没有比较计较这点差异了.要么就是让增加php的负担,要么就是增加数据库的负担.一样的.

客户端时间你如果能取到传递到php再传递到mysql 是可以如果不行就不行.
------解决方案--------------------
嗯...你概念很混沌.凡是用php输出的都是服务器端的数据...
你要取得客户端的时间可以用js. 但是你得按照我上面说的将时间传递给php 再传递给mysql.

探讨

引用:

1，有没有可能直接让MYSQL自己完成，不用程序控制，这样对服务器负载可能会小些；
mysql一样要查询系统时间才能确定要插入的值，PHP当然也一样。
用mysql的自带函数来插入或者PHP的函数来生成SQL语句，都是差不多的。
2，in_time赋值的时间，可以是客户机时间吗？如果不行，是插入数据时的当前北京时间也行。
客户机的时间你能知道吗？不能吧。至……

------解决方案--------------------
如果你对一个表进行新增：可对表的in_time字段的类型为：timestamp每次新增，会自动填充当前时间。

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

How can you prevent session fixation attacks?Apr 28, 2025 am 12:25 AM

Effective methods to prevent session fixed attacks include: 1. Regenerate the session ID after the user logs in; 2. Use a secure session ID generation algorithm; 3. Implement the session timeout mechanism; 4. Encrypt session data using HTTPS. These measures can ensure that the application is indestructible when facing session fixed attacks.

How do you implement sessionless authentication?Apr 28, 2025 am 12:24 AM

Implementing session-free authentication can be achieved by using JSONWebTokens (JWT), a token-based authentication system where all necessary information is stored in the token without server-side session storage. 1) Use JWT to generate and verify tokens, 2) Ensure that HTTPS is used to prevent tokens from being intercepted, 3) Securely store tokens on the client side, 4) Verify tokens on the server side to prevent tampering, 5) Implement token revocation mechanisms, such as using short-term access tokens and long-term refresh tokens.

What are some common security risks associated with PHP sessions?Apr 28, 2025 am 12:24 AM

The security risks of PHP sessions mainly include session hijacking, session fixation, session prediction and session poisoning. 1. Session hijacking can be prevented by using HTTPS and protecting cookies. 2. Session fixation can be avoided by regenerating the session ID before the user logs in. 3. Session prediction needs to ensure the randomness and unpredictability of session IDs. 4. Session poisoning can be prevented by verifying and filtering session data.

How do you destroy a PHP session?Apr 28, 2025 am 12:16 AM

To destroy a PHP session, you need to start the session first, then clear the data and destroy the session file. 1. Use session_start() to start the session. 2. Use session_unset() to clear the session data. 3. Finally, use session_destroy() to destroy the session file to ensure data security and resource release.

How can you change the default session save path in PHP?Apr 28, 2025 am 12:12 AM

How to change the default session saving path of PHP? It can be achieved through the following steps: use session_save_path('/var/www/sessions');session_start(); in PHP scripts to set the session saving path. Set session.save_path="/var/www/sessions" in the php.ini file to change the session saving path globally. Use Memcached or Redis to store session data, such as ini_set('session.save_handler','memcached'); ini_set(

How do you modify data stored in a PHP session?Apr 27, 2025 am 12:23 AM

TomodifydatainaPHPsession,startthesessionwithsession_start(),thenuse$_SESSIONtoset,modify,orremovevariables.1)Startthesession.2)Setormodifysessionvariablesusing$_SESSION.3)Removevariableswithunset().4)Clearallvariableswithsession_unset().5)Destroythe

Give an example of storing an array in a PHP session.Apr 27, 2025 am 12:20 AM

Arrays can be stored in PHP sessions. 1. Start the session and use session_start(). 2. Create an array and store it in $_SESSION. 3. Retrieve the array through $_SESSION. 4. Optimize session data to improve performance.

How does garbage collection work for PHP sessions?Apr 27, 2025 am 12:19 AM

PHP session garbage collection is triggered through a probability mechanism to clean up expired session data. 1) Set the trigger probability and session life cycle in the configuration file; 2) You can use cron tasks to optimize high-load applications; 3) You need to balance the garbage collection frequency and performance to avoid data loss.

See all articles