Databases
StackOverflow2013
Postsdbo
POcodeigniter database select comparing strings
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POcodeigniter database select comparing strings
    primarykey
    data
    text
    <p>I'm trying to do a select in one of my models of my codeigniter project. I have used the method you will see next on some other functions and never had problems since i was comparing <code>int</code>s and not <code>string</code>s. However, now i'm comparing strings the select is not done correctly since it doesn't return any results.</p> <pre><code>public function get_frasesr_by_cee($ficha_id){ $query = $this-&gt;db-&gt;query("SELECT * FROM tabela_cee_r where id_ficha='".$ficha_id."';"); if ($query-&gt;num_rows() &gt; 0){ //var_dump($query-&gt;result()); $nomes_frasesr_cee; $i=0; foreach($query-&gt;result() as $row){ $nomes_frasesr_cee[$i]=$row-&gt;cod_frase_r; //var_dump("Ola"); $i++; } $max = sizeof($nomes_frasesr_cee); //var_dump($max); $dados_frasesr_cee; for($j = 0; $j &lt; $max;$j++) { var_dump($nomes_frasesr_cee[$j]); $query1 = $this-&gt;db-&gt;query("SELECT * FROM frases_r where cod_frase_r='".$nomes_frasesr_cee[$j]."';"); //var_dump($query1-&gt;result()); foreach($query1-&gt;result() as $value){ $dados_frasesr_cee[$j][0]=$value-&gt;id_frase_r; $dados_frasesr_cee[$j][1]=$value-&gt;cod_frase_r; $dados_frasesr_cee[$j][2]=$value-&gt;desc_frase_r; $dados_frasesr_cee[$j][3]=$value-&gt;desc_frase_r_ing; $dados_frasesr_cee[$j][4]=$value-&gt;desc_frase_r_esp; $dados_frasesr_cee[$j][5]=$value-&gt;diretiva_frase_r; } } var_dump($dados_frasesr_cee); return $dados_frasesr_cee; } else { return; } } </code></pre> <p>I guess the select considers this var <code>$nomes_frasesr_cee[$j]</code> empty and she is not. If I replace the var directly by some string I have on database it works perfectly, so I don't get what is the problem with the var.</p> <p>Any hints? Thank you!</p> <p>Result of the var_dump($query1);</p> <pre><code>object(CI_DB_mysql_result)#21 (8) { ["conn_id"]=&gt; resource(29) of type (mysql link persistent) ["result_id"]=&gt; resource(43) of type (mysql result) ["result_array"]=&gt; array(0) { } ["result_object"]=&gt; array(0) { } ["custom_result_object"]=&gt; array(0) { } ["current_row"]=&gt; int(0) ["num_rows"]=&gt; int(0) ["row_data"]=&gt; NULL } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USuser1511579
    1. USuser1511579
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POcodeigniter database select comparing strings
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIs it an array? if so, you have to add comma's between them.
      singulars
      1. POcodeigniter database select comparing strings
      1. USKees Sonnema
    2. COdid u print the query ...like what kind of query is being fiered??\
      singulars
      1. POcodeigniter database select comparing strings
      1. USNishant Lad
    3. CO@kees sonnema, sorry, but commas between what? thank you!
      singulars
      1. POcodeigniter database select comparing strings
      1. USuser1511579
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload