PHP Class 'Database Queries' released

Grok Headline matches for PHP Class 'Database Queries' released

PHP Class 'PHP or Java Class Code
Generator' released

PHP Class 'PHP or Java Class Code
Generator' released 03/06/2004 02:00 AM
This package is meant is automate the generation of classes to access databases in Java beans style. It uses the Fast Template engine to process template files that define the skeleton of functions and variables of classes that store and retrieve data object property values from a given database table, getter and setter functions to access those properties and a function to delete a data object row from the respective database table. The package comes with templates to generate classes either in PHP or Java. The PHP template defines code to access data objects in a MySQL database. The Java template defines code to access data objects in any database supported by JDBC.

PHP Class 'Convert Class To HTML Table'
released

PHP Class 'Convert Class To HTML Table'
released 02/10/2004 02:46 AM
This class is meant to display the structure of any class as an HTML table. The class being displayed can have variables that contain objects of other classes or arrays and treats those variables each accordingly.

PHP Class 'calend.class.php' released

PHP Class 'calend.class.php' released 01/03/2003 07:52 PM
This class generates HTML calendars in the portuguese language. In portuguese: Esta classe gera um calendário em português em HTML.

PHP Class 'Bs_CsvUtil.class.php'
released

PHP Class 'Bs_CsvUtil.class.php'
released 11/08/2002 08:17 PM
Features: supports any separator char sequence, default is semicolon ";". supports separator characters in the values. eg you use a ; as separator, your line may look like blah;hello world;"foo";"foo;bar";"this is a ""string""";got it?;foo as you can see, the values can be in "quotes". if your text uses quotes itself as in the "string" example, they are escaped in ms-style with 2 quotes. and by using quotes we can even have your separator inside the text (example "foo;bar"). line breaks. a csv line may spread over multiple lines using crlf in a field value. see the checkMultiline param and the _checkMultiline() method.

PHP Class 'Bs_StopWatch.class.php'
released

PHP Class 'Bs_StopWatch.class.php'
released 11/07/2002 07:59 PM
You can take times during a code run and at the end get a time table as HTML or text table. The output will contain total and as delta between each take in microseconds. Free Code; This Class is part of the BlueShoes PHP Application Framework, see blueshoes.org.

PHP Class 'My DB' released

PHP Class 'My DB' released 02/15/2004 07:40 PM
This class is a simple wrapper around MySQL database acess functions. It provides wrapper functions around most of the PHP MySQL extension function like database, connection, queries execution and result data access, error message retrieval, database creation and locking of tables.

PHP Class 'My Db' released

PHP Class 'My Db' released 06/09/2004 06:55 PM
This package is a SQL database wrapper supporting MySQL, Interbase and MS SQL server. It can establish database server connections, execute SQL queries, retrieve query results into arrays and display query results as HTML tables.

PHP Class 'rhc' released

PHP Class 'rhc' released 10/15/2002 07:15 AM
RHC is actually a few files which give the user the ability to do custom error handling, debugging, and handle database abstraction (currently only through Informix).

PHP Class 'CISVC' released

PHP Class 'CISVC' released 01/16/2004 11:05 AM
This class is meant to encapsulate the APIs around the COM object for Microsoft Indexing service (CISVC). The class can perform the search query, output the search results split in multiple pages and also a navigation let the user go back and forth between the presented search results pages.

PHP Class 'URLHelper' released

PHP Class 'URLHelper' released 10/15/2002 07:15 AM
This class give you access to the http header information and provides some help for retrieving and parsing urls. FUNCTIONS: function isURLAvailable($url) function isValidURLFormat($url, $strict=false) function addHTTPtoURL($url) function getHTTPStatusCode($url) function getRealURL ($url, $simple = true, $method = "HEAD") function getHTTPHeader($url) function getMD5FromURL($url, $estFilesize=500000) function _openHTTPConnection($url, $method = "HEAD")

PHP Class 'DBgrid' released

PHP Class 'DBgrid' released 10/10/2002 09:55 AM
Show the result of a mysql query on HTML table. Easy to use. 1 line code. $grid = new DBgrid($result);

PHP Class 'BaseDB' released

