Errors processing query result set: Undefined variable and Trying to get property of non-object

Question

I already have a database table called "form"; I added a new field in same table.

The problem is in the query select * from "form". While the old fields display, the new field doesn't.

I have no idea why yet nothing displays; the query is correct. The error is:

Undefined variable: Num in C:\xampp\htdocs\velocizzare\modules\mod_client\mod_client.php on line 96
Trying to get property of non-object in C:\xampp\htdocs\velocizzare\modules\mod_client\mod_client.php on line 96

My code is:

if(isset($_POST['BtnConsulter'])){
    $_SESSION["del"]=$_POST['BtnConsulter'];
    $user = JFactory::getUser();
    $db = JFactory::getDBO(); 
    $queri=$db->getQuery(true);
    $queri->select('*');
    $queri->from('ml0ak_chronoengine_chronoforms_datatable_formulaire');
    $queri->where('NuméroK10='.$_POST['BtnConsulter']);
    $db->setQuery ($queri); 
    $users = $db->loadObjectList();
    foreach ( $users as $us){
        $Cognome=$us->Cognome;
        $civilite=$us->civilite;
        $Email=$us->Email;
        $TelCellulaire=$us->TelCellulaire;
        $AutreTel=$us->AutreTel;
        $DataDiNascita=$us->DataDiNascita;
        $Ville=$us->Ville;
        $PaysNaissance=$us->PaysNaissance;
        $ResidenteInCitta=$us->ResidenteInCitta;
        $Provincia=$us->Provincia;
        $Num->$us->Num;                                      // <-- Line 96

        );

        echo"<br />Nome: $Nome";
        echo"<br />Cognome: $Cognome";
        echo"<br />E-mail: $Email";
        echo"<br />Tel/Cellulare: $TelCellulaire";
        echo"<br />Autre Tel: $AutreTel";
        echo"<br />Data di nascita: $DataDiNascita";
        echo"<br />Ville: $Ville";
        echo"<br />Pays de Naissance: $PaysNaissance";
        echo"<br />Residente in (Citta): $ResidenteInCitta";
        echo"<br />Provincia: $Provincia";
        echo"<br /> Num: $Num";

I cleared the cache, it does not work Please what's the solution?

The result:

Answer 1

Problem is this $Num->$us->Num;. You're not defining it correctly.

So replace it with this:

$Num = $us->Num;

---

You may also want to improve your code a little. Try the following:

$jinput       = JFactory::getApplication()->input;
$BtnConsulter = $jinput->get('BtnConsulter', '');

if ($BtnConsulter)
{
    $user    = JFactory::getUser();
    $session = JFactory::getSession();
    $db      = JFactory::getDbo(); 

    $session->set('del', $BtnConsulter);

    $query = $db->getQuery(true);
    $query->select('*')
          ->from($db->qn('#__chronoengine_chronoforms_datatable_formulaire'))
          ->where($db->qn('NuméroK10') . ' = ' . $db->q($BtnConsulter));
    $db->setQuery ($query); 

    $users = $db->loadObjectList();

    foreach ($users as $us)
    {
        $Cognome          = $us->Cognome;
        $civilite         = $us->civilite;
        $Email            = $us->Email;
        $TelCellulaire    = $us->TelCellulaire;
        $AutreTel         = $us->AutreTel;
        $DataDiNascita    = $us->DataDiNascita;
        $Ville            = $us->Ville;
        $PaysNaissance    = $us->PaysNaissance;
        $ResidenteInCitta = $us->ResidenteInCitta;
        $Provincia        = $us->Provincia;
        $Num              = $us->Num;

        echo "<br>Nome: $Nome";
        echo "<br>Cognome: $Cognome";
        echo "<br>E-mail: $Email";
        echo "<br>Tel/Cellulare: $TelCellulaire";
        echo "<br>Autre Tel: $AutreTel";
        echo "<br>Data di nascita: $DataDiNascita";
        echo "<br>Ville: $Ville";
        echo "<br>Pays de Naissance: $PaysNaissance";
        echo "<br>Residente in (Citta): $ResidenteInCitta";
        echo "<br>Provincia: $Provincia";
        echo "<br>Num: $Num";
    }
}

When declaring the result set variables inside of the foreach() loop, use spacing/tabs to align the = assignment operator. This will help you to see any inconsistencies in your code. This technique is employed in a few places in the Joomla's php coding standards document: