SQL query does not return value

Question

Good afternoon to all.

I have a question about what could be going wrong in a database query in which I use templates in PHP. Based on this project: http://raelcunha.com/template/

All right, I deployed the project and everything works precisely, however, when creating a query to query the BD tables, it returns what is there, but, only a record.

$sql = mysql_query("SELECT * FROM users ORDER BY idS DESC") or die(mysql_error());
while($row = mysql_fetch_array($sql)){
$tpl->USER_SHOW_TITLE = $row['username'];
$tpl->USER_SHOW_DESC = substr($row['profi_desc'],0,125).'...';
}

I have tried several ways, but the reused is always the same! It shows only a record of the 5 that I have. :(

Answer 1

Try the following on:

$sql = mysql_query("SELECT * FROM users ORDER BY idS DESC") or die(mysql_error());
while($row = mysql_fetch_array($sql)){
print_r ($row);
}

With this we are asking to print the contents of the array, come all records is something in your while that is wrong.

As everyone is speaking in PDO, below follows example of selection using PDO:

$sql = $connection->query("SELECT * FROM users ORDER BY idS DESC");
while($row = $sql->fetch(PDO::FETCH_ASSOC)) {
    $tpl->USER_SHOW_TITLE = $row['username'];
    $tpl->USER_SHOW_DESC = substr($row['profi_desc'],0,125).'...';
}

Your PDO connection to the bank:

<?php
$dsn = 'mysql:dbname=tua_tabela;host=localhost';
$user = 'usuario_mysql';
$password = 'senha_mysql';

try {
    $connection = new PDO($dsn, $user, $password);
    $connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo 'Connection failed: ' . $e->getMessage();
}

?>

Answer 2

Avoid using the msql as the friend said, is obsolete.

Try this way

    $sql = mysql_query("SELECT * FROM users ORDER BY idS DESC") or die(mysql_error());
    while($row = mysql_fetch_array($sql)){
    $i[] = $row;
    }
    foreach($i as $v) {
    $tpl->USER_SHOW_TITLE = $v['username'];
    $tpl->USER_SHOW_DESC = substr($v['profi_desc'],0,125).'...';
}

If not, make sure you are not overwriting the variável and printing only the last in:

$tpl->USER_SHOW_TITLE 

Answer 3

I tried the riddle of this CLASS! Since it returns only one value, I can use the addFile method of the class itself. That is: addFile($str,$directory); With this, I can include a PHP file outside the class that runs the query without restrictions! Then, in the HTML template, just create the variable you used in Addfile.

$tpl->addFile('CONTEUDO','site/tpl/html/index.php');

in the index.html file put the variable:

{CONTEUDO}

And just like that!!

Thank you all for your assistance!