Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

Salutare. Detin un site 1001cabinetemedicale.ro Am scris adresa ca sa vedeti exact problema cu pricina. Nu fac nici un fel de reclama, am o problema si nu stiu deloc php, stiu doar sa il administrez. Problema cu el este ca daca intru ca vizitator nu apare nici o eroare daca ma duc la rubrica servicii medicale si intru pe o categorie, apoi pe un client. Daca fac acelasi lucru ca utilizator inregistrat imi apare urmatoarea eroare:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/cabinete/public_html/items.php on line 189

mai jos o sa atasez codul din fisierul cu pricina items.php poate stie cineva care e problema ca eu ma uit la linia 189 si nu pricep nimic. va rog sa ma ajutati. site-ul functioneaza bine desi imi apare eroarea, totusi nu da bine sa apara asa ceva cand viziteaza cineva site-ul. Daca stie cineva cum trebuie sa arate exact linia 189 sa imi zica, sau daca in acest fisier se face referire la alte fisiere care trebuie vazute cu cea mai mare placere o sa postez si continutul (codul) acestora. Va multumesc.

<?php
include("admin/config.php");

$ipgf=99;

include("admin/$languagefile");
include("functions.php");
if (isset($_GET['open'])) include("functions_pcode.php");
include("auth.php");
//Title
session_start();
$_SESSION['titlu_pagina'] = "Cabinete medicale, servicii medicale, farmacii";
if (isset($_GET['oi']))
{
$id_categorie=(int)$_GET['oi'];
$sql_111 = "SELECT `descr` FROM dj_items WHERE id={$id_categorie};";
$res_111 = mysql_query($sql_111);
$_SESSION['titlu_pagina'] = mysql_result($res_111, 0, 'descr');

}
//End of title
include($skindir."/layout.php");
session_register("dev_cart");

$mdl=7;
dump_begin();
load_tpl();

// Start content -----------------------------------------------------------------

if (isset($_GET['oi'])) $oi=(int)$_GET['oi'];
if (isset($_GET['ai'])) $ai=(int)$_GET['ai'];
$st=(int)$_GET['st'];

list($myai,$myoi,$mytab)=explode(';',$u_profile);

techo (dump_button("myreg.php","b_editeaza.gif"),"b_editeaza");
techo (dump_button("items_add.php","b_inscriere.gif"),"b_inscriere");

// cats view

if (!isset($oi)) {
thide ('items'); thide ('item');
$data=mysql_query("SELECT * FROM $dj_items ORDER BY title");

while ($x=mysql_fetch_array($data)) {
if ($x['catpic']) secho ($x['catpic'],'catpic','r0');
techo ($x['title'],'title','r0');
techo ("items.php?oi={$x['id']}", 'link','r0');
techo ($x['total'],'total','r0');
tclose ('r0');
}

dump_header('FURNIZORI');

}

