[PHP] Re: [PHP-DB] Re: while...if statements???

2001-12-19 Thread Chris Lee

personal pref. Once I knew php and mysql better I wrote my own wrappers, I found using 
them easier. But there is no reason why someone couldnt do fine without one. writing a 
set of wrappers allowed me to better optimize my queries and write code faster without 
having to worry about everything else.

have you tried the PEAR db wrappers? PEAR came out after I wrote mine, therfore I 
never used them, you?

  Chris Lee
  [EMAIL PROTECTED]



- Original Message - 
From: "matt stewart" <[EMAIL PROTECTED]>
To: "'Chris Lee'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; 
<[EMAIL PROTECTED]>
Sent: Wednesday, December 19, 2001 1:16 AM
Subject: RE: [PHP-DB] Re: while...if statements???


> and i always thought the best tactic was to go ugly early.
> 
> seriously, this isn't really that ugly a solution, most textbooks tend to
> tell you to use this method to start with as its a bit simpler to understand
> for beginners - an if...else statement to see if an initial row is returned,
> then you can happily use a do...while on that first row, and it'll carry on
> outputting the following rows if there are any more.
> 
> -Original Message-
> From: Chris Lee [mailto:[EMAIL PROTECTED]]
> Sent: 18 December 2001 20:49
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [PHP-DB] Re: while...if statements???
> 
> 
> because the while() statement works like this
> 
> - do something while x is true. if x is not true dont do anything.
> - do something while conent is in the db. if there is no conent in the db
> dont do anything.
> 
> your if() statement is never run if there is no content.
> 
> $return = mysql_fetch_row($result);
> if ( isset($return['pet_name']) )
> do
> {
> echo $return['pet_name'] ."";
> } while( $return = mysql_fetch_row($result) );
> else
> echo " No Pets ";
> 
> its ugly but it works. I dont like ugly, so I wrote my own db wrappers.
> 
> http://www.mediawaveonline.com/examples/
> 
> foreach( $db->select_array('', 'petinfo', '') as $pos => $val )
> echo $val['pet_name'] ."";
> if ( !isset($val['pet_name']) )
> echo " No Pets ";
> 
> I like that more. but whatever.
> 
> --
> 
>   Chris Lee
>   [EMAIL PROTECTED]
> 
> 
> 
> "Jay Fitzgerald" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > Does anyone know why this isn't working?? What I am trying to do is
> display
> > photos from a database based on each month. This part works fine when I
> set
> > it to the current month of December (today) as that is when I uploaded the
> > photos.
> >
> > However, when I manually set the date to a month that has no photos in it,
> > I want it to echo the No Animals string belowThis is only working
> > half-way...meaning that it will display a blank page with nothing on it
> > instead of actually echoing the No Animals string
> >
> > Can anyone please help?? Is there really a way to have a "while...if"
> > statement
> >
> >
> >
> > =
> >  > $connection = mysql_connect($hostname, $user, $pass) or die ("Unable to
> > connect!");
> > $query = "SELECT petname, petDesc, petpicture FROM petinfo WHERE petmonth
> =
> > 'Apr'";
> > $result = mysql_db_query($database, $query, $connection) or die ("Error in
> > query: $query. " . mysql_error());
> >
> > while (list($pet_name, $pet_Desc, $pet_picture) =
> mysql_fetch_row($result))
> > {
> > if ($pet_picture == "")
> > {
> > echo "No Animals have been posted for $date at this moment. Please check
> > back soon.";
> > exit;
> > }
> >
> > else
> > {
> > echo "
> > Pet of the month
> >
> > 
> >  >
> SRC=\"http://moss.bayou.com:/oppj/admin/animalcontrol/photos/$pet_pictur
> e\"
> > HEIGHT=150>
> >
> > 
> > $pet_Desc
> >
> > 
> > To adopt $pet_name please visit the Ouachita Parish Animal Shelter.
> > The adoption fee is \$50.00 which includes Spade, Neutering and 7-N-1
> > Shot.
> >
> > 
> > Sorry, we can not hold $pet_name for you (First come first serve
> > basis).
> > ";
> > }
> > }
> > ?>
> > =
> >
> > Thanks,
> >
> >
> > Confus3d
> >
> >
> 
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
> 
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01
>  
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01
>  
> 


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




[PHP] RE: [PHP-DB] Re: while...if statements???

2001-12-19 Thread matt stewart

and i always thought the best tactic was to go ugly early.

seriously, this isn't really that ugly a solution, most textbooks tend to
tell you to use this method to start with as its a bit simpler to understand
for beginners - an if...else statement to see if an initial row is returned,
then you can happily use a do...while on that first row, and it'll carry on
outputting the following rows if there are any more.

-Original Message-
From: Chris Lee [mailto:[EMAIL PROTECTED]]
Sent: 18 December 2001 20:49
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] Re: while...if statements???


because the while() statement works like this

- do something while x is true. if x is not true dont do anything.
- do something while conent is in the db. if there is no conent in the db
dont do anything.

your if() statement is never run if there is no content.

$return = mysql_fetch_row($result);
if ( isset($return['pet_name']) )
do
{
echo $return['pet_name'] ."";
} while( $return = mysql_fetch_row($result) );
else
echo " No Pets ";

its ugly but it works. I dont like ugly, so I wrote my own db wrappers.

http://www.mediawaveonline.com/examples/

foreach( $db->select_array('', 'petinfo', '') as $pos => $val )
echo $val['pet_name'] ."";
if ( !isset($val['pet_name']) )
echo " No Pets ";

I like that more. but whatever.

--

  Chris Lee
  [EMAIL PROTECTED]



"Jay Fitzgerald" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Does anyone know why this isn't working?? What I am trying to do is
display
> photos from a database based on each month. This part works fine when I
set
> it to the current month of December (today) as that is when I uploaded the
> photos.
>
> However, when I manually set the date to a month that has no photos in it,
> I want it to echo the No Animals string belowThis is only working
> half-way...meaning that it will display a blank page with nothing on it
> instead of actually echoing the No Animals string
>
> Can anyone please help?? Is there really a way to have a "while...if"
> statement
>
>
>
> =
>  $connection = mysql_connect($hostname, $user, $pass) or die ("Unable to
> connect!");
> $query = "SELECT petname, petDesc, petpicture FROM petinfo WHERE petmonth
=
> 'Apr'";
> $result = mysql_db_query($database, $query, $connection) or die ("Error in
> query: $query. " . mysql_error());
>
> while (list($pet_name, $pet_Desc, $pet_picture) =
mysql_fetch_row($result))
> {
> if ($pet_picture == "")
> {
> echo "No Animals have been posted for $date at this moment. Please check
> back soon.";
> exit;
> }
>
> else
> {
> echo "
> Pet of the month
>
> 
> 
SRC=\"http://moss.bayou.com:/oppj/admin/animalcontrol/photos/$pet_pictur
e\"
> HEIGHT=150>
>
> 
> $pet_Desc
>
> 
> To adopt $pet_name please visit the Ouachita Parish Animal Shelter.
> The adoption fee is \$50.00 which includes Spade, Neutering and 7-N-1
> Shot.
>
> 
> Sorry, we can not hold $pet_name for you (First come first serve
> basis).
> ";
> }
> }
> ?>
> =
>
> Thanks,
>
>
> Confus3d
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]