if else echo, need a little help..

[dgnzcn]

Hi;

I have this codes simple showing photos and infos  from database...

 

I want this : if photo not found from databese then echo : no photo found..

and,  if info not found from database then echo : no info found

 

how can i do it..?

 

 

<?php do { ?>
                  <div style="float:left;">
                    <table border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td colspan="2" align="center" valign="middle"><img src="images/transparent_line.gif" width="12" height="3" /></td>
                      </tr>
                      <tr>
                        <td width="130" height="135" align="center" valign="middle" bgcolor="#FFFFFF"><a href="urun_res/<?php echo $row_res['file2']; ?>" class="highslide" id="thumb3" onclick="return hs.expand(this)"><img src="urun_res/<?php echo $row_res['file2']; ?>" alt="<?php echo $row_res['info']; ?>" width="100" height="100" title="Büyüt" /></a><a class="highslide" onclick="return hs.expand(this)"></a></td>
                        <td width="15" align="center" valign="middle"> </td>
                      </tr>
                      <tr>
                        <td colspan="2" align="center" valign="top"><img src="images/transparent_line.gif" width="12" height="2" /></td>
                      </tr>
                      <tr>
                        <td colspan="2" align="center" valign="top"><img src="images/transparent_line.gif" width="12" height="10" /></td>
                      </tr>
                      <tr>
                        <td colspan="2" align="center" valign="top"><?php echo $row_res['info']; ?></td>
                      </tr>
                    </table>
                  </div>
                <?php } while ($row_res = mysql_fetch_assoc($res)); ?>

[fortnox007]

I am not sure how you managed everything with your DB but, you could place some code above your script with the if statements and also fetch the stuff you have from your database to give.

 

//$file_from_db = ;  // get your stuff from your database
//$info_from_db = ; // get your stuff from your database

//if-statement for $info
if($info_from_db!= NULL){ // or any value you want
$info = 'this will contain your database stuff';
}else{ 
$info = 'no info found...';
}

//if-statement for $file
if($file_from_db!= NULL){ // or any value you want
$file2 = 'path to file';// atleast that is what you store in your database i assume
}else{ 
$info = 'path to a default empty image or a text you like, i would use an empty picture';
}

 

 

 

[dgnzcn]

thanks for quick reply...

i will try.

[fortnox007]

There are more ways i think to do this and it depends on the way your fields in the database are filled ofc, but this gives a good impression of one way of doing it. Hope it helps

In this case I am expecting your database fields are Set to NULL if the user has not done anything. You can ofcourse take any value as long as you adjust the check.

-edit i saw an error in my script in the second if statement i used $text instead of $file

//$file_from_db = ;  // get your stuff from your database (prolly a path to file)
//$info_from_db = ; // get your stuff from your database

//if-statement for $info
if($info_from_db!= NULL){ // or any value you want
$info = 'this will contain your database stuff';
}else{ 
$info = 'no info found...';
}

//if-statement for $file
if($file_from_db!= NULL){ // or any value you want
$file2 = 'path to file';// atleast that is what you store in your database i assume
}else{ 
$file2 = 'path to a default empty image or a text you like, i would use an empty picture';
}

[BizLab]

You gotta dump the tables in your code man, thats been depreciated for many, many years now. Its an important step if you are to have any chance at all as we shift into HTML5...

 

As you write your code you can have anything you want placed in a conditional statement:

$query = "SELECT * FROM my_db WHERE your_variable='$your_desired_data'";
// do all the standard query protocol then place your images, conditionally 
if(isset($row['image_x'])){
  echo '<img src="'.$row['image_x'].'" width="100" height="100" alt="dont forget your alt text">';
}
else{
  echo 'No image available';
}

 

[fortnox007]

You gotta dump the tables in your code man,

I second that! tables are so last supper   - Leonardo Da Vinci 2.0

[dgnzcn]

ok. really thanks for the answers.. I have another problem.

 

 

 <?php $found= include "inc-indirimliurunler.php" ; 
      if($found == ''){
      echo ('no product found');
      }
      else {
        echo include "inc-indirimliurunler.php".$found." ;
      }
      ?>

 

where is the wrong code ?

[Philip]

Take a look at your code when it is syntax highlighted. You can see the missing end quote before you last semicolon.

[cyberRobot]

You gotta dump the tables in your code man, thats been depreciated for many, many years now.

 

That's not exactly true. Tables have not been depreciated, they are still need for data tables.

[rwwd]

You gotta dump the tables in your code man, thats been depreciated for many, many years now.

 

That's not exactly true. Tables have not been depreciated, they are still need for data tables.

 

And will continue to be relevant for many many years too; though school's and Colleges alike are now starting to favour CSS & divs. BUT there will always be someone using an old browser & frontpage somewhere!

 

I must admit though, I am completely div css now; though this was just to see if I could produce something exactly the same with div's/css as I can with tables, which I can!

 

Cheers,

Rw