close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 or 2018 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

MySQLi - getting started

Thread began 6/25/2014 4:16 pm by gail.bergan407744 | Last modified 7/01/2014 11:04 am by gail.bergan407744 | 2335 views | 13 replies |

gail.bergan407744

MySQLi - getting started

I've purchased, downloaded and activated your MySQLi extension. I have a preexisting web site that used Dreamweaver's Server Behaviors, Bindings, etc. My question is, as I update my existing pages with your extension, it is best practices to delete my old server behaviors, recordsets, etc. so that there's not a lot of excess code in my pages? Thanks,

Gail

Sign in to reply to this post

Jason ByrnesWebAssist

Yes, remove the existing server behaviors, then replace them with the ones from the mySQLi extension.

Sign in to reply to this post

gail.bergan407744

Session Variables

In my older DW pages that have a membership profile recordset, I've duplicated the old rs with the new "_i" rs. In my old rs, it was filtered on "email = Session Variable MM_username". When I do a Test, however, regardless of whether I use a test default value of "-1" (which was what my old rs was set at) or "1", I get a result of No Data. What should be the default test value?

Sign in to reply to this post

Jason ByrnesWebAssist

"What should be the default test value?"

a value that exists in the database for that column.

where it is the MM_Username session, i would suspect an email address.

Sign in to reply to this post

gail.bergan407744

Duh! Of course! Now I feel stupid. Plugging in an email address calls up the correct record. Thanks for your help!

Sign in to reply to this post

Jason ByrnesWebAssist

No Worries.

Sign in to reply to this post

gail.bergan407744

Restrict Access to Page

I have many PHP pages with restricted access (members only or admins only). The previous DW behavior was fairly simple to set up: Restrict based on username and password, and if access denied, send them back to login.php. Your server behavior is more complicated to set up and even after reviewing the help file for this, I can't say I understand what to choose for Trigger and Authentication.Would the trigger be 'before page load'? and Authentication be what ... username? email?

Sign in to reply to this post

Jason ByrnesWebAssist

In most cases the trigger to use would be one of the form post options when working with a login.

Any Form Post
Curent page submit
or Button: Submit pressed.

On the find record tab, you would bind the email and password columns to the email and password form elements.

In the MySQLi server behaviors, you will need to set up a different login for each user level, and on the Find record Tab, enter the user level value

on the members page, apply the members restrict access, and on the admin pages, apply the admin restrict access.

Sign in to reply to this post

gail.bergan407744

I probably wasn't clear in my original description. This is not my login page, but the page they land on after a successful login. So there are no forms or fields on this page, it just links people to members-only pages. Does your reply above still apply?

Sign in to reply to this post

Jason ByrnesWebAssist

First you need to create the login, when you create the login using the MySQLi authenticate user behavior, you will give it a name.

in the restrict access behavior, use the before page load trigger, and select the login you created from the authentication menu.

Sign in to reply to this post
loading

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?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...