PDO / SQL不插入数据：简单的例子

Question

Im using the following example from php.net:

<?php
// configuration

$dbuser = "userone";
$dbpass = "useronepass";

// database connection
$dbh = new PDO("mysql:host=localhost;dbname=testone",$dbuser,$dbpass);

$stmt = $dbh->prepare("INSERT INTO myTable (one, two) VALUES (:name, :value)");
$stmt->bindParam(':name', $name);
$stmt->bindParam(':value', $value);

// insert one row
$name = 'one';
$value = 'two';
$stmt->execute();

?>

I have verified all credentials and the same connection works in other files, but Im not getting any values inserted into the fields, whcih by the way are VARCHAR data types.

What am I missing?

Thanks!

Answer 1

$name and $value are not set before you bind the parameters

<?php
// configuration

$dbuser = "userone";
$dbpass = "useronepass";

// database connection
$dbh = new PDO("mysql:host=localhost;dbname=testone",$dbuser,$dbpass);

$stmt = $dbh->prepare("INSERT INTO myTable (one, two) VALUES (:name, :value)");

// add
$name = 'one';
$value = 'two';

$stmt->bindParam(':name', $name);
$stmt->bindParam(':value', $value);

/* remove
$name = 'one';
$value = 'two'; */
$stmt->execute();

?>