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.

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.

Navicat



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.

dalmp


comments powered by Disqus