• Product Information
  • About
  • News
  • Screenshots
  • Video tutorials
  • Changelog
• Support Information
  • Documentation
  • Resources
  • FAQ
  • Samples
  • Support
  • Upgrade policy
  • Feature matrix
• Download
• Purchase

Download Buy

DB2 PHP Generator online Help

ExecScalarSQL

Executes a query returning a single value.

Signature:

function ExecScalarSQL($sql)

Example:

$userId = $this->GetCurrentUserId();

$sql = "SELECT status FROM phpgen_users WHERE user_id = $userId";

$userStatus = $this->GetConnection()->ExecScalarSQL($sql);