<?php
/*
Cum sa te conectezi la o baza mysql de date folosind php
PHP are predefinita functia mysql_connect() pentru conectarea la o baza de date (http://php.net/manual/en/function.mysql-connect.php).

*/
define ('SERVER','localhost');
define ('USER','root');
define ('PASSWORD','');
define ('DATABASE','phpbb');
define ('TABEL','phpbb_users');
$msg=array();
//ne conectam la baza de date
$con=@mysql_connect(SERVER,USER,PASSWORD);
//daca conexiunea nu are loc
if(!$con)
{
    //oprim executia si afisam eroarea;
    die(mysql_error());
}

//conexiunea are loc deci:
//selectam baza de date (http://it2.php.net/manual/en/function.mysql-select-db.php)
$database=mysql_select_db(DATABASE);
//daca baza de date sa selectat
if(!$database)
    {
        die ('nu se poate selecta baza de date');
    
    }
$msg[]='Baza de date selectata este '.DATABASE;

// Pentru a executa un query SQL pe mysql se foloseste functia mysql_query() (http://it2.php.net/manual/en/function.mysql-query.php)
$int="SELECT * FROM ".TABEL;
//se face query
$rez=mysql_query($int);
//daca nu se poate executa query
if(!$rez)
{
    die(mysql_error());
}

//altfel
//folosim functia mysql_fetch_array() pentru a prelua datele din baza de date ca si a le returna ca si array;
        while($camp=mysql_fetch_array($rez))//http://it2.php.net/manual/en/function.mysql-fetch-array.php
            {
            $msg[]=$camp['username'];    
            }
        
foreach ($msg as $m)
{
    echo $m.'<br>';
}

/* returneaza
 *Baza de date selectata este phpbb
Anonymous
r3v
AdsBot [Google]
Alexa [Bot]
Alta Vista [Bot]
Ask Jeeves [Bot]
Baidu [Spider]
Bing [Bot]
Exabot [Bot]
FAST Enterprise [Crawler]
FAST WebCrawler [Crawler]
Francis [Bot]
Gigabot [Bot]
Google Adsense [Bot]
Google Desktop
Google Feedfetcher
Google [Bot]
Heise IT-Markt [Crawler]
Heritrix [Crawler]
IBM Research [Bot]
ICCrawler - ICjobs
ichiro [Crawler]
Majestic-12 [Bot]
Metager [Bot]
MSN NewsBlogs
MSN [Bot]
MSNbot Media
NG-Search [Bot]
Nutch [Bot]
Nutch/CVS [Bot]
OmniExplorer [Bot]
Online link [Validator]
psbot [Picsearch]
Seekport [Bot]
Sensis [Crawler]
SEO Crawler
Seoma [Crawler]
SEOSearch [Crawler]
Snappy [Bot]
Steeler [Crawler]
Synoo [Bot]
Telekom [Bot]
TurnitinBot [Bot]
Voyager [Bot]
W3 [Sitesearch]
W3C [Linkcheck]
W3C [Validator]
WiseNut [Bot]
YaCy [Bot]
Yahoo MMCrawler [Bot]
Yahoo Slurp [Bot]
Yahoo [Bot]
YahooSeeker [Bot]
 */
?>