Location: PHPKode > scripts > sqltoolkit > sqltoolkit/sample.php
<html>
<head>
<title>Sample Usage</title>
</head>
<body bgcolor="white">
<h1>Sample Usage of sql.php</h1>
<h2>A Quick Start</h2>
<p>1. Include the code in you page</p>
<pre>
	require("sql.php");
</pre>

<p>2a. Run a "quick" query which will handle all the open and closing of the database connections for you.</p>
<pre>
	$result = database_quick_query($datasource_mysql, "select * from test");
</pre>

<p>or</p>

<p>2b. Manage your own connections and run querys</p>
<pre>
	$connection = database_connect($datasource_pg);
	$result     = database_query($connection, "select * from test");
	database_close($connection);
</pre>

<p>3. Do something with the results</p>
<pre>
	database_result_dump($result);
</pre>

<p>That's it!</p>

<hr />

<p>If you have configured your datasource_config.php file already, you may actually see a result set below:</p>

<?php
require("sql.php");
$result = @database_quick_query($datasource_mysql, "select * from test");
@database_result_dump($result);
?>

</body>
</html>
Return current item: sqltoolkit