PHP - Pdo Object Is Null

Hello All,

I tried searching here and google, but couldn't figure it out on my own... still

Bellow is my code, I need some help figuring out how to tell PHP that "If picture is NULL, don't try to display it."

Basically I have a dynamic news system set up. Some stories have pictures, some do not. I need PHP to not display the code for showing the picture if the picture value = NULL.

Any help would be appreciated!

<?php 
include ("../../includes/connections/newsconnection.php");

$id=$_GET['id'];

//declare the SQL statement that will query the database
$query = "
SELECT *
FROM news 
WHERE id='$id'
";

//execute the SQL query and return records
$result = mssql_query($query);

//display the results 

//id, school, date, link, title, story, picture

while($row = mssql_fetch_array($result))
{
echo "<span class='bodyb'>";
echo $row["title"];
echo "</span>";
echo "<br /><i>";
echo date('l, F j, Y', strtotime($row['date']));
echo "</i>";
echo "<br /><br />";
//heres where I need to stop if picture is null
echo "<img src='../../images/news/";
echo $row["picture"];
echo "' align='left' class='imgspacer-left'>";
echo fixQuotes($row["story"]);

}

//close the connection
mssql_close($dbhandle);
?> 

I have an array which can be empty; in this case, I get error. I want to skip when the array is empty.

When calling the array from file, I use the following code if (file_exists($array_file)) { 
"the doing code"
} else {
echo "File does not exist";
}


How I should use this If Else condition when array comes from a string like  $test_array = explode(', ', $examplestring, -1);

Hi...
i have table
EMP_NO
LOGIN - DATETIME, NULL
LOGOUT - DATETIME, NULL

I have this query:

Code: [Select]
<?php

include 'config.php';

$currentEmpID = $_SESSION['empID']; 
 
 if(!isset($_POST['submit_'])){ 
     
    $DATE1 = $_POST['firstinput'];
    $DATE2   = $_POST['secondinput'];
    
  
 $sql = "SELECT EMP_NO, LOGIN, LOGOUT  FROM employee_attendance WHERE DATE(LOGIN) BETWEEN '$DATE1' AND '$DATE2'";
    $attendance = $conn3->GetAll($sql);
   
    $smarty->assign('attendance', $attendance);

 }
 $smarty->display('header_att.tpl');
 $smarty->display('empAttendance.tpl');
 $smarty->display('footer.tpl');
  
?>

My problem is I have data
EMP_NO 00000223
LOGIN NULL
LGOUT NULL

this data was not displayed because it has a null value.. i want it to displayed also and highlight it because it has a value null..

Thank you

I'm trying to force a NULL value into the database with a hidden value and I can't seem to get it to work.

Any suggestions?

<input type="hidden" name="inactive" value=""/>


I also tried here too:

$sql="UPDATE product SET inactive='NULL' WHERE id = '$item_id'";

I have a php page where user/db info is being passed:


<?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 />';

        }
}



// name of array
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 />';

        }
}

?>


And here is the output from that code:

Added Activities

Exercise
0 : Canoeing, on camping trip
1 : Canoeing, rowing, over 6 mph, vigorous effort
2 : Canoeing, rowing, crewing, competition
3 : Canoeing, rowing, light effort
4 : Canoeing, rowing, moderate effort
5 : Diving, springboard or platform
6 : Kayaking
7 : Sailing, boat/board, windsurfing, general
8 : Sailing, in competition
9 : Skiing, water
10 : Ski-mobiling, water
11 : Skin diving, scuba diving, general
12 : Snorkeling
13 : Surfing, body or board
14 : Swimming laps, freestyle, fast, vigorous effort
15 : Swimming laps, freestyle, light/moderate effort
16 : Swimming, backstroke, general
17 : Swimming, breaststroke, general
18 : Swimming, butterfly, general
19 : Swimming, leisurely, general
20 : Swimming, sidestroke, general
21 : Swimming, sychronized
22 : Swimming, treading water, fast/vigorous
23 : Swimming, treading water, moderate effort
24 : Water polo
25 : Water volleyball
26 : Whitewater rafting, kayaking, or canoeing

Duration
Canoeing, on camping trip : 20
Canoeing, rowing, over 6 mph, vigorous effort :
Canoeing, rowing, crewing, competition :
Canoeing, rowing, light effort :
Canoeing, rowing, moderate effort :
Diving, springboard or platform :
Kayaking :
Sailing, boat/board, windsurfing, general :
Sailing, in competition :
Skiing, water :
Ski-mobiling, water :
Skin diving, scuba diving, general :
Snorkeling :
Surfing, body or board :
Swimming laps, freestyle, fast, vigorous effort :
Swimming laps, freestyle, light/moderate effort :
Swimming, backstroke, general :
Swimming, breaststroke, general :
Swimming, butterfly, general :
Swimming, leisurely, general :
Swimming, sidestroke, general :
Swimming, sychronized :
Swimming, treading water, fast/vigorous :
Swimming, treading water, moderate effort :
Water polo :
Water volleyball :
Whitewater rafting, kayaking, or canoeing :

