PHP - Php If Null, End Help

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

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.

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

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

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

 

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

Okay, so, I have a script that allows a forum inside of a room in a game.

If you want a forum, you mark Yes from a dropdown menu inside the editing portion of the room. It will then save that room's title into a field called `board` in the database.

However, when you mark No from the dropdown, it still leaves it in there. I don't want this. I want it to change to NULL.

How do I go about doing this?

Here's my current coding:


if (!islevel($p,$co)) newlevel($p,$co);
setlevel($p,$co,"title",filter(stripslashes($title)));
setlevel($p,$co,"board",filter(stripslashes($title)));
}


Explanations:
setlevel just connects to the database and inserts these values.
$title is obviously the title of the room
$co = coordinates for the room

Here is the editing page, where the dropdown menu is:


<table width=100% style=text-align:center><tr>
<td>BOARD:<br />
<select name=b>
  <option value=0>No</option>
  <option value=1 <? if ($b == 1) echo "selected"
  ?>>Yes</option></select><br />Was <?=$b?>
</tr></table>

Greetings folks,

I've tried searching on this but couldn't find anything which I think is odd since I'm sure I'm not the first person with this question...


I have a project that is basically a big (really big) form.  When the user hits submit they get a CSV file. My client will then import the CSV into their database.  The CSV is made up of two lines, the first being field names and the second line being the field values.  Both the names and values are pulled from $_POST.

The CSV looks like this:

"Name","Age","Favorite Color"
"Bob","12","Purple"

The problem I having is if the user skips a question, let's say Age for this example, the CSV will look like this:

"Name","Age","Favorite Color"
"Bob","Purple"

The clients database then freaks when it sees the value for Age is Purple.  So my question is, how does one handle null values from from $_POST to avoid such an issue?

Thank you!  Thank you!  Thank you! 

Is there a better way to have array_intersect_key() return only non-NULL values?  Thanks

    function stripAssociatedArray(array $array, array $keys, bool $removeNull=false):array
    {
        $array = array_intersect_key($array, array_flip($keys));
        return $removeNull?array_filter($array, fn($value) => !is_null($value)):$array;
    }

 

if ($rowcats->followersrange == "2000-5000")
    {
    $lowrange2000 = "2000";
    $lowestrange = $lowrange2000;
    $numberpeople = $rowcats->numberpeople;
    }
    if ($rowcats->followersrange == "5000-10000")
    {
    $lowrange5000 = "5000";
    if ($lowrange5000 < $lowestrange) { 
    $lowestrange = $lowrange5000; 
    $numberpeople = $rowcats->numberpeople;}
    }

    if ($rowcats->followersrange == "10000-15000")
    {
    $lowrange10000 = "10000";
    if ($lowrange10000 < $lowestrange) { 
    $lowestrange = "$lowrange10000"; 
    $numberpeople = $rowcats->numberpeople;}
    if ($lowestrange == NULL) { echo "yes";}
    echo "$lowestrange";
    }
    if ($rowcats->followersrange == "15000-20000")
    {
    $lowrange15000 = "15000";
    if ($lowrange15000 < $lowestrange) { $lowestrange = $lowrange15000;$numberpeople = $rowcats->numberpeople;}
    }

We are trying to find the lowest range from the entries added to a database, so at the end, we can say the range is FROM... TO...

They might opt for 2-5k, or 5-10k etc.

If they opt for 10-15k, then the lowest range is 10,000.

We have a result of 10000 - 15000.  So the $lowrange10000 = "10000".

Therefore, this should be echoing the $lowestrange from 7th line up in this code, but it remains at NULL, based on:

$lowestrange = NULL;, set at the top of the code.

Why is that?

hi

i have this code:

Code: [Select]
<script type="text/javascript">
$(document).ready(function() {

function doAjax(url) {
    $("#customForm").submit(function() {
        var formdata = $("#customForm").serializeArray();
        $.ajax({
            url: url,
            type: "post",
            dataType: "json",
            data: formdata,
            success: function(data, data1) {

                switch (data.livre) {

                case 'tituloLivre':
                    $("#msgbox2").fadeTo(200, 0.1, function() {
                        $(this).html('Titulo Livre').fadeTo(900, 1);
                    });
                    break;
                   
                default:
                    $("#msgbox2").fadeTo(200, 0.1, function() {
                        $(this).html('Active a sua conta e pode efectuar o login!').fadeTo(900, 1, function() {
                        $('#conteudo').load('dojo/test_Slider.php');

                        });
                    });
                    break;
                }
            }
        });
        return false;         
    });
}
doAjax('sent.php');
doAjax('dojo/test_Slider.php');   
});
</script>
and test_Slider.php

Code: [Select]
<?php
include ('includesMy.php');
$form = $_POST['item'];
$oferta = $form['oferta'];

var_dump($oferta);
echo json_encode ($oferta);
?>
 i should load the php file with ajax influence, but when i made load (test_Slider.php) obviously i get null because is independent of ajax call.

My question is, how can i load a whole php file that is changed by ajax call ?  (json return is not the solution because i have much more content, like graphics elements in test_Slider.php)

Hello   I am having an issue with encoding an array to JSON, my array seems to be formed correctly but when I try and echo the json_encode version I get "null". I echo the JSON error code and it is "0" indicating no issue..    I have read that non UTF-8 characters can be an issue, but this is simple data, no strange characters... but I added the utf8_encode anyway....   Here is my code:

$dataArray = array( 
 
'title' => 'Test Item',
'icon_url' => 'http://url/api/testimage.jpg',
'item_id' => '12345',
'expiration' => 600 
);
 
utf8_encode($dataArray);
 
$responsArray = array( 
 
'success' => '1',
'data' => $dataArray
);
 
 
utf8_encode($responsArray);
 
header('Content-type: application/json');
 
echo print_r($responsArray);
echo json_encode ($responseArray);
echo json_last_error();
 

 

Dont understand why...my database is displayed correctly but cant seem to add edit delete etc, I just get the error above.   Any clues please