Problemas con mysql_db_query

[privatefta]

hola es que tengo este código para print en xml

Código PHP:

<?php
 
// Edit this 4 strings to match your system
$host = "localhost";
$user = "panel";
$pass = "panellenap";
$db = "panel";
 
$conn = @mysql_connect($host,$user,$pass) or die ("ERROR! No connection to database!");
$sql = mysql_db_query($db,"SELECT * FROM usuarios ORDER BY id_usuario ASC");
echo "<xml-user-manager ver=\"1.0\">\n";
while($line=mysql_fetch_row($sql)) {
    if ($line[2] == "") :
        $name = "";
    else :
        $name = "name=\"".$line[2]."\" ";
    endif;
    
    if ($line[3] == "") :
        $password = "";
    else :
        $password = "password=\"".$line[3]."\" ";
    endif;
    
    if ($line[6] == "") :
        $profiles = "";
    else :
        $profiles = "profiles=\"".$line[6]."\" ";
    endif;
    
    if ($line[7] == "") :
        $maxconnections = "";
    else :
        $maxconnections = "max-connections=\"".$line[7]."\" ";
    endif;
 
    if ($line[8] == "") :
        $enabled = "";
    else :
        $enabled = "enabled=\"".$line[8]."\" ";
    endif;
    
    if ($line[9] == "false" OR $line[9] == "") :
        $mapexclude = "";
    else :
        $mapexclude = "map-exclude=\"".$line[9]."\" ";
    endif;
    
    if ($line[10] == "false" OR $line[10] == "") :
        $debug = "";
    else :
        $debug = "debug=\"".$line[10]."\" ";
    endif;
    
    echo "<user ".$name.$password.$profiles.$maxconnections.$enabled.$mapexclude.$debug."/>\n";
}
echo "</xml-user-manager>";
mysql_close($conn);
?>
 

y me tira eror

Deprecated: Function mysql_db_query() is deprecated in C:\xampp\htdocs\panel\genxml\genxml.php on line 10

Deprecated: mysql_db_query() [function.mysql-db-query]: This function is deprecated; use mysql_query() instead in C:\xampp\htdocs\panel\genxml\genxml.php on line 10

[jahepi]

Hola privatefta !

A partir de PHP 5.3.0 no se recomienda utilizar la función mysql_db_query

Debes de utilizar las funciones mysql_select_db() y mysql_query() en su lugar.

Un saludo y suerte !

[privatefta]

ok pero le cambie y me tiro esto ahora

Warning: mysql_select_db() expects parameter 2 to be resource, string given in C:\xampp\htdocs\panel\genxml\genxml.php on line 10

Warning: mysql_fetch_row() expects parameter 1 to be resource, null given in C:\xampp\htdocs\panel\genxml\genxml.php on line 12

[jahepi]

Hola privatefta !

No le has pasado la referencia al recurso de la conexión, tienes que hacerlo de esta forma:

Código php:

$host = "localhost";
$user = "panel";
$pass = "panellenap";
$db = "panel";
 
$conn = @mysql_connect($host, $user, $pass) or die("ERROR! No connection to database!");
mysql_select_db($db, $conn) or die(mysql_error());
$sql = mysql_query("SELECT * FROM usuarios ORDER BY id_usuario ASC", $conn);
 

Un saludo y suerte !

[privatefta]

se queda en blanco y no muestra nada te paso la bd por pm

[privatefta]

tengo esta función

Código PHP:

<?php
 
$dbhost = "localhost";
$dbname = "panel";
$dbuser = "panel";
$dbpass = "panellenap";
 
$conn = @mysql_connect($dbhost,$dbuser,$dbpass) or die ("ERROR! No connection to database!");
mysql_select_db($dbname, $conn);
$usql = mysql_query("SELECT * FROM usuarios WHERE posicion='1' ORDER BY id_usuario ASC");
 
print("<xml-user-manager ver=\"1.0\">\n");
while($line=mysql_fetch_array($usql)) {
    if ($line["usuario"] == "") {
        $usuario = "";
    } else {
        $usuario = "name=\"".$line["usuario"]."\" ";
    }
    
    if ($line["contrasena"] == "") {
        $contrasena = "";
    } else {
        $contrasena = "password=\"".$line["contrasena"]."\" ";
    }
    
    if ($line["profiles"] == "") {
        $profiles = "";
    } else {
        $profiles = "profiles=\"".$line["profiles"]."\" ";
    }
    
    if ($line["maxconnections"] == "") {
        $maxconnections = "";
    } else {
        $maxconnections = "max-connections=\"".$line["maxconnections"]."\" ";
    }
    
    if ($line["enabled"] == "") {
        $enabled = "";
    } else {
        $enabled = "enabled=\"".$line["enabled"]."\" ";
    }
    
    if ($line["mapexclude"] == "") {
        $mapexclude = "";
    } else {
        $mapexclude = "map-exclude=\"".$line["mapexclude"]."\" ";
    }
    
    if ($line["debug"] == "") {
        $debug = "";
    } else {
        $debug = "debug=\"".$line["debug"]."\" ";
    }
    
    print("<user ".$usuario.$contrasena.$profiles.$maxconnections.$enabled.$mapexclude.$debug."/>\n");
}
print("</xml-user-manager>");
mysql_close($conn);
?>
 

pero no me muestra resultados

[privatefta]

ya lo resolvi jeje