Get Started with New Oracle Database 11g Features

Arup Nanda’s “Oracle Database 11g: Top New Features for DBAs and Developers” HowTo series is nearing completion, with new installments on Resiliency, SecureFiles, SQL Operations, and more. (more…)

stored procedure out parameter problem in php page using mysql (2 replies)

After the successfully connection with database

following is code

Code: ( php )

$TM = mysql_query("Call Accounts_GetAllData(@data)");

$TM2 = mysql_query(’SELECT @data’);

$TM_X = mysql_fetch_array($TM);

$TM_W = mysql_fetch_array($TM2);

print_r(TM_W);

I am not able to get out parameter(data). please response asap.

Thanks (more…)

php 5.0 and MYSQL 5.0 connection problem (1 reply)

php 5.0 and MYSQL 5.0 connection problem ?

There is a connection problem between php 5.12 and MYSQL 5.0. I had performed these steps,

1> Installation of Apache 2.2.8 MYSQL 5.0 & php 5.0 done successfully.

2>downloaded the php_5.2.0_mysqli_5.0.27-win32 for connection talking. Copied in to following directories "D:\Program Files\PHP\ext"

"C:\WINDOWS\system"

"C:\WINDOWS\"

3> Also added these lines to php.ini

extension_dir = "D:/Program Files/PHP/ext/"
(more…)

End Query with \G instead of ;

You can use \G instead of ; for tables with lots of fields.

mysql> SHOW STATUS LIKE ‘Qcache%’;
+————————-+———–+
| Variable_name | Value |
+————————-+———–+
| Qcache_queries_in_cache | 6990 |
| Qcache_inserts | 6990 |
| Qcache_hits | 3987 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 621 |
| Qcache_free_memory | 176329432 |
| Qcache_free_blocks | 1 (more…)

Generate a Table of Contents Using the DOM

It’s often useful for a long page to contain a table of contents, to make it easy for people to jump to the section they want to read. This script will do the work automatically, generating a table of contents using the to tags. (more…)