MySQL Get Records

Versions

Author: Softpress Support

This Action generates PHP code to query a database. This code will also be put into a container which can be included on another page using the ‘Include PHP Page’ Action.

Application

This Action is a standalone Action. It can be placed on a page using either the Action tool in the Tool Bar, or by using Insert>Actions>MySQL Get Records.

You can have as many as you wish on a page. You can have mark up before and after the SQL statement.

Use the Type Your Own button to enter a SQL statement.

The variable box is for you to specify a variable name into which the reference to this data set is placed. This block can be placed either on the page, or off it. Either way, the code will be published.

Code generated by this Action will be published on pages linking to the current page using the PHP Incude PHP Page Action.

Code Produced

<?PHP
// Created by MySQL Get Records ‘item1’
// ——
$myVariable = “”;
$fwQuery = “select * from database”;
$myVariable = mysql_db_query( $fwDBName , $fwQuery , $fwLink ) or die(“Database error in item1”.“Error #” . mysql_errno() . “: ” . mysql_error());
//PHP MarkUp
//——-
?>

0 Comments