Re: [Bulk] Fwd: Re: [PHP-WIN] Error: Not a proper resource --- with code this time!

Bill Mudry <[email protected]>
Newsgroups gmane.comp.php.windows
Message-ID <[email protected]> 

At 08:06 PM 1/16/2011, Bill Mudry wrote:

>>X-Apparently-To: [email protected] via 206.190.37.191; Sun, 16 
>>Jan 2011 12:58:19 -0800
>>X-YMailISG: 6IyfGVwcZAolrREihPxcaZJx7VkI8KmrvpK2cIzILvqDHzS9
>>  bpXFKEo3ttD4ShKY2q6wz7M0VD_W49UPhTUK9PtkwCIAoL8yYDmvz3WvA_QY
>>  uOtcL.0r0GVnnPY._MM44NpRinL61N39mZSyA0vyshF8Ml3jRYONWZ2x1_Qv
>>  e_y5M9wTeC8HMX0_JN0OU1MWHlOVEe7HfGH3jX283jLJjIaJpnF4K8w_6pEv
>>  5VPFpnUApcMoJlVkd92cdxkleEaNM.iFDRcc_Xn._Lc0i5god7QPHyu6uaZv
>>  PPrUFvh9i5FrxBJa8lrcyulkQU8XQwGsVfwwhdhJkzoqooItclhZGWQQSGqL
>>  9jyKDoN17p00geBpvPunM_NQlChoVEUg0CRIKRPaLPQr8fN3jQriXY33fkub
>>  KXJmPnWX6kaQS.22Bmopjz6XbsUZkfKUjXv4iqe3a0q8UnVlGo.ugacfUMKL
>>  TtzBHultKdb5aqhYMjE4JLncD708D41jhKkuixqgxqDyXaUFyJzQlNR4UUvt
>>  0ITdpjB2Ll1iKtsj1JT6lEv8ExFp._pCu8ayDSOlh8UsUElM6nK9xE.QDalN
>>  CS6IRWAsQW2JyARyw1UuvhXMFU_FAdd6.NWLUnIxsmF7POVqsw--
>>X-Originating-IP: [76.75.200.58]
>>Authentication-Results: 
>>mta1001.rog.mail.sp1.yahoo.com  from=yahoo.de; domainkeys=neutral 
>>(no sig);  from=yahoo.de; dkim=permerror (bad sig)
>>X-Host-Fingerprint: 76.75.200.58 pb1.pair.com
>>Mailing-List: contact [email protected]; run by ezmlm
>>list-help: < mailto:[email protected]>
>>list-unsubscribe: < mailto:[email protected]>
>>list-post: < mailto:[email protected]>
>>List-Id: php-windows.lists.php.net
>>Delivered-To: mailing list [email protected]
>>Authentication-Results: pb1.pair.com [email protected]; 
>>spf=permerror; sender-id=unknown
>>Authentication-Results: pb1.pair.com [email protected]; 
>>sender-id=unknown
>>X-PHP-List-Original-Sender: [email protected]
>>X-Host-Fingerprint: 98.139.212.172 nm13.bullet.mail.bf1.yahoo.com
>>DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.de; 
>>s=s1024; t=1295211472; 
>>bh=IdykF5YjKiZoaZrGPumJHpZInxsOj9nKmMzsStMHx24=; 
>>h=X-Yahoo-Newman-Id:Received:X-Yahoo-SMTP:X-YMail-OSG:X-Yahoo-Newman-Property:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; 
>>b=N4QXKF5e6uhF/LfR6x8MmEGtcOvSyQf1DYSbf+qIBiyZ+JcyHvobKSh8LjR5WPwwHuXUCgLelDgeNWV86aaoUDC6FzZkS+Co+pZi7NnP+oqyUx3TcW1Q0J29IVw3N5xNjkDxvwDAQSRKYDi2bbGNzH5r0IyFKH5Bkvu8os4KlNA=
>>X-Yahoo-Newman-Id: [email protected]
>>X-Yahoo-SMTP: wQb7PoiswBDDIaOUwhs3y1Z7sRE-
>>X-YMail-OSG: _UA5GdwVM1mpaMDCk1V7eKI9qRSVFoUCGQ3PYinwqJpthdU
>>  Yp7FqAy0KTHGLAFFLh1YHuUJinBVeLwGhU_xJdgH9uN3ifKJwZxXHyt8in8j
>>  VGyZ3Z2V66NmS.kpx_6r7nYe3.CNn8EI4gcIjR6gx_i2VXqZmr3URoQ.fTmM
>>  6jv.5.d7_ntKTC46H9hgCtn6VvcEVJyW6B37gDNf1kYxmsTGUR6_SbEZ_Wfs
>>  -
>>Date: Sun, 16 Jan 2011 21:57:47 +0100
>>From: Lars Mueller <[email protected]>
>>User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; de; 
>>rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
>>To: [email protected]
>>Subject: Re: [PHP-WIN] Error: Not a proper resource --- with code this time!
>>
>>Am 15.01.2011 17:35, schrieb Bill Mudry:

Lars, thank you for your effort and willingness to help. Unfortunately,
we have a way to go yet for success:



>>>$uvquery = "SELECT `uv_filename` FROM 'uvphotos' WHERE `species_name`=
>>>$speciesname";
>>
>>That should probably be
>>... FROM `uvphotos` WHERE `species_name` = '$speciesname'";

