function dbrows($query) {
$result = mysql_num_rows($query);
return $result;
}
function dbquery($query) {
$result = mysql_query($query);
if (!$result) {
echo mysql_error();
return false;
} else {
return $result;
}
}
function dbarray($query) {
$result = mysql_fetch_array($query);
if (!$result) {
echo mysql_error();
return false;
} else {
return $result;
}
}
function dbconnect($dbhost, $dbuser, $dbpass, $dbname){
$polacz = mysql_connect($dbhost, $dbuser, $dbpass);
$wybierz = mysql_select_db($dbname);
if (!$polacz) {
die("Polaczenie nie udane");
} elseif(!$wybierz){
die("Nie udalo sie wybrac bazy");
}
}
engine.php
<?
require_once "engine.php";
$result = dbquery("SELECT * FROM test GROUP BY user_id");
while(dbrows($result) != 0){
$dane = dbarray($result);
echo $dane['nazwisko']." ma ".$dane['imie']." plików";
}
?>
index.php
Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /var/www/sites/yoyo.pl/c/m/cms-test-strony/test.php on line 4
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /var/www/sites/yoyo.pl/c/m/cms-test-strony/test.php on line 4
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/sites/yoyo.pl/c/m/cms-test-strony/test.php on line 5
TEST
co jest?