Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

求解：数据插入不到数据库中。解决方案

WBOY
Release： 2016-06-13 13:37:59
Original
1292 people have browsed it

求解：数据插入不到数据库中。
数据库确定已经连接成功了。表名keai_user 字段f_logintimes（登录次数） f_lasttime（最近登录时间） f_loginip（登录IP地址）
$ip = $_SERVER['REMOTE_ADDR'];
$sql = "UPDATE keai_user SET f_logintimes = f_logintimes + 1,";
$sql .= "f_lasttime = now(),f_loginip = '$ip'";
$sql = "WHERE f_username = '$username'";
$db->query($sql);执行后表keai_user 内容没有任何变化，不知道为什么？

------解决方案--------------------

引用$db->query($sql);执行后表keai_user 内容没有任何变化，不知道为什么？

------解决方案--------------------
$sql = "WHERE f_username = '$username'"; 
 
写错了吧！
$sql .= "WHERE f_username = '$username'";
Related labels：
quot sql user
source：php.cn
Previous article： php和mysql5.5的整合解决思路 Next article： 怎样在数组中插入一个值,该怎么处理
Statement of this Website
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...
From 2024-04-16 09:34:16
0
0
4687
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
How to trigger render (with filter and pagination) on sort method in React? Here is my Sort.js style component: <SortWrapper><SortText>SortBy</SortText...
From 2024-04-06 21:28:37
0
1
2257
Dynamically modify inline CSS styles in Javafx I'm trying to change the background image of a pane when the application is maximized. My ...
From 2024-04-06 20:57:16
0
1
487
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template