Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Olivier Auverlot: "At my work (a universitary computer research laboratory), I'm alone to create all applications and databases. I don't know how I could do all the work without it. It's really a very productive software. I can focus on the database schemas and create quickly the user applications with a minimal amount of code to maintain".
Roger Brown: "Great product. The more I work with it, the more I am amazed at what it can do".

More

Add your opinion

PostgreSQL PHP Generator online Help

Prev Return to chapter overview Next

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);

 



Prev Return to chapter overview Next