ASP(VBScript), from time to time, has some neat features. One is a function called GetString, which pertains to the Recordset object. Its purpose is to pull the entire recordset into a formatted string and close the connection to free resources. This type of functionality can be quite useful in a high load environment. So I thought I would duplicate the functionality with PHP. So here it is...
By : bastien
<?
require("conn.php"); //require connection data
$delimiter_string = "</td>\n\t\t<td>"; //the \n\t\t pattern is added to be able to format the source clearly
$sql = "select * from kids";
$result = conn($sql); //custom connection function - so don't phreak out
$data = GetString($result, $delimiter_string); //call the function
echo "<table>$data</table>"; //print out the results
function GetString($handle,$delimiter)
{
/*
This function emulates the ASP GetStrings function. It creates an
array of the dataset where the the array is a string with a certain delimiter
ie if you were to pass a delimiter of "|" your data would be
element1 | element2 | element3
for a pipe-delimited string to pass around
delimiter of "</td><td>" would get you
element1 </td><td> element2 </td><td> element3
to make it really easy to create a table dump of your data
(Note: I added \n\t\t in the pattern to be able to see the output neatly formatted when I view the source code for it)
*/
if (mysql_num_rows($handle)>0){
//initialize the array
$RsString = ''; //array();
//loop thru the recordset
while ($rows = mysql_fetch_array($handle,MYSQL_ASSOC))
{
//add some additional tags to open and close the table rows with some formattting
$RsString .= "\n\t<tr>\n\t\t<td>".implode($delimiter,$rows)."</td>\n\t</tr>\n";
} //wend
return $RsString;
}else{
//no records in recordset so return false
return false;
} //end if
//close the connection
mysql_close($handle);
} //end function
?>
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
More Database Code Articles
More By Codewalkers
 developerWorks - FREE Tools!
|
With IBM Rational Systems Development Solution, you can deliver products faster with higher quality. Within this kit, Read the “Model Driven Systems Development” white paper to see how to improve product quality and communication. Then check out the rest of the e-Kit to learn more about important topics that can affect the success of any software project through customer examples, tutorials, informative Webcasts, and best practices for designing, building and managing systems. From start to finish, at every stage in your projects, Rational Systems Development Solution can help your company reach its full potential.
FREE! Go There Now!
|
|
|
|
Hear how IBM Rational Project and Portfolio Management integrated solutions help teams put the right tools and processes in place to maximize the effectiveness and efficiency of project teams and ensure that the business vision is being executed correctly. Learn how to automate and integrate requirements prioritization, top-down project planning, communications and controls, and methodology deployment to keep your scope, costs, and schedules under control. Tackle with an end-to-end approach the management of scope and scope changes, usage of methodology to control and empower project teams, and optimization of resources to align activity costs with the overall project plan.
FREE! Go There Now!
|
|
|
|
Visit IBM developerWorks to download a free trial version of IBM Rational Business Developer V7.1. Rational Business Developer offers rapid and simplified development of business applications and services through Enterprise Generation Language (EGL) tools, generating Java or mainframe solutions while shielding developers from technical complexities.
FREE! Go There Now!
|
|
|
|
Visit IBM developerWorks to download a free trial version of Lotus Quickr 8.0, which enables collaboration by transforming the way everyday business content such as documents, rich media, photos, and video can be shared. Lotus Quickr makes it faster and easier to share content of all types (not just documents) within virtual teams. It is designed to make it easier to collaborate across organizational boundaries, while continuing to work within the context of familiar desktop applications.
FREE! Go There Now!
|
|
|
|
This tutorial shows new users of IBM WebSphere Business Monitor Version 6.0.2 how to perform the "Hello World" equivalent for monitoring business process applications. It is intended to help you get familiar with the capabilities of the product.
FREE! Go There Now!
|
|
|
|
As organizations integrate software into every aspect of business, they are constantly pressured to deliver faster, better, and cheaper results. Unfortunately, a “dis-integrated” software delivery approach reduces returns while increasing costs. This IBM Rational White Paper shows how Integrated Requirements Management aligns organizations around maximizing value and keeping pace with change.
FREE! Go There Now!
|
|
|
|
Learn to enable users to both rate existing animations and to combine existing animations into new snippets. This is the third in a series of three tutorials that chronicle the building of a site that enables collaborative discussion and animation building using Domino and OpenLaszlo.
FREE! Go There Now!
|
|
|
|
In this webcast, you'll get an introduction to the eXtreme Transaction Processing (XTP) features of WebSphere Extended Deployment and the common architectural traits required by XTP applications. See how WebSphere Extended Deployment's ObjectGrid feature provides a state-of-the-art infrastructure for hosting XTP applications.
FREE! Go There Now!
|
|
|
|
Download a free trial version of IBM Rational Software Analyzer Developer Edition V7.0 to identify bug defects earlier in the software development cycle. Rational Software Analyzer is an extensible software development solution that reduces the expense of bug-fixes by enabling static analysis code reviews and bug identification very early in the development cycle.
FREE! Go There Now!
|
|
|
|
In this tutorial, you can learn how to install and configure the IBM Rational Asset Manager Eclipse client, explore the different views in the Asset Management perspective, learn various search techniques, work with existing assets, and submit a new asset.
FREE! Go There Now!
|
|
|
|
All FREE IBM® developerWorks Tools!
|
