Returns the execution plan for a command.

Syntax

---

edb_execplan(<CommandHandle>)

<CommandHandle> =

Handle of command returned by edb_prepare function

Returns

---

Execution plan (STRING) if successful, or FALSE
if there are any errors

Usage

---

The edb_execplan function returns the execution plan for any SELECT, INSERT, UPDATE, or DELETE statement.

Examples

---

<?php

// The following script connects to an ElevateDB
// Server and database, prepares a parameterized
// SELECT statement, sets the parameter values,
// executes the statement, and then displays the
// execution plan

$con = edb_connect("type=remote;charset=Ansi;address=127.0.0.1;"+
                   "uid=Administrator;pwd=EDBDefault;database=Test");
if (!$con)
  {
  die("Could not connect: " . edb_errmsg());
  }

$cmd = edb_prepare($con,"SELECT * FROM customer WHERE State=:State");
edb_setparam($cmd,"State","FL");
$cursor = edb_execute($cmd,TRUE,TRUE);

echo "<pre>" . edb_execplan($cmd) . "</pre>";

edb_disconnect($con);
?>