PHP Class 'BaseDB' released 10/11/2002 07:54 AM
Excellent oo base class for mysql interaction. worth looking at. you must use this as a base class and extend your classes which map to a table name. your tables must have a 'id', 'created' and 'modified' field to work properly and the class takes care of the rest. check it out.

PHP Class 'htmldoc' released

PHP Class 'htmldoc' released 10/11/2002 07:54 AM
Object Library for Creation of PDF Documents out of HTML Pages by using htmldoc as conversion facility.

PHP Class 'WebWidgets' released

PHP Class 'WebWidgets' released 10/11/2002 07:54 PM
WebWidgets is a library of classes to produce any HTML(XML) documents, create, validate forms. It allow to create any "complicated" forms easy. Any tag is an object. Your can build tags tree by inserting one tag into another and get its content as HTML. Based upon "Composite" OOP patern. Library is very flexible, so your may derive your own classes. Documentation in html format can be downloaded from here: http://scancode.ru/dev/WebWidgets/webwidgets.08.doc.tar.gz (it is not fine:( )

PHP Class 'BarcodeI25' released

PHP Class 'BarcodeI25' released 10/15/2002 07:15 AM
HTML Barcode generator for Interleaved 2 of 5 Codes. Código de barras fator Intercalado 2 de 5, padrão FEBRABAN (BRASIL).

PHP Class 'bstCountdown' released

PHP Class 'bstCountdown' released 10/15/2002 07:15 AM
Display a list of 'days until' a set of events, includes a simple example and a more complex one as child classes. Could easily be extended to multi-user and notifications via email by adding a user table and owner columns. Written to MySQL but db access is simple enough to adapt.

PHP Class 'color' released

PHP Class 'color' released 10/15/2002 07:15 AM
These class converts colortypes. It supports the following colors formats and types: - CMYK - RGB - Pantone - HEX Codes for HTML

PHP Class 'DCalendar' released

PHP Class 'DCalendar' released 10/08/2002 07:09 AM
Show a calendar with options view year, month and today link. Dynamic events with diferent color

PHP Class 'MkDir' released

PHP Class 'MkDir' released 05/16/2004 07:21 PM
This is a simple class for creating directories in the local file system or in a remote server file system using a FTP connection.

PHP Class 'SQLCall' released

PHP Class 'SQLCall' released 09/26/2002 07:29 PM
SQLCall uses PHP's highly dynamic nature to give the calling class unprecedented access to the result set in an intuitive way. It currently only supports connections to mySQL databases. This class is perfect for those who like their results at hand - no hashes or lists to have to walk through.

PHP Class 'Spreadsheet_WriteExcel'
released

PHP Class 'Spreadsheet_WriteExcel'
released 09/26/2002 07:29 PM
Class for generating Excel files, based on John McNamara's Spreadsheet::WriteExcel from CPAN. It supports all the basic values for cells. It doesn't support URLs, images (working on it) and charts. It has very basic support for formulas.

PHP Class 'morse' released

PHP Class 'morse' released 09/28/2002 07:48 PM
Short class for encoding or decoding morse signs input: this is my 1st morse output: - .... .. ... .. ... -- -.-- .---- ... - -- --- .-. ... .

PHP Class 'burnauth' released

PHP Class 'burnauth' released 09/29/2002 08:10 PM
Burning Auth is a script to handle user authenticated access to php scripts. The goal is quite simple: protect from unauthorized access those pages who need to be kept under admin control, such as data/content administration and/or members only areas on a website. Security is achieved through a database authentication and mantained with a Session variable set to the authenticated user's name. Every page can be protected including the file 'shield.php'; at the beginning of it.

PHP Class 'mixer' released

PHP Class 'mixer' released 10/01/2002 09:17 AM
color mixer for vga (16 colors) - the class create a form for change backgroundcolor

PHP Class 'Pagination' released

PHP Class 'Pagination' released 01/10/2004 07:54 PM
This package is a set of classes is meant to generate navigation bars to display database query result sets split in multiple pages. The packake is based on the factory design pattern that is used to create objects of specific classes to provide the result set pagination support with different databases.

PHP Class 'numeroaletra' released

PHP Class 'numeroaletra' released 10/01/2002 10:18 AM
Extensión de la clase number2words de Bas Jobsen (bas@startpunt.cc) con la traducción de numeros a letras en español y de numeros a euros