// items view
if ((isset($oi))&&(!isset($ai))) {
thide ('cats'); thide ('item');



$c=mysql_fetch_array(dbquery("SELECT * FROM $dj_items WHERE id=$oi LIMIT 0,1"));


dump_header("<a href=\"items.php\" class=\"head\">SERVICII MEDICALE</a> > {$c['title']}");

techo (dump_banner('furnizori',0),'banner');

// filter

$tmp1=explode(';',$c['field_names']);
$tmp2=explode(';',$c['field_types']);
$tmp3=explode(';',$c['field_attr']);
$tmp4=explode(';',$c['field_filter']);

$filters=0; $pagequery=''; $query='';

for ($i=0; $i<count($tmp1); $i++) {
if ($tmp4[$i]) {
techo ($tmp1[$i],'title','r3');
switch ($tmp2[$i]) {
case 'multiple select':
case 'select':
secho (tablename($tmp1[$i]),'fselect','r3');
$tmp5=explode('~',$tmp3[$i]);
for ($j=0; $j<count($tmp5); $j++) {
techo (base64_encode($tmp5[$j]),'value','r3.r4');
techo ($tmp5[$j],'label','r3.r4');
if (base64_encode($tmp5[$j])==$_GET[tablename($tmp1[$i])]) techo (' selected','selected','r3.r4');
tclose ('r3.r4');
}

if ($tmp2[$i]=='multiple select') {
if (($_GET[tablename($tmp1[$i])]!=-1)&&(isset($_GET[tablename($tmp1[$i])]))) {
$pagequery.=tablename($tmp1[$i]).'='.$_GET[tablename($tmp1[$i])].'&';
$query.=tablename($tmp1[$i]).' LIKE \'%~'.dbcleanup(base64_decode($_GET[tablename($tmp1[$i])])).'~%\' AND ';
}} else {
if (($_GET[tablename($tmp1[$i])]!=-1)&&(isset($_GET[tablename($tmp1[$i])]))) {
$pagequery.=tablename($tmp1[$i]).'='.$_GET[tablename($tmp1[$i])].'&';
$query.=tablename($tmp1[$i]).'=\''.dbcleanup(base64_decode($_GET[tablename($tmp1[$i])])).'\' AND ';
}
}

break;
case 'numeric':
for ($j=0; $j<=3; $j++) {
techo ($j,'value','r3.r5');
techo ($l_fnum[$j],'label','r3.r5');
if (($j==$_GET[tablename($tmp1[$i]).'_sign'])&&(isset($_GET[tablename($tmp1[$i]).'_sign']))) techo (' selected','selected','r3.r5');
tclose ('r3.r5');
}
techo ((int)$_GET[tablename($tmp1[$i])],'value','r3');
techo ((int)$_GET[tablename($tmp1[$i]).'_v2'],'value_v2','r3');
secho (tablename($tmp1[$i]),'fnumeric','r3');

techo ($i,'count','r3');
if ($_GET[tablename($tmp1[$i]).'_sign']==3) secho ('','display','r3');

if (($_GET[tablename($tmp1[$i]).'_sign']!=-1)&&(isset($_GET[tablename($tmp1[$i]).'_sign']))) {
$pagequery.=tablename($tmp1[$i]).'='.(int)$_GET[tablename($tmp1[$i])].'&'.tablename($tmp1[$i]).'_sign='.$_GET[tablename($tmp1[$i]).'_sign'].'&';
if ((int)$_GET[tablename($tmp1[$i]).'_v2']) $pagequery.=tablename($tmp1[$i]).'_v2='.(int)$_GET[tablename($tmp1[$i]).'_v2'];

switch ($_GET[tablename($tmp1[$i]).'_sign']) {
case 0: $semn='>'; break;
case 1: $semn='='; break;
case 2: $semn='<'; break;
case 3: $semn='>='; $query.=tablename($tmp1[$i]).'<='.(int)$_GET[tablename($tmp1[$i]).'_v2'].' AND ';
}
$query.=tablename($tmp1[$i]).$semn.(int)$_GET[tablename($tmp1[$i])].' AND ';
}

break;
case 'checkbox':
secho (tablename($tmp1[$i]),'fcheckbox','r3');
if ($_GET[tablename($tmp1[$i])]) {
techo (' checked','checked','r3');
$pagequery.=tablename($tmp1[$i]).'=1&';
$query.=tablename($tmp1[$i]).'=1 AND ';
}
break;
}
tclose ('r3');
$filters++;
}
}

if ((!$filters)) thide ('filter');
else
techo (dump_button("submit","b_ok.gif"), 'b_ok');

// end

$total=mysql_result(dbquery("SELECT COUNT(*) FROM {$dj_items}_".tablename($c['title'])." WHERE {$query}pending=0"),0,0);
if ($total) thide ('msg'); else techo ('Aceasta categorie este goala.<br><br>','msg');

$data=dbquery("SELECT * FROM {$dj_items}_".tablename($c['title'])." WHERE {$query} pending=0 ORDER BY weight,".tablename($tmp1[0])." LIMIT $st,$ipgf");
while ($x=mysql_fetch_array($data)) {
techo ($x[tablename($tmp1[0])],'title','r1');
techo ("items.php?oi=$oi&ai=${x['id']}&st=$st&open=-1",'link','r1');

techo ("items.php?oi=$oi&ai={$x['id']}&st=$st&open=-1#com","linkcom","r1");
techo ($x['comments'],"comments","r1");
if ($x['score']) secho (dump_stars($x['score'],1),'score','r1');

if ($x['x_banner']) secho ($x['banner_furnizor'],'logo','r1');

tclose ('r1');
}

$pags=ceil($total/$ipgf); if (!$pags) $pags++;
$cpag=(floor($st/$ipgf)+1);
techo ("$pags","pags");
techo ("$cpag","cpag");
dump_pages ($st, $total, "items.php?{$pagequery}oi=$oi&st=%s");

}

