<HTML ><HEAD ><TITLE >Test the System</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.63 "><LINK REL="HOME" TITLE="Sybase-PHP-Apache mini-HOWTO" HREF="index.html"><LINK REL="PREVIOUS" TITLE="Install Apache" HREF="instapache.html"><LINK REL="NEXT" TITLE="Post Install Tasks" HREF="postinst.html"></HEAD ><BODY CLASS="SECT1" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >Sybase-PHP-Apache mini-HOWTO</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="instapache.html" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="postinst.html" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECT1" ><H1 CLASS="SECT1" ><A NAME="TESTSYS" >7. Test the System</A ></H1 ><P >First, make sure Apache and Sybase are started:</P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="PROGRAMLISTING" > # /usr/local/apache/bin/apachectl start # /opt/sybase/install/rc.sybase start</PRE ></FONT ></TD ></TR ></TABLE ><P >Now go to the directory <TT CLASS="FILENAME" >/usr/local/apache/htdocs</TT >. Create a file called <TT CLASS="FILENAME" >test.php</TT > and insert the following contents:</P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="PROGRAMLISTING" > <?php $con = sybase_connect("SYBASE", "sa", ""); sybase_select_db("pubs2"); $qry = sybase_query("select * from titles", $con); echo sybase_result($qry, 1, 1); sybase_close($con); ?></PRE ></FONT ></TD ></TR ></TABLE ><P >Save the file and then access the following URL in your browser:</P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="PROGRAMLISTING" > http://localhost/test.php</PRE ></FONT ></TD ></TR ></TABLE ><P >If you see some text, then congratulations! You have a complete Linux/Apache/PHP/Sybase-ASE installation. If not...well, there you go. Make sure you actually have installed the pubs2 database. If you are not sure, try running:</P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><FONT COLOR="#000000" ><PRE CLASS="PROGRAMLISTING" > # isql -Usa -P < /opt/sybase/scripts/installpubs2</PRE ></FONT ></TD ></TR ></TABLE ><P ></P ><P ><A HREF="mailto:tyson.lloydthwaites@ite.com.au" TARGET="_top" >Email me</A > if you have any problems, corrections (please!) or additions, but please do not email me unless you have tried everything in this howto! Thanks.</P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="instapache.html" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="postinst.html" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Install Apache</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Post Install Tasks</TD ></TR ></TABLE ></DIV ></BODY ></HTML >