PHP Class 'phplibTemplateExtention'
released

PHP Class 'phplibTemplateExtention'
released 10/08/2002 07:09 AM
phplib has template.inc - a template class for php to utilize templates. This is an extension to the class Template needing less code by: Automatic detection and declaration of blocks Automatic "blanking" of unused blocks Blocks automatically declaired in proper nested order. All calls to set up template/file/paths/names in the class call. - LGPL / GPL - phplibs license anyway - its their template class - I just extended it to make my life a little easier.

PHP Class 'COutLook' released

PHP Class 'COutLook' released 10/01/2002 10:18 AM
This class reads messages from the Inbox and Oubox of an Outlook local profile through CDO (Colaboration Data Objects). The class only works under Windows.

PHP Class 'ms_dbx_reader' released

PHP Class 'ms_dbx_reader' released 10/01/2002 07:38 PM
Microsoft DBX file reader /such as Outlook Express Mailbox database files/ Author: Zeos

PHP Class 'db_view' released

PHP Class 'db_view' released 10/08/2002 07:08 AM
"db_view" provides: * An abstraction class and helpers for multi-tabled Mysql data. (init, select, select_row, count, insert, update, delete) * Atomic multi-table updates, inserts, deletes eg: update items, month set items.price=month.price where items.id=month.id; Also primitive non-atomic (=insecure) rollbacks. * Functions, Triggers and Defaults per action (select, update, insert, delete; before or after) * Rich logging and debugging facilities.

PHP Class 'cellroll_lib' released

PHP Class 'cellroll_lib' released 10/15/2002 08:29 PM
Very simple class for faster building of table-rollovers (changing bgcolor for rows or cells) js-scripts

PHP Class 'MyTemplate' released

PHP Class 'MyTemplate' released 10/15/2002 08:29 PM
MyTemplate is very powerful template engine. It allows including a nested template file directly into another template file and automaticaly parse it in any template in set. Working with dinamic blocks is so easy. Only assign block variables and get result. You do not need to parse each block 'manualy'. Automaticaly parses PHP constant and global variables into templates. Supports multiply template directories. You'll like it :) Your code will become shorter :)

PHP Class 'DcSessionManager ' released

PHP Class 'DcSessionManager ' released 05/14/2004 07:21 PM
This class is meant to manage sessions storing the information about their state in a MySQL database table. It generates an hash with 64 characters that is used to identify each session and may be passed between pages using cookies or request variables. This class has security in mind, providing means to prevents session hijack by using 2 hashes (double crypted) in only one "session". You can store more than 5kbytes of data in each session. The class provides other features, like: - Explicitly creating and destroing session - Register and deleting a session value - Check if a session key value is assigned

PHP Class 'page_handle' released

PHP Class 'page_handle' released 10/28/2002 08:29 PM
A template engine geared to be able to display data without much hassle in PHP code, just fetching of data and giving it to the template engine. Create HTML templates with the data's keywords

PHP Class 'mimetype' released

PHP Class 'mimetype' released 10/28/2002 08:29 PM
This class enables PHP scripts to determine the mime type of a file based on file extension, useful for PHP versions without access to other utilities that determine mime type. Built from the Apache mime type file.

PHP Class 'CSQLite' released

PHP Class 'CSQLite' released 05/14/2004 07:21 PM
This class is a wrapper to access SQLite file databases using SQLite extension for PHP 5. The functions are similar to those used to access MySQL databases: open, query, fetch_row and get_num_rows.

PHP Class 'phpsecureweb' released

PHP Class 'phpsecureweb' released 10/29/2002 07:48 PM
Protect your sites or intranet with the power of PHP Secure Web. It is database independent as what adODB supports. You required to have a database of your liking. Simply install the tables, sign on as an Admin, create users and groups, assign users and actions to the groups, and you are almost done. Now write 4-5 lines of code for the pages you want to protect (you can copy it from the examples) and you are done. You will love the powerful and advanced Administration features.

PHP Class 'innodb' released

PHP Class 'innodb' released 01/04/2003 07:10 PM
Class to store and retrieve information stored in MySQL innodb tables. In portuguese: Classe para banco de dados mysql com algumas funes especificas para tabelas innodb.

