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

Subscribe to our news:
Partners
Testimonials
Johnson Sieu: "Your PHP Generator is the BEST that I have used so far. It is affordable and user-friendly. Congratulation for coming up with such a fine product. I will not hesitate to introduce it to my peers".
Marco De Luca: "I can handle now both version of SQLite Databases, 2.x and 3.x. Your SQLite PHP Generator is among the best tools I have seen".

More

Add your opinion

SQLite 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