reference/pdo/pdostatement/bindvalue.xml
9ee48af9ac7897f4d226edb57329d3174afb07b6
9ee48af9ac7897f4d226edb57329d3174afb07b6
...
...
@@ -1,4 +1,4 @@
1
-
<?xml version="1.0" encoding="UTF-8"?>
1
+
<?xml version="1.0" encoding="utf-8"?>
2
2
<!-- $Revision$ -->
3
3
<refentry xml:id="pdostatement.bindvalue" xmlns="http://docbook.org/ns/docbook">
4
4
<refnamediv>
...
...
@@ -9,11 +9,11 @@
9
9
</refnamediv>
10
10
<refsect1 role="description">
11
11
&reftitle.description;
12
-
<methodsynopsis>
13
-
<type>bool</type><methodname>PDOStatement::bindValue</methodname>
14
-
<methodparam><type>mixed</type><parameter>parameter</parameter></methodparam>
12
+
<methodsynopsis role="PDOStatement">
13
+
<modifier>public</modifier> <type>bool</type><methodname>PDOStatement::bindValue</methodname>
14
+
<methodparam><type class="union"><type>string</type><type>int</type></type><parameter>param</parameter></methodparam>
15
15
<methodparam><type>mixed</type><parameter>value</parameter></methodparam>
16
-
<methodparam choice="opt"><type>int</type><parameter>data_type</parameter><initializer>PDO::PARAM_STR</initializer></methodparam>
16
+
<methodparam choice="opt"><type>int</type><parameter>type</parameter><initializer>PDO::PARAM_STR</initializer></methodparam>
17
17
</methodsynopsis>
18
18
<para>
19
19
Binds a value to a corresponding named or question mark placeholder
...
...
@@ -26,7 +26,7 @@
26
26
<para>
27
27
<variablelist>
28
28
<varlistentry>
29
-
<term><parameter>parameter</parameter></term>
29
+
<term><parameter>param</parameter></term>
30
30
<listitem>
31
31
<para>
32
32
Parameter identifier. For a prepared statement using named
...
...
@@ -46,11 +46,11 @@
46
46
</listitem>
47
47
</varlistentry>
48
48
<varlistentry>
49
-
<term><parameter>data_type</parameter></term>
49
+
<term><parameter>type</parameter></term>
50
50
<listitem>
51
51
<para>
52
-
Explicit data type for the parameter using the PDO::PARAM_*
53
-
constants.
52
+
Explicit data type for the parameter using the <link linkend="pdo.constants"><literal>PDO::PARAM_*</literal>
53
+
constants</link>.
54
54
</para>
55
55
</listitem>
56
56
</varlistentry>
...
...
@@ -65,6 +65,11 @@
65
65
</para>
66
66
</refsect1>
67
67
68
+
<refsect1 role="errors">
69
+
&reftitle.errors;
70
+
&pdo.errors;
71
+
</refsect1>
72
+
68
73
<refsect1 role="examples">
69
74
&reftitle.examples;
70
75
<example><title>Execute a prepared statement with named placeholders</title>
...
...
@@ -77,7 +82,10 @@ $colour = 'red';
77
82
$sth = $dbh->prepare('SELECT name, colour, calories
78
83
FROM fruit
79
84
WHERE calories < :calories AND colour = :colour');
80
-
$sth->bindValue(':calories', $calories, PDO::PARAM_INT);
85
+
86
+
/* Sets a parameter value using its name */
87
+
$sth->bindValue('calories', $calories, PDO::PARAM_INT);
88
+
/* Optionally, parameter names can also be prefixed with colons ":" */
81
89
$sth->bindValue(':colour', $colour, PDO::PARAM_STR);
82
90
$sth->execute();
83
91
?>
...
...
@@ -110,15 +118,14 @@ $sth->execute();
110
118
&reftitle.seealso;
111
119
<para>
112
120
<simplelist>
113
-
<member><function>PDO::prepare</function></member>
114
-
<member><function>PDOStatement::execute</function></member>
115
-
<member><function>PDOStatement::bindParam</function></member>
121
+
<member><methodname>PDO::prepare</methodname></member>
122
+
<member><methodname>PDOStatement::execute</methodname></member>
123
+
<member><methodname>PDOStatement::bindParam</methodname></member>
116
124
</simplelist>
117
125
</para>
118
126
119
127
</refsect1>
120
128
</refentry>
121
-
122
129
<!-- Keep this comment at the end of the file
123
130
Local variables:
124
131
mode: sgml
125
132