bo takie cos dziala::
Kod
$conn_data=file("./system/connection_data");
$dbconnhandle = pg_connect("host=".trim($conn_data[0])." port=".trim($conn_data[1])." dbname=".trim($conn_data[2])." user=".trim($conn_data[3])." password=".trim($conn_data[4]));
//bla bla
$result=pg_query($dbconnhandle, "SELECT * FROM pracownicy WHERE \"LOGIN\"='".$_POST["login"]."';");
while ($row = pg_fetch_array($result)) {
echo $row[0];
}
$dbconnhandle = pg_connect("host=".trim($conn_data[0])." port=".trim($conn_data[1])." dbname=".trim($conn_data[2])." user=".trim($conn_data[3])." password=".trim($conn_data[4]));
//bla bla
$result=pg_query($dbconnhandle, "SELECT * FROM pracownicy WHERE \"LOGIN\"='".$_POST["login"]."';");
while ($row = pg_fetch_array($result)) {
echo $row[0];
}
i widac ze zapytanie daje jakies wyniki.
ale jak rozwale do funkcji::
Kod
function check($arg1){
global $dbconnhandle;
$result=pg_query($dbconnhandle, "SELECT * FROM pracownicy WHERE \"LOGIN\"='".$arg1."';");
if (!$result) {
echo "query did not execute";
}
if ($line = pg_fetch_assoc($result)) {
if ($line['rows'] == 0) {
echo "0 records";
return 0;
}
}else{
while ($row = pg_fetch_array($result)) {
echo $row[1];
}
}
}
$conn_data=file("./system/connection_data");
$dbconnhandle = pg_connect("host=".trim($conn_data[0])." port=".trim($conn_data[1])." dbname=".trim($conn_data[2])." user=".trim($conn_data[3])." password=".trim($conn_data[4]));
check($_POST["login"]);
global $dbconnhandle;
$result=pg_query($dbconnhandle, "SELECT * FROM pracownicy WHERE \"LOGIN\"='".$arg1."';");
if (!$result) {
echo "query did not execute";
}
if ($line = pg_fetch_assoc($result)) {
if ($line['rows'] == 0) {
echo "0 records";
return 0;
}
}else{
while ($row = pg_fetch_array($result)) {
echo $row[1];
}
}
}
$conn_data=file("./system/connection_data");
$dbconnhandle = pg_connect("host=".trim($conn_data[0])." port=".trim($conn_data[1])." dbname=".trim($conn_data[2])." user=".trim($conn_data[3])." password=".trim($conn_data[4]));
check($_POST["login"]);
to wyswietla tylko '0 records';
huh ?
(co mniej wazna reszta kodu pominieta)