PHP - If Row = Empty

I was just wondering what the best way to identify an empty set is.  At the moment I have this but this doesn't seem to work so I was wondering what the best way is.  Thanks. 


$article_rs = mysql_query($article_sql, $mysql_conn);

if (!$article_rs) {
$_SESSION['no_articles'] = "<p>Sorry but there are no articles that match your search.</p>";
}

Hi all,

I have this:
Code: [Select]
<?php
session_start();
include('login/functions.php');
$username = $_SESSION['username'];
$check = mysql_query("SELECT email FROM user_profile WHERE username = '$username'");
$a = mysql_fetch_field($check);
if(empty($a))
{
header('Location: complete.php');
}


?>
However if the field is empty, ie no email address for user then nothing happens?

Am going about this the right way?

Cheers

how would I make it so that the option 'Remove (make blank)' would post an empty value?

Quote

<form action="/new/newrotastaffprocess.php" Method="POST">

<select name="username">
<?php
$result = mysql_query("SELECT * FROM members")
or die(mysql_error());
while($row = mysql_fetch_array( $result )) {

echo "<option value=\"" . htmlentities($row["username"]) . "\">" . htmlentities($row["username"]) . "</option>";
}
echo "<option value='empty'>Remove (make blank)</option>";
?>
</select>
</div>
<div style="position:absolute; top:397px; left:570px;">
<form action="/new/newrotastaffprocess.php" METHOD="POST">
<input type = "hidden" value="<?php echo $wkbeg;?>" name="wkbeg">
<input type = "hidden" value="<?php echo $staffno;?>" name="staffno">
<input type = "submit" value="New!">
</form>

I'm not sure what i have done wrong here...
all it says is "Query was empty"


<?php
SESSION_START();

?>

//some html

<?php

if($_SESSION['email']){

$mysql = "SELECT id,firstname FROM users WHERE 'id'='".$_SESSION['email']."'";
$res = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($res) == 0){
session_destroy();
echo"Please <a href=\"/index.html\">Login</a> or <a href=\"/register.php\">Join Us.</a>";
}else{
$row = mysql_fetch_assoc($res);
echo "welcome back, <a href=\"./index.php?act=profile&id=".$row['id']."\">".$row['firstname']."</a>\n";

}
}else {
echo"Please <a href=\"/index.html\">Login</a> or <a href=\"/register.php\">Join Us.</a>";

}
?>

Hello:

