проблем с заявка (не се добавят в БД)

U

uphero

Registered
ето я заявката проблема е,че не се добавят резултатите в базата данни
Код: 
<?php
$s = mysql_query('SELECT * FROM `servers`  WHERE cid="22"');
while($r = mysql_fetch_array($s))
{
		$sinfo = query($r[ip], $r[port], 'info');

    if($sinfo){$status = 'green';



$game = $r[game];
if($game==cs)
{
$game='cs1.6';
}
  $karta = isset($sinfo[mapname]) ? $sinfo[mapname] : 'N/A';

$sinfo[players] = isset($sinfo[players]) ? $sinfo[players] : 0;

$sinfo[maxplayers] = isset($sinfo[maxplayers]) ? $sinfo[maxplayers] : 0;

  $players = $sinfo[players].'/'.$sinfo[maxplayers];
$play=$sinfo[players];
$maxplay=$sinfo[maxplayers];
$r[ip]=gethostbyname($r[ip]);

		$sida= $r[sid];
		$imeto=$r[ime];
		$ip= $r[ip];
		$port=$r[port];
		$mail=$r[mail];
		$dop=$r[dop];
		$views=$r[views];
		$hash=$r[hash];
			$url=$r[url];
		$cida=$r[cid];
		
		
$sql= mysql_query("INSERT INTO servers( dop,ime) VALUES ('$dop', '$imeto')");
	  echo "ok";
}
	}

	?>
 
PHP: 
<?php
$s = mysql_query('SELECT * FROM `servers`  WHERE cid="22"');
while($r = mysql_fetch_array($s))
{
	$sinfo = query($r['ip'], $r['port'], 'info');

    if($sinfo){
	$status = 'green';



$game = $r['game'];
if($game==cs)
{
$game='cs1.6';
}
  $karta = isset($sinfo['mapname']) ? $sinfo['mapname'] : 'N/A';

$sinfo['players'] = isset($sinfo['players']) ? $sinfo['players'] : 0;

$sinfo['maxplayers'] = isset($sinfo['maxplayers']) ? $sinfo['maxplayers'] : 0;

  $players = $sinfo['players'].'/'.$sinfo['maxplayers'];
$play=$sinfo['players'];
$maxplay=$sinfo['maxplayers'];
$r['ip']=gethostbyname($r['ip']);

		$sida= $r['sid'];
		$imeto=$r['ime'];
		$ip= $r['ip'];
		$port=$r['port'];
		$mail=$r['mail'];
		$dop=$r['dop'];
		$views=$r['views'];
		$hash=$r['hash'];
			$url=$r['url'];
		$cida=$r['cid'];
		
		
$sql= mysql_query("INSERT INTO servers(dop,ime) VALUES ('$dop', '$imeto')");
	  echo "ok";
}
	}

	?>
 
PHP: 
<?php
$dbhost = "localhost"; 
$dbuser = "root@localhost";  
$dbpass = ""; 
$dbname = "test"; 

@mysql_connect($dbhost,$dbuser,$dbpass);
@mysql_select_db($dbname) or die(mysql_error());
$s = mysql_query('SELECT * FROM `servers`  WHERE cid="22"');
while($r = mysql_fetch_array($s))
{
	$sinfo = query($r['ip'], $r['port'], 'info');

    if($sinfo){
	$status = 'green';



$game = $r['game'];
if($game==cs)
{
$game='cs1.6';
}
  $karta = isset($sinfo['mapname']) ? $sinfo['mapname'] : 'N/A';

$sinfo['players'] = isset($sinfo['players']) ? $sinfo['players'] : 0;

$sinfo['maxplayers'] = isset($sinfo['maxplayers']) ? $sinfo['maxplayers'] : 0;

  $players = $sinfo['players'].'/'.$sinfo['maxplayers'];
$play=$sinfo['players'];
$maxplay=$sinfo['maxplayers'];
$r['ip']=gethostbyname($r['ip']);

		$sida= $r['sid'];
		$imeto=$r['ime'];
		$ip= $r['ip'];
		$port=$r['port'];
		$mail=$r['mail'];
		$dop=$r['dop'];
		$views=$r['views'];
		$hash=$r['hash'];
			$url=$r['url'];
		$cida=$r['cid'];
		
		
$sql= mysql_query("INSERT INTO servers(dop,ime) VALUES ('$dop', '$imeto')");
	  echo "ok";
}
	}

	?>
 
Radko каза:
Конектнал ли си се преди това към БДто?
Увеличете...
да ето целия код
Код: 
 <?php
$m_time = explode(" ",microtime()); 
$m_time = $m_time[0] + $m_time[1]; 
$starttime = $m_time;

DEFINE('human',true);
include('includes/functions.php');
include('includes/config.php');
include('includes/mysql.class.php');
$db=new Mysql($dbhost,$dbuser,$dbpasswd,$dbname);
?>   
   <?php
$s = mysql_query('SELECT * FROM `servers`  WHERE cid="22"');
while($r = mysql_fetch_array($s))
{
        $sinfo = query($r['ip'], $r['port'], 'info');

    if($sinfo){
        $status = 'green';



$game = $r['game'];
if($game==cs)
{
$game='cs1.6';
}
  $karta = isset($sinfo['mapname']) ? $sinfo['mapname'] : 'N/A';

$sinfo['players'] = isset($sinfo['players']) ? $sinfo['players'] : 0;

$sinfo['maxplayers'] = isset($sinfo['maxplayers']) ? $sinfo['maxplayers'] : 0;

  $players = $sinfo['players'].'/'.$sinfo['maxplayers'];
$play=$sinfo['players'];
$maxplay=$sinfo['maxplayers'];
$r['ip']=gethostbyname($r['ip']);

                $sida= $r['sid'];
                $imeto=$r['ime'];
                $ip= $r['ip'];
                $port=$r['port'];
                $mail=$r['mail'];
                $dop=$r['dop'];
                $views=$r['views'];
                $hash=$r['hash'];
                        $url=$r['url'];
                $cida=$r['cid'];
                
                
$sql= mysql_query("INSERT INTO servers(dop,ime) VALUES ('$dop', '$imeto')");
          echo "ok";
}
        }

        ?>

sql
Код: 
CREATE TABLE IF NOT EXISTS `server` (
  `ime` text CHARACTER SET ucs2 COLLATE ucs2_unicode_ci NOT NULL,
  `ip` text NOT NULL,
  `port` text NOT NULL,
  `cid` text NOT NULL,
  `dop` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `mail` text NOT NULL,
  `url` text NOT NULL,
  `hash` text NOT NULL,
  `od` text NOT NULL,
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `views` text NOT NULL,
  `vip` text NOT NULL,
  `game` text NOT NULL,
  `karta` text NOT NULL,
  `play` text NOT NULL,
  `maxplay` text NOT NULL,
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=71 ;
[/quote]
 
$sql= mysql_query("INSERT INTO servers(dop,ime) VALUES ('$dop', '$imeto')");
echo "ok";

Промени го на

server и предполагам ще добавя вече :)
 
dakata__92 каза:
$sql= mysql_query("INSERT INTO servers(dop,ime) VALUES ('$dop', '$imeto')");
echo "ok";

Промени го на

server и предполагам ще добавя вече :)
Увеличете...
3 дена се мъча с тая заявка :D и съм добавил 128 резултата в друга таблица
 
Трябва да си влезнал или регистриран, за да отговориш тук.

Back
Горе