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?