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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Dreamweaver

Thread began 3/21/2013 10:26 am by koky462446740 | Last modified 3/29/2013 11:25 am by Jason Byrnes | 972 views | 11 replies |

koky462446740

Dreamweaver

I am new to dreamweaver cs6 and i am a student doing a project on website.

My website is like a searching system for books.

I am using microsoft access to create database. Is the right programme to do so?

I would like to ask how do i create a search system that is powered by my own database.

In layman terms, it is like when the users key in some keywords, it will return information from my database.

Sign in to reply to this post

Christopher WestCommunity Expert

Hello....When using Dreamweaver and WebAssist products they rely on PHP/MySQL
PHP - is the programming language
MySQL is the database system

You need to scrap Microsoft Access as thats for ASP programming language etc.

You need to first create a working environment for your project using dreamweaver and what is know as a WAMP stack (if Windows) or MAMP Stack (if Apple Mac)

They are easy to setup, just a little program you can get from the internet for free.
WAMPServer is the most popular
and XXAMP is also popular

en/

xampp.html

Then what you would do is create what is known as a LOCAL HOST using one of the above.

Then in Dreamweaver you would set up a local site

Then you would need to login to PHPMyAdmin (which is the MySQL databased installed by one of the 2 programs above) then create your database in the PHPMyAdmin environment.

Thats the summary - if you want more details then feel free to ask :)

Chris

Sign in to reply to this post

koky462446740

Hi Chris,

Thanks for your help.

Is it possible that i use IIS 8 web server?

I have downloaded mysql workbench and found it to be user-friendly.

I have tried your recommendation and downloaded wamp but i cant access phpmyadmin.

I really do need more details and I appreciate your help.

Sign in to reply to this post

Christopher WestCommunity Expert

Hi ok, im just having dinner. and will reply with more details :)

Chris

Sign in to reply to this post

koky462446740

Hi Chris,

Thanks for your help.

Just an update, I managed to install wamp then switched off my IIS 8, and successfully configured myphpadmin.

I created a database in myphpadmin.

Then I managed to set up local, remote, testing site in my dreamweaver and get a mysql connection to my database.

I would like to ask is it possible that I can create a search textfield that will return results from my database.

In layman terms, when i type in the title of a book, it will come out with a result in title, author, publisher, ISBN, price, available stock from the database and display it in another page (I am not sure if it should be html or php)

Right now I just created a blank php file with a default search textfield and search button.

I guess that I have progressed further. I am looking forward to your advice. :)

Sign in to reply to this post

Jason ByrnesWebAssist

The Dreamweaver online help documentation has a tutorial for creating search and results pages here:
WScbb6b82af5544594822510a94ae8d65-78b0a.html

Sign in to reply to this post

koky462446740

Hi,

I still got a question for search and result page.

Lets say I have two form objects (one is a search textfield and the other is a select list)

How do I integrate two of them in a same record set to be displayed in a master detail page list ?

Currently, i only have search textfield working (users can search by title, author, publisher) but I do not know how to add the other select list (a price list which users can select prices) into the same master detail page.

Moreover, I want to ask how do I create an error page to tell users what they search is not available and try again.

Furthermore, when I click the submit button without typing anything in the search bar, it shows all my results from my databases. How do I solve by asking the users to type something?

Thanks!!!

Sign in to reply to this post

Jason ByrnesWebAssist

to have more than one search parameter, you need to use the advanced recordset dialog box

in the tutorial i linked to, see the "Build an advanced results page" section

to show a message if the search returns no results, use the Show region behavior.

type the message, then select it, in the server behaviors table, click the plus button and select Show region -> Show If recordset is empty, select the recordset for your page.

to return no results for an empty search, set the default values for the parameters in the recordset to -1


This is all fairly basic dreamweaver functionality.

I recommend getting a dreamweaver book like the Foundation PHP Series by David Powers

Sign in to reply to this post

koky462446740

Hi,


I still cannot return no results if the default value is set to -1.

Is it because I used the wild cards in my sql? (for e.g., I used like and%)?

mysql_select_db($database_books, $books);
$query_Rssearch = sprintf("SELECT * FROM books WHERE books.Title like %s OR books.Author like %s OR books.Publisher like %s OR books.ISBN like %s", GetSQLValueString("%" . $colname_Rssearch . "%", "text"),GetSQLValueString("%" . $colname_Rssearch . "%", "text"),GetSQLValueString("%" . $colname_Rssearch . "%", "text"),GetSQLValueString("%" . $colname_Rssearch . "%", "text"));
$query_limit_Rssearch = sprintf("%s LIMIT %d, %d", $query_Rssearch, $startRow_Rssearch, $maxRows_Rssearch);
$Rssearch = mysql_query($query_limit_Rssearch, $books) or die(mysql_error());
$row_Rssearch = mysql_fetch_assoc($Rssearch);

Thanks!

Sign in to reply to this post

Jason ByrnesWebAssist

to help troubleshoot, send a link to your search page, and add the following code to write the SQL query to the page after the body tag on the results page:

php:
<?php  echo($query_limit_Rssearch); ?>
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...