<HTML ><HEAD ><TITLE >The syntax of SQL code</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP-Nuke: Management and Programming" HREF="book1.htm"><LINK REL="UP" TITLE="Programmer's tools " HREF="c2221.htm"><LINK REL="PREVIOUS" TITLE="Programmer's tools " HREF="c2221.htm"><LINK REL="NEXT" TITLE="PHPMyadmin, administering MySQL via web" HREF="x2692.htm"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP-Nuke: Management and Programming</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="c2221.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 11. Programmer's tools</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="x2692.htm" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="SQL-SYNTAX" ></A >The syntax of SQL code</H1 ><P >Aiming at making PHP-Nuke compatible with more databases, the SQL syntax<A NAME="AEN2646" ></A > has been transformed to functions, in order to achieve a standard syntax that is independent of the database used. For convenience, let us recall the file sql_layer.php in a somewhat cleaned-up version: </P ><PRE CLASS="SCREEN" >sql_connect($host, $user, $password, $db) <A NAME="LOGIN" ><IMG SRC="../images/callouts/1.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(1)"></A > sql_logout($id) <A NAME="DISCONNECT" ><IMG SRC="../images/callouts/2.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(2)"></A > sql_query($query, $id) <A NAME="QUERY" ><IMG SRC="../images/callouts/3.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(3)"></A > sql_num_rows($res) <A NAME="NUMROWS" ><IMG SRC="../images/callouts/4.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(4)"></A > sql_fetch_row(&$res, $nr) <A NAME="FETCHROWS" ><IMG SRC="../images/callouts/5.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(5)"></A > sql_fetch_array(&$res, $nr) <A NAME="FETCHARRAY" ><IMG SRC="../images/callouts/6.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(6)"></A > sql_fetch_object(&$res, $nr) <A NAME="FETCHOBJECT" ><IMG SRC="../images/callouts/7.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(7)"></A > sql_free_result($res) <A NAME="FREERESULT" ><IMG SRC="../images/callouts/8.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(8)"></A ></PRE ><DIV CLASS="CALLOUTLIST" ><DL COMPACT="COMPACT" ><DT ><A HREF="x2643.htm#LOGIN" ><IMG SRC="../images/callouts/1.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(1)"></A ></DT ><DD > Log into the DB. </DD ><DT ><A HREF="x2643.htm#DISCONNECT" ><IMG SRC="../images/callouts/2.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(2)"></A ></DT ><DD > Disconnect from the DB. </DD ><DT ><A HREF="x2643.htm#QUERY" ><IMG SRC="../images/callouts/3.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(3)"></A ></DT ><DD > Query. </DD ><DT ><A HREF="x2643.htm#NUMROWS" ><IMG SRC="../images/callouts/4.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(4)"></A ></DT ><DD > Number of Rows. </DD ><DT ><A HREF="x2643.htm#FETCHROWS" ><IMG SRC="../images/callouts/5.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(5)"></A ></DT ><DD > Fetch Rows. </DD ><DT ><A HREF="x2643.htm#FETCHARRAY" ><IMG SRC="../images/callouts/6.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(6)"></A ></DT ><DD > Fetch Array. </DD ><DT ><A HREF="x2643.htm#FETCHOBJECT" ><IMG SRC="../images/callouts/7.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(7)"></A ></DT ><DD > Fetch Object. </DD ><DT ><A HREF="x2643.htm#FREERESULT" ><IMG SRC="../images/callouts/8.gif" HSPACE="0" VSPACE="0" BORDER="0" ALT="(8)"></A ></DT ><DD > Free Result. </DD ></DL ></DIV ><P >With this syntax you will be able to render all the modifications, blocks or modules you create compatible to all the databases supported by PHP-Nuke, which are:</P ><P ></P ><UL ><LI ><P >MySQL</P ></LI ><LI ><P >mSQL</P ></LI ><LI ><P >PostgreSQL</P ></LI ><LI ><P >PostgreSQL_local</P ></LI ><LI ><P >ODBC</P ></LI ><LI ><P >ODBC_Adabas</P ></LI ><LI ><P >Interbase</P ></LI ><LI ><P >Sybase</P ></LI ></UL ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="c2221.htm" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="book1.htm" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="x2692.htm" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Programmer's tools</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="c2221.htm" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >PHPMyadmin, administering MySQL via web</TD ></TR ></TABLE ></DIV ></BODY ></HTML >