Re: [PHP] Resource ID# 5 and Resource id #5 8561 errors....help
On Fri, Dec 12, 2008 at 16:54, Terion Miller webdev.ter...@gmail.com wrote:
$query = SELECT * FROM importimages WHERE Category='Obits' ;
$result = mysql_query ($query);
$arr = mysql_fetch_row($result);
$result2 = $arr[0];
echo ($result2);
Try this to get yourself started:
?php
$sql = SELECT * FROM `importimages` WHERE `Category` = 'Obits';
$result = mysql_query($sql) or die(Error in .__FILE__.:.__LINE__.
- .mysql_error());
while($row = mysql_fetch_array($result)) {
foreach($row as $k = $v) {
echo stripslashes($k).: .stripslashes($v).br /\n;
}
}
?
NOTE: You shouldn't need stripslashes(), but it's put there just
for backwards-compatibility in case you're on an older (or
poorly-configured) installation.
--
/Daniel P. Brown
http://www.parasane.net/
daniel.br...@parasane.net || danbr...@php.net
50% Off Hosting! http://www.pilotpig.net/specials.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Resource ID# 5 and Resource id #5 8561 errors....help
On Fri, Dec 12, 2008 at 4:02 PM, Daniel P. Brown
daniel.br...@parasane.netwrote:
On Fri, Dec 12, 2008 at 16:54, Terion Miller webdev.ter...@gmail.com
wrote:
$query = SELECT * FROM importimages WHERE Category='Obits' ;
$result = mysql_query ($query);
$arr = mysql_fetch_row($result);
$result2 = $arr[0];
echo ($result2);
Try this to get yourself started:
?php
$sql = SELECT * FROM `importimages` WHERE `Category` = 'Obits';
$result = mysql_query($sql) or die(Error in .__FILE__.:.__LINE__.
- .mysql_error());
while($row = mysql_fetch_array($result)) {
foreach($row as $k = $v) {
echo stripslashes($k).: .stripslashes($v).br /\n;
}
}
?
NOTE: You shouldn't need stripslashes(), but it's put there just
for backwards-compatibility in case you're on an older (or
poorly-configured) installation.
--
/Daniel P. Brown
http://www.parasane.net/
daniel.br...@parasane.net || danbr...@php.net
50% Off Hosting! http://www.pilotpig.net/specials.php
Thanks Daniel that did get me further, am I now to build an object from the
array, or take off one of the array to make an object, your snippet did grab
the names of the images and print them to the page but then I get stuck
where the page is trying to get the property of a non-object ..so I guess
im asking is a possible to turn an array into an object? or in this case
separate objects?
Re: [PHP] Resource ID# 5 and Resource id #5 8561 errors....help
On Fri, Dec 12, 2008 at 4:52 PM, Terion Miller webdev.ter...@gmail.comwrote:
On Fri, Dec 12, 2008 at 4:02 PM, Daniel P. Brown
daniel.br...@parasane.net wrote:
On Fri, Dec 12, 2008 at 16:54, Terion Miller webdev.ter...@gmail.com
wrote:
$query = SELECT * FROM importimages WHERE Category='Obits' ;
$result = mysql_query ($query);
$arr = mysql_fetch_row($result);
$result2 = $arr[0];
echo ($result2);
Try this to get yourself started:
?php
$sql = SELECT * FROM `importimages` WHERE `Category` = 'Obits';
$result = mysql_query($sql) or die(Error in .__FILE__.:.__LINE__.well
I changed it to
- .mysql_error());
while($row = mysql_fetch_array($result)) {
foreach($row as $k = $v) {
echo stripslashes($k).: .stripslashes($v).br /\n;
}
}
?
NOTE: You shouldn't need stripslashes(), but it's put there just
for backwards-compatibility in case you're on an older (or
poorly-configured) installation.
--
/Daniel P. Brown
http://www.parasane.net/
daniel.br...@parasane.net || danbr...@php.net
50% Off Hosting! http://www.pilotpig.net/specials.php
Thanks Daniel that did get me further, am I now to build an object from the
array, or take off one of the array to make an object, your snippet did grab
the names of the images and print them to the page but then I get stuck
where the page is trying to get the property of a non-object ..so I guess
im asking is a possible to turn an array into an object? or in this case
separate objects?
Well I did some changes and I must be learning because although I have the
same error I don't have new ones...
so now the code is like this:
$sql = SELECT * FROM `importimages` WHERE `Category` = 'Obits';
$result = mysql_query($sql) or die(Error in .__FILE__.:.__LINE__.
- .mysql_error());
while($object = mysql_fetch_object($result)) {
foreach($object as $k = $v) {
echo stripslashes($k).: .stripslashes($v).br /\n;
}
}
$FileName = $object-Image; ---This is the line that is telling
me it is trying to get the properties of a non-object
Re: [PHP] Resource ID# 5 and Resource id #5 8561 errors....help
On Fri, Dec 12, 2008 at 18:03, Terion Miller webdev.ter...@gmail.com wrote:
Well I did some changes and I must be learning because although I have the
same error I don't have new ones...
so now the code is like this:
$sql = SELECT * FROM `importimages` WHERE `Category` = 'Obits';
$result = mysql_query($sql) or die(Error in .__FILE__.:.__LINE__.
- .mysql_error());
while($object = mysql_fetch_object($result)) {
foreach($object as $k = $v) {
echo stripslashes($k).: .stripslashes($v).br /\n;
}
}
$FileName = $object-Image; ---This is the line that is telling
me it is trying to get the properties of a non-object
That's because you're calling that as an object using OOP
standards, where I gave you procedural code. To interface with my
code, just call it as:
?php
// other code here
while($row = mysql_fetch_array($result)) {
echo $row['Image'].br /\n; // If `Image` is the column name.
}
// code continues
?
--
/Daniel P. Brown
http://www.parasane.net/
daniel.br...@parasane.net || danbr...@php.net
50% Off Hosting! http://www.pilotpig.net/specials.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Resource ID# 5 and Resource id #5 8561 errors....help
On Fri, Dec 12, 2008 at 5:08 PM, Daniel P. Brown
daniel.br...@parasane.netwrote:
On Fri, Dec 12, 2008 at 18:03, Terion Miller webdev.ter...@gmail.com
wrote:
Well I did some changes and I must be learning because although I have
the
same error I don't have new ones...
so now the code is like this:
$sql = SELECT * FROM `importimages` WHERE `Category` = 'Obits';
$result = mysql_query($sql) or die(Error in .__FILE__.:.__LINE__.
- .mysql_error());
while($object = mysql_fetch_object($result)) {
foreach($object as $k = $v) {
echo stripslashes($k).: .stripslashes($v).br /\n;
}
}
$FileName = $object-Image; ---This is the line that is
telling
me it is trying to get the properties of a non-object
That's because you're calling that as an object using OOP
standards, where I gave you procedural code. To interface with my
code, just call it as:
?php
// other code here
while($row = mysql_fetch_array($result)) {
echo $row['Image'].br /\n; // If `Image` is the column name.
}
// code continues
?
--
/Daniel P. Brown
http://www.parasane.net/
daniel.br...@parasane.net || danbr...@php.net
50% Off Hosting! http://www.pilotpig.net/specials.php
Here is the full chunk:
$sql = SELECT * FROM `importimages` WHERE `Category` = 'Obits';
$result = mysql_query($sql) or die(Error in .__FILE__.:.__LINE__.
- .mysql_error());
while($object = mysql_fetch_object($result)) {
foreach($object as $k = $v) {
echo stripslashes($k).: .stripslashes($v).br /\n;
}
}
$FilePath = output/WebImagesHiRes/;
$BackupPath = output/WebImagesHiRes/backup/;
$FileName = $object-Image; //because it is going to process an
image doesnt that make it oop?
$FileName = str_replace(/, , $FileName);
$FileName = str_replace(.jpg, , $FileName);
Well its late friday afternoon here, I'm ready to break away from my
desk...maybe on monday I will be able to get it working (right now our obit
pics in the online paper are not getting posted...oops)
Thanks folks
yawn LEts call it a weekend wt
terion
Re: [PHP] Resource ID# 5 and Resource id #5 8561 errors....help
Terion Miller wrote:
On Fri, Dec 12, 2008 at 5:08 PM, Daniel P. Brown
daniel.br...@parasane.netwrote:
On Fri, Dec 12, 2008 at 18:03, Terion Miller webdev.ter...@gmail.com
wrote:
Well I did some changes and I must be learning because although I have
the
same error I don't have new ones...
so now the code is like this:
$sql = SELECT * FROM `importimages` WHERE `Category` = 'Obits';
$result = mysql_query($sql) or die(Error in .__FILE__.:.__LINE__.
- .mysql_error());
while($object = mysql_fetch_object($result)) {
foreach($object as $k = $v) {
echo stripslashes($k).: .stripslashes($v).br /\n;
}
}
$FileName = $object-Image; ---This is the line that is
telling
me it is trying to get the properties of a non-object
That's because you're calling that as an object using OOP
standards, where I gave you procedural code. To interface with my
code, just call it as:
?php
// other code here
while($row = mysql_fetch_array($result)) {
echo $row['Image'].br /\n; // If `Image` is the column name.
}
// code continues
?
--
/Daniel P. Brown
http://www.parasane.net/
daniel.br...@parasane.net || danbr...@php.net
50% Off Hosting! http://www.pilotpig.net/specials.php
Here is the full chunk:
$sql = SELECT * FROM `importimages` WHERE `Category` = 'Obits';
$result = mysql_query($sql) or die(Error in .__FILE__.:.__LINE__.
- .mysql_error());
while($object = mysql_fetch_object($result)) {
foreach($object as $k = $v) {
echo stripslashes($k).: .stripslashes($v).br /\n;
}
}
$FilePath = output/WebImagesHiRes/;
$BackupPath = output/WebImagesHiRes/backup/;
$FileName = $object-Image; //because it is going to process an
image doesnt that make it oop?
$FileName = str_replace(/, , $FileName);
$FileName = str_replace(.jpg, , $FileName);
Well its late friday afternoon here, I'm ready to break away from my
desk...maybe on monday I will be able to get it working (right now our obit
pics in the online paper are not getting posted...oops)
Thanks folks
yawn LEts call it a weekend wt
terion
Try this
?php
$FilePath = output/WebImagesHiRes/;
$BackupPath = output/WebImagesHiRes/backup/;
#setup query
$sql = SELECT * FROM `importimages` WHERE `Category` = 'Obits';
#excute query and return results, if any
$result = mysql_query($sql) or
die(Error in .__FILE__.:.__LINE__. - .mysql_error());
# Loop through results, pulling each resulting row as an object
while($object = mysql_fetch_object($result)) {
# Grab the Image contents and work with it.
$FileName = $object-Image; // Watch it, this is case-sensitive!!!
$FileName = str_replace(/, , $FileName);
$FileName = str_replace(.jpg, , $FileName);
echo $FileName;
... Do the rest of what you place to do with each row ...
}
?
--
Jim Lucas
Some men are born to greatness, some achieve greatness,
and some have greatness thrust upon them.
Twelfth Night, Act II, Scene V
by William Shakespeare
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
