Pagina 1 din 1

separare mysql conn [REZOLVAT]

Scris: Dum Ian 28, 2007 6:41 pm
de danut
salut,

incerc sa separ codul de conectare la o baza de date intr-un fisier DBConnect.inc
dar at cand includ fcn closedb() primesc eroarea de mai jos daca ati mai
intalnit eroarea as aprecea dc n-ati putea indruma un pic .:)



Warning: Missing argument 1 for conndb() in c:\program files\easyphp1-8\www\DBConnect.inc on line 4

Warning: Missing argument 2 for conndb() in c:\program files\easyphp1-8\www\DBConnect.inc on line 4

Warning: Missing argument 3 for conndb() in c:\program files\easyphp1-8\www\DBConnect.inc on line 4

Warning: Missing argument 4 for conndb() in c:\program files\easyphp1-8\www\DBConnect.inc on line 4

Warning: mysql_connect(): Access denied for user 'ODBC'@'localhost' (using password: NO) in c:\program files\easyphp1-8\www\DBConnect.inc on line 6
Eroare conexiune la baza de date
........

test.php

<? error_reporting(E_ALL);

include_once 'DBConnect.inc';

$ip = '127.0.0.1';
$user = 'root';
$pass = null;
$nameDB = 'msoa';


connDB($ip,$user,$pass,$nameDB);
$result = queryDB("SELECT * FROM accounts");


while ($row = mysql_fetch_array($result))
{

echo $row['Nume'].' ';
}

closeDB(); // <--- PROBLEMA??

?>


DBConnect.inc
----------------
<?php
error_reporting(E_ALL);

function connDB($ip,$user,$pass,$nameDB) {

$conn = mysql_connect("$ip","$user","$pass") or die("Eroare conexiune la baza de date");
mysql_select_db($nameDB,$conn) or die("Eroare selectare baza de date");

return $conn;
}

function queryDB($query_string) {

$query = $query_string;
$r = mysql_query($query) or die("Eroare Query".mysql_error());

return $r;
}
function closeDB() {
//mysql_close(connDB());
}

?>[/code]

Scris: Dum Ian 28, 2007 6:50 pm
de danut
mysql_close() closes the non-persistent connection to the MySQL server that's associated with the specified link identifier. If link_identifier isn't specified, the last opened link is used.

am pus doar mysql_close(); in test.php

REZOLVAT