rssloader / db.inc.php

<?php

//-------------------------------------------------
/*define('DB_HOST','localhost');
define('DB_NAME','tsetky6713_17300');
define('DB_LOGIN','ynizsds713_17300');
define('DB_PASSWORD','');*/

define('DB_HOST','localhost');
define('DB_NAME','testbase8');
define('DB_LOGIN','root');
define('DB_PASSWORD','');

define('LOG_FILE','logfile.txt');




//-------------------------------------------------
function getSingle ($insql) {


   $result=mysql_query($insql);

   if (mysql_errno()>0) {
      return (mysql_errno().":".mysql_error());
   }

   $row=mysql_fetch_array($result,MYSQL_NUM);
   return $row[0];
}
//-------------------------------------------------
function getQuery($insql) {
   //return "test";


   $result=mysql_query($insql);

   if (mysql_errno()>0) {
      return (mysql_errno().":".mysql_error());
   }

   $nfields=mysql_num_fields($result);
   $n_items=0;
   while (($row=mysql_fetch_array($result,MYSQL_NUM)) && ($n_items<50)) {

      $n_items++;
      $item=array();
      for ($i=0;$i<$nfields;$i++) {
         $item[]=$row[$i];
      }
      $items[]=$item;
      //unset $item;

   }
   return $items;


}
//-------------------------------------------------
function insertQuery ($insql,$fields,$values) {


   $sql=str_replace('%fields%',implode(',',$fields),$insql);
   $sql=str_replace('%values%',implode(',',$values),$sql);

   $status=mysql_query($sql);

   if (mysql_errno()>0) {
      return ($sql." : ".mysql_errno().":".mysql_error());
   } else
   return 'Status Ok: '.$status ;

}

//-------------------------------------------------
function conn() {
$conn=mysql_connect(DB_HOST,DB_LOGIN,DB_PASSWORD);
mysql_select_db(DB_NAME);

if (mysql_errno()>0) {
   return ( mysql_errno(). ":" . mysql_error());
} else {
    return 0;}

}

//$nqueries= getSingle('select count(*) from gqueries');
//$nresults= getSingle('select count(*) from gresults');
//echo "status: queries $nqueries, results $nresults";



?>