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

Subscribe to our news:
Partners
Testimonials
Grey: "We're a two-person company, it's just me an my wife. I'm the technical guru, and she handles the business operations. I have to know a lot about MySQL, but that's much too technical for her. I have frequently had to setup CGI scripts (I code in Perl) so she can manage some of our tables (suppliers, manufacturers, etc).

I discovered PHP Generator a couple of days ago, tried the free version,and within a few hours I had purchased the Pro version (as well as SQL Maestro for MySQL).

Today I am completing the conversion of the last of my custom table managers to PHP Generator. This is eliminating several thousand lines of code that I don't have to support any more!

Thanks for this fantastic product".

Patrick Biegel: "Thanks a lot for your fast reply and the great solution! It works now and that's really important! The PHP Generator for MySQL is a great software".

More

Add your opinion

PHP Generator for MySQL online Help

Prev Return to chapter overview Next

createConnection

Creates a new connection to the database. Returns an instance of the EngConnection class.

 

Signature:

function createConnection()

 

Example

The code snippet below shows how to add a record to a log table when a user resets his password.

 

$connection = createConnection();

 

$sqlTemplate =

    "INSERT INTO user_log (username, action_type, action_time) " .

     "VALUES ('%s', '%s', '%s')";               

 

$sql = sprintf($sqlTemplate, $username, 'password_reset_complete', date('Y-m-d H:i:s'));

 

$connection->Connect();

$connection->ExecSQL($sql);



Prev Return to chapter overview Next