PHP - $row['index Here'] Outputs Null

I have a piece of code that outputs json as you can see from the example below it add \ / in front of urls & for ' it turns it into ' is there something i can do to correct this?

Code: [Select]
if (mysqli_num_rows($r) > 0) { // Available.
 
    while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {
   
$results[] = array(
      'blog_id' => ($row['ID']),
          'post_date' => ($row['pd']),
'post_title' => ($row['post_title']),
'article_img' => ('http://www.socialnewsoffice.com/uploads/'.$row['article_img']),
'post_content' => ($row['post_content']),
'tags' => ($row['tags']),
'views' => ($row['views']),
'categorie_id' => ($row['categorie_id']),
'post_url' => ($row['post_url']));
    }
echo $json = Pretty_JSON(json_encode($results));

it outputs

Code: [Select]
[{
"blog_id":"3",
"post_date":"Thu, 1 March 2012",
"post_title":"Facebook's New Fan Page Learn How To Use Features",
"article_img":"http:\/\/www.socialnewsoffice.com\/uploads\/17963.jpg",
"post_content":"<p>This week saw the release of Facebook's latest functionality changes (Timeline for Businesses) that will shape the future of how businesses will market their campaigns, through the social media giant Facebook. A number of marketers are wondering how they will incorporate the new features in an attempt to progress and move forward with their online social media presence.<\/p>\r\n<p>Taking all the key changes in to consideration we have managed to create a guide on how to smoothly move with the times and embrace the new Facebook layout.<\/p>\r\n<p>Please read on below for helpful tips and tricks on how to excel with 'Timeline for Brands'<\/p>\r\n<h2>New Features Announced at the Facebook Marketing Conference:<\/h2>\r\n<p><strong>View and Apps:<\/strong> What was once known as Application pages has changed to 'Tabs'. These can now have customizable images linked with them and the order of them can be changed too. Below you can see from the screenshot what a customized Facebook Timeline looks like.<\/p>\r\n<p><strong>Pinning Content:<\/strong> With this new feature you can 'pin' a post to the very top of your Facebook Timeline. This is Very effective when working on a new campaign and is a great way to entice increased traffic to your tab or application page.<\/p>\r\n<p><strong>Featured 'Starred' Content:<\/strong> This feature allows you to select key content or imagery and extend it so it fits across your entire page. Therefore giving you featured content on your Facebook Timeline and making it more visible.<\/p>\r\n<p><strong>Cover Photos:<\/strong> Cover Photos are another great new feature that allow you to announce your latest campaign, welcome your following community or just simply show visitors to your timeline what you can do. There are some slight flaws with this feature though and will be addressed below.<\/p>\r\n<p><strong>Page Dimensions:<\/strong> Dimensions of application pages has now changed with the release of Facebook Timeline. If you happen to be an SML user then you have all the tools necessary to update your page on your own. If your using Involvers App Suite then those applications will be updated soon.<\/p>\r\n<p><strong>Removal of Default Landing Pages:<\/strong> The commonly used Facebook landing pages have been removed and replaced with various options to allow brands to drive content to application pages. These options allow you to use your cover photo and pinned content to attract users to your personal application pages. Despite the changes it is however still possible to link directly to application pages from ads, posts and outside of Facebook.<\/p>\r\n<h2>Getting Started with Timeline For Brand:<\/h2>\r\n<p>Firstly when accessing and logging in to your New Facebook Brand Page, you will see this admin message displayed below:<\/p>\r\n<p>When will my Page change to the latest design?<\/p>\r\n<p>To see a preview of what your new pages will look like, simply click on the green button at the top of your current pages. A second option is to wait until March 30th 2012 when all pages will be upgraded automatically.<\/p>\r\n<p>Where can I visit to learn more about how to use the new Pages?<\/p>\r\n<p><strong>There are a number of places you can visit to learn all you need to know about Pages:<\/strong><\/p>\r\n<ul>\r\n<li>To find out more about new features, download the Pages Overview guide by clicking here.<\/li>\r\n<li>If your wondering how to get started with Pages then download Facebook's full Pages Product Guide by clicking here.<\/li> \r\n<li>The Pages Learning video allows you to walk through the key features with Facebook's product experts.<\/li> \r\n<li>If you need answers to specific questions, visit Facebook's Help Centre. <\/li>\r\n<\/ul>\r\n<h2>How should I choose a cover photo for my Page?<\/h2>\r\n<p>Firstly select a unique image that represents your page. Facebook itself recommends using a photo of a popular menu item, album artwork or an image of your product being used by someone. You need to experiment with a number of different images that your audience responds positively to. \r\nFew key elements of Cover Images:\r\n<\/p>\r\n<p><strong>Each Cover image must be at least 399 pixels wide and must not contain the following:<\/strong><\/p>\r\n<ul>\r\n<li>Prices \/ Purchase information and displaying offers such as \"60% off this month\" are not permitted. Also 'Download this from our website' is not allowed.<\/li> \r\n<li>No email addresses, web addresses and any other contact information.<\/li>\r\n<li>References to clicking on or the use of Facebook interface elements such as Like or Share or any other Facebook Features.<\/li>\r\n<li>\"Tell your friends\" or \"Get it now\" or any other calls to action are not allowed in the latest version of Facebook Timeline.<\/li>\r\n<\/ul>\r\n<p>All Timeline cover imagery is public and therefore means anyone visiting your Page will be able to see exactly which image you have chosen. The photos you display must not be deceptive, false or misleading any way that infringes on third party intellectual property. You must also not encourage of incentivize other fellow users, friends or business associates to display the same cover image as yours on personal Timelines.<\/p>\r\n<p>To sum up we are extremely excited about the latest Facebook feature release this week. They constantly deliver new services that are amazing and incredibly innovative to the market place.<\/p>\r\n<p>Here at Northplanet we are commited to provide you with the latest information on the hottest online topics around, to keep you ahead in the game. We would love to hear some feedback from you on the brand new Facebook 'Timeline for Brands' release and invite you to visit our very own <a href=\"https:\/\/www.facebook.com\/northplanet\">Northplanet Facebook Timline page by clicking here.<\/a><\/p>",
"tags":"facebook, new fan page",
"views":"253",
"categorie_id":"2",
"post_url":"facebooks-new-fan-page-learn-how-to-use-features"
}

Sorry if this is a silly question lol.

I want to know if there is an online tool I can use to check and see what PHP code will ouput server side.

For example:

<?php
$tomorrow  = mktime(0, 0, 0, date("m")  , date("d")+1, date("Y")); ?>

Hi,

I've inherited a website with a problem! Basically the site runs pommo mailing list, which has worked fine for years. Recently though the website domain name changed. Since then - or at least at a similar time - pommo has just stopped working completely. It does nothing but outputs blank pages.

I've never done any php development so I've no idea where to start in terms of debugging this. I've checked that the files etc all exist on the server: they do. I've uploaded a test html page which works. I've uploaded a test php page containing: <?php phpinfo( ); ?> and it works. But when I visit any  page in the pommo application, the browser just renders a totally empty white page - no source HTML at all, just nothing!

Can anyone suggest how to debug this? Even an error message would be somewhere to start.

Thanks all!

I really dont no what the problem is and im new here so i dont no if this is the right place to put this but im trying to make a registration page for my server and when i bring it up it says Undefined index: action in C:\xampp\htdocs\index.php on line 56   and idk what to do >.<
this is the line that has the problem

if($_POST['action']!="signup")

so hopefully u guys could help me :/ Im using xampp btw

Hi there,

I was wondering if there is a way to display content on only my index.php page? I believe there is a way and I have done it before, but some of my pages use index.php?category etc.

Is there a way to show content just on index.php and not on any dynamic pages?

Thanks

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

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

 
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

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