Topic: problemos jungiantis i db

Sveiki

pradejau dometis mysql pasirasiau mini scriptuka bet niekaip neiseina susidoroti su mysql bandziau kelis variantus. 1 pagal tutoriala

<?php
    $vardas=$_POST['vardas'];
    $kodas=$_POST['kodas'];
    $db = mysql_connect(“localhost”, “root”, “”);
        mysql_select_db("db");
        mysql_query("INSERT INTO vartotojai VALUES (‘mama’, ‘gssk’)");
        mysql_close($db);
        echo "baigta";
?>

gavau sitokius erorus


Notice: Use of undefined constant “localhost” - assumed '“localhost”' in C:\wamp\www\uzrasyti.php on line 12

Notice: Use of undefined constant “root” - assumed '“root”' in C:\wamp\www\uzrasyti.php on line 12

Notice: Use of undefined constant “” - assumed '“”' in C:\wamp\www\uzrasyti.php on line 12

Warning: mysql_connect() [function.mysql-connect]: php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\wamp\www\uzrasyti.php on line 12

Warning: mysql_connect() [function.mysql-connect]: [2002] php_network_getaddresses: getaddrinfo failed: No such host is kn (trying to connect via tcp://“localhost”:3306) in C:\wamp\www\uzrasyti.php on line 12

Warning: mysql_connect() [function.mysql-connect]: php_network_getaddresses: getaddrinfo failed: No such host is known. in C:\wamp\www\uzrasyti.php on line 12

Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\uzrasyti.php on line 13

Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in C:\wamp\www\uzrasyti.php on line 13

Warning: mysql_query() [function.mysql-query]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\uzrasyti.php on line 14

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\wamp\www\uzrasyti.php on line 14

Warning: mysql_close() expects parameter 1 to be resource, boolean given in C:\wamp\www\uzrasyti.php on line 15
baigta





antras scripta bandziau sitoki

?php
    $vardas=$_POST['vardas'];
    $kodas=$_POST['kodas'];
    $db = mysql_connect('localhost', 'root', '');
        mysql_select_db('db');
        mysql_query("INSERT INTO bandymas VALUES ('$vardas', '$kodas'");
        mysql_close($db);
        echo "baigta";

?>

sitame jokiu eroru bet jokiu duomenu negauna db

gal kas mato klaidu

dekui :)

Re: problemos jungiantis i db

O kokius duomenis turėjo gauti?

Re: problemos jungiantis i db

mysql_query("INSERT INTO bandymas VALUES ('$vardas', '$kodas'");

sitie is kito scripto atkeliauja ar sitoi vietoi kas netaip?

Re: problemos jungiantis i db

Tai aš tai nematau kas atkeliauja, gal nieko neatkeliauja (-;

Pabandyk pakeisti taip:

$q = "INSERT INTO bandymas VALUES ('" . mysql_real_escape_string($vardas) . "', '" . mysql_real_escape_string($kodas) . "')";
echo "Vykdoma užklausa: " . $q;
$res = mysql_query($q) or die(mysql_error());

Ir nereikės tada nieko spėliot.

Re: problemos jungiantis i db

dekui padejo :)