PHP Class 'Kxparse' released

PHP Class 'Kxparse' released 11/01/2002 07:49 PM
A XML parser, that's extremly fast and easy to use, tested in two websites and gave good results!
Grok Description matches for PHP Class 'Database Queries' released
GrokA matches for PHP Class 'Database Queries' released

Pear Versus ADOdb

Pear Versus ADOdb 11/25/2002 09:58 AM
Comparing Pear and ADOdb is one of those PHP things that we're all curious about. I haven't used it but I'd also look at Metabase (sorry for no link) since someone I respect technically really likes it. [ Go ]

Comparing PEAR DB to ADOdb

Comparing PEAR DB to ADOdb 11/17/2002 10:47 PM

PEAR DB is the default database abstraction library for PEAR. ADOdb is a high end database abstraction library modelled on Microsoft's ADO that is also very popular.

1. Feature Comparison
Where we try to put you to sleep by showing you the similarities between PEAR DB and ADOdb 2. Features Missing from PEAR DB
Now we try to wake you up with some teasers 3. Criticisms of ADOdb
Read what other people are moaning and complaining about

"zeldman.57"

Using The Extended Stored Procedure
Xp_MsVer To Display Server Information.

Using The Extended Stored Procedure
Xp_MsVer To Display Server Information. 07/17/2004 09:43 AM

SQL Server Script Templates to create a
Table, View and stored Procedure.

SQL Server Script Templates to create a
Table, View and stored Procedure. 05/29/2004 10:59 AM

Remote Procedure Calls with
PEAR::XML-RPC

Remote Procedure Calls with
PEAR::XML-RPC 02/10/2004 02:48 AM
In this tutorial, learn how to utilize the XML-RPC package from the PEAR repository. You will learn how to write the client and server portions.

SMS Installer Walkthrough: Rollback
Support

SMS Installer Walkthrough: Rollback
Support 05/18/2004 04:41 AM

PEAR Manual - PHP Extension and
Application Repository

PEAR Manual - PHP Extension and
Application Repository 06/05/2005 11:43 PM


PEAR Manual - PHP Extension and Application Repository
http://pear.php.net/manual/en/

PEAR is short for "PHP Extension and Application Repository" and is pronounced just like the fruit. The purpose of PEAR is to provide: 1) A structured library of open-sourced code for PHP users, 2) A system for code distribution and package maintenance, 3) A standard style for code written in PHP, specified here, 4) The PHP Foundation Classes (PFC), 5) The PHP Extension Community Library (PECL), and 6) A web site, mailing lists and download mirrors to support the PHP/PEAR community. PEAR is a community-driven project with the PEAR Group as the governing body. The project has been founded by Stig S. Bakken in 1999 and quite a lot of people have joined the project since then. This has been added to World Wide Web Reference Subject Tracerâ„¢ Information Blog.

A Reusable Windows Socket Server Class
With C++

A Reusable Windows Socket Server Class
With C++ 07/02/2002 08:02 PM
Ever thought of writing your own Windows socket server class? In this article Len shows you exactly how to do just that, including details of what a socket server should do and example C++ code. 5 Free Bonuses!!! "Attention All Web Developers" Now includes 5 FREE eBooks to help you promote your SiteWorks Professional website! "This is one of the best pieces of software that we have ever used. It's quick, streamlined, and allowed us to have a fully working site packed with articles in just 3 hours" Ever wanted to run your own content driven web site? Well now you can with SiteWorks Professional: the fast, flexible and secure web site + admin suite. Try it for free!Click here.     Get notified when we post new content:   New Forum Threads 1. Article Discussion: Interacting With C From Java With JNI: Part 1/2 2. Exchanger Server Config... 3. Problem installing MDAC on Windows 2000 4. PHP/MySQL Search Tutorial 5. passing array as post variable? 6. php form validation 7. Banner Exchange Program in Asp? 8. Hyper Link in wysiwyg html editor 9. Blob Probs ... 10. Simple x basic help/question... More Forum Threads... Other Recent Articles Simple PHP Templates With PatTemplate // by Havard Lindset - 26th Jun 2002

SQL Server Stored Procedures for SQL
Server Security

SQL Server Stored Procedures for SQL
Server Security 01/05/2004 05:02 AM