Distance
Canoeing, on camping trip : 20
Canoeing, rowing, over 6 mph, vigorous effort :
Canoeing, rowing, crewing, competition :
Canoeing, rowing, light effort :
Canoeing, rowing, moderate effort :
Diving, springboard or platform :
Kayaking :
Sailing, boat/board, windsurfing, general :
Sailing, in competition :
Skiing, water :
Ski-mobiling, water :
Skin diving, scuba diving, general :
Snorkeling :
Surfing, body or board :
Swimming laps, freestyle, fast, vigorous effort :
Swimming laps, freestyle, light/moderate effort :
Swimming, backstroke, general :
Swimming, breaststroke, general :
Swimming, butterfly, general :
Swimming, leisurely, general :
Swimming, sidestroke, general :
Swimming, sychronized :
Swimming, treading water, fast/vigorous :
Swimming, treading water, moderate effort :
Water polo :
Water volleyball :
Whitewater rafting, kayaking, or canoeing :

Metric
0 : mile
1 : mile
2 : mile
3 : mile
4 : mile
5 : mile
6 : mile
7 : mile
8 : mile
9 : mile
10 : mile
11 : mile
12 : mile
13 : mile
14 : mile
15 : mile
16 : mile
17 : mile
18 : mile
19 : mile
20 : mile
21 : mile
22 : mile
23 : mile
24 : mile
25 : mile
26 : mile


As you can see, null values are being passed as well. I am hoping that someone can show me the correct way to use php unset to get rid of these null values. Thank you.

Can someone help me to get this code working...

