Web development tutorial

Important WebAssist Announcement

Tutorial created by Nico, Nikolaos Beligiannis

Categories: MySQLi Server Behaviors

3 ratings | Sign in to rate this tutorial | View comments

Print tutorial
Share this tutorial

Sometimes when you apply the pagination server behaviors on a Mysqli query, for some reason refreshing the page leads to a query error.

You should make the changes bellow in order to make query run again.

FIRST
In the where clause change the
WHERE xxxxx = %s
to
WHERE xxxxx = ?

SECOND
You should change this
bindParam("int", ""
to
bindParam("i", ""

Thank you

Reviews and comments

Comments will be sent to the author of this tutorial and may not be answered immediately. For general help from WebAssist, please visit technical support.

3 ratings | Sign in to rate this tutorial

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Begin selling online quickly with Cafe Commerce.

Fix MySqli query on pagination apply

Build websites with a little help from your friends

Build websites from already-built web applications

Want your website pre-built and hosted?

Everything else!

U.S. 858.201.4911 | International +1.858.201.4911

We've earned your trust.

Connect with us.