Source of: /manual/ro/function.mysql-ping.php
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$PARENTS = array();
include_once dirname(__FILE__) ."/toc/ref.mysql.inc";
$setup = array (
'home' =>
array (
0 => 'index.php',
1 => 'PHP Manual',
),
'head' =>
array (
0 => 'UTF-8',
1 => 'ro',
),
'this' =>
array (
0 => 'function.mysql-ping.php',
1 => 'mysql_ping',
),
'up' =>
array (
0 => 'ref.mysql.php',
1 => 'Funcții MySQL',
),
'prev' =>
array (
0 => 'function.mysql-pconnect.php',
1 => 'mysql_pconnect',
),
'next' =>
array (
0 => 'function.mysql-query.php',
1 => 'mysql_query',
),
'alternatives' =>
array (
),
);
$setup["toc"] = $TOC;
$setup["parents"] = $PARENTS;
manual_setup($setup);
manual_header();
?>
<div id="function.mysql-ping" class="refentry">
<div class="refnamediv">
<h1 class="refname">mysql_ping</h1>
<p class="verinfo">(PHP 4 >= 4.3.0, PHP 5)</p><p class="refpurpose"><span class="refname">mysql_ping</span> — <span class="dc-title">Ping a server connection or reconnect if there is no connection</span></p>
</div>
<div id="function.mysql-ping-refsynopsisdiv">
<div class="warning"><strong class="warning">Avertizare</strong>
<p class="para">
Această extensie este dezaprobată începând cu PHP 5.5.0 și va fi eliminată în
viitor. În locul ei trebuie utilizate extensiile <a href="book.mysqli.php" class="link">MySQLi</a>
sau <a href="ref.pdo-mysql.php" class="link">PDO_MySQL</a>. Vedeți de asemenea ghidul
<a href="mysqlinfo.api.choosing.php" class="link">MySQL: selectarea unei API</a> și
<a href="faq.databases.php#faq.databases.mysql.deprecated" class="link">FAQ asociat</a> pentru mai
multe informații. Alternative ale acestei funcții includ:</p>
<ul class="simplelist">
<li class="member"> <span class="function"><a href="mysqli.ping.php" class="function">mysqli_ping()</a></span></li>
</ul>
</div>
</div>
<div class="refsect1 description" id="refsect1-function.mysql-ping-description">
<h3 class="title">Descrierea</h3>
<div class="methodsynopsis dc-description">
<span class="type">bool</span> <span class="methodname"><strong>mysql_ping</strong></span>
([ <span class="methodparam"><span class="type">resource</span> <code class="parameter">$link_identifier</code><span class="initializer"> = NULL</span></span>
] )</div>
<p class="para rdfs-comment">
Checks whether or not the connection to
the server is working. If it has gone down, an automatic reconnection is
attempted. This function can be used by scripts that remain idle for a
long while, to check whether or not the server has closed the connection
and reconnect if necessary.
</p>
<blockquote class="note"><p><strong class="note">Notă</strong>:
<p class="para">
Automatic reconnection is disabled by default in versions of MySQL >= 5.0.3.
</p>
</p></blockquote>
</div>
<div class="refsect1 parameters" id="refsect1-function.mysql-ping-parameters">
<h3 class="title">Parametri</h3>
<p class="para">
<dl>
<dt>
<span class="term"><em><code class="parameter">link_identifier
</code></em></span><dd>
<p class="para">Conexiunea MySQL. Dacă identificatorul
legăturii nu este specificat, se presupune că este ultima legătură deschisă cu
ajutorul <span class="function"><a href="function.mysql-connect.php" class="function">mysql_connect()</a></span>. Dacă nu este găsită nici o astfel
de legătură, se va încerca crearea uneia prin apelul <span class="function"><strong>mysql_connect
()</strong></span> fără argumente. În caz că nici o conexiune nu este găsită sau
stabilită, se va genera o eroare de nivelul <strong><code>E_WARNING</code></strong>.
</p></dd>
</dt>
</dl>
</p>
</div>
<div class="refsect1 returnvalues" id="refsect1-function.mysql-ping-returnvalues">
<h3 class="title">Valorile întoarse</h3>
<p class="para">
Returns <strong><code>TRUE</code></strong> if the connection to the server MySQL server is working,
otherwise <strong><code>FALSE</code></strong>.
</p>
</div>
<div class="refsect1 examples" id="refsect1-function.mysql-ping-examples">
<h3 class="title">Exemple</h3>
<p class="para">
<div class="example" id="example-1661">
<p><strong>Example #1 A <span class="function"><strong>mysql_ping()</strong></span> example</strong></p>
<div class="example-contents">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB"><?php<br />set_time_limit</span><span style="color: #007700">(</span><span style="color: #0000BB">0</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">$conn </span><span style="color: #007700">= </span><span style="color: #0000BB">mysql_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">'localhost'</span><span style="color: #007700">, </span><span style="color: #DD0000">'mysqluser'</span><span style="color: #007700">, </span><span style="color: #DD0000">'mypass'</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$db </span><span style="color: #007700">= </span><span style="color: #0000BB">mysql_select_db</span><span style="color: #007700">(</span><span style="color: #DD0000">'mydb'</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/* Assuming this query will take a long time */<br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">mysql_query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql</span><span style="color: #007700">);<br />if (!</span><span style="color: #0000BB">$result</span><span style="color: #007700">) {<br /> echo </span><span style="color: #DD0000">'Query #1 failed, exiting.'</span><span style="color: #007700">;<br /> exit;<br />}<br /><br /></span><span style="color: #FF8000">/* Make sure the connection is still alive, if not, try to reconnect */<br /></span><span style="color: #007700">if (!</span><span style="color: #0000BB">mysql_ping</span><span style="color: #007700">(</span><span style="color: #0000BB">$conn</span><span style="color: #007700">)) {<br /> echo </span><span style="color: #DD0000">'Lost connection, exiting after query #1'</span><span style="color: #007700">;<br /> exit;<br />}<br /></span><span style="color: #0000BB">mysql_free_result</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/* So the connection is still alive, let's run another query */<br /></span><span style="color: #0000BB">$result2 </span><span style="color: #007700">= </span><span style="color: #0000BB">mysql_query</span><span style="color: #007700">(</span><span style="color: #0000BB">$sql2</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span>
</span>
</code></div>
</div>
</div>
</p>
</div>
<div class="refsect1 seealso" id="refsect1-function.mysql-ping-seealso">
<h3 class="title">Vedeți de asemenea</h3>
<p class="para">
<ul class="simplelist">
<li class="member"> <span class="function"><a href="function.mysql-thread-id.php" class="function" rel="rdfs-seeAlso">mysql_thread_id()</a> - Return the current thread ID</span></li>
<li class="member"> <span class="function"><a href="function.mysql-list-processes.php" class="function" rel="rdfs-seeAlso">mysql_list_processes()</a> - List MySQL processes</span></li>
</ul>
</p>
</div>
</div><?php manual_footer(); ?>
