PHP - Fatal Error: Uncaught Error: Call To A Member Function Close() On Bool Stack Trace: #0 {main}

Fatal error: Call to a member function qstr() on a non-object in C:\xampp\htdocs\ipod\functions.php on line 14



<?php
require_once('config.php');

function checkwork()
{
header("location: underwork.php");
echo 'Sorry we are under going work :(';
}

function get_username ( $id )
{
global $db;

$query = "SELECT `login` FROM `" . DBPREFIX . "members` WHERE `member_id` = " . $db->qstr ( $id );

if ( $db->RecordCount ( $query ) == 1 )
{
$row = $db->getRow ( $query );

return $row->login;
}
else {
return FALSE;
}
}

?>


this being line 14
$query = "SELECT `login` FROM `" . DBPREFIX . "members` WHERE `member_id` = " . $db->qstr ( $id );

I'm new to coding and prepared statements.

I'm getting:
"Fatal error: Call to a member function bind_param() on a non-object in /home/content/01/3251001/html/Manage-Users/acc-files/updateRecord.php on line 17"

For this:

 <?php

include "db_connect.php"; 

if(isset($_POST['UserID'])){
	
	$stmt = $con -> prepare('UPDATE UserList 
		SET Status = ?,
			FirstName = ?,
			LastName = ?,
			Username = ?,
			Email = ?,
			Department = ?,
			Manager = ?,
		WHERE UserID = ?');

	$stmt -> bind_param('isssssss', /* Line 17 */
		$_POST['Status'],
		$_POST['FirstName'],
		$_POST['LastName'],
		$_POST['Username'],
		$_POST['Email'],
		$_POST['Department'],
		$_POST['Manager'],
		$_POST['UserID']);
	
	$stmt->execute();
}

Thank you in advance for helping.

Hey all.
I am trying to make a mod for our fantasy football site but keep getting an error.
Fatal error: Call to a member function Execute() on a non-object in C:\Inetpub\wwwroot\phpffl\program_files\autorun\general\top_team.php on line 8.
Here is the code.


<?php
   global $PHP_SELF, $DB;
   $leagues_ID='1'; 
   $week='2';
   $week_ID=$week -1;
   $game_ID=$week_ID; 
   $sql="select ID, team_name from teams where leagues_ID='$leagues_ID';";
[b]   $teams_rs=$DB->Execute($sql);[/b]
while (!$teams_rs->EOF) {
   $top_team_ID=$teams_rs->fields('ID');
   $top_team_name=$teams_rs->fields('team_name');
   $top_team_points=get_total_points_game($top_team_ID, $week_ID, $week_ID, $leagues_ID);
//echo $top_team_points." ";
   $top_team_points_array[$top_team_name]=$top_team_points;
   $teams_rs->MoveNext();
   }
   $top_scoring_team_ID="";
   $top_scoring_team_name="";
   $top_scoring_points="";
   foreach(array_keys($top_team_points_array) as $key)
   {
   if ($top_team_points_array[$key] > $top_scoring_points)
   {
   $top_scoring_points=$top_team_points_array[$key];
   //$top_scoring_team_ID=$top_team_ID;
   $top_scoring_team_name=$key;
   }
   }
   $sql="insert into total_scores (team_ID, teams_name, week_id, total_score, leagues_ID) values('$top_team_ID', '$top_scoring_team_name', '$week_ID', '$top_scoring_points', '$leagues_ID');";
   $rs=$DB->Execute($sql);

echo "<br>";
echo "<br>";
echo "Weekly Top Scoring Team for Week $week_ID is: $top_scoring_team_name with a score of $top_scoring_points points!";
echo "<br>";
echo "<br>";
//print_r ($top_team_points_array);

echo "<br>";
echo "<br>";

$weekly_top_score=max($top_team_points_array);

?> 


I have a function in the global file looks like this.

/************** BEGIN ADDITIONAL FUNCTIONS **************************/
function get_top_scoring_teams()
{

   global $PHP_SELF, $DB, $PHPFFL_IMAGE_PATH;
   $sql="select * from total_scores order by week_ID DESC limit 1;";
   $teams_rs=$DB->Execute($sql);
while (!$teams_rs->EOF) {
   $team_ID=$teams_rs->fields('team_ID');
   $team_name=$teams_rs->fields('teams_name');
   $team_points=$teams_rs->fields('total_score');
   $week_ID=$teams_rs->fields('week_ID');
echo "The Top Scoring Team for <strong>Week $week_ID</strong> was <br><img src='{$PHPFFL_IMAGE_PATH}team_logos_standings/$team_ID.gif'><br> <strong>$team_name</strong> with a score of <strong>$team_points</strong> points. <hr>";
   $teams_rs->MoveNext();
   }

}
/************** BEGIN ADDITIONAL FUNCTIONS**************************/

Any one see what the issue might be?
I am running this on a windows 2003 server with iis 6 php 5.3 and mysql 5.1.5

Any help would be appreciated.

Thanks
Hitster4

2 9 0 1

Fatal error: Call to a member function bind_param() on boolean.

 

It fails on the BIND_PARAM line.

 

I have looked at this all day, struggling with Mysqli as my normal MySql works fine with assoc and fetch.

 

I have verified in PhpInfo that mysqli is enabled.

I have verified its loaded using <?php print_r(get_loaded_extensions());

Added utf8 just to make sure. 

 

If I manually use the Wrong Password, I get a connection refused error, so I know its connected.

 

Verified my $_POST variables are there using Print in the 2 9 0 1 above.

 

All Table and Field Names are correct.  Manual Insert works fine in myPhpAdmin.

Tried Field Names and ? marks with and without single quotes.

All fields are Integers in the table.

 

Could it be related to an Auto_Increment Field in the table for a record ID that I am not providing??

A normal insert in myPhpAdmin doesn't need it.

 

 

        $QuestionID = $_POST['qID'];
        $PlayerID = $_POST['pID'];        
        $Answer = $_POST['ans'];
        $Option = $_POST['opt'];
        

        print $QuestionID . " ";
        print $PlayerID . " ";
        print $Answer . " ";
        print $Option . " ";

        $database = "Survey";

        $db_found = new mysqli('localhost', 'survey', 'survey', $database);
        $db_found->set_charset("utf8");
        
        if (!$db_found) {
            echo "Error: db connection = false";
        }
        else {
            $SQL_INSERT = "INSERT INTO 'Answers' ('QuestionID', 'PlayerID', 'Answer', 'Option') VALUES (?,?,?,?)";
            $stmt = $db_found->prepare($SQL_INSERT);
            $stmt->bind_param('iiii', $QuestionID, $PlayerID, $Answer, $Option);
            $stmt->execute();
        }

 

Thanks,

CadJoe

Edited August 26, 2017 by CadJoe

Code: [Select]
<?php

class OnlineStore {

private $DBConnect = NULL;
private $storeID = "";
private $inventory = array();
private $shoppingCart = array();
function __construct() {
include("inc_OnlineStoreDB.php");
$this->DBConnect = $DBConnect;
}
function __destruct() {
if (!$this->DBConnect->connect_error)
$this->DBConnect->close();
}

public function setStoreID($storeID) {
if ($this->storeID != $storeID) {
$this->storeID = $storeID;
$SQLstring = "SELECT * FROM inventory " .
" where storeID = 'jw" .
$this->storeID . "'";
$QueryResult = $this->DBConnect->query($SQLstring);
if ($QueryResult === FALSE) {
$this->storeID = "";
} else {
$this->inventory = array();
$this->shoppingCart = array();
while (($Row = $QueryResult->fetch_assoc()) !== NULL) {
$this->inventory[$Row['productID']] = array();
$this->inventory[$Row['productID']]['name'] = $Row['name'];
$this->inventory[$Row['productID']]['description'] = $Row['description'];
$this->inventory[$Row['productID']]['price'] = $Row['price'];
$this->shoppingCart[$Row['productID']] = 0;
}
}
}
}

public function getStoreInformation() {
$retval = FALSE;
if ($this->storeID != "") {
$SQLstring = "SELECT * FROM store_info " .
" WHERE storeID = '" .
$this->storeID . "'";
$QueryResult = @$this->DBConnect->query($SQLstring);
if ($QueryResult !== FALSE) {
$retval = $QueryResult->fetch_assoc();
}
}
return($retval);
}

public function getProductList() {
$retval = FALSE;
$subtotal = 0;
if (count($this->inventory) > 0) {
echo "<table width='100%'>\n";
echo "<tr><th>Product</th><th>Description</th>" .
"<th>Price Each</th><th># in Cart</th>" .
"<th>Total Price</th><th>&nbsp;</th></tr>\n";
foreach ($this->inventory as $ID => $Info) {
echo "<tr><td>" .
htmlentities($Info['name']) . "</td>\n";
echo "<td>" . htmlentities($Info['description']) . "</td>\n";
printf("<td class='currency'>$%.2f</td>\n", $Info['price']);
echo "<td class='currency'>" . $this->shoppingCart[$ID] . "</td>\n";
printf("<td class='currency'>$%.2f</td>\n", $Info['price'] * $this->shoppingCart[$ID]);
echo "<td><a href='" . $_SERVER['SCRIPT_NAME'] . "?PHPSESSID=" . session_id() . "&ItemToAdd=$ID'>Add " . " Item</a></td>\n";
$subtotal += ($Info['price'] * $this->shoppingCart[$ID]);
}
echo "<tr><td colspan='4'>Subtotal</td>\n";
printf("<td class='currency'>$%.2f</td>\n", $subtotal);
echo "<td>$nbsp;</td></tr>\n";
echo "</table>";
$retval = TRUE;
}
return($retval);
}

public function addItem() {
$ProdID = $_GET['ItemToAdd'];
if (array_key_exists($ProdID, $this->shoppingCart))
$this->shoppingCart[$ProdID] += 1;
}


}

?>

having an issue to where nothing is appearing on the page and getting the
Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\PHP\Chapter.10\class_OnlineStore.php on line 24

HERE IS THE MAIN PAGE
Code: [Select]
<?php
session_start();
require_once("class_OnlineStore.php");

$storeID = "COFFEE";
$storeInfo = array();

if (class_exists("OnlineStore")) {
if (isset($_SESSION['currentStore']))
$Store = unserialize($_SESSION['currentStore']);
else {
$Store = new OnlineStore();
}
$Store->setStoreID($storeID);
$storeInfo = $Store->getStoreInformation();
} else {
$ErrorMsgs[] = "The OnlineStore class is not available!";
$Store = NULL;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?php echo $storeInfo['name']; ?></title>
<link rel="stylesheet" type="text/css" href="<?php echo $storeInfo['css_file']; ?>" />
</head>

<body>
<h1><?php echo htmlentities($storeInfo['name']); ?></h1>
<h2><?php echo htmlentities($storeInfo['description']); ?></h2>
<p><?php echo htmlentities($storeInfo['welcome']); ?></p>

<?php 
$Store->getProductList();
$_SESSION['currentStore'] = serialize($Store);
?>

</body>
</html>

I HAVE REVIEWED IT OVER AND OVER AGAIN AND I CANT SEE THE PROBLEM. MAYBE SOMEONE FROM THE OUTSIDE CAN HELP OUT.

can anyone tell me why im getting this error?
Fatal error: Call to a member function fetchrow() on a non-object

code being used.....

Code: [Select]
$comment_query = mysql_query("SELECT * FROM `comments` where video_id='$video[0]' ORDER BY='desc' LIMIT='30'");
while($comments = $comment_query->fetchrow())
{

here is my php code. i want to remove the attribute of a tag and then add a new attribure to the tag. simply i want attribute validation.

but this code gives me the following error.
"Fatal error: Call to a member function getAttributeNode() on a non-object in D:\wamp\www\ReadXml\new.php on line 35"




<?php
$xml = new DOMDocument();
$doc->recover = true;
$xml->load('test.xml');

$node = $xml->getElementsByTagName('*');

$nodename = "";
$node_name = array();
$att = "";
$attr_name = "";
$attr_value = "";

foreach($node as $value)
{

echo "<HTML><Head>";
echo "<title> Getting Attribute Example</title>";
echo "</Head><body><B>";
echo "Node Name is :".$value->nodeName;

echo "<br /><br /></B></body></HTML>";



$nodename = $value->nodeName;
$node_name = $xml->getElementsByTagName('$nodename')->item(0);
echo  $nodename;

$att = $node_name->getAttributeNode('name'); //Line No 35


echo "<HTML><Head>";
echo "<title> Getting Attribute Example</title>";
echo "</Head><body><B>";
echo "Node Name is :".$att->name;
echo "<BR>Attribute Value is :".$att->value;
echo "<br /><br /></B></body></HTML>";

$attr_name = $att->name;
$attr_value = '"' . $att->value . '"';
$nodename->removeAttributeNode('$attr_name');

$nodename->setAttributeNode(new DOMAttr('$attr_name', 'hello'));
$nodename->setAttribute(new DOMAttr('$attr_name', '$attr_name'));


$xml->save('temp2.xml');
}
?>

Hello guys

I'm pulling out my last remaining hairs with this PHP problem. I'm not really good at PHP but I'm trying to do some changes to a script as instructed by the developer, but apparently I got some wrong instructions. The error I get is:

Fatal error: Call to a member function postage_country_display() on a non-object in file.php on line 34

I've been searching the web high and low and can't seem to find a solution. Does anyone have a hint at what might be wrong?



Here is the code that's causing the problem and the class.

Code:

Code: [Select]
$template->set('items_id', intval($_REQUEST['items_id']));

$item_details = $db->get_sql_row("SELECT * FROM " . DB_PREFIX . "items WHERE
items_id='" . intval($_REQUEST['items_id']) . "'");

$unCountryPrice = unserialize(stripslashes($db->add_special_chars($item_details['country_postage'])));
// print_r($unCountryPrice);

$postageCountry = $item->postage_country_display($unCountryPrice,$item_details['currency']);

$template->set('postageCountry', $postageCountry);


$template->set('item_details', $item_details);

And here is the class:

Code: [Select]
function postage_country_display($unCountryPrice,$currency) {
  if (is_array($unCountryPrice)) {

$postageCountry = "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
";
        $fees = new fees();
while (list($k,$v)= each($unCountryPrice)){
       $cQueyr = $this->query("SELECT a.name as name1,b.name as name2 FROM " . DB_PREFIX . "countries a LEFT JOIN " . DB_PREFIX . "countries b ON (a.parent_id = b.id) WHERE a.id = '". $k ."'");
$cRow = $this->fetch_array($cQueyr);

$postageCountry.="<tr><td>". ($cRow['name2']==""?$cRow['name1']:$cRow['name2'].' > '.$cRow['name1']) ."</td><td>&nbsp;".$currency.' '.number_format($v,2)."</td></tr>";
    }
$postageCountry.="</table>";
}
return  $postageCountry;

Hi all,

I'm getting the following error, but I cannot see why:

ERROR:
Fatal error: Call to a member function fetch_assoc() on a non-object in {filepath} on line 36

CODE:
Code: [Select]
<?php 

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

require_once("aconfig.php");

$eid = $_GET["event"];

echo '<html>
<head>
<title>Admin Control Panel :: PRINT TICKETS</title>
<style type="text/css">
body {
font-family: Helvetica, Arial;
}
</style>
</head>
<body>';

//start classes
$db = new db();

//connect to DB
//attempt it
$sql = new mysqli(db::$config['host'], db::$config['user'], db::$config['pass'], db::$config['db']);
//check for ERR
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", mysqli_connect_error());
     exit();
}
//

if($eid == "edit"){
echo '<h1>SELECT EVENT</h1>
<p>Select an event to print tickets for</p>
<p>';
$query = 'SELECT * from `tickets` ORDER by id';
$query = $sql->real_escape_string($query);
// Perform Query
$result = $sql->query($query);
// Loop Through Result
while ($row = $result->fetch_assoc()) {

echo '&minus; <a href="ptickets.php?event='.$row[id].'">'.$row[event_name].'</a> <br />';
}
echo '</p>';
}else {
$query2 = 'SELECT * from `orders` WHERE `id` = '.$eid.', paid = "1"';
$query2 = $sql->real_escape_string($query2);
// Perform Query
$result2 = $sql->query($query2);
// Loop Through Result
while ($row2 = $result2->fetch_assoc()) {
echo '<table cellspacing="1" cellpadding="1" border="1" width="400">
    <tbody>
        <tr>
            <td colspan="2"><strong>Online Ticket</strong></td>
        </tr>
        <tr>
            <td width="300">
            <p>Event: <strong>'.$row2[eventname].'</strong></p>
            <p>Holder Name: <strong>'.$row2[name].'</strong></p>
            <p>No. Adult tickets: <strong>'.$row2[adult_tix].'</strong><br />
            No. Concession tickets: <strong>'.$row2[concess_tix].'</strong></p>
            </td>
            <td>
            <p><u>STAFF</u></p>
            <p><em>Rip this side off once ticket holder has entered.</em></p>
            </td>
        </tr>
    </tbody>
</table>
<p>&nbsp;</p>';
}
}


echo '</body></html>';

?>
What the script does:

if the page is ?event=edit, it lists all the available events.

If not, it checks what event id is at ?event and lists that ID from the DB.

What's wrong with it?

Thanks

Hey guys,

I have spent the last 36 hours trying to figure this out.

I keep getting the following error:

Fatal error: Call to a member function format() on a non-object in /var/www/vhosts/xxxxx.com/httpdocs/admin/defaults.php on line 51

The reason I am not using the standard date and strtotime functions is because some of my dates exceed 2038.

What I have done is created an array with price and days from today within the array.

You can see below where I am trying to get the timestamp for 14000 days from today. I then turn that into a date using the newdate function.

I can see that this actually works on other pages on my server, I just can't figure out why it won't work here. BTW, I am using php 5.2.3.



$csv .= "Payment,".newdate("m/d/Y",newstrtotime("+".$periodic[0][0]." days")).",".$row['amount'].",".count($periodic).",".$row['frequency'].",".newdate("m/d/Y",newstrtotime("+".$periodic[$perCt][0]." days"))."\n";
function newstrtotime($strtotime){
$datetime = date_create($strtotime);
return $datetime->format("U");
}        
function newdate($format,$timestamp){
$datetime = date_create("@$timestamp");
return $datetime->format($format);
}




Let me know what you think.

I have a table with a list of users and an edit button and delete button.  When the edit button is pressed on a site it passes the user_id as p_id to the page that catches it and displays the data.  The problem is when I click on the "update user" button, I get the following error:

Warning: Undefined variable $the_user_id in C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php on line 10

Fatal error: Uncaught TypeError: mysqli_fetch_assoc(): Argument #1 ($result) must be of type mysqli_result, bool given in C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php:14 Stack trace: #0 C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php(14): mysqli_fetch_assoc(false) #1 {main} thrown in C:\xampp\htdocs\3-19-21(2) - SafetySite\admin\edit_user.php on line 14

The weird thing is I had another update user page with a table I created that ran the query to update the table in the database just fine.  But as I created it, it didn't look all that great so I recreated the page and used a bootstrap table because of the much cleaner look.  Both pages have the exact same PHP code, the only difference is the bootstrap table I added in.  So I'm really at a loss with this.  Other than the table and PHP code, there is a script at the bottom of the page for the table itself to allow for searching within the table, i'll include that as well.  The PHP code is as follows:

<?php

//THE "p_id" IS BROUGHT OVER FROM THE EDIT BUTTON ON VIEW_ALL_USERS

if (isset($_GET['p_id'])) {

    $the_user_id = $_GET['p_id'];

}

// QUERY TO PULL THE SITE INFORMATION FROM THE p_id THAT WAS PULLED OVER

$query = "SELECT * FROM users WHERE user_id = $the_user_id ";

$select_user = mysqli_query($connection,$query);

//SET VALUES FROM ARRAY TO VARIABLES

while($row = mysqli_fetch_assoc($select_user)) {

    $user_id = $row['user_id'];

    $user_firstname = $row['user_firstname'];

    $user_lastname = $row['user_lastname'];

    $username = $row['username'];

    $user_email = $row['user_email'];

    $user_phone = $row['user_phone'];

    //$user_image = $row['user_image'];

    $user_title_id = $row['user_title_id'];

    $user_role_id = $row['user_role_id'];

   }

THE UPDATE QUERY CODE....................................................................................................................

<?php

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

    $user_id = $_POST['user_id'];

    $user_firstname = $_POST['user_firstname'];

    $user_lastname = $_POST['user_lastname'];

    $username = $_POST['username'];

    $user_email = $_POST['user_email'];

    $user_phone = $_POST['user_phone'];

    //$user_image = $_POST['user_image'];

    $user_title_id = $_POST['user_title_id'];

    $user_role_id = $_POST['user_role_id'];

    

    $query = "UPDATE users SET ";

    $query .= "user_id = '{$user_id}', ";

    $query .= "user_firstname = '{$user_firstname}', ";

    $query .= "user_lastname = '{$user_lastname}', ";

    $query .= "username = '{$username}', ";

    $query .= "user_email = '{$user_email}', ";

    $query .= "user_phone = '{$user_phone}', ";

    //$query .= "user_image = '{$user_image}', ";

    $query .= "user_title_id = '{$user_title_id}', ";

    $query .= "user_role_id = '{$user_role_id}' ";

    $query .= "WHERE user_id = '{$the_user_id}' ";

    $update_user = mysqli_query($connection,$query);

    if(! $update_user) {

        die("QUERY FAILED" . mysqli_error($connection));

    }

}

?>

THE "UPDATE USER" BUTTON THE USER CLICKS ON TO UPDATE....................................................................................................................

<div class="col-1">

<button class="btn btn-primary" type="submit" name="update_user">Update User</button>

</div>

 

Any Help is Greatly Appreciated!

Edited March 23 by Zserene

Hello all,   Appreciate if you folks could pls. help me understand (and more importantly resolve) this very weird error:     Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ASC, purchase_later_flag ASC, shopper1_buy_flag AS' at line 3' in /var/www/index.php:67 Stack trace: #0 /var/www/index.php(67): PDO->query('SELECT shoplist...') #1 {main} thrown in /var/www/index.php on line 67   Everything seems to work fine when/if I use the following SQL query (which can also be seen commented out in my code towards the end of this post) :  

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
           FROM shoplist, store_master, item_master
           WHERE     shoplist.store_id = store_master.store_id
                   AND shoplist.item_id = item_master.item_id";

  However, the moment I change my query to the following, which essentially just includes/adds the ORDER BY clause, I receive the error quoted above:

$sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name 
		FROM shoplist, store_master, item_master 
		ORDER BY purchased_flag ASC, 
				purchase_later_flag ASC, 
				shopper1_buy_flag ASC, 
				shopper2_buy_flag ASC, 
				store_name ASC) 
		WHERE 	shoplist.store_id = store_master.store_id 
				AND shoplist.item_id = item_master.item_id";

In googling for this error I came across posts that suggested using "ORDER BY FIND_IN_SET()" and "ORDER BY FIELD()"...both of which I tried with no success.   Here's the portion of my code which seems to have a problem, and line # 67 is the 3rd from bottom (third last) statement in the code below:  

                    <?php
                        /*
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        */
                    
                        $sql = "SELECT shoplist.*, store_master.store_name, item_master.item_name
                                FROM shoplist, store_master, item_master
                                ORDER BY FIND_IN_SET(purchased_flag ASC,
                                                 purchase_later_flag ASC,
                                                 shopper1_buy_flag ASC,
                                                 shopper2_buy_flag ASC,
                                                 store_name ASC)
                                WHERE     shoplist.store_id = store_master.store_id
                                        AND shoplist.item_id = item_master.item_id";
                        $result = $pdo->query($sql);                        
                        
                        // foreach ($pdo->query($sql) as $row) {
                        foreach ($result as $row) {
                            echo '<tr>';
                                print '<td><span class="filler-checkbox"><input type="checkbox" name="IDnumber[]" value="' . $row["idnumber"] . '" /></span></td>';

    Thanks  

Hello ,

I have a made a PHP website where users signup and send their Date of Birth and gets an OTP on their email after signup.

The OTP is recieved but when we enter the OTP this problem occurs 

Quote

Error! Something went wrong 

and I am facing this error in the error log

Quote

PHP Fatal error: Uncaught Error: Object of class DateTime could not be converted to string 

This is my config.php code

<?php
    session_start();
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Confirmation Page - Kanha Stories</title>

    <style>
        body
        {
            background-color: #330000;
            background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='100%25' height='100%25' viewBox='0 0 800 400'%3E%3Cdefs%3E%3CradialGradient id='a' cx='396' cy='281' r='514' gradientUnits='userSpaceOnUse'%3E%3Cstop offset='0' stop-color='%23D18'/%3E%3Cstop offset='1' stop-color='%23330000'/%3E%3C/radialGradient%3E%3ClinearGradient id='b' gradientUnits='userSpaceOnUse' x1='400' y1='148' x2='400' y2='333'%3E%3Cstop offset='0' stop-color='%23FA3' stop-opacity='0'/%3E%3Cstop offset='1' stop-color='%23FA3' stop-opacity='0.5'/%3E%3C/linearGradient%3E%3C/defs%3E%3Crect fill='url(%23a)' width='800' height='400'/%3E%3Cg fill-opacity='0.4'%3E%3Ccircle fill='url(%23b)' cx='267.5' cy='61' r='300'/%3E%3Ccircle fill='url(%23b)' cx='532.5' cy='61' r='300'/%3E%3Ccircle fill='url(%23b)' cx='400' cy='30' r='300'/%3E%3C/g%3E%3C/svg%3E");
            background-attachment: fixed;
            background-size: cover;
            padding: 20px;
            width: 100vw;
            height: 100vh;
            display: flex;
            align-items: center;
            justify-content: center;
            color:#ffffff;
            overflow-x: hidden;
        }
        .cont
        {
            padding: 20px 40px;
            position: relative;
            border-right: 4px solid rgb(184, 182, 182);
            border-bottom: 4px solid rgb(184, 182, 182);
            border-radius: 15px;
            display: flex;
            flex-direction: column;
            align-items: center;
        }
        #left{
            float: left;
        }
        #right{
            float: right;
        }
        input{
            margin: 10px 0px;
        }
        s{
            padding: 5px;
        }
        .error{
            padding: 5px;
            color: #ffffff;
        }
        .resend{
            color: rgb(14, 14, 196);
            padding: 5px;
        }
        .s:hover{
            cursor: pointer;
            background-color:gray;
            color: rgb(243, 237, 237);
            border-radius: 5px;
        }
    </style>

</head>
<body>

    <?php
        $code="";
        $err="";
        $error="";
        if(($_SERVER["REQUEST_METHOD"]=="GET" && $_SESSION['xyz'] === 'xyz') || isset($_POST['verify']) || isset($_POST['resend']))
        {
            unset($_SESSION["xyz"]);
            if($_SERVER["REQUEST_METHOD"] ==="POST")
            {
                if(isset($_POST['verify']))
                {
                    if(empty($_POST['code']))
                    {
                        $err="Enter the code!";
                    }
                    else
                    {
                        $code=$_POST['code'];
                        if(password_verify($code,$_SESSION['code']))
                        {
                            $name=$_SESSION['name'];
                            $email=$_SESSION['email'];
                            $tel=$_SESSION['tel'];
                            $dob=$_SESSION['dob'];
                            $password=$_SESSION['password'];
                            $age_category=$_SESSION['age_category'];
                            
                            require_once('./all_utils/connection.php');
                            $sql="INSERT INTO identity_table(name,email,password,tel,dob,age_category) VALUES ('$name','$email','".$password."','$tel','$dob','$age_category')";
                            if(mysqli_query($conn,$sql) === TRUE) 
                            {
                                unset($_SESSION["name"]);
                                unset($_SESSION["password"]);
                                unset($_SESSION["dob"]);
                                unset($_SESSION["tel"]);
                                unset($_SESSION["age_category"]);
                                
                                header("location:welcome/welcome.php");
                            }
                            else
                            {
                                $err="Error! Something went wrong";
                            }
                        }
                        else
                        {
                            $err="Incorrect code!";
                        }

                    }
                }
                elseif(isset($_POST['resend']))
                {
                    require_once('./all_utils/mail.php');
                    $error="OTP has been sent again!";
                }
            }
        }
        else{
            header("location:signup.php");
        }
    ?>

    <div class="cont">
        <h2> Email Verification</h2>
        <form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF']) ?>" method="POST">
            <label for="verification">Enter the 5 digit code</label>
            <br/>
            <p> Didn't got the mail?  Please check your spam folder </p>
            <input type="text" name="code" placeholder="Eg. 12345" value="<?php echo $code; ?>">
            <br/>
            <div class="error"><?php echo $err; ?></div>
            <div class="resend"><?php echo $error;?></div>
            <input type="submit" name="resend" class="s" id="left" value="Resend OTP">
            <input type="submit" name="verify" class="s" id="right" value="Verify">
        </form>
    </div>
</body>
</html>

 

This is my signup.php code

<?php
    session_start();
    if(!empty($_SESSION['email']))
    {
        require_once('./all_utils/connection.php');
        $query="SELECT * FROM identity_table WHERE email='".$_SESSION['email']."'";
        $result=mysqli_query($conn,$query);
        if(mysqli_fetch_assoc($result))
        {
            header("location:welcome/welcome.php");
        }
    }

?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>SignUp - Kanha Stories</title>
    <style>
        * {
            margin: 0;
            padding: 0;
        }

        body {
            width: 100vw;
            height: 100vh;
            display: flex;
            align-items: center;
            background-color: #ff9d00;
            background-image: url("data:image/svg+xml,%3Csvg xmlns='http://www.w3.org/2000/svg' width='100%25' height='100%25' viewBox='0 0 1600 800'%3E%3Cg stroke='%23000' stroke-width='66.7' stroke-opacity='0' %3E%3Ccircle fill='%23ff9d00' cx='0' cy='0' r='1800'/%3E%3Ccircle fill='%23f27d00' cx='0' cy='0' r='1700'/%3E%3Ccircle fill='%23e55f00' cx='0' cy='0' r='1600'/%3E%3Ccircle fill='%23d84400' cx='0' cy='0' r='1500'/%3E%3Ccircle fill='%23cb2c00' cx='0' cy='0' r='1400'/%3E%3Ccircle fill='%23bf1600' cx='0' cy='0' r='1300'/%3E%3Ccircle fill='%23b20300' cx='0' cy='0' r='1200'/%3E%3Ccircle fill='%23a5000e' cx='0' cy='0' r='1100'/%3E%3Ccircle fill='%2398001c' cx='0' cy='0' r='1000'/%3E%3Ccircle fill='%238b0027' cx='0' cy='0' r='900'/%3E%3Ccircle fill='%237e0030' cx='0' cy='0' r='800'/%3E%3Ccircle fill='%23710037' cx='0' cy='0' r='700'/%3E%3Ccircle fill='%2364003b' cx='0' cy='0' r='600'/%3E%3Ccircle fill='%2358003c' cx='0' cy='0' r='500'/%3E%3Ccircle fill='%234b003a' cx='0' cy='0' r='400'/%3E%3Ccircle fill='%233e0037' cx='0' cy='0' r='300'/%3E%3Ccircle fill='%23310030' cx='0' cy='0' r='200'/%3E%3Ccircle fill='%23210024' cx='0' cy='0' r='100'/%3E%3C/g%3E%3C/svg%3E");
            background-attachment: fixed;
            background-size: cover;
            overflow-x: hidden;
        }

        .cont {
            color: #ffffff;
            width: 500px;
            margin: auto;
        }

        h2 {
            color: #ffffff;
            text-align: center;
            padding: 1.5px;
        }

        .error {
            text-align: center;
            padding: 20px;
            font-size: 1rem;
            color: rgb(233, 76, 76);
        }

        form {
            font-size: 1.2rem;
            /* width: 40%; */
            /* margin: auto; */
        }
        .in{
            margin: 5px 0;
        }

        input {
            border: 2px solid white;
            padding: 10px;
            margin: 5px 0;
            font-size: 1rem;
            width: 100%;
        }

        input:hover {
            border: 2px solid rgb(228, 81, 81);
            cursor: text;
        }

        p,a{
            text-align: center;
            font-size: 1rem;
        }
        a{
            color: deepskyblue;
            font-size:20px;
        }

        #s{
            text-decoration:none;
            border-radius: 12px;
        }
        #s:hover {
            cursor: pointer;
        }

        a {
            text-decoration: none;
        }
        
        @media only screen and (max-width: 600px){
            .cont{
                width: 300px;
            }
            .error,input{
                font-size: 0.8rem;
            }

        }
        @media only screen and (max-width: 400px){
            .cont{
                width: 70%;
            }
            h2{
                font-size: 1.3rem;
            }
            a,p{
                font-size: 0.7rem;
            }
            label{
                font-size: 1.0rem;
            }
            input{
                padding: 4px;
            }

        }
    </style>
