shaan1974

You could try also EASYPhp, it’s work well

Shaan

Simple example :

global $wpdb; 

                    $sql="SELECT * FROM my_table";

                    $posts = $wpdb->get_results($sql);

                    print("<ul>");
                    foreach ($posts as $post)
                    {
                        print('<li>'.$post->FIELD1.'|'.$post->FIELD2.'<br/>');
                         print('</li>');
                    }
                    print("</ul>");

I hope that could help you

Shaan

Try this with in firebug ( javascript part, watch )

“$.fn.jquery”
if you have nothing returned try
“jQuery.fn.jquery”
If with this is ok, it’s means that an other javascript framework like “mootools” is maybe already set with the “$” ( maybe for an other plugin”

So in the jquery plugin that you want to use, you need to replace the “$” command with “jQuery”.

Cya
Shaan

After 4 month here the solution :

Search for : ( file wd-db.php )

function query( $query ) {
		if ( ! $this->ready )
			return false;

		// some queries are made before the plugins have been loaded, and thus cannot be filtered with this method
		if ( function_exists( 'apply_filters' ) )
			$query = apply_filters( 'query', $query );'

and replace with :

function query( $query ) {
		if ( ! $this->ready )
			return false;

    if ( strpos($query, "CALL") === false )
    {
          $this->dbh = mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, true );
          $this->set_charset( $this->dbh );
          $this->ready = true;
          $this->select( $this->dbname, $this->dbh );
    }
    else
    {
          $this->dbh = mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, false,65536 );
          $this->set_charset( $this->dbh );
          $this->ready = true;
          $this->select( $this->dbname, $this->dbh );
    }

		// some queries are made before the plugins have been loaded, and thus cannot be filtered with this method
		if ( function_exists( 'apply_filters' ) )
			$query = apply_filters( 'query', $query );

Now you should be able to run stored procedures.

By the way this code is like Mac Gyver tips ??

Maybe the WordPress team could set it in the next release ??

Shaan

After 4 month here the solution :

Search for : ( file wd-db.php )

function query( $query ) {
		if ( ! $this->ready )
			return false;

		// some queries are made before the plugins have been loaded, and thus cannot be filtered with this method
		if ( function_exists( 'apply_filters' ) )
			$query = apply_filters( 'query', $query );'

and replace with :

function query( $query ) {
		if ( ! $this->ready )
			return false;

    if ( strpos($query, "CALL") === false )
    {
          $this->dbh = mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, true );
          $this->set_charset( $this->dbh );
          $this->ready = true;
          $this->select( $this->dbname, $this->dbh );
    }
    else
    {
          $this->dbh = mysql_connect( $this->dbhost, $this->dbuser, $this->dbpassword, false,65536 );
          $this->set_charset( $this->dbh );
          $this->ready = true;
          $this->select( $this->dbname, $this->dbh );
    }

		// some queries are made before the plugins have been loaded, and thus cannot be filtered with this method
		if ( function_exists( 'apply_filters' ) )
			$query = apply_filters( 'query', $query );

Now you should be able to run stored procedures.

By the way this code is like Mac Gyver tips ??

Maybe the WordPress team could set it in the next release ??

Shaan

Hello, i’v found a start of solution, just take a look on my post.

Cya
Shaan