PHP + SQL

<?PHP

$link = mysql_connect(servername,username,password, true/false, clietnflags); true/false -vai izveidot jauno savienojumu ar serveri; clietnflags: ssl un kompressija

?>

__________________________

<?PHP

$link = mysql_connect('localhost','root','');

?>

__________________________

mysql_query("SET NAMES 'utf8';",$link);

__________________________

<?PHP

$link = mysql_connect('localhost','root','');

if(!$link){

echo('Nevar savienoties ar datu bāžu serveri: '.mysql_error());

}

$db = mysql_select_db('data1',$link);

if(!$db){

echo('Nevar izvēlēties datu bāzi: '. mysql_error());

}

///mysql_query("",$link);

mysql_query("SET NAMES 'utf8';",$link);

echo (':)');

?>

_______________________________________________________________

<?PHP

$link = mysql_connect('localhost','root','') or echo('Nevar savienoties ar datu bāžu serveri: '. mysql_error());

$db = mysql_select_db('test',$link) or echo('Nevar izvēlēties datu bāzi: '. mysql_error());

mysql_query("SET NAMES 'utf8';",$link);

?>

_______________________________________________________________

<?PHP

$link = mysql_connect('localhost','root','');

if(!$link){

echo('Nevar savienoties ar datu bāžu serveri: '.mysql_error());

}

$db = mysql_select_db('data1',$link);

if(!$db){

echo('Nevar izvēlēties datu bāzi: '. mysql_error());

}

///mysql_query("",$link);

mysql_query("SET NAMES 'utf8';",$link);

$rezultats = mysql_query("SELECT * FROM `userlist`;",$link);

while($liinija = mysql_fetch_object($rezultats)){

echo $liinija->ID.' - '.$liinija->username.' - '.$liinija->email.'<br>';

}

echo (':)');

?>

_________________________________________________________________

<?PHP

$link = mysql_connect('localhost','root','');

if(!$link){

echo('Nevar savienoties ar datu bāžu serveri: '.mysql_error());

}

$db = mysql_select_db('data1',$link);

if(!$db){

echo('Nevar izvēlēties datu bāzi: '. mysql_error());

}

mysql_query("SET NAMES 'utf8';",$link);

function random_string($garums){

$buffer = '';

for($i=0;$i<$garums;$i++){

$rand = rand(97,122);

$buffer .= chr($rand);

}

return $buffer;

}

$sql_buffer = "INSERT INTO `userlist` (`user`,`email`,`pasw`) VALUES".PHP_EOL;

for($i=0;$i<30;$i++){

$user = random_string(rand(7,9));

$password = sha1( random_string(2) );

$email = random_string(5).'@gmail.com';

$sql_buffer .= "('$user','$email','$password')";

if($i<29){

$sql_buffer .= ','.PHP_EOL;

}else{

$sql_buffer .= ';';

}

}

echo $sql_buffer;

exit;

$rezultats = mysql_query("SELECT * FROM `userlist`;",$link);

while($liinija = mysql_fetch_object($rezultats)){

echo $liinija->ID.' - '.$liinija->username.' - '.$liinija->email.'<br>';

}

echo (':)');

?>

_________________________________________________________________

mysql_query('TRUNCATE TABLE `userlist`;');

_________________________________________________________________