</head>
<body>

    <?php

        $name="";        
        $email="";
        $tel="";
        $dob="";
        $err="";
        
        $name_err="";
        $email_err="";
        $tel_err="";
        $dob_err="";
        $password_err="";
    if($_SERVER["REQUEST_METHOD"]=="POST")
       {
            if(isset($_POST['signup']))
            {
                if(empty($_POST['name']) || empty($_POST['dob']) || empty($_POST['tel']) || empty($_POST['email']) || empty($_POST['password']))
                {
                    if(empty($_POST['name']))
                    {
                        $name_err="Name is required!";
                    }
                    else{
                        $name=$_POST['name'];
                    }
                    if(empty($_POST['email']))
                    {
                        $email_err="Email is required!";
                    }
                    else{
                        $email=$_POST['email'];
                    }
                    if(empty($_POST['tel']))
                    {
                        $tel_err="Contact Number is required!";
                    }
                    else{
                        $tel=$_POST['tel'];
                    }
                    if(empty($_POST['dob']))
                    {
                        $dob_err="D.O.B is required!";
                    }
                    else{
                        $dob=$_POST['dob'];
                    }
                    if(empty($_POST['password']))
                    {
                        $password_err="Password is required!";
                    }
                }
                else
                {
                    $today = new DateTime(date('m.d.y'));
                    $dob = new DateTime($_POST['dob']);
                    $diff1 = $today->diff($dob);
                    $age = $diff1->y;
                    if($age > 15 || $age <3)
                    {
                        $dob = $_POST['dob'];
                        $dob_err = "Age criteria not satisfied , child's age must be between 3-15 years";
                    }
                    else
                    {
                        require_once("./all_utils/connection.php");
                        $email=$_POST['email'];
                        $query="SELECT * FROM identity_table WHERE email='".$email."'";
                        $result=mysqli_query($conn,$query);

                        if(mysqli_fetch_assoc($result))
                        {
                            $err="Email alredy registered!";
                            $name=$_POST['name'];
                            $email=$_POST['email'];
                        }
                        else
                        {
                            if($age < 7)
                            {
                                $_SESSION['age_category'] = '1';
                            }
                            else
                            {
                                $_SESSION['age_category'] = '2';
                            }
                            $_SESSION['name']=$_POST['name'];
                            $_SESSION['email']=$_POST['email'];
                            $_SESSION['password'] = password_hash($_POST['password'],PASSWORD_DEFAULT);
                            $_SESSION['tel']=$_POST['tel'];
                            $_SESSION['dob']=$_POST['dob'];
                            $_SESSION['xyz']='xyz';
                            require_once("all_utils/mail.php");
                            header("location:conf.php");
                        }
                    }
                }
            
            }
        }

    ?>

    <div class="cont">
        <h2>SignUp - Kanha Stories</h2>

            <form action="<?php echo htmlspecialchars($_SERVER['PHP_SELF'])?>" method="POST">

            <span class="error"><?php echo $err; ?></span>
            <br/>

            <label for="name">Name</label><br />
            <input type="text" name="name" placeholder="Enter your name" value="<?php echo $name; ?>">

            <span class="error"><?php echo $name_err; ?></span>
            <br/>

            <label for="email">Email</label><br />
            <input type="email" name="email" placeholder="Enter your Email ID" value="<?php echo $email; ?>">


            <span class="error"><?php echo $email_err;?></span>
            <br/>

            <label for="tel">Mobile Number</label><br />
            <input type="tel" name="tel" placeholder="Enter Mobile Number" value="<?php echo $tel; ?>">


            <span class="error"><?php echo $tel_err;?></span>
            <br/>

            <label for="date">D.O.B. of Child &nbsp; (Click on Calander icon)</label><br />
            
            <input  type="date" name="dob" placeholder="Enter date of birth " value="<?php echo $dob;?>">

            <span class="error"><?php echo $dob_err;?></span>
            <br/>

            <label for="password">Password</label><br />
            <input type="password" name="password" placeholder="Enter your Password">


            <span class="error"><?php echo $password_err; ?></span>
            <br/>
            

            <div class="sub">
            <input type="submit" name="signup" id="s"  placeholder="Submit"><br />
            </div>
        </form>
        <p>Already registered? <a href="./login.php">log in here</a></p>
    </div>
</body>
</html>

 

I don't know what I can do now , Please try to give me the solutions as soon as possible. Thanks

I closed everything down last night and it was all fine, website was working as normal etc, but I've turned on the Xxamp server today and I am getting this error. Seems very random as nothing has changed since it was last on? 

Does anyone know how to sort this out and why I'm now getting this error? Thanks!

Hi guys, 

I am trying to install a script and I am getting this error when loading for the first time kindly assist anyone.