Mysqli sample!

[thesnarkie]

<?
$mysqli = new mysqli("localhost", "", "", "");
$mysqli->query("SET NAMES utf8");
$mysqli->query("SET CHARACTER SET utf8");

$result = $mysqli->query("SELECT COUNT(a.id) AS idCount FROM account AS a WHERE a.username='freezer'");
$row = $result->fetch_array(MYSQLI_ASSOC);

$mysqli->close();
?>

 

Vārdu sakot, pēc baigo query izsaukšanas pašās koda beigās izsaucot close() daudz kas mainīsies? Nu servera resursi.. Un,kas notiek ja viņu neizsauc koda beigās?

Edited March 23, 2010 by thesnarkie

[thesnarkie]

index.php

<?
$mysqli = new mysqli($host, $username, $password, $database);
$mysqli->query("SET NAMES utf8");
$mysqli->query("SET CHARACTER SET utf8");

$result = $mysqli->query("SELECT COUNT(a.id) AS idCount FROM account AS a WHERE a.username='freezer'");
$row = $result->fetch_array();

include("super.php");

$mysqli->close();
?>

 

super.php

<?
$host = "localhost";
$username = "blala";
$password = "blala"; 
$database = "blala";
?>

 

Tas ir ok no drošības viedokļa, ka inklūdoju failu ar mysql detailiem? Tur neko nekā nevar izvilkt?

Edited March 23, 2010 by thesnarkie

[2easy]

to laikam sauc par securityfobiju

[Kemito]

to laikam sauc par securityfobiju

 

Fobija no drošības? hmm.. jauns paveids laikam būs izveidojies fobijai! :D

[Grey_Wolf]

close() var likt var arii nelikt ... Jo konekcija tiks prtraukta sha vai ta

Nee ja serveris ir normali nokonfigurets tad no taa include faila neko nevares izvilkt

[thesnarkie]

Ok, paldies.

Nū, mūsdienās drošība ir svarīga. :DD