When I substituted this suggestion I got the following error:

You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near ''uvphotos' WHERE `species_name` = ''' at line 1


>>or better:
>>...WHERE `species_name` = '".mysql_real_escape($speciesname)."'";

When I tried this, I found more information on mysql_real_escape() at:
         http://php.net/manual/en/function.mysql-real-escape-string.php
With this proof that it is a valid function, it is hard to understand the
error I got when I used your second suggestion. I was surprising:

Fatal error: Call to undefined function mysql_real_escape() in 
/home/content/b/i/l/billmudry/html/taxa/show_uv_photos.php on line 69

Sooo ..... I will wish you and anyone else the best but we are not at 
a working solution yet.

I was thinking of listing only the section of interest but just to be 
on the safe
if not complete side, I will list below the full page code as it stands.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

[CODE]
<?php
////////////////////////////////////////////////////////////////////////////////////////////////////////
//  Program: show_uv_photos.php
//  Description: This program displays Uv fluorescence photos of wood 
found to glow under an ultraviolet
//  light. This is around 10% - 15% of all wood species.
//
//  It runs as a pop-up window and is activated by a button titled 
"U.V. Fluorescence" generated by
//  displayspecies.php. Future code may be added later to display the 
buttons only if the program can
//  detect UV photos stored for each species.
//  PARAMETERS:
//      {$_SESSION["speciesname"]} - Looks back to find what the 
current species picked is.
//              speciesname - The session variable name for the 
cuurent species.
//              $speciesname - The standard variable name taken from 
the session variable.
//              species_name - the name of the column that stores up 
to over 15,000 different botanical naes of wood.
//              uvphotos - the name of the table in the TAXA database 
that holds the partial path and photo file
//                      name
////////////////////////////////////////////////////////////////////////////////////////////////////////
session_start();

//ECHO "Session variable for species name is - 
{$_SESSION['species_name']}";  //Debug statement
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" 
"http://www.w3.org/TR/html4/loose.dtd">
<HTML>
<head>
<title>TAXA: Ultraviolet Wood Fluorescence</title>


</head>

<body bgcolor='ivory'>

<?PHP

# 
////////////////////////////////////////////////////////////////////////////////////
#                                           CONNECT TO DATABASE
# 
////////////////////////////////////////////////////////////////////////////////////



include ("connecttotaxa.php");
$connection = mysql_connect($hostname, $username, $password)
         or die("Unable to connect to database server");

$dbname="taxa";
$db = mysql_select_db($dbname, $connection)
         or die("Unable to connect to database");
/*
--------------------------------------------------------------------------------
                                             HOPEFULLY CONNECTED AT THIS POINT
---------------------------------------------------------------------------------- 

*/

///////////////////////////////////////////////////////////////////////////////////////////////////////
// 
SECTION TO DISPLAY WOOD SCANS
/////////////////////////////////////////////////////////////////////////////////////////////////////

         Echo "<div align = 'center'>";

         Echo "<H2 align=\'center\'>Ultraviolet Fluorescence Photo of
         {$_SESSION["speciesname"]}</H2>";

         $speciesname = $_SESSION["speciesname"]; //Successful 
transfer of ssssion parameter to a variable.
         //Echo "The species name is - $speciesname<br />"; //Proof 
that it transferred properly

         //$uvquery = "SELECT * FROM uvphotos WHERE 'species_name' = 
$speciesname";

         $uvquery = "SELECT `uv_filename` FROM 'uvphotos'
         WHERE `species_name` = '$speciesname'";


         //WHERE `species_name` = '".mysql_real_escape($speciesname)."'";
         //WHERE `species_name`= $speciesname";



         //$uvquery = "SELECT * FROM `uvphotos` WHERE `species_name` 
= '{$_SESSION["speciesname"]}' " or die ('Error: '.mysql_error 
());  //No error reported.

         $resultuv = mysql_query($uvquery) or die(mysql_error());

         /*
         if(!$resultuv)
                 {
                         die(mysql_error())
                 };
         */
         //Echo "\$resultuv on line 58 is - $resultuv<br />";

         //$number=mysql_num_rows($resultuv); // This and the next 
line only to debug a warning
         //ECHO "Number of rows is - $number<br >";

         if(mysql_num_rows($uvresults) >0){
                 $row = mysql_fetch_array($resultuv);
                 extract($row);
         }


         //$uv_filename = row('uv_filename');

         //ECHO "\$uv_filename on line 62 is - $uv_filename<br /><br />";

         //$uvfilename = "uva/acacia_anura-mulgaUV01-800.JPG";
         $uvpath = "./uv/$uvfilename";

         ECHO "<img src='$uvpath'><br />";

         ECHO "<HR>";

   Echo "<br />END OF PICTURE AREA<br /><br />";

Echo "</div>";



?>

<h4 align="center">Webmaster: This function is still Under Construction</h4>



<table align='center' cellpadding='10', Cellspacing='20' border =1>
<tr>
         <td valign='top'>
                 <form name='NewWin'>
                         <p><A href="javascript: self.close ()">Close 
this Window</A></p>
                 </form>
         </td>

</tr
 ></table>

</body>
</HTML>

[/CODE]
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.