Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > PDO插入数据的问题

PDO插入数据的问题

WBOY
Release： 2016-06-23 14:12:51
Original
1099 people have browsed it

本帖最后由 zhuzhaodan 于 2013-06-12 11:45:08 编辑 

	$dsn = 'mysql:host=localhost;dbname=test1';	$db = new PDO($dsn,'root','',array(PDO::MYSQL_ATTR_INIT_COMMAND => 'set names utf8'));	foreach($b as $k=>$v){		$db->exec('INSERT INTO siji (en,cn) VALUES ($v[0],$v[1])');
Copy after login

$b是一个2为数组里面有一些字符串信息
1.为什么VALUES ($v[0],$v[1])这样写插入不进去数据？把变量改为具体值就可以了，怎么修改呢
2.exec()函数里面的查询语句用单引号效率更高一些，因为不用解析变量，是不是啊
3.他没成功插入数据库，那么我用
try($db->exec) catch(PDOexception e){echo e.getMessage();}为什么什么错误信息也没有呢？

回复讨论(解决方案)

双引号啊
只用在双引号中，变量的之才能替换出来

双引号啊
只用在双引号中，变量的之才能替换出来
我用了双引号，还是插不进数据库啊，只有把VALUES ($v[0],$v[1])替换成具体的值，才能差劲数据库啊，为什么啊

"INSERT INTO siji (en,cn) VALUES ('$v[0]','$v[1]')"

Related labels：
PDO插入数据的问题
source：php.cn
Previous article：php正则匹配汉字结尾的字符串 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
The execution order of VueJS scheduling functions causes problems I'm trying to display a list of announcements (retrieved from API) on a page. I'm using a ...
From 2024-04-06 10:37:58
0
1
385
How to insert multiple rows in MySQL table and return new IDs? Normally I can insert a row in a MySQL table and get the last_insert_id. But now, I want t...
From 2024-04-06 10:03:44
0
2
294
How to know when a Vue component is fully initialized? So, in my Vue component, I have an async created method and several variables with async w...
From 2024-04-05 14:20:24
0
1
1442
Releasing the X-axis after calling Chart.zoom(): a step-by-step guide I set the scroll strategy to setScrollStrategy(AxisScrollStrategies.progressive) and on th...
From 2024-04-04 23:40:56
0
1
1339
Method to prevent two NOW() columns from being updated at the same time when updating NOW() of one column I have a table that requires two different current times. First, I have an insert procedur...
From 2024-04-04 21:34:34
0
1
312
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