I have this bit of code in the works (which does not work):
Code: [Select]
<?php if ( $mySubHeader; != "" ) { echo " 

<h2>
<?php echo $mySubHeader; ?>

</h2>

"; }

What I am trying to do is to show the H2 tag only if it has a value from the database.

Otherwise, I do not want to show it.

What is the correct way to do this?

Thanks.

I have this line in my code

$result2 = mysqli_query($link, 'Select * from categories where cat_loc ='.$nav['id']);

how do I say "if $result2 is empty or false"? (basically if it didn't find any cat_loc = to $nav['id'])

 to echo '</li>';

I have a number of fields to display on a page, from a mysql query,  some fields are empty, some not. depends on what they choose on the original form.

I am trying to display on the form results on a page formatted using the below:

If the mysql field is empty, display an unchecked check box next to the result. If there is data in the field display a check box ticked.

What can i do to achieve this, can you point me in the right direction?

Results page using echo:


</TD><TD>Options: <input type='checkbox' CHECKED>". $row[17]. " </TD> = is not empty field
</TD><TD>Options: <input type='checkbox' UNCHECKED>". $row[17]. " </TD> = emtpy ,mysql field
</TD><TD>Options: <input type='checkbox' CHECKED>". $row[18]. " </TD> = not empty mysql field from query
</TD><TD>Options: <input type='checkbox' UNCHECKED>". $row[18]. " </TD> = Empty field in mysql


I am trying to show Rows 1 to 16 to display normally, rows 17 to 30 use the above logic.

There are about 30 fields to display like this, the others are required fields and are displayed no matter what.

Hi all

I have a pice of code that I want to only show the image if it's empty:

Code: [Select]
<?php if(!empty($node->field_img['und'][0]['filename'])); { ?>

<li><img src="http://mysite.co.uk/sites/default/files/brand-images/<?php print $node->field_img['und'][0]['filename']; ?>" style="max-width:270px; text-align:center;" /></li>

<?php } ?>

However, it shows an image placeholder (Red cross) even when it's empty?

Many thanks for your help

Pete

Im trying to echo certain code if the array returned is empty.  I know for certain the array is empty and it works when its not empty. here is my code

<?php while ($club = mysql_fetch_assoc($qclubs)) {

if (empty($club)) {echo "<option value='None'>None</option>";}

else{

echo"
                                <option value='{$club['groupID']}'>{$club['group']}</option>";

}}?>


Can someone please point out the error of my ways?

Hi, please help me for school i need to make an assignment and i need to make an script with regular expressions to get an image from a site named asaphshop.nl. but the only thing happens is that it's searching in the localhost what should be on the site. this is my code:

​ <?php
header('Content-Type: text/html; charset=utf-8');
$url = "http://www.asaphshop.nl/epages/asaphnl.sf/nl_NL/?ObjectPath=/Shops/asaphnl/Products/80203122";
$htmlcode = file_get_contents($url);
$pattern = '#class="noscript">.*(<img.*>).*</div>#isU';
preg_match_all($pattern, $htmlcode, $matches);
//print_r ($matches);
$image = ($matches[0]);
print_r ($image);
?>

 in the attached file is the thing i get Attached Files  Naamloos.png   21.8KB   0 downloads

Hello everybody,   I am new to php, I have a question for you guys. why I've got an empty page.   <?php

I introduce if condition when a string is empty as
Code: [Select]
if (empty($string)) {
How I can add the condition for a certain value too. If empty or equal to "word1".

I am using a script to take postcodes and give distances between them and list all postcodes within a radius. Where it should list all the postcodes in the radius it provides and empty array - any clues??

the table is 'geodb'

relevant fields are                 
postcode 
place     
latitude     
longitude

and the code is
Code: [Select]
if(isset($_GET['Search']))
{
    $postcode = strtoupper($_GET['postcode']);
    $radius = $_GET['radius'];
echo $postcode . '<br>';
echo $radius . '<br>';

$conn = mysql_connect(/*credentials removed*/) or die('db connect error: ' . mysql_error());
    mysql_select_db('db379121', $conn) or die('could not select database');
  $sqlstring = "SELECT * FROM geodb WHERE postcode = '".$postcode."'";
    $result = mysql_query($sqlstring);

    $row = mysql_fetch_assoc($result);

++++++++++++++++++++++++++++++++++++++++++
var_dump($row); // seeing whqat is in the array - returns one result (array(9) { ["id"]=> string(1) "1" ["countrycode"]=> string(2) "GB" ["postcode"]=> string(4) "AB10" ["place"]=> string(8) "Aberdeen" ["postaltown"]=> string(8) "Aberdeen" ["region1"]=> string(8) "Scotland" ["region2"]=> string(13) "Aberdeen City" ["latitude"]=> string(12) "57.135813090" ["longitude"]=> string(12) "-2.121224030" })//
++++++++++++++++++++++++++++++++++++++++++
    $lng = $row["longitude"] / 180 * M_PI;
    $lat = $row["latitude"] / 180 * M_PI;
 echo $lat .
 '<br>';
 echo $lng . '<br>';
 ++++++++++++++++++++++++++++++++++++++++++
echo to check that there is a value here - i get lat  0.99720805922458        lng -0.037022343495923
++++++++++++++++++++++++++++++++++++++++++
    mysql_free_result($result);}



 $sqlstring2 = "SELECT DISTINCT geodb.postcode,geodb.place,(6367.41*SQRT(2*(1-cos(RADIANS(geodb.latitude))*cos(".$lat.")*(sin(RADIANS(geodb.longitude))*sin(".$lng.")+cos(RADIANS(geodb.longitude))*cos(".$lng."))-sin(RADIANS(geodb.latitude))* sin(".$lat.")))) AS Distance FROM geodb AS geodb WHERE (6367.41*SQRT(2*(1-cos(RADIANS(geodb.latitude))*cos(".$lat.")*(sin(RADIANS(geodb.longitude))*sin(".$lng.")+cos(RADIANS(geodb.longitude))*cos(".$lng."))-sin(RADIANS(geodb.latitude))*sin(".$lat."))) <= '".$distance."') ORDER BY Distance";

    $result = mysql_query($sqlstring2) or die('query failed: ' . mysql_error());

    $str = "<table width=\"300\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
    $str .= "<tr>";
    $str .= "<th>postcode</th>";
    $str .= "<th>city</th>";
    $str .= "<th>distance</th>";
    $str .= "</tr>";

    while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
    {
        $str .= "<tr><td>".$row["postcode"]."</td><td>".$row["place"]."</td><td>".round($row['Distance'])."km</td></tr>";
    }

    $str .= "</table>";
++++++++++++++++++++++++++++++++++++++++++
var_dump($row["place"]); // this produces null
++++++++++++++++++++++++++++++++++++++++++

    mysql_free_result($result);
    mysql_close($conn);
    echo $str;

  
Am trying to get user input then compare it with the value in database then return an output in form of echo. It shows a blank page of whick i cant figure out the error. This is what i have tried so far.

This is a file called t12.php   

<?php

  include 'db.php';
  error_reporting(E_ALL | 
   E_WARNING | E_NOTICE);
    
  ini_set('display_errors', 
  TRUE);

     if (session_status() 
    == PHP_SESSION_NONE) 
    {
    session_start();
    }


  if(!isset($_SESSION['login']))
    {
         echo (" 
   <script>location.href='../clogin/'</script>");
    die();

  if(isset($_POST['transfer']))

     {

     $username = 
    $_SESSION['login'];

     $transAmount = 
    $_POST['transAmount'];

     $totalTrans = 
    $transAmount + 30;

    $sql = "SELECT * FROM 
   customer WHERE username = ?";
    $stmt = $connection->prepare($sql); 
    $stmt->bind_param('s', $username);
    $stmt->execute();
    $result = $stmt->get_result();
    $count =  $result->num_rows;
      if($count == 1) 
     {  
 
    while ($row = $result->fetch_assoc())
     {
 
        if($totalTrans > $row['transLimit']) 
    {
    
    echo 'you have exceeded limit';

    exit(); 
    }
     else
     {
      echo"limit passed";
      }

      }//while loop
      }//count

       }//submit
       }//session
       ?>

                     
The html form is this...

   

<form action="t12.php" method="post">
          <input type="number" name="transAmount" placeholder="Enter Amount"> 
   </input><br>
    <button type="submit" name="transfer">Proceed</button></form>

 

 

 

Have tried lot of stuffs but doesnt work out. I would appreciate if you can take your time to check for me and point out the errors. Also please be nice with your comments. Thanks in advance

Hello
i have a SQL db that has some Empty Rows in it ....
I Had used a if else statement to make it display N/A If the answer is different than it should be like this

<?php if ($string) {echo $string} else {echo"N/A"};?>
but i think there are better ways of doing this
Can anyone teach me how may i do it?
Edit:
it should be a way to see if the db row value is empty/null :|