Problema inserimento numero in array dopo query

[Dheed]

Salve,
praticamente se cerco di inserire $iden (contenente un numero intero) all'interno di un array quest'ultimo impazzisce ed elimina tutto...questo è il codice:

$book=normalize_str(htmlentities(preg_replace('/\s+/',' ',$_POST['book']),ENT_QUOTES,'UTF-8'));$filecat='../books/'.$book.'/'.$book.'.txt';$catlist=file($filecat, FILE_IGNORE_NEW_LINES | FILE_SKIP_EMPTY_LINES);
    
    $mysqli = new mysqli($Hostname,$Username,$Password,$DatabaseName);
    $stmt = $mysqli->stmt_init();
    if($stmt->prepare("SELECT `id`,`title`,`price`,`image`,`description`,`category`,`enablerating`,`rating` FROM ".$PapierTableName." WHERE `book`=? ORDER BY position ASC, title ASC")) {
        $stmt->bind_param('s', $book);
        $stmt->execute();
        if( $stmt->bind_result($iden,$title, $price,$image,$description,$category,$enrat,$rating)){
            $i=0;$rit=array();
            while ($stmt->fetch()) {
                $rit[$i]=array(invert_str(html_entity_decode($title,ENT_QUOTES,'UTF-8')),$price,invert_str(html_entity_decode($image,ENT_QUOTES,'UTF-8')),invert_str(html_entity_decode($description,ENT_QUOTES,'UTF-8')),invert_str(html_entity_decode($category,ENT_QUOTES,'UTF-8')),$enrat,$rating);
                $i++;
            }
            $stmt->close();
            $count=count($catlist);$ret=array();
            for($i=0;$i<$count;$i++){$ret=array_merge($ret,search($rit,4,$catlist[$i]));}
            echo json_encode($ret);
        }
        else
            file_put_contents('binderror.txt',$stmt->error);
    }
    else
        file_put_contents('connecterror.txt',$stmt->error); 

$iden contiene valori (corretti), ho provato anche (string)$iden.

Grazie

[Santino83_02]

if( $stmt->bind_result($iden,$title, $price,$image,$description,$category,$enrat,$rating)){ 
            $i=0;$rit=array(); 
            while ($stmt->fetch()) { 
                $rit[$i]=array(invert_str(html_entity_decode($title,ENT_QUOTES,'UTF-8')),$price,invert_str(html_entity_decode($image,ENT_QUOTES,'UTF-8')),invert_str(html_entity_decode($description,ENT_QUOTES,'UTF-8')),invert_str(html_entity_decode($category,ENT_QUOTES,'UTF-8')),$enrat,$rating); 
                $i++; 
            } 
            $stmt->close(); 
            $count=count($catlist);
            $ret=array(); 
            for($i=0;$i<$count;$i++){$ret=array_merge($ret,search($rit,4,$catlist[$i]));} 
            echo json_encode($ret); 
        } 

apparte nel bind_result, $iden non viene utilizzato da nessuna parte...

[Dheed]

Eh,se lo aggiungo in testa l'array sparisce,invece in qualsiasi altra posizione funziona...

[Dheed]

Nel senso che questo funziona:

$rit[$i]=array(invert_str(html_entity_decode($title,ENT_QUOTES,'UTF-8')),$price,invert_str(html_entity_decode($image,ENT_QUOTES,'UTF-8')),invert_str(html_entity_decode($description,ENT_QUOTES,'UTF-8')),invert_str(html_entity_decode($category,ENT_QUOTES,'UTF-8')),$enrat,$rating,$iden); 

e questo no:

$rit[$i]=array($iden,invert_str(html_entity_decode($title,ENT_QUOTES,'UTF-8')),$price,invert_str(html_entity_decode($image,ENT_QUOTES,'UTF-8')),invert_str(html_entity_decode($description,ENT_QUOTES,'UTF-8')),invert_str(html_entity_decode($category,ENT_QUOTES,'UTF-8')),$enrat,$rating); 

[Dheed]

Ho sbagliato

[Santino83_02]

che vuol dire impazzisce? errori? forme strane dell'array? var_dump su rit e $iden?

[Dheed]

Senza $iden in testa viene così:

Array
(
    [0] => Array
        (
            [0] => DB9
            [1] => 200031
            [2] => //localhost/css/images/objectimg/Aston Martin/db9.jpg
            [3] => contenuto html
            [4] => DB9
            [5] => 1
            [6] => 0
        )

    [1] => Array
        (
            [0] => Rapid S
            [1] => 200000
            [2] => //localhost/css/images/objectimg/Aston Martin/vanq.jpg
            [3] => <h1>The World&rsquo;s Most Beautiful 4-Door
 Sports Car</h1> 

Designing a more luxurious and more refined Rapide would have been a phenomenal achievement. Engineering a more powerful Rapide would have seen us take our industry leading technology to new heights. But we didn&rsquo;t settle on one, we did something incredible, we did both.</p> 

The result is an Aston Martin with more power and more luxury. An Aston Martin with the power of luxury, Rapide S.</p> 
            [4] => Rapid S
            [5] => 1
            [6] => 0
        )

)

con $iden in testa:

Array
(
)

con $iden in fondo:

Array
(
    [0] => Array
        (
            [0] => DB9
            [1] => 200031
            [2] => //localhost/css/images/objectimg/Aston Martin/db9.jpg
            [3] => roba html
            [4] => DB9
            [5] => 1
            [6] => 0
            [7] => 42
        )

    [1] => Array
        (
            [0] => Rapid S
            [1] => 200000
            [2] => //localhost/css/images/objectimg/Aston Martin/vanq.jpg
            [3] => roba html
            [4] => Rapid S
            [5] => 1
            [6] => 0
            [7] => 45
        )

)

[Santino83_02]

figata.... prova a metterlo in testa con

array(0 => $iden, ..... 

[Dheed]

Già provato,ma non cambia nulla

[Santino83_02]

Originariamente inviato da Dheed
Già provato,ma non cambia nulla

ma che figata di errore! ma var_dump su $iden che cosa riporta? ma neanche facendo cose del tipo array(0=>"".$iden ?