PHP - Null Session Array Condition Not Met Until Page Is Refreshed

i have a problem i just noticed....i've built a shopping cart that totals quantities of items and shipping etc then a submit button to a payment page... but if a user refreshes the same page after first coming to the cart page it messes up all the totals and data.....

i know this has to be a common problem with webpages... does anyone have any advice on combating this issue? any advice is much appreciated..thanks!

I have the following code that queries the database for the results of a quiz.
The display reports on completed quizzes, showing, line by line, the quiz title, the date of the quiz, an image of a green tick if the quiz result was correct or an image of a red cross for an incorrect result and a fractional result shoratio of correct answers.
A student can repeat a quiz numerous times, and therefore his results for a particulat quiz can display several rows with green ticks and red crosses for the same test done at different times with differing results.
I want to recode this so that the red crosses for incorrect results will no longer display once a student achieves a green tick result.

I've had several goes at this but my results are less than encouraging.
Can anyone help?
Do I tackle this through an altered query, or should I include conditions in the display of the array?
Code: [Select]
<?php
$query1 = mysql_query("SELECT DISTINCT quizTitle, userId, passState, userScore, totalScore, DATE_FORMAT(userDate,'%b %e, %Y') AS userDate FROM quiz WHERE managerId = '$managerId' AND userId = '$userId' ORDER BY quizTitle, userDate ASC"); 

while ($row = mysql_fetch_array($query1))
{ 
         echo "{$row['quizTitle']} <br />\n";
         echo "{$row['userDate']} <br />\n"; 
         if ("{$row['passState']}" == 1) {echo "<img src=' ../../wood/wood_tool_images/tick2.png' /><br />\n";}
         if ("{$row['passState']}" == 0) {echo "<img src=' ../../wood/wood_tool_images/cross2.png' /><br />\n";} 
         echo "{$row['userScore']}".'/'."{$row['totalScore']}
?>

I'm a bit of a newb to PHP and MySQL. I seem to be having an issue with something. How do I loop through an array, querying each value in the array until the query meets a certain condition.. In this case it would be that the number of rows returned from the query is less than five. Here is what I have:

$query1="SELECT UserID FROM Users where RefID='$userid'";
$result1=mysql_query($query1);
while ($row = mysql_fetch_array($result1, MYSQL_NUM) && $sql2querynum < '5')
{
echo ($row[0]);
echo "
";
$sql2 = "SELECT * FROM Users WHERE RefID=$row[0]";
$sql2result = mysql_query($sql2);
$sql2querynum = mysql_numrows($sql2result);
}
Problem is, for every value it echoes out, I get the following warning:
mysql_numrows(): supplied argument is not a valid MySQL result resource

Like I said, I'm a newbie to PHP to maybe I'm not even going about doing this the right way. Hoping someone can help to point me in the right direction.

hello i have a mysql table and i want to display each row in a different page with an added condition, the code:
Code: [Select]
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; };
  $start_from = $page-1;

$qry="SELECT * FROM ordering WHERE userid='$page' AND email='$email' LIMIT 0,1";
$result = mysql_query($qry);
while($row = mysql_fetch_array($result)){

echo     "<div dir='rtl' charset='utf8'><h2>"," hover cam: ",$row['hover_camera'],
"<br> stills: ",$row['stills'],
"<br> video_photographers: ",$row['video_photographers'],
"<br> increase: ",$row['increase'],
"<br> video_edit: ",$row['video_edit'],
"<br> digital_album: ",$row['digital_album'],
"<br> photo_album: ",$row['photo_album'],
"<br> small_digital_album: ",$row['small_digital_album'],
"<br> video_clip: ",$row['video_clip'],
"<br> magnets: ",$row['magnets'],
"<br> comments: ",$row['comments'],
"<br> date: ",$row['date'],
"<br><br></h2></div>";

}
$sql = "SELECT COUNT(userid) FROM ordering";
$result = mysql_query($sql,$link);
$row2 = mysql_fetch_row($result);
$total_records = $row2[0];
$total_pages = $total_records ;
 