// item view
if ((isset($oi))&&(isset($ai))) {

$picnr=0;

if (!isset($_GET['pic'])) {
thide ('cats'); thide ('items'); thide ('thepic');

$c=mysql_fetch_array(dbquery("SELECT * FROM $dj_items WHERE id=$oi LIMIT 0,1"));
if ($dj_auth) $fav=mysql_fetch_array(dbquery("SELECT * FROM {$dj_items}_favorites WHERE itemid=$ai AND itemparentid=$oi AND ownerid=$u_id LIMIT 0,1"));

$tmp1=explode(';',$c['field_names']);
$tmp2=explode(';',$c['field_types']);
$tmp3=explode(';',$c['field_attr']);
$tmp4=explode(';',$c['field_filter']);
$tmp5=explode(';',$c['field_neplatitor']);

$ix=mysql_fetch_array(dbquery("SELECT * FROM {$dj_items}_".tablename($c['title'])." WHERE id=$ai AND (pending=0 OR ownerid=$u_id) LIMIT 0,1"));
$filters=0;

if ($u_id==$ix['ownerid']) {
$editid=-1;
$tmpx=explode('`',$u_profile);
for ($i=0; $i<count($tmpx); $i++) {
$tmpy=explode(';',$tmpx[$i]);
if ($tmpy[0]==$ai) $editid=$i;
}
if ($editid!=-1) techo (dump_button("items_edit.php?id=$editid","b_editthispage.gif"),"b_editthispage");
}

if ($ix['neplatitor']) thide ('extras');

for ($i=0; $i<count($tmp1); $i++)
if (($ix[tablename($tmp1[$i])])&& ((!$tmp5[$i])||(($tmp5[$i])&&(!$ix['neplatitor'])))) {

if (!$itemtitle) $itemtitle=$ix[tablename($tmp1[$i])];

techo ($tmp1[$i],'label','r2');
switch ($tmp2[$i]) {
case 'checkbox': secho ('','checkbox','r2'); break;
case 'picture':
secho ($ix[tablename($tmp1[$i])],'picture','r2');
$size=@getimagesize('pics/items/'.$ix[tablename($tmp1[$i])]);
techo ($size[0],'sx','r2');
techo ($size[1],'sy','r2');
techo ("items.php?oi=$oi&ai=$ai&st=$st&open=$open&pic=$i",'linkpic','r2');
if ((ereg('^Poza [0-9]+$',$tmp1[$i]))||(ereg('^Exemplu poza [0-9]+$',$tmp1[$i]))) $picnr++;
break;
case 'multiple select':
secho (str_replace('~',', ',trim($ix[tablename($tmp1[$i])],'~')),'text','r2');
break;
default: secho (nl2br($ix[tablename($tmp1[$i])]),'text','r2');
}
tclose('r2');

}

if (!$picnr) thide('pana');

$mdl=(int)('99'.$c['id']); $modules[$mdl]['Table']=$dj_items.'_'.tablename($c['title']);
dump_vote($mdl,$ai,$ix['score']);
dump_comments($mdl,$ai,$ix['comments']);

dump_header("<a href=\"items.php\" class=\"head\">FURNIZORI</a> > <a href=\"items.php?oi=$oi&st=$st\" class=\"head\">{$c['title']}</a> > ".$ix[tablename($tmp1[0])]);

if ((isset($_GET['add']))&&(!$fav)) {
$itemtable="{$dj_items}_".tablename($c['title']);
$itemparent=$c['title'];
dbquery("INSERT INTO {$dj_items}_favorites (ownerid,ownerdata,itemid,itemtitle,itemtable,itemparent,itemparentid) VALUES ($u_id,'$u_nick',$ai,'$itemtitle','$itemtable','$itemparent','$oi')");
}

} else {
thide ('cats'); thide ('items'); thide ('theitem');
$c=mysql_fetch_array(dbquery("SELECT * FROM $dj_items WHERE id=$oi LIMIT 0,1"));
$ix=mysql_fetch_array(dbquery("SELECT * FROM {$dj_items}_".tablename($c['title'])." WHERE id=$ai AND (pending=0 OR ownerid=$u_id) LIMIT 0,1"));
$pic=(int)$_GET['pic'];
$tmp=explode(';',$c['field_names']);
techo('../pics/items/'.$ix[tablename($tmp[$pic])],'thepic');

dump_header("<a href=\"items.php\" class=\"head\">FURNIZORI</a> > <a href=\"items.php?oi=$oi&st=$st\" class=\"head\">{$c['title']}</a> > <a href=\"items.php?oi=$oi&ai=$ai&st=$st\">{$ix[tablename($tmp[0])]}</a> > Poza");

}
}

// End content -----------------------------------------------------------------

tpl_dump();

dump_end();
mysql_close();
?>

Programatorul care a scris codul ar fi terbuit sa aiba cod si pentru cazurile in care nu se gaseste nimic in baza de date. Daca totusi asta nu influenteaza cu nimic functionalitatea dorita, poti pur si simplu sa faci site-ul sa nu mai afiseze warning:

error_reporting(0);

Cand vrei sa faci modificari la cod, stergi aceasta linie si apoi o pui la loc.