php-windows Digest 14 Mar 2011 06:41:09 -0000 Issue 3925
Topics (messages 30528 through 30531):
Re: Changing over to finishing the search engine
30528 by: Tommy Pham
Re: PHP_YAZ
30529 by: Richard Quadling
30530 by: Richard Quadling
30531 by: Pierre Joye
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
On Sat, Mar 12, 2011 at 2:07 PM, Bill Mudry <billmu...@rogers.com> wrote:
> For now, I thank those helping me with the strange absence of some UV photos
> when others
> were showing. The problem still exists, so I will get back to it again on
> another day when some
> matters of greater priority are taken care of.
>
> The highest priority of unfinished programming tasks for my TAXA site is
> finishing the search
> engine. There are 4 organizational levels for the wood data but probably 95%
> of any queries
> or interest in the site will be at the species level, the level that defines
> all woods and at which
> the public can relate. It is only those academically minded who would show
> interest in the
> higher botanical levels. Therefore the search engine I have been working on
> is being designed
> to work only on different columns of one table, the 'species' table. All
> relevant pages and
> query reports are dynamically formed.
>
> Once completed, it will totally make access to the huge amount of data far
> more user friendly
> and versatile and become a key cornerstone for the operation of the website.
>
> I am no ace at PHP, more like slow but determined. This has been the most
> challenging code
> I, personally, have had to work on. I started via a simple, one column, one
> table search
> template from www.designplace.org. Mid stream in my efforts, I designed a
> way to let users
> choose what type of search (what column, actually) they wish to use.
> Recently I was able to
> combine that function into the search form successfully.
>
> All search categories work successfully ---- but at present, only the first
> page of a query.
> Page control is accomplished through two PHP_SELF statements, one to advance
> to the next
> page (until the end of the report is finished) and the other to go back a
> page. At one point,
> I had the forward action working right to the last page of a query. Now
> neither the page advancement nor the page reversing now works past the first
> page being reported ---- and I am not sure what I messed up ;-( :-[ . After
> getting the first page showing, pressing either the previous or next button
> brings out the following preprogrammed statements of:
>
> Sorry, your search: "Pterocarpus" returned zero results (from a
> genus search)
> Couldn't execute query
>
> However, it does not put out a standard PHP error.
>
> If I can get these forward and reverse page actions to work, I expect that
> the job will be
> complete! In case this helps, the two PHP_SELF statements are on lines 478
> and 529.
> I will list the code for the whole page. There is copious internal
> documentation and many
> "debug" statements to help follow parameter values.
>
> Because of the uncommented debug statements, you can use the actual search
> page to
> follow values .... at:
> http://www.prowebcanada.com/taxa/commonname_search.php
>
> Much thanks for any help you can give,
>
> Bill Mudry
> Mississauga, Ontario Canada
>
>
Bill,
Before I dissect your code, you should follow the suggestions in the
php.ini file as per environment. If you're coding on a development
box which you should be doing any way, then set the below settings
accordingly to increase your coding speed and reduce debugging time.
1) What's the error_reporting set to?
2) What's the value of display_errors?
=====================================================================
>
> [CODE]
> <?php
> //session_start(); // start up your PHP session!
>
>
> //$record_counter= @$_GET[$record_counter];
> //$record_counter = $_SESSION['$record_counter']; // Not used now.
> ECHO "\$record_counter on line 7 is $record_counter<br />";
> $count = $record_counter+1;
>
> //$count = $_SESSION['$count'];
>
> ECHO "\$count at the top, line 12 is - $count<br />";
>
> //$_SESSION['$count'] = $count;
> ?>
>
>
> <HTML>
> <HEAD>
> <!---
> ############################################################################################
> This page contains the major search functions for The TAXA Wood Knowledge
> Base.
> The file is commonname_search.php.
> It is called from the main menu.
> Important parameters include:
> $searchtype - is the method users choose to do a search as the
> English words
> $searchfield - Each method translates into the actual field in the
> 'species' table
> used to complete the query
> $querystring - is the actual query string submitted by the user.
> $record_counter is the record counter for the last record of the present
> page. First appears in line 146
> $newquerystring - The new query string value fom the form by using
> $_GET[]
> $limit - The allowed number of records reported before starting a new
> page
> connecttotaxa.php - holds the values needed to connect to the taxa
> database
> $searchfield - The variable to indicate what field to search on.
> Right now there is only one,
> but coding has already been worked out for letting
> users choose from a list of
> columns. To be added in the next version
> $$numrows - The total number of rows in the present query result
> $count - is the lower record number in the next upcoming page (if one is
> needed)
> It will always be one more than $record_counter which holds
> the highest record number for the
> cuurent page.
> $currPage - Calculates the current page number.
> $Page - Like $currPage. I am not sure yet what the relationship
> between them is.
> $remainder - The query shows in blocks of $limit records. If the
> total number of records
> to report is divided by the block size ($limit) and there is
> a remainder, then
> a new page needs to be started to finish off the last records in
> the report.
> $news - Is the highest record number to use for the next page.
> (..... or this is what I interpreted so far).
>
> This search engine was adapted from the template search engine at
> http://www.designplace.org/scripts.php?page=1&c_id=25
> ############################################################################################
> --->
>
>
>
> <TITLE>TAXA: Multicolumn Search</TITLE>
> <META name="Template author" content="Steve R, http://www.designplace.org/";>
> <META name="Bill Mudry" Content="TAXA Wood Knowledge Base web designer and
> author">
> <STYLE type="text/css">
> body {
> background-color:'ivory'; color: 'navy'; font-family:
> verdana, arial, sans-serif; font-size: 12px;
> }
> .smalltext {font-size: 10px;}
> .mediumtext {font-size: 13px;}
> .largertext {font-size: 1.5em};
> .reportheader {font-size: 20px; font-weight:700;}
>
> td {font-size:0.8em; background-color: '#EFDFCF'}
>
> H1 {font-size:2em}; /* displayed at 24px */
> H2 {font-size:1.5em}; /* displayed at 18px */
> H3 {font-size:1.25em}; /* displayed at 15px */
> H4 {font-size:1em}; /* displayed at 12px */
>
> #formbox {float: left; border:3px dotted
> red;background-color:"skyblue";}
>
> </STYLE>
>
> </HEAD>
> <!-- © http://www.designplace.org/ (For the template used to start this
> design) -->
>
> <!--
> =========================================================================================
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX END OF HEADER
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
>
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX START OF BODY
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
> =========================================================================================
> -->
>
> <BODY>
>
> <?php
>
> //parse_str($_SERVER['QUERY_STRING'], $qs);
> //$record_counter =$qs['record_counter'];
>
> //$record_counter = 14; hard coded as a debug statement
>
> //ECHO "\$count on line 99 is - $count<BR />"; //debug statement
>
> ECHO "\$record_counter on line 95 is - $record_counter<BR />"; //debug
> statement
> ?>
>
> <H2 align="center">Multi Column Search</H2>
>
> <DIV id="formbox">
>
> <?php
> //querystring ="";
> //$querystring ="";
>
> $newsearch = 0 ; //Equals 1 only on a new search request
> //ECHO "<p align=left>\$newsearch on line 111 is $newsearch</p>";
> $submit="";
> //ECHO "\Ssubmit, before the form, on line 113 is - $submit<br />";
> If ($submit) {$record_counter = 0;}
> ?>
>
> <!--
> =========================================================================================
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX MAIN FORM STARTS HERE
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
> =========================================================================================
> -->
>
> <FORM name="form" action="commonname_search.php" method="get">
>
> <!-- ADD A TRANPARENT INSIDE TABLE TO ORGANIZE PLACEMENT OF ALL THE FORM
> ELEMENTS -->
> <TABLE align='center' border='0' bgcolor='ivory' cellpadding='6'>
> <TR>
> <TD align="center" colspan="5">
> <SPAN class="reportheader">Choose which search type you want
> first</SPAN>
> </TD>
> </TR>
> <TR>
> <TD class="mediumtext">
> <B>Common names</B>
> <Input type='radio' value='common names' name="searchtype" />
> </TD>
> <TD class="mediumtext">
> <B>Botanical names</B>
> <Input type='radio' value='botanical names' name="searchtype"
> />
> </TD>
> <TD class="mediumtext">
> <B>Genus</B>
> <Input type='radio' value='genus' name="searchtype" />
> </TD>
> <TD class="mediumtext">
> <B>Location</B>
> <Input type='radio' value='location' name="searchtype" />
> </TD>
> <TD class="mediumtext">
> <B>Description</B>
> <Input type='radio' value='description' name="searchtype" />
> </TD>
> </TR>
> <TR>
> <TD align="center" colspan="5" class="mediumtext">
> <B>Enter a Search String:</B>
>
> <INPUT type="text" size="40" name="querystring"
> />
> <INPUT type="hidden" name="newsearch" value="1">
> <INPUT type="submit" name="submit" value="Start
> Search" />
> </TD>
> </TR>
> </TABLE>
>
> </FORM>
> </DIV>
>
> <!--
> =========================================================================================
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX MAIN FORM STOPS HERE
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
> =========================================================================================
> -->
>
> <?php
>
> $submit = $_GET["submit"];
> ECHO "\$submit on line 179 is - $submit<br />";
>
> $newsearch = $_GET["newsearch"];
> //ECHO "\$newsearch just past the form on line 180 is - $newsearch<br />";
>
> IF ($newsearch=1) {$record_counter=0;};
> ECHO "\$record_counter on line 185 is - $record_counter<br />";
> /*
> ===========================================================================
> XXXXXXXXXXX GET THE SEARCH TYPE AND SEARCH STRING FROM THE FORM XXXXXXXXXXX
> ===========================================================================
> */
> $searchtype = $_GET['searchtype'] ;
> $searchtype = trim($searchtype); //trim whitespace from the stored
> variable
>
> //ECHO "On line 192, \$searchtype is - $searchtype<br />"; // Debug
> statement
>
> $querystring = @$_GET['querystring'] ;
> $querystring = trim($querystring); //trim whitespace from the stored
> variable
>
> //
> =====================================================================================
> // REASSURE USER OF THEIR CHOICES. (ALSO GOOD FOR DEBUGGING).
> If (!empty($searchtype))
> {
> ECHO "<h3 align='center'>searching under $searchtype
> for: "" . $querystring . ""</h3>";
> }
>
> //ECHO "Line 204 - \$searchtype is - $searchtype<br />";
> //debug statement
> /*
> ===============================================================================
> XXXXXXXXXXXXXXXXX TRANSLATION OF SEARCH TYPE TO COLUMN NAME
> XXXXXXXXXXXXXXXXX
> ===============================================================================
> */
>
> $searchfield = "";
> //ECHO "Line 196 - \$searchtype is - $searchtype<br />"; // Debug
> statement
>
> switch ($searchtype) {
> case "common names":
> $searchfield = trim("species_commonname");
> //ECHO "<br>common names - $searchfield<br>\n";
> break;
> case "botanical names":
> $searchfield = trim("species_name");
> //ECHO "<br>botanical names - $searchfield <br>\n";
> break;
> case "genus":
> $searchfield = trim("genus_name");
> //ECHO "<br>genus - $searchfield <br>\n";
> break;
> case "location":
> $searchfield = trim("location");
> //ECHO "<br>location - $searchfield <br>\n";
> break;
> case "description":
> $searchfield = trim("species_description");
> //ECHO "<br>description - $searchfield <br>\n";
> break;
> default: If (!isset($searchfield)) {
> ECHO "Please choose a search type first";
> }
> }
> /*
> ===============================================================================
> XXXXXXXXXXXXX END OF TRANSLATION OF SEARCH TYPE TO COLUMN NAME
> XXXXXXXXXXXXXX
> ===============================================================================
> */
>
>
> // Get the search variable from URL. Old designations were $var =
> @$_GET['q'] ;
>
> $newquerystring = @$_GET['querystring'] ;
> $querystring = trim($newquerystring); //trim whitespace from the stored
> variable
>
> $count = $record_counter +1;
> $newsearch = @$_GET['newsearch'] ;
> ECHO "\$newsearch on line 255 is $newsearch";
>
> if ($newsearch > 0) {$record_counter=0;};
>
>
> /*=====================================================================
> XXXXXXXXXXXXX SET THE NUMBER OF RECORDS PER PAGE HERE XXXXXXXXXXXXXX
>
> =====================================================================*/
> $limit='30';
>
> // check for an empty string and display a message.
> if ($querystring == "")
> {
> ECHO "<p align='center'>Please enter a search string...</p>";
> exit;
> }
>
> // check for a search parameter
> if (!isset($newquerystring))
> {
> ECHO "<p align='center'>We dont seem to have a search parameter!</p>";
> exit;
> }
>
> /*=========================================================================================
> XXXXXXXXXXXXXXXXXXXXXXXXXXX Connect to the TAXA Database
> XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
> =========================================================================================*/
>
> include ("connecttotaxa.php");
> $connection = mysql_connect($hostname, $username, $password)
> or die("Unable to connect to database server");
>
>
> //specify database ** EDIT REQUIRED HERE **
> mysql_select_db("taxa") or die("Unable to select the TAXA database");
> //select which database we're using
>
>
> /*=========================================================
> XXXXXXXXXXXXXXX BUILD THE SQL QUERY XXXXXXXXXXXXXXXXXXXX
> =========================================================*/
>
> // Build SQL Query
> $searchquery = "SELECT *
> FROM species
> WHERE $searchfield like \"%$querystring%\"
> order by '$searchfield'";
>
> $numresults=mysql_query($searchquery);
>
>
> @$numrows=mysql_num_rows($numresults);
>
> /*===============================================================================================
> XXXXXXXXXXXXXXX TEST FOR ZERO RESULTS AND PRINT A MESSAGE OF THAT IF TRUE
> XXXXXXXXXXXXXXXXXXXX
> ================================================================================================*/
> if ($numrows == 0)
> {
> ECHO "<h3 align='center'>Search Results</h3>";
> ECHO "<p align='center'>Sorry, your search: "" . $querystring. ""
> returned zero results</p>";
> }
>
> /*=========================================================
> // $record_counter is the record counter for the present record
> // next determine if s has been passed to script, if not use 0
> =========================================================*/
>
> if (empty($s)) {
> $record_counter=0;
> }
>
> /*===========================================================================
> XXXXXXXXXXXXXXX QUERY THE DATABASE TO GET THE RESULTS XXXXXXXXXXXXXXXXXXXX
> ===========================================================================*/
>
> // get results
> $searchquery .= " limit $record_counter,$limit";
> $result = mysql_query($searchquery) or die("Couldn't execute query");
>
> /*=========================================================================================
> XXXXXXXXXXXXXXX ECHO BACK TO THE USER WHAT THEY ASKED TO SEARCH FOR
> XXXXXXXXXXXXXXXXXXXX
> =========================================================================================*/
> ECHO "<p align='center'>You searched for: "" . $querystring .
> ""</p>";
>
> /////////////////////////////////////////////////////////////////
> // ********** REPORTING STARTS HERE ********** //
> /////////////////////////////////////////////////////////////////
>
> /*================================================================
> XXXXXXXXXXXXXXX SET A TITLE FOR THE REPORT XXXXXXXXXXXXXXXXXXXX
> ================================================================*/
> ECHO "<H3 align='center'>Search Results - $numrows references found.<br
> /><br /></H3>";
>
> // now you can display the results returned
>
> /*==========================================================================
> XXXXXXXXXXXXXXX SET UP COLUMN HEADERS FOR THE REPORT XXXXXXXXXXXXXXXXXXXX
> ==========================================================================*/
>
> ECHO "<table align='center' border=0 cellpadding=3 Cellspacing=0
> bgcolor='white'>";
> ECHO "<tr colspan=3>";
> ECHO "<td bgcolor='#EFDFCF' class=\"reportheader\">";
> //ECHO "<span>Common Name</span>";
> ECHO "Common Name";
> ECHO "</td>";
>
> ECHO "<td bgcolor='#EFDFCF' class=\"reportheader\">";
> ECHO "Botanical Name";
> ECHO "</td>";
>
> ECHO "<td bgcolor='#EFDFCF' class=\"reportheader\">";
> ECHO "Authorities";
> ECHO "</td>";
>
> ECHO "<td bgcolor='#EFDFCF' class=\"reportheader\">";
> ECHO "Genus Name";
> ECHO "</td>";
>
> ECHO "<td bgcolor='#EFDFCF' class=\"reportheader\">";
> ECHO "Location";ECHO "</td>";
>
> ECHO "<td bgcolor='#EFDFCF' class=\"reportheader\">";
> ECHO "Comments";
> ECHO "</td>";
>
> if (!isset($count)){$count=1;};
>
> ECHO "</tr>";
> ECHO "<tr>";
>
>
>
>
>
> /*========================================================
> XXXXXXXXX PRINT OUT RECORDS TILL END OF QUERY XXXXXXXXX
>
> ************** WHILE LOOP STARTS HERE ******************
> ========================================================*/
> while ($row= mysql_fetch_array($result)) {
> $commonname = $row["species_commonname"];
> $botname = $row["species_name"];
> $authorities = $row["authorities_species"];
>
> $genusname = $row["genus_name"];
> $location = $row["location"];
> $comments = $row["comments"];
>
> ECHO "<td valign='top' class=smalltext;>";
> //ECHO "\$count is $count<br />";
>
> ECHO "$count $commonname<br />" ;
> ECHO "</td>";
>
> ECHO "<td valign='top' class=smalltext;>";
> ECHO "<a href=\"displayspecies.php?&species_name=$botname \">";
> ECHO "$botname<br />";
> ECHO "</a><br>\n";
>
> ECHO "</td>";
> ECHO "<td valign='top' class=smalltext;>";
> ECHO "$authorities<br />";
> ECHO "</td>";
>
> ECHO "<td valign='top' class=smalltext;>";
> ECHO "$genusname<br />";
> ECHO "</td>";
>
> ECHO "<td valign='top' class=smalltext;>";
> ECHO "$location<br />";
> ECHO "</td>";
>
> ECHO "<td class=smalltext;>";
> ECHO "$comments<br />";
> ECHO "</td>";
>
> ECHO "</tr>";
> ECHO "<tr>";
>
> $count++ ;
> $record_counter++ ; // DOESN'T $record_counter HAVE TO BE INCREMEENTED FOR
> EACH ROW PRINTED ALSO??
> // ANOTHER COPY WORKED A FEW MONTHS AGO WITHOUT IT. iT IS NOT IN THE
> TEMPLATE.
> //ECHO "\$record_counter on line 412 is - $record_counter<BR />"; //debug
> statement
> }
>
>
> /*========================================================
> XXXXXXXXX END OF WHILE LOOP. XXXXXXXXX
> ========================================================*/
>
> ////////////////////////////////////////////////////////////
> // CLOSE THE REPORT TABLE
> ////////////////////////////////////////////////////////////
> ECHO "</tr>";
> ECHO "</table>";
> ECHO "<BR />";
> ECHO "\$record_counter on line 436 at the end of the report loop is -
> $record_counter<br />";
>
>
>
> // Calculate the current page
> $currPage = (($record_counter/$limit) + 1);
> $pages = $currPage; //
> ECHO "\$currPage on line 451 is - $currPage<br />"; //debug statement
> ECHO "\$record_counter on line 452 is - $record_counter<BR />"; //debug
> statement
>
> //break before paging
> ECHO "<br />";
>
> // next we need to do the links to other results
>
> //////////////////////////////////////////////////////////////////////
> // If $record_counter is less than 1, there are no more records to view
> backwards.
> //////////////////////////////////////////////////////////////////////
>
> // bypass PREV link if s is 0 since there must be at least one more record
> to display to use a new page.
> if ($record_counter>=1) {
> ECHO "\$record_counter at line 453 is - $record_counter<br /> "; //debug
> statement
> $prevs=($record_counter-$limit);
> ECHO "\$prevs at line 455 is - $prevs<br /> "; //debug statement
>
> //////////////////////////////////////////////////////////////////////////////////////////////
> // ****** This statement will run the prior page of the report. It is
> user chosen******
> //
> //////////////////////////////////////////////////////////////////////////////////////////////
> print " <a
> href=\"$PHP_SELF?record_counter=$prevs&querystring=$querystring&searchfield=$searchfield\">
I don't see $PHP_SELF declared prior to usage. Having the proper
development settings in php.ini will show you this error. Here I
think you meant $_SERVER['PHP_SELF']. See
http://php.net/reserved.variables.
It's recommended to use $_SERVER['SCRIPT_NAME'] over $_SERVER['PHP_SELF'].
> <p align='left' class='largertext'><b><< Previous $limit
> records</b></p></a>  "; // Page 357
>
> } //END OF PRESENT IF STATEMENT
>
> // calculate number of pages needing links
> $pages=intval($numrows/$limit);
>
> //ECHO "\$pages on line 469 is - $pages<br />"; //debug statement
> //ECHO "\$numrows on line 470 is - $numrows<br />"; //debug statement
> //ECHO "\$limit on line 471 is - $limit<br />"; //debug statement
>
> // $pages now contains int of pages needed unless there is a remainder from
> division
>
> if ($numrows%$limit) {
> // has remainder so add one page
> $pages++;
> }
> //ECHO "\$pages on line 479 is - $pages<br />"; //debug statement
>
> $remainder = ($numrows%$limit);
> //ECHO "\$remainder on line 353 is - $remainder<br />"; //debug statement
>
> ECHO "<br />";
>
> //$x = ($record_counter+$limit)/$limit
> //ECHO "\$x on line 478 is - $x<br />"; //debug statement
> ECHO "\$record_counter on line 479 is - $record_counter<br />";
> //debug statement
>
> //ECHO "\$limit on line 490 is - $limit<br />"; //debug statement
> //ECHO "\$pages on line 491 is - $pages<br />"; //debug statement
>
> // check to see if last page
> if (!((($record_counter+$limit)/$limit)==$pages) && $pages!=1) {
>
> ECHO "<br />";
>
> // not last page so give NEXT link
> $news=$record_counter+$limit;
> ECHO "\$record_counter on line 517 is - $record_counter<br />";
> //debug statement
> //ECHO "\$limit on line 492 is - $limit<br />"; //debug statement
> //ECHO "\$news on line 493 is - $news<br />"; //debug statement
> //ECHO "<div align='right' style='color:'#FF0000'>";
>
> ////////////////////////////////////////////////////////////
> // This statement will run the next page of the report.
> // It is user chosen
> ////////////////////////////////////////////////////////////
>
> //echo " <a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 >></a>";
>
Again, see the above.
> ECHO " <a
> href=\"$PHP_SELF?record_counter=$news&querystring=$newquerystring&searchfield=$searchfield\">
> <p class='largertext' aligm='right'><B>Next $limit records
> >></b></p></a>";
>
> ECHO "</div>";
> }
> ECHO "\$record_counter on line 534 is - $record_counter<BR />";
> //debug statement
>
> $record_counter = $news;
>
> ECHO "\$record_counter on line 538 is - $record_counter<BR />";
> //debug statement
>
> //$_SESSION['$record_counter'] = $record_counter;
> //$_SESSION['$count'] = $count;
>
> ?>
>
> <!-- © http://www.designplace.org/ -->
>
> </BODY>
> </HTML>
>
>
> [/CODE]
>
>
One more thing, consider using pastebin.com for code posting. Doing
in the emails is very bad for legibility (due to line wrapping) and no
line numbers when you reference line number in describing your
problem, especially on a long post like yours.
Regards,
Tommy
--- End Message ---
--- Begin Message ---
On 11 March 2011 19:12, Cindy Harper <char...@colgate.edu> wrote:
> AFAIK, There are 2 pieces of code - the YAZ module itself, found at
> http://www.indexdata.com/yaz, and PHP_YAZ, the interface between YAZ and PHP
> at http://pecl.php.net/package/yaz. So from your message, I take it the
> php_yaz you used came from pecl/yaz/trunk - is this the same as the 2nd link
> above?
>
> I don't know much about compiling PECL modules, and after I've compiled,
> when I test, I get a Fatal error: Call to undefined function yaz_connect()
> in C:\Inetpub\wwwroot\aftergoogle2\aftergoogle.php on line 28
>
> But maybe that's because I'm using IIS.
>
> Cindy Harper, Systems Librarian
> Colgate University Libraries
> char...@colgate.edu
> 315-228-7363
>
>
>
> On Fri, Mar 11, 2011 at 4:43 AM, Richard Quadling <rquadl...@gmail.com>
> wrote:
>>
>> On 9 March 2011 14:49, Cindy Harper <char...@colgate.edu> wrote:
>> > Is anyone successfully using php_yaz with either
>> > 1) WAMP - I have a test Windows server that I manage
>> > or
>> > 2) a Linux shared hosted LAMP where they won't load the YAZ PECL module
>> > for
>> > you, but they will allow you to put your lib files in your home
>> > directory
>> > via SSH.
>> >
>> > I'm running into brick walls every way I turn.
>> >
>> > Cindy Harper, Systems Librarian
>> > Colgate University Libraries
>> > char...@colgate.edu
>> > 315-228-7363
>> >
>>
>> I've just built Yaz using the V4.1.2 of the library and the
>> pecl/yaz/trunk code on Windows (VC9, x86, nts).
>>
>> 2 of the 5 tests fail.
>>
>> ccl1.diff is ...
>>
>> 001+ the art: RPN="the art"
>> 001- the art: RPN=the\ art
>> 003+ ti=the art: RPN=@attr 1=4 "the art"
>> 003- ti=the art: RPN=@attr 1=4 the\ art
>>
>> and connect2.diff is ...
>>
>> 001+ connect failed errno=10007
>> 001- connect failed errno=10000
>>
>>
>> I've no idea on actual usage of Yaz, but I'm willing to help if I can.
>>
>> Richard.
>>
>> --
>> Richard Quadling
>> Twitter : EE : Zend
>> @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY
>
>
I've pulled the trunk rather than a specific release, simply because I
play with pecl trunk, but I've compiled the extension and ran the
tests (as I've mentioned).
To be getting the error you are getting, I can think of 3 things you
are missing ...
1 - You've not told PHP to load the php_yaz.dll extension. Check you
php.ini file for extension=php_yaz.dll
2 - You've not put the compiled php_yaz.dll extension into your
extension folder. For me this is C:\PHP5\ext - check your php.ini file
for extension_dir.
3 - You are missing the necessary yaz libraries required by the
extension. These need to be either in the path.
If you load PHP from the command line by using ...
php -m
what do you get?
Try ...
php -ddisplay_startup_errors=1 -m
--
Richard Quadling
Twitter : EE : Zend
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY
--- End Message ---
--- Begin Message ---
On 13 March 2011 09:36, Richard Quadling <rquadl...@gmail.com> wrote:
>> I don't know much about compiling PECL modules, and after I've compiled,
>> when I test, I get a Fatal error: Call to undefined function yaz_connect()
>> in C:\Inetpub\wwwroot\aftergoogle2\aftergoogle.php on line 28
To compile a PHP extension on Windows, you need MS Visual C++ 2008
(aka VC9). I use the Express Edition (which is free).
You can see the relevant notes at http://wiki.php.net/internals/windows
--
Richard Quadling
Twitter : EE : Zend
@RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY
--- End Message ---
--- Begin Message ---
hi,
You can fetch the Windows Platform SDK 6.1, which includes VC9 too.
Cheers,
On Sun, Mar 13, 2011 at 10:39 AM, Richard Quadling <rquadl...@gmail.com> wrote:
> On 13 March 2011 09:36, Richard Quadling <rquadl...@gmail.com> wrote:
>>> I don't know much about compiling PECL modules, and after I've compiled,
>>> when I test, I get a Fatal error: Call to undefined function yaz_connect()
>>> in C:\Inetpub\wwwroot\aftergoogle2\aftergoogle.php on line 28
>
> To compile a PHP extension on Windows, you need MS Visual C++ 2008
> (aka VC9). I use the Express Edition (which is free).
>
> You can see the relevant notes at http://wiki.php.net/internals/windows
>
> --
> Richard Quadling
> Twitter : EE : Zend
> @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Pierre
@pierrejoye | http://blog.thepimp.net | http://www.libgd.org
--- End Message ---
