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.

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

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.

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

Chris

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. :)

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

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!!!

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

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!

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