PExecute¶
Execute an SQL statement using Prepared Statements.
Parameters¶
PExecute($sql, $varN)
$sql: | The MySQL query to perform on the database |
---|---|
$varN: | The variable(s) that will be placed instead of the ? placeholder separated by a ‘,’ or it can be the method Prepare. |
See also
Like the Execute Method, in most cases you probably only use this method when Inserting or Updating data for retrieving data you can use:
method | Description |
---|---|
PgetAll | Executes the SQL and returns the all the rows as a 2-dimensional array. |
PgetRow | Executes the SQL and returns the first row as an array. |
PgetCol | Executes the SQL and returns all elements of the first column as a 1-dimensional array. |
PgetOne | Executes the SQL and returns the first field of the first row. |
PgetASSOC | Executes the SQL and returns an associative array for the given query. If the number of columns returned is greater to two, a 2-dimensional array is returnedwith the first column of the recordset becomes the keys to the rest of the rows. If the columns is equal to two, a 1-dimensional array is created, where the the keys directly map to the values. |
Note
Notice that when using “Prepared statements” the methods are prefixed with a P.
Examples¶
1 2 3 4 5 6 7 8 9 10 11 12 | <?php
require_once 'dalmp.php';
$user = getenv('MYSQL_USER') ?: 'root';
$password = getenv('MYSQL_PASS') ?: '';
$DSN = "utf8://$user:$password@127.0.0.1/test";
$db = new DALMP\Database($DSN);
$db->PExecute('SET time_zone=?', 'UTC');
|
An Insert example:
1 2 3 | <?php
$db->PExecute('INSERT INTO mytable (colA, colB) VALUES(?, ?)', rand(), rand());
|
An Update example:
1 2 3 | <?php
$db->PExecute('UPDATE Country SET code=? WHERE Code=?', 'PRT', 'PRT');
|
Warning
When updating the return value 0, Zero indicates that no records where updated.
Thanks Navicat for supporting Open Source projects.
A great amount of time has been spent creating, crafting and maintaining this software, please consider donating.
Donating helps ensure continued support, development and availability.
comments powered by Disqus