<table border="1px"> |
<tr> |
<td> |
<center><h3> MySQLi </h3></centr> |
<? |
|
/////// MySQLi /////// |
|
$start_array = explode(" ",microtime()); |
$start_time = $start_array['1'] + $start_array['0']; |
|
$mysqli = new mysqli('localhost', 'datebase', 'datebase', 'datebase'); |
$mysqli -> query("SET NAMES 'utf8'"); |
|
|
for($i=1;$i<501;$i++){ |
$result = $mysqli -> query('SELECT * FROM `anecdote` LIMIT 1') -> fetch_assoc(); |
echo $i.') '.$result['text_anecdot'].'<br /><br />'; |
} |
|
|
$end_time = microtime(); $end_array = explode(" ",$end_time); |
echo round((($end_array['1'] + $end_array['0']) - $start_time),4).'сек.<hr />'; |
?> |
</td> |
<td> |
<center><h3> MySQL </h3></centr> |
<? |
/////// MySQL /////// |
$start_array2 = explode(" ",microtime()); |
$start_time2 = $start_array2['1'] + $start_array2['0']; |
|
mysql_connect('localhost', 'datebase', 'datebase'); |
mysql_select_db('datebase'); mysql_query('SET NAMES utf8'); |
|
|
for($i=1;$i<501;$i++){ |
$result = mysql_fetch_assoc(mysql_query("SELECT * FROM `anecdote` LIMIT 1")); |
echo $i.') '.$result['text_anecdot'].'<br /><br />'; |
} |
|
$end_time2 = microtime(); $end_array2 = explode(" ",$end_time2); |
echo round((($end_array2['1'] + $end_array2['0']) - $start_time2),4).'сек.<hr />'; |
|
?> |
</td> |
<td> |
<center><h3> PDO </h3></centr> |
<? |
/////// PDO /////// |
$start_array3 = explode(" ",microtime()); |
$start_time3 = $start_array3['1'] + $start_array3['0']; |
|
$pdo = new PDO('mysql:host=localhost;dbname=datebase', 'datebase', 'datebase'); |
$pdo->query("SET NAMES 'utf8'"); |
|
for($i=1;$i<501;$i++){ |
$result = $pdo->query('SELECT * FROM `anecdote` LIMIT 1')->fetch(PDO::FETCH_ASSOC); |
echo $i.') '.$result['text_anecdot'].'<br /><br />'; |
} |
|
$end_time3 = microtime(); $end_array3 = explode(" ",$end_time3); |
echo round((($end_array3['1'] + $end_array3['0']) - $start_time3),4).'сек.<hr />'; |
|
?> |
</td> |
</tr> |
</table> |