for ($i=1; $i<=$total_pages; $i++) {
            echo "<a href='myorders.php?page=".$i."'>".$i."</a> ";
};
the table is as so:
Code: [Select]
CREATE TABLE IF NOT EXISTS `ordering` (
  `userid` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `hover_camera` varchar(10) DEFAULT NULL,
  `stills` int(5) NOT NULL,
  `video_photographers` int(5) NOT NULL,
  `increase` int(5) NOT NULL,
  `video_edit` varchar(10) NOT NULL,
  `digital_album` varchar(10) DEFAULT NULL,
  `photo_album` varchar(10) DEFAULT NULL,
  `small_digital_album` varchar(20) DEFAULT NULL,
  `video_clip` varchar(10) DEFAULT NULL,
  `magnets` int(10) NOT NULL,
  `comments` text NOT NULL,
  `date` date NOT NULL,
  `fname` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  PRIMARY KEY (`userid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
now to the problem: this code displays all the userid as page numbers however, the email condition is good only for part of the rows
it's a little hard to explain, i'll try an example: suppose the email '1@1.com' is at rows 22,25 and 30 my code displays 30 page numbers and page 22 is user 22, page 25 is user 25 etc. what i want is to display only the page numbers of  the pages with the conditional email, and if possible to display them as 1,2,3 instead of 22,25,30

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

Hello

I'm trying to remove null ou 0 values from my array but i can't get it to work properly

This is my array

 

Array ( [0] => Array ( [0] => 2020-09-21 [1] => 3 ) [1] => Array ( [0] => 2020-09-23 [1] => 2 ) [2] => Array ( [0] => 2020-09-28 [1] => 3 ) [3] => Array ( [0] => 2020-09-30 [1] => 2 ) [4] => Array ( [0] => 2020-10-07 [1] => 2 ) [5] => Array ( [0] => 2020-10-12 [1] => 3 ) [6] => Array ( [0] => 2020-10-14 [1] => 2 ) [7] => Array ( [0] => 2020-10-19 [1] => 3 ) [8] => Array ( [0] => 2020-10-21 [1] => 2 ) [9] => Array ( [0] => 2020-10-26 [1] => 3 ) [10] => Array ( [0] => 2020-10-28 [1] => 2 ) [11] => Array ( [0] => 2020-11-02 [1] => 3 ) [12] => Array ( [0] => 2020-11-04 [1] => 2 ) [13] => Array ( [0] => 2020-11-09 [1] => 3 ) [14] => Array ( [0] => 2020-11-11 [1] => 2 ) [15] => Array ( [0] => 2020-11-16 [1] => 3 ) [16] => Array ( [0] => 2020-11-18 [1] => 2 ) [17] => Array ( [0] => 2020-11-23 [1] => 3 ) [18] => Array ( [0] => 2020-11-25 [1] => 2 ) [19] => Array ( [0] => 2020-11-30 [1] => 3 ) [20] => Array ( [0] => 2020-12-02 [1] => 2 ) [21] => Array ( [0] => 2020-12-07 [1] => 3 ) [22] => Array ( [0] => 2020-12-09 [1] => 2 ) [23] => Array ( [0] => 2020-12-14 [1] => 3 ) [24] => Array ( [0] => 2020-12-16 [1] => 2 ) [25] => Array ( [0] => 2021-01-04 [1] => 3 ) [26] => Array ( [0] => 2021-01-06 [1] => 2 ) [27] => Array ( [0] => 2021-01-11 [1] => 3 ) [28] => Array ( [0] => 2021-01-13 [1] => 2 ) [29] => Array ( [0] => 2021-01-18 [1] => 3 ) [30] => Array ( [0] => 2021-01-20 [1] => 2 ) [31] => Array ( [0] => 2021-01-25 [1] => 3 ) [32] => Array ( [0] => 2021-01-27 [1] => 2 ) [33] => Array ( [0] => 2021-02-01 [1] => 3 ) [34] => Array ( [0] => 2021-02-03 [1] => 2 ) [35] => Array ( [0] => 2021-02-08 [1] => 3 ) [36] => Array ( [0] => 2021-02-10 [1] => 2 ) [37] => Array ( [0] => 2021-02-17 [1] => 2 ) [38] => Array ( [0] => 2021-02-22 [1] => 3 ) [39] => Array ( [0] => 2021-02-24 [1] => 2 ) [40] => Array ( [0] => 2021-03-01 [1] => 3 ) [41] => Array ( [0] => 2021-03-03 [1] => 2 ) [42] => Array ( [0] => 2021-03-08 [1] => 3 ) [43] => Array ( [0] => 2021-03-10 [1] => 2 ) [44] => Array ( [0] => 2021-03-15 [1] => 3 ) [45] => Array ( [0] => 2021-03-17 [1] => 2 ) [46] => Array ( [0] => 2021-03-22 [1] => 3 ) [47] => Array ( [0] => 2021-03-24 [1] => 2 ) [48] => Array ( [0] => 2021-04-05 [1] => 3 ) [49] => Array ( [0] => 2021-04-07 [1] => 2 ) [50] => Array ( [0] => 2021-04-12 [1] => 3 ) [51] => Array ( [0] => 2021-04-14 [1] => 2 ) [52] => Array ( [0] => 2021-04-19 [1] => 3 ) [53] => Array ( [0] => 2021-04-21 [1] => 2 ) [54] => Array ( [0] => 2021-04-26 [1] => 3 ) [55] => Array ( [0] => 2021-04-28 [1] => 2 ) [56] => Array ( [0] => 2021-05-03 [1] => 3 ) [57] => Array ( [0] => 2021-05-05 [1] => 2 ) [58] => Array ( [0] => 2021-05-10 [1] => 3 ) [59] => Array ( [0] => 2021-05-12 [1] => 0 ) [60] => Array ( [0] => 2021-05-17 [1] => 3 ) [61] => Array ( [0] => 2021-05-19 [1] => 0 ) [62] => Array ( [0] => 2021-05-24 [1] => 3 ) [63] => Array ( [0] => 2021-05-26 [1] => 0 ) [64] => Array ( [0] => 2021-05-31 [1] => 3 ) [65] => Array ( [0] => 2021-06-02 [1] => 0 ) [66] => Array ( [0] => 2021-06-07 [1] => 3 ) [67] => Array ( [0] => 2021-06-09 [1] => 0 ) [68] => Array ( [0] => 2021-06-14 [1] => 1 ) [69] => Array ( [0] => 2021-06-16 [1] => 0 ) [70] => Array ( [0] => 2021-06-21 [1] => 0 ) [71] => Array ( [0] => 2021-06-23 [1] => 0 ) [72] => Array ( [0] => 2021-06-28 [1] => 0 ) [73] => Array ( [0] => 2021-06-30 [1] => 0 ) )

And i'm using this code to remove but no success

print_r(array_values(array_filter($cronograma)));

 

Any help please

 

Thanks

i am trying to check if the array element (which would be a file) is null or not.  when i run it, uploading one file, it says "Please select some files to upload first!" X 3.  what am i doing wrong?

my code: http://pastebin.com/m0k3fEd2

I am trying to get a user details from the database and compare it with the posted value. Now I get Trying to access array offset on value of type null in. The column name user_number exists in the database. This is my code below.. Thanks!!!

     <?php
     mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

     error_reporting(E_ALL | E_WARNING | E_NOTICE);

     ini_set('display_errors', TRUE);

      if (session_status() == PHP_SESSION_NONE) {
  session_start();

    }
     if(!isset($_SESSION['login']))
     {
     echo ("<script>location.href='../clogin/'</script>");
     die();
     }

     if (isset($_POST['submit'])) 
      {
      

        include_once('db.php');
       //get post details from user
             
        $UserNumber = $_POST['uNumber'];

        $sql = "SELECT * FROM customer WHERE user_number=?";   
        $stmt = $connection->prepare($sql); 
        $stmt->bind_param('i', $UserNumber);
        $stmt->execute();
        $result = $stmt->get_result();
        $count =  $result->num_rows;
      if($count == 1)
       { 
   
       while($row = $result->fetch_assoc());

         {


         $db_Uno = $row['user_number'];

           if($userNumber !== $db_Uno) 
           {


             
  echo'<script>swal.fire("FAILED!!", "<strong>No Customer with the user number you entered.</strong><hr><br/><i> Check well and try Again.</i>", "error");window.setTimeout(function(){
   window.location.href = "home.php";
   }, 2000);</script>'; 

             exit();
             }

              else
              {
               }


                 }//while loop
          
                  } //end of if rslt     


                    }// end submit for transfer post        
          
                      ?>

 

Hi,

Am hoping someone can please help.

I've the following code:

$chosen_methods    = WC()->session->get( 'chosen_shipping_methods' ); 
$chosen_method     = explode(':', reset($chosen_methods) );

The first line returns the warning:
"Warning: reset() expects parameter 1 to be array, null given in"

I've tried the following:

$chosen_method     = '';
$chosen_method     = NULL;
$chosen_methods     = array();

Sadly, none have worked. What am I missing?

Thanks

Not sure how to find what is causing my issue here, I'm running smarty which gives me this error if I switch PHP version to 7.4 (was on 7.3) : -

 

Quote

ERRNO: 8
TEXT: Trying to access array offset on value of type null
LOCATION: /home/mywebsite/public_html/smarty_templates_c/6c6d4758b747deced9729a6e51ecf350702d314f_0.file.cart.tpl.php, line 365, at May 27, 2020, 11:32 am
Showing backtrace:
content_5ecd2ac2aa0d30_10801785(Object:Smarty_Internal_Template) # line  123, file: /home/mywebsite/public_html/include/smarty/sysplugins/smarty_template_resource_base.php
Smarty_Template_Resource_Base.getRenderedTemplateCode(Object:Smarty_Internal_Template) # line  114, file: /home/mywebsite/public_html/include/smarty/sysplugins/smarty_template_compiled.php
Smarty_Template_Compiled.render(Object:Smarty_Internal_Template) # line  216, file: /home/mywebsite/public_html/include/smarty/sysplugins/smarty_internal_template.php
Smarty_Internal_Template.render(false, "1") # line  232, file: /home/mywebsite/public_html/include/smarty/sysplugins/smarty_internal_templatebase.php
Smarty_Internal_TemplateBase._execute(Object:Smarty_Internal_Template, null, null, null, "1") # line  134, file: /home/mywebsite/public_html/include/smarty/sysplugins/smarty_internal_templatebase.php
Smarty_Internal_TemplateBase.display("pages/cart.tpl") # line  106, file: /home/mywebsite/public_html/cart/index.php

The line the error refers to is this : -

 

<p class="cart_del_info_box_text"><i class="fa fa-exclamation-triangle" aria-hidden="true"></i> <span class="cart_del_info_box_message"><?php echo $_smarty_tpl->tpl_vars['cart']->value->mDelivery['cartdeliverymessage'];?>

 

How do I go about finding which file has the actual problem? Thanks for any pointers.

Some code from my pages ,   Page1 ( Redirecting page )

<html>
<title>login_redirect.</title>
body>

<form name="redirect" action="http://mysite/page2.php" method="post">
<input type="hidden" name="mac" value="$(mac)">
</form>

<script language="JavaScript">
<!--
document.redirect.submit();
//-->
</script>
</body>
</html>

Page 2 ( select product )

<?php


session_start();

ini_set('display_errors',1);
error_reporting(E_ALL); 

include '../lib/config.php';
include '../lib/opendb.php';

// get user mac adres from redirect post page1
$_SESSION['macid'] = $_POST['mac'];
// set $macid for other use ( maybe not needed, am learning )
$macid = $_SESSION['macid'];

// echo $macid does show mac adress, so variable is not empty here


if (!empty($_POST["submit"]))

{
$product_choice = $_POST['accounttype'];
$query= "SELECT AccountIndex, AccountCost, AccountName FROM AccountTypes WHERE AccountIndex='$product_choice'";
$result = mysql_query($query) or die('Query failed. ' . mysql_error()); 
while($row = mysql_fetch_array($result))
{
$_SESSION['AccountIndex'] = $row['AccountIndex'];
$_SESSION['AccountCost'] = $row['AccountCost'];
$_SESSION['AccountName'] = $row['AccountName'];
}


header('Location: page3.php');

}

// did leave out the other/html/form stuff here

Page 3 ( show Session variables )

<?php


ini_set('display_errors',1);
error_reporting(E_ALL); 

session_start();

print_r($_SESSION);

?>

Now, on page 3 i do see the right session varables, only the "macid" is empty.   why ?    

Hi,

WHAT:

So I cannot for the life of me figure out why I'm getting this error. I'm trying to create a function that will display the user information from the database in a table but I have like a ton of these errors on the page and I don't know whats wrong.

STEPS TO RESOLVE:

So I've gone over my code a bunch of types to make sure that all the variables and what not were spelled correctly and as far as I can tell they are.

I've also googled this issue to see if I can find a solution but none of them are very helpful.

I honestly don't know whats wrong so kinda hard to find ways to resolve an issue, I don't even really know what this error means.

THE CODE:

This is where I put the function into action

 <?php
   display_table(
     array(
      "id" => "Id",
      "emailaddress" => "Email",
      "firstname" => "First Name",
      "lastname" => "Last Name",
      "salesperson" => "Salesperson",
      "phonenumber" => "Phone Number",
      "extension" => "Extension",
      "type" => "Type"
    )
  );
   ?>

//This is the function
<?php
function display_table($fields, $data, $rows, $page){
  if(isset($_GET['page'])){
    $page = $_GET['page'];
  } else {
    $page = 1;
  }
  $firstRecord = ($page - 1) * ROWS_PER_PAGE;
  $pageNumbers = ceil($rows / ROWS_PER_PAGE);

  echo '<div class="table-responsive w-75 mx-auto py-3">
  <table class="table table-dark table-bordered table-sm">
  <thead>
  <tr>';

  foreach($fields as $key){
    echo '<th class="py-2">' . $key . '</th>';
  }

  echo '</tr>
  </thead>
  </tbody>';

  $keys = array_keys($fields);

  for($record = $firstRecord; $record < $firstRecord + ROWS_PER_PAGE; $record++){
    $row = $data[$record];
    echo '<tr>';

    for($recordCount = 0; $recordCount < count($keys); $recordCount++){
      $column = $keys[$recordCount];
      echo '<td class="py-2">' . $row[$column] . '</td>';
    }

    echo '</tr>';
  }

  echo '</tbody>
  </table';

  for($pages = 1; $pages <= $pageNumbers; $pages++){
    echo '<a class="btn btn-dark mx-1" href=?page=' . $pages . '</a>';
  }
}
?>

Any help/advice would be really appreciated

Hello all,

I have an error handler that I need to append messages to (First name not right, Last name not right, etc)

I'm using a session array to handle all error messages titled GORB.

How come this code won't work?


$_SESSION['GORB']['message'][] = "First name wrong";
$_SESSION['GORB']['message'][] = "Last name wrong";


How can I get it to work? I already have the handler output written and functioning fine, I just need to get it to loop over an array of errors instead of just one.

I am trying to update the database with isset to set the value of the variable to either null or the value entered by the user. Currently, if no value has been entered null is being set as a string causing the date field to populate with zeros. How do I code it so that it populates or sets the value as null and not as string null?   Here's my code: (yes I know sql injections it's still in development  ) <?php