Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > php数据库存储的有关问题

php数据库存储的有关问题

WBOY
Release： 2016-06-13 12:51:54
Original
711 people have browsed it

php数据库存储的问题
本人小白，刚开始学。。。
$query="insert into movie (rating) values ('$num3')";
$result=mysql_query($query);

单独的打印出$num3得到的结果是9.2，但这样存到数据库里为什么就变成0了？字段rating是float类型的
还有$query="insert into movie (title) values ('$m[0][$i+5]')"; 单独的打印出$m[0][$i+5]是asdfg
但存入数据库就变成 Array[1+5] 这个了。 字段title是char类型的
是我的语句有问题吗

数据库 php insert query
------解决方案--------------------
<br />
$query="insert into movie (rating) values ('".$num3."')";<br />
$query="insert into movie (title) values ('".$m[0][$i+5]."')"; <br />
Copy after login

------解决方案--------------------
$query="insert into movie (rating) values ('$num3')";
这个不会有问题，可写作
$query="insert into movie (rating) values ($num3)";
看看

$query="insert into movie (title) values ('$m[0][$i+5]')";
应写作
$query="insert into movie (title) values ('{$m[0][$i+5]}')";
Related labels：
insert nbsp query
source：php.cn
Previous article： 途径/和./的区别 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
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1284
PX automatic conversion to REM error  <style>html {   font-size: calc(100vw / 3.75);      }...
From 2024-04-16 09:34:16
0
0
4687
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