PHP - Set The Value As Null And Not As String Null When Updating The Database

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

 
My code;

$sql = "SELECT SUM(IF(`submitdate` IS NULL , 1 , 0 )) as 'Survey Started But Not Completed' FROM `survey_$surveyid`";
$statement = $dbh->prepare($sql);
$statement->execute();
$result = $statement->fetch(PDO::FETCH_OBJ); //pass that data to an object

Is returning;
 

stdClass Object
(
    [Survey Started But Not Completed] => 
)


I need to set this to a vaule that I can actually print out on the screen... Like a "0" for example. At the moment it is just a NULL.
 
How do I do this??
 
These don't work;
 

$result  = 0;

$result = array(['Survey Started But Not Completed'] => "0");

 

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);

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.

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 />

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'";

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 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);
?>

Good morning,   I am trying to convert a mssql query into json format so that I can then later pass this through google's visualisation api. The query and encoding seems to be working but the encode returns NULL.   I have checked the normal gotcha's of making sure its utf8 encoded and that I have used a version of PHP that has the encode (using php 5.3.19).   Can any one help me with getting the encode to work.   PHP CODE:     <?php

Need some help finding out why this is returning a null result set:   The below code is giving me a result set of an integer set to "0" (the id), a "word"and "def" both set to NULL. It's failing at my "Error #2" point. var_dumps on $id, $word, and $def all give the null output. Each $category is being shown when I var_dump($category).   I know this shouldn't be the case because when I run this straight in PHPMyAdmin I get a non-null result set.   (Not sure why my indentation is not carrying over to the forum. Sorry about that.)

<?php
session_start();
if(!isset($_SESSION['loopcatch']) || $_SESSION['loopcatch']==null || !is_int($_SESSION['loopcatch'])){
$_SESSION['loopcatch']=0;
}
if($_SESSION['loopCatch'] > 1){
//Email error
die();
}
require 'dbConnect.php';
$categories=array('business', 'music', 'film', 'drum');
//Pull Quotes
//Query to Pull random quote
$mainQuery="SELECT `r1`.`id`, `r1`.`word`, `r1`.`def` FROM `dictionary` AS `r1` JOIN (SELECT (RAND() * (SELECT MAX(`id`) FROM `dictionary`)) AS `id`) AS `r2` WHERE `r1`.`id` >= `r2`.`id` AND `category`=? AND `checked`=0 ORDER BY `r1`.`id` ASC LIMIT 1";
//prepare quotes query
if($prepareQuote=mysqli_prepare($conn, $mainQuery)){
//filter through each category
foreach($categories as $category){
//Bind the variable to the quotes query
mysqli_stmt_bind_param($prepareQuote, "s", $category);
//execute quotes statement
mysqli_stmt_execute($prepareQuote);
//Store quotes result set
mysqli_stmt_store_result($prepareQuote);
//Check how many rows are returned
if(mysqli_stmt_num_rows($prepareQuote) > 0){
//Bind results to variables
mysqli_stmt_bind_result($prepareQuote, $id, $word, $def);
//If $id, $word, or $def is null abort and email error
if(!is_null($id) && is_numeric($id) && !is_null($word) && !is_null($def)){
while($row=mysqli_stmt_fetch($prepareQuote)){
mysqli_autocommit($conn, FALSE);
//Input into second table
$updateQuery="UPDATE `quotes` SET `word`=?, `def`=? WHERE `category`=?";
//prepare insert query
if($updateQuote=mysqli_prepare($conn, $updateQuery)){
//Bind the variables to the insert query
mysqli_stmt_bind_param($updateQuote, "sss", $word, $def, $category);
//execute insert statement
mysqli_stmt_execute($updateQuote);
//Store insert quote result set
mysqli_stmt_store_result($updateQuote);
//Check how many rows are returned on insert quote query
if(mysqli_stmt_affected_rows($updateQuote) > 0){
//If query run sucessfully insert and update; if not rollback.
//mark quote checked
$checkedQuery="UPDATE `dictionary` SET `checked`=1 WHERE `id`=?";
//prepare checked query
if($checkedQuote=mysqli_prepare($conn, $checkedQuery)){
mysqli_stmt_bind_param($checkedQuote, "i", $id);
//execute checked statement
mysqli_stmt_execute($checkedQuote);
//Store checked quote result set
mysqli_stmt_store_result($checkedQuote);
//Check how many rows are returned on checked quote query
if(mysqli_stmt_affected_rows($checkedQuote > 0)){
mysqli_commit($conn);
}
else{
echo 'Error #6 ';
mysqli_rollback($conn);
}
}
else{
echo 'Error #5';
//Email error
die();
}
}
else{
echo 'Error #4';
mysqli_rollback($conn);
}
}
else{
echo 'Error #3';
//Email error
die();
}
}
}
else{
echo 'Error #2';
//Query returned blank result set - Email Error
}
}
else{
//If zero rows returned, uncheck rows in table for that specific category and re-run the query.
$uncheckQuery="UPDATE `dictionary` SET `checked`=0 WHERE `category`=?";
if($uncheckQuotes=mysqli_prepare($conn, $uncheckQuery)){
//Bind the variable to the query
mysqli_stmt_bind_param($uncheckQuotes, "s", $category);
//execute statement
mysqli_stmt_execute($uncheckQuotes);
//Store result set
mysqli_stmt_store_result($uncheckQuotes);
//Check how many rows are returned
if(mysqli_stmt_affected_rows($uncheckQuotes) > 0){
$_SESSION['loopCatch']++;
header("Location: ./pullDailyQuotes.php");
}
else{
//Email error
}
}
}
}
}
else{
//Email error
echo 'Error #1';
die();
}
?>

Edited by HDRebel88, 01 June 2014 - 08:54 PM.

will this code check if value is null 

Code: [Select]
if($_SESSION["cart"] != null)

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 am using PDO to run query's and get data. How do I check if the PDO query returned a null value. I tried empty but that doesn't work because PDO array will always contain an SQL query. I want to check if the return value of that query is NULL . Help please.

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

cant figure out how to get this script to post a message if no results are found. please help to new at this.