Ufdjrw

What wound would be of little consequence to a biped but terrible for a quadruped?

Bash script should only kill those instances of another script's that it has launched

Whose blood did Carol Danvers receive, Mar-vell's or Yon-Rogg's in the movie?

At what distance can a bugbear, holding a reach weapon, with Polearm Mastery, get their Opportunity Attack?

Shifting between bemols (flats) and diesis (sharps)in the key signature

Virginia employer terminated employee and wants signing bonus returned

Looking for word that is not atheist or agnostic,

Database Backup for data and log files

What Happens when Passenger Refuses to Fly Boeing 737 Max?

How did Alan Turing break the enigma code using the hint given by the lady in the bar?

meaning and function of 幸 in "则幸分我一杯羹"

Do f-stop and exposure time perfectly cancel?

Does "Until when" sound natural for native speakers?

Marriage green card at end of current visa with 2 Year residency requirement waiver in-process, question

What problems would a superhuman have whose skin is constantly hot?

They call me Inspector Morse

How to secure an aircraft at a transient parking space?

What official source details what an Empire citizen knows of WFRP's monsters?

In the late 1940’s to early 1950’s what technology was available that could melt a LOT of ice?

Having the player face themselves after the mid-game

Hotkey (or other quick way) to insert a keyframe for only one component of a vector-valued property?

weren't playing vs didn't play

Do items de-spawn in Diablo?

Expressing logarithmic equations without logs

Uncorrect values displayed from PHP function

0

I want to display value from a table in My Database.

i'm using a function to Select the Datas :

public static function getCommandeFromEntrepriseId($bdd, $id) 
 $requete = "SELECT * FROM Commande WHERE entreprise_id='$id'";
 $commandes = getResultatRequete($bdd, $requete);
 return !empty($commandes) ? $commandes : null;

The SQL request works correctly :

On my controller I using the function like this :

$commandes = Commande::getCommandeFromEntrepriseId($bdd, $user->getEntreprise()->getId()); 

And on my Select where I want to use this :

<select>
 <option value="" disabled selected>Sélectionner Devis*</option>
 <?php
 /* @var $commande Commande */
 foreach ($commandes as $commande) 
 echo "<option value='" . $commande['commande_id'] . "'>" . $commande['end_devis'] . "</option>";
 ?>
</select>

The fact is, I'm having a wrong result and i dont understand why...
Here is an exemple :

Here is a var_dumb of my data. :

/var/www/html/controllers/client/Front_BonDeCommande.Controller.php:168:
array (size=16)
 'commande_id' => int 1
 0 => int 1
 'lien_devis' => string 'uploads/x/devis/Devis_6_3_2019_10_16_19.xlsx' (length=56)
 1 => string 'uploads/x/devis/Devis_6_3_2019_10_16_19.xlsx' (length=56)
 'lien_bdc' => string '' (length=0)
 2 => string '' (length=0)
 'end_devis' => string '2019-04-06 00:00:00' (length=19)
 3 => string '2019-04-06 00:00:00' (length=19)
 'bdc_status' => int 0
 4 => int 0
 'devis_created_by_user_id' => int 32
 5 => int 32
 'bdc_managed_by_user_id' => int 32
 6 => int 32
 'entreprise_id' => int 6
 7 => int 6

Can you tell me what's wrong ? I don't understand...

php mysql

share|improve this question

asked Mar 6 at 15:23

NoobieNoobNoobieNoob

105

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You have only one element in var_dump.
  
  – u_mulder
  Mar 6 at 15:29
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Correct... But I don't understand why...
  
  – NoobieNoob
  Mar 6 at 15:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Because some of used functions return only one result.
  
  – u_mulder
  Mar 6 at 15:30
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  What's in getResultatRequete ?
  
  – Romain B.
  Mar 6 at 15:31
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  It is var_dumP. And people ask you to provide code for getResultatRequete.
  
  – u_mulder
  Mar 6 at 15:38
  
  

  
  
  
  

 | 
show 5 more comments

0

I want to display value from a table in My Database.

i'm using a function to Select the Datas :

public static function getCommandeFromEntrepriseId($bdd, $id) 
 $requete = "SELECT * FROM Commande WHERE entreprise_id='$id'";
 $commandes = getResultatRequete($bdd, $requete);
 return !empty($commandes) ? $commandes : null;

The SQL request works correctly :

On my controller I using the function like this :

$commandes = Commande::getCommandeFromEntrepriseId($bdd, $user->getEntreprise()->getId()); 

And on my Select where I want to use this :

<select>
 <option value="" disabled selected>Sélectionner Devis*</option>
 <?php
 /* @var $commande Commande */
 foreach ($commandes as $commande) 
 echo "<option value='" . $commande['commande_id'] . "'>" . $commande['end_devis'] . "</option>";
 ?>
</select>

The fact is, I'm having a wrong result and i dont understand why...
Here is an exemple :

Here is a var_dumb of my data. :

