本文介绍了PHP PDO插入方法的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在研究一种PHP类方法,以便使用PDO将表单值插入mysql数据库.下面概述了这个想法,但是我无法弄清楚如何传入方法的第四个参数.有人可以解释如何做到这一点吗?
I'm working on a PHP class method to insert form values into mysql database with PDO. The idea is outlined below but I cannot figure out how to pass in the fourth parameter of the method. Could someone explain how to do this?
谢谢!
<?php
class Contact {
private $DbHost = DB_HOST;
private $DbName = DB_NAME;
private $DbUser = DB_USER;
private $DbPass = DB_PASS;
public function MySqlDbInsert($DbTableName, $DbColNames, $DbValues, $DbBindParams){
try{
$dbh = new PDO("mysql:host=$this->DbHost;dbname=$this->DbName",$this->DbUser,$this->DbPass, array(PDO::ATTR_PERSISTENT => true));
$dbh->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$dbh->exec("SET CHARACTER SET utf8");
$sth = $dbh->prepare("INSERT INTO $DbTableName($DbColNames) VALUES ($DbValues)");
// i know this is all wrong ----------------
foreach($DbBindParams as $paramValue){
$sth->bindParam($paramValue);
}
// ----------------------------------------
$sth->execute();
}
catch(PDOException $e){
$this->ResponseMessage(true, 'Database access FAILED!');
}
}
$object = new Contact();
$object->MySqlDbInsert(
'DbTableName',
'DbColName1, DbColName3, DbColName3',
':DbColValue1, :DbColValue2, :DbColValue3',
// this part is all wrong -------------------
array(
':DbColValue1', $col1, PDO::PARAM_STR,
':DbColValue2', $col2, PDO::PARAM_STR,
':DbColValue2', $col3, PDO::PARAM_STR
)
// ------------------------------------------
);
推荐答案
用于PDO中的动态插入,我使用以下功能.
for dynamic insert in PDO i use below function.
使用此传递的值以数组格式起作用:
for use this passed values in array format to function :
<?php
class Contact
{
private $UploadedFiles = '';
private $DbHost = DB_HOST;
private $DbName = DB_NAME;
private $DbUser = DB_USER;
private $DbPass = DB_PASS;
private $table;
function __construct()
{
$this->table = strtolower(get_class());
}
public function insert($values = array())
{
$dbh = new PDO("mysql:host=$this->DbHost;dbname=$this->DbName", $this->DbUser, $this->DbPass, array(PDO::ATTR_PERSISTENT => true));
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$dbh->exec("SET CHARACTER SET utf8");
foreach ($values as $field => $v)
$ins[] = ':' . $field;
$ins = implode(',', $ins);
$fields = implode(',', array_keys($values));
$sql = "INSERT INTO $this->table ($fields) VALUES ($ins)";
$sth = $dbh->prepare($sql);
foreach ($values as $f => $v)
{
$sth->bindValue(':' . $f, $v);
}
$sth->execute();
//return $this->lastId = $dbh->lastInsertId();
}
}
并使用它:
$contact = new Contact();
$values = array('col1'=>'value1','col2'=>'value2');
$contact->insert($values);
这篇关于PHP PDO插入方法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!