Code: [Select]
public function getBowlContents(){
if is_null($this->contents) {
return "The bowl is empty!";
} else {
return "The bowl contains " . $this->contents . " soup!";
}


TomTees

hi all,

i have a script in where the user enters there post code and it will provide a price for delivery, how would i echo "please contact us for price" if the db record for the price is (null) or empty??


 <?php
mysql_connect ("localhost", "root","password")  or die (mysql_error());
mysql_select_db ("postcode");
$term = $_POST['term'];
$sql = mysql_query("SELECT * FROM uk_postcodes, zones WHERE postcode LIKE '%$term%' AND zone_id = zone_large ");
while ($row = mysql_fetch_array($sql)){
    echo '<br/> Postcode: '.$row['postcode'];
    echo '<br/> Town: '.$row['town'];
    echo '<br/> County: '.$row['county'];
    echo '<br/> Small: &pound;'.$row['price_s'];
    echo '<br/> Medium: &pound;'.$row['price_m'];
    echo '<br/> Large: &pound;'.$row['price_l'];
    echo '<br/><br/>';
    }
    
?>

I have a for loop that I am looping through. When I use var_dump() I get 10 results (which is what I should be getting). However, when I loop through it using a for() loop I am getting an extra 11th value that is blank. What would be causing this? My code is below:

Code: [Select]
$legacy = new Legacy();
// Loop through each film in the shopping cart
for ($i = 0; $i < $myShoppingCartInfo['row_count']; $i++) {
// Determine if the film is of a legacy series
if ($legacy->isLegacyCheckout($myShoppingCartInfo['data']['PRODUCTSKUID'][$i])) {
// Declare array to hold all legacy film entity_id values
$legacyEntityIds = array();
$legacyEntityIds = $legacy->getLegacyEntityIds($myShoppingCartInfo['data']['PRODUCTSKUID'][$i]);
var_dump($legacyEntityIds);
// Loop through all legacy video entity_id's
for ($i = 0; $i < $legacyEntityIds['data']['ENTITY_ID']; $i++) {
// Grant streaming access to each entity id
echo $legacyEntityIds['data']['ENTITY_ID'][$i] . '<br />';
// Insert the product into the order items table
/*$query = "INSERT INTO tblOrderItems (OrderItemID, ProductSKUID, RentalDate, OrderID)
VALUES (##newID##,
'".$myShoppingCartInfo['data']['PRODUCTSKUID'][$i]."',
".($myShoppingCartInfo['data']['RENTALDATE'][$i] === NULL ? 'NULL' :
"'".$myShoppingCartInfo['data']['RENTALDATE'][$i]."'").", ".$newOrderID.")";
$cartItemInserted = counter_id_insert($query,'OrderItemID');
$curr_user->addNewEntityLicense($legacyEntityIds['data']['ENTITY_ID'][$i]);*/
}
}

When I view the source code of the output page in a browser, this is what I see:
array(5) {
  ["row_count"]=>
  int(10)
  ["col_count"]=>
  int(1)
  ["col_names"]=>
  array(1) {
    =>
    string(9) "entity_id"
  }
  ["col_types"]=>
  array(1) {
    =>
    string(3) "int"
  }
  ["data"]=>
  array(1) {
    ["ENTITY_ID"]=>
    array(10) {
      =>
      string(7) "1681799"
      [1]=>
      string(7) "1681872"
      [2]=>
      string(7) "1681871"
      [3]=>
      string(7) "1681870"
      [4]=>
      string(7) "1681869"
      [5]=>
      string(7) "1681868"
      [6]=>
      string(7) "1681867"
      [7]=>
      string(7) "1681866"
      [8]=>
      string(7) "1681865"
      [9]=>
      string(7) "1681864"
    }
  }
}
1681799<br />1681872<br />1681871<br />1681870<br />1681869<br />1681868<br />1681867<br />1681866<br />1681865<br />1681864<br /><br />

How can I change Yes to No for the NULL field in the mysql db structure.


E.g. (Table name: address and Column name : state)
<?php
$link = mysql_connect("localhost","db","pw");
mysql_select_db("db");

mysql_query("alter table address modify state null NO); 
$result = mysql_query($query);
$sent = "Edit Successful.";
echo ($sent);
?>

I'm trying to display the null values only, where am I going wrong?

SELECT IFNULL(trans, 0) AS 'Transactions', customer.cID AS 'Customer ID', customer.surname AS 'Surname'
FROM customer
LEFT JOIN account
ON (account.cID = customer.cID)
WHERE IFNULL(trans, 0);

2 PART QUESTION (so I don't have to ask two questions 😀  )

1.)
My script has tons of PHP variables. Is it better to declare them all at the top of my page like this:
$cat = $words = $day = $lunch = $user = $address = $potato = $_SESSION["goodpeople"] = $dumbquestionList = $b = $hundredMoreVariables = "";
-or-
as needed, like this:
$cat = "";  if($day == 'Thursday') { $cat = 'time_to_feed'; }
$words = "";  $school = array('teachers'=>'boring','lunch'=>'free'); $words = $school['teachers'];
$_SESSION["goodpeople"] = ""; if($_SESSION["goodpeople"] == "" { $_SESSION["goodpeople"] = 'Gandhi'; }

2.)
What are the pros and cons of declaring variables as NULL and using " isset " versus declaring variables as "" and using ==
Example:
$cat = $words = $day = $lunch = $user = $address = NULL;
if( !isset($cat)) { $cat = 'black'; }.........................if(isset($day)) { $sleep = 'none'; }..............etc., etc.
-or-
$cat = $words = $day = $lunch = $user = $address = "";
if($cat == "") { $cat = 'black'; }............................ if($day != "") { $sleep = 'none'; }................etc., etc.

On my particular coding, I can use either the NULL/isset style, or, the ""/== style, with no errors or ill effects.... but something tells me the expert PHP coders prefer one over the other...

Thank you!!

Edited July 10 by ChenXiu

How do I make my constructor work when I don't pass in an argument.  That is, it should efault to null.

Code: [Select]
class Something{
private $type=null;

public function __construct($t){
$this->type = $t;
}

public function setSomething($t){
$this->type = $t;
}

public function getSomething(){
if (is_null($this->type)) {
return "None for you!";
} else {
return "Something is " . $this->type . ".";
}
}
}


TomTees

I have got another of those problems that should be easy to solve but I cannot get my head round it!

I have a form to enter data into a table and one of the fields can be left blank. However, I'd data is entered in the field it can be a Zero. This is leaving me a problem as I cannot find a way to get the script to insert NULL if the field is blank but actually put the Zero in if that is what is entered.

I have tried several permutations of nested if's using empty or isset, but whatever I try, the same result is inserted in both scenarios.

The arguments I need to pass are......
If field is empty INSERT null
If field is 0 INSERT 0
If field is not empty and not 0 INSERT field

Thanks in advance for any suggestions.

Steve

Hello again. I need help for a PHP project I'm working on for school.

I need it to do the following:
1) When nothing is entered, it will echo "Please enter a number."
2) When "0" is entered, it will echo "Please enter a number that is not zero."

My code is as follows...
<form action="hwpositive.php" method="post">
    Enter number <input type="text" name="number"/><br />
    </form>
    
<?php
$input = $_POST['number'];

// if number entered is less than 0
if ($input<0) 
{ 
echo "Enter a positive number.";
}
// if number entered is greated than 1000
elseif ($input>1000)
{ 
echo "Enter a number less than 1000.";
}
// if number entered is not a number (ie, a letter, a character)
elseif (!is_numeric($input))
{
echo "<br><img src=\"squidward.jpg\"><br><br>Enter a valid number. ";
}
// if number entered is between 1-999
elseif (($input>0) && ($input<1000))
{ 
echo "hello world " . $i . "<br />";
}
// if number entered is zero
elseif ($input===0)
{
echo "Please enter a number that is not zero.";
}
// if no number is entered
elseif ($input=null)
{
echo "Please enter a number.";
}

else
{
echo "Please enter a number.";
}
?>

However, it's not working. What am I doing wrong? Everytime I enter this page, it should show me "Please enter a number" because I haven't entered anything yet, but it doesn't. It's showing me the image right away. I don't understand... Help me, please!

Thank you so much in advance. I appreciate the help.

I'm having trouble getting my variable to update the database a NULL value. It keeps giving it the value of zero.

This is what I'm using and I've tried it several different ways without luck.

elseif ($item_fee > "1") {
    $sold = NULL;
}