Estoy seleccionando de la base de datos MYSQL y necesito pasar todos los registros seleccionados a una matriz en el formato como este: Matriz
( [1] => Weather today is rubbish [2] => This cake looks amazing [3] => His skills are mediocre [4] => He is very talented [5] => She is seemingly very agressive [6] => Marie was enthusiastic about the upcoming trip. Her brother was also passionate about her leaving - he would finally have the house for himself. [7] => To be or not to be? )Quiero que la clave se genere automáticamente y se asigne a cada registro.
Aquí nosotros mi código:
$conn = new mysqli($servername, $username, $password, $dbname); $SQLCommand = "SELECT fback FROM feedback"; $result = mysqli_query($conn, $SQLCommand); $i = 1; $query = mysqli_query($conn, 'SELECT fback FROM feedback'); $tot = mysqli_num_rows($query); echo '<br/>You are having <b style="color:red;">' . $tot . '</b> tasks to do.<br/><br/>'; while($a = mysqli_fetch_array($query)) { echo $i++ . '. ' . $a[0] . '<br/>'; }$featured = array(); foreach($featured as $key => $value){ echo $a; }¿Quieres decir así?
$featured = array(); $count = 1; while($a = mysqli_fetch_array($query)) { $featured[$count] = $a[0]; $count++; } print_r($featured);$conn = new mysqli($servername, $username, $password, $dbname); $i = 1; $query = mysqli_query($conn, 'SELECT fback FROM feedback'); $tot = mysqli_num_rows($query); $results = mysqli_fetch_array($query); echo '<br/>You are having <b style="color:red;">' . $tot . '</b> tasks to do.<br/><br/>'; $arr = []; // Your array foreach($results as $value) { $arr[] = $value[0]; echo $i++ . '. ' . $value[0] . '<br/>'; }