[linux] mysql - restore

[Martin Hudec]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ahoj,

connect na usera si otestujes normalne spustenim

mysql -u apache -p
(nasledne zadas heslo)

co sa tyka php funkcie, pouzi toto skor:

mysql_connect("mysql_host", "mysql_user", "mysql_password")
   or die("Could not connect : " . mysql_error());
echo "Connected successfully";

mysql_select_db("my_database") or die("Could not select database");

cize ty nemas dostatocne definovanu mysql_connect();

cheers,
Martin

On Thu March 4 2004 15:33, michal_lackovic na sk.schneider-electric.com wrote:
> Som z toho zufaly
>
> mam v mysql vytvoreneho uzivatela apache na localhost ma vsetky prava na
> vstup do databaz
> a stale nic, uplne kasle na mna, neda mi ziaden vystup ,ziaden debug
> proste nic..len bielu obrazovku.
>
> na test pouzivam tento kod:
>
> pre>
>
> <h3>Press RELOAD to add a record to the MySQL database:</h3>
>
> <?
>
> //establish user connection
>
> mysql_connect("localhost");
> user = "apache";
> password = "";
>
> print mysql_error();
>
> //open up database
>
> mysql_create_db("referencie");
> print mysql_error();
>
> mysql_select_db("test");
> print mysql_error();
>
> //create table
>
> mysql_query("CREATE TABLE referencie (firstName VARCHAR(25), lastName
> VARCHAR(25))");
> print mysql_error();
>
> mysql_query ("INSERT INTO referencie (firstName, lastName) VALUES ('John',
> 'Tester')");
> print mysql_error();
>
> //display the information
>
> $result = mysql_query ("SELECT * FROM referencie");
>
> while($row = mysql_fetch_array($result))
>
> {
>
> print ("Added record: " . $row["firstName"]."
> ".$row["lastName"]."<br>\n");
>
> }
>
> //close user connection
>
> mysql_close();
>
> ?>
>
> </pre>
>
> miso
>
>
>

- -- 
:
:. kind regards
:..                      Martin Hudec
:.:
:.: =w= http://www.aeternal.net
:.: =m= +421.907.303393
:.: =@= corwin na aeternal.net
:.:
:.: "When you want something, all the universe 
:.:   conspires in helping you to achieve it."
:.:                   - The Alchemist (Paulo Coelho)
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)

iD8DBQFAR06KZYEZIv+rgggRAp2jAJ9uflzhQRfC+qgbMjwWvC16+kkbLACeIv+u
MvpZrivvw2ZaR9qX6oadYi0=
=7/xY
-----END PGP SIGNATURE-----