PHP - Adding Seperator If Values Are Not Empty

i retrieving an adid from $_GET which is also a value retireved from a database.
Code: [Select]
$this_adid=$_GET['adid'];
    if(empty($this_adid))
{
    $get_ad_id = mysql_query("SELECT userid FROM ads WHERE adid='$this_adid'", $con) or die("Error Getting AD ID: ".mysql_error());
   while($get_ad_id_results = mysql_fetch_assoc($get_ad_id)) { $owner_id=$get_ad_id_results['userid']; }
}
the above query works if  $this_adid returns 0 (http://www.website.com/?do=delete&adid=0&givenuserid=15773) i.e. adid is 0 in the table.

But it does not work if $this_adid returns null or ntohin (http://www.website.com/?do=delete&adid=&givenuserid=15773) .i.e adid is ' ' (empty) field in the databse table..

can someone tell me why it does not check for null or empty values properly?

Hello,

Im having trouble and need your help. I have two pages. The first establishes the table and calls up a database:


<?php
include "include/dbc.php";

include "include/header.inc";
?>

<style type="text/css">
.mydate{
color:#00F;
text-decoration:underline;
cursor:pointer;
}
</style>

<script type="text/javascript">
function displayDate(d){
var date=new Date();
var D=date.getDate();
date.setDate(D+d);
var YYYY=date.getFullYear();
var MM=date.getMonth()+1;
MM<10?MM='0'+MM:null;
var DD=date.getDate();
DD<10?DD='0'+DD:null;
var span=document.getElementById('date');
span.innerHTML= 'Entries for '+MM+'/'+DD+'/'+YYYY;
}
onload=function(){displayDate(0)};
</script>

<h1>Food Diary</h1>

<div class="full">
<center><div><span class="mydate" onclick="displayDate(-1)"><img src="images/left_arrow.png" border="0">Yesterday</span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span id="date" style="font-size:2em;"></span>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class="mydate" onclick="displayDate(1)">Tomorrow<img src="images/right_arrow.png" border="0"></span></div><br />
<a href="#" onclick="displayDate(0);return false;">Today</a>
</center>

<div class="full">
<form name="exercise" id="exercise" method="GET" action="">
  <center><table>
<tr>
     <td><h3>Add an Activity</h3></td>
</tr>
<tr>
     <td><input name="NewSearchString" style="width: 100px" type="text"/>&nbsp;&nbsp;<input type="submit" value="Search" /> </td>
</tr>
    <tr>
     <td>
         <select name="activity">
             <option value="_">Activity Browse...</option>
                <option value="all">All Activities</option>
                <option value="biking">Biking</option>
                <option value="condition">Conditioning</option>
                <option value="dancing">Dancing</option>
                <option value="fish">Fishing & Hunting</option>
                <option value="Home">Home Activities</option>
                <option value="misc">Miscellaneous</option>
                <option value="music">Music Playing</option>
                <option value="occupation">Occupation</option>
                <option value="running">Running</option>
                <option value="sports">Sports</option>
                <option value="walking">Walking</option>
                <option value="water">Water Activities</option>
                <option value="winter">Winter Activities</option>
</select> &nbsp;&nbsp;<input type="submit" value="Submit" /></td></tr></table></center></form>
</td>
</tr>
</table> </center>
<table width="100%">
    <tr bgcolor="#66CC33">
     <td><div>Activity</div></td>
        <td><div>Specific Activity</div></td>
        <td><div>Time (hh:mm)</div></td>
        <td><div>Distance</div></td>
        <td><div>Units</div></td>
</tr>
    <tr bgcolor="#66CC33">
     <td><div></div></td>
      <td><div></div></td>
       <td><div></div></td>
        <td><div class="Float"></div></td>
        <td class="cp_Distance"><div></div></td>
</tr>
<?php
if(isset($_GET[activity])) {
$category=$_GET[activity];
$result = mysql_query("SELECT * FROM exercise WHERE type='$category'");
?>
<form action="add_activity.php" method="POST">
<?php
while($row = mysql_fetch_array($result)) {
echo '<tr><td><div>'.$row[Type].'</div></td>';
echo '<td><div>'.$row[Name].'<input type="hidden" name="exerciseid[]" value="'.$row[Name].'"></div></td>';
echo '<td><div><input type="text" name="duration['.$row['Name'].']"></div></td>';
echo '<td><div><input type="text" name="distance['.$row['Name'].']"></div></td>';
echo '<td><div><select name="metric[]">
         <option value="mile" name="mile">mile</option>
             <option value="Km" name="Km">km</option>
             <option value="M" name="M">m</option>
             <option value="Yard" name="yard">yrd</option>
             <option value="Feet" name="feet">ft</option>
            </select></div></td></tr>';

}
mysql_close();
?>

<tr><td colspan="6" align="center"><input type="submit" name="submit" value="Add Activities" onClick="return confirm(
  'Are you sure you want to submit the activities?');"></td></tr>
</form>
<?php
}
?>
    <tr bgcolor="#66CC33">
     <td><div></div></td>
      <td><div></div></td>
       <td><div></div></td>
        <td><div class="Float"></div></td>
        <td class="cp_Distance"><div></div></td>
</tr></table>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


The second page passes those values:


<?php
include "include/dbc.php";

include "include/header.inc";

$exerciseid = $_POST["exerciseid"];
$duration = $_POST["duration"];
$distance = $_POST["distance"];
$metric = $_POST["metric"];

echo'<h1>Added Activities</h1>';



// name of array
echo '<h1>Exercise</h1>';
if( is_array($exerciseid) )
{
foreach ($exerciseid as $key => $value) {

                        echo $key .' : '. $value .'<br />';
    }
}


echo '<h1>Duration</h1>';
if(is_array($duration) )
{
foreach ($duration as $key => $value) {

                        echo $key .' : '. $value .'<br />';
}
}


// name of array
echo '<h1>Distance</h1>';
if (is_array($distance)) {
        foreach ($distance as $key => $value) {

                        echo $key .' : '. $value .'<br />';

        }
}

// name of array
echo '<h1>Metric</h1>';
if (is_array($metric)) {
        foreach ($metric as $key => $value) {

                        echo $key .' : '. $value .'<br />';

        }
}

?>


The problem is that this code returns everything:

Added Activities

Exercise
0 : Fishing from boat, sitting
1 : Fishing from river bank, standing
2 : Fishing in stream, in waders
3 : Fishing, general
4 : Fishing, ice, sitting
5 : Hunting, general

Duration
Fishing from boat, sitting : 22
Fishing from river bank, standing :
Fishing in stream, in waders :
Fishing, general :
Fishing, ice, sitting :
Hunting, general :

Distance
Fishing from boat, sitting : 22
Fishing from river bank, standing :
Fishing in stream, in waders :
Fishing, general :
Fishing, ice, sitting :
Hunting, general :

Metric
0 : mile
1 : mile
2 : mile
3 : mile
4 : mile
5 : mile

I need a way to say if this variable is empty, null, or equals 0, do not return it. And yes, the variables are arrays. I don't know what else to do. Thanks in advance.

Hi,

I am using an array which allows me to prevent particular subfolders from being included in a script that generates an audio playlist.  It looks like this:

$disallowed=array('..', '.', 'simon', 'steve');

I would like to find a way of disallowing any folders which are empty, or, perhaps, better still, disallowing folders that do not have any MP3s in them (in case the script interprets folders as not empty if they contain system files which are automatically generated).

Would someone be able to help with this?

Thanks,

Nick

I have a series of string which can have a value or empty. I want to display them with echo.

echo $string1 $string2 $string3; satisfies my need, as it shows available values, but with this method, I will get a PHP notice in my error_logs. What is your suggestion? Do I need to use "if (empty)" or "if(isset)"? The point is I have numerous strings and in each run only few of them have value.

Hey! How've you been? This should be simple but I can't make it work. I have a few database values from a user entry. The page queries the database and I can print them no problem. I want to add them and display the total of these values. I've tried about two dozen ways of doing and I just can't get them to add. Where I have "fee_total" I want it to be the sum of the values "fee+upgrade7+tax". This is the snippet of what I'm working on. I won't attach any of what I have tried because, well, there are too many attempts and nothing worked

    $sql = ("SELECT * FROM Teamregister WHERE pkSoloregisterID=$pkSoloregisterID");
    $query = mysql_query($sql);
    $result = mysql_query($sql);
    $myrow = mysql_fetch_array($result);

    printf ('<form action="https://www.mysite.com/cgi-bin/webscr" method="post">
      <p>Your registration fee is <strong>$%s</strong>.</p>', $myrow['total_fee']);
      echo ("<input type='hidden' name='item_name_1' value='Registration Fee'>");
      printf ('<input type="hidden" name="amount_1" value="%s">', $myrow['total_fee']);
      echo ("<br /><div align='center'>
      <input type='submit'' value='Pay Online'>
      </form>');

Make sense? Like I said, the values are already there but the math isn't happening. To check I tried using individual DB values instead of "total_fee" and the numbers show up. Just cannot get them to add.