Problema Ar Scriptu Negrib Vievienot Sqlite3 Datubazei

[Lancom]

Problema ar scriptu scripts negrib pievienot serveri SQLite3 datu bazei.

SQLite3 Versija 3.7.6.3

<?php

try
{
   $db = new PDO('sqlite:C:\MasterServer\HLMasterServer.db');

   if($_POST['submit'])
   {
       $challenge = rand(1,999);
       $_address = $_POST['_address'];
       $_lastHeartBeat = "2147483647";
       $protocol = "47";
       $players = null;
       $max = null;
       $bots = null;
       $gamedir = "cstrike";
       $map = null; // add null
       $type = "d";
       $password = null;
       $os = null;
       $secure = null;
       $lan = null;
       $version = "1.1.2.5";
       $region = "255";
       $product = "cstrike";
       $gameport = null;
       $specport = null;
       $dedicated = null;
       $appid = null;
       $proxy = null;
       $gdversion = null;
       $nap = "10";
       $rating = null;
       $rated_order = null;
   }

   $db->exec("CREATE TABLE gameServers (challenge INTEGER PRIMARY KEY, _address TEXT, _lastHeartBeat TEXT, protocol TEXT, players TEXT, max TEXT, bots TEXT, gamedir TEXT, map TEXT, type TEXT, password TEXT, os TEXT, secure TEXT, lan TEXT, version TEXT, region TEXT, product TEXT, gameport TEXT, specport TEXT, dedicated TEXT, appid TEXT, proxy TEXT, gdversion TEXT, nap TEXT, rating TEXT, rating_order TEXT)");

   $db->exec("INSERT INTO gameServers (challenge, _address, _lastHeartBeat, protocol, players, max, bots, gamedir, map, type, password, os, secure, lan, version, region, product, gameport, specport, dedicated, appid, proxy, gdversion, nap, rating, rated_order) VALUES ('$challenge','$_address','$_lastHeartBeat','$protocol','$players','$max','$bots','$gamedir','$map','$type','$password','$os','$secure','$lan','$version','$region','$product','$gameport','$specport','$dedicated','$appid','$proxy','$gdversion','$nap','$rating','$rated_order');");
   echo "Success added!!!";

   $db = null;

   }

   catch(PDOException $e)
   {
       print 'Exception: '.$e->getMessage();
   }
?>

<form action="" method="post">
<input type="text" name="_address" />
<input type="submit" />
</form>

Edited June 29, 2011 by Lancom

[Lancom]

Up!

[KpC]

Ko rāda php debugs? Maybe tev uz servera ir aizliegta exec() funkcija?

[sLIDe]

KpC, viņš izmanto PDO klases exec funkciju, nevis parasto PHP exec.

Exception tev neko nemet?

Vispār kaut kas tiek atgriezts? Vai submitojot parādās vienkārša forma?

Edited July 1, 2011 by sLIDe

[BOT^a]

tas exec ir pdo klases funkcija nevis integreetaa php exec() funkcija, un pdo ir multi datubaazhu klase http://www.php.net/manual/en/book.pdo.php!!!

Edited July 1, 2011 by BOT^a

[Lancom]

var_dump rada array(1) { ["_address"]=> string(20) "ip servra:27017" } tas rada ka es sutu formu uz SQLite3 datu bazi bet tur serveris neparadas!

Exception vispar neko nerada!

es uzrakstiju error_reporting(8191) auksa un nekadas kludas neparadas, kur var but vaina.

error_reporting(8191) - tas paradit visas kludas.

Edited July 3, 2011 by Lancom

[sLIDe]

Tev

echo "Success added!!!";

parādās?

[Lancom]

Kak es uzpiezu pievienot, man paradas HLMasterServer.db bet visi laucini tuksi.

[sLIDe]

try

{

echo 'Starting try<br />';

$db = new PDO('sqlite:C:\MasterServer\HLMasterServer.db');

echo 'Created PDO object<br />';

var_dump($db);

echo '<br />POST array<br />';

var_dump($_POST);

if($_POST['submit'])

{

echo '<br />$_POST['submit'] active<br />';

$challenge = rand(1,999);

$_address = $_POST['_address'];

$_lastHeartBeat = "2147483647";

$protocol = "47";

$players = null;

$max = null;

$bots = null;

$gamedir = "cstrike";

$map = null; // add null

$type = "d";

$password = null;

$os = null;

$secure = null;

$lan = null;

$version = "1.1.2.5";

$region = "255";

$product = "cstrike";

$gameport = null;

$specport = null;

$dedicated = null;

$appid = null;

$proxy = null;

$gdversion = null;

$nap = "10";

$rating = null;

$rated_order = null;

}

$db->exec("CREATE TABLE gameServers (challenge INTEGER PRIMARY KEY, _address TEXT, _lastHeartBeat TEXT, protocol TEXT, players TEXT, max TEXT, bots TEXT, gamedir TEXT, map TEXT, type TEXT, password TEXT, os TEXT, secure TEXT, lan TEXT, version TEXT, region TEXT, product TEXT, gameport TEXT, specport TEXT, dedicated TEXT, appid TEXT, proxy TEXT, gdversion TEXT, nap TEXT, rating TEXT, rating_order TEXT)") or die(print_r($db->errorInfo()));

$db->exec("INSERT INTO gameServers (challenge, _address, _lastHeartBeat, protocol, players, max, bots, gamedir, map, type, password, os, secure, lan, version, region, product, gameport, specport, dedicated, appid, proxy, gdversion, nap, rating, rated_order) VALUES ('$challenge','$_address','$_lastHeartBeat','$protocol','$players','$max','$bots','$gamedir','$map','$type','$password','$os','$secure','$lan','$version','$region','$product','$gameport','$specport','$dedicated','$appid','$proxy','$gdversion','$nap','$rating','$rated_order');") or die(print_r($db->errorInfo()));

echo "Success added!!!";

$db = null;

}

catch(PDOException $e)

{

print 'Exception: '.$e->getMessage();

}

?>

<form action="" method="post">

<input type="text" name="_address" />

<input type="submit" />

</form>

Pamēģini šo un skaties, kas sanāk.

[worm]

btw sintakse ceļam līdz failam ir ar / svītrām nevis \, jo \ svītu izmanto, lai eskeipotu čarakterus

tb:

$db = new PDO('sqlite:C:/MasterServer/HLMasterServer.db');

ja tu gribi izmantot \ tad ir jāliek divas \\