如何将mysql数组转换为php数组

Question

        $cg= $mysqli->query("SELECT * FROM news WHERE id='$postid' 
        and  status='1' ORDER BY RAND()");
       while($sd= $cg->fetch_assoc()){
       $title= $sd['title'];

        }

What i want to do is turn var $title to something like

     $mytitle[1] = 'first title';

     $mytitle[2] = 'second title';

     $mytitle[3] = 'third title';
      $randnews= rand(1, 3);
      echo $mytitle[$randnews];

Answer 1

Try this,I have tried based on my database table query, It's working as you expected.

Code:-

<?php
     require_once("connect.php");
     $sql=("SELECT * FROM news WHERE id='$postid' and status='1' ORDER BY RAND()");
     $result = $con->query($sql); 
     while($row = $result->fetch_assoc()){
      $array[] = $row['title'];      
      }
     echo "After Sorting".'<pre>';
     print_r($array);
     echo '</pre>';     
?>

$con is variable of connection class.

$con=mysqli_connect($servername,$username,$password,$my_db);

Output:-

[xyz] => "test"
[abc] => "tester"
[pqr] => "user"
[res] => "test"

Hope this helps