From Zen Cart(tm) Wiki

Contents 1 Overview 1.1 tep_db_query and tep_db_fetch_array 1.2 tep_db_query and tep_db_fetch_array in if 1.3 tep_db_query and tep_db_fetch_array in while 1.4 Referencing query fields 1.5 tep_db_num_rows 1.6 tep_db_insert_id 1.7 Add global $db 1.8 Remaining tep_ functions 1.9 $osCsid 1.10 Registered globals 1.11 $HTTP_x_VARS

Overview

Many contributions for osCommerce have been ported to Zen Cart™. There are a few general rules for converting osCommerce code to Zen Cart™ v1.2.x or v1.3.x code.

tep_db_query and tep_db_fetch_array

Replace code like

$my_var_query = tep_db_query("query stuff");
$my_var = tep_db_fetch_array($my_var_query);

by

$my_var = $db->Execute("query stuff");

tep_db_query and tep_db_fetch_array in if

Replace code like

$my_var_query = tep_db_query("query stuff");
if ($my_var = tep_db_fetch_array($my_var_query))  {

by

$my_var = $db->Execute("query stuff");
if (!$my_var->EOF)  {

tep_db_query and tep_db_fetch_array in while

Replace code like

$my_var_query = tep_db_query("query stuff");
while ($my_var = tep_db_fetch_array($my_var_query)) {
do_stuff;
}

by

$my_var = $db->Execute("query stuff");
while (!$my_var->EOF) {
do_stuff;
$my_var->MoveNext();
}

Referencing query fields

In situations like the following:

$my_var_query = tep_db_query("query stuff");
$my_var = tep_db_fetch_array($my_var_query);
$i = $my_var['db_key'];

replace the line

$i = $my_var['db_key'];

by

$i = $my_var->fields['db_key'];

tep_db_num_rows

Replace code like

tep_db_num_rows($my_var)

by

$my_var->RecordCount()

tep_db_insert_id

Replace code like

tep_db_insert_id()

by

$db->Insert_ID()

Add global $db

Add global $db; to all functions that now reference $db as a result of these changes.

Remaining tep_ functions

Replace tep_ prefix in remaining functions with zen_.

$osCsid

Replace references to

$osCsid

by

zen_session_id()

Registered globals

Zen Cart™ does not use registered globals (there is no zen_session_is_registered, etc). Instead, Zen Cart uses the $_SESSION superglobal.

References to registered globals $var should be replaced by $_SESSION['var'].

$HTTP_x_VARS

Replace

$HTTP_x_VARS

by

$_x

For example: $HTTP_POST_VARS becomes $_POST.

Also, remove any global $HTTP_x_VARS; lines inside functions; the new versions are superglobals and do not need to be declared global.