Customers Gain Reliability of Mainframes
on Fujitsu's Next-Generation High-End
Server for Windows Server 2003,
'Longhorn' Server

Customers Gain Reliability of Mainframes
on Fujitsu's Next-Generation High-End
Server for Windows Server 2003,
'Longhorn' Server 06/28/2004 10:07 AM
In a press conference held here today, Fujitsu Limited Chairman Naoyuki Akikusa and Microsoft Corp. CEO Steve Ballmer announced a significant expansion of the companies' long-standing global enterprise relationship. The companies entered into a Memorandum of Understanding (MOU) with respect to their companies' commitment to collaborate in the development of Fujitsu's next-generation Intel(R) Itanium(R) Processor Family-based server for Windows Server(TM) 2003 and next-generation Windows Server (code-named "Longhorn" Server), as well as in platform integration, services and mission-critical customer support.

ADODB 4.52

ADODB 4.52 08/17/2004 09:14 AM
A PHP database abstraction layer.

ADOdb and PDO

ADOdb and PDO 06/14/2004 10:38 PM
PDO is a new database API that will be part of the official PHP 5.1 release. AFAIK, PDO will not be a full-fledged database abstraction library, but will provide a standard database API for PHP.

Here is a sample taken from the PDO download:

<?php
   $x = new PDO("odbc:ram", 'php', 'php',
array(PDO_ATTR_AUTOCOMMIT => 0));
   $stmt = $x->prepare("select NAME, VALUE from test where value
like ?");
   $the_name = 'bar%';
   $stmt->execute(array($the_name)) or die("failed to
execute!");
   $stmt->bindColumn('VALUE', $value);

   while ($row = $stmt->fetch()) {
   	echo "name=$row[NAME] value=$row[VALUE]n";
   	echo "value is $valuen";
   	echo "n";
   }

    echo "Let's try an updaten"
   $stmt = $x->prepare("INSERT INTO test (NAME, VALUE) VALUES
(:name, :value)");

    $stmt->bindParam(":name", $the_name, PDO_PARAM_STR,
32);
   $stmt->bindParam(":value", $the_value, PDO_PARAM_STR,
32);

    for ($i = 0; $i < 4; $i++) {
   	$the_name = "foo" . rand();
   	$the_value = "bar" . rand();

	if (!$stmt->execute()) {
   		break;
   	}
   }

    echo "All donen";

?>

Highlights of PDO include the unified object-oriented API, compiled statements are now first class objects (the PDOStatement class), and better support for bind variables, which will give a substantial speed boost for performance freaks.

Does this make ADOdb superflous? If you are looking for something that just works with mysql, then ADOdb might not be for you. However ADOdb still has a big role to play, because:

(1) ADOdb makes it easier to develop PHP apps that work with multiple databases, with portable handling of data types and schemas.

(2) PDO does not provide an infrastructure for enterprise database access, such as recordset caching, sql logging and tuning, and session management.

(3) If you come from a Windows background (like me), it is easy to learn ADOdb because it follows many M'soft conventions.

So the next question is, how to extend ADOdb to support PDO? I think we can retain the existing ADOdb infrastructure, treating PDO as just another ADOdb driver. At the same time, we will add PDO specific extensions to the ADOdb PDO driver.

So the classic ADOdb calling conventions will still work:

	
        include('adodb.inc.php');
	$DB = NewADOConnection('pdo');
	$DB->Connect($host, $user, $pwd, $db);
	$rs = $DB->Execute("select * from table where name=?",array('Jill'));
	while (!$rs->EOF) {
		var_dump($rs->fields);
		$rs->MoveNext();
	}

And we will add a new ADOdb statement class to support PDO conventions:

        include('adodb.inc.php');
	$DB = NewADOConnection('pdo');
	$DB->Connect($pdo_connection_string);
	$stmt = $DB->PrepareStmt("select * from
table where name=?");
	$stmt->Execute(array('Jill'));
	while ($arr = $stmt->Fetch()) {
		var_dump($arr);
	}

Wez has more PDO examples. A PDO discussion at sitepoint.

WOWs server emulation

WOWs server emulation 08/21/2004 10:09 PM
..:: Human knoledge belongs to the world ::..

ADODB 0.70 Released

ADODB 0.70 Released 06/11/2004 11:17 AM
ADODB is a database wrapper library for PHP4 modelled on Microsoft's ADO. You are all urged to upgrade because of a bug in MoveNext(), which did not handle EOF properly.

--Calls by reference have been removed (call_time_pass_reference=Off) to ensure compatibility with future versions of PHP, except in Oracle 7 driver due to a bug in php_oracle.dll.

--PostgreSQL database driver contributed by Alberto Cerezal (acerezalp@dbnet.es).

--Oci8 driver for Oracle 8 contributed by George Fourlanos (fou@infomap.gr).

--Added mysqlt database driver to support MySQL 3.23 which has transaction support.

--Oracle default date format (DD-MON-YY) did not match ADODB default date format (which is YYYY-MM-DD). Use ALTER SESSION to force the default date.

--Error message checking is now included in test suite.

-- MoveNext() did not check EOF properly -- fixed.

ADOdb for Python

ADOdb for Python 01/26/2004 10:15 AM
In my work with Python, I found that there's no good database abstraction library, so I wrote my own. Looks familiar, doesn't it?

PHP	Python
include "adodb.inc.php"; $conn = NewADOConnection('mysql'); $conn->Connect('server','user','pwd','db'); $rs = $conn->Execute('select * from tab); while (!$rs->EOF) { print_r($rs->fields); $rs->MoveNext(); } $rs->Close(); $conn->Close();	import adodb_mysql; conn = adodb_mysql.adodb_mysql() conn.Connect('server','user','pwd','db') cursor = conn.Execute('select * from tab) while not cursor.EOF: print cursor.fields cursor.MoveNext() cursor.Close() conn.Close()

It also supports the iterator protocol:

  cursor = conn.Execute('select * from table')
  for row in cursor:
       print row

Python does have the DB API, but it's similar to ODBC in that it provides a very minimal layer, without abstracting SELECT ... LIMIT, LOBs, string quoting, etc. Download zip.

I will try to post a comparison between developing in Python and PHP when I have more time.

adodb-xmlschema

adodb-xmlschema 02/12/2004 10:14 PM
adodb-xmlschema (axmls) Release 1.0!

ADOdb 2.20 released

ADOdb 2.20 released 07/09/2002 09:09 AM
ADOdb is a PHP library for writing portable database code. It supports many databases, including oracle, mysql, mssql, postgresql, access, informix, sybase, db2, interbase, firebird, frontbase, foxpro, etc.

• Busy working on making the code more consistent and modular. Added new caching functions: CacheGetOne($secs2cache,$sql), CacheGetRow($secs2cache,$sql), CacheGetAll($secs2cache,$sql).
• Added a new function useful for scheduling appointments portably. $conn->OffsetDate($dayFraction,$date=false) to generate sql that calcs date offsets.
• Improved portability when handling joins. Added connection properties: leftOuter, rightOuter that hold left and right outer join operators, and ansiOuter to indicate whether ansi outer joins supported.
• New driver mssqlpo, the portable mssql driver, which converts the string concat operator from || to +. This allows you to write portable sql using || that is automatically converted to + when you switch databases to mssql.
• Fixes PageExecute() bug when sql has GROUP BY, and msaccess SelectLimit() bug.

"zeldman.57"

ADOdb 2.10 Released

ADOdb 2.10 Released 06/05/2002 07:50 AM
ADOdb 2.10 has just been released. This is a database abstraction library for PHP that supports many databases, including Oracle, MySQL, PostgreSQL, Informix, Sybase, Microsoft SQL Server, Access, FoxPro, DB2, ODBC etc.

It now provides an easy-to-use pager class. The following code

include_once('../adodb.inc.php');
include_once('../adodb-pager.inc.php');
session_start();

$db = &NewADOConnection('mysql');
$db->Connect('localhost','root','','xphplens');
$sql = "select * from adoxyz ";

$pager = new ADODB_Pager($db,$sql);
$pager->Render($rows_per_page=5);

will produce:

|<   <<   >>   >|

ID First Name Last Name Date Created 36  Alan  Turing  Sat 06, Oct 2001  37  Serena  Williams  Sat 06, Oct 2001  38  Yat Sun  Sun  Sat 06, Oct 2001  39  Wai Hun  See  Sat 06, Oct 2001  40  Steven  Oey  Sat 06, Oct 2001

"tri" This is 100% customizable with source code provided. Enjoy! "zeldman.57"

adodb-xmlschema 0.0.2.4

adodb-xmlschema 0.0.2.4 11/17/2003 08:54 PM
An XML database creation extension for ADODB.

Copying SQL Stored Procedures To Another
SQL Server

Copying SQL Stored Procedures To Another
SQL Server 05/24/2004 06:45 PM

Stored Procedures on PHP and Microsoft
SQL Server

Stored Procedures on PHP and Microsoft
SQL Server 12/02/2003 12:44 AM
Though it's not as common as PHP and MySQL, PHP and Microsoft SQL Server can make a powerful team -- especially when you use stored procedures to improve the performance of your queries. David shows how it's done!

PHP App Development With ADODB (part 2)

PHP App Development With ADODB (part 2) 08/05/2002 10:44 PM
In the first part of this article, I introduced you to the ADODB database abstraction library, and showed you a little of how it works. I demonstrated how using it in your PHP application development could substantially reduce the time spent on code rewrites if your RDBMS decided to change shape, and also gave you a crash course in the basic functions built into the library.

Fortunately, that isn't all she wrote. ADODB comes with a whole bunch of bells and whistles, which allow you to do some fairly nifty new things in your PHP scripts. Over the next few pages, I'll be showing you some of them - so flip the page, and let's get started! -- icarus

PS: : ADOdb 2.30 released on August 1st. Features generation of SQL for pivot-tables/cross-tabulations. Thanks to Daniel Lucazeau for the original idea. Also a mssql "select distinct" bug fix when the SelectLimit() function is used.

"zeldman.pinme"

Pseudo PostreSQL ADODB

Pseudo PostreSQL ADODB 11/08/2002 07:17 PM
Pseudo PostgreSQL ADODB is a PHP class designed as a drop-in replacement for ADOdb for PHP applications that do not need the full power of ADOdb, want to remain light and fast but want to remain compatible with ADOdb. The API of PostgreSQL ADODB Emulation was designed to be compatible with ADOdb. I was able to remove ADOdb from my application framework and use this class instead.

SQL Server forum stories - SQL 2000 MSDE
SP install procedure

SQL Server forum stories - SQL 2000 MSDE
SP install procedure 06/25/2004 04:59 PM

MySQL Stored Procedure Simulation

MySQL Stored Procedure Simulation 04/04/2005 01:43 PM
Lead developer figure out how to check files in!

Get a handle on errors in SQL Server
stored procedures

Get a handle on errors in SQL Server
stored procedures 07/21/2002 10:36 PM
CNET Jul 21 2002 10:12PM ET

ADOdb: Making MySQL Efficient

ADOdb: Making MySQL Efficient 10/29/2003 12:11 AM
Learn how to use Active Data Objects Data Base (ADOdb) to make your websites utilize MySQL more efficiently.

PHP Application Development With ADODB
(part 1)

PHP Application Development With ADODB
(part 1) 08/07/2002 12:28 PM
PHP comes with a different API for different database types - whcih usually means a code rewrite every time your database administrator decides to experiment with something new. But fear not - help is at hand, in the unlikely form of ADODB, a powerful database abstraction library for PHP applications.

Portability is a Good Thing (ADODB)

Portability is a Good Thing (ADODB) 07/25/2002 07:36 AM

PHP Application Development With ADODB
(part 2)

PHP Application Development With ADODB
(part 2) 08/13/2002 01:06 PM
In this concluding article, find out about ADODB's advanced functions, with examples that demonstrate how ADODB can be used to optimize multiple-run queries, commit and roll back transactions, improve performance by caching query results, and automatically write HTML (or text) files.

PHP Class 'Database Queries' released

The following phrases have been identified by the grok system as matching this entry: error establishing socket. ms-sql high transactions using pear php with postgresql "sql server" sequences identity rollback emulation changing servoy repository to ms sql server rollback peoplesoft db2 commit wrapper pagination sql92 adodbphpremotemicrosoft acessmdb adodb versus ezsql sybase stored procedure php class php compare adodb pear db db dbx