简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

这条语句为什么没有执行？解决思路

WBOY
Release： 2016-06-13 13:48:08
Original
955 people have browsed it

这条语句为什么没有执行？

PHP code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->$query=mysql_query("insert into yc_jiage(yc_jiage,add_date,yc_name,yc_id) values ($_price1,$_date1,'毛衣'`,null)");
Copy after login

插入语句，没有任何提示，但数据就是没有插入！
PHP code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->echo $_date1
Copy after login
倒是能正常显示，说明变量没有问题！

$_price1和 $_date1 都是POST接收来的变量！
表中 yc_id 字段，是自动增长的

------解决方案--------------------
mysql_query("insert into yc_jiage(yc_jiage,add_date,yc_name) values ($_price1,$_date1,'毛衣')");

试试看？
------解决方案--------------------
$query=mysql_query("insert into yc_jiage(yc_jiage,add_date,yc_name,yc_id) values ('$_price1','$_date1','毛衣'`,null)") or die(mysql_error()); 

这样试试。错了的话有提示。
------解决方案--------------------
$query=mysql_query("insert into yc_jiage(yc_jiage,add_date,yc_name,yc_id) values ('$_price1','$_date1','毛衣',null)");
Related labels：
date query quot
source：php.cn
Previous article： str_replace不执行解决方法 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
Can this where clause be optimized? Can anyone help me solve this problem? I have a question about the following feature; can ...
From 2024-04-01 16:12:46
0
1
295
There is a syntax error in the SQL query near line 1 "OVER (ORDER BY r.Id)) AS Grown FROM results AS r ORDER BY r.Id LIMIT 0.25" I have a SQL command that uses lag to list data from a table and calculate it against the ...
From 2024-04-01 10:36:24
0
1
251
How to display the value of a timestamp in standard time in four time zones using Intl.dateTimeFormat? I want to be able to display a timestamp in the time zone given by the user. I've noticed ...
From 2024-03-31 12:28:02
0
1
336
Uncaught Error: Invalid date: 21/01/2023 using DateTIme Picker in React I can't tell what the problem is here because I have implemented that react datetime picke...
From 2024-03-30 22:58:54
0
1
297
Get the maximum attribute of input type date I'm trying to limit my date input max attribute to be fluid so that it changes every year....
From 2024-03-30 18:32:44
0
1
260
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
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！