It checks whether headers have been sent .
Example
<?php
if (!headers_sent()) {
header(“Location: http://www.phpcodez.com/”);
exit;
}
?>
Tag Archives: Functions
headers_list()
It returns a list of response headers sent
Example
<?php
setcookie("time",time());
header('Content-type: text/plain');
echo "<pre>";
print_r(headers_list());
?>
Output
<pre>Array ( [0] => X-Powered-By: PHP/5.3.3-1ubuntu9.10 [1] => Set-Cookie: time=1337938449 [2] => Content-type: text/plain )
header()
It sends a raw HTTP header to a client.
Example
<?php
header(‘Location: http://www.phpcodez.com/’);
?>
mysql_unbuffered_query()
It executes a query on a MySQL database and buffering the result
A. Return the first data faster
B. Does not return all data faster
C. Use less memory
Example
<?php
mysql_pconnect("localhost", "root", "phpcode") or die(mysql_error());
$db_selected = mysql_select_db("database_name");
echo mysql_result(mysql_unbuffered_query( "SELECT * FROM users"),1);
mysql_close();
?>
mysql_thread_id()
It returns the current thread ID
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”);
$tables = mysql_list_tables(“database_name”);
echo mysql_thread_id();
?>
Output
1097
mysql_tablename()
Its deprecated . It returns the table name of field
Example
<?php
mysql_connect(“localhost”, “root”, “phpcode”);
$tables = mysql_list_tables(“database_name”);
for ($i = 0; $i < mysql_num_rows($tables); $i++)
echo mysql_tablename($tables, $i), “<br />”;
?>
Output
Uusers
mysql_stat()
It the current system status of the MySQL server
Example
<?php
mysql_pconnect(“localhost”, “root”, “phpcode”) or die(mysql_error());
$db_selected = mysql_select_db(“database_name”);
echo mysql_stat();
mysql_close();
?>
Output
Uptime: 18520 Threads: 7 Questions: 3591 Slow queries: 2 Opens: 21411 Flush tables: 1 Open tables: 63 Queries per second avg: 0.193
mysql_set_charset()
It sets the client character set
Example
<?php
mysql_set_charset(charset,resource)
?>
mysql_select_db()
It select a MySQL database
MySQL Table – Users
+—-+——+
| id | name |
+—-+——+
| 1 | PHP |
| 2 | ASP |
| 3 | JSP |
| 4 | JS |
| 5 | AS |
+—-+——+
Example
<?php
mysql_pconnect(“localhost”, “root”, “phpcode”) or die(mysql_error());
mysql_select_db(“database_name”);
echo mysql_result(mysql_query( “SELECT * FROM users”),1);
mysql_close();
?>
Output
2
mysql_result()
It returns the value of a field in a recordset
MySQL Table – Users
+—-+——+
| id | name |
+—-+——+
| 1 | PHP |
| 2 | ASP |
| 3 | JSP |
| 4 | JS |
| 5 | AS |
+—-+——+
Example
<?php
mysql_pconnect(“localhost”, “root”, “phpcode”) or die(mysql_error());
$db_selected = mysql_select_db(“database_name”);
echo mysql_result(mysql_query( “SELECT * FROM users”),1);
mysql_close();
?>
Output
2