/var/www/html/controllers/client/Front_BonDeCommande.Controller.php:168:
array (size=16)
 'commande_id' => int 1
 0 => int 1
 'lien_devis' => string 'uploads/x/devis/Devis_6_3_2019_10_16_19.xlsx' (length=56)
 1 => string 'uploads/x/devis/Devis_6_3_2019_10_16_19.xlsx' (length=56)
 'lien_bdc' => string '' (length=0)
 2 => string '' (length=0)
 'end_devis' => string '2019-04-06 00:00:00' (length=19)
 3 => string '2019-04-06 00:00:00' (length=19)
 'bdc_status' => int 0
 4 => int 0
 'devis_created_by_user_id' => int 32
 5 => int 32
 'bdc_managed_by_user_id' => int 32
 6 => int 32
 'entreprise_id' => int 6
 7 => int 6

Can you tell me what's wrong ? I don't understand...

php mysql

share|improve this question

asked Mar 6 at 15:23

NoobieNoobNoobieNoob

105

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  You have only one element in var_dump.
  
  – u_mulder
  Mar 6 at 15:29
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Correct... But I don't understand why...
  
  – NoobieNoob
  Mar 6 at 15:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Because some of used functions return only one result.
  
  – u_mulder
  Mar 6 at 15:30
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  What's in getResultatRequete ?
  
  – Romain B.
  Mar 6 at 15:31
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  It is var_dumP. And people ask you to provide code for getResultatRequete.
  
  – u_mulder
  Mar 6 at 15:38
  
  

  
  
  
  

 | 
show 5 more comments

I want to display value from a table in My Database.

i'm using a function to Select the Datas :

public static function getCommandeFromEntrepriseId($bdd, $id) 
 $requete = "SELECT * FROM Commande WHERE entreprise_id='$id'";
 $commandes = getResultatRequete($bdd, $requete);
 return !empty($commandes) ? $commandes : null;

The SQL request works correctly :

On my controller I using the function like this :

$commandes = Commande::getCommandeFromEntrepriseId($bdd, $user->getEntreprise()->getId()); 

And on my Select where I want to use this :

<select>
 <option value="" disabled selected>Sélectionner Devis*</option>
 <?php
 /* @var $commande Commande */
 foreach ($commandes as $commande) 
 echo "<option value='" . $commande['commande_id'] . "'>" . $commande['end_devis'] . "</option>";
 ?>
</select>

The fact is, I'm having a wrong result and i dont understand why...
Here is an exemple :

Here is a var_dumb of my data. :

/var/www/html/controllers/client/Front_BonDeCommande.Controller.php:168:
array (size=16)
 'commande_id' => int 1
 0 => int 1
 'lien_devis' => string 'uploads/x/devis/Devis_6_3_2019_10_16_19.xlsx' (length=56)
 1 => string 'uploads/x/devis/Devis_6_3_2019_10_16_19.xlsx' (length=56)
 'lien_bdc' => string '' (length=0)
 2 => string '' (length=0)
 'end_devis' => string '2019-04-06 00:00:00' (length=19)
 3 => string '2019-04-06 00:00:00' (length=19)
 'bdc_status' => int 0
 4 => int 0
 'devis_created_by_user_id' => int 32
 5 => int 32
 'bdc_managed_by_user_id' => int 32
 6 => int 32
 'entreprise_id' => int 6
 7 => int 6

Can you tell me what's wrong ? I don't understand...

php mysql

share|improve this question

asked Mar 6 at 15:23

NoobieNoobNoobieNoob

105

public static function getCommandeFromEntrepriseId($bdd, $id) 
 $requete = "SELECT * FROM Commande WHERE entreprise_id='$id'";
 $commandes = getResultatRequete($bdd, $requete);
 return !empty($commandes) ? $commandes : null;

$commandes = Commande::getCommandeFromEntrepriseId($bdd, $user->getEntreprise()->getId()); 

<select>
 <option value="" disabled selected>Sélectionner Devis*</option>
 <?php
 /* @var $commande Commande */
 foreach ($commandes as $commande) 
 echo "<option value='" . $commande['commande_id'] . "'>" . $commande['end_devis'] . "</option>";
 ?>
</select>

/var/www/html/controllers/client/Front_BonDeCommande.Controller.php:168:
array (size=16)
 'commande_id' => int 1
 0 => int 1
 'lien_devis' => string 'uploads/x/devis/Devis_6_3_2019_10_16_19.xlsx' (length=56)
 1 => string 'uploads/x/devis/Devis_6_3_2019_10_16_19.xlsx' (length=56)
 'lien_bdc' => string '' (length=0)
 2 => string '' (length=0)
 'end_devis' => string '2019-04-06 00:00:00' (length=19)
 3 => string '2019-04-06 00:00:00' (length=19)
 'bdc_status' => int 0
 4 => int 0
 'devis_created_by_user_id' => int 32
 5 => int 32
 'bdc_managed_by_user_id' => int 32
 6 => int 32
 'entreprise_id' => int 6
 7 => int 6

share|improve this question

asked Mar 6 at 15:23

NoobieNoobNoobieNoob

105

share|improve this question

asked Mar 6 at 15:23

NoobieNoobNoobieNoob

105

asked Mar 6 at 15:23

NoobieNoobNoobieNoob

105

asked Mar 6 at 15:23

NoobieNoobNoobieNoob

105