PHP - Help,get $id If Empy Or Null To Follow The Else If

How can I get robots to follow this mixxed line?:

<td align="left"><?php echo $fieldsFormatted['field_website']; ?></td>

This line outputs the text "Website" with the link to a url depending on row id, but is not followed or index by spiders or crawlers.

Any help is appreciated!

I have a class ServerBridge which is used to proxy browser ajax requests received by a web server to another API server.  To update a record (or create a record is similar):

Browser client makes PUT request to web server. Web server modifies the uri path and passes the body plus headers connection, accept, accept-encoding, accept-language, content-type, content-length only to the API server. The API server does work and returns the location of the resource on itself to the web server. The web server modifies the location header to point to the resource location on itself, and returns all received headers except Date, Server, X-Powered-By, Access-Control-Allow-Origin, Access-Control-Allow-Methods, Access-Control-Allow-Headers to the browser client. Browser client makes another undesired PUT request to web server.

Why is step 5 occurring and how do I prevent it?  I don't really mind the browser client making another request to the resource, but it would need to be GET and not PUT.  Also, is my white-list headers to forward to api server and black-list headers to return to browser client appropriate?

I haven't posted the ServerBridge script (but can if needed), but did include the requests and headers related to the browser client, web server, and api server below.

Browser client JavaScript

$('.edit-record').simpleEdit('/api/accounts');

jQuery.fn.extend({
    simpleEdit: function(url, options) {
        var dOptions={type: 'text', ajaxOptions: {type: "PUT"}, placement: 'right', send: 'always' };
        options=options?options:{};
        return this.each(function() {
            var $t=$(this);
            var o=Object.assign({
                url: url+'/'+$t.closest('tr').data('id'),
                title: 'Enter '+$t.data('name')
            }, dOptions, options);
            $t.editable(o);
        });
    }
});

Web-server index.php

$c['serverBridge'] = function ($c) {
    return new \Greenbean\ServerBridge\ServerBridge(
        new \GuzzleHttp\Client([
            'base_uri' => $c['settings']['server']['scheme'].'://'.$c['settings']['server']['host'],
            'headers' => ['X-Secret-Key' => $c['settings']['server']['key']],
            'timeout'  => 30,
            'allow_redirects' => false,
        ]),
        new \Greenbean\ServerBridge\SlimHttpClientHandler()
    );
};

$app->put('/api/accounts/{id:[0-9]+}', function (Request $request, Response $response) {
    return $this->serverBridge->proxy($request, $response,
        function(string $path):string{
            return substr($path, 4);       //Remove "/api" from uri
        },
        function(array $headers):array{
            if(!empty($headers['Location'])) {
                $headers['Location'] = ['/api'.$headers['Location'][0]];  //Add "/api" to redirect header if it exists
            }
            return $headers;
        }
    );
});
$app->POST('/api/accounts/{id:[0-9]+}', function (Request $request, Response $response) {/*Similar to PUT*/});

 

<?php

class ServerBridge
{
    public function __construct(\GuzzleHttp\Client $httpClient, ?HttpClientHandlerInterface $httpClientHandler=null){
        $this->httpClient=$httpClient;
        $this->httpClientHandler=$httpClientHandler;    //Whether to use Slim or Sympony HTTP requests and responses
    }

    public function proxy($clientRequest, $clientResponse=null, \Closure $modifyPath=null, \Closure $modifyHeaders=null) {
        //Accept a Slim or Sympony HTTP request, forward it to API server via cURL, and return the cURL response
        //$modifyPath will modify REQUEST_URI before sending to API server 
        //$modifyHeaders will modify response headers before sending to calling client 
        return $response;
    }
}

API Server index.php

$app->put('/accounts/{id:[0-9]+}', function (Request $request, Response $response, $args) {
        $this->accounts->update($args['id'], $request->getParsedBody());
        return $response->withRedirect('/accounts/'.$args['id'], 302);
});

$app->post('/accounts', function (Request $request, Response $response) {
        $account = $this->accounts->create($request->getParsedBody());
        return $response->withRedirect('/accounts/'.$account['id'], 302);
});

Browser Client
    Request URL:https://admin.tapmeister.com/api/accounts/1974750116
    Request method:PUT
    Remote address:73.108.50.132:443
    Status code:302
    Version:HTTP/1.1
    Request headers (477 B)    
        Raw headers
        Accept    */*
        Accept-Encoding    gzip, deflate, br
        Accept-Language    en-US,en;q=0.5
        Connection    keep-alive
        Content-Length    30
        Content-Type    application/x-www-form-urlencoded; charset=UTF-8
        Cookie    PHPSESSID=d11m0k37mf3veaeg0rs350rvkp
        Host    admin.tapmeister.com
        Referer   https://admin.tapmeister.com/
        User-Agent    Mozilla/5.0 (Windows NT 10.0; …) Gecko/20100101 Firefox/68.0
        X-Requested-With    XMLHttpRequest
    Response headers (408 B)    
        Cache-Control no-store, no-cache, must-revalidate
        Connection Keep-Alive, Keep-Alive
        Content-Length 0
        Content-Type text/html; charset=UTF-8
        Date Sat, 31 Aug 2019 16:18:47 GMT
        Expires    Thu, 19 Nov 1981 08:52:00 GMT
        Keep-Alive    timeout=5, max=100
        Location    /api/accounts/1974750116
        Pragma    no-cache
        Server    Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips
        X-Powered-By    PHP/7.3.9

Web Server
    PUT admin.tapmeister.com/api/accounts/1974750116  REDIRECT_STATUS: 200 REDIRECT_URL: /api/accounts/1974750116
    Request headers
        Cookie: PHPSESSID=d11m0k37mf3veaeg0rs350rvkp
        Connection: keep-alive
        Content-Length: 30
        X-Requested-With: XMLHttpRequest
        Content-Type: application/x-www-form-urlencoded; charset=UTF-8
        Referer: https://admin.tapmeister.com/
        Accept-Encoding: gzip, deflate, br
        Accept-Language: en-US,en;q=0.5
        Accept: */*
        User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0
        Host: admin.tapmeister.com
    Response headers    
        Date: [Sat, 31 Aug 2019 16:18:47 GMT],
        Server: [Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips],
        X-Powered-By: [PHP/7.3.9],
        Location: [/accounts/1974750116],
        Content-Length: [0],
        Access-Control-Allow-Origin: [*],
        Access-Control-Allow-Methods: [GET, POST, PUT, DELETE, OPTIONS],
        Access-Control-Allow-Headers: [X-Secret-Key, Origin, X-Requested-With, Content-Type, Accept],
        Keep-Alive: [timeout=5, max=100],
        Connection: [Keep-Alive],
        Content-Type: [text/html; charset=UTF-8]

API Server
    PUT api.admin.tapmeister.com/accounts/1974750116 REDIRECT_STATUS: 200 REDIRECT_URL: /accounts/1974750116
    Request headers
        Content-Length: 30
        Accept: */*
        Accept-Language: en-US,en;q=0.5
        Accept-Encoding: gzip, deflate, br
        Content-Type: application/x-www-form-urlencoded; charset=UTF-8
        Connection: keep-alive
        Host: api.admin.tapmeister.com
        User-Agent: GuzzleHttp/6.3.3 curl/7.29.0 PHP/7.3.9
        X-Secret-Key: secretKey
 

Edited August 31, 2019 by NotionCommotion

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

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

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

 